RSORT_AND_VDREPAYMENT SAP (Sort Fields and Payoffs) Structure details
Description: Sort Fields and Payoffs
Related tables to RSORT_AND_VDREPAYMENT
Access table RSORT_AND_VDREPAYMENT
Structure field list including key, data, relationships and ABAP select examples
RSORT_AND_VDREPAYMENT 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 "Sort Fields and Payoffs" 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_RSORT_AND_VDREPAYMENT TYPE RSORT_AND_VDREPAYMENT.
The RSORT_AND_VDREPAYMENT table consists of various fields, each holding specific information or linking keys about Sort Fields and Payoffs data available in SAP. These include XBUKRS (Company Code), XSZKEY (Indicator for Control of Incoming Payment Distribution), XVALSZKEY (Character field 13 digits), XKUNNR (Customer Numbers).. 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 RSORT_AND_VDREPAYMENT 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 |
SORT_KEY | 0 | ||||||||
XBUKRS | Company Code | BUKRS | CHAR | 4 | BUKRS | BUK | C_T001 | ||
XSZKEY | Indicator for Control of Incoming Payment Distribution | VVSZKEY | NUMC | 2 | VVSZKEY | ||||
XVALSZKEY | Character field 13 digits | CHAR13 | CHAR | 13 | CHAR13 | ||||
XKUNNR | Customer Numbers | KUNNR | CHAR | 10 | ALPHA | KUNNR | KUN | C_KUNNR | |
XWAERS | Currency Key | WAERS | CUKY | 5 | WAERS | FWS | |||
XDATE | Field of type DATS | DATS | DATS | 8 | DATS | ||||
VDREPAYMENT | 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_STATUS | Bus. operation status | TB_SBOSTATUS | CHAR | 1 | SBO_STATUS | ||||
SFGKZ | Release Workflow Indicator for the Business Operation | TB_SFGKZA | CHAR | 1 | T_SFGKZ | ||||
SRELSTAT | Internal Release Status in the Business Operations | TB_SRELSTAT | CHAR | 1 | T_SRELSTAT | ||||
SNOTIZ | Indicator for stored memo | SNOTIZ | CHAR | 1 | JANEI | ||||
DFAELL | Due Date of Business Operation | TB_DFAELLR | DATS | 8 | DATUM | ||||
BRVWR | Available Capital on Due Date | TB_BRVWR | CURR | 15(2) | WERTV8_TR | ||||
DEFSZ | Date of End of Fixed-Rate Period | TB_REPAY_DEFSZ | DATS | 8 | DATUM | ||||
BRPWR | Remaining Capital at the End of the Fixed Period | TB_BRPWR | CURR | 15(2) | WERTV8_TR | ||||
SBOTERM | Repayment Change During Partial Payoff | TB_SBOTERM | CHAR | 1 | T_SBO_TERM | ||||
XTEXT | Text (15 characters) | TEXT15 | CHAR | 15 | TEXT15 | ||||
SBWHR | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | WAERS | ||||
SBRUTTO | Gross procedure | TB_SBRUTTO | CHAR | 1 | JFLAGG | ||||
SNETTO | Net procedure | TB_SNETTO | CHAR | 1 | JFLAGG | ||||
BBBWHR | Gross Payoff Amount | TB_BBBWHR | CURR | 13(2) | WERTV7 | ||||
BCWHR | Net Payoff Amount | TB_BBNWHR | CURR | 13(2) | WERTV7 | ||||
BADDFLOWS | Other Flows | TB_ADDFLOWS | CURR | 13(2) | WERTV7 | ||||
BOVERDUE_ITEMS | Overdue Items | TB_OVERDUE_ITEMS | CURR | 13(2) | WERTV7 | ||||
BCREDITS | Credit Balance | TB_CREDITS | CURR | 13(2) | WERTV7 | ||||
BPROPPAYMENTS | Proportional Payments | TB_PROPPAYMENTS | CURR | 13(2) | WERTV7 | ||||
BDEFPAYMENTS | Deferred Payments | TB_DEFPAYMENTS | CURR | 13(2) | WERTV7 | ||||
BREGPAYMENTS | Regular Payments | TB_REGPAYMENTS | CURR | 13(2) | WERTV7 | ||||
BFELD1 | Amount Field 1 | TB_FELD1 | CURR | 13(2) | WERTV7 | ||||
BFELD2 | Amount Field 2 | TB_FELD2 | CURR | 13(2) | WERTV7 | ||||
BFELD3 | Amount Field 3 | TB_FELD3 | CURR | 13(2) | WERTV7 | ||||
BFELD4 | Amount Field 4 | TB_FELD4 | CURR | 13(2) | WERTV7 | ||||
BOUTSTANDING | Payments Outstanding Until Payoff Due Date | TB_OUTSTANDING | CURR | 13(2) | WERTV7 | ||||
IOA_AMOUNT | Interest on Arrears Calculated | TB_IOA_CALCULATION_RESULT | CURR | 13(2) | WERTV7 | ||||
BOFFSETNG_FLOWS | Offsetting Flows/Waivers/Write-Offs | TB_OFFSETNG_FLOWS | CURR | 13(2) | WERTV7 | ||||
.INCLU--AP | 0 | ||||||||
BREFUND | Refund for PPI | TB_REFUND_CMLCHN | CURR | 13(2) | WERTV7 | ||||
BHWHR | Payoff Amount in Local Currency | TB_BHNWHR | CURR | 13(2) | WERTV7 | ||||
KURS1 | Exchange rate | VVKURSF | DEC | 9(5) | EXCRT | KURSF | |||
SINCL | Inclusive Indicator for Due Date | TB_SINCL | CHAR | 1 | XFELD | ||||
SINCLINT | Inclusive indicator for beginning and end of a period | VVSINCL | NUMC | 1 | VVSINCL | ||||
SVULT | Month-End Indicator for Due Date | TB_SVULT | CHAR | 1 | VVSULT | ||||
DDISPO | Payment Date | TB_PAYDATE | DATS | 8 | DATUM | ||||
SKALID | Factory calendar | SKALID | CHAR | 2 | WFCID | H_TFACD | |||
SKALID2 | Calendar ID 2 (valid in connection with calendar ID 1) | VVSKALID2 | CHAR | 2 | WFCID | ||||
SBEWART | Payoff Flow Type | TB_SBEWART | CHAR | 4 | SBEWART | ||||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
BRPWR_FAELL | Remaining Capital on Due Date | TB_BRPWR_FAELL | CURR | 15(2) | WERTV8_TR | ||||
DELFZ | Previous Term End Without Payoff (Calculated) | TB_DELFZ_WITHOUT_REPAY | DATS | 8 | DATUM | ||||
DELFZ_REPAY | New Term End With Payoff | TB_DELFZ_WITH_REPAY | DATS | 8 | DATUM | ||||
BAVWR | Available Disbursement Obligation on Due Date | TB_BAVVWR | CURR | 15(2) | WERTV8_TR | ||||
BPARTREDUCTION | Reduction | TB_PARTREDUCTION | CURR | 13(2) | WERTV7 | ||||
BNONSETTLEDREPAY | Repayment not Settled | TB_NONSETTLEDREPAY | CURR | 13(2) | WERTV7 | ||||
JREPAY_SETTLEM | Repayment Settlement | TB_JREPAY_SETTLEMENT | CHAR | 1 | JFLAGG | ||||
JREGPAYMENTS | Treatment of Regular Payments | TB_JREGPAYMENTS | CHAR | 1 | JFLAGG | ||||
SKOART | Partial Payoff: Condition Type for Repayment ChangeC | TB_SKOART | NUMC | 4 | SKOART | ||||
DGUEL_KP | Repayment Change Effective From | TB_DGUEL_KP_REPAY | DATS | 8 | DATUM | ||||
BBASIS | Base Amount for Repayment Change | TB_BBASIS_REPAY | CURR | 13(2) | WERTV7 | ||||
PKOND | Repayment Rate for Repayment Change | TB_PKOND_REPAY | DEC | 10(7) | DECV3_7 | ||||
BKOND | Payment Installment for Repayment Change | TB_BKOND_REPAY | CURR | 13(2) | WERTV7 | ||||
SCONDCOLL | Repayment Clash | TB_SCONDCOLL | CHAR | 1 | TB_SCONDCOLL | ||||
DDEFERRAL_FROM | Start of Deferral Period | TB_DEFERRAL_FROM | DATS | 8 | DATUM | ||||
DGUEL_KK | Date Condition Effective from | DGUEL | DATS | 8 | DATUM | ||||
SPAYSIM | Indicator: Full Clearing for Actual Principle 1 | TB_SPAYSIM | CHAR | 1 | JFLAGG | ||||
PSSDKURS | Exchange Rate For Net Posted Borrower's Notes | TB_PSSDKURS | DEC | 10(7) | PWKURS | ||||
BNWHR | Nominal Payoff Amount | TB_REPAY_BNWHR | CURR | 13(2) | WERTV7 | ||||
JNOREGSETTLE | Available Capital Contains Regular Repayments | TB_NO_REG_SETTLEMENT | CHAR | 1 | JFLAGG | ||||
.INCLU--AP | 0 | ||||||||
DFAELL_ADJ | Due date adjustment indicator | TB_DFAELLR_ADJ_CMLCHN | CHAR | 1 | TD_DFAELLR_ADJ_CMLCHN | ||||
PARTNR | Payer of Payoff | TB_PARTNR_REPAY | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
ZLSCH | Payment Method | DZLSCH | CHAR | 1 | ZLSCH | ||||
BVTYP | Bank Details ID | TB_BVTYP | CHAR | 4 | BVTYP | ||||
SZART | Payment transaction | TB_SZART | CHAR | 1 | XFELD | ||||
JNODOIP | Blocked by Payoff: No Open Item Clearing for Loan | TB_JNODOIP | CHAR | 1 | XFELD | ||||
XNODUNN | Exclude Loan from Dunning Run | XNODUNN | CHAR | 1 | XFELD | ||||
KOSTL | Cost Center | KOSTL | CHAR | 10 | ALPHA | KOSTL | KOS | ||
SBUST | Posting control key | VVSBUST | NUMC | 2 | VVSBUST | ||||
SZEGEN | Generate incoming payment immediately | SZEGEN | NUMC | 2 | SZEGEN | ||||
DANGAM | Creation Date for the Offer | TB_DANGAM_REPAY | DATS | 8 | DATUM | ||||
DANGBIS | End of the Validity Period of the Offer | TB_DANGBIS_REPAY | DATS | 8 | DATUM | ||||
DANNAHME | Acceptance Date of the Offer | TB_DANNAHME_REPAY | DATS | 8 | DATUM | ||||
DKUENDDG | Date of Receipt of Notice | TB_DKUEND_REPAY | DATS | 8 | DATUM | ||||
SKUEND | Reason for Notice | TB_SKUEND_REPAY | NUMC | 3 | SKUEART | ||||
RREJECT_REASON | Reason for Rejection | TB_REJECT_REASON | CHAR | 3 | T_REASON | ||||
RREPAY_REASON | Payoff Reason | TB_REPAY_REASON | NUMC | 3 | SKUEART | ||||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | ALPHA | KUNNR | KUN | C_KUNNR | |
ZAHLS | Block Key for Payment | DZAHLS | CHAR | 1 | ZAHLS | ||||
XCONDPAYDATA | Keep Payment Data for Condition-Based Flows Acc to Cond. | XCONDPAYDATA | CHAR | 1 | XFELD | ||||
MABER | Dunning Area | MABER | CHAR | 2 | MABER | ||||
MANSP | Dunning block | MANSP | CHAR | 1 | MANSP | ||||
REMIT_INFO | Payment Notes Info | TB_REMIT_INFO | CHAR | 140 | T_REMIT_INFO | ||||
MNDID | Unique Referene to Mandate per Payment Recipient | SEPA_MNDID | CHAR | 35 | ID035 | ||||
UZAWE | Payment Method Supplement | UZAWE | CHAR | 2 | UZAWE | ||||
XNODUNN_OLD | Exclude Loan from Dunning Run | XNODUNN | CHAR | 1 | XFELD | ||||
JNODOIP_OLD | Blocked by Payoff: No Open Item Clearing for Loan | TB_JNODOIP | CHAR | 1 | XFELD | ||||
DEFSZ_OLD | Date of fixed period end | VVDEFSZ | DATS | 8 | DATUM | ||||
CHANGED | 0 | ||||||||
DFPOSPO | Date of Earliest Possible Payoff | TB_DFPOSPO | DATS | 8 | T_DFPOSPO | ||||
MREQUESTOR | Business Partner Requesting Payoff (BP Number) | TB_MREQUESTOR | CHAR | 10 | ALPHA | T_MREQUESTOR | |||
MSTOPCODE | Technical Key for Stop | TB_STOP | CHAR | 3 | T_STOP | ||||
MQUOTE | Business Operation Is Payoff Quote Or Payoff | TB_MQUOTE | CHAR | 1 | T_MQUOTE | ||||
MCOM_STATUS | Communication Status | TB_MCOM_STATUS | NUMC | 3 | T_MCOM_STATUS | ||||
DCOM_STATUS | Last Change to Communication Status | TB_DCOM_STATUS | DATS | 8 | T_DCOM_STATUS | ||||
MREMITCODE | Remittance Code | TB_REMIT_CODE | CHAR | 4 | CHAR4 | ||||
AACCRUED | Payments Accrued | TB_AACCRUED | CURR | 13(2) | T_AAMOUNT | ||||
APROJECTED | Projected Payments | TB_APROJECTED | CURR | 13(2) | T_AAMOUNT | ||||
AINS_DEBIT | Insurance Receivables (Debit) | TB_AINS_DEBIT | CURR | 13(2) | T_AAMOUNT | ||||
AINS_CREDIT | Insurance Credit Memos (Credit) | TB_AINS_CREDIT | CURR | 13(2) | T_AAMOUNT | ||||
AINTDIEM | Interest per Day | TB_AINTDIEM | CURR | 13(2) | T_AAMOUNT | ||||
MNOINS | No Insurance Calculation | TB_NOINS | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
LIFE_REPAY | Current Total Term of the Loan in Months | TB_LIFE_REPAY | DEC | 6 | DEC6 | ||||
OVERDUE_ITEMS | Arrears of Contract Capital as a Percentage | TB_OVERDUE_ITEMS_REPAY | DEC | 6 | DEC6 | ||||
FIRST_POS_NOTICE | Earliest Possible Notice Date | TB_FIRST_POS_NOTICE | DATS | 8 | DATE | ||||
INTERIM_ACCOUNT | Receivables Interim Account | TB_INTERIM_ACCOUNT | CHAR | 10 | ALPHA | T_INTERIM_ACCOUNT | |||
ENFORCM_PAYM | Collector | TB_ENFORCM_PAYM | CHAR | 10 | ALPHA | BU_PARTNER | |||
STATI_OLD | Contract Status Before Activation of Notice | TB_NOTICE_STATI_OLD | NUMC | 2 | STATI | ||||
DUNNING_DATE | Date of Last Dunning Notice | TB_DUNNING_DATE_REPAY | DATS | 8 | DATE | ||||
DUNNING_LEVEL | Last Dunning Level | TB_DUNNING_LEVEL_REPAY | NUMC | 1 | MAHNS | ||||
CLR_CATEGORY | Clearing Category | TB_REPAY_CLR_CATEGORY | NUMC | 2 | T_REPAY_CLR_CATEGORY | ||||
NO_INST_OLD | Previous Total of Loan Installments | TB_NO_INST_OLD | NUMC | 3 | |||||
INST_NEW | New Figure for Payment Installments | TB_INST_NEW | CURR | 13(2) | WERTV7 | ||||
NO_INST_NEW | New Total Number of Loan Installments | TB_NO_INST_NEW | NUMC | 3 | |||||
EXIT_INST_NEW | Amount of the Final Installment Payment for the Contract | TB_EXIT_INST | CURR | 13(2) | WERTV7 | ||||
EXIT_INST_OLD | Previous Amount of Clearing Installment | TB_EXIT_INST_OLD | CURR | 13(2) | WERTV7 | ||||
MONTHS_OLD | Overall Term in Months Without Payoff | TB_MONTHS_OLD | NUMC | 3 | |||||
MONTHS_NEW | Overall Term in Months with Payoff | TB_MONTHS_NEW | NUMC | 3 | |||||
.INCLU--AP | 0 | ||||||||
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 structure RSORT_AND_VDREPAYMENT using ABAP code?
As RSORT_AND_VDREPAYMENT 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 RSORT_AND_VDREPAYMENT as there is no data to select.How to access SAP table RSORT_AND_VDREPAYMENT
Within an ECC or HANA version of SAP you can also view further information about RSORT_AND_VDREPAYMENT 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