ADEFCAP SAP (Payment Agreement Data) Append Structure details
Dictionary Type: Append Structure
Description: Payment Agreement Data
Description: Payment Agreement Data
Append Structure field list including key, data, relationships and ABAP select examples
ADEFCAP is a standard SAP Append Structure which is used to store Payment Agreement Data data and is available within R/3 SAP systems depending on the version and release level.
The ADEFCAP table consists of various fields, each holding specific information or linking keys about Payment Agreement Data data available in SAP. These include MANDT (Client), BUKRS (Company Code), SARCHIV (Archiving Category Indicator), RANL (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 (Deep)
SAP ADEFCAP append 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 |
VDDEFERRAL | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | BUKRS | BUK | C_T001 | ||
SARCHIV | Archiving Category Indicator | SARCHIV | CHAR | 1 | SARCHIV | ARC | |||
RANL | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
RBO | Business Operation Number (Loans) | RBO | CHAR | 15 | RBO | ||||
SBO_CAT | Business Operation Category | SBO_CAT | CHAR | 1 | SBO_CAT | ||||
SBO_STATUS | Bus. operation status | TB_SBOSTATUS | CHAR | 1 | SBO_STATUS | ||||
SBO_STATUS_OLD | Loans: Business operation status | SBO_STATUS | CHAR | 1 | SBO_STATUS | ||||
XBO_TEXT | Text for Business Operation | XBOTEXT | CHAR | 30 | TEXT30 | ||||
SRELSTAT | Internal Release Status in the Business Operations | TB_SRELSTAT | CHAR | 1 | T_SRELSTAT | ||||
SFGKZ | Release Workflow Indicator for the Business Operation | TB_SFGKZA | CHAR | 1 | T_SFGKZ | ||||
UCURR | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | WAERS | ||||
AARRBAL | Total Amount of Overdue Items | TB_ARRBALANCE | CURR | 13(2) | WERTV7 | ||||
AFUDUPAY | Total Amount for Payments Due in the Future | TB_FUDUPAY | CURR | 13(2) | WERTV7 | ||||
ACAPRECS | Total Amount of Receivables to Be Included in Loan | TB_CAPRECS | CURR | 13(2) | WERTV7 | ||||
ACREBAL | Total Amount of Credit | TB_CREBAL | CURR | 13(2) | WERTV7 | ||||
ABALNUIT | Total Amount of Non-Selected Items | TB_BALNUIT | CURR | 13(2) | WERTV7 | ||||
ABALNCPRECS | Total Amount of Receivables Not Included in Loan | TB_BALNCPRECS | CURR | 13(2) | WERTV7 | ||||
IINCL_KYDTE | Term Including Key Date | TB_INCLKYDTE | CHAR | 1 | XFELD | ||||
IULTI_KYDTE | Key Date Must Be Last Day of the Month | TB_ULTIKYDTE | CHAR | 1 | XFELD | ||||
DPAYM_TO | Payments to | TB_PAYM_TO | DATS | 8 | DATUM | ||||
INOTE_ASSIGNED | Memo Exists | TB_IND_NOTE_ASSIGNED | CHAR | 1 | XFELD | ||||
APRCCHRGE | Processing Charge for Deferral or Capitalization | TB_PRCCHRGE | CURR | 13(2) | WERTV7 | ||||
ICAPITAL | Include Processing Charge in Loan | TB_ICAPITAL | CHAR | 1 | XFELD | ||||
IDEVIATE_PAYM | Alternative Payment Information in Additional Flows | TB_DEVIATE_PAYM | CHAR | 1 | XFELD | ||||
MNORISKMS | Number of Risk-Increasing Measures | TB_NORISKMS | NUMC | 2 | T_NORISKMS | ||||
IOA_AMOUNT | Interest on Arrears Calculated | TB_IOA_CALCULATION_RESULT | CURR | 13(2) | WERTV7 | ||||
MPOSTTYPE | Posting Control | TB_DEFCAPPOSTTYPE | NUMC | 2 | VVSBUST | ||||
IDUNNBLCK | Dunning Block for Items for Deferral or Capitalization | TB_DUNNBLCK | CHAR | 1 | MANSP | ||||
IIOABLCK | Interest on Arrears Block for Items for Deferral/Capitaliz. | TB_IOABLCK | CHAR | 2 | ZINKZ | ||||
IDUBLDEFI | Dunning Block for Deferral Installments | TB_DUBLDEFR | CHAR | 1 | MANSP | ||||
IIOABLDEFI | Interest on Arrears Block for Deferral Installments | TB_IOADEFI | CHAR | 2 | ZINKZ | ||||
IPAYBLCK | Payment Block for Deferral Installments | TB_PAYBLCK | CHAR | 1 | ZAHLS | ||||
DOFFER_FR | Creation Date for the Offer | TB_OFFER_FR | DATS | 8 | DATUM | ||||
DOFFER_TO | End of the Validity Period of the Offer | TB_OFFER_TO | DATS | 8 | DATUM | ||||
DACCEPT | Acceptance Date of the Offer | TB_ACCEPT | DATS | 8 | DATUM | ||||
IDEFMANUPROC | Reason for Postprocessing: Key | TB_MAN_POSTPROCESS | NUMC | 3 | |||||
MDEFREASON | Reason for Deferral: Key | TB_DEFREASON | NUMC | 3 | T_DEFCAPREASON | ||||
ADEFERR | Deferral Amount | TB_DEFAMO | CURR | 13(2) | WERTV7 | ||||
DDEFKYDTE | Key Date for Deferral | TB_DEFKYDTE | DATS | 8 | DATUM | ||||
PDEFINTRT | Interest Rate for the Deferral | TB_DEFINTRT | DEC | 10(7) | DECV3_7 | ||||
MINTDYMT | Interest Calculation Method | SZBMETH | CHAR | 1 | SZBMETH | ||||
DFRSTDUDTE | Due Date of First Installment Payment for Deferral Plan | TB_FRSDUDTE | DATS | 8 | DATUM | ||||
IULTIDUDTE | Due Date Is Always on the Last Day of the Month | TB_ULTIDUDTE | CHAR | 1 | XFELD | ||||
IINCLDUDTE | Including Due Date | TB_INCLDUDTE | CHAR | 1 | CHAR1 | ||||
MNUMRTS | Number of Payment Installments in the Deferral Plan | TB_NUMRTS | NUMC | 3 | |||||
MRHYTHM | Frequency of Installment Payments in Months | TB_RHYTHM | NUMC | 3 | |||||
MWRKDYRL | Working Day Shift for Calculation Day | TB_SVWERK | NUMC | 1 | T_SWERK | ||||
MPUHOLCAL | Factory calendar | SKALID | CHAR | 2 | WFCID | H_TFACD | |||
IFREEPAYM | Custom Deferral Plan | TB_FREEPAYM | CHAR | 1 | XFELD | ||||
MPARTKUNNR | Customer Numbers | KUNNR | CHAR | 10 | ALPHA | KUNNR | KUN | C_KUNNR | |
MPARTNER | Business Partner Number for Payer of Deferral Installments | TB_DEFPARTNER | CHAR | 10 | ALPHA | BU_PARTNER | |||
MBANKTYPE | Bank Details ID for Deferral Installments | TB_DEFBVTYP | CHAR | 4 | BVTYP | ||||
MPAYMTHD | Payment Method for Deferral Installments | TB_DEFPYMTD | CHAR | 1 | ZLSCH | ||||
PEFFINTRT | Effective Interest Rate for Deferral Agreement | TB_EFFINTRT | DEC | 10(7) | DECV3_7 | ||||
MEFFINTMT | Effective Interest Method for Deferral Agreement | TB_EFFINTMT | NUMC | 1 | SEFFMETH | ||||
MNDID | Unique Referene to Mandate per Payment Recipient | SEPA_MNDID | CHAR | 35 | ID035 | ||||
VDCAPITAL | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | BUKRS | BUK | C_T001 | ||
SARCHIV | Archiving Category Indicator | SARCHIV | CHAR | 1 | SARCHIV | ARC | |||
RANL | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
RBO | Business Operation Number (Loans) | RBO | CHAR | 15 | RBO | ||||
SBO_CAT | Business Operation Category | SBO_CAT | CHAR | 1 | SBO_CAT | ||||
SBO_STATUS | Bus. operation status | TB_SBOSTATUS | CHAR | 1 | SBO_STATUS | ||||
SBO_STATUS_OLD | Loans: Business operation status | SBO_STATUS | CHAR | 1 | SBO_STATUS | ||||
XBO_TEXT | Text for Business Operation | XBOTEXT | CHAR | 30 | TEXT30 | ||||
SRELSTAT | Internal Release Status in the Business Operations | TB_SRELSTAT | CHAR | 1 | T_SRELSTAT | ||||
SFGKZ | Release Workflow Indicator for the Business Operation | TB_SFGKZA | CHAR | 1 | T_SFGKZ | ||||
UCURR | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | WAERS | ||||
AARRBAL | Total Amount of Overdue Items | TB_ARRBALANCE | CURR | 13(2) | WERTV7 | ||||
AFUDUPAY | Total Amount for Payments Due in the Future | TB_FUDUPAY | CURR | 13(2) | WERTV7 | ||||
ACAPRECS | Total Amount of Receivables to Be Included in Loan | TB_CAPRECS | CURR | 13(2) | WERTV7 | ||||
ACREBAL | Total Amount of Credit | TB_CREBAL | CURR | 13(2) | WERTV7 | ||||
ABALNUIT | Total Amount of Non-Selected Items | TB_BALNUIT | CURR | 13(2) | WERTV7 | ||||
ABALNCPRECS | Total Amount of Receivables Not Included in Loan | TB_BALNCPRECS | CURR | 13(2) | WERTV7 | ||||
IINCL_KYDTE | Term Including Key Date | TB_INCLKYDTE | CHAR | 1 | XFELD | ||||
IULTI_KYDTE | Key Date Must Be Last Day of the Month | TB_ULTIKYDTE | CHAR | 1 | XFELD | ||||
DPAYM_TO | Payments to | TB_PAYM_TO | DATS | 8 | DATUM | ||||
INOTE_ASSIGNED | Memo Exists | TB_IND_NOTE_ASSIGNED | CHAR | 1 | XFELD | ||||
APRCCHRGE | Processing Charge for Deferral or Capitalization | TB_PRCCHRGE | CURR | 13(2) | WERTV7 | ||||
ICAPITAL | Include Processing Charge in Loan | TB_ICAPITAL | CHAR | 1 | XFELD | ||||
IDEVIATE_PAYM | Alternative Payment Information in Additional Flows | TB_DEVIATE_PAYM | CHAR | 1 | XFELD | ||||
MNORISKMS | Number of Risk-Increasing Measures | TB_NORISKMS | NUMC | 2 | T_NORISKMS | ||||
IOA_AMOUNT | Interest on Arrears Calculated | TB_IOA_CALCULATION_RESULT | CURR | 13(2) | WERTV7 | ||||
MPOSTTYPE | Posting Control | TB_DEFCAPPOSTTYPE | NUMC | 2 | VVSBUST | ||||
IDUNNBLCK | Dunning Block for Items for Deferral or Capitalization | TB_DUNNBLCK | CHAR | 1 | MANSP | ||||
IIOABLCK | Interest on Arrears Block for Items for Deferral/Capitaliz. | TB_IOABLCK | CHAR | 2 | ZINKZ | ||||
IDUBLDEFI | Dunning Block for Deferral Installments | TB_DUBLDEFR | CHAR | 1 | MANSP | ||||
IIOABLDEFI | Interest on Arrears Block for Deferral Installments | TB_IOADEFI | CHAR | 2 | ZINKZ | ||||
IPAYBLCK | Payment Block for Deferral Installments | TB_PAYBLCK | CHAR | 1 | ZAHLS | ||||
DOFFER_FR | Creation Date for the Offer | TB_OFFER_FR | DATS | 8 | DATUM | ||||
DOFFER_TO | End of the Validity Period of the Offer | TB_OFFER_TO | DATS | 8 | DATUM | ||||
DACCEPT | Acceptance Date of the Offer | TB_ACCEPT | DATS | 8 | DATUM | ||||
ICAPMANUPROC | Reason for Postprocessing: Key | TB_MAN_POSTPROCESS | NUMC | 3 | |||||
MCAPREASON | Key for Reason for Capitalization | TB_CAPREASON | NUMC | 3 | T_DEFCAPREASON | ||||
ACAPITALI | Capitalization Amount | TB_CAPAMO | CURR | 13(2) | WERTV7 | ||||
DCAPKYDTE | Key Date for Capitalization of Overdue Items | TB_CAPKYDTE | DATS | 8 | DATUM | ||||
DENDPROPO | New End of Term | TB_ENDPROPO | DATS | 8 | DATUM | ||||
AINSTPROPO | New Figure for Payment Installments | TB_INSTPROPO | CURR | 13(2) | WERTV7 | ||||
PKAPEFFINTRT | Effective Interest Based on Capitalization of Overdue Items | TB_KAPEFFINTRT | DEC | 10(7) | DECV3_7 | ||||
MKAPEFFINTMT | Capitalization of Overdue Items: Effective Interest Method | TB_KAPEFFINTMT | NUMC | 1 | SEFFMETH | ||||
DENDWOCAP | End of Term Without Capitalization of Overdue Items | TB_ENDWOCAP | DATS | 8 | DATUM | ||||
AINSTWOCAP | Payment Installment Amount w/o Capitalizn of Overdue Items | TB_INSTWOCAP | CURR | 13(2) | WERTV7 | ||||
IENDPROPO | Specify New End of Term | TB_IENDPROPO | CHAR | 1 | |||||
IINSTPROPO | Specify New Installment | TB_IINSTPROPO | CHAR | 1 | |||||
NINSTPROPO | Total No.Pymnt Installments with Capitalizn of Overdue Items | TB_NINSTPROPO | NUMC | 3 | |||||
NINSTWOCAP | Total No. Pymnt Installments w/o Capitalizn of Overdue Items | TB_NINSTWOCAP | NUMC | 3 | |||||
NOVRTWOCAP | Overall Term in Months w/o Capitalization of Overdue Items | TB_NOVRTWOCAP | NUMC | 3 | |||||
NOVRTPROPO | Overall Term in Months with Capitalization of Overdue Items | TB_NOVRTPROPO | NUMC | 3 | |||||
DSTARTREP | Repayment Start | TB_DSTARTREP | DATS | 8 | |||||
DFIRST_DISB | Field of type DATS | DATS | DATS | 8 | DATS | ||||
DOEFFINTPYMNP | Key Date for Last Change to Installment Plan | TB_MODEL_DATE_LAST_PAYMENTPLAN | DATS | 8 | DATUM | ||||
OEFFINTPYMNP | Effective Interest Rate for Last Change to Installment Plan | TB_MODEL_EFFECTIV_INTERSTS_PPC | DEC | 10(7) | DEC3_7 | ||||
NMAXTERM | Number of Times Units for Maximum Term of Contract | TB_PROD_TERM_MAX_VALUE | NUMC | 4 | T_PROD_TIME_QUANTITY_TERM | ||||
AREIMBURSEMENT | Credit Life Insurance Reimbursement | TB_CLI_RECALC_CONTR | CURR | 13(2) | WERTV7 | ||||
AINSURANCE_CONTR | Single Premium for Credit Life Insurance | TB_CLI_INSURANCE | CURR | 13(2) | WERTV7 | ||||
ADIFFERENCE | Calculated Difference for Credit Life Insurance | TB_LOLIINBAL | CURR | 13(2) | WERTV7 | ||||
ICONSIDER | Transfer CLI Difference | TB_ICONSIDER | CHAR | 1 | XFELD | ||||
CALCULATION_DATE | CLI: Key Date for Calculation of Credit Life Insurance | TB_CLI_CALCULATION_DATE | DATS | 8 | DATUM | ||||
UCLICURR | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | WAERS | ||||
CLI_FLOW_SBEWART | Flow Type | SBEWART | CHAR | 4 | SBEWART | ||||
CLI_CHANGED | Checkbox | XFELD | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP append structure ADEFCAP using ABAP code?
As ADEFCAP 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 ADEFCAP as there is no data to select. You could however select data from any tables that this append structure has been assigned too.How to access SAP table ADEFCAP
Within an ECC or HANA version of SAP you can also view further information about ADEFCAP and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects