DBERDZ SAP (DB Table: Individ. Lines - Print Document) Table details

Dictionary Type: Table
Description: DB Table: Individ. Lines - Print Document




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




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

DBERDZ is a standard SAP Table which is used to store DB Table: Individ. Lines - Print Document data and is available within R/3 SAP systems depending on the version and release level.

The DBERDZ table consists of various fields, each holding specific information or linking keys about DB Table: Individ. Lines - Print Document data available in SAP. These include OPBEL (Number of print document), BELZEILE (Billing line item for billing documents), BUKRS (Company Code), KTOSL (Transaction Key).. 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 DBERDZ 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
OPBELNumber of print document E_PRINTDOCCHAR12Assigned to domainALPHAE_PRINTDOCE_PRINTDOC
BELZEILEBilling line item for billing documents BELZEILENUMC6LFDNR6
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
KTOSLTransaction Key KTOSLCHAR3CHAR3
HKONTGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
STPRZTax rate in output format STEUERSATZCHAR8CHAR8
SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt) SBASW_KKCURR13(2) WRTV7
SBETWTax Amount in Transaction Currency with +/- Sign SBETW_KKCURR13(2) WRTV7
TXJCDTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
HVORGMain Transaction for Line Item HVORG_KKCHAR4TFKHVOHVORG_KK8HV
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
BLDATDocument Date in Document BLDATDATS8DATUM
BUDATPosting Date in the Document BUDATDATS8DATUM
FAEDNDue date for net payment FAEDN_KKDATS8DATUM
BETRWAmount in Transaction Currency with +/- Sign BETRW_KKCURR13(2) WRTV7
AUGBWClearing Amount in Transaction Currency (With +/- Sign) AUGBW_KKCURR13(2) WRTV7
FAEDSDue Date for Cash Discount FAEDS_KKDATS8DATUM
SKTOWCash discount amount in transaction currency with +/- sign SKTOW_KKCURR13(2) WRTV7
ASKTWProportional cash discount in transaction currency ASKTW_KKCURR13(2) WRTV7
SKTPZCash discount rate SKTPZ_KKDEC5(3) PRZ23
VERTRAGContract VERTRAGCHAR10Assigned to domainALPHAVERTRAGVTGEVER
ABPOPBELBudget billing plan ABPLANNRCHAR12Assigned to domainALPHAOPBEL_KKOP1EABP
SPARTEDivision SPARTECHAR2TSPASPARTSPA
XTOTAL_AMNTConsider Items in Bill Sum Total XTOTAL_AMNTCHAR1E_XTOTAL_AMNT
AWTYPReference Transaction AWTYPCHAR5Assigned to domainAWTYP
AWKEYReference Key AWKEYCHAR20AWKEY
CA_OPBELNumber of Contract Accts Rec. & Payable Doc. OPBEL_KKCHAR12Assigned to domainALPHAOPBEL_KK80B
TAXRATE_INTERNALTax rate STPRZ_KKNUMC6STPRZ_KK
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
BRUTTOZEILEBlling line item is a gross line item BRUTTOZEILECHAR1KENNZX
AKLASSEBilling class AKLASSECHAR4Assigned to domainAKLASSEAKL
BRANCHEIndustry sector BU_INDSECTCHAR10TB023BU_INDSECTH_TB023
TVORGSubtransaction for Document Item TVORG_KKCHAR4TFKTVOTVORG_KK
GEGEN_TVORGOffsetting trans. for sub-transaction of billing line item GEGEN_TVORGCHAR4TFKTVOTVORG_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
ZEITANTTime portion, billing period in days or months E_ZEITANTDEC8(4) E_ZEITANT
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
EQUNREquipment Number EQUNRCHAR18Assigned to domainALPHAEQUNREQNEQUI
GERAETDevice GERAETCHAR18GERNRGERNRGEREGER
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
ZWNUMMERRegister E_ZWNUMMERNUMC3LFDNR3EZN
INDEXNRConsecutive number of register relationship INDEXNRNUMC12INDEXNR
MASSBILLUnit of measurement for billing E_MASSBILLUNIT3T006CUNITMEINS
MWSKZTax on sales/purchases code MWSKZCHAR2Assigned to domainMWSKZ
ERMWSKZIndicator: Tax Determination Code ERMWSKZCHAR2Assigned to domainERMWSKZ
NETTOBTRNet amount of billing line item NETTOBTRCURR13(2) WRTV7
TWAERSTransaction Currency TWAERSCUKY5TCURCWAERSPCU
SAISONSeason SAISONCHAR10Assigned to domainE_OPERAND
PREISTUFPrice level PREISTUFCHAR10TE471PREISTUFPRZ
PREISTYPPrice category PREISTYPCHAR1PREISTYPPRY
PREISPrice E_PREISCHAR10Assigned to domainALPHAE_PREISPRXISU_F4_PREIS
PREISZUSIndicator: Price Summary PREISZUSCHAR4KENNZ4
VONZONEFrom-block VONZONENUMC10E_ZONE
BISZONETo-block BISZONENUMC10E_ZONE
ZONENNRNumber of price block or price scale E_ZONENNRNUMC3E_ZONENNR
PREISBTRPrice amount PRSBTRDEC17(8) PRSBTR
MNGBASISQuantity base for amount MNGBASISDEC5(2) MNGBASIS
TIMBASISTime Basis TIMBASISCHAR3TIMBASIS
TIMTYPTime category (days or months) TIMTYPCHAR1TIMTYP
PREIGKLPrice adjustment clause PREIGKLCHAR10Assigned to domainPREIGKLPAC
URPREISBase price to which the price adjustment clause relates URPREISDEC17(8) PRSBTR
PREIADDPrice to be added for price adjustment PREIADDDEC17(8) PRSBTR
PREIFAKTPrice adjustment factor PREIFAKTDEC12(7) PREIFAKT
OPMULTAddition first OPMULTCHAR1KENZX
FRAN_TYPEFranchise Fee Category FRAN_TYPECHAR1FRAN_TYPE
KONZIGRFranchise fee group KONZIGRCHAR10TE241KONZIGR
ABLESGRMeter reading reason ABLESGRCHAR2TE609ABLESGRABLGRD
ABLESGRVPrevious meter reading reason ABLESGRVCHAR2TE609ABLESGR
ATIMMeter reading time (relevant to billing) ATIMCHAR4HH_MMHHMM
ATIMVATime of day of previous meter reading ATIMVACHAR4HH_MMHHMM
ADATMAXDate of maximum meter reading ADATMAXDATS8DATUM
ATIMMAXTime of maximum meter reading ATIMMAXCHAR4HH_MMHHMM
TARIFTYPRate category TARIFTYPCHAR10Assigned to domainTARIFTYPTTYETTAA
TARIFNRRate key TARIFNRCHAR10Assigned to domainTARIFNRTRFISU_F4_TARIF
KONDIGRRate fact group KONDIGRCHAR10TE067KONDIGR
STTARIFStatistical rate STTARIFCHAR10STTARIFNR
GEWKEYWeighting key GEWKEYCHAR8TE266GEWKEY
GEWANTZNumerator of weighting portion GEWANTZDEC17GEWANTZ
GEWANTNDenominator of weighting portion GEWANTNDEC17GEWANTN
LEUCHTNRExternal lighting number LEUCHTNRCHAR10LEUCHTNR
BETRARTOperation Type for Lighting Unit BETRARTCHAR4TE497BETRART
WDHFAKTRepetition factor for reference values WDHFAKTINT410E_FAKTOR
TEMP_AREATemperature area TEMP_AREACHAR8TE307TEMP_AREA
DRCKSTUFGas pressure level DRCKSTUFCHAR2DRCKSTUF
THGDATUMGas allocation date THGDATUMDATS8DATUM
ZUORDDATMeter reading allocation date E_ZUORDDATDATS8DATUM
SPGRUNDDisconnection reason SPGRUNDCHAR2Assigned to domainSPGRUND
ABGGRND1Reason for proration ABGGRNDCHAR4Assigned to domainABGGRND
ABGGRND2Reason for proration ABGGRNDCHAR4Assigned to domainABGGRND
ABGGRND3Reason for proration ABGGRNDCHAR4Assigned to domainABGGRND
ABGGRND4Reason for proration ABGGRNDCHAR4Assigned to domainABGGRND
ABGGRND5Reason for proration ABGGRNDCHAR4Assigned to domainABGGRND
ABGGRND6Reason for proration ABGGRNDCHAR4Assigned to domainABGGRND
ABGGRND7Reason for proration ABGGRNDCHAR4Assigned to domainABGGRND
ABGGRND8Reason for proration ABGGRNDCHAR4Assigned to domainABGGRND
ABGGRND9Reason for proration ABGGRNDCHAR4Assigned to domainABGGRND
ABGGRND10Reason for proration ABGGRNDCHAR4Assigned to domainABGGRND
EIN01Input operand EINOPERANDCHAR10Assigned to domainE_OPERAND
EIN02Input operand EINOPERANDCHAR10Assigned to domainE_OPERAND
EIN03Input operand EINOPERANDCHAR10Assigned to domainE_OPERAND
EIN04Input operand EINOPERANDCHAR10Assigned to domainE_OPERAND
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
AUS01Output operand AUSOPERANDCHAR10Assigned to domainE_OPERAND
AUS02Output operand AUSOPERANDCHAR10Assigned to domainE_OPERAND
AUS03Output operand AUSOPERANDCHAR10Assigned to domainE_OPERAND
AUS04Output operand AUSOPERANDCHAR10Assigned to domainE_OPERAND
AUS05Output 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
MASS5Unit of Measurement E_MASSUNIT3T006CUNITMEINS
MASS6Unit of Measurement E_MASSUNIT3T006CUNITMEINS
DATUM1Date DATUMDATS8DATUM
DATUM2Date DATUMDATS8DATUM
TEXTNRText Number TEXTNRNUMC8NUM08
TEXTSPLanguage key in text processing TEXTSPLANG1T002ISOLASPRAS
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
LRATESTEPLogical Number of Rate Step LRATESTEPNUMC10LRATESTEP
TXDAT_KKDecisive Date for Calculating Taxes TXDAT_KKDATS8DATUM
REGRELSORTSort help for register relationships during bill printout REGRELSORTNUMC2REGRELSORT
SC_BELNRNumber of billing document in adjustment reversal SC_BELNRCHAR12ALPHAE_BELNRBELERCH
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
PRCTRProfit Center PRCTRCHAR10CEPCALPHAPRCTRPRCPRCTR_EMPTY
KOSTLCost Center KOSTLCHAR10CSKSALPHAKOSTLKOS
PS_PSP_PNRWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8PRPSKONPRPS_POSNR
AUFNROrder Number AUFNRCHAR12AUFKALPHAAUFNRANR
PAOBJNRProfitability Segment Number (CO-PA) RKEOBJNRNUMC10RKEOBJNR
PAOBJNR_SProfitability Segment No. for CO-PA Post. Acc. to Cons. Mth RKEOBJNR_SNUMC10RKEOBJNR
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
APERIODICNon-Periodic Posting APERIODICCHAR1KENNZX
ABLBELNRInternal ID for meter reading document ABLBELNRCHAR20Assigned to domainALPHAABLBELNREAB
LOGIKZWLogical register number LOGIKZWNUMC18LOGIKZW
ISTABLARTMeter reading type ISTABLARTCHAR2Assigned to domainISTABLARTIALISU_MR_ISTABLART
ISTABLARTVAMeter reading type of previous meter reading ISTABLARTVACHAR2Assigned to domainISTABLARTIALISU_MR_ISTABLART
EXTPKZSimulation indicator for meter reading results EXTPKZCHAR1ORIGIN_ESTIM
BEGPROGStart of forecast period BEGPROGDATS8DATUM
ENDEPROGEnd of forecast period ENDEPROGDATS8DATUM
REFBELZEILEReference billing line item for billing documents REFBELZEILENUMC6LFDNR6
SPERRUNGTime slice is in a disconnection period SPERRUNGCHAR1KENNZX
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
NETTOFRMDAmount in foreign currency with +/- sign NETTOFRMDCURR13(2) WRTV7
WAERSFCurrency key for amount WAERSFCUKY5Assigned to domainWAERS
UMRECHDATConversion Date for Foreign Currency Amount UMRECHDATDATS8UMRECHDAT
UMRECHKURSExchange rate btwn net amount and foreign currency amount UMRECHKURSDEC9(5) EXCRTKURSF
AKTIVMeter reading active E_AKTIVCHAR1E_AKTIV
REFBELZONERef. billing line item for documents resulting from blocking REFBELZONENUMC6LFDNR6
ABLHINWNote from meter reader ABLHINWCHAR4Assigned to domainABLHINW
KONZVERFranchise contract KONZVERCHAR10Assigned to domainALPHAKONZVERKZVEKONA
REFBILLDOCNOReference Document Number REFBILLDOCNOCHAR12ALPHAE_BELNR
PERTYPCategory of the internal billing period BILLPERTYPCHAR2BILLPERTYP
V_ZWSTANDPlaces Before Decimal Point in Meter Reading V_ZWSTANDDEC17V_ZWSTAND
N_ZWSTANDPlaces After Decimal Point in the Meter Reading N_ZWSTANDDEC14(14) N_ZWSTAND
V_ZWSTNDABPredecimal Places in Billed Meter Reading V_ZWSTNDABDEC17V_ZWSTAND
N_ZWSTNDABDecimal Places in the Billed Meter Reading N_ZWSTNDABDEC14(14) N_ZWSTAND
V_ZWSTVORPredecimal places in previous meter reading result V_ZWSTVORDEC17V_ZWSTAND
N_ZWSTVORDecimal places in previous meter reading N_ZWSTVORDEC14(14) N_ZWSTAND
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_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
V_ZWSTDIFFPre-decimal places for the meter reading difference V_ZWSTDIFFDEC17V_ZWSTDIFF
N_ZWSTDIFFDecimal places for the meter reading difference N_ZWSTDIFFDEC14(14) N_ZWSTDIFF

Key field Non-key field



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

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

SELECT SINGLE *
FROM DBERDZ
INTO CORRESPONDING FIELDS OF WA_DBERDZ
WHERE...

How to access SAP table DBERDZ

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