DBERCHZ4 SAP (Individual line items (rarely used fields)) Table details

Dictionary Type: Table
Description: Individual line items (rarely used fields)




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




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
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 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 table
DATA: 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 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!