| 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 | BELNR | Number of a settlement document | nvarchar | 10 | 0 | CHAR | (N' ') | No | | AA_BELNR | Allow NULL? |
| 3 | KOKRS | Controlling Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TKA01 | KOKRS | Allow NULL? |
| 4 | BUDAT | Posting Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CO_BUDAT | Allow NULL? |
| 5 | BZDAT | Asset value date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BZDAT | Allow NULL? |
| 6 | CPUDT | Date Document Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CO_CPUDT | Allow NULL? |
| 7 | WSDAT | Value Date for Currency Translation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | WSDAT | Allow NULL? |
| 8 | KURST | Exchange Rate Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TCURV | KURST | Allow NULL? |
| 9 | GJAHR | Settlement Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ABR_GJAHR | Allow NULL? |
| 10 | PERIO | Settlement Period | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ABR_PERIO | Allow NULL? |
| 11 | PERBZ | Settlement type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | PERBZ_LD | Allow NULL? |
| 12 | OBJNR | Object number | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | ONR00 | J_OBJNR | Allow NULL? |
| 13 | STFLG | Identifier for reversal document | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_STFLG | Allow NULL? |
| 14 | STBEL | Document Number of Reversed Document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | AUAK | AA_STBEL | Allow NULL? |
| 15 | STOKZ | Indicator: Document Has Been Reversed | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_STOKZ | Allow NULL? |
| 16 | ABSCH | Allocation Structure for Settlement/Assessment | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TKB5A | BRGABSCH | Allow NULL? |
| 17 | URSCH | Source structure | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TKB4A | URSCH | Allow NULL? |
| 18 | GMENG | Total quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | BRGGMENG | |
| 19 | GEINH | Unit of measure of total quantity | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | GEINH | Allow NULL? |
| 20 | ANALG | Identifier for "proportional settlement" | char | 1 | 0 | CHAR | (N' ') | Yes | | ANALG | Allow NULL? |
| 21 | ABRNR | Sequential settlement number | smallint | 5 | 0 | INT2 | ((0)) | Yes | | ABRNR | |
| 22 | KSTAR | Settlement cost element for receiver | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | CSKA | ABRKSTAR | Allow NULL? |
| 23 | ERSCH | PA transfer structure | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TKB9A | ERSCH | Allow NULL? |
| 24 | SAPRL | SAP Release | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | SAPRL | Allow NULL? |
| 25 | AWSYS | Logical System | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TBDLS | LOGSYSTEM | Allow NULL? |
| 26 | CO_VAART | CO Settlement: Processing type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | CO_VAART | Allow NULL? |
| 27 | BUPERIO | Posting period | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | COBU_PERIO | Allow NULL? |
| 28 | BUGJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | GJAHR | Allow NULL? |
| 29 | TIMESTMP | Time created (Greenwich Meantime) | decimal | 16 | 0 | DEC | ((0)) | Yes | | RKE_HZSTMP | |
| 30 | PERIO_F | From Period | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | CO_PERAB | Allow NULL? |
| 31 | PERIO_T | To period | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | CO_PERBI | Allow NULL? |
| 32 | VERSN | Version | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | VERSN | Allow NULL? |
| 33 | WRTTP | Value Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | CO_WRTTP | Allow NULL? |
| 34 | BLDAT | Document Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CO_BLDAT | Allow NULL? |
