| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | KOKRS | Controlling Area | nvarchar | 4 | 0 | CHAR | (N' ') | No | TKA01 | KOKRS | Allow NULL? |
| 3 | VERSA | Results Analysis Version | nvarchar | 3 | 0 | CHAR | (N' ') | No | TKKAP | VERSN_ABGR | Allow NULL? |
| 4 | ABGSL | Results Analysis Key | nvarchar | 6 | 0 | CHAR | (N' ') | No | TKKAA | ABGR_SCHL | Allow NULL? |
| 5 | ZLNID | Line ID | nvarchar | 3 | 0 | CHAR | (N' ') | No | TKKAX | DZEILEN_ID | Allow NULL? |
| 6 | KATEG | Category | char | 1 | 0 | CHAR | (N' ') | No | | KATEGORIE | Allow NULL? |
| 7 | KBSTB | Cost Element for Capitalized Costs + WIP (Creation/Balance) | nvarchar | 10 | 0 | CHAR | (N' ') | No | | KST_BST_BI | Allow NULL? |
| 8 | KBSTV | Cost Element for Capitalized Costs and WIP (Usage) | nvarchar | 10 | 0 | CHAR | (N' ') | No | | KST_BST_VB | Allow NULL? |
| 9 | KRUEB | Cost Element for Reserves (Creation/Balance) | nvarchar | 10 | 0 | CHAR | (N' ') | No | | KST_RUE_BI | Allow NULL? |
| 10 | KRUEV | Cost Element for Reserves (Usage) | nvarchar | 10 | 0 | CHAR | (N' ') | No | | KST_RUE_VB | Allow NULL? |
| 11 | KKDUS | Cost Element for Cost of Sales / Revenues | nvarchar | 10 | 0 | CHAR | (N' ') | No | | KST_KDU | Allow NULL? |
| 12 | KZIFR | Reserves Apportionment Number | decimal | 5 | 2 | DEC | ((0)) | No | | KENNZIFFER | |
| 13 | KZIFB | Capitalized Costs Apportionment Number | decimal | 5 | 2 | DEC | ((0)) | No | | KENNZIFFEB | |
| 14 | EVFLD | Field names for progress analysis values (PS) | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | EV_FELD | Allow NULL? |
| 15 | ZLNI1 | Line ID | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | DZEILEN_ID | Allow NULL? |
| 16 | ZLNI2 | Line ID | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | DZEILEN_ID | Allow NULL? |
| 17 | ZLNI3 | Line ID | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | DZEILEN_ID | Allow NULL? |
| 18 | RFLG1 | Reserved for SAP Development | char | 1 | 0 | CHAR | (N' ') | Yes | | RESERV_FLG | Allow NULL? |
| 19 | RFLG2 | Reserved for SAP Development | char | 1 | 0 | CHAR | (N' ') | Yes | | RESERV_FLG | Allow NULL? |
| 20 | RFLG3 | Reserved for SAP Development | char | 1 | 0 | CHAR | (N' ') | Yes | | RESERV_FLG | Allow NULL? |
| 21 | MEINH | Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | CO_MEINH | Allow NULL? |