SAP VDCAPITAL Data for Capitalization of Overdue Items Table data and field list

VDCAPITAL is a standard SAP Table which is used to store Data for Capitalization of Overdue Items data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The VDCAPITAL table consists of various fields, each holding specific information or linking keys about Data for Capitalization of Overdue Items data available in SAP. These include BUKRS (Company Code), SARCHIV (Archiving Category Indicator), RANL (Contract Number), RBO (Business Operation Number (Loans))... 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. .

VDCAPITAL table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP VDCAPITAL table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the VDCAPITAL table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
SARCHIVArchiving Category Indicator SARCHIVCHAR1SARCHIVARC
RANLContract Number RANLCHAR13ALPHARANLRAN
RBOBusiness Operation Number (Loans) RBOCHAR15RBO
SBO_CATBusiness Operation Category SBO_CATCHAR1SBO_CAT
SBO_STATUSBus. operation status TB_SBOSTATUSCHAR1SBO_STATUS
SBO_STATUS_OLDLoans: Business operation status SBO_STATUSCHAR1SBO_STATUS
XBO_TEXTText for Business Operation XBOTEXTCHAR30TEXT30
SRELSTATInternal Release Status in the Business Operations TB_SRELSTATCHAR1T_SRELSTAT
SFGKZRelease Workflow Indicator for the Business Operation TB_SFGKZACHAR1T_SFGKZ
UCURRPosition Currency (Currency of Position Amount) SBWHRCUKY5Assigned to domainWAERS
AARRBALTotal Amount of Overdue Items TB_ARRBALANCECURR13(2) WERTV7
AFUDUPAYTotal Amount for Payments Due in the Future TB_FUDUPAYCURR13(2) WERTV7
ACAPRECSTotal Amount of Receivables to Be Included in Loan TB_CAPRECSCURR13(2) WERTV7
ACREBALTotal Amount of Credit TB_CREBALCURR13(2) WERTV7
ABALNUITTotal Amount of Non-Selected Items TB_BALNUITCURR13(2) WERTV7
ABALNCPRECSTotal Amount of Receivables Not Included in Loan TB_BALNCPRECSCURR13(2) WERTV7
IINCL_KYDTETerm Including Key Date TB_INCLKYDTECHAR1XFELD
IULTI_KYDTEKey Date Must Be Last Day of the Month TB_ULTIKYDTECHAR1XFELD
DPAYM_TOPayments to TB_PAYM_TODATS8DATUM
INOTE_ASSIGNEDMemo Exists TB_IND_NOTE_ASSIGNEDCHAR1XFELD
APRCCHRGEProcessing Charge for Deferral or Capitalization TB_PRCCHRGECURR13(2) WERTV7
ICAPITALInclude Processing Charge in Loan TB_ICAPITALCHAR1XFELD
IDEVIATE_PAYMAlternative Payment Information in Additional Flows TB_DEVIATE_PAYMCHAR1XFELD
MNORISKMSNumber of Risk-Increasing Measures TB_NORISKMSNUMC2T_NORISKMS
IOA_AMOUNTInterest on Arrears Calculated TB_IOA_CALCULATION_RESULTCURR13(2) WERTV7
MPOSTTYPEPosting Control TB_DEFCAPPOSTTYPENUMC2TZB09VVSBUST
IDUNNBLCKDunning Block for Items for Deferral or Capitalization TB_DUNNBLCKCHAR1T040SMANSP
IIOABLCKInterest on Arrears Block for Items for Deferral/Capitaliz. TB_IOABLCKCHAR2ZINKZ
IDUBLDEFIDunning Block for Deferral Installments TB_DUBLDEFRCHAR1T040SMANSP
IIOABLDEFIInterest on Arrears Block for Deferral Installments TB_IOADEFICHAR2ZINKZ
IPAYBLCKPayment Block for Deferral Installments TB_PAYBLCKCHAR1T008ZAHLS
DOFFER_FRCreation Date for the Offer TB_OFFER_FRDATS8DATUM
DOFFER_TOEnd of the Validity Period of the Offer TB_OFFER_TODATS8DATUM
DACCEPTAcceptance Date of the Offer TB_ACCEPTDATS8DATUM
ICAPMANUPROCReason for Postprocessing: Key TB_MAN_POSTPROCESSNUMC3TDCAP_POSTPR
MCAPREASONKey for Reason for Capitalization TB_CAPREASONNUMC3TDCAP_REASONT_DEFCAPREASON
ACAPITALICapitalization Amount TB_CAPAMOCURR13(2) WERTV7
DCAPKYDTEKey Date for Capitalization of Overdue Items TB_CAPKYDTEDATS8DATUM
DENDPROPONew End of Term TB_ENDPROPODATS8DATUM
AINSTPROPONew Figure for Payment Installments TB_INSTPROPOCURR13(2) WERTV7
PKAPEFFINTRTEffective Interest Based on Capitalization of Overdue Items TB_KAPEFFINTRTDEC10(7) DECV3_7
MKAPEFFINTMTCapitalization of Overdue Items: Effective Interest Method TB_KAPEFFINTMTNUMC1SEFFMETH
DENDWOCAPEnd of Term Without Capitalization of Overdue Items TB_ENDWOCAPDATS8DATUM
AINSTWOCAPPayment Installment Amount w/o Capitalizn of Overdue Items TB_INSTWOCAPCURR13(2) WERTV7
IENDPROPOSpecify New End of Term TB_IENDPROPOCHAR1
IINSTPROPOSpecify New Installment TB_IINSTPROPOCHAR1
NINSTPROPOTotal No.Pymnt Installments with Capitalizn of Overdue Items TB_NINSTPROPONUMC3
NINSTWOCAPTotal No. Pymnt Installments w/o Capitalizn of Overdue Items TB_NINSTWOCAPNUMC3
NOVRTWOCAPOverall Term in Months w/o Capitalization of Overdue Items TB_NOVRTWOCAPNUMC3
NOVRTPROPOOverall Term in Months with Capitalization of Overdue Items TB_NOVRTPROPONUMC3
DSTARTREPRepayment Start TB_DSTARTREPDATS8
DFIRST_DISBField of type DATS DATSDATS8DATS
DOEFFINTPYMNPKey Date for Last Change to Installment Plan TB_MODEL_DATE_LAST_PAYMENTPLANDATS8DATUM
OEFFINTPYMNPEffective Interest Rate for Last Change to Installment Plan TB_MODEL_EFFECTIV_INTERSTS_PPCDEC10(7) DEC3_7
NMAXTERMNumber of Times Units for Maximum Term of Contract TB_PROD_TERM_MAX_VALUENUMC4T_PROD_TIME_QUANTITY_TERM
AREIMBURSEMENTCredit Life Insurance Reimbursement TB_CLI_RECALC_CONTRCURR13(2) WERTV7
AINSURANCE_CONTRSingle Premium for Credit Life Insurance TB_CLI_INSURANCECURR13(2) WERTV7
ADIFFERENCECalculated Difference for Credit Life Insurance TB_LOLIINBALCURR13(2) WERTV7
ICONSIDERTransfer CLI Difference TB_ICONSIDERCHAR1XFELD
CALCULATION_DATECLI: Key Date for Calculation of Credit Life Insurance TB_CLI_CALCULATION_DATEDATS8DATUM
UCLICURRPosition Currency (Currency of Position Amount) SBWHRCUKY5Assigned to domainWAERS
CLI_FLOW_SBEWARTFlow Type SBEWARTCHAR4Assigned to domainSBEWART
CLI_CHANGEDCheckbox XFELDCHAR1XFELD

Key field Non-key field



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

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

SELECT SINGLE *
FROM VDCAPITAL
INTO CORRESPONDING FIELDS OF WA_VDCAPITAL
WHERE...

How to access SAP table VDCAPITAL

Within an ECC or HANA version of SAP you can also view further information about VDCAPITAL and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).