The DBERCHZ4 table in SAP ERP or S/4HANA stores Individual line items (rarely used fields) data. There are total 56 fields in DBERCHZ4 table. The Individual line items (rarely used fields) 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 DBERCHZ4 table. It is in IS-U: Billing (EE20) ABAP package and is part of the Contract Billing (IS-U-BI) module.
SAP DBERCHZ4 Table Fields
Following is the list of fields that are available in SAP DBERCHZ4 table. The primary key fields of Individual line items (rarely used fields) 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) | |
| LEUCHTNR | External lighting number | LEUCHTNR | CHAR (10) | |
| BETRART | Operation Type for Lighting Unit | BETRART | TE497 | CHAR (4) |
| SPGRUND | Disconnection reason | SPGRUND | CHAR (2) | |
| EIN05 | Input operand | EINOPERAND | * | CHAR (10) |
| EIN06 | Input operand | EINOPERAND | * | CHAR (10) |
| EIN07 | Input operand | EINOPERAND | * | CHAR (10) |
| EIN08 | Input operand | EINOPERAND | * | CHAR (10) |
| EIN09 | Input operand | EINOPERAND | * | CHAR (10) |
| EIN10 | Input operand | EINOPERAND | * | CHAR (10) |
| AUS03 | Output operand | AUSOPERAND | * | CHAR (10) |
| AUS04 | Output operand | AUSOPERAND | * | CHAR (10) |
| AUS05 | Output operand | AUSOPERAND | * | CHAR (10) |
| MASS5 | Unit of Measurement | E_MASS | T006 | UNIT (3) |
| MASS6 | Unit of Measurement | E_MASS | T006 | UNIT (3) |
| SC_BELNR | Number of billing document in adjustment reversal | SC_BELNR | CHAR (12) | |
| SC_BELZEILE | Billing line item for billing documents | SC_BELZEILE | NUMC (6) | |
| REFBELZEILE | Reference billing line item for billing documents | REFBELZEILE | NUMC (6) | |
| SPERRUNG | Time slice is in a disconnection period | SPERRUNG | CHAR (1) | |
| NETTOFRMD | Amount in foreign currency with +/- sign | NETTOFRMD | CURR (13) | |
| WAERSF | Currency key for amount | WAERSF | TCURC | CUKY (5) |
| UMRECHDAT | Conversion Date for Foreign Currency Amount | UMRECHDAT | DATS (8) | |
| UMRECHKURS | Exchange rate btwn net amount and foreign currency amount | UMRECHKURS | DEC (9) | |
| REFBELZONE | Ref. billing line item for documents resulting from blocking | REFBELZONE | NUMC (6) | |
| REFBILLDOCNO | Reference Document Number | REFBILLDOCNO | CHAR (12) | |
| FIRSTBELNR | Billing Document Number of First Invoiced Document | FIRSTBELNR | CHAR (12) | |
| TAXREL | Line Contains Tax Determination Quantity for Invoicing | TAXREL | CHAR (1) | |
| TAXGROUP | Categorize Amounts for Tax Determination | TAXGROUP | CHAR (4) | |
| BILLTYPE | Waste Billing Category | EBILLTYPE | CHAR (6) | |
| OBJNR | Number of service frequency | EOBJNR | * | CHAR (10) |
| ORDERNR | Internal Number for Identifying a Waste Disposal Order | EORDERNR | CHAR (20) | |
| LAUFNR | Sequence Number of Service Frequency | LAUFNR | NUMC (5) | |
| ORDER_LAUFNR | Sequence Number for Waste Disposal Order Item | ORDER_LAUFNR | NUMC (4) | |
| GGVERTRAG | Guarantor Contract | E_GUARANTOR_CONTRACT | CHAR (18) | |
| OLD_BELNR | Billing Document Number | E_BELNR | CHAR (12) | |
| CONDIREF | Internal: Reference Number for a Condition | CONDIREF | NUMC (4) | |
| DATEFROM | Start Date | E_MDUSDATEFROM | DATS (8) | |
| TIMEFROM | Start Time | E_MDUSTIMEFROM | TIMS (6) | |
| DATETO | End Date | E_MDUSDATETO | DATS (8) | |
| TIMETO | End Time | E_MDUSTIMETO | TIMS (6) | |
| RATERELGROUP | Rate Relationship Group (in Schema) | E_RATERELGROUP | * | CHAR (10) |
| BASIC_RATE | Rate key | TARIFNR | CHAR (10) | |
| RATERELCAT | Rate Relationship Category | E_RATERELCAT | NUMC (1) | |
| CONDBILLPROGID | Conditional Billing Program ID | E_CONDBILLPROG_ID | * | CHAR (10) |
| GEN_CONTRACT | Contract | VERTRAG | CHAR (10) | |
| REC_CONTRACT | Contract | VERTRAG | CHAR (10) | |
| GEN_TOU | Generating TOU | EGTOU | CHAR (5) | |
| REC_TOU | ISU_Brazil: Consuming TOU | ECTOU | CHAR (5) | |
| PROPORTION_EXT | Distribution Proportion | EDBN_PROP_EXT | DEC (8) | |
| V_ZAHL5 | Pre-decimal places in a number | V_ZAHL | DEC (17) | |
| N_ZAHL5 | Decimal places in a number | N_ZAHL | DEC (14) | |
| V_ZAHL6 | Pre-decimal places in a number | V_ZAHL | DEC (17) | |
| N_ZAHL6 | Decimal places in a number | N_ZAHL | DEC (14) | |
| COLOGRP_INST_L | Colocation group for Installation | E_COLOGRP_INST | CHAR (12) |
