| 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 | BELZEILE | Billing line item for billing documents | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | BELZEILE | Allow NULL? |
| 4 | CSNO | Sequence number of schema step during billing | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | CSNO | Allow NULL? |
| 5 | BELZART | Line Item Type | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TE835 | BELZART | Allow NULL? |
| 6 | ABSLKZ | Billing Line Item for Budget Billing Amount Determination | char | 1 | 0 | CHAR | (N' ') | Yes | | ABSLKZ | Allow NULL? |
| 7 | DIFFKZ | Indicator: difference line item for discount statistics | char | 1 | 0 | CHAR | (N' ') | Yes | | DIFFKZ | Allow NULL? |
| 8 | BUCHREL | Billing Line Item Relevant to Posting | char | 1 | 0 | CHAR | (N' ') | Yes | | BUCHREL | Allow NULL? |
| 9 | MENGESTREL | Quantity (billed value) is statistically relevant | char | 1 | 0 | CHAR | (N' ') | Yes | | MENGESTREL | Allow NULL? |
| 10 | BETRSTREL | Amount of billing line item is statistically relevant | char | 1 | 0 | CHAR | (N' ') | Yes | | BETRSTREL | Allow NULL? |
| 11 | STGRQNT | Quantity statistics group | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | STGRQNT | Allow NULL? |
| 12 | STGRAMT | Amount statistics group | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | STGRAMT | Allow NULL? |
| 13 | PRINTREL | Billing Line Is Print-Relevant | char | 1 | 0 | CHAR | (N' ') | Yes | | PRINTREL | Allow NULL? |
| 14 | AKLASSE | Billing class | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | AKLASSE | Allow NULL? |
| 15 | BRANCHE | Industry | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TB038A | BU_IND_SECTOR | Allow NULL? |
| 16 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TFKTVO | TVORG_KK | Allow NULL? |
| 17 | GEGEN_TVORG | Offsetting trans. for sub-transaction of billing line item | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TFKTVO | GEGEN_TVORG | Allow NULL? |
| 18 | TAX_TVORG | Subtransaction for tax determination for BB line items | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | TAX_TVORG | Allow NULL? |
| 19 | LINESORT | Presorting of billing line items in billing schema | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TE530 | LINESORT | Allow NULL? |
| 20 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ABZEITSCH | Allow NULL? |
| 21 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BISZEITSCH | Allow NULL? |
| 22 | TIMTYPZA | Time category (days or months) for billing line item | char | 1 | 0 | CHAR | (N' ') | Yes | | TIMTYPZA | Allow NULL? |
| 23 | SCHEMANR | Number of the billing schema | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SCHEMANR | Allow NULL? |
| 24 | SNO | Sequence number of schema step in billing schema | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | SNO | Allow NULL? |
| 25 | PROGRAMM | Variant program | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | E_PROGRAMM | Allow NULL? |
| 26 | MASSBILL | Unit of measurement for billing | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | E_MASSBILL | Allow NULL? |
| 27 | SAISON | Season | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SAISON | Allow NULL? |
| 28 | TIMBASIS | Time Basis | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | TIMBASIS | Allow NULL? |
| 29 | TIMTYP | Time category (days or months) | char | 1 | 0 | CHAR | (N' ') | Yes | | TIMTYP | Allow NULL? |
| 30 | FRAN_TYPE | Franchise Fee Category | char | 1 | 0 | CHAR | (N' ') | Yes | | FRAN_TYPE | Allow NULL? |
| 31 | KONZIGR | Franchise fee group | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TE241 | KONZIGR | Allow NULL? |
| 32 | TARIFTYP | Rate category | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | TARIFTYP | Allow NULL? |
| 33 | TARIFNR | Rate key | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | TARIFNR | Allow NULL? |
| 34 | KONDIGR | Rate fact group | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TE067 | KONDIGR | Allow NULL? |
| 35 | STTARIF | Statistical rate | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | STTARIF | Allow NULL? |
| 36 | GEWKEY | Weighting key | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TE266 | GEWKEY | Allow NULL? |
| 37 | WDHFAKT | Repetition factor for reference values | int | 10 | 0 | INT4 | ((0)) | Yes | | WDHFAKT | Allow NULL? |
| 38 | TEMP_AREA | Temperature area | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TE307 | TEMP_AREA | Allow NULL? |
| 39 | DRCKSTUF | Gas pressure level | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | DRCKSTUF | Allow NULL? |
| 40 | ABGGRND1 | Reason for proration | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TE661 | ABGGRND | Allow NULL? |
| 41 | ABGGRND2 | Reason for proration | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TE661 | ABGGRND | Allow NULL? |
| 42 | ABGGRND3 | Reason for proration | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TE661 | ABGGRND | Allow NULL? |
| 43 | ABGGRND4 | Reason for proration | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TE661 | ABGGRND | Allow NULL? |
| 44 | ABGGRND5 | Reason for proration | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TE661 | ABGGRND | Allow NULL? |
| 45 | ABGGRND6 | Reason for proration | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TE661 | ABGGRND | Allow NULL? |
| 46 | ABGGRND7 | Reason for proration | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TE661 | ABGGRND | Allow NULL? |
| 47 | ABGGRND8 | Reason for proration | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TE661 | ABGGRND | Allow NULL? |
| 48 | ABGGRND9 | Reason for proration | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TE661 | ABGGRND | Allow NULL? |
| 49 | ABGGRND10 | Reason for proration | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TE661 | ABGGRND | Allow NULL? |
| 50 | EIN01 | Input operand | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | EINOPERAND | Allow NULL? |
| 51 | EIN02 | Input operand | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | EINOPERAND | Allow NULL? |
| 52 | EIN03 | Input operand | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | EINOPERAND | Allow NULL? |
| 53 | EIN04 | Input operand | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | EINOPERAND | Allow NULL? |
| 54 | AUS01 | Output operand | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | AUSOPERAND | Allow NULL? |
| 55 | AUS02 | Output operand | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | AUSOPERAND | Allow NULL? |
| 56 | MASS1 | Unit of Measurement | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | E_MASS | Allow NULL? |
| 57 | MASS2 | Unit of Measurement | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | E_MASS | Allow NULL? |
| 58 | MASS3 | Unit of Measurement | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | E_MASS | Allow NULL? |
| 59 | MASS4 | Unit of Measurement | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | E_MASS | Allow NULL? |
| 60 | DATUM1 | Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATUM | Allow NULL? |
| 61 | DATUM2 | Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATUM | Allow NULL? |
| 62 | RABZUS | Discount key | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | RABZUS | Allow NULL? |
| 63 | BACKCANC01 | Indicator: reverse backbilling | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BACKCANC01 | Allow NULL? |
| 64 | BACKCANC02 | Indicator: reverse backbilling | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BACKCANC02 | Allow NULL? |
| 65 | BACKCANC03 | Indicator: reverse backbilling | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BACKCANC03 | Allow NULL? |
| 66 | BACKCANC04 | Indicator: reverse backbilling | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BACKCANC04 | Allow NULL? |
| 67 | BACKCANC05 | Indicator: reverse backbilling | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BACKCANC05 | Allow NULL? |
| 68 | BACKCANC | Indicator: Reverse Backbilling | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BACKCANC | Allow NULL? |
| 69 | BACKEXEC | Indicator: allocate backbilling | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BACKEXEC | Allow NULL? |
| 70 | BACKDOCNO | Number of a billing document | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | BACKDOCNO | Allow NULL? |
| 71 | BACKDOCLINE | Billing line item for billing documents | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | BACKDOCLINE | Allow NULL? |
| 72 | DYNCANC01 | Schema steps for reversal in dynamic period control 1 | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | DYNCANC01 | Allow NULL? |
| 73 | DYNCANC02 | Reversal indicator, dynamic period control 2 | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | DYNCANC02 | Allow NULL? |
| 74 | DYNCANC03 | Reversal indicator, dynamic period control 3 | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | DYNCANC03 | Allow NULL? |
| 75 | DYNCANC04 | Reversal Indicator, Dynamic Period Control 4 | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | DYNCANC04 | Allow NULL? |
| 76 | DYNCANC05 | Reversal indicator, dynamic period control 5 | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | DYNCANC05 | Allow NULL? |
| 77 | DYNCANC | Indicator: Reverse Backbilling | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | DYNCANC | Allow NULL? |
| 78 | DYNEXEC | Indicator: Allocate Backbilling | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | DYNEXEC | Allow NULL? |
| 79 | LRATESTEP | Logical Number of Rate Step | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | LRATESTEP | Allow NULL? |
| 80 | PEB | Indicator: billing line item relates to period-end billing | char | 1 | 0 | CHAR | (N' ') | Yes | | PEB | Allow NULL? |
| 81 | OPLFDNR | Consecutive number of an operand | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | OPLFDNR | Allow NULL? |
| 82 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | STAFO | Allow NULL? |
| 83 | ARTMENGE | Classification of billed quantity for statistics | char | 1 | 0 | CHAR | (N' ') | Yes | | ARTMENGE | Allow NULL? |
| 84 | STATTART | Rate type for statistical analysis | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TE069 | STATTART | Allow NULL? |
| 85 | TIMECONTRL | Period control | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | TIMECONTRL | Allow NULL? |
| 86 | TCNUMTOR | Numerator of the time portion in a time slice | decimal | 8 | 4 | DEC | ((0)) | Yes | | TCNUMTOR | |
| 87 | TCDENOMTOR | Denominator of the time portion in a time slice | decimal | 8 | 4 | DEC | ((0)) | Yes | | TCDENOMTOR | |
| 88 | TIMTYPQUOT | Time category of meter for time portion of a time slice | char | 1 | 0 | CHAR | (N' ') | Yes | | TIMTYPQUOT | Allow NULL? |
| 89 | AKTIV | Meter reading active | char | 1 | 0 | CHAR | (N' ') | Yes | | E_AKTIV | Allow NULL? |
| 90 | KONZVER | Franchise contract | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KONZVER | Allow NULL? |
| 91 | PERTYP | Category of the internal billing period | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BILLPERTYP | Allow NULL? |
| 92 | ERCHV_ANCHOR | Anchor Line for DBERCHV Entry | char | 1 | 0 | CHAR | (N' ') | Yes | | ERCHV_ANCHOR | Allow NULL? |
| 93 | OUCONTRACT | Master Agreement for Individual Contract | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | OUCONTRACT | Allow NULL? |
| 94 | V_ABRMENGE | Places before decimal point in billing quantity | decimal | 17 | 0 | DEC | ((0)) | Yes | | V_ABRMENGE | |
| 95 | N_ABRMENGE | Places after decimal point in billing quantity | decimal | 14 | 14 | DEC | ((0)) | Yes | | N_ABRMENGE | |
| 96 | V_ZAHL1 | Pre-decimal places in a number | decimal | 17 | 0 | DEC | ((0)) | Yes | | V_ZAHL | |
| 97 | N_ZAHL1 | Decimal places in a number | decimal | 14 | 14 | DEC | ((0)) | Yes | | N_ZAHL | |
| 98 | V_ZAHL2 | Pre-decimal places in a number | decimal | 17 | 0 | DEC | ((0)) | Yes | | V_ZAHL | |
| 99 | N_ZAHL2 | Decimal places in a number | decimal | 14 | 14 | DEC | ((0)) | Yes | | N_ZAHL | |
| 100 | V_ZAHL3 | Pre-decimal places in a number | decimal | 17 | 0 | DEC | ((0)) | Yes | | V_ZAHL | |
| 101 | N_ZAHL3 | Decimal places in a number | decimal | 14 | 14 | DEC | ((0)) | Yes | | N_ZAHL | |
| 102 | V_ZAHL4 | Pre-decimal places in a number | decimal | 17 | 0 | DEC | ((0)) | Yes | | V_ZAHL | |
| 103 | N_ZAHL4 | Decimal places in a number | decimal | 14 | 14 | DEC | ((0)) | Yes | | N_ZAHL | |
| 104 | V_ZEITANT | Predecimal place of a time portion | decimal | 17 | 0 | DEC | ((0)) | Yes | | V_ZEITANT | |
| 105 | N_ZEITANT | Decimal places of a time portion | decimal | 14 | 14 | DEC | ((0)) | Yes | | N_ZEITANT | |
