DBERCHZ8 SAP (Document line items (rarely used fields, unimportant)) Table details

Dictionary Type: Table
Description: Document line items (rarely used fields, unimportant)




ABAP Code to SELECT data from DBERCHZ8
Related tables to DBERCHZ8
Access table DBERCHZ8




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
MANDTClient MANDTCLNT3Assigned to domainMANDT
BELNRNumber of a billing document E_BELNRCHAR12ALPHAE_BELNRBELERCH
BELZEILEBilling line item for billing documents BELZEILENUMC6LFDNR6
LEUCHTNRExternal lighting number LEUCHTNRCHAR10LEUCHTNR
BETRARTOperation Type for Lighting Unit BETRARTCHAR4TE497BETRART
SPGRUNDDisconnection reason SPGRUNDCHAR2SPGRUND
EIN05Input operand EINOPERANDCHAR10Assigned to domainE_OPERAND
EIN06Input operand EINOPERANDCHAR10Assigned to domainE_OPERAND
EIN07Input operand EINOPERANDCHAR10Assigned to domainE_OPERAND
EIN08Input operand EINOPERANDCHAR10Assigned to domainE_OPERAND
EIN09Input operand EINOPERANDCHAR10Assigned to domainE_OPERAND
EIN10Input operand EINOPERANDCHAR10Assigned to domainE_OPERAND
AUS03Output operand AUSOPERANDCHAR10Assigned to domainE_OPERAND
AUS04Output operand AUSOPERANDCHAR10Assigned to domainE_OPERAND
AUS05Output operand AUSOPERANDCHAR10Assigned to domainE_OPERAND
MASS5Unit of Measurement E_MASSUNIT3T006CUNITMEINS
MASS6Unit of Measurement E_MASSUNIT3T006CUNITMEINS
SC_BELNRNumber of billing document in adjustment reversal SC_BELNRCHAR12ALPHAE_BELNRBELERCH
SC_BELZEILEBilling line item for billing documents SC_BELZEILENUMC6LFDNR6
REFBELZEILEReference billing line item for billing documents REFBELZEILENUMC6LFDNR6
SPERRUNGTime slice is in a disconnection period SPERRUNGCHAR1KENNZX
NETTOFRMDAmount in foreign currency with +/- sign NETTOFRMDCURR13(2) WRTV7
WAERSFCurrency key for amount WAERSFCUKY5TCURCWAERS
UMRECHDATConversion Date for Foreign Currency Amount UMRECHDATDATS8UMRECHDAT
UMRECHKURSExchange rate btwn net amount and foreign currency amount UMRECHKURSDEC9(5) EXCRTKURSF
REFBELZONERef. billing line item for documents resulting from blocking REFBELZONENUMC6LFDNR6
REFBILLDOCNOReference Document Number REFBILLDOCNOCHAR12ALPHAE_BELNR
FIRSTBELNRBilling Document Number of First Invoiced Document FIRSTBELNRCHAR12ALPHAE_BELNR
TAXRELLine Contains Tax Determination Quantity for Invoicing TAXRELCHAR1KENNZX
TAXGROUPCategorize Amounts for Tax Determination TAXGROUPCHAR4KENNZ4
BILLTYPEWaste Billing Category EBILLTYPECHAR6BILLTYPE_IDEAAT
OBJNRNumber of service frequency EOBJNRCHAR10Assigned to domainALPHAEOBJNR
ORDERNRInternal Number for Identifying a Waste Disposal Order EORDERNRCHAR20Assigned to domainALPHAEORDERNREORDERNREORDNERNR
LAUFNRSequence Number of Service Frequency LAUFNRNUMC5NUMC5
ORDER_LAUFNRSequence Number for Waste Disposal Order Item ORDER_LAUFNRNUMC4NUMC4
GGVERTRAGGuarantor Contract E_GUARANTOR_CONTRACTCHAR18ALPHAE_GUARANTOR_CONTRACTEWAGCONTRACTEWA_GUARANTOR_CONTRACT_MAIN
OLD_BELNRNumber of a billing document E_BELNRCHAR12ALPHAE_BELNRBELERCH
CONDIREFInternal: Reference Number for a Condition CONDIREFNUMC4LFDNR4
DATEFROMStart Date E_MDUSDATEFROMDATS8DATUM
TIMEFROMStart Time E_MDUSTIMEFROMTIMS6TIMS
DATETOEnd Date E_MDUSDATETODATS8DATUM
TIMETOEnd Time E_MDUSTIMETOTIMS6TIMS
RATERELGROUPRate Relationship Group (in Schema) E_RATERELGROUPCHAR10Assigned to domainE_RATERELGROUP
BASIC_RATERate key TARIFNRCHAR10Assigned to domainTARIFNRTRFISU_F4_TARIF
RATERELCATRate Relationship Category E_RATERELCATNUMC1E_RATERELCAT
CONDBILLPROGIDConditional Billing Program ID E_CONDBILLPROG_IDCHAR10Assigned to domainE_CONDBILLPROG_ID
V_ZAHL5Pre-decimal places in a number V_ZAHLDEC17V_ZAHL
N_ZAHL5Decimal places in a number N_ZAHLDEC14(14) N_ZAHL
V_ZAHL6Pre-decimal places in a number V_ZAHLDEC17V_ZAHL
N_ZAHL6Decimal places in a number N_ZAHLDEC14(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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!