DBERCHZ1 SAP (Individual line items) Table details
Dictionary Type: Table
Description: Individual line items
Description: Individual line items
Table field list including key, data, relationships and ABAP select examples
DBERCHZ1 is a standard SAP Table which is used to store Individual line items data and is available within R/3 SAP systems depending on the version and release level.
The DBERCHZ1 table consists of various fields, each holding specific information or linking keys about Individual line items data available in SAP. These include BELNR (Number of a billing document), BELZEILE (Billing line item for billing documents), CSNO (Sequence number of schema step during billing), BELZART (Line Item Type).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP DBERCHZ1 table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
BELNR | Number of a billing document | E_BELNR | CHAR | 12 | ALPHA | E_BELNR | BEL | ERCH | |
BELZEILE | Billing line item for billing documents | BELZEILE | NUMC | 6 | LFDNR6 | ||||
CSNO | Sequence number of schema step during billing | CSNO | NUMC | 6 | LFDSCHEM | ||||
BELZART | Line Item Type | BELZART | CHAR | 6 | TE835 | BELZART | ISU_BELZART | ||
ABSLKZ | Billing Line Item for Budget Billing Amount Determination | ABSLKZ | CHAR | 1 | KENNZX | ||||
DIFFKZ | Indicator: difference line item for discount statistics | DIFFKZ | CHAR | 1 | KENNZX | ||||
BUCHREL | Billing Line Item Relevant to Posting | BUCHREL | CHAR | 1 | KENNZX | ||||
MENGESTREL | Quantity (billed value) is statistically relevant | MENGESTREL | CHAR | 1 | MENGREL | ||||
BETRSTREL | Amount of billing line item is statistically relevant | BETRSTREL | CHAR | 1 | KENNZX | ||||
STGRQNT | Quantity statistics group | STGRQNT | CHAR | 6 | Assigned to domain | STGRQNT | |||
STGRAMT | Amount statistics group | STGRAMT | CHAR | 6 | Assigned to domain | STGRAMT | |||
PRINTREL | Billing Line Is Print-Relevant | PRINTREL | CHAR | 1 | KENNZX | ||||
AKLASSE | Billing class | AKLASSE | CHAR | 4 | Assigned to domain | AKLASSE | AKL | ||
BRANCHE | Industry | BU_IND_SECTOR | CHAR | 10 | TB038A | BU_INDSECTOR | |||
TVORG | Subtransaction for Document Item | TVORG_KK | CHAR | 4 | TFKTVO | TVORG_KK | |||
GEGEN_TVORG | Offsetting trans. for sub-transaction of billing line item | GEGEN_TVORG | CHAR | 4 | TFKTVO | TVORG_KK | |||
TAX_TVORG | Subtransaction for tax determination for BB line items | TAX_TVORG | CHAR | 4 | Assigned to domain | TVORG_KK | |||
LINESORT | Presorting of billing line items in billing schema | LINESORT | CHAR | 4 | TE530 | LINESORT | |||
AB | Date from which time slice is valid | ABZEITSCH | DATS | 8 | DATUM | ||||
BIS | Date at Which a Time Slice Expires | BISZEITSCH | DATS | 8 | DATUM | ||||
TIMTYPZA | Time category (days or months) for billing line item | TIMTYPZA | CHAR | 1 | TIMTYP | ||||
SCHEMANR | Number of the billing schema | SCHEMANR | CHAR | 10 | Assigned to domain | SCHEMANR | ISU_F4_SCHEMA | ||
SNO | Sequence number of schema step in billing schema | SNO | NUMC | 4 | LFDNR4 | ||||
PROGRAMM | Variant program | E_PROGRAMM | CHAR | 8 | Assigned to domain | E_PROGRAMM | VPM | ISU_F4_VARIANT | |
MASSBILL | Unit of measurement for billing | E_MASSBILL | UNIT | 3 | T006 | CUNIT | MEINS | ||
SAISON | Season | SAISON | CHAR | 10 | Assigned to domain | E_OPERAND | |||
TIMBASIS | Time Basis | TIMBASIS | CHAR | 3 | TIMBASIS | ||||
TIMTYP | Time category (days or months) | TIMTYP | CHAR | 1 | TIMTYP | ||||
FRAN_TYPE | Franchise Fee Category | FRAN_TYPE | CHAR | 1 | FRAN_TYPE | ||||
KONZIGR | Franchise fee group | KONZIGR | CHAR | 10 | TE241 | KONZIGR | |||
TARIFTYP | Rate category | TARIFTYP | CHAR | 10 | Assigned to domain | TARIFTYP | TTY | ETTAA | |
TARIFNR | Rate key | TARIFNR | CHAR | 10 | Assigned to domain | TARIFNR | TRF | ISU_F4_TARIF | |
KONDIGR | Rate fact group | KONDIGR | CHAR | 10 | TE067 | KONDIGR | |||
STTARIF | Statistical rate | STTARIF | CHAR | 10 | STTARIFNR | ||||
GEWKEY | Weighting key | GEWKEY | CHAR | 8 | TE266 | GEWKEY | |||
WDHFAKT | Repetition factor for reference values | WDHFAKT | INT4 | 10 | E_FAKTOR | ||||
TEMP_AREA | Temperature area | TEMP_AREA | CHAR | 8 | TE307 | TEMP_AREA | |||
DRCKSTUF | Gas pressure level | DRCKSTUF | CHAR | 2 | DRCKSTUF | ||||
ABGGRND1 | Reason for proration | ABGGRND | CHAR | 4 | TE661 | ABGGRND | |||
ABGGRND2 | Reason for proration | ABGGRND | CHAR | 4 | TE661 | ABGGRND | |||
ABGGRND3 | Reason for proration | ABGGRND | CHAR | 4 | TE661 | ABGGRND | |||
ABGGRND4 | Reason for proration | ABGGRND | CHAR | 4 | TE661 | ABGGRND | |||
ABGGRND5 | Reason for proration | ABGGRND | CHAR | 4 | TE661 | ABGGRND | |||
ABGGRND6 | Reason for proration | ABGGRND | CHAR | 4 | TE661 | ABGGRND | |||
ABGGRND7 | Reason for proration | ABGGRND | CHAR | 4 | TE661 | ABGGRND | |||
ABGGRND8 | Reason for proration | ABGGRND | CHAR | 4 | TE661 | ABGGRND | |||
ABGGRND9 | Reason for proration | ABGGRND | CHAR | 4 | TE661 | ABGGRND | |||
ABGGRND10 | Reason for proration | ABGGRND | CHAR | 4 | TE661 | ABGGRND | |||
EIN01 | Input operand | EINOPERAND | CHAR | 10 | Assigned to domain | E_OPERAND | |||
EIN02 | Input operand | EINOPERAND | CHAR | 10 | Assigned to domain | E_OPERAND | |||
EIN03 | Input operand | EINOPERAND | CHAR | 10 | Assigned to domain | E_OPERAND | |||
EIN04 | Input operand | EINOPERAND | CHAR | 10 | Assigned to domain | E_OPERAND | |||
AUS01 | Output operand | AUSOPERAND | CHAR | 10 | Assigned to domain | E_OPERAND | |||
AUS02 | Output operand | AUSOPERAND | CHAR | 10 | Assigned to domain | E_OPERAND | |||
MASS1 | Unit of Measurement | E_MASS | UNIT | 3 | T006 | CUNIT | MEINS | ||
MASS2 | Unit of Measurement | E_MASS | UNIT | 3 | T006 | CUNIT | MEINS | ||
MASS3 | Unit of Measurement | E_MASS | UNIT | 3 | T006 | CUNIT | MEINS | ||
MASS4 | Unit of Measurement | E_MASS | UNIT | 3 | T006 | CUNIT | MEINS | ||
DATUM1 | Date | DATUM | DATS | 8 | DATUM | ||||
DATUM2 | Date | DATUM | DATS | 8 | DATUM | ||||
RABZUS | Discount key | RABZUS | CHAR | 10 | Assigned to domain | ALPHA | RABZUS | RBZ | |
BACKCANC01 | Indicator: reverse backbilling | BACKCANC01 | CHAR | 4 | Assigned to domain | BACKGROUP | |||
BACKCANC02 | Indicator: reverse backbilling | BACKCANC02 | CHAR | 4 | Assigned to domain | BACKGROUP | |||
BACKCANC03 | Indicator: reverse backbilling | BACKCANC03 | CHAR | 4 | Assigned to domain | BACKGROUP | |||
BACKCANC04 | Indicator: reverse backbilling | BACKCANC04 | CHAR | 4 | Assigned to domain | BACKGROUP | |||
BACKCANC05 | Indicator: reverse backbilling | BACKCANC05 | CHAR | 4 | Assigned to domain | BACKGROUP | |||
BACKCANC | Indicator: Reverse Backbilling | BACKCANC | CHAR | 4 | Assigned to domain | BACKGROUP | |||
BACKEXEC | Indicator: allocate backbilling | BACKEXEC | CHAR | 4 | Assigned to domain | BACKGROUP | |||
BACKDOCNO | Number of a billing document | BACKDOCNO | CHAR | 12 | ALPHA | E_BELNR | BEL | ERCH | |
BACKDOCLINE | Billing line item for billing documents | BACKDOCLINE | NUMC | 6 | LFDNR6 | ||||
DYNCANC01 | Schema steps for reversal in dynamic period control 1 | DYNCANC01 | CHAR | 4 | Assigned to domain | DYNGROUP | |||
DYNCANC02 | Reversal indicator, dynamic period control 2 | DYNCANC02 | CHAR | 4 | Assigned to domain | DYNGROUP | |||
DYNCANC03 | Reversal indicator, dynamic period control 3 | DYNCANC03 | CHAR | 4 | Assigned to domain | DYNGROUP | |||
DYNCANC04 | Reversal Indicator, Dynamic Period Control 4 | DYNCANC04 | CHAR | 4 | Assigned to domain | DYNGROUP | |||
DYNCANC05 | Reversal indicator, dynamic period control 5 | DYNCANC05 | CHAR | 4 | Assigned to domain | DYNGROUP | |||
DYNCANC | Indicator: Reverse Backbilling | DYNCANC | CHAR | 4 | Assigned to domain | DYNGROUP | |||
DYNEXEC | Indicator: Allocate Backbilling | DYNEXEC | CHAR | 4 | Assigned to domain | DYNGROUP | |||
LRATESTEP | Logical Number of Rate Step | LRATESTEP | NUMC | 10 | LRATESTEP | ||||
PEB | Indicator: billing line item relates to period-end billing | PEB | CHAR | 1 | KENNZX | ||||
OPLFDNR | Consecutive number of an operand | OPLFDNR | NUMC | 4 | LFDNR4 | ||||
STAFO | Update group for statistics update | STAFO | CHAR | 6 | Assigned to domain | ALPHA | STAFO | MCF | |
ARTMENGE | Classification of billed quantity for statistics | ARTMENGE | CHAR | 1 | ARTMENGE | ||||
STATTART | Rate type for statistical analysis | STATTART | CHAR | 8 | TE069 | TARIFART | TAT | ||
TIMECONTRL | Period control | TIMECONTRL | CHAR | 2 | Assigned to domain | TIMECONTRL | |||
TCNUMTOR | Numerator of the time portion in a time slice | TCNUMTOR | DEC | 8(4) | TCNUMTOR | ||||
TCDENOMTOR | Denominator of the time portion in a time slice | TCDENOMTOR | DEC | 8(4) | TCDENOMTOR | ||||
TIMTYPQUOT | Time category of meter for time portion of a time slice | TIMTYPQUOT | CHAR | 1 | TIMTYP | ||||
AKTIV | Meter reading active | E_AKTIV | CHAR | 1 | E_AKTIV | ||||
KONZVER | Franchise contract | KONZVER | CHAR | 10 | Assigned to domain | ALPHA | KONZVER | KZV | EKONA |
PERTYP | Category of the internal billing period | BILLPERTYP | CHAR | 2 | BILLPERTYP | ||||
ERCHV_ANCHOR | Anchor Line for DBERCHV Entry | ERCHV_ANCHOR | CHAR | 1 | KENNZX | ||||
OUCONTRACT | Master Agreement for Individual Contract | OUCONTRACT | CHAR | 10 | Assigned to domain | ALPHA | VERTRAG | VTG | EVER |
V_ABRMENGE | Places before decimal point in billing quantity | V_ABRMENGE | DEC | 17 | V_ABRMENGE | ||||
N_ABRMENGE | Places after decimal point in billing quantity | N_ABRMENGE | DEC | 14(14) | N_ABRMENGE | ||||
V_ZAHL1 | Pre-decimal places in a number | V_ZAHL | DEC | 17 | V_ZAHL | ||||
N_ZAHL1 | Decimal places in a number | N_ZAHL | DEC | 14(14) | N_ZAHL | ||||
V_ZAHL2 | Pre-decimal places in a number | V_ZAHL | DEC | 17 | V_ZAHL | ||||
N_ZAHL2 | Decimal places in a number | N_ZAHL | DEC | 14(14) | N_ZAHL | ||||
V_ZAHL3 | Pre-decimal places in a number | V_ZAHL | DEC | 17 | V_ZAHL | ||||
N_ZAHL3 | Decimal places in a number | N_ZAHL | DEC | 14(14) | N_ZAHL | ||||
V_ZAHL4 | Pre-decimal places in a number | V_ZAHL | DEC | 17 | V_ZAHL | ||||
N_ZAHL4 | Decimal places in a number | N_ZAHL | DEC | 14(14) | N_ZAHL | ||||
V_ZEITANT | Predecimal place of a time portion | V_ZEITANT | DEC | 17 | V_ZEITANT | ||||
N_ZEITANT | Decimal places of a time portion | N_ZEITANT | DEC | 14(14) | N_ZEITANT |
Key field | Non-key field |
How do I retrieve data from SAP table DBERCHZ1 using ABAP code
The following ABAP code Example will allow you to do a basic selection on DBERCHZ1 to SELECT all data from the tableDATA: WA_DBERCHZ1 TYPE DBERCHZ1.
SELECT SINGLE *
FROM DBERCHZ1
INTO CORRESPONDING FIELDS OF WA_DBERCHZ1
WHERE...
How to access SAP table DBERCHZ1
Within an ECC or HANA version of SAP you can also view further information about DBERCHZ1 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects