VDBEPI SAP (Posted line items for document header) Table details

Dictionary Type: Table
Description: Posted line items for document header




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




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

VDBEPI is a standard SAP Table which is used to store Posted line items for document header data and is available within R/3 SAP systems depending on the version and release level.

The VDBEPI table consists of various fields, each holding specific information or linking keys about Posted line items for document header data available in SAP. These include BUKRS (Company Code), RBELKPFD (Document Number of Document Header (Loan)), RPOSNR (Activity number), SBEWART (Flow 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 VDBEPI 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 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

Key field Non-key field



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

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

SELECT SINGLE *
FROM VDBEPI
INTO CORRESPONDING FIELDS OF WA_VDBEPI
WHERE...

How to access SAP table VDBEPI

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