RFVD_CORR_CL_DEFCAP_COLLATRL SAP (Collateral) Structure details
Description: Collateral
Related tables to RFVD_CORR_CL_DEFCAP_COLLATRL
Access table RFVD_CORR_CL_DEFCAP_COLLATRL
Structure field list including key, data, relationships and ABAP select examples
RFVD_CORR_CL_DEFCAP_COLLATRL 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 "Collateral" 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_RFVD_CORR_CL_DEFCAP_COLLATRL TYPE RFVD_CORR_CL_DEFCAP_COLLATRL.
The RFVD_CORR_CL_DEFCAP_COLLATRL table consists of various fields, each holding specific information or linking keys about Collateral data available in SAP. These include RSICHER (Collateral reference number), BUKRS (Company Code), RANL (Contract Number), SSICH (Collateral type).. 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 RFVD_CORR_CL_DEFCAP_COLLATRL 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 |
WA_COLLATERAL | 0 | ||||||||
RSICHER | Collateral reference number | RSICHER | NUMC | 8 | NUMC8 | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | BUKRS | BUK | C_T001 | ||
RANL | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
SSICH | Collateral type | SSICH | CHAR | 4 | SSICH | ||||
SSICHART | Category Of Collateral Group (Internal) | SSICHART | NUMC | 2 | SSICHART | ||||
XPAADR | Partner/address string | VVXPAADR | CHAR | 60 | CHAR60 | ||||
XLVNR | Contract / account number | XLVNR | CHAR | 15 | CHAR15 | ||||
XLVTARIF | Contract Rate/Group | XLVTARIF | CHAR | 15 | XKBEZ | ||||
DBLV | Contract Start | DBLV | DATS | 8 | DATUM | ||||
DELV | Contract End Date | DELV | DATS | 8 | DATUM | ||||
BVERTRAG | Contract Amount | BVERTRAG | CURR | 13(2) | WERTV7 | ||||
SVWAERS | Currency Key | WAERS | CUKY | 5 | WAERS | FWS | |||
BLVPR | Contract contribution/premium | BLVPR | CURR | 13(2) | WERTV7 | ||||
AMMRHY | Frequency in months | AMMRHY | NUMC | 3 | NUMC03 | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | WAERS | FWS | |||
XAKT | File Number | XAKT | CHAR | 32 | CHAR32 | ||||
XWPKN | Securities ID number (Display PRF5) | XWPKN | CHAR | 15 | XKBEZ | ||||
XALKZ | Short name | XALKZ | CHAR | 15 | XKBEZ | ||||
XALLB | Long name | XALLB | CHAR | 60 | XLBEZ | ||||
BNOMS | Nominal value | BNOMS | CURR | 13(2) | BWHR | ||||
PKUR | Price in percent | PKUR | DEC | 10(7) | DEC3_7 | ||||
BWKUR | Security price for unit quotation | BWKURS | CURR | 13(2) | BWKURS | ||||
PNOMZINS | Nominal interest rate | PNOMZINS | DEC | 10(7) | DEC3_7 | ||||
DBLFZ | Start of Term | DBLFZ | DATS | 8 | DATUM | ||||
DELFZ | End of Term | DELFZ | DATS | 8 | DATUM | ||||
BVALHYP | Mortgage value-dated amount | BVALHYP | CURR | 13(2) | BWHR | ||||
XADRDV4 | Property location/ name of vessel | XADRDV4 | CHAR | 50 | TEXT50 | ||||
BHAFTUNG | Value of assigned rights from collateral | BHAFTUNG | CURR | 13(2) | BWHR | ||||
BHAFTWHR | Currency | SWHR | CUKY | 5 | WAERS | WHR | |||
DABTRET | Date of assignment for collateral security | DABTRET | DATS | 8 | DATUM | ||||
DBESTAET | Assignment confirmation date | VVDABBST | DATS | 8 | DATUM | ||||
DANZEIGE | Assignment display date | VVDABANZ | DATS | 8 | DATUM | ||||
XURK | Document number | XURK | CHAR | 15 | CHAR15 | ||||
SDOKUART | Indicator for the type of document | SDOKUART | NUMC | 3 | SDOKUART | ||||
DURK | Document date/expert opinion date | DURK | DATS | 8 | DATUM | ||||
JPROL | Indicator: Taken into consideration for rollover | VVJPROL | CHAR | 1 | JANEI | ||||
DBEBEZ | Date of start of relationship | DBEBEZ | DATS | 8 | DATUM | ||||
DENBEZ | Date of end of relationship | DENBEZ | DATS | 8 | DATUM | ||||
JHAUPT | Primary collateral indicator | VVJHSICH | CHAR | 1 | JANEI | ||||
WA_LOAN | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
RSICHER | Collateral reference number | RSICHER | NUMC | 8 | NUMC8 | ||||
RERF | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
DERF | First Entered on | DERF | DATS | 8 | DATUM | ||||
TERF | Time of Initial Entry | TERF | TIMS | 6 | TIMES | ||||
REHER | Source of initial entry | REHER | CHAR | 10 | CHAR10 | ||||
RBEAR | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 | ||||
DBEAR | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
TBEAR | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
RBHER | Editing Source | RBHER | CHAR | 10 | CHAR10 | ||||
SSICH | Collateral type | SSICH | CHAR | 4 | SSICH | ||||
SSICHART | Category Of Collateral Group (Internal) | SSICHART | NUMC | 2 | SSICHART | ||||
BVALHYP | Mortgage value-dated amount | BVALHYP | CURR | 13(2) | BWHR | ||||
SWHRVAL | Currency Key | WAERS | CUKY | 5 | WAERS | FWS | |||
XADRDV4 | Property location/ name of vessel | XADRDV4 | CHAR | 50 | TEXT50 | ||||
XGBAMT | Land registry ID | XGBAMT | CHAR | 25 | XTEXT25 | ||||
XGVON | Land register district | XGBVON | CHAR | 25 | XTEXT25 | SH_GEM | |||
NBANDNR | Land register volume number | NBANDNR | CHAR | 15 | TEXT15 | ||||
NBLATTNR | Land register page number | NBLATTNR | CHAR | 15 | TEXT15 | ||||
XNRABT3 | No. of entry in Section 3 of land register | XNRABT3 | CHAR | 5 | CHAR5 | ||||
DEINTRAG | Date of entry | DEINTRAG | DATS | 8 | DDAT | ||||
XPARTNER | Name | NAME1 | CHAR | 30 | TEXT30 | ||||
XAKT | File Number | XAKT | CHAR | 32 | CHAR32 | ||||
KOMM1 | Name | XLBEZ | CHAR | 50 | XTEXT50 | ||||
KOMM2 | Name | XLBEZ | CHAR | 50 | XTEXT50 | ||||
RANL | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
SLAENDER | Country ID | SLAENDER | CHAR | 3 | LAND1 | ||||
.INCLU--AP | 0 | ||||||||
UEBERGABE_DAT | Date | DATUM | DATS | 8 | DATUM | ||||
WA_POLICY | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
RSICHER | Collateral reference number | RSICHER | NUMC | 8 | NUMC8 | ||||
RERF | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
DERF | First Entered on | DERF | DATS | 8 | DATUM | ||||
TERF | Time of Initial Entry | TERF | TIMS | 6 | TIMES | ||||
REHER | Source of initial entry | REHER | CHAR | 10 | CHAR10 | ||||
RBEAR | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 | ||||
DBEAR | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
TBEAR | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
RBHER | Editing Source | RBHER | CHAR | 10 | CHAR10 | ||||
SSICH | Collateral type | SSICH | CHAR | 4 | SSICH | ||||
SSICHART | Category Of Collateral Group (Internal) | SSICHART | NUMC | 2 | SSICHART | ||||
XLVNR | Contract / account number | XLVNR | CHAR | 15 | CHAR15 | ||||
XLVTARIF | Contract Rate/Group | XLVTARIF | CHAR | 15 | XKBEZ | ||||
DBLV | Contract Start | DBLV | DATS | 8 | DATUM | ||||
DELV | Contract End Date | DELV | DATS | 8 | DATUM | ||||
DVERTRAG | Contract Date | DVERTRAG | DATS | 8 | DATUM | ||||
BVERTRAG | Contract Amount | BVERTRAG | CURR | 13(2) | WERTV7 | ||||
SVWAERS | Currency Key | WAERS | CUKY | 5 | WAERS | FWS | |||
BLVPR | Contract contribution/premium | BLVPR | CURR | 13(2) | WERTV7 | ||||
SZAWS | Payment form (at start of period, mid-period, at period end) | SZAWS | NUMC | 1 | SZAHLDIV | ||||
AMMRHY | Frequency in months | AMMRHY | NUMC | 3 | NUMC03 | ||||
DFAELLIG | Due date/calculation date | DFAELLIG | DATS | 8 | DATUM | ||||
DZAHLUNG | Payment date | DZAHLUNG | DATS | 8 | DATUM | ||||
PSPZINS | Interest on savings for credit balance | PSPZINS | DEC | 10(7) | DEC3_7 | ||||
PBONUS | Bonus / dynamization factor | PBONUS | DEC | 10(7) | DEC3_7 | ||||
SPFSTAT | Pledge status indicator | SPFSTAT | NUMC | 2 | SPFSTAT | ||||
JZESSION | Assignment Indicator | JZESSION | CHAR | 1 | JANEI | ||||
KOMM1 | Name | XLBEZ | CHAR | 50 | XTEXT50 | ||||
KOMM2 | Name | XLBEZ | CHAR | 50 | XTEXT50 | ||||
XKBEZPRT | Short term/character | XKBEZPRT | CHAR | 15 | XKBEZ | ||||
XAKT | File Number | XAKT | CHAR | 32 | CHAR32 | ||||
SLVSON | Insurance Policy Special Treatment Indicator | VVSLVSON | NUMC | 2 | VVLVSON | ||||
DLVSON | Key Date for Special Treatment of Insurance | VVDLVSON | DATS | 8 | DATS | ||||
DFINAMT | Date of tax office report | VVDFINAMT | DATS | 8 | DATUM | ||||
SLVGRP1 | Internal Indicator | VVSLVGRP1 | CHAR | 6 | VVSLVGRP1 | ||||
SLVGRP2 | Internal indicator | VVSLVGRP2 | CHAR | 6 | VVSLVGRP2 | ||||
SBUEART1 | Guarantee type 2 | VVSBUEART1 | NUMC | 2 | VVSBUEART1 | ||||
SBUEART | Guarantee type 1 | VVSBUEART | NUMC | 2 | VVSBUEART | ||||
DBUERG | Date of statement of guarantee | VVDBUERG | DATS | 8 | DATUM | ||||
XKOKBEZ | Quota short name | VVXKOKBEZ | CHAR | 15 | CHAR15 | ||||
JDYNSTAT | Index-Linked Insurance Indicator | VVJDYNSTAT | CHAR | 1 | JANE | ||||
JDYNANN | Adoption of index-linked insurance indicator | VVJDYNANN | CHAR | 1 | JANE | ||||
DDYNANN | Acceptance date of last dynamics | VVDDYNDAT | DATS | 8 | DATUM | ||||
SLVHERK | Contract origin indicator | VVSLVHERK | NUMC | 1 | VVSLVHERK | ||||
BVORABL | Prospective maturity payment | VVVVORABL | CURR | 13(2) | BWHR | ||||
LVRECH | Calculation date of maturity payments | VVDLVRECH | DATS | 8 | DATUM | ||||
SLAENDER | Country ID | SLAENDER | CHAR | 3 | LAND1 | ||||
.INCLU--AP | 0 | ||||||||
CLI_COMMENT | Comment on Calculation of CLI Single Premium | TB_CLI_COMMENT | CHAR | 50 | CHAR50 | ||||
RECALC_COMMENT | Comment on Recalculation of CLI Single Premium | TB_CLI_RECALC_COMMENT | CHAR | 50 | CHAR50 | ||||
WA_STOCK | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
RSICHER | Collateral reference number | RSICHER | NUMC | 8 | NUMC8 | ||||
RERF | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
DERF | First Entered on | DERF | DATS | 8 | DATUM | ||||
TERF | Time of Initial Entry | TERF | TIMS | 6 | TIMES | ||||
REHER | Source of initial entry | REHER | CHAR | 10 | CHAR10 | ||||
RBEAR | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 | ||||
DBEAR | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
TBEAR | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
RBHER | Editing Source | RBHER | CHAR | 10 | CHAR10 | ||||
SSICH | Collateral type | SSICH | CHAR | 4 | SSICH | ||||
SSICHART | Category Of Collateral Group (Internal) | SSICHART | NUMC | 2 | SSICHART | ||||
XWPKN | Securities ID number (Display PRF5) | XWPKN | CHAR | 15 | XKBEZ | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | WAERS | FWS | |||
BKURSWRT | Market value of a security according to stmnt in PRF5 | BKURSWRT | CURR | 13(2) | BWHR | ||||
DKURSWRT | Date of valuation at market value | DKURSWRT | DATS | 8 | DATUM | ||||
BNEWE | Nominal value per share | BNEWE | CURR | 10(2) | VVBNENNW | ||||
BWKUR | Security price for unit quotation | BWKURS | CURR | 13(2) | BWKURS | ||||
PKUR | Price in percent | PKUR | DEC | 10(7) | DEC3_7 | ||||
ASTUECK | Number of units for unit-quoted securities | ASTUECK | DEC | 15(5) | ASTUECK | ||||
BNOMS | Nominal value | BNOMS | CURR | 13(2) | BWHR | ||||
XALKZ | Short name | XALKZ | CHAR | 15 | XKBEZ | ||||
XALLB | Long name | XALLB | CHAR | 60 | XLBEZ | ||||
XEMIT | Name of issuer (info) | XEMIT | CHAR | 50 | XDOKBS | ||||
PNOMZINS | Nominal interest rate | PNOMZINS | DEC | 10(7) | DEC3_7 | ||||
DEBEG | Issue start date | DEBEG | DATS | 8 | DATUM | ||||
XSERIE | Issue serial number | XSERIE | CHAR | 15 | XKBEZ | ||||
XREIHE | Issue Series | XREIHE | CHAR | 15 | XKBEZ | ||||
SVERWA | Custody type | SVERWA | CHAR | 1 | SVERWA | ||||
XDKBZ | Sec.acct position short description | XDKBZ | CHAR | 15 | XKBEZ | ||||
DBLFZ | Start of Term | DBLFZ | DATS | 8 | DATUM | ||||
DELFZ | End of Term | DELFZ | DATS | 8 | DATUM | ||||
XAKT | File Number | XAKT | CHAR | 32 | CHAR32 | ||||
KOMM1 | Name | XLBEZ | CHAR | 50 | XTEXT50 | ||||
KOMM2 | Name | XLBEZ | CHAR | 50 | XTEXT50 | ||||
RLDEPO | Securities Account | RLDEPO | CHAR | 10 | RLDEPO | DEP | ACC_CCD_CORE | ||
DURUEB | Date of document transfer/date of entry in debt register | VVDURUEB | DATS | 8 | DATS | ||||
BBWHR | Amount in position currency | BBWHR | CURR | 13(2) | WERTV7 | ||||
SLAENDER | Country ID | SLAENDER | CHAR | 3 | LAND1 |
Key field | Non-key field |
How do I retrieve data from SAP structure RFVD_CORR_CL_DEFCAP_COLLATRL using ABAP code?
As RFVD_CORR_CL_DEFCAP_COLLATRL 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 RFVD_CORR_CL_DEFCAP_COLLATRL as there is no data to select.How to access SAP table RFVD_CORR_CL_DEFCAP_COLLATRL
Within an ECC or HANA version of SAP you can also view further information about RFVD_CORR_CL_DEFCAP_COLLATRL 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