SAP VDBOBEPP Business Operation: Entered and Activated Flow Data Table

Overview

VDBOBEPP is a standard SAP S/4HANA table that stores Business Operation: Entered and Activated Flow Data data. There are total 207 fields in the VDBOBEPP table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VDBOBEPP belongs to Loans Management (FS-CML) module and is located in the package Treasury Loans (FVVD).

In addition, following links provide an overview of foreign key relationships, if any, that link VDBOBEPP to other SAP tables and standard CDS views available based on VDBOBEPP table in S/4HANA 2020.

Techincal Settings of VDBOBEPP

Below are technical details of the table VDBOBEPP

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of VDBOBEPP Fields

The following table gives you an overview of the fields available in VDBOBEPP

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
BUKRSCompany CodeBUKRST001CHAR4
RANLContract NumberRANLCHAR13
DTRANSFlow data key: System dateVVDTRANSDATS8
TTRANSTransaction data key: system timeVVTTRANSTIMS6
NTRANSTransaction data key: Consecutive numberVVNTRANSNUMC4
RERFEntered ByRERFCHAR12
DERFFirst Entered OnDERFDATS8
TERFTime of CreationTERFTIMS6
REHERSource of Initial EntryREHERCHAR10
RBEAREmployee IDRBEARCHAR12
DBEARLast Edited OnDBEARDATS8
TBEARLast Edited AtTBEARTIMS6
RBHEREditing SourceRBHERCHAR10
DVORGANGActivity dateDVORGANGDATS8
SVORGANGBusiness Operation (Activity)SVORFALLCHAR4
NVORGANGActivity numberNVORGANGCHAR3
SBEWARTFlow TypeSBEWART*CHAR4
SREFBEWReference flow typeSREFBEW*CHAR4
SBEWZITIFlow categorySBEWZITI*CHAR4
SPLANISTPlan/actual record/record to be released indicatorSPLANISTCHAR1
SSOLHABDebit/credit indicatorVVSSOLHABCHAR1
SSTORNOReversal indicatorSSTORNOCHAR1
SSTOGRDReason for ReversalSSTOGRDTZSTCHAR2
ZUONRAssignment numberDZUONRCHAR18
RSTBLGReverse Document NumberSTBLGCHAR10
SGTXTItem TextSGTXTCHAR50
SANLFProduct CategorySANLF*NUMC3
DGUEL_KKDate Condition Effective fromDGUELDATS8
NLFD_ANGOffer consecutive numberNLFD_ANGNUMC3
SSTATIStatus of data recordSSTATI*NUMC2
GSARTProduct TypeVVSARTTZPABCHAR3
RREFKONTAccount Assignment Reference in Financial Assets ManagementRREFKONTT037SCHAR8
GSBERBusiness AreaGSBERTGSBCHAR4
DORDEROrder dayDORDERDATS8
NORDEROrder NumberNORDERNUMC8
BNWHRNominal amountBNWHRCURR13
SNWHRCurrency of nominal amountSNWHRTCURCCUKY5
BBWHRAmount in position currencyBBWHRCURR13
SBWHRPosition Currency (Currency of Position Amount)SBWHRTCURCCUKY5
BCWHRSettlement AmountBCWHRCURR13
SCWHRSettlement CurrencySCWHRTCURCCUKY5
BHWHRAmount in local currencyBHWHRCURR13
KURS1Exchange rateVVKURSFDEC9
KURS2Exchange rateVVKURSFDEC9
DVALUTCalculation DateDVALUTDATS8
DFAELLDue date/calculation dateDFAELLIGDATS8
DDISPOPayment DateDDISPODATS8
DBESTANDPosition value dateDBESTANDDATS8
DBERVONStart of Calculation PeriodDBERVONDATS8
DBERBISEnd of Calculation PeriodDBERBISDATS8
ATAGENumber of DaysVVATAGENUMC6
ABASTAGENumber of base days in a calculation periodABASTAGENUMC6
SZBMETHInterest Calculation MethodSZBMETHCHAR1
UMSKZSpecial G/L IndicatorUMSKZ*CHAR1
KOSTLCost CenterKOSTL*CHAR10
SSPESENExpenses keySSPESENCHAR1
RSOLLAccount for debit postingRSOLLSKA1CHAR10
RHABENAccount for credit postingRHABENSKA1CHAR10
RZKSOLLDebit interim accountRZKSOLLSKA1CHAR10
RZKHABECredit interim accountRZKHABESKA1CHAR10
SBSLSOLLPosting KeyBSCHLTBSLCHAR2
SBSLZKSOPosting KeyBSCHLTBSLCHAR2
SBSLZKHAPosting KeyBSCHLTBSLCHAR2
SHSLHABENPosting KeyBSCHLTBSLCHAR2
RBANKKBank accountRBANKKSKB1CHAR10
SFDLEVPlanning LevelFDLEVT036CHAR2
JFDUPDRecord transferred to cash management and forecastJFDUPDCHAR1
JONLAENIndicator for fixing a flow recordJONLAENCHAR1
JZINSBASFlow in interest baseJZINSBASCHAR1
JZINSZPTInterest dateJZINSZPTCHAR1
PKONDPercentage rate for condition itemsPKONDDEC10
BBASISCalculation Base AmountBBASISCURR13
SSORTZITSort indicator for interest/repayment schedule calculationsSSORTZITCHAR1
SWOHERSource of flow recordSWOHERCHAR1
SSTCKKZAccrued interest methodSSTCKKZCHAR1
SSTCKTGAccrued interest: Daily methodSSTCKTGCHAR1
PEFFZINSEffective Interest RatePEFFZINSDEC10
SEFFMETHEffective Interest Method (Financial Mathematics)SEFFMETHNUMC1
JVERFIndicator whether drawings exist for the disbursementJVERFCHAR1
KUNNRCustomer NumberKUNNRKNA1CHAR10
BVTYPPartner bank typeBVTYPCHAR4
ZLSCHPayment MethodDZLSCHT042ZCHAR1
MABERDunning AreaMABERT047MCHAR2
ZAHLSBlock Key for PaymentDZAHLST008CHAR1
RPARTNRBusiness Partner NumberBP_PARTNR_NEWBUT000CHAR10
SROLEXTDummy functionDUMMY_3CHAR3
RKLAMMERClassification Number for Finance ProjectsRKLAMMERCHAR13
JEINBEHALTIndicator for withholding of amount during disbursementVVJEINBECHAR1
SZEGENGenerate Incoming Payment ImmediatelySZEGEN*NUMC2
MWSKZTax on sales/purchases codeMWSKZT007ACHAR2
DTRANSREFFlow data key: System dateVVDTRANSDATS8
TTRANSREFTransaction data key: system timeVVTTRANSTIMS6
NTRANSREFTransaction data key: Consecutive numberVVNTRANSNUMC4
RPNNRDaybook no.VVRPNNRCHAR10
HBKIDShort Key for a House BankHBKIDT012CHAR5
SBUSTPosting control keyVVSBUSTTZB09NUMC2
PWKURSSecurity price for percentage quotationPWKURSDEC10
DSTOCKPremium reserve fund dateVVDSTOCKDATS8
JVORAUSID for planned record reference to an advance paymentVVJVORAUSCHAR1
AMMRHYFrequency in monthsAMMRHYNUMC3
SKOARTCondition Type (Smallest Subdivision of Condition Records)SKOARTTZK01NUMC4
SEXCLVONExclusive Indicator for the Start of a Calculation PeriodVVSEXCLVONNUMC1
SULTVONMonth-End Indicator for Start of a Calculation PeriodVVSULTVONCHAR1
SINCLBISInclusive Indicator for the End of a Calculation PeriodVVSINCLBISNUMC1
SULTBISMonth-End Indicator for the End of a Calculation PeriodVVSULTBISCHAR1
SINCLInclusive indicator for beginning and end of a periodVVSINCLNUMC1
DVERRECHSettlement dateVVDVERRECHDATS8
DPKONDFixing Date of Percentage Rate from ConditionVVDPKONDDATS8
RUMBLGReference transfer document numberUMBLGCHAR10
ZINKZExempted from Interest CalculationDZINKZCHAR2
SVULTMonth-End Indicator for Value DateVVSVULTCHAR1
JSOFVERRImmediate settlementJSOFVERRCHAR1
SINCLVERRInclusive Indicator for Clearing DateVVSINCLVERNUMC1
SULTVERRMonth-End Indicator for Clearing DateVVSULTVERRCHAR1
SREFZITIRefer.flow category in accrual/deferral flow recordsVVSREFZITI*CHAR4
STGBASISBase Days MethodVVSTGBASISCHAR1
STGMETHDaily MethodVVSTGMETHNUMC1
SBASISCalculation base referenceVVSBASISTZFBCHAR4
SBERFIMACalculation category for cash flow calculatorSBEWFIMAAT40CHAR4
SVORGKZActivity indicator for debit/credit controlVVSVORGKZNUMC2
MANSPDunning BlockMANSPT040SCHAR1
DGUEL_KPCondition Item Valid FromDGUEL_KPDATS8
NSTUFELevel number of condition item for recurring paymentsNSTUFENUMC2
DBPERIODPeriod startVVDBPERIODDATS8
SPAEXCLExclusive Indicator for Start Date of a PeriodTFMSPAEXCLNUMC1
SPAULTMonth-End Indicator for Start Date of a PeriodTFMSPAULTCHAR1
DEPERIODPeriod EndVVDEPERIODDATS8
SPEINCLInclusive Indicator for End Date of a PeriodTFMSPEINCLNUMC1
SPEULTMonth-End Indicator for End of a PeriodTFMSPEULTCHAR1
RKONTQuota numberRKONTNUMC6
DAUSZLead date for withholding amounts for disbursementVVDAUSZDATS8
SSOLISTCalculation using actual principle (or debit)SSOLISTCHAR1
RDARNEHMBorrower/Applicant NumberRDARNEHM_NEWCHAR10
BKONDCondition Item Currency AmountBKONDCURR13
RZEBELDocument number of waiver/write-off documentVEBLGNRCHAR10
ZFBDTPayment DateDDISPODATS8
DZFESTInterest rate fixing dateTB_DZFESTDATS8
SBERECHGrace Period Interest MethodSBERECHCHAR1
BKARZINSInt.for days betw. redemption clear.and pmnt (FiMa-internal)TFMBKAZINSCURR13
BTITALKImputed annuity repayment amount (FiMa internal)TFMBTIKALKCURR13
HDN_KUNNRMain Borrower Customer NumberHDN_KUNNRKNA1CHAR10
SZARTPayment TransactionTB_SZARTCHAR1
RUZBELAccounting Document NumberBELNR_DCHAR10
REBZJFiscal Year of the Relevant Invoice (for Credit Memo)REBZJNUMC4
REBZGDocument No. of the Invoice to Which the Transaction BelongsREBZGCHAR10
REBZZLine Item in the Relevant InvoiceREBZZNUMC3
S_SSDREFReference flow category in borrower's note loan flow recordsVVS_SSDREF*CHAR4
SAENDChange Indicator for FiMa Flow RecordsTFM_SAENDNUMC1
XPOREIndicator: Individual Payment?PRQ_XPORECHAR1
SPAYRQGenerate Payment RequestTB_SPAYRQKCHAR1
PRKEYKey Number for Payment RequestPRQ_KEYNO*CHAR10
HKTIDID for Account DetailsHKTIDT012KCHAR5
VORGTYPActivity Category (Posting Area)VORGTYP_LOCHAR4
ACENVSource in TR-LO posting areaACENV_LONUMC4
SSIGNDirection of FlowTB_SSIGNCHAR1
SPRSNGIndividual PaymentTB_SPRSNGKCHAR1
UZAWEPayment method supplementUZAWET042FCHAR2
SPRGRDDetermine Grouping DefinitionTB_SPRGRDCHAR1
SCSPAYSame Direction Necessary for Joint Payment?TB_SCSPAYCHAR1
ZWELSList of Respected Payment MethodsDZWELSCHAR10
PAYGRGrouping Field for Automatic PaymentsPAYGRCHAR20
JEXPOZINSType of Compound Interest CalculationTFM_SINTCOMPCHAR1
SREVALEXCLPrice gains w/o proportionate gains from deferral write-backVVSREVALEXCLCHAR1
RBOBusiness Operation Number (Loans)RBOCHAR15
SROUNDRounding CategoryTFM_SROUNDCHAR1
SKALIDWTInterest CalendarTFMSKALIDWTCHAR2
PPAYMENTPayment RateTFM_PPAYMENTDEC11
AMMRHYZVInterest Settlement Frequency for Exponential Interest Calc.TFM_AMMRHYZVNUMC2
LC_CAPITALSEffect of the Flow on Capital Amounts StatusTB_LC_CAPITALSCHAR2
LC_DISBURSEEffect of the Flow on the Disbursement StatusTB_LC_DISBURSECHAR2
OP_APPLICATIONOpen Item Tool: Application KeyTB_OPAPPLNUMC2
OP_RBOOI Tool: Locking Business OperationTB_OP_RBOCHAR15
DFAELL_OLD_EXTOld Due DateTB_EXTENS_DFAELL_OLDDATS8
DDISPO_OLD_EXTOld Payment DateTB_EXTENS_DDISPO_OLDDATS8
RBO_EXTBusiness Operation Number (Loans)RBOCHAR15
SBEWEGRP2Flow Record Group in Cash Flow Calculator (Incoming Payment)TB_FLOW_REC_GRPNUMC6
SUSP_REASON_TYPEKey for Overpayment ReasonTB_SUSPREASONTDSUSPREASONNUMC3
MNDIDUnique Reference to Mandate for each PayeeSEPA_MNDIDCHAR35
SBEWEGRPFlow record group in cash flow calculatorSBEWEGRPNUMC4
REMIT_INFOPayment Notes InfoTB_REMIT_INFOCHAR140
DIP_KUKEYDIP Short KeyFVD_DIP_KUKEYFEBEPNUMC8
DIP_ESNUMDIP Line Item NumberFVD_DIP_ESNUMFEBEPNUMC5
DIP_IDID (Differentiated Incominmg Payment)TB_DIP_IDVDDIP_IDCHAR4
DIP_DATEDate (Differentiated Incoming Payment)TB_DIP_DATEDATS8
FLG_IP_CLI_NOTICEPayment created by CLI noticeTB_FLG_IP_CLI_NOTICECHAR1
AAVGDAYSNo. of Days for Interest Calc. with Average Interest RateTFM_AAVGDAYSINT410
PAVGINTERESTAverage Interest RateTFM_PAVGINTERESTDEC15
JAVGCAPUse Upper Limit of Average Interest RateTFM_JAVGCAPCHAR1
PAVGCAPUpper Limit of Average Interest RateTFM_PAVGCAPDEC15
JAVGFLOORUse Lower Limit of Average Interest RateTFM_JAVGFLOORCHAR1
PAVGFLOORLower Limit of Average Interest RateTFM_PAVGFLOORDEC15
PAVGSPREADAverage Interest Rate SpreadTFM_PAVGSPREADDEC15
SROUNDAVGINTERESTRounding Category of Average Interest RateTFM_SROUNDAVGINTERESTCHAR1
ROUNDDECAVGINTERESTNumber of Rounding Decimal Places for Average Interest RateTFM_ROUNDDECAVGINTERESTINT13
AAVGWEIGHTWeighting of Interest RateTFM_AWEIGHTINT410
AAVGWEIGHTSUMCumulative Weighting of Interest RateTFM_AWEIGHTSUMINT410
JEXPOINTFACTORExponential Interest Calculation with FactorTFM_JEXPOINTFACTORCHAR1
FLOWFACTORFlow FactorTFM_FLOWFACTORD34R34
BASEFACTORBase FactorTFM_BASEFACTORD34R34
SFACTORRESETEvent for Resetting Factor CalculationTFM_SFACTORRESETCHAR1
CA_DTRANSFlow data key: System dateVVDTRANSDATS8
CA_TTRANSTransaction data key: system timeVVTTRANSTIMS6
CA_NTRANSTransaction data key: Consecutive numberVVNTRANSNUMC4
CA_FLG_ORGFlow is orginal flow for customer specific dependent flow(s)TB_FLG_CUST_ORGCHAR1
BROUNDUNITRounding Unit for AmountsTB_BROUNDUNIT_ADEC13
SEPA_PDPosting Date in the DocumentBUDATDATS8

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VDBOBEPP

