RSORT_AND_DETAILS SAP (Sort Fields and Overpayments with Relevant Payoffs) Structure details
Description: Sort Fields and Overpayments with Relevant Payoffs
Related tables to RSORT_AND_DETAILS
Access table RSORT_AND_DETAILS
Structure field list including key, data, relationships and ABAP select examples
RSORT_AND_DETAILS 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 Overpayments with Relevant 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_DETAILS TYPE RSORT_AND_DETAILS.
The RSORT_AND_DETAILS table consists of various fields, each holding specific information or linking keys about Sort Fields and Overpayments with Relevant 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_DETAILS 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 | ||||
SERIAL_NUMBER | Sequence Number | TB_SERIAL_NUMBER | INT4 | 10 | INT4 | ||||
REVOCATION_STATUS | Rescission Status | TB_REVOCATION_STATUS | NUMC | 1 | T_REVOCATION_STATUS | ||||
FLG_CN_IN_DISSOLUTION | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
PRODUCT_TYPE | Product Type | VVSART | CHAR | 3 | Assigned to domain | VVSART | SAN | VVSART_APPL_BAS | |
BSID_COUNTER | Natural Number | INT4 | INT4 | 10 | INT4 | ||||
BSID | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | BUKRS | BUK | C_T001 | ||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | ALPHA | KUNNR | KUN | C_KUNNR | |
UMSKS | Special G/L Transaction Type | UMSKS | CHAR | 1 | UMSKS | ||||
UMSKZ | Special G/L Indicator | UMSKZ | CHAR | 1 | UMSKZ | ||||
AUGDT | Clearing Date | AUGDT | DATS | 8 | DATUM | ||||
AUGBL | Document Number of the Clearing Document | AUGBL | CHAR | 10 | ALPHA | BELNR | |||
ZUONR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | BUZEI | BUZ | |||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8 | DATUM | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | WAERS | FWS | |||
XBLNR | Reference Document Number | XBLNR1 | CHAR | 16 | XBLNR1 | ||||
BLART | Document Type | BLART | CHAR | 2 | BLART | BAR | |||
MONAT | Fiscal Period | MONAT | NUMC | 2 | MONAT | ||||
BSCHL | Posting Key | BSCHL | CHAR | 2 | BSCHL | ||||
ZUMSK | Target Special G/L Indicator | DZUMSK | CHAR | 1 | UMSKZ | ||||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
GSBER | Business Area | GSBER | CHAR | 4 | GSBER | GSB | |||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | MWSKZ | ||||
DMBTR | Amount in Local Currency | DMBTR | CURR | 13(2) | WERT7 | ||||
WRBTR | Amount in document currency | WRBTR | CURR | 13(2) | WERT7 | ||||
MWSTS | Tax Amount in Local Currency | MWSTS | CURR | 13(2) | WERT7 | ||||
WMWST | Tax amount in document currency | WMWST | CURR | 13(2) | WERT7 | ||||
BDIFF | Valuation Difference | BDIFF | CURR | 13(2) | WRTV7 | ||||
BDIF2 | Valuation Difference for the Second Local Currency | BDIF2 | CURR | 13(2) | WRTV7 | ||||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
PROJN | Old: Project number : No longer used --> PS_POSNR | PROJN | CHAR | 16 | PROJN | ||||
AUFNR | Order Number | AUFNR | CHAR | 12 | ALPHA | AUFNR | ANR | ||
ANLN1 | Main Asset Number | ANLN1 | CHAR | 12 | ALPHA | ANLN1 | AN1 | ||
ANLN2 | Asset Subnumber | ANLN2 | CHAR | 4 | ALPHA | ANLN2 | AN2 | ||
SAKNR | G/L Account Number | SAKNR | CHAR | 10 | ALPHA | SAKNR | SAK | C_SAKNR | |
HKONT | General Ledger Account | HKONT | CHAR | 10 | ALPHA | SAKNR | |||
FKONT | Financial Budget Item | FIPLS | NUMC | 3 | FIPLS | ||||
FILKD | Account Number of the Branch | FILKD | CHAR | 10 | ALPHA | MAXKK | |||
ZFBDT | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | DATUM | ||||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
ZBD1T | Cash discount days 1 | DZBD1T | DEC | 3 | ZBDXT | ||||
ZBD2T | Cash discount days 2 | DZBD2T | DEC | 3 | ZBDXT | ||||
ZBD3T | Net Payment Terms Period | DZBD3T | DEC | 3 | ZBDXT | ||||
ZBD1P | Cash Discount Percentage 1 | DZBD1P | DEC | 5(3) | PRZ23 | ||||
ZBD2P | Cash Discount Percentage 2 | DZBD2P | DEC | 5(3) | PRZ23 | ||||
SKFBT | Amount Eligible for Cash Discount in Document Currency | SKFBT | CURR | 13(2) | WERT7 | ||||
SKNTO | Cash discount amount in local currency | SKNTO | CURR | 13(2) | WERT7 | ||||
WSKTO | Cash discount amount in document currency | WSKTO | CURR | 13(2) | WERT7 | ||||
ZLSCH | Payment Method | DZLSCH | CHAR | 1 | ZLSCH | ||||
ZLSPR | Payment Block Key | DZLSPR | CHAR | 1 | ZAHLS | SPE | |||
ZBFIX | Fixed Payment Terms | DZBFIX | CHAR | 1 | ZBFIX | ||||
HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | HBKID | ||||
BVTYP | Partner Bank Type | BVTYP | CHAR | 4 | BVTYP | ||||
REBZG | Number of the Invoice the Transaction Belongs to | REBZG | CHAR | 10 | ALPHA | BELNR | |||
REBZJ | Fiscal Year of the Relevant Invoice (for Credit Memo) | REBZJ | NUMC | 4 | GJAHR | GJAHR | |||
REBZZ | Line Item in the Relevant Invoice | REBZZ | NUMC | 3 | BUZEI | ||||
SAMNR | Invoice List Number | SAMNR | NUMC | 8 | SAMNR | ||||
ANFBN | Document Number of the Bill of Exchange Payment Request | ANFBN | CHAR | 10 | ALPHA | BELNR | |||
ANFBJ | Fiscal Year of the Bill of Exchange Payment Request Document | ANFBJ | NUMC | 4 | GJAHR | GJAHR | |||
ANFBU | Company Code in Which Bill of Exch.Payment Request Is Posted | ANFBU | CHAR | 4 | BUKRS | ||||
ANFAE | Bill of Exchange Payment Request Due Date | ANFAE | DATS | 8 | DATUM | ||||
MANSP | Dunning block | MANSP | CHAR | 1 | MANSP | ||||
MSCHL | Dunning key | MSCHL | CHAR | 1 | MSCHL | ||||
MADAT | Last dunned on | MADAT | DATS | 8 | DATUM | ||||
MANST | Dunning level | MAHNS_D | NUMC | 1 | MAHNS | ||||
MABER | Dunning Area | MABER | CHAR | 2 | MABER | ||||
XNETB | Indicator: Document posted net ? | XNETB | CHAR | 1 | XFELD | ||||
XANET | Indicator: Down payment in net procedure ? | XANET | CHAR | 1 | XFELD | ||||
XCPDD | Indicator: Address and bank data set individually | XCPDD | CHAR | 1 | XFELD | ||||
XINVE | Indicator: Capital Goods Affected? | XINVE | CHAR | 1 | XFELD | ||||
XZAHL | Indicator: Is the posting key used in a payment transaction? | XZAHL | CHAR | 1 | XFELD | ||||
MWSK1 | Tax Code for Distribution | MWSKX | CHAR | 2 | MWSKZ | ||||
DMBT1 | Amount in Local Currency for Tax Distribution | DMBTX | CURR | 13(2) | WRTV7 | ||||
WRBT1 | Amount in foreign currency for tax breakdown | WRBTX | CURR | 13(2) | WRTV7 | ||||
MWSK2 | Tax Code for Distribution | MWSKX | CHAR | 2 | MWSKZ | ||||
DMBT2 | Amount in Local Currency for Tax Distribution | DMBTX | CURR | 13(2) | WRTV7 | ||||
WRBT2 | Amount in foreign currency for tax breakdown | WRBTX | CURR | 13(2) | WRTV7 | ||||
MWSK3 | Tax Code for Distribution | MWSKX | CHAR | 2 | MWSKZ | ||||
DMBT3 | Amount in Local Currency for Tax Distribution | DMBTX | CURR | 13(2) | WRTV7 | ||||
WRBT3 | Amount in foreign currency for tax breakdown | WRBTX | CURR | 13(2) | WRTV7 | ||||
BSTAT | Document Status | BSTAT_D | CHAR | 1 | BSTAT | ||||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | ALPHA | RCOMP | PGS | ||
VBELN | Billing Document | VBELN_VF | CHAR | 10 | ALPHA | VBELN | VF | ||
REBZT | Follow-On Document Type | REBZT | CHAR | 1 | REBZT | ||||
INFAE | Inverted Date for Net Due Date | INFAE | CHAR | 8 | CHAR08 | ||||
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
EGBLD | Country of Destination for Delivery of Goods | EGBLD | CHAR | 3 | LAND1 | ||||
EGLLD | Supplying Country for Delivery of Goods | EGLLD | CHAR | 3 | LAND1 | ||||
RSTGR | Reason Code for Payments | RSTGR | CHAR | 3 | RSTGR | ||||
XNOZA | Indicator: Account is not counted | XNOZA | CHAR | 1 | XFELD | ||||
VERTT | Contract Type | RANTYP | CHAR | 1 | RANTYP | ||||
VERTN | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
VBEWA | Flow Type | SBEWART | CHAR | 4 | SBEWART | ||||
WVERW | Bill of exchange usage type | WVERW | CHAR | 1 | WVERW | ||||
PROJK | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | KONPR | PS_POSNR | |||
FIPOS | Commitment Item | FIPOS | CHAR | 14 | FIPOS | FIP | |||
NPLNR | Network Number for Account Assignment | NPLNR | CHAR | 12 | ALPHA | AUFNR | NET | ||
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
APLZL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
XEGDR | Indicator: Triangular deal within the EU ? | XEGDR | CHAR | 1 | XFELD | ||||
DMBE2 | Amount in Second Local Currency | DMBE2 | CURR | 13(2) | WERT7 | ||||
DMBE3 | Amount in Third Local Currency | DMBE3 | CURR | 13(2) | WERT7 | ||||
DMB21 | Amount in Second Local Currency for Tax Breakdown | DMB2X | CURR | 13(2) | WRTV7 | ||||
DMB22 | Amount in Second Local Currency for Tax Breakdown | DMB2X | CURR | 13(2) | WRTV7 | ||||
DMB23 | Amount in Second Local Currency for Tax Breakdown | DMB2X | CURR | 13(2) | WRTV7 | ||||
DMB31 | Amount in Third Local Currency for Tax Breakdown | DMB3X | CURR | 13(2) | WRTV7 | ||||
DMB32 | Amount in Third Local Currency for Tax Breakdown | DMB3X | CURR | 13(2) | WRTV7 | ||||
DMB33 | Amount in Third Local Currency for Tax Breakdown | DMB3X | CURR | 13(2) | WRTV7 | ||||
BDIF3 | Valuation Difference for the Third Local Currency | BDIF3 | CURR | 13(2) | WRTV7 | ||||
XRAGL | Indicator: Clearing was Reversed | XRAGL | CHAR | 1 | XFELD | ||||
UZAWE | Payment Method Supplement | UZAWE | CHAR | 2 | UZAWE | ||||
XSTOV | Indicator: Document is flagged for reversal | XSTOV | CHAR | 1 | XFELD | ||||
MWST2 | Tax Amount in Second Local Currency | MWST2 | CURR | 13(2) | WERT7 | ||||
MWST3 | Tax Amount in Third Local Currency | MWST3 | CURR | 13(2) | WERT7 | ||||
SKNT2 | Cash Discount Amount in Second Local Currency | SKNT2 | CURR | 13(2) | WERT7 | ||||
SKNT3 | Cash Discount Amount in Third Local Currency | SKNT3 | CURR | 13(2) | WERT7 | ||||
XREF1 | Business partner reference key | XREF1 | CHAR | 12 | CHAR12 | ||||
XREF2 | Business partner reference key | XREF2 | CHAR | 12 | CHAR12 | ||||
XARCH | Indicator: Document already archived ? | XARCH | CHAR | 1 | XFELD | ||||
PSWSL | Update Currency for General Ledger Transaction Figures | PSWSL | CUKY | 5 | WAERS | ||||
PSWBT | Amount for Updating in General Ledger | PSWBT | CURR | 13(2) | WERT7 | ||||
LZBKZ | State Central Bank Indicator | LZBKZ | CHAR | 3 | LZBKZ | ||||
LANDL | Supplying Country | LANDL | CHAR | 3 | LAND1 | ||||
IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | IMKEY | ||||
VBEL2 | Sales Document | VBELN_VA | CHAR | 10 | ALPHA | VBELN | AUN | ||
VPOS2 | Numeric field: Length 6 | NUM06 | NUMC | 6 | NUM06 | ||||
POSN2 | Sales Document Item | POSNR_VA | NUMC | 6 | POSNR | APO | |||
ETEN2 | Delivery Schedule Line Number | ETENR | NUMC | 4 | ETENR | ||||
FISTL | Funds Center | FISTL | CHAR | 16 | FISTL | FIS | |||
GEBER | Fund | BP_GEBER | CHAR | 10 | BP_GEBER | FIC | |||
DABRZ | Reference Date for Settlement | DABRBEZ | DATS | 8 | DDAT | ||||
XNEGP | Indicator: Negative posting | XNEGP | CHAR | 1 | XFELD | ||||
KOSTL | Cost Center | KOSTL | CHAR | 10 | ALPHA | KOSTL | KOS | ||
RFZEI | Payment Card Item | RFZEI_CC | NUMC | 3 | NUM03 | ||||
KKBER | Credit control area | KKBER | CHAR | 4 | KKBER | KKB | |||
EMPFB | Payee/Payer | EMPFB | CHAR | 10 | ALPHA | MAXKK | |||
PRCTR | Profit Center | PRCTR | CHAR | 10 | ALPHA | PRCTR | PRC | PRCTR_EMPTY | |
XREF3 | Reference key for line item | XREF3 | CHAR | 20 | CHAR20 | ||||
QSSKZ | Withholding Tax Code | QSSKZ | CHAR | 2 | QSSKZ | ||||
ZINKZ | Exempted from interest calculation | DZINKZ | CHAR | 2 | ZINKZ | ||||
DTWS1 | Instruction key 1 | DTAT16 | NUMC | 2 | DTWSX | ||||
DTWS2 | Instruction key 2 | DTAT17 | NUMC | 2 | DTWSX | ||||
DTWS3 | Instruction key 3 | DTAT18 | NUMC | 2 | DTWSX | ||||
DTWS4 | Instruction key 4 | DTAT19 | NUMC | 2 | DTWSX | ||||
XPYPR | Indicator: Items from Payment Program Blocked | XPYPR | CHAR | 1 | XFELD | ||||
KIDNO | Payment Reference | KIDNO | CHAR | 30 | CHAR30 | ||||
ABSBT | Credit management: Hedged amount | ABSBT | CURR | 13(2) | WERT7 | ||||
CCBTC | Payment cards: Settlement run | CCBTC | CHAR | 10 | ALPHA | CCBTC | |||
PYCUR | Currency for Automatic Payment | PYCUR | CUKY | 5 | WAERS | ||||
PYAMT | Amount in Payment Currency | PYAMT | CURR | 13(2) | WERT7 | ||||
BUPLA | Business Place | BUPLA | CHAR | 4 | J_1BBRANCH | ||||
SECCO | Section Code | SECCO | CHAR | 4 | SECCO | SECCO_ABA | |||
CESSION_KZ | Accounts Receivable Pledging Indicator | CESSION_KZ | CHAR | 2 | CESSION_KZ | ||||
PPDIFF | Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments) | PPDIFF | CURR | 13(2) | WRTV7 | ||||
PPDIF2 | Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments) | PPDIF2 | CURR | 13(2) | WRTV7 | ||||
PPDIF3 | Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments) | PPDIF3 | CURR | 13(2) | WRTV7 | ||||
KBLNR | Document Number for Earmarked Funds | KBLNR_FI | CHAR | 10 | ALPHA | KBLNR | KBL | ||
KBLPOS | Earmarked Funds: Document Item | KBLPOS | NUMC | 3 | KBLPOS | KBP | |||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
GMVKZ | Item is in Execution | FM_GMVKZ | CHAR | 1 | FM_GMVKZ | ||||
SRTYPE | Type of Additional Receivable | FM_SRTYPE | CHAR | 2 | FM_SRTYPE | ||||
LOTKZ | Lot Number for Requests | PSO_LOTKZ | CHAR | 10 | ALPHA | LOTKZ | LOT | ||
FKBER | Functional Area | FKBER | CHAR | 16 | FKBER | FBE | |||
INTRENO | Internal Real Estate Master Data Code | VVINTRENO | CHAR | 13 | VVINTRENO | ||||
PPRCT | Partner Profit Center | PPRCTR | CHAR | 10 | ALPHA | PRCTR | PPC | ||
BUZID | Identification of the Line Item | BUZID | CHAR | 1 | CHAR1 | ||||
AUGGJ | Fiscal Year of Clearing Document | AUGGJ | NUMC | 4 | GJAHR | GJAHR | |||
HKTID | ID for account details | HKTID | CHAR | 5 | HKTID | ||||
BUDGET_PD | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | FM_BUDGET_PERIOD | BUDPER | |||
PAYS_PROV | Payment Service Provider | COM_WEC_PAYMENT_SRV_PROVIDER | CHAR | 4 | COM_WEC_PAYMENT_SRV_PROVIDER | ||||
PAYS_TRAN | Payment Reference of Payment Service Provider | FPS_TRANSACTION | CHAR | 35 | COM_WEC_PSP_TRANSACTION_ID | ||||
MNDID | Unique Referene to Mandate per Payment Recipient | SEPA_MNDID | CHAR | 35 | ID035 | ||||
.INCLU--AP | 0 | ||||||||
KONTT | Account Assignment Category for Industry Solution | KONTT_FI | CHAR | 2 | KONTT_FI | ||||
KONTL | Acct assignment string for industry-specific acct assignmnts | KONTL_FI | CHAR | 50 | CHAR50 | ||||
UEBGDAT | Transfer date of an item to legal dunning proceeding | UEBGDAT | DATS | 8 | DATUM | ||||
.INCLU--AP | 0 | ||||||||
VNAME | Joint Venture | JV_NAME | CHAR | 6 | ALPHA | JV_NAME | JVV | ||
EGRUP | Equity group | JV_EGROUP | CHAR | 3 | ALPHA | JV_EGROUP | GJE | ||
BTYPE | Payroll Type | JV_BILIND | CHAR | 2 | ALPHA | JV_BILIND | |||
.INCLU--AP | 0 | ||||||||
PROPMANO | Mandate, Mandate-Opening Contract | REHORECNNRM | CHAR | 13 | ALPHA | RECNNR | REHORECNNRM | ||
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_DETAILS using ABAP code?
As RSORT_AND_DETAILS 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_DETAILS as there is no data to select.How to access SAP table RSORT_AND_DETAILS
Within an ECC or HANA version of SAP you can also view further information about RSORT_AND_DETAILS 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