DBERCHZ4 SAP (Individual line items (rarely used fields)) Table details
Dictionary Type: Table
Description: Individual line items (rarely used fields)
Description: Individual line items (rarely used fields)
Table field list including key, data, relationships and ABAP select examples
DBERCHZ4 is a standard SAP Table which is used to store Individual line items (rarely used fields) data and is available within R/3 SAP systems depending on the version and release level.
The DBERCHZ4 table consists of various fields, each holding specific information or linking keys about Individual line items (rarely used fields) data available in SAP. These include BELNR (Number of a billing document), BELZEILE (Billing line item for billing documents), LEUCHTNR (External lighting number), BETRART (Operation Type for Lighting Unit).. 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: Cannot Be Enhanced
SAP DBERCHZ4 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 | ||||
LEUCHTNR | External lighting number | LEUCHTNR | CHAR | 10 | LEUCHTNR | ||||
BETRART | Operation Type for Lighting Unit | BETRART | CHAR | 4 | TE497 | BETRART | |||
SPGRUND | Disconnection reason | SPGRUND | CHAR | 2 | SPGRUND | ||||
EIN05 | Input operand | EINOPERAND | CHAR | 10 | Assigned to domain | E_OPERAND | |||
EIN06 | Input operand | EINOPERAND | CHAR | 10 | Assigned to domain | E_OPERAND | |||
EIN07 | Input operand | EINOPERAND | CHAR | 10 | Assigned to domain | E_OPERAND | |||
EIN08 | Input operand | EINOPERAND | CHAR | 10 | Assigned to domain | E_OPERAND | |||
EIN09 | Input operand | EINOPERAND | CHAR | 10 | Assigned to domain | E_OPERAND | |||
EIN10 | Input operand | EINOPERAND | CHAR | 10 | Assigned to domain | E_OPERAND | |||
AUS03 | Output operand | AUSOPERAND | CHAR | 10 | Assigned to domain | E_OPERAND | |||
AUS04 | Output operand | AUSOPERAND | CHAR | 10 | Assigned to domain | E_OPERAND | |||
AUS05 | Output operand | AUSOPERAND | CHAR | 10 | Assigned to domain | E_OPERAND | |||
MASS5 | Unit of Measurement | E_MASS | UNIT | 3 | T006 | CUNIT | MEINS | ||
MASS6 | Unit of Measurement | E_MASS | UNIT | 3 | T006 | CUNIT | MEINS | ||
SC_BELNR | Number of billing document in adjustment reversal | SC_BELNR | CHAR | 12 | ALPHA | E_BELNR | BEL | ERCH | |
SC_BELZEILE | Billing line item for billing documents | SC_BELZEILE | NUMC | 6 | LFDNR6 | ||||
REFBELZEILE | Reference billing line item for billing documents | REFBELZEILE | NUMC | 6 | LFDNR6 | ||||
SPERRUNG | Time slice is in a disconnection period | SPERRUNG | CHAR | 1 | KENNZX | ||||
NETTOFRMD | Amount in foreign currency with +/- sign | NETTOFRMD | CURR | 13(2) | WRTV7 | ||||
WAERSF | Currency key for amount | WAERSF | CUKY | 5 | TCURC | WAERS | |||
UMRECHDAT | Conversion Date for Foreign Currency Amount | UMRECHDAT | DATS | 8 | UMRECHDAT | ||||
UMRECHKURS | Exchange rate btwn net amount and foreign currency amount | UMRECHKURS | DEC | 9(5) | EXCRT | KURSF | |||
REFBELZONE | Ref. billing line item for documents resulting from blocking | REFBELZONE | NUMC | 6 | LFDNR6 | ||||
REFBILLDOCNO | Reference Document Number | REFBILLDOCNO | CHAR | 12 | ALPHA | E_BELNR | |||
FIRSTBELNR | Billing Document Number of First Invoiced Document | FIRSTBELNR | CHAR | 12 | ALPHA | E_BELNR | |||
TAXREL | Line Contains Tax Determination Quantity for Invoicing | TAXREL | CHAR | 1 | KENNZX | ||||
TAXGROUP | Categorize Amounts for Tax Determination | TAXGROUP | CHAR | 4 | KENNZ4 | ||||
BILLTYPE | Waste Billing Category | EBILLTYPE | CHAR | 6 | BILLTYPE_ID | EAAT | |||
OBJNR | Number of service frequency | EOBJNR | CHAR | 10 | Assigned to domain | ALPHA | EOBJNR | ||
ORDERNR | Internal Number for Identifying a Waste Disposal Order | EORDERNR | CHAR | 20 | Assigned to domain | ALPHA | EORDERNR | EORDERNR | EORDNERNR |
LAUFNR | Sequence Number of Service Frequency | LAUFNR | NUMC | 5 | NUMC5 | ||||
ORDER_LAUFNR | Sequence Number for Waste Disposal Order Item | ORDER_LAUFNR | NUMC | 4 | NUMC4 | ||||
GGVERTRAG | Guarantor Contract | E_GUARANTOR_CONTRACT | CHAR | 18 | ALPHA | E_GUARANTOR_CONTRACT | EWAGCONTRACT | EWA_GUARANTOR_CONTRACT_MAIN | |
OLD_BELNR | Number of a billing document | E_BELNR | CHAR | 12 | ALPHA | E_BELNR | BEL | ERCH | |
CONDIREF | Internal: Reference Number for a Condition | CONDIREF | NUMC | 4 | LFDNR4 | ||||
DATEFROM | Start Date | E_MDUSDATEFROM | DATS | 8 | DATUM | ||||
TIMEFROM | Start Time | E_MDUSTIMEFROM | TIMS | 6 | TIMS | ||||
DATETO | End Date | E_MDUSDATETO | DATS | 8 | DATUM | ||||
TIMETO | End Time | E_MDUSTIMETO | TIMS | 6 | TIMS | ||||
RATERELGROUP | Rate Relationship Group (in Schema) | E_RATERELGROUP | CHAR | 10 | Assigned to domain | E_RATERELGROUP | |||
BASIC_RATE | Rate key | TARIFNR | CHAR | 10 | Assigned to domain | TARIFNR | TRF | ISU_F4_TARIF | |
RATERELCAT | Rate Relationship Category | E_RATERELCAT | NUMC | 1 | E_RATERELCAT | ||||
CONDBILLPROGID | Conditional Billing Program ID | E_CONDBILLPROG_ID | CHAR | 10 | Assigned to domain | E_CONDBILLPROG_ID | |||
V_ZAHL5 | Pre-decimal places in a number | V_ZAHL | DEC | 17 | V_ZAHL | ||||
N_ZAHL5 | Decimal places in a number | N_ZAHL | DEC | 14(14) | N_ZAHL | ||||
V_ZAHL6 | Pre-decimal places in a number | V_ZAHL | DEC | 17 | V_ZAHL | ||||
N_ZAHL6 | Decimal places in a number | N_ZAHL | DEC | 14(14) | N_ZAHL |
Key field | Non-key field |
How do I retrieve data from SAP table DBERCHZ4 using ABAP code
The following ABAP code Example will allow you to do a basic selection on DBERCHZ4 to SELECT all data from the tableDATA: WA_DBERCHZ4 TYPE DBERCHZ4.
SELECT SINGLE *
FROM DBERCHZ4
INTO CORRESPONDING FIELDS OF WA_DBERCHZ4
WHERE...
How to access SAP table DBERCHZ4
Within an ECC or HANA version of SAP you can also view further information about DBERCHZ4 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