Table NameFieldCardinalityCheck Table
VDBOBEPPBUKRS1: CNT001
VDBOBEPPDIP_ESNUM:FEBEP
VDBOBEPPDIP_ID:VDDIP_ID
VDBOBEPPDIP_KUKEY:FEBEP
VDBOBEPPGSART1: CNTZPAB
VDBOBEPPGSBER:TGSB
VDBOBEPPHBKID1: CNT012
VDBOBEPPHDN_KUNNRC: CNKNA1
VDBOBEPPHKTID:T012K
VDBOBEPPKUNNRC: CNKNA1
VDBOBEPPMABER1: CNT047M
VDBOBEPPMANDT1: CNT000
VDBOBEPPMANSP:T040S
VDBOBEPPMWSKZ:T007A
VDBOBEPPRBANKK1: CNSKB1
VDBOBEPPRHABEN1: 1SKA1
VDBOBEPPRPARTNR1: CNBUT000
VDBOBEPPRREFKONT:T037S
VDBOBEPPRSOLL1: 1SKA1
VDBOBEPPRZKHABE1: 1SKA1
VDBOBEPPRZKSOLL1: 1SKA1
VDBOBEPPSBASIS:TZFB
VDBOBEPPSBERFIMA:AT40
VDBOBEPPSBSLSOLL1: CNTBSL
VDBOBEPPSBSLZKHA1: CNTBSL
VDBOBEPPSBSLZKSO1: CNTBSL
VDBOBEPPSBUST1: CNTZB09
VDBOBEPPSBWHR1: CNTCURC
VDBOBEPPSCWHR1: CNTCURC
VDBOBEPPSFDLEV1: CNT036
VDBOBEPPSHSLHABEN1: CNTBSL
VDBOBEPPSKOART1: CNTZK01
VDBOBEPPSNWHR1: CNTCURC
VDBOBEPPSSTOGRD1: CNTZST
VDBOBEPPSUSP_REASON_TYPE:TDSUSPREASON
VDBOBEPPUZAWE:T042F
VDBOBEPPZAHLS1: CNT008
VDBOBEPPZLSCH:T042Z

Other References