SAP VDCAPTR CAPTR: Master Data of Capital Transfer Table
Overview
VDCAPTR is a standard SAP S/4HANA table that stores CAPTR: Master Data of Capital Transfer data. There are total 128 fields in the VDCAPTR table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDCAPTR belongs to Loans Management (FS-CML) module and is located in the package Capital Transfer (FVVD_CAPTR).
In addition, following links provide an overview of foreign key relationships, if any, that link VDCAPTR to other SAP tables and standard CDS views available based on VDCAPTR table in S/4HANA 2020.
Techincal Settings of VDCAPTR
Below are technical details of the table VDCAPTR
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDCAPTR Fields
The following table gives you an overview of the fields available in VDCAPTR
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| BUKRS | Company Code | BUKRS | CHAR | 4 | |
| SARCHIV | Archiving Category Indicator | SARCHIV | CHAR | 1 | |
| RANL | Contract Number | RANL | CHAR | 13 | |
| RBO | Business Operation Number (Loans) | RBO | CHAR | 15 | |
| SBO_STATUS | Business Operation Status of Capital Transfer | TB_SBOSTATUS_CAPTR | CHAR | 1 | |
| SFGKZ | Release Workflow Indicator for the Business Operation | TB_SFGKZA | CHAR | 1 | |
| SRELSTAT | Internal Release Status in the Business Operations | TB_SRELSTAT | CHAR | 1 | |
| DVALUTTF | Transfer Key Date | TB_TRANSFER_DATE | DATS | 8 | |
| IULTDVALUTTF | Month-End Indicator on Transfer Key Date | TB_IND_ULTIMO | CHAR | 1 | |
| ICOMTF | Transfer Procedure Indicator (' ' = Rem. Cap '1' = Val.DtCp) | TB_IND_TRANSFER_PROCEDURE | CHAR | 1 | |
| IPREDISTF | Indicator Transfer Advance Discount / Premium | TB_IND_PRE_DISCOUNT_TRANSFER | CHAR | 1 | |
| INEUVALTF | Transfer Not Affecting Valuation | TB_IND_NEUTRAL_VALIDATION_TF | CHAR | 1 | |
| REXCHGRA | Exchange Rate | TB_EXCHANGE_RATE | DEC | 9 | |
| DEXCHGRA | Date of Exchange Rate | TB_DATE_EXCHANGE_RATE | DATS | 8 | |
| MTEMPLNO | Capital Transfer Template Key | TB_CAPTR_TEMPLATE | TDCAPTR_TEMPL | CHAR | 2 |
| RECAPCONTROL | Control Transfer Remaining Capital | TB_REMAINING_CAPITAL_CONTROL | NUMC | 2 | |
| DIOBCONTROL | Control Disbursement Obligation | TB_DISBURSEMENT_OBL_CONTROL | NUMC | 2 | |
| REDISCONTROL | Control Remaining Discount / Premium | TB_REMAINING_DISCOUNT_CONTROL | NUMC | 2 | |
| PREDISCONTROL | Control Advance Discount / Premium | TB_PRE_DISCOUNT_CONTROL | NUMC | 2 | |
| NSEREPCONTROL | Control Repayment Amount Not Settled | TB_NOT_SETTLED_REP_CONTROL | NUMC | 2 | |
| COMCAPCONTROL | Value-Dated Capital Control | TB_VALUEDATED_CAPITAL_CONTROL | NUMC | 2 | |
| SCHEDREPCONTROL | Scheduled Repayment Control | TB_SCHEDULED_REPAY_CONTROL | NUMC | 2 | |
| UNSCHEDREPCONTR | Unscheduled Repayment Control | TB_UNSCHEDULED_REPAY_CONTROL | NUMC | 2 | |
| PRATETF | Transfer Quota Capital Transfer | TB_TRANSFER_RATE | DEC | 10 | |
| IINCLDVALUT_S | Inclusive Indicator for Source Loan | TB_IND_INCL_SOURCE | CHAR | 1 | |
| PARTNR_S | Partner Number | TB_PARTNR_CAPTR | CHAR | 10 | |
| UPOSCURR_S | Position Currency Source Loan (Currency of Postion Amounts) | TB_SBWHR_SOURCE | * | CUKY | 5 |
| ARECA_S | Remaining Capital in Source Loan | TB_REMAINING_CAPITAL_SOURCE | CURR | 13 | |
| ARECAAV_S | Available Remaining Capital Source Loan on Transfer Key Date | TB_AVAIL_REMAINING_CAPITAL_S | CURR | 13 | |
| ARECATF_S | Remaining Capital to be Transferred in the Source Loan | TB_TF_REMAINING_CAPITAL_SOURCE | CURR | 13 | |
| ADIOB_S | Disbursement Obligation of Source Loan on Transfer Key Date | TB_DISBURSEMENT_OBLIG_SOURCE | CURR | 13 | |
| ADIOBAV_S | Available Disbursement Obligation Source Loan | TB_AVAIL_DISBURSMENT_OBLIG_S | CURR | 13 | |
| ADIOBTF_S | Disbursement Obligation to be Transferred Source Loan | TB_TF_DISBURSEMENT_OBLIG_S | CURR | 13 | |
| AREDIS_S | Remaining Discount / Premium in Source Loan | TB_REMAINING_DISCOUNT_SOURCE | CURR | 13 | |
| APREDIS_S | Advance Discount / Premium Source Loan | TB_PRE_DISCOUNT_SOURCE | CURR | 13 | |
| IREPSE_S | Indicator Repayment Settlement in Source Loan | TB_IND_REP_SETTLEMENT_SOURCE | CHAR | 1 | |
| ANSEREP_S | Repayment Not Settled in Source Loan | TB_NOT_SETTLED_REP_SOURCE | CURR | 13 | |
| FTRECAOF_S | Flow Type Remaining Capital Outflow | TB_FT_REMAINING_CAPITAL_OF | * | CHAR | 4 |
| FTREDISOF_S | Flow Type Remaining Discount / Premium Outflow | TB_FT_REMAINING_DISCOUNT_OF | * | CHAR | 4 |
| FTPREDISOF_S | Flow Type Advance Discount / Premium Outflow | TB_FT_PRE_DISCOUNT_OF | * | CHAR | 4 |
| CTDIOBOF_S | Condition Type Disbursement Obligation Outflow | TB_CT_DISBURSMENT_OBLIG_OF | * | NUMC | 4 |
| CTREPSE_S | Condition Type Repayment Settlement | TB_CT_REPAYMENT_SETTLEMENT_OF | * | NUMC | 4 |
| CTCOMOF_S | Condition Type Commitment Outflow | TB_CT_COMMITMENT_OF | * | NUMC | 4 |
| MSBOTERM_S | Repayment Change Indicator Source Loan | TB_SBOTERM_CAPTR_SOURCE | CHAR | 1 | |
| CTREP_S | Repayment Condition Type in Source Loan | TB_CT_REPAYMENT_SOURCE | * | NUMC | 4 |
| DCOEFFR_S | Start of Fixed Period in Source Loan | TB_DATE_FIXED_FROM_SOURCE | DATS | 8 | |
| DBEGREP_S | Repayment Start in Source Loan | TB_REPAYMENT_DATE_FROM_SOURCE | DATS | 8 | |
| PREPCHG_S | Repayment Rate in Source Loan in Percent | TB_REPAYMENT_RATE_SOURCE | DEC | 10 | |
| AREPCHG_S | Specified Payment Installment in Source Loan | TB_REPAYMENT_AMOUNT_SOURCE | CURR | 13 | |
| AREPCHGBAS_S | Base Amount in Source Loan | TB_REPAYMENT_BAS_AMOUNT_SOURCE | CURR | 13 | |
| ARECATFLC_S | Remaining Capital in Local Currency to be Transferred | TB_REMAINING_CAP_TF_LOCAL_CURR | CURR | 13 | |
| MOFMETHOD_S | Outflow Procedure Source Loan | TB_OUTFLOW_METHOD_SOURCE | NUMC | 2 | |
| ISAVTERMEND_S | Save Term End Indicator in Source Loan | TB_IND_SAVE_TERM_END_SOURCE | CHAR | 1 | |
| DEOTOLD_S | Previous Term End in Source Loan (Calculated) | TB_DATE_END_OF_TERM_OLD_SOURCE | DATS | 8 | |
| DEOT_S | New End of Term in Source Loan (With CT) (Calculated) | TB_DATE_END_OF_TERM_NEW_SOURCE | DATS | 8 | |
| APRREDIS_S | Remaining Discount in Source Loan to be Transferred | TB_REMAINING_CAP_PRORATED_S | CURR | 13 | |
| APRPREDIS_S | Advance Discount/ Premium to be Transferred Source Loan | TB_PRE_DISCOUNT_PRORATED_S | CURR | 13 | |
| APRNSEREP_S | Proportional Repayment Not Settled in Source Loan | TB_NOT_SETTLED_REP_PR_RATED_S | CURR | 13 | |
| ATFVALCAOF_S | Value-Dated Capital to be Transferred in Sce Loan (Outflow) | TB_TF_VALUEDATED_CAP_SOURCE | CURR | 13 | |
| ATFSCHEDREPOF_S | Scheduled Repayment Capital to be Transferred (Outflow) | TB_TF_SCHEDULED_REPAY_CAP_S | CURR | 13 | |
| ATFUNSCHREPOF_S | Unscheduled Repayment Capital to be Transferred (Outflow) | TB_TF_UNSCHEDULED_REPAY_CAP_S | CURR | 13 | |
| AVALCA_S | Value-Dated Capital in Source Loan (on Transfer Key Date) | TB_VALUEDATED_CAPITAL_SOURCE | CURR | 13 | |
| ASUMICSCHREP_S | Total of Incoming Payments for Scheduled Repayment | TB_SUM_INCOMING_CAP_SCHEDR | CURR | 13 | |
| ASUMICUNSCHREP_S | Total of Incoming Payments for Unscheduled Repayment | TB_SUM_INCOMING_CAP_UNSCHEDR | CURR | 13 | |
| FTVALCAOF_S | Flow Type Value-Dated Capital Outflow | TB_FT_VALUEDATED_CAPITAL_OF | * | CHAR | 4 |
| FTSCHEDREPOF_S | Flow Type Scheduled Repayment Outflow | TB_FT_SCHEDREP_CAPITAL_OF | * | CHAR | 4 |
| FTUNSCHEDROF_S | Flow Type Unscheduled Repayment Outflow | TB_FT_UNSCHEDREP_CAPITAL_OF | * | CHAR | 4 |
| MRANL_T | Loan Number Target Loan | TB_RANL_TARGET | CHAR | 13 | |
| MBVTYP_T | Bank Details ID in Target Loan | TB_BVTYP_TARGET | CHAR | 4 | |
| MZLSCH_T | Payment Method in Target Loan | TB_ZLSCH_TARGET | * | CHAR | 1 |
| MNDID_T | Unique Reference to Mandate for each Payee | SEPA_MNDID | CHAR | 35 | |
| PARTNR_T | Partner Number | TB_PARTNR_CAPTR | CHAR | 10 | |
| UPOSCURR_T | Position Currency Target Loan (Currency of Postion Amounts) | TB_SBWHR_TARGET | * | CUKY | 5 |
| AVALUTCA_T | Value-Dated Capital Target Loan | TB_VALUT_CAPITAL_TARGET | CURR | 13 | |
| ADIOB_T | Disbursement Obligation of Target Loan | TB_DISBURSEMENT_OBLIG_TARGET | CURR | 13 | |
| ADIOBAV_T | Available Disbursement Obligation Target Loan | TB_AVAIL_DISBURSMENT_OBLIG_T | CURR | 13 | |
| ACOLDIS_T | Collected Discount / Premium in Target Loan | TB_COLLECTED_DISCOUNT_TARGET | CURR | 13 | |
| ARECA_T | Remaining Capital in Target Loan | TB_REMAINING_CAPITAL_TARGET | CURR | 13 | |
| ATFRECAIFSC_T | Rem. Capital Inflow To Be Transferred in Settlement Currency | TB_REMAINING_CAPITAL_IF_SC_T | CURR | 13 | |
| ATFREDISIFSC_T | Rem. Disc./Premium Inflow to be Transferred in Settl. Crcy | TB_REMAINING_DISCOUNT_IF_SC_T | CURR | 13 | |
| ATFPREDISIFSC_T | Advance Disc./ Prem. Inflow To Transfer in Settlement Crcy | TB_PRE_DISCOUNT_IF_SC_TARGET | CURR | 13 | |
| ANSEREPCFSC_T | Carry Forward Repayment Not Settled in Settlement Currency | TB_NOT_SET_REP_CARRY_FORW_SC_T | CURR | 13 | |
| FTRECAIF_T | Flow Type Remaining Capital Inflow | TB_FT_REMAINING_CAPITAL_IF | * | CHAR | 4 |
| FTREPCF_T | Flow Type Repayment Carry Forward | TB_FT_REPAYMENT_CARRY_FORWARD | * | CHAR | 4 |
| FTREDISIF_T | Flow Type Remaining Discount / Premium Inflow | TB_FT_REMAINING_DISCOUNT_IF | * | CHAR | 4 |
| FTPREDISIF_T | Flow Type Advance Discount / Premium Inflow | TB_FT_PRE_DISCOUNT_IF | * | CHAR | 4 |
| CTCAINC_T | Condition Type Capital Increase | TB_CT_CAPITAL_INCREASE | * | NUMC | 4 |
| CTNSETREPCF | Condition Type Carry Forward Repayment Amnt Not Settled | TB_CT_NOT_SET_REP_CARRY_FORW | * | NUMC | 4 |
| DFIXEDFRO_T | Start of Fixed Period in Target Loan | TB_DATE_FIXED_FROM_TARGET | DATS | 8 | |
| MEXBEGEIR_T | External Initial Effective Interest Target Loan | TB_EXT_ORIGINAL_EFFECTIV_IR_T | DEC | 10 | |
| RDISBRATE_T | Disbursement Rate Target Loan | TB_DISBURSEMENT_RATE_TARGET | DEC | 10 | |
| MSBOTERM_T | Repayment Change Indicator Target Loan | TB_SBOTERM_CAPTR_TARGET | CHAR | 1 | |
| CTREP_T | Repayment Condition Type in Target Loan | TB_CT_REPAYMENT_TARGET | * | NUMC | 4 |
| DBEGREP_T | Repayment Start in Target Loan | TB_REPAYMENT_DATE_FROM_TARGET | DATS | 8 | |
| PREPCHG_T | Repayment Rate in Target Loan in Percent | TB_REPAYMENT_RATE_TARGET | DEC | 10 | |
| AREPCHG_T | Specified Payment Installment in Target Loan | TB_REPAYMENT_AMOUNT_TARGET | CURR | 13 | |
| AREPCHGBAS_T | Base Amount in Target Loan | TB_REPAYMENT_BAS_AMOUNT_TARGET | CURR | 13 | |
| ISAVTERMEND_T | Save Term End Indicator in Target Loan | TB_IND_SAVE_TERM_END_TARGET | CHAR | 1 | |
| IFMETHOD_T | Inflow Method Target Loan | TB_INFLOW_METHOD_TARGET | NUMC | 2 | |
| DEOTOLD_T | Previous Term End in Target Loan (Calculated) | TB_DATE_END_OF_TERM_OLD_TARGET | DATS | 8 | |
| DEOT_T | New Term End in Target Loan (With CT) (Calculated) | TB_DATE_END_OF_TERM_NEW_TARGET | DATS | 8 | |
| ATFVALCAIF_T | Value-Dated Capital to Transfer in Target Loan (Inflow) | TB_TF_VALUEDATED_CAP_TARGET | CURR | 13 | |
| ATFSCHRIF_T | Scheduled Repayment Capital to be Transferred (Inflow) | TB_TF_SCHEDULED_REPAY_CAP_T | CURR | 13 | |
| ATFUNSCHRIF_T | Unscheduled Repayment Capital to be Transferred (Inflow) | TB_TF_UNSCHEDULED_REPAY_CAP_T | CURR | 13 | |
| FTVALCAIF_T | Flow Type Value-Dated Captial Inflow | TB_FT_VALUEDATED_CAPITAL_IF | * | CHAR | 4 |
| FTSCHRIF_T | Flow Type Scheduled Repayment Inflow | TB_FT_SCHEDREP_CAPITAL_IF | * | CHAR | 4 |
| FTUNSCHRIF_T | Flow Type Unscheduled Repayment Inflow | TB_FT_UNSCHEDREP_CAPITAL_IF | * | CHAR | 4 |
| MRCAPTR_REASON | Reason for Capital Transfer | TB_CAPTR_REASON | TDCAPTR_REASON | NUMC | 3 |
| MPOSTTYPE | Posting Control for the Capital Transfer | TB_POSTTYPE_KEY | TZB09 | NUMC | 2 |
| IMANPOPROC | Need for Postprocessing | TB_MAN_POSTPROCESSING | TDCAPTR_POSTPR | NUMC | 3 |
| DCOM_T | Commitment Date of Target Loan | TB_DATE_COMMITMENT_TARGET | DATS | 8 | |
| DOFFON_T | Date of Offer Created for Target Loan | TB_DATE_OFFER_ON_TARGET | DATS | 8 | |
| DOFFUNT_T | End of Validity Period of Offer of Target Loan | TB_DATE_OFFER_UNTIL_TARGET | DATS | 8 | |
| DACCEPT_T | Aceptance Date of Offer of Target Loan | TB_DATE_ACCEPTED_ON_TARGET | DATS | 8 | |
| DAPPLIC_T | Application Date of Target Loan | TB_DATE_APPLICATION_ON_TARGET | DATS | 8 | |
| DAPPROV_T | Approval Date of Target Loan | TB_DATE_APPROVAL_TARGET | DATS | 8 | |
| DCONTRAC_T | Creation Date of Contract for Target Loan | TB_DATE_CONTRACT_ON_TARGET | DATS | 8 | |
| ICONTR_CREATED_T | Contract Created Indicator (Target Loan) | TB_IND_CONTRACT_CREATED_TARGET | CHAR | 1 | |
| INEW_CONTRACT | Indicator - Is Contract Registered for Capital Transfer | TB_NEW_CONTRACT | CHAR | 1 | |
| RERF | Entered By | RERF | CHAR | 12 | |
| DERF | First Entered On | DERF | DATS | 8 | |
| TERF | Time of Creation | TERF | TIMS | 6 | |
| REHER | Source of Initial Entry | REHER | CHAR | 10 | |
| RBEAR | Employee ID | RBEAR | CHAR | 12 | |
| DBEAR | Last Edited On | DBEAR | DATS | 8 | |
| TBEAR | Last Edited At | TBEAR | TIMS | 6 | |
| RBHER | Editing Source | RBHER | CHAR | 10 |
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 VDCAPTR
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VDCAPTR | IMANPOPROC | 1: N | TDCAPTR_POSTPR |
| VDCAPTR | MANDT | 1: CN | T000 |
| VDCAPTR | MPOSTTYPE | 1: C | TZB09 |
| VDCAPTR | MRCAPTR_REASON | 1: CN | TDCAPTR_REASON |
| VDCAPTR | MTEMPLNO | : | TDCAPTR_TEMPL |