DBERCHZ1 SAP (Individual line items) Table details

Dictionary Type: Table
Description: Individual line items




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




Table field list including key, data, relationships and ABAP select examples

DBERCHZ1 is a standard SAP Table which is used to store Individual line items data and is available within R/3 SAP systems depending on the version and release level.

The DBERCHZ1 table consists of various fields, each holding specific information or linking keys about Individual line items data available in SAP. These include BELNR (Number of a billing document), BELZEILE (Billing line item for billing documents), CSNO (Sequence number of schema step during billing), BELZART (Line Item Type).. 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: Can be enhanced (character-type or numeric)


SAP DBERCHZ1 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
CSNOSequence number of schema step during billing CSNONUMC6LFDSCHEM
BELZARTLine Item Type BELZARTCHAR6TE835BELZARTISU_BELZART
ABSLKZBilling Line Item for Budget Billing Amount Determination ABSLKZCHAR1KENNZX
DIFFKZIndicator: difference line item for discount statistics DIFFKZCHAR1KENNZX
BUCHRELBilling Line Item Relevant to Posting BUCHRELCHAR1KENNZX
MENGESTRELQuantity (billed value) is statistically relevant MENGESTRELCHAR1MENGREL
BETRSTRELAmount of billing line item is statistically relevant BETRSTRELCHAR1KENNZX
STGRQNTQuantity statistics group STGRQNTCHAR6Assigned to domainSTGRQNT
STGRAMTAmount statistics group STGRAMTCHAR6Assigned to domainSTGRAMT
PRINTRELBilling Line Is Print-Relevant PRINTRELCHAR1KENNZX
AKLASSEBilling class AKLASSECHAR4Assigned to domainAKLASSEAKL
BRANCHEIndustry BU_IND_SECTORCHAR10TB038ABU_INDSECTOR
TVORGSubtransaction for Document Item TVORG_KKCHAR4TFKTVOTVORG_KK
GEGEN_TVORGOffsetting trans. for sub-transaction of billing line item GEGEN_TVORGCHAR4TFKTVOTVORG_KK
TAX_TVORGSubtransaction for tax determination for BB line items TAX_TVORGCHAR4Assigned to domainTVORG_KK
LINESORTPresorting of billing line items in billing schema LINESORTCHAR4TE530LINESORT
ABDate from which time slice is valid ABZEITSCHDATS8DATUM
BISDate at Which a Time Slice Expires BISZEITSCHDATS8DATUM
TIMTYPZATime category (days or months) for billing line item TIMTYPZACHAR1TIMTYP
SCHEMANRNumber of the billing schema SCHEMANRCHAR10Assigned to domainSCHEMANRISU_F4_SCHEMA
SNOSequence number of schema step in billing schema SNONUMC4LFDNR4
PROGRAMMVariant program E_PROGRAMMCHAR8Assigned to domainE_PROGRAMMVPMISU_F4_VARIANT
MASSBILLUnit of measurement for billing E_MASSBILLUNIT3T006CUNITMEINS
SAISONSeason SAISONCHAR10Assigned to domainE_OPERAND
TIMBASISTime Basis TIMBASISCHAR3TIMBASIS
TIMTYPTime category (days or months) TIMTYPCHAR1TIMTYP
FRAN_TYPEFranchise Fee Category FRAN_TYPECHAR1FRAN_TYPE
KONZIGRFranchise fee group KONZIGRCHAR10TE241KONZIGR
TARIFTYPRate category TARIFTYPCHAR10Assigned to domainTARIFTYPTTYETTAA
TARIFNRRate key TARIFNRCHAR10Assigned to domainTARIFNRTRFISU_F4_TARIF
KONDIGRRate fact group KONDIGRCHAR10TE067KONDIGR
STTARIFStatistical rate STTARIFCHAR10STTARIFNR
GEWKEYWeighting key GEWKEYCHAR8TE266GEWKEY
WDHFAKTRepetition factor for reference values WDHFAKTINT410E_FAKTOR
TEMP_AREATemperature area TEMP_AREACHAR8TE307TEMP_AREA
DRCKSTUFGas pressure level DRCKSTUFCHAR2DRCKSTUF
ABGGRND1Reason for proration ABGGRNDCHAR4TE661ABGGRND
ABGGRND2Reason for proration ABGGRNDCHAR4TE661ABGGRND
ABGGRND3Reason for proration ABGGRNDCHAR4TE661ABGGRND
ABGGRND4Reason for proration ABGGRNDCHAR4TE661ABGGRND
ABGGRND5Reason for proration ABGGRNDCHAR4TE661ABGGRND
ABGGRND6Reason for proration ABGGRNDCHAR4TE661ABGGRND
ABGGRND7Reason for proration ABGGRNDCHAR4TE661ABGGRND
ABGGRND8Reason for proration ABGGRNDCHAR4TE661ABGGRND
ABGGRND9Reason for proration ABGGRNDCHAR4TE661ABGGRND
ABGGRND10Reason for proration ABGGRNDCHAR4TE661ABGGRND
EIN01Input operand EINOPERANDCHAR10Assigned to domainE_OPERAND
EIN02Input operand EINOPERANDCHAR10Assigned to domainE_OPERAND
EIN03Input operand EINOPERANDCHAR10Assigned to domainE_OPERAND
EIN04Input operand EINOPERANDCHAR10Assigned to domainE_OPERAND
AUS01Output operand AUSOPERANDCHAR10Assigned to domainE_OPERAND
AUS02Output operand AUSOPERANDCHAR10Assigned to domainE_OPERAND
MASS1Unit of Measurement E_MASSUNIT3T006CUNITMEINS
MASS2Unit of Measurement E_MASSUNIT3T006CUNITMEINS
MASS3Unit of Measurement E_MASSUNIT3T006CUNITMEINS
MASS4Unit of Measurement E_MASSUNIT3T006CUNITMEINS
DATUM1Date DATUMDATS8DATUM
DATUM2Date DATUMDATS8DATUM
RABZUSDiscount key RABZUSCHAR10Assigned to domainALPHARABZUSRBZ
BACKCANC01Indicator: reverse backbilling BACKCANC01CHAR4Assigned to domainBACKGROUP
BACKCANC02Indicator: reverse backbilling BACKCANC02CHAR4Assigned to domainBACKGROUP
BACKCANC03Indicator: reverse backbilling BACKCANC03CHAR4Assigned to domainBACKGROUP
BACKCANC04Indicator: reverse backbilling BACKCANC04CHAR4Assigned to domainBACKGROUP
BACKCANC05Indicator: reverse backbilling BACKCANC05CHAR4Assigned to domainBACKGROUP
BACKCANCIndicator: Reverse Backbilling BACKCANCCHAR4Assigned to domainBACKGROUP
BACKEXECIndicator: allocate backbilling BACKEXECCHAR4Assigned to domainBACKGROUP
BACKDOCNONumber of a billing document BACKDOCNOCHAR12ALPHAE_BELNRBELERCH
BACKDOCLINEBilling line item for billing documents BACKDOCLINENUMC6LFDNR6
DYNCANC01Schema steps for reversal in dynamic period control 1 DYNCANC01CHAR4Assigned to domainDYNGROUP
DYNCANC02Reversal indicator, dynamic period control 2 DYNCANC02CHAR4Assigned to domainDYNGROUP
DYNCANC03Reversal indicator, dynamic period control 3 DYNCANC03CHAR4Assigned to domainDYNGROUP
DYNCANC04Reversal Indicator, Dynamic Period Control 4 DYNCANC04CHAR4Assigned to domainDYNGROUP
DYNCANC05Reversal indicator, dynamic period control 5 DYNCANC05CHAR4Assigned to domainDYNGROUP
DYNCANCIndicator: Reverse Backbilling DYNCANCCHAR4Assigned to domainDYNGROUP
DYNEXECIndicator: Allocate Backbilling DYNEXECCHAR4Assigned to domainDYNGROUP
LRATESTEPLogical Number of Rate Step LRATESTEPNUMC10LRATESTEP
PEBIndicator: billing line item relates to period-end billing PEBCHAR1KENNZX
OPLFDNRConsecutive number of an operand OPLFDNRNUMC4LFDNR4
STAFOUpdate group for statistics update STAFOCHAR6Assigned to domainALPHASTAFOMCF
ARTMENGEClassification of billed quantity for statistics ARTMENGECHAR1ARTMENGE
STATTARTRate type for statistical analysis STATTARTCHAR8TE069TARIFARTTAT
TIMECONTRLPeriod control TIMECONTRLCHAR2Assigned to domainTIMECONTRL
TCNUMTORNumerator of the time portion in a time slice TCNUMTORDEC8(4) TCNUMTOR
TCDENOMTORDenominator of the time portion in a time slice TCDENOMTORDEC8(4) TCDENOMTOR
TIMTYPQUOTTime category of meter for time portion of a time slice TIMTYPQUOTCHAR1TIMTYP
AKTIVMeter reading active E_AKTIVCHAR1E_AKTIV
KONZVERFranchise contract KONZVERCHAR10Assigned to domainALPHAKONZVERKZVEKONA
PERTYPCategory of the internal billing period BILLPERTYPCHAR2BILLPERTYP
ERCHV_ANCHORAnchor Line for DBERCHV Entry ERCHV_ANCHORCHAR1KENNZX
OUCONTRACTMaster Agreement for Individual Contract OUCONTRACTCHAR10Assigned to domainALPHAVERTRAGVTGEVER
V_ABRMENGEPlaces before decimal point in billing quantity V_ABRMENGEDEC17V_ABRMENGE
N_ABRMENGEPlaces after decimal point in billing quantity N_ABRMENGEDEC14(14) N_ABRMENGE
V_ZAHL1Pre-decimal places in a number V_ZAHLDEC17V_ZAHL
N_ZAHL1Decimal places in a number N_ZAHLDEC14(14) N_ZAHL
V_ZAHL2Pre-decimal places in a number V_ZAHLDEC17V_ZAHL
N_ZAHL2Decimal places in a number N_ZAHLDEC14(14) N_ZAHL
V_ZAHL3Pre-decimal places in a number V_ZAHLDEC17V_ZAHL
N_ZAHL3Decimal places in a number N_ZAHLDEC14(14) N_ZAHL
V_ZAHL4Pre-decimal places in a number V_ZAHLDEC17V_ZAHL
N_ZAHL4Decimal places in a number N_ZAHLDEC14(14) N_ZAHL
V_ZEITANTPredecimal place of a time portion V_ZEITANTDEC17V_ZEITANT
N_ZEITANTDecimal places of a time portion N_ZEITANTDEC14(14) N_ZEITANT

Key field Non-key field



How do I retrieve data from SAP table DBERCHZ1 using ABAP code

The following ABAP code Example will allow you to do a basic selection on DBERCHZ1 to SELECT all data from the table
DATA: WA_DBERCHZ1 TYPE DBERCHZ1.

SELECT SINGLE *
FROM DBERCHZ1
INTO CORRESPONDING FIELDS OF WA_DBERCHZ1
WHERE...

How to access SAP table DBERCHZ1

Within an ECC or HANA version of SAP you can also view further information about DBERCHZ1 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!