VDFLOW SAP (Loans: Cumulative Values) Structure details

Dictionary Type: Structure
Description: Loans: Cumulative Values




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




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

VDFLOW 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 "Loans: Cumulative Values" 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_VDFLOW TYPE VDFLOW.

The VDFLOW table consists of various fields, each holding specific information or linking keys about Loans: Cumulative Values data available in SAP. These include BISDAT (Date of evaluation end), RSTICH (Key date reference), MANDT (Client), BUKRS (Company Code).. 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: Can be enhanced (character-type or numeric)


SAP VDFLOW 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
VONDATStart Date of Evaluation DVONDATDATS8DATUM
BISDATDate of evaluation end DBISDATDATS8DATUM
RSTICHKey date reference RSTICHCHAR1RSTICH
MANDTClient MANDTCLNT3T000MANDT
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
RANLVDContract Number RANLCHAR13ALPHARANLRAN
SSTATIStatus of data record SSTATINUMC2TZC37STATI
SANLFProduct Category SANLFNUMC3TZAFVVSANLF
GSARTProduct Type VVSARTCHAR3TZPAVVSARTSANVVSART_APPL_BAS
SBILKBalance Sheet Indicator SBILKCHAR2TW11SBILK
RPORTBPortfolio RPORTBCHAR10TWPOBRPORTBT50H_RPORTB_CORE
SGLZBSCB asset group indicator SGLZBCHAR4TW07SGLZB
SHWHRLocal currency SHWHRCUKY5TCURCWAERS
RDARNEHMLoan partner TB_RDARNEHMCHAR10BUT000ALPHABU_PARTNER
DZUSAGELoan - Date of Commitment by Lender DZUSAGEDATS8DATUM
DBLFZStart of Term DBLFZDATS8DATUM
DELFZEnd of Term DELFZDATS8DATUM
DBFSZDate of start of fixed period VVDBFSZDATS8DATUM
DEFSZDate of fixed period end VVDEFSZDATS8DATUM
RKLAMMERClassification Number for Finance Projects RKLAMMERCHAR13ALPHARANL
XAKTFile Number XAKTCHAR32CHAR32
SDTYPLoans Class VVSDTYPNUMC3TD02VVSDTYP
STITELLoan Type Indicator STITELNUMC3TD03STITEL
SFRISTLoan Term SFRISTNUMC2TD09SFRIST
SSICHERPrimary collateral SSICHERCHAR4TD01SSICH
SVZWECKPurpose of Loan SVZWECKCHAR2TD07SVZWK
DBEWIApproval date VVDBEWIDATS8DATUM
SBEALoan Processing Indicator VVSBEANUMC2VVSBEA
SSOLISTPlan/Actual principle VVSSOLISTCHAR1VVSSOLIST
SDUNNCMPSummarization Level for Dunning Letter SDUNNCMPCHAR2SDUNNCMP
XNODUNNExclude Loan from Dunning Run XNODUNNCHAR1XFELD
MABERDunning Area MABERCHAR2T047MMABER
MAHNSDunning level MAHNS_DNUMC1MAHNS
MADATLast dunned on MADATDATS8DATUM
SMAHNMLoan Manual Dunning Level VVSMAHNMCHAR1TDMAHNS_MANVVSMAHNM
ZUONDAssignment TB_ZUONDCHAR18TEXT18
REFERInternal Reference TB_REFERCHAR16CHAR16
MERKMCharacteristics TB_MERKMCHAR25CHAR25
SSONDERSpecial treatment of loan SSONDERNUMC2TD10SSONDER
SB_VERTRAGContract clerk SB_VERTRAG_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
SB_BUCHHAccounting clerks SB_BUCHH_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
SB_PROLORollover clerk SB_PROLO_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
SFIWOIndicator: Type of Residential Object Financing SFIWOCHAR2TD15SFIWO
SOBJARTObject type SOBJARTNUMC2TIV5ASOBJART
SNUTZARTMain usage type of object VVSNUTZNUMC4TIV01SNUNR
RANLALT1Alternative Identification RANLALT1CHAR13CHAR13
RANLALT2Alternative identification 2 RANLALT2CHAR13CHAR13
SGR1Group Key 1 (Freely Available) SGRP1CHAR6TDDG1SGRP1
SGR2Group Key 2 (Freely Available) SGRP2CHAR6TDDG2SGRP2
SGRP3Group Key 3 (Freely Available) SGRP3CHAR6TDDG3SGRP3
SGRP4Group Key 4 (Freely Available) SGRP4CHAR6TDDG4SGRP4
SAKTPASIndicator: Asset/Liability Transaction VVSAKTPASCHAR1VVSAKTPAS
SFIBGAsset Grouping Indicator SFIBGNUMC4TW08SFIBG
SREGIONSales Region VVSREGIONCHAR4TD18VVSREGION
SGESSTBranch Office VVSGESSTCHAR4TD17VVSGESST
SOBEZOrganizational District VVSOBEZCHAR2CHAR2
SBEZIRKAgent District VVSBEZIRKCHAR4CHAR4
LC_CAPITALSProcessing Characteristic: Status of Capital Amounts TB_LC_CHARAC_CAPITALSCHAR1Assigned to domainT_LC_CHARACVALUEH_VD_CHARAC_CAPITALS
LC_DISBURSEMENTProcessing Characteristic: Disbursement Status TB_LC_CHARAC_DISBURSEMENTCHAR1Assigned to domainT_LC_CHARACVALUEH_VD_CHARAC_DISBURSEMENT
GUARANTORBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
NAVALGuarantee number VVNAVALCHAR15CHAR15
SBEWARTFlow Type SBEWARTCHAR4TZB0ASBEWART
SBEWZITIFlow category SBEWZITICHAR4TZB03SBEWZITI
RREFKONTAcct Assignment Ref. for Operative Valn Area and Loan TB_REFKONTCHAR8T037SUSTRU
HKONTGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
BUCHST_DLPosting status of flow for loans BUCHST_DLCHAR1BUCHST_DL
SVORGKZActivity indicator for debit/credit control VVSVORGKZNUMC2VVSVORGKZ
SSTORNOReversal indicator SSTORNOCHAR1SSTORNO
SSTOGRDReason for Reversal SSTOGRDCHAR2Assigned to domainSSTOGRD
GL_ACCOUNT_DNumber of G/L Account: Debit FTI_GLACC_DCHAR10SKB1ALPHASAKNRSAKC_SAKNR
GL_ACCOUNT_CNumber of G/L Account: Credit FTI_GLACC_CCHAR10SKB1ALPHASAKNRSAKC_SAKNR
RVZBLGAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
DBUDATPosting Date in the Document BUDATDATS8DATUM
DGJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
DMONATFiscal Period MONATNUMC2MONAT
DDISPOPayment Date DDISPODATS8DATUM
DVALUTCalculation Date DVALUTDATS8DATUM
DFAELLDue date DFAELLDATS8DATUM
RAHABKIShort key for own house bank TB_RHABKICHAR5Assigned to domainHBKID
RAHKTIDShort key for house bank account TB_RHKTIDCHAR5Assigned to domainHKTID
RPZAHLPayer/payee TB_RPZAHL_NEWCHAR10BUT000ALPHABU_PARTNERBPABUPA
RPBANKPartner bank details TB_RPBANKCHAR4BVTYP
ZLSCHPayment Method DZLSCHCHAR1T042ZZLSCH
SPAYRQGenerate payment request TB_SPAYRQKCHAR1XFELD
LAND1Country key of company code FTI_LAND1CHAR3T005LAND1LND
SSIGNDirection of flow TB_SSIGNCHAR1T_SSIGN
BZBETRPayment Amount in Payment Currency TB_BZWR_ACURR15(2) WERTV8
BHWBETRPayment amount in local currency TB_BZHW_ACURR15(2) WERTV8
WZBETRPayment Currency TB_WZBETRCUKY5TCURCWAERS
BBWHRFlow Amount in Position Currency TB_BBWR_ACURR15(2) WERTV8
BHWHRFlow Amount in Local Currency TB_BBHW_ACURR15(2) WERTV8
SBWHRPosition Currency/Transaction Currency TB_BWHRCUKY5TCURCWAERS
D_BNBW_AAsset: Change in nominal value in position currency D_BNOMBW_ACURR15(2) WERTV8_TR
D_BNBW_PLiability: Change in nominal value in position currency D_BNOMBW_PCURR15(2) WERTV8_TR
D_AWBW_AChange in acquisition value in position currency (asset) D_AWBW_ACURR15(2) WERTV8_TR
D_AWHW_AChange in acquisition value in local currency (asset) D_AWHW_ACURR15(2) WERTV8_TR
D_AWBW_PChange in acquisition value in position currency (liability) D_AWBW_PCURR15(2) WERTV8_TR
D_AWHW_PChange in acquisition value in local currency (liability) D_AWHW_PCURR15(2) WERTV8_TR
D_BWBW_AChange in book value in position currency (asset) D_BWBW_ACURR15(2) WERTV8_TR
D_BWHW_AChange in book value in local currency (asset) D_BWHW_ACURR15(2) WERTV8_TR
D_BWBW_PChange in book value in position currency (liability) D_BWBW_PCURR15(2) WERTV8_TR
D_BWHW_PChange in book value in local currency (liability) D_BWHW_PCURR15(2) WERTV8_TR
EEBETRProfit/loss amount in profit/loss currency EEBETRCURR13(2) WERTV7
EHBETRProfit/loss amount in local currency EHBETRCURR13(2) WERTV7
SPLWHRProfit/loss currency SPLWHRCUKY5TCURCWAERS
PABGERFPLRevenue Accrued/Deferred in Profit/Loss Currency PABGERFPLWCURR15(2) WERTV8_TR
PABGERFHWRevenue Accrued/Deferred in Local Currency PABGERFHWCURR15(2) WERTV8_TR

Key field Non-key field



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

As VDFLOW 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 VDFLOW as there is no data to select.

How to access SAP table VDFLOW

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