| 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 | * | MANDT | Allow NULL? |
| 2 | BELNR | Number of a billing document | nvarchar | 12 | 0 | CHAR | (N' ') | No | | E_BELNR | Allow NULL? |
| 3 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | BUKRS | Allow NULL? |
| 4 | SPARTE | Division | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | SPARTE | Allow NULL? |
| 5 | GPARTNER | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BU_PARTNER | Allow NULL? |
| 6 | VKONT | Contract Account Number | nvarchar | 12 | 0 | CHAR | (N' ') | No | * | VKONT_KK | Allow NULL? |
| 7 | VERTRAG | Contract | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | VERTRAG | Allow NULL? |
| 8 | BEGABRPE | Start of billing period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BEGABRPE | Allow NULL? |
| 9 | ENDABRPE | End of billing period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ENDABRPE | Allow NULL? |
| 10 | STORNODAT | Reversal date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | STORNODAT | Allow NULL? |
| 11 | ABRVORG | Billing Transaction | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ABRVORG | Allow NULL? |
| 12 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | HVORG_KK | Allow NULL? |
| 13 | KOFIZ | Account determination ID for IS-U contracts | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | E_KOFIZ | Allow NULL? |
| 14 | SIMULATION | Indicator: billing simulation | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | SIMULATION | Allow NULL? |
| 15 | BERGRUND | Reason for credit memo/backbilling | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BERGRUND | Allow NULL? |
| 16 | BEGNACH | Start of backbilling period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BEGNACH | Allow NULL? |
| 17 | TXJCD | Tax Jurisdiction | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | TXJCD | Allow NULL? |
| 18 | KONZVER | Franchise contract | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KONZVER | Allow NULL? |
| 19 | ABRVORG2 | Billing Transaction that Triggered Period-End Billing | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ABRVORG2 | Allow NULL? |
| 20 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 21 | AEDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 22 | BEGRU | Authorization Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | BEGRU | Allow NULL? |
| 23 | BACKBI | Type of backbilling | char | 1 | 0 | CHAR | (N' ') | Yes | | BACKBI | Allow NULL? |
| 24 | PERENDBI | Type of period-end billing | char | 1 | 0 | CHAR | (N' ') | Yes | | PERENDBI | Allow NULL? |
| 25 | BEGEND | Start of period-end billing period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BEGEND | Allow NULL? |
| 26 | ENDOFBB | Indicator: end of backbilling period | char | 1 | 0 | CHAR | (N' ') | Yes | | ENDOFBB | Allow NULL? |
| 27 | ENDOFPEB | Indicator: end of period-end billing period | char | 1 | 0 | CHAR | (N' ') | Yes | | ENDOFPEB | Allow NULL? |
| 28 | SC_BELNR_H | Number of billing document in adjustment reversal | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SC_BELNR | Allow NULL? |
| 29 | SC_BELNR_N | New billing document number in adjustment reversal | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SC_BEL_N | Allow NULL? |
| 30 | ZUORDDAA | Allocation date for billing | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | E_ZUORDDATABR | Allow NULL? |
| 31 | BILLINGRUNNO | Number of Billing Run | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | BILLINGRUNNO | Allow NULL? |
| 32 | SIMRUNID | Simulation Period ID | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | SIMRUNID | Allow NULL? |
| 33 | KTOKLASSE | Account class | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | KTOKLASSE | Allow NULL? |
| 34 | ORIGDOC | Origin of Billing Document | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ORIGDOC | Allow NULL? |
| 35 | MEM_OPBEL | Reversed invoicing document no. for new billing/invoicing | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | MEM_OPBEL | Allow NULL? |
| 36 | MEM_BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | MEM_BUDAT | Allow NULL? |
| 37 | EXBILLDOCNO | External document number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | EXBILLDOCNO | Allow NULL? |
| 38 | BCREASON | Reason for Reversal | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | BCREASON | Allow NULL? |
| 39 | NINVOICE | Billing document without invoicing | char | 1 | 0 | CHAR | (N' ') | Yes | | NINVOICE | Allow NULL? |
| 40 | DAUBUCH | Standing order | char | 1 | 0 | CHAR | (N' ') | Yes | | DAUBUCH | Allow NULL? |
| 41 | BILLING_PERIOD | Billing Key Date (For Example January 2002) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | E_BILLING_PERIOD | Allow NULL? |
