RBCT_RANL SAP (CML BCT: Extraction Structure Loans) Structure details
Description: CML BCT: Extraction Structure Loans
Structure field list including key, data, relationships and ABAP select examples
RBCT_RANL 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 "CML BCT: Extraction Structure Loans" 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_RBCT_RANL TYPE RBCT_RANL.
The RBCT_RANL table consists of various fields, each holding specific information or linking keys about CML BCT: Extraction Structure Loans data available in SAP. These include BUKRS (Company Code), RANL (Contract Number), DATETO (Date in CHAR format), DATEFROM (Date in CHAR format).. 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 RBCT_RANL 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 |
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
RANL | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
DATETO | Date in CHAR format | DATE | CHAR | 8 | CHAR8 | ||||
DATEFROM | Date in CHAR format | DATE | CHAR | 8 | CHAR8 | ||||
SANLF | Product Category | SANLF | NUMC | 3 | TZAF | VVSANLF | |||
GSART | Product Type | VVSART | CHAR | 3 | TZPA | VVSART | SAN | VVSART_APPL_BAS | |
RREFKONT | Account Assignment Reference in Financial Assets Management | RREFKONT | CHAR | 8 | T037S | USTRU | KRE | ||
HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | T012 | HBKID | |||
HKTID | ID for account details | HKTID | CHAR | 5 | T012K | HKTID | |||
STITEL | Loan Type Indicator | STITEL | NUMC | 3 | TD03A | STITEL | |||
SGLZB | SCB asset group indicator | SGLZB | CHAR | 4 | TW07 | SGLZB | |||
SFIBG | Asset Grouping Indicator | SFIBG | NUMC | 4 | Assigned to domain | SFIBG | |||
SBILK | Balance Sheet Indicator | SBILK | CHAR | 2 | TW11 | SBILK | |||
XAKT | File Number | XAKT | CHAR | 32 | CHAR32 | ||||
RANLALT1 | Alternative Identification | RANLALT1 | CHAR | 13 | CHAR13 | ||||
RANLALT2 | Alternative identification 2 | RANLALT2 | CHAR | 13 | CHAR13 | ||||
SGR1 | Group Key 1 (Freely Available) | SGRP1 | CHAR | 6 | TDDG1 | SGRP1 | |||
SGR2 | Group Key 2 (Freely Available) | SGRP2 | CHAR | 6 | TDDG2 | SGRP2 | |||
RKLAMMER | Classification Number for Finance Projects | RKLAMMER | CHAR | 13 | ALPHA | RANL | |||
RANLKET | Principle loan investment number | RANLHPT | CHAR | 13 | CHAR13 | RAN | |||
RANTRAG | Application number | RANTRAG | CHAR | 13 | CHAR13 | ||||
SSOLIST | Plan/Actual principle | VVSSOLIST | CHAR | 1 | VVSSOLIST | ||||
SFRIST | Loan Term | SFRIST | NUMC | 2 | Assigned to domain | SFRIST | |||
BANTRAG | Capital applied for | BANTRAG | CURR | 13(2) | BWHR | ||||
SANTWHR | Currency | SWHR | CUKY | 5 | Assigned to domain | WAERS | WHR | ||
DANTRAG | Entry Date of Loan Application | DANTRAG | DATS | 8 | DATUM | ||||
DZUSAGE | Loan - Date of Commitment by Lender | DZUSAGE | DATS | 8 | DATUM | ||||
SSICHER | Primary collateral | SSICHER | CHAR | 4 | TD01 | SSICH | |||
SVZWECK | Purpose of Loan | SVZWECK | CHAR | 2 | TD07 | SVZWK | |||
SSONDER | Special treatment of loan | SSONDER | NUMC | 2 | TD10 | SSONDER | |||
SLAENDER | Country ID | SLAENDER | CHAR | 3 | T005 | LAND1 | |||
SNICHTAB | Reason for Non-Acceptance | SNICHTAB | NUMC | 2 | TDA5 | SNICHTAB | |||
JORIG | Posting system indicator for borrower's note loans | BUCHSYS | NUMC | 1 | BUCHSYS | ||||
SDTYP | Loans Class | VVSDTYP | NUMC | 3 | TD02 | VVSDTYP | |||
DBEWI | Approval date | VVDBEWI | DATS | 8 | DATUM | ||||
SABT | Assignee | VVSABT | CHAR | 4 | Assigned to domain | VVSABT | |||
MABER | Dunning Area | MABER | CHAR | 2 | T047M | MABER | |||
MAHNS | Dunning level | MAHNS_D | NUMC | 1 | MAHNS | ||||
MADAT | Last dunned on | MADAT | DATS | 8 | DATUM | ||||
SONDST | Special posting treatment | VVSONDST | CHAR | 2 | TD14 | VVSONDST | |||
SGRP3 | Group Key 3 (Freely Available) | SGRP3 | CHAR | 6 | TDDG3 | SGRP3 | |||
SGRP4 | Group Key 4 (Freely Available) | SGRP4 | CHAR | 6 | TDDG4 | SGRP4 | |||
SZKEY | Indicator for Control of Incoming Payment Distribution | VVSZKEY | NUMC | 2 | TVZ01 | VVSZKEY | |||
SVERFU | Type of Restraint on Drawing | VVSVERFU | NUMC | 2 | TZV05 | VVSVERFU | |||
STITART | Borrower's Note Loan Security Type | VVSTITART | NUMC | 2 | TD16 | VVSTITART | |||
RPORTB | Portfolio | RPORTB | CHAR | 10 | TWPOB | RPORTB | T50 | H_RPORTB_CORE | |
SREGION | Sales Region | VVSREGION | CHAR | 4 | TD18 | VVSREGION | |||
SGESST | Branch Office | VVSGESST | CHAR | 4 | TD17 | VVSGESST | |||
SBEA | Loan Processing Indicator | VVSBEA | NUMC | 2 | VVSBEA | ||||
SOBEZ | Organizational District | VVSOBEZ | CHAR | 2 | CHAR2 | ||||
SBEZIRK | Agent District | VVSBEZIRK | CHAR | 4 | CHAR4 | ||||
SMAHNM | Loan Manual Dunning Level | VVSMAHNM | CHAR | 1 | TDMAHNS_MAN | VVSMAHNM | |||
DRUECK | Date when loan will probably be redeemed | VVDRUECK | DATS | 8 | DATUM | ||||
SABGRENZ | Loan Discount Accrual/Deferral Method | VVSABGRD | CHAR | 1 | VVSABGRD | ||||
SFEST | Indicator for Control of Fixed Contract | VVFESTKZ | CHAR | 1 | VVFESTKZ | ||||
SRATING | Rating | BP_RATING | CHAR | 3 | TP06 | BP_RATING | |||
SRATAGEN | Rating agency | SRATAGEN_NEW | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BPA | BUPA |
RDARNEHM | Business Partner Number | BP_PARTNR_NEW | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BPA | BUPA |
OBJNR | Text string 22 characters | CHAR22 | CHAR | 22 | CHAR22 | ||||
HDN_KUNNR | Main Borrower Customer Number | HDN_KUNNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
RANLSTAMNR | Master number part of loan number for finding contracts | RANLSTAMNR | CHAR | 13 | ALPHA | RANL | |||
SDUNNCMP | Summarization Level for Dunning Letter | SDUNNCMP | CHAR | 2 | SDUNNCMP | ||||
XNODUNN | Exclude Loan from Dunning Run | XNODUNN | CHAR | 1 | XFELD | ||||
ZUOND | Assignment | TB_ZUOND | CHAR | 18 | TEXT18 | ||||
REFER | Internal Reference | TB_REFER | CHAR | 16 | CHAR16 | ||||
MERKM | Characteristics | TB_MERKM | CHAR | 25 | CHAR25 | ||||
SDUNCHARG | Post Dunning Charges and Interest to this Contract | SDUNCHARG | CHAR | 1 | XFELD | ||||
SAKTPAS | Indicator: Asset/Liability Transaction | VVSAKTPAS | CHAR | 1 | VVSAKTPAS | ||||
RPZAHL | Payer/payee | TB_RPZAHL_NEW | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BPA | BUPA |
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
JNOREPAY | Payoff Lock | TB_JNOREPAY | CHAR | 1 | XFELD | ||||
JNODOIP | Blocked by Payoff: No Open Item Clearing for Loan | TB_JNODOIP | CHAR | 1 | XFELD | ||||
COM_VAL_CLASS | General Valuation Class | TPM_COM_VAL_CLASS | NUMC | 4 | TRGC_COM_VALCL | TPM_COM_VAL_CLASS | CVC | ||
SSTATI | Status of data record | SSTATI | NUMC | 2 | TZC37 | STATI | |||
SSTATE_OF_EXEC | Region Where Contract Concluded | TB_SREGION | CHAR | 3 | Assigned to domain | REGIO | |||
BACKOFFICE_ID | Object ID | HROBJID | NUMC | 8 | Assigned to domain | HROBJID | PON | ||
PAYM_STATUS | Payment Status | TB_PAYM_STATUS | CHAR | 1 | T_PAYM_STATUS | ||||
DGUEL_KK | Date Condition Effective from | DGUEL | DATS | 8 | DATUM | ||||
NLFD_ANG | Offer consecutive number | NLFD_ANG | NUMC | 3 | LFNR3 | ||||
SKOKOART | Type of Condition Header | SKOKOART | NUMC | 2 | SKOKOART | ||||
STILGART | Repayment Type Indicator | STILGART | NUMC | 1 | STILGART | ||||
KZAHLUNG | Pay-in/disbursement rate | KZAHLUNG | DEC | 10(7) | DEC3_7 | ||||
BZUSAGE | Commitment capital | BZUSAGE | CURR | 13(2) | WERTV7 | ||||
PEFFZINS | Effective Interest Rate | PEFFZINS | DEC | 10(7) | DEC3_7 | ||||
SEFFMETH | Effective Interest Method (Financial Mathematics) | SEFFMETH | NUMC | 1 | SEFFMETH | ||||
SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | SZBMETH | ||||
SDISKO | Discounted | SDISKO | CHAR | 1 | SDISKO | ||||
DKUEND | Date of notice | DKUEND | DATS | 8 | DATUM | ||||
SKUEND | Reason for Notice | SKUEND | NUMC | 3 | TD04 | SKUEART | |||
DKUENDDG | Earliest Possible Date for Notice Given by the Lender | DKUENDDG | DATS | 8 | DATUM | ||||
DBLFZ | Start of Term | DBLFZ | DATS | 8 | DATUM | ||||
DELFZ | End of Term | DELFZ | DATS | 8 | DATUM | ||||
PMANEFFZ | Internal Effective Interest Rate | PEFFZINS_INTERN | DEC | 10(7) | DEC3_7 | ||||
SEFFM2 | Effective Interest Method (Financial Mathematics) | SEFFMETH | NUMC | 1 | SEFFMETH | ||||
SKUEGL | Notice Arrangement Lender | VVSKUEGL | NUMC | 3 | TD28 | VVSKUEGL | |||
DEFSZ | Date of fixed period end | VVDEFSZ | DATS | 8 | DATUM | ||||
DABEFFZ | Date when calculation of effective rate starts | VVDABEFFZ | DATS | 8 | DATUM | ||||
DKUENDDN | Earliest Possible Date for Notice Given by the Borrower | VVDKUENDDN | DATS | 8 | DATUM | ||||
SKUEDN | Notice Arrangement Borrower | VVSKUEDN | NUMC | 3 | TD29 | VVSKUEDN | |||
SKUEART | Notice Type for the Loan | VVSKUEART | NUMC | 3 | TD27 | VVSKUEART | |||
DMARKTZINS | ISB: Market Rate Date: Market Interest Rate for NPV Calc. | DMARKTZINS | DATS | 8 | DATS | ||||
NOM_INTEREST | Percentage rate for condition items | PKOND | DEC | 10(7) | DECV3_7 | ||||
INTEREST_TYPE | Interest Category | 0 | |||||||
SZSREF | Reference Interest Rate | SZSREF | CHAR | 10 | Assigned to domain | ZIREFKU | |||
INTEB | Financial Assets Management internal level | VVSINTEB | NUMC | 2 | Assigned to domain | INTEB | |||
NOMZINS | Nominal interest rate with 3 decimal places | NOMZI | DEC | 6(3) | NOMZI | ||||
EFFZC | Effective Interest Rate to 3 Decimal Places | 0 | |||||||
EFFZIC | Internal Effective Interest Rate to 3 Decimal Places | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure RBCT_RANL using ABAP code?
As RBCT_RANL 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 RBCT_RANL as there is no data to select.How to access SAP table RBCT_RANL
Within an ECC or HANA version of SAP you can also view further information about RBCT_RANL 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