VDSTATE SAP (Loans: Non-Cumulative Values for Drilldown Reporting) Structure details

Dictionary Type: Structure
Description: Loans: Non-Cumulative Values for Drilldown Reporting




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




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

VDSTATE 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: Non-Cumulative Values for Drilldown Reporting" 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_VDSTATE TYPE VDSTATE.

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


SAP VDSTATE 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
STICHTAGKey date VVSTDATDATS8VVSTDATKEYDATE
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
NLFD_ANGOffer consecutive number NLFD_ANGNUMC3LFNR3
GPARTNRBusiness Partner Number BP_PARTNR_NEWCHAR10BUT000ALPHABU_PARTNERBPABUPA
ROLETYPBP Role BU_PARTNERROLECHAR6TB003BU_ROLEBUPA_ROLE
ROLECML Correspondence Role Type of Recipient TB_ROLE_CORRCHAR4TDPZ6T_ROLE_CORR
RREFKONTAcct Assignment Ref. for Operative Valn Area and Loan TB_REFKONTCHAR8T037SUSTRU
HKONTGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
STILGARTRepayment Type Indicator STILGARTNUMC1STILGART
KZAHLUNGPay-in/disbursement rate KZAHLUNGDEC10(7) DEC3_7
PEFFZINSEffective Interest Rate PEFFZINSDEC10(7) DEC3_7
SEFFMETHEffective Interest Method (Financial Mathematics) SEFFMETHNUMC1SEFFMETH
SANTWHRCurrency SWHRCUKY5TCURCWAERSWHR
SREPAYMENTRepayment Status of Loan on Key Date SREPAYMENTCHAR1SREPAYMENT
ZINSENInterest Payments in Arrears (Asset) TB_BZINS_ACURR15(2) WERTV8_TR
ZINSEN_PInterest Payments in Arrears (Liability) TB_BZINS_PCURR15(2) WERTV8_TR
TILGUNGRepayments in Arrears (Assets) TB_BTILGUNG_ACURR15(2) WERTV8_TR
TILGUNG_PRepayments in Arrears (Liability) TB_BTILGUNG_PCURR15(2) WERTV8_TR
UEBERZTotal overpayments for contract VVUEBERZCURR15(2) WERTV8_TR
VERSCHTotal Remaining Postings Outstanding VVVERSCHCURR15(2) WERTV8_TR
BZINSANWRAsset: Accrued interest claim in position currency BZINSANWR_ACURR15(2) WERTV8_TR
BZINSANHWAsset: Accrued interest claim in local currency BZINSANHW_ACURR15(2) WERTV8_TR
BZINSANWR_PLiability: Accrued interest claim in position currency BZINSANWR_PCURR15(2) WERTV8_TR
BZINSANHW_PLiability: Accrued interest claim in local currency BZINSANHW_PCURR15(2) WERTV8_TR
BANTRAGAsset: Application capital in position currency TB_BANTRAG_ACURR13(2) BWHR
BANTRAG_PLiability: Application capital in position currency TB_BANTRAG_PCURR13(2) BWHR
BRPWRAsset: Remaining capital acc.to debit pos. in position curr. TB_BRPWR_ACURR15(2) WERTV8_TR
BRPHWAsset: Remaining capital acc.to debit pos. in local currency TB_BRPHW_ACURR15(2) WERTV8_TR
BRPWR_PLiab.: Remaining capital acc.to debit pos. in position curr. TB_BRPWR_PCURR15(2) WERTV8_TR
BRPHW_PLiab.: Remaining capital acc.to debit pos. in local currency TB_BRPHW_PCURR15(2) WERTV8_TR
BRPNWRAsset: Nominal remaining capital in position currency TB_BRPNWR_ACURR15(2) WERTV8_TR
BRPNWR_PLiability: Nominal remaining capital in position currency TB_BRPNWR_PCURR15(2) WERTV8_TR
BRIWRAsset: Effective capital (rem.cap. acc.to IP) in pos. curr. TB_BRIWR_ACURR15(2) WERTV8_TR
BRIHWAsset: Effective capital (rem.cap. acc.to IP) in local curr. TB_BRIHW_ACURR15(2) WERTV8_TR
BRIWR_PLiab.: Effective capital (rem.cap. acc.to IP) in pos. curr. TB_BRIWR_PCURR15(2) WERTV8_TR
BRIHW_PLiab.: Effective capital (rem.cap. acc.to IP) in local curr. TB_BRIHW_PCURR15(2) WERTV8_TR
BRINWRAsset: Nominal effective capital in position currency TB_BRINWR_ACURR15(2) WERTV8_TR
BRINWR_PLiability: Nominal effective capital in position currency TB_BRINWR_PCURR15(2) WERTV8_TR
BVAWRAsset: Value-dated capital in position currency TB_BVAWR_ACURR15(2) WERTV8_TR
BVAWR_PLiability: Value-dated capital in position currency TB_BVAWR_PCURR15(2) WERTV8_TR
BAVWRAsset: Disbursement obligation in position currency TB_BAVWR_ACURR15(2) WERTV8_TR
BAVWR_PLiability: Disbursement obligation in position currency TB_BAVWR_PCURR15(2) WERTV8_TR
BVKWRAsset: Contract capital in position currency TB_BVKWR_ACURR15(2) WERTV8_TR
BVKWR_PLiability: Contract capital in position currency TB_BVKWR_PCURR15(2) WERTV8_TR
BVZWRAsset: Current Contract Capital in Position Currency TB_BVZWR_ACURR15(2) WERTV8_TR
BVZWR_PLiability: Current Contract Capital in Position Currency TB_BVZWR_PCURR15(2) WERTV8_TR
BKKWRAsset: Commitment capital in position currency TB_BKKWR_ACURR15(2) WERTV8
BKKWR_PLiability: Commitment capital in position currency TB_BKKWR_PCURR15(2) WERTV8
BZUSAGEAsset: Current commitment capital in position currency TB_BZKWR_ACURR15(2) WERTV8
BZUSAGE_PLiability: Current commitment capital in position currency TB_BZKWR_PCURR15(2) WERTV8
BNBUERGInitial capital not guaranteed in position currency TB_BNBUERGCURR13(2) WERTV7
BBUCHWR_AAsset: Book value in position currency TB_BBUCHWR_ACURR15(2) WERTV8_TR
BBUCHHW_AAsset: Book value in local currency TB_BBUCHHW_ACURR15(2) WERTV8_TR
BBUCHWR_PLiability: Book value in position currency TB_BBUCHWR_PCURR15(2) WERTV8_TR
BBUCHHW_PLiability: Book value in local currency TB_BBUCHHW_PCURR15(2) WERTV8_TR
BKAUFWR_AAsset: Acquisition value in position currency TB_BKAUFWR_ACURR15(2) WERTV8_TR
BKAUFHW_AAsset: Acquisition value in local currency TB_BKAUFHW_ACURR15(2) WERTV8_TR
BKAUFWR_PLiability: Acquisition value in position currency TB_BKAUFWR_PCURR15(2) WERTV8_TR
BKAUFHW_PLiability: Acquisition value in local currency TB_BKAUFHW_PCURR15(2) WERTV8_TR
BNOMWR_AAsset: Nominal value in position currency TB_BNOMWR_ACURR15(2) WERTV8_TR
BNOMWR_PLiability: Nominal value in position currency TB_BNOMWR_PCURR15(2) WERTV8_TR
NOMZINSNominal Interest Rate TB_NOMINAL_INTERESTDEC10(7) DECV3_7

Key field Non-key field



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

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

How to access SAP table VDSTATE

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