VDBEPI_ADD SAP (Extended VDBEPI for Display in Account Statement) Structure details

Dictionary Type: Structure
Description: Extended VDBEPI for Display in Account Statement




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




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

VDBEPI_ADD is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Extended VDBEPI for Display in Account Statement" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_VDBEPI_ADD TYPE VDBEPI_ADD.

The VDBEPI_ADD table consists of various fields, each holding specific information or linking keys about Extended VDBEPI for Display in Account Statement data available in SAP. These include MANDT (Client), BUKRS (Company Code), RBELKPFD (Document Number of Document Header (Loan)), RPOSNR (Activity number).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP VDBEPI_ADD structure 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 MANDTCLNT3T000MANDT
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
RBELKPFDDocument Number of Document Header (Loan) RBELKPFDCHAR10VDBEKIALPHARBELKPFD
RPOSNRActivity number NVORGANGCHAR3CHAR3
SBEWARTFlow Type SBEWARTCHAR4Assigned to domainSBEWART
SREFBEWReference flow type SREFBEWCHAR4Assigned to domainSBEWART
SBEWZITIFlow category SBEWZITICHAR4Assigned to domainSBEWZITI
BNWHRNominal amount BNWHRCURR13(2) WERTV7
SNWHRCurrency of nominal amount SNWHRCUKY5Assigned to domainWAERS
BBWHRAmount in position currency BBWHRCURR13(2) WERTV7
SBWHRPosition Currency (Currency of Position Amount) SBWHRCUKY5Assigned to domainWAERS
BCWHRSettlement Amount BCWHRCURR13(2) WERTV7
SCWHRSettlement Currency SCWHRCUKY5Assigned to domainWAERS
BHWHRAmount in local currency BHWHRCURR13(2) WERTV7
PKKURSPurchase Price of Borrower's Note PKKURSDEC10(7) PWKURS
PRUCKRepayment rate in percent PRUCKDEC10(7) DEC3_7
KURS1Exchange rate VVKURSFDEC9(5) EXCRTKURSF
KURS2Exchange rate VVKURSFDEC9(5) EXCRTKURSF
DVALUTCalculation Date DVALUTDATS8DATUM
DFAELLDue date DFAELLDATS8DATUM
DDISPOPayment Date DDISPODATS8DATUM
DBESTANDPosition value date DBESTANDDATS8DATUM
DBERVONStart of Calculation Period DBERVONDATS8DATUM
UMSKZSpecial G/L Indicator UMSKZCHAR1Assigned to domainUMSKZ
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
SSPESENExpenses key SSPESENCHAR1SSPESEN
SSOLHABDebit/credit indicator VVSSOLHABCHAR1VVSSOLHAB
RSOLLAccount for debit posting RSOLLCHAR10SKA1ALPHASAKNR
RHABENAccount for credit posting RHABENCHAR10SKA1ALPHASAKNR
RZKSOLLDebit interim account RZKSOLLCHAR10SKA1ALPHASAKNR
RZKHABECredit interim account RZKHABECHAR10SKA1ALPHASAKNR
SBSLSOLLPosting Key BSCHLCHAR2TBSLBSCHL
SBSLZKSOPosting Key BSCHLCHAR2TBSLBSCHL
SBSLZKHAPosting Key BSCHLCHAR2TBSLBSCHL
SHSLHABENPosting Key BSCHLCHAR2TBSLBSCHL
BUCHTXTItem Text SGTXTCHAR50TEXT50
RBANKKBank account RBANKKCHAR10SKB1ALPHASAKNRBKT
SFDLEVPlanning level FDLEVCHAR2T036FDLEVFFE
JFDUPDRecord transferred to cash management and forecast JFDUPDCHAR1JANEI
JONLAENIndicator for fixing a flow record JONLAENCHAR1VVSONLAEN
JZINSBASFlow in interest base JZINSBASCHAR1JANEI
JZINSZPTInterest date JZINSZPTCHAR1JANEI
PKONDPercentage rate for condition items PKONDDEC10(7) DECV3_7
BBASISCalculation base amount BBASISCURR13(2) WERTV7
SSORTZITSort indicator for interest/repayment schedule calculations SSORTZITCHAR1CHAR1
SWOHERSource of flow record SWOHERCHAR1CHAR1
KUNNRCustomer Numbers KUNNRCHAR10KNA1ALPHAKUNNRKUNC_KUNNR
BVTYPPartner Bank Type BVTYPCHAR4BVTYP
ZLSCHPayment Method DZLSCHCHAR1Assigned to domainZLSCH
MABERDunning Area MABERCHAR2T047MMABER
ZAHLSBlock Key for Payment DZAHLSCHAR1T008ZAHLS
RPARTNRBusiness Partner Number BP_PARTNR_NEWCHAR10BUT000ALPHABU_PARTNERBPABUPA
SROLEXTDummy function DUMMY_3CHAR3CHAR3
JEINBEHALTIndicator for Withholding of Amount During Disbursement JEINBEHALTCHAR1KENZX
JFIRUECKConfirmation From FI Not Necessary JFIRUECKCHAR1JANEI
MWSKZTax on sales/purchases code MWSKZCHAR2Assigned to domainMWSKZ
MWARTTax Type MWARTCHAR1MWART
DBERBISEnd of Calculation Period DBERBISDATS8DATUM
ATAGENumber of days VVATAGENUMC6INT6
ABASTAGENumber of base days in a calculation period ABASTAGENUMC6INT6
SZBMETHInterest Calculation Method SZBMETHCHAR1SZBMETH
JSTOCKPremium reserve fund-relevant indicator VVJSTOCKCHAR1JANEI
SBUSTPosting control key VVSBUSTNUMC2TZB09VVSBUST
DTRANSFlow data key: System date VVDTRANSDATS8DATUM
TTRANSTransaction data key: system time VVTTRANSTIMS6UZEIT
NTRANSTransaction data key: Consecutive number VVNTRANSNUMC4NUMC4
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
SKOARTCondition Type (Smallest Subdivision of Condition Records) SKOARTNUMC4TZK01SKOART
SEXCLVONExclusive Indicator for the Start of a Calculation Period VVSEXCLVONNUMC1VVSEXCLVON
SULTVONMonth-End Indicator for Start of a Calculation Period VVSULTVONCHAR1VVSULT
SINCLBISInclusive Indicator for the End of a Calculation Period VVSINCLBISNUMC1VVSINCLBIS
SULTBISMonth-End Indicator for the End of a Calculation Period VVSULTBISCHAR1VVSULT
SINCLInclusive indicator for beginning and end of a period VVSINCLNUMC1VVSINCL
DVERRECHSettlement date VVDVERRECHDATS8DATUM
DPKONDDetermination date for percentage rate of condition items VVDPKONDDATS8DATUM
SBUCHAIndicator for postings to accruals/deferrals accounts VVSBUCHACHAR1CHAR1
ZINKZExempted from interest calculation DZINKZCHAR2ZINKZ
SVULTMonth-End Indicator for Value Date VVSVULTCHAR1VVSULT
JSOFVERRImmediate settlement JSOFVERRCHAR1TFMSOFVERR
SINCLVERRInclusive Indicator for Clearing Date VVSINCLVERNUMC1VVSINCLVER
SULTVERRMonth-End Indicator for Clearing Date VVSULTVERRCHAR1VVSULT
SREFZITIRefer.flow category in accrual/deferral flow records VVSREFZITICHAR4Assigned to domainSBEWZITI
STGBASISBase Days Method VVSTGBASISNUMC1VVSTGBASIS
STGMETHDaily Method VVSTGMETHNUMC1VVSTGMETH
SBASISCalculation base reference VVSBASISCHAR4Assigned to domainVVSBASIS
SGTXTItem Text SGTXTCHAR50TEXT50
SBERFIMACalculation category for cash flow calculator SBEWFIMACHAR4AT40SBEWFIMA
SVORGKZActivity indicator for debit/credit control VVSVORGKZNUMC2VVSVORGKZ
MANSPDunning block MANSPCHAR1T040SMANSP
DGUEL_KPCondition Item Valid From DGUEL_KPDATS8DATUM
NSTUFELevel number of condition item for recurring payments NSTUFENUMC2NUMC2
DBPERIODPeriod start VVDBPERIODDATS8DATUM
SPAEXCLExclusive Indicator for Start Date of a Period TFMSPAEXCLNUMC1TFMSPAEXCL
SPAULTMonth-End Indicator for Start Date of a Period TFMSPAULTCHAR1VVSULT
DEPERIODPeriod End VVDEPERIODDATS8DATUM
SPEINCLInclusive Indicator for End Date of a Period TFMSPEINCLNUMC1TFMSPEINCL
SPEULTMonth-End Indicator for End of a Period TFMSPEULTCHAR1VVSULT
SSTCKKZAccrued interest method SSTCKKZCHAR1SSTCKKZ
NORDEROrder Number NORDERNUMC8NUM8ORD
RKONTQuota number RKONTNUMC6RKONTRKT
DAUSZLead date for withholding amounts for disbursement VVDAUSZDATS8DATUM
SSOLISTCalculation using actual principle (or debit) SSOLISTCHAR1CHAR1
RDARNEHMBorrower/Applicant Number RDARNEHM_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
BKONDCondition item currency amount BKONDCURR13(2) WERTV7
SBERECHGrace Period Interest Method SBERECHCHAR1XFELD
BKARZINSInt.for days betw. redemption clear.and pmnt (FiMa-internal) TFMBKAZINSCURR13(2) TFM_WRTV7
BTITALKImputed annuity repayment amount (FiMa internal) TFMBTIKALKCURR13(2) TFM_WRTV7
RERFEntered by RERFCHAR12SYCHAR12
DERFFirst Entered on DERFDATS8DATUM
TERFTime of Initial Entry TERFTIMS6TIMES
REHERSource of initial entry REHERCHAR10CHAR10
RBEAREmployee ID RBEARCHAR12SYCHAR12
DBEARLast Edited on DBEARDATS8DATUM
TBEARLast Edited at TBEARTIMS6TIMES
RBHEREditing Source RBHERCHAR10CHAR10
HDN_KUNNRMain Borrower Customer Number HDN_KUNNRCHAR10Assigned to domainALPHAKUNNR
SZARTPayment transaction TB_SZARTCHAR1XFELD
RUZBELAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
REBZJFiscal Year of the Relevant Invoice (for Credit Memo) REBZJNUMC4GJAHRGJAHR
REBZGNumber of the Invoice the Transaction Belongs to REBZGCHAR10ALPHABELNR
REBZZLine Item in the Relevant Invoice REBZZNUMC3BUZEI
S_SSDREFReference flow category in borrower's note loan flow records VVS_SSDREFCHAR4Assigned to domainSBEWZITI
PWKURSSecurity price for percentage quotation PWKURSDEC10(7) PWKURS
DZFESTInterest rate fixing date TB_DZFESTDATS8DATUM
XPOREIndicator: Individual Payment? PRQ_XPORECHAR1XFELD
SPAYRQGenerate payment request TB_SPAYRQKCHAR1XFELD
PRKEYKey Number for Payment Request PRQ_KEYNOCHAR10Assigned to domainALPHAPRQ_KEYNO
HBKIDShort Key for a House Bank HBKIDCHAR5T012HBKID
HKTIDID for account details HKTIDCHAR5T012KHKTID
VORGTYPActivity Category (Posting Area) VORGTYP_LOCHAR4VORGTYP_LO
ACENVSource in TR-LO posting area ACENV_LONUMC4ACENV_LO
SSIGNDirection of flow TB_SSIGNCHAR1T_SSIGN
SPRSNGIndividual payment TB_SPRSNGKCHAR1XFELD
UZAWEPayment Method Supplement UZAWECHAR2T042FUZAWE
SPRGRDDetermine grouping definition TB_SPRGRDCHAR1T_SPRGRD
SCSPAYSame direction necessary for joint payment? TB_SCSPAYCHAR1XFELD
ZWELSList of the Payment Methods to be Considered DZWELSCHAR10ZWELS
PAYGRGrouping Field for Automatic Payments PAYGRCHAR20CHAR20
JEXPOZINSExponential Interest Calculation TB_JZINSRECHAR1XFELD
SREVALEXCLPrice gains w/o proportionate gains from deferral write-back VVSREVALEXCLCHAR1XFELD
SROUNDRounding Category TFM_SROUNDCHAR1TFM_SROUND
SKALIDWTInterest Calendar TFMSKALIDWTCHAR2Assigned to domainWFCIDH_TFACD
JVERFIndicator whether drawings exist for the disbursement JVERFCHAR1JVERF
PPAYMENTPayment Rate TFM_PPAYMENTDEC11(7) TFM_PPAYMENT
AMMRHYZVInterest Settlement Frequency for Exponential Interest Calc. TFM_AMMRHYZVNUMC2TFM_AMMRHYZV
LC_CAPITALSEffect of the Flow on Capital Amounts Status TB_LC_CAPITALSCHAR2T_LC_CASH_FLOW
LC_DISBURSEEffect of the Flow on the Disbursement Status TB_LC_DISBURSECHAR2T_LC_CASH_FLOW
DFAELL_OLD_EXTOld Due Date TB_EXTENS_DFAELL_OLDDATS8DATUM
DDISPO_OLD_EXTOld Payment Date TB_EXTENS_DDISPO_OLDDATS8DATUM
RBO_EXTBusiness Operation Number (Loans) RBOCHAR15RBO
SBEWEGRP2Flow Record Group in Cash Flow Calculator (Incoming Payment) TB_FLOW_REC_GRPNUMC6SBEWEGRP2
SUSP_REASON_TYPEKey for Overpayment Reason TB_SUSPREASONNUMC3Assigned to domainT_SUSPREASON
BILL_NUMBERBill Number TB_BILL_NUMBERCHAR15ALPHAT_BILL_NUMBER
BILL_DUE_DATEDue Date for Bill TB_BILL_DUE_DATEDATS8DATUM
MNDIDUnique Referene to Mandate per Payment Recipient SEPA_MNDIDCHAR35ID035
REMIT_INFOPayment Notes Info TB_REMIT_INFOCHAR140T_REMIT_INFO
.INCLU--AP 0
CUST_EXT1Data element 1 for customer enhancements (VDBEPI) TB_CUST_EXT1CHAR30TB_CUST_EXT1_DOM
CUST_EXT2Data element 2 for customer enhancements (VDBEPI) TB_CUST_EXT2CHAR30TB_CUST_EXT2_DOM
CUST_EXT3Data element 3 for customer enhancements (VDBEPI) TB_CUST_EXT3CHAR30TB_CUST_EXT3_DOM
.INCLU--AP 0
BROUNDUNITRounding Unit for Amounts TB_BROUNDUNIT_ADEC13(7) TFMSRUNIT
SANLFProduct Category SANLFNUMC3Assigned to domainVVSANLF
RANLContract Number RANLCHAR13ALPHARANLRAN
DGUEL_KKDate Condition Effective from DGUELDATS8DATUM
NLFD_ANGOffer consecutive number NLFD_ANGNUMC3LFNR3
RKLAMMERClassification Number for Finance Projects RKLAMMERCHAR13ALPHARANL
DVORGANGActivity date DVORGANGDATS8DATUM
SVORGANGBusiness Operation (Activity) SVORFALLCHAR4SVORFALL
NVORGANGActivity number NVORGANGCHAR3CHAR3
SSTATIStatus of data record SSTATINUMC2Assigned to domainSTATI
RREFKONTAccount Assignment Reference in Financial Assets Management RREFKONTCHAR8Assigned to domainUSTRUKRE
HKONTGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
SBLARTDocument Type BLARTCHAR2Assigned to domainBLARTBAR
DBLDATDocument Date in Document BLDATDATS8DATUM
DBUDATPosting Date in the Document BUDATDATS8DATUM
DGJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
DMONATFiscal Period MONATNUMC2MONAT
SSTORNOReversal indicator SSTORNOCHAR1SSTORNO
SSTOGRDReason for Reversal SSTOGRDCHAR2Assigned to domainSSTOGRD
ZUONRAssignment Number DZUONRCHAR18ZUONR
RSTBLGDocument Number of Reversed Document TB_REVERSAL_OFCHAR10ALPHARBELKPFD
RZEBELDoc.no. of debit pos. doc.header (only for inc.pmnt records) RZEBELCHAR10ALPHARBELKPFD
DORDEROrder day DORDERDATS8DATUM
DANJRNLDate of transferal to journal DANJRNLDATS8DATUM
DANFIBUDate of transferal to FiAc DANFIBUDATS8DATUM
UANFIBUTime of transfer to financial accounting UANFIBUTIMS6TIMES
SSTCKTGAccrued interest: Daily method SSTCKTGCHAR1SZBMETH
PEFFZINSEffective Interest Rate PEFFZINSDEC10(7) DEC3_7
SEFFMETHEffective Interest Method (Financial Mathematics) SEFFMETHNUMC1SEFFMETH
DSTOCKPremium reserve fund date VVDSTOCKDATS8DATUM
RPNNRDaybook no. VVRPNNRCHAR10VVRPNNR
RVZBLGAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
RPNSUPSuper prima nota for grouping in autom.deb.pos. VVRPNSUPCHAR10VVRPNNR
RUMBLGReference transfer document number UMBLGCHAR10ALPHABELNR
RUZBELKPFAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
SEVALPOSTPEC for flow executed indicator yes/no SEVALPOSTCHAR1XFELD
SBEWAGRPFlow type group SBAGRPCHAR2Assigned to domainSBEWAGRP
SFIBUControl entry of overpayment and advance payment data VVSFIBUCHAR2VVSFIBU
XBEWARTName of flow type XBEWARTCHAR30TEXT30
SBTRSDebit amount in display currency SBCWHRCURR13(2) WERT7
SBTRHCredit amount in display currency HBCWHRCURR13(2) WERT7
SBTRSUMAmount in Display Currency SUMBCWHRCURR13(2) WERT7
SBTRWHRDisplay currency SSCWHRCUKY5Assigned to domainWAERS
SHWHRLocal currency SHWHRCUKY5Assigned to domainWAERS
GPRESTOPBusiness Partner Assigned to Open Items in General Ledger T_BP_RESTOPCHAR10Assigned to domainALPHABU_PARTNER
ICON_SREORGIndicator For Reorganization Record (Doc. Data Archiving) ICON_SREORGCHAR4Assigned to domainICON
COLORField For Color COLOUR_CODECHAR3COLOUR_CODE
XMARKIndicator: Line selected XMARKCHAR1XFELD
CHANGEDLine Was Changed TB_ROW_CHANGEDCHAR1T_ROW_CHANGED
SIOA_LOCK_CHKBXLocked for Interest on Arrears TB_FLG_IOA_LOCKCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP structure VDBEPI_ADD using ABAP code?

As VDBEPI_ADD is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on VDBEPI_ADD as there is no data to select.

How to access SAP table VDBEPI_ADD

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