| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | ANLAGE | Installation | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | ABRDATS | Scheduled Billing Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 4 | ABRVORG | Billing Transaction | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | SPARTE | Division | nvarchar | 2 | 0 | | | | Allow NULL? |
| 7 | PORTION | Portion | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | ABRVORG2 | Billing Transaction | nvarchar | 2 | 0 | | | | Allow NULL? |
| 9 | TRIGSTAT | Status of Billing Order | char | 1 | 0 | | | | Allow NULL? |
| 10 | ABLEINH | Meter reading unit | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | ADATSOLL | Scheduled meter reading date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | ABRDATSU | Scheduled billing date for suppressed billing order | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | ABRVORGU | Billing Transaction for a Suppressed Billing Order | nvarchar | 2 | 0 | | | | Allow NULL? |
| 14 | BEGEND | Start of period-end billing period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | SC_BELNR | Number of billing document in adjustment reversal | nvarchar | 12 | 0 | | | | Allow NULL? |
| 16 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 18 | AEDAT | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 20 | ENDPRIO | Priority of Period-End Billing | char | 1 | 0 | | | | Allow NULL? |
| 21 | ABSCHLPAN | Adjust budget billing plan | char | 1 | 0 | | | | Allow NULL? |
| 22 | ZUORDDAT | Allocation date for billing | nvarchar | 8 | 0 | | | | Allow NULL? |
| 23 | MEM_OPBEL | Reversed invoicing document no. for new billing/invoicing | nvarchar | 12 | 0 | | | | Allow NULL? |
| 24 | MEM_BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 25 | ADATSOLLU | Scheduled MR date of suppressed meter reading order | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | ESTINBILL | Meter Reading Results are Estimated in Billing | nvarchar | 2 | 0 | | | | Allow NULL? |
| 27 | ESTINBILLU | ESTINBILL of a Suppressed Billing Order | nvarchar | 2 | 0 | | | | Allow NULL? |
| 28 | ESTINBILL_SAV | Original Value from ESTINBILL | nvarchar | 2 | 0 | | | | Allow NULL? |
| 29 | ESTINBILL_USAV | ESTINBILL_SAV of a Suppressed Billing Order | nvarchar | 2 | 0 | | | | Allow NULL? |
| 30 | OSB_GROUP | On-Site Billing Group | nvarchar | 3 | 0 | | | | Allow NULL? |
| 31 | MAINDOCNO | Billing Document Number of Primary Installation | nvarchar | 12 | 0 | | | | Allow NULL? |
| 32 | WAIT_BI | Billing Sequence Control | nvarchar | 2 | 0 | | | | Allow NULL? |
| 33 | VKONTO | Contract Account Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 34 | MDUSREQUESTID | MDUS Request ID | nvarchar | 22 | 0 | | | | Allow NULL? |
| 35 | MDUSRQSTAT | MDUS Status of Billing Order | nvarchar | 2 | 0 | | | | Allow NULL? |