Search by table name, fields

SAP DBERCHZ5 Table – Individual line items (unimportant rows)

The DBERCHZ5 table in SAP ERP or S/4HANA stores Individual line items (unimportant rows) data. There are total 106 fields in DBERCHZ5 table. The Individual line items (unimportant rows) table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of DBERCHZ5 table. It is in IS-U: Billing (EE20) ABAP package and is part of the Contract Billing (IS-U-BI) module.

SAP DBERCHZ5 Table Fields

Following is the list of fields that are available in SAP DBERCHZ5 table. The primary key fields of Individual line items (unimportant rows) table in SAP are MANDT (Client), BELNR (Billing Document Number), BELZEILE (Billing line item for billing documents).

Field Description Data Element Check Table Data Type
MANDT Client MANDT CLNT (3)
BELNR Billing Document Number E_BELNR CHAR (12)
BELZEILE Billing line item for billing documents BELZEILE NUMC (6)
CSNO Sequence number of schema step during billing CSNO NUMC (6)
BELZART Line Item Type BELZART TE835 CHAR (6)
ABSLKZ Billing Line Item for Budget Billing Amount Determination ABSLKZ CHAR (1)
DIFFKZ Indicator: difference line item for discount statistics DIFFKZ CHAR (1)
BUCHREL Billing Line Item Relevant to Posting BUCHREL CHAR (1)
MENGESTREL Quantity (billed value) is statistically relevant MENGESTREL CHAR (1)
BETRSTREL Amount of billing line item is statistically relevant BETRSTREL CHAR (1)
STGRQNT Quantity statistics group STGRQNT * CHAR (6)
STGRAMT Amount statistics group STGRAMT * CHAR (6)
PRINTREL Billing Line Is Print-Relevant PRINTREL CHAR (1)
AKLASSE Billing Class AKLASSE * CHAR (4)
BRANCHE Industry BU_IND_SECTOR TB038A CHAR (10)
TVORG Subtransaction for Document Item TVORG_KK TFKTVO CHAR (4)
GEGEN_TVORG Offsetting trans. for sub-transaction of billing line item GEGEN_TVORG TFKTVO CHAR (4)
TAX_TVORG Subtransaction for tax determination for BB line items TAX_TVORG * CHAR (4)
LINESORT Presorting of billing line items in billing schema LINESORT TE530 CHAR (4)
AB Date from which time slice is valid ABZEITSCH DATS (8)
BIS Date at Which a Time Slice Expires BISZEITSCH DATS (8)
TIMTYPZA Time category (days or months) for billing line item TIMTYPZA CHAR (1)
SCHEMANR Number of the billing schema SCHEMANR CHAR (10)
SNO Sequence number of schema step in billing schema SNO NUMC (4)
PROGRAMM Variant program E_PROGRAMM CHAR (8)
MASSBILL Unit of measurement for billing E_MASSBILL T006 UNIT (3)
SAISON Season SAISON * CHAR (10)
TIMBASIS Time Basis TIMBASIS CHAR (3)
TIMTYP Time category (days or months) TIMTYP CHAR (1)
FRAN_TYPE Franchise Fee Category FRAN_TYPE CHAR (1)
KONZIGR Franchise fee group KONZIGR TE241 CHAR (10)
TARIFTYP Rate category TARIFTYP CHAR (10)
TARIFNR Rate key TARIFNR CHAR (10)
KONDIGR Rate fact group KONDIGR TE067 CHAR (10)
STTARIF Statistical rate STTARIF CHAR (10)
GEWKEY Weighting key GEWKEY TE266 CHAR (8)
WDHFAKT Repetition factor for reference values WDHFAKT INT4 (10)
TEMP_AREA Temperature area TEMP_AREA TE307 CHAR (8)
DRCKSTUF Gas pressure level DRCKSTUF * CHAR (2)
ABGGRND1 Reason for proration ABGGRND TE661 CHAR (4)
ABGGRND2 Reason for proration ABGGRND TE661 CHAR (4)
ABGGRND3 Reason for proration ABGGRND TE661 CHAR (4)
ABGGRND4 Reason for proration ABGGRND TE661 CHAR (4)
ABGGRND5 Reason for proration ABGGRND TE661 CHAR (4)
ABGGRND6 Reason for proration ABGGRND TE661 CHAR (4)
ABGGRND7 Reason for proration ABGGRND TE661 CHAR (4)
ABGGRND8 Reason for proration ABGGRND TE661 CHAR (4)
ABGGRND9 Reason for proration ABGGRND TE661 CHAR (4)
ABGGRND10 Reason for proration ABGGRND TE661 CHAR (4)
EIN01 Input operand EINOPERAND * CHAR (10)
EIN02 Input operand EINOPERAND * CHAR (10)
EIN03 Input operand EINOPERAND * CHAR (10)
EIN04 Input operand EINOPERAND * CHAR (10)
AUS01 Output operand AUSOPERAND * CHAR (10)
AUS02 Output operand AUSOPERAND * CHAR (10)
MASS1 Unit of Measurement E_MASS T006 UNIT (3)
MASS2 Unit of Measurement E_MASS T006 UNIT (3)
MASS3 Unit of Measurement E_MASS T006 UNIT (3)
MASS4 Unit of Measurement E_MASS T006 UNIT (3)
DATUM1 Date DATUM DATS (8)
DATUM2 Date DATUM DATS (8)
RABZUS Discount key RABZUS * CHAR (10)
BACKCANC01 Indicator: reverse backbilling BACKCANC01 * CHAR (4)
BACKCANC02 Indicator: reverse backbilling BACKCANC02 * CHAR (4)
BACKCANC03 Indicator: reverse backbilling BACKCANC03 * CHAR (4)
BACKCANC04 Indicator: reverse backbilling BACKCANC04 * CHAR (4)
BACKCANC05 Indicator: reverse backbilling BACKCANC05 * CHAR (4)
BACKCANC Indicator: Reverse Backbilling BACKCANC * CHAR (4)
BACKEXEC Indicator: allocate backbilling BACKEXEC * CHAR (4)
BACKDOCNO Number of a billing document BACKDOCNO CHAR (12)
BACKDOCLINE Billing line item for billing documents BACKDOCLINE NUMC (6)
DYNCANC01 Schema steps for reversal in dynamic period control 1 DYNCANC01 * CHAR (4)
DYNCANC02 Reversal indicator, dynamic period control 2 DYNCANC02 * CHAR (4)
DYNCANC03 Reversal indicator, dynamic period control 3 DYNCANC03 * CHAR (4)
DYNCANC04 Reversal Indicator, Dynamic Period Control 4 DYNCANC04 * CHAR (4)
DYNCANC05 Reversal indicator, dynamic period control 5 DYNCANC05 * CHAR (4)
DYNCANC Indicator: Reverse Backbilling DYNCANC * CHAR (4)
DYNEXEC Indicator: Allocate Backbilling DYNEXEC * CHAR (4)
LRATESTEP Logical Number of Rate Step LRATESTEP NUMC (10)
PEB Indicator: billing line item relates to period-end billing PEB CHAR (1)
OPLFDNR Consecutive number of an operand OPLFDNR NUMC (4)
STAFO Update Group for statistics update STAFO * CHAR (6)
ARTMENGE Classification of billed quantity for statistics ARTMENGE CHAR (1)
STATTART Rate type for statistical analysis STATTART TE069 CHAR (8)
TIMECONTRL Period control TIMECONTRL * CHAR (2)
TCNUMTOR Numerator of the time portion in a time slice TCNUMTOR DEC (8)
TCDENOMTOR Denominator of the time portion in a time slice TCDENOMTOR DEC (8)
TIMTYPQUOT Time category of meter for time portion of a time slice TIMTYPQUOT CHAR (1)
AKTIV Meter reading active E_AKTIV CHAR (1)
KONZVER Franchise contract KONZVER CHAR (10)
PERTYP Category of the internal billing period BILLPERTYP CHAR (2)
ERCHV_ANCHOR Anchor Line for DBERCHV Entry ERCHV_ANCHOR CHAR (1)
OUCONTRACT Master Agreement for Individual Contract OUCONTRACT CHAR (10)
V_ABRMENGE Places before decimal point in billing quantity V_ABRMENGE DEC (17)
N_ABRMENGE Places after decimal point in billing quantity N_ABRMENGE DEC (14)
V_ZAHL1 Pre-decimal places in a number V_ZAHL DEC (17)
N_ZAHL1 Decimal places in a number N_ZAHL DEC (14)
V_ZAHL2 Pre-decimal places in a number V_ZAHL DEC (17)
N_ZAHL2 Decimal places in a number N_ZAHL DEC (14)
V_ZAHL3 Pre-decimal places in a number V_ZAHL DEC (17)
N_ZAHL3 Decimal places in a number N_ZAHL DEC (14)
V_ZAHL4 Pre-decimal places in a number V_ZAHL DEC (17)
N_ZAHL4 Decimal places in a number N_ZAHL DEC (14)
V_ZEITANT Predecimal place of a time portion V_ZEITANT DEC (17)
N_ZEITANT Decimal places of a time portion N_ZEITANT DEC (14)
COLOGRP_INST_L Colocation group for Installation E_COLOGRP_INST CHAR (12)