DBERCHZ8 SAP (Document line items (rarely used fields, unimportant)) Table details
Description: Document line items (rarely used fields, unimportant)
Table field list including key, data, relationships and ABAP select examples
DBERCHZ8 is a standard SAP Table which is used to store Document line items (rarely used fields, unimportant) data and is available within R/3 SAP systems depending on the version and release level.
The DBERCHZ8 table consists of various fields, each holding specific information or linking keys about Document line items (rarely used fields, unimportant) 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 DBERCHZ8 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 DBERCHZ8 using ABAP code
The following ABAP code Example will allow you to do a basic selection on DBERCHZ8 to SELECT all data from the tableDATA: WA_DBERCHZ8 TYPE DBERCHZ8.
SELECT SINGLE *
FROM DBERCHZ8
INTO CORRESPONDING FIELDS OF WA_DBERCHZ8
WHERE...
How to access SAP table DBERCHZ8
Within an ECC or HANA version of SAP you can also view further information about DBERCHZ8 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