SAP ABAP Table DBERCHZ1 (Individual line items)
Hierarchy
☛
IS-UT (Software Component) SAP Utilities/Telecommunication
⤷
IS-U-BI (Application Component) Contract Billing
⤷
EE20 (Package) IS-U: Billing
⤷
⤷
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | DBERCHZ1 |
|
| Short Description | Individual line items |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | A | Application Table (Master- and Transaction Data) |
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
| |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 | |
MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
| 2 | |
E_BELNR | E_BELNR | CHAR | 12 | 0 | Number of a billing document | ||
| 3 | |
BELZEILE | LFDNR6 | NUMC | 6 | 0 | Billing line item for billing documents | ||
| 4 | |
0 | 0 | Substructure of document line items: Always filled data | |||||
| 5 | |
CSNO | LFDSCHEM | NUMC | 6 | 0 | Sequence number of schema step during billing | ||
| 6 | |
BELZART | BELZART | CHAR | 6 | 0 | Line Item Type | TE835 | |
| 7 | |
ABSLKZ | KENNZX | CHAR | 1 | 0 | Billing Line Item for Budget Billing Amount Determination | ||
| 8 | |
DIFFKZ | KENNZX | CHAR | 1 | 0 | Indicator: difference line item for discount statistics | ||
| 9 | |
BUCHREL | KENNZX | CHAR | 1 | 0 | Billing Line Item Relevant to Posting | ||
| 10 | |
MENGESTREL | MENGREL | CHAR | 1 | 0 | Quantity (billed value) is statistically relevant | ||
| 11 | |
BETRSTREL | KENNZX | CHAR | 1 | 0 | Amount of billing line item is statistically relevant | ||
| 12 | |
STGRQNT | STGRQNT | CHAR | 6 | 0 | Quantity statistics group | * | |
| 13 | |
STGRAMT | STGRAMT | CHAR | 6 | 0 | Amount statistics group | * | |
| 14 | |
PRINTREL | KENNZX | CHAR | 1 | 0 | Billing Line Is Print-Relevant | ||
| 15 | |
AKLASSE | AKLASSE | CHAR | 4 | 0 | Billing class | * | |
| 16 | |
BU_IND_SECTOR | BU_INDSECTOR | CHAR | 10 | 0 | Industry | TB038A | |
| 17 | |
TVORG_KK | TVORG_KK | CHAR | 4 | 0 | Subtransaction for Document Item | TFKTVO | |
| 18 | |
GEGEN_TVORG | TVORG_KK | CHAR | 4 | 0 | Offsetting trans. for sub-transaction of billing line item | TFKTVO | |
| 19 | |
TAX_TVORG | TVORG_KK | CHAR | 4 | 0 | Subtransaction for tax determination for BB line items | * | |
| 20 | |
LINESORT | LINESORT | CHAR | 4 | 0 | Presorting of billing line items in billing schema | TE530 | |
| 21 | |
ABZEITSCH | DATUM | DATS | 8 | 0 | Date from which time slice is valid | ||
| 22 | |
BISZEITSCH | DATUM | DATS | 8 | 0 | Date at Which a Time Slice Expires | ||
| 23 | |
TIMTYPZA | TIMTYP | CHAR | 1 | 0 | Time category (days or months) for billing line item | ||
| 24 | |
SCHEMANR | SCHEMANR | CHAR | 10 | 0 | Number of the billing schema | * | |
| 25 | |
SNO | LFDNR4 | NUMC | 4 | 0 | Sequence number of schema step in billing schema | ||
| 26 | |
E_PROGRAMM | E_PROGRAMM | CHAR | 8 | 0 | Variant program | * | |
| 27 | |
E_MASSBILL | MEINS | UNIT | 3 | 0 | Unit of measurement for billing | T006 | |
| 28 | |
SAISON | E_OPERAND | CHAR | 10 | 0 | Season | * | |
| 29 | |
TIMBASIS | TIMBASIS | CHAR | 3 | 0 | Time Basis | ||
| 30 | |
TIMTYP | TIMTYP | CHAR | 1 | 0 | Time category (days or months) | ||
| 31 | |
FRAN_TYPE | FRAN_TYPE | CHAR | 1 | 0 | Franchise Fee Category | ||
| 32 | |
KONZIGR | KONZIGR | CHAR | 10 | 0 | Franchise fee group | TE241 | |
| 33 | |
TARIFTYP | TARIFTYP | CHAR | 10 | 0 | Rate category | * | |
| 34 | |
TARIFNR | TARIFNR | CHAR | 10 | 0 | Rate key | * | |
| 35 | |
KONDIGR | KONDIGR | CHAR | 10 | 0 | Rate fact group | TE067 | |
| 36 | |
STTARIF | STTARIFNR | CHAR | 10 | 0 | Statistical rate | ||
| 37 | |
GEWKEY | GEWKEY | CHAR | 8 | 0 | Weighting key | TE266 | |
| 38 | |
WDHFAKT | E_FAKTOR | INT4 | 10 | 0 | Repetition factor for reference values | ||
| 39 | |
TEMP_AREA | TEMP_AREA | CHAR | 8 | 0 | Temperature area | TE307 | |
| 40 | |
DRCKSTUF | DRCKSTUF | CHAR | 2 | 0 | Gas pressure level | ||
| 41 | |
ABGGRND | ABGGRND | CHAR | 4 | 0 | Reason for proration | TE661 | |
| 42 | |
ABGGRND | ABGGRND | CHAR | 4 | 0 | Reason for proration | TE661 | |
| 43 | |
ABGGRND | ABGGRND | CHAR | 4 | 0 | Reason for proration | TE661 | |
| 44 | |
ABGGRND | ABGGRND | CHAR | 4 | 0 | Reason for proration | TE661 | |
| 45 | |
ABGGRND | ABGGRND | CHAR | 4 | 0 | Reason for proration | TE661 | |
| 46 | |
ABGGRND | ABGGRND | CHAR | 4 | 0 | Reason for proration | TE661 | |
| 47 | |
ABGGRND | ABGGRND | CHAR | 4 | 0 | Reason for proration | TE661 | |
| 48 | |
ABGGRND | ABGGRND | CHAR | 4 | 0 | Reason for proration | TE661 | |
| 49 | |
ABGGRND | ABGGRND | CHAR | 4 | 0 | Reason for proration | TE661 | |
| 50 | |
ABGGRND | ABGGRND | CHAR | 4 | 0 | Reason for proration | TE661 | |
| 51 | |
EINOPERAND | E_OPERAND | CHAR | 10 | 0 | Input operand | * | |
| 52 | |
EINOPERAND | E_OPERAND | CHAR | 10 | 0 | Input operand | * | |
| 53 | |
EINOPERAND | E_OPERAND | CHAR | 10 | 0 | Input operand | * | |
| 54 | |
EINOPERAND | E_OPERAND | CHAR | 10 | 0 | Input operand | * | |
| 55 | |
AUSOPERAND | E_OPERAND | CHAR | 10 | 0 | Output operand | * | |
| 56 | |
AUSOPERAND | E_OPERAND | CHAR | 10 | 0 | Output operand | * | |
| 57 | |
E_MASS | MEINS | UNIT | 3 | 0 | Unit of Measurement | T006 | |
| 58 | |
E_MASS | MEINS | UNIT | 3 | 0 | Unit of Measurement | T006 | |
| 59 | |
E_MASS | MEINS | UNIT | 3 | 0 | Unit of Measurement | T006 | |
| 60 | |
E_MASS | MEINS | UNIT | 3 | 0 | Unit of Measurement | T006 | |
| 61 | |
DATUM | DATUM | DATS | 8 | 0 | Date | ||
| 62 | |
DATUM | DATUM | DATS | 8 | 0 | Date | ||
| 63 | |
RABZUS | RABZUS | CHAR | 10 | 0 | Discount key | * | |
| 64 | |
BACKCANC01 | BACKGROUP | CHAR | 4 | 0 | Indicator: reverse backbilling | * | |
| 65 | |
BACKCANC02 | BACKGROUP | CHAR | 4 | 0 | Indicator: reverse backbilling | * | |
| 66 | |
BACKCANC03 | BACKGROUP | CHAR | 4 | 0 | Indicator: reverse backbilling | * | |
| 67 | |
BACKCANC04 | BACKGROUP | CHAR | 4 | 0 | Indicator: reverse backbilling | * | |
| 68 | |
BACKCANC05 | BACKGROUP | CHAR | 4 | 0 | Indicator: reverse backbilling | * | |
| 69 | |
BACKCANC | BACKGROUP | CHAR | 4 | 0 | Indicator: Reverse Backbilling | * | |
| 70 | |
BACKEXEC | BACKGROUP | CHAR | 4 | 0 | Indicator: allocate backbilling | * | |
| 71 | |
BACKDOCNO | E_BELNR | CHAR | 12 | 0 | Number of a billing document | ||
| 72 | |
BACKDOCLINE | LFDNR6 | NUMC | 6 | 0 | Billing line item for billing documents | ||
| 73 | |
DYNCANC01 | DYNGROUP | CHAR | 4 | 0 | Schema steps for reversal in dynamic period control 1 | * | |
| 74 | |
DYNCANC02 | DYNGROUP | CHAR | 4 | 0 | Reversal indicator, dynamic period control 2 | * | |
| 75 | |
DYNCANC03 | DYNGROUP | CHAR | 4 | 0 | Reversal indicator, dynamic period control 3 | * | |
| 76 | |
DYNCANC04 | DYNGROUP | CHAR | 4 | 0 | Reversal Indicator, Dynamic Period Control 4 | * | |
| 77 | |
DYNCANC05 | DYNGROUP | CHAR | 4 | 0 | Reversal indicator, dynamic period control 5 | * | |
| 78 | |
DYNCANC | DYNGROUP | CHAR | 4 | 0 | Indicator: Reverse Backbilling | * | |
| 79 | |
DYNEXEC | DYNGROUP | CHAR | 4 | 0 | Indicator: Allocate Backbilling | * | |
| 80 | |
LRATESTEP | LRATESTEP | NUMC | 10 | 0 | Logical Number of Rate Step | ||
| 81 | |
PEB | KENNZX | CHAR | 1 | 0 | Indicator: billing line item relates to period-end billing | ||
| 82 | |
OPLFDNR | LFDNR4 | NUMC | 4 | 0 | Consecutive number of an operand | ||
| 83 | |
STAFO | STAFO | CHAR | 6 | 0 | Update group for statistics update | * | |
| 84 | |
ARTMENGE | ARTMENGE | CHAR | 1 | 0 | Classification of billed quantity for statistics | ||
| 85 | |
STATTART | TARIFART | CHAR | 8 | 0 | Rate type for statistical analysis | TE069 | |
| 86 | |
TIMECONTRL | TIMECONTRL | CHAR | 2 | 0 | Period control | * | |
| 87 | |
TCNUMTOR | TCNUMTOR | DEC | 8 | 4 | Numerator of the time portion in a time slice | ||
| 88 | |
TCDENOMTOR | TCDENOMTOR | DEC | 8 | 4 | Denominator of the time portion in a time slice | ||
| 89 | |
TIMTYPQUOT | TIMTYP | CHAR | 1 | 0 | Time category of meter for time portion of a time slice | ||
| 90 | |
E_AKTIV | E_AKTIV | CHAR | 1 | 0 | Meter reading active | ||
| 91 | |
KONZVER | KONZVER | CHAR | 10 | 0 | Franchise contract | * | |
| 92 | |
BILLPERTYP | BILLPERTYP | CHAR | 2 | 0 | Category of the internal billing period | ||
| 93 | |
ERCHV_ANCHOR | KENNZX | CHAR | 1 | 0 | Anchor Line for DBERCHV Entry | ||
| 94 | |
OUCONTRACT | VERTRAG | CHAR | 10 | 0 | Master Agreement for Individual Contract | * | |
| 95 | |
0 | 0 | ||||||
| 96 | |
0 | 0 | Pre-/decimal places of always filled ERCHZ fields | |||||
| 97 | |
V_ABRMENGE | V_ABRMENGE | DEC | 17 | 0 | Places before decimal point in billing quantity | ||
| 98 | |
N_ABRMENGE | N_ABRMENGE | DEC | 14 | 14 | Places after decimal point in billing quantity | ||
| 99 | |
V_ZAHL | V_ZAHL | DEC | 17 | 0 | Pre-decimal places in a number | ||
| 100 | |
N_ZAHL | N_ZAHL | DEC | 14 | 14 | Decimal places in a number | ||
| 101 | |
V_ZAHL | V_ZAHL | DEC | 17 | 0 | Pre-decimal places in a number | ||
| 102 | |
N_ZAHL | N_ZAHL | DEC | 14 | 14 | Decimal places in a number | ||
| 103 | |
V_ZAHL | V_ZAHL | DEC | 17 | 0 | Pre-decimal places in a number | ||
| 104 | |
N_ZAHL | N_ZAHL | DEC | 14 | 14 | Decimal places in a number | ||
| 105 | |
V_ZAHL | V_ZAHL | DEC | 17 | 0 | Pre-decimal places in a number | ||
| 106 | |
N_ZAHL | N_ZAHL | DEC | 14 | 14 | Decimal places in a number | ||
| 107 | |
V_ZEITANT | V_ZEITANT | DEC | 17 | 0 | Predecimal place of a time portion | ||
| 108 | |
N_ZEITANT | N_ZEITANT | DEC | 14 | 14 | Decimal places of a time portion |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | DBERCHZ1 | ABGGRND1 | |
|
|||
| 2 | DBERCHZ1 | ABGGRND10 | |
|
|||
| 3 | DBERCHZ1 | ABGGRND2 | |
|
|||
| 4 | DBERCHZ1 | ABGGRND3 | |
|
|||
| 5 | DBERCHZ1 | ABGGRND4 | |
|
|||
| 6 | DBERCHZ1 | ABGGRND5 | |
|
|||
| 7 | DBERCHZ1 | ABGGRND6 | |
|
|||
| 8 | DBERCHZ1 | ABGGRND7 | |
|
|||
| 9 | DBERCHZ1 | ABGGRND8 | |
|
|||
| 10 | DBERCHZ1 | ABGGRND9 | |
|
|||
| 11 | DBERCHZ1 | BELZART | |
|
KEY | ||
| 12 | DBERCHZ1 | BRANCHE | |
|
KEY | ||
| 13 | DBERCHZ1 | GEGEN_TVORG | |
|
|||
| 14 | DBERCHZ1 | GEWKEY | |
|
KEY | ||
| 15 | DBERCHZ1 | KONDIGR | |
|
KEY | ||
| 16 | DBERCHZ1 | KONZIGR | |
|
KEY | ||
| 17 | DBERCHZ1 | LINESORT | |
|
KEY | ||
| 18 | DBERCHZ1 | MASS1 | |
|
KEY | ||
| 19 | DBERCHZ1 | MASS2 | |
|
KEY | ||
| 20 | DBERCHZ1 | MASS3 | |
|
KEY | ||
| 21 | DBERCHZ1 | MASS4 | |
|
KEY | ||
| 22 | DBERCHZ1 | MASSBILL | |
|
KEY | ||
| 23 | DBERCHZ1 | STATTART | |
|
|||
| 24 | DBERCHZ1 | TEMP_AREA | |
|
KEY | ||
| 25 | DBERCHZ1 | TVORG | |
|
History
| Last changed by/on | SAP | 20110901 |
| SAP Release Created in | 462 |