JBD_STR_LOAN_ATTRIB_MAP SAP (Loan: Attributes) Structure details
Description: Loan: Attributes
Related tables to JBD_STR_LOAN_ATTRIB_MAP
Access table JBD_STR_LOAN_ATTRIB_MAP
Structure field list including key, data, relationships and ABAP select examples
JBD_STR_LOAN_ATTRIB_MAP 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 "Loan: Attributes" 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_JBD_STR_LOAN_ATTRIB_MAP TYPE JBD_STR_LOAN_ATTRIB_MAP.
The JBD_STR_LOAN_ATTRIB_MAP table consists of various fields, each holding specific information or linking keys about Loan: Attributes data available in SAP. These include RANLALT1 (Alternative Identification), SARCHIV (Archiving Category Indicator), RANL (Contract Number), RERF (Entered by).. 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: Not classified
SAP JBD_STR_LOAN_ATTRIB_MAP 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 | |
RANLALT1 | Alternative Identification | RANLALT1 | CHAR | 13 | CHAR13 | ||||
SARCHIV | Archiving Category Indicator | SARCHIV | CHAR | 1 | SARCHIV | ARC | |||
RANL | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
RERF | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
DERF | First Entered on | DERF | DATS | 8 | DATUM | ||||
TERF | Time of Initial Entry | JBD_DTE_TERF | TIMS | 6 | UZEIT | ||||
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 | JBD_DTE_TBEAR | TIMS | 6 | UZEIT | ||||
RBHER | Editing Source | RBHER | CHAR | 10 | CHAR10 | ||||
SSTATI | Status of data record | SSTATI | NUMC | 2 | Assigned to domain | STATI | |||
SANLF | Product Category | SANLF | NUMC | 3 | Assigned to domain | VVSANLF | |||
GSART | Product Type | VVSART | CHAR | 3 | Assigned to domain | VVSART | SAN | VVSART_APPL_BAS | |
RREFKONT | Account Assignment Reference in Financial Assets Management | RREFKONT | CHAR | 8 | Assigned to domain | USTRU | KRE | ||
HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | Assigned to domain | HBKID | |||
HKTID | ID for account details | HKTID | CHAR | 5 | Assigned to domain | HKTID | |||
STITEL | Loan Type Indicator | STITEL | NUMC | 3 | Assigned to domain | STITEL | |||
SGLZB | SCB asset group indicator | SGLZB | CHAR | 4 | Assigned to domain | SGLZB | |||
SFIBG | Asset Grouping Indicator | SFIBG | NUMC | 4 | Assigned to domain | SFIBG | |||
SBILK | Balance Sheet Indicator | SBILK | CHAR | 2 | Assigned to domain | SBILK | |||
XALKZ | Short name | XALKZ | CHAR | 15 | XKBEZ | ||||
XALLB | Long name | XALLB | CHAR | 60 | XLBEZ | ||||
XAKT | File Number | XAKT | CHAR | 32 | CHAR32 | ||||
RANLALT2 | Alternative identification 2 | RANLALT2 | CHAR | 13 | CHAR13 | ||||
SGR1 | Group Key 1 (Freely Available) | SGRP1 | CHAR | 6 | Assigned to domain | SGRP1 | |||
SGR2 | Group Key 2 (Freely Available) | SGRP2 | CHAR | 6 | Assigned to domain | 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 | ||||
BZUSAGE | Commitment capital | BZUSAGE | CURR | 13(2) | WERTV7 | ||||
DZUSAGE | Loan - Date of Commitment by Lender | DZUSAGE | DATS | 8 | DATUM | ||||
DBLFZ | Start of Term | DBLFZ | DATS | 8 | DATUM | ||||
DELFZ | End of Loan Term | DENDLFZ | DATS | 8 | DATUM | ||||
DBDIS | Start of distribution of discount | DBDIS | DATS | 8 | DDAT | ||||
SDISMETH | Discount distribution method | SDISMETH | NUMC | 1 | DISMETH | ||||
SSICHER | Primary collateral | SSICHER | CHAR | 4 | Assigned to domain | SSICH | |||
SVZWECK | Purpose of Loan | SVZWECK | CHAR | 2 | Assigned to domain | SVZWK | |||
SSONDER | Special treatment of loan | SSONDER | NUMC | 2 | Assigned to domain | SSONDER | |||
SFIWO | Indicator: Type of Residential Object Financing | SFIWO | CHAR | 2 | Assigned to domain | SFIWO | |||
SDTI | DTI indicator | SDTI | NUMC | 5 | NUMC | ||||
SHOME | Home statement | SHOME | NUMC | 3 | Assigned to domain | SHOME | |||
SLAENDER | Country ID | SLAENDER | CHAR | 3 | Assigned to domain | LAND1 | |||
AABTRET | Number of Assignments Still Possible | AABTRET | NUMC | 2 | NUM02 | ||||
BABTRET | Minimum amount for assignments | BABTRET | CURR | 13(2) | BWHR | ||||
SNICHTAB | Reason for Non-Acceptance | SNICHTAB | NUMC | 2 | Assigned to domain | SNICHTAB | |||
DARCHIV | Date of Rejection/Withdrawal | DARCHIV | DATS | 8 | DATUM | ||||
BGESDAR | Total amount of syndicated loan | BGESDAR | CURR | 13(2) | BWHR | ||||
DKONS | Syndicate loan date | DKONS | DATS | 8 | DATUM | ||||
SKWGKRED | Credit category indicator Para. 75 report (Austria) | SKWGKRED | NUMC | 1 | Assigned to domain | SKWGKRED | |||
SKWGDAR | Credit type indicator for Austrian reporting | SKWGDAR | NUMC | 1 | Assigned to domain | SKWGDAR | |||
JORIG | Posting system indicator for borrower's note loans | BUCHSYS | NUMC | 1 | BUCHSYS | ||||
VVSLOEKZ | Deletion indicator | VVSLOEKZ | NUMC | 1 | VVSLOEKZ | ||||
SDTYP | Loans Class | VVSDTYP | NUMC | 3 | Assigned to domain | VVSDTYP | |||
DBEWI | Approval date | VVDBEWI | DATS | 8 | DATUM | ||||
SABTRANS | Indicator for Possible Foreign Assignment | VVSABTRANS | CHAR | 1 | XFELD | ||||
AKONS | Number of syndicate members | VVAKONS | NUMC | 3 | NUM03 | ||||
SFGKZ | Release Indicator | VVSFGKZ | CHAR | 1 | VVSFGKZ | ||||
SABT | Assignee | VVSABT | CHAR | 4 | Assigned to domain | VVSABT | |||
MABER | Dunning Area | MABER | CHAR | 2 | Assigned to domain | MABER | |||
MAHNS | Dunning level | MAHNS_D | NUMC | 1 | MAHNS | ||||
MADAT | Last dunned on | MADAT | DATS | 8 | DATUM | ||||
RSBEAR | Dummy field 12 characters CHAR | DUMMY_12 | CHAR | 12 | CHAR12 | ||||
SONDST | Special posting treatment | VVSONDST | CHAR | 2 | Assigned to domain | VVSONDST | |||
SGRP3 | Group Key 3 (Freely Available) | SGRP3 | CHAR | 6 | Assigned to domain | SGRP3 | |||
SGRP4 | Group Key 4 (Freely Available) | SGRP4 | CHAR | 6 | Assigned to domain | SGRP4 | |||
SZKEY | Indicator for Control of Incoming Payment Distribution | VVSZKEY | NUMC | 2 | Assigned to domain | VVSZKEY | |||
BEGRU | Authorization Group | BEGRU | CHAR | 4 | BEGRU | ||||
SVERFU | Type of Restraint on Drawing | VVSVERFU | NUMC | 2 | Assigned to domain | VVSVERFU | |||
STITART | Borrower's Note Loan Security Type | VVSTITART | NUMC | 2 | Assigned to domain | VVSTITART | |||
NABTRV | Contract of assignment number | VVNABTRV | CHAR | 15 | CHAR15 | ||||
NAVAL | Guarantee number | VVNAVAL | CHAR | 15 | CHAR15 | ||||
DABTR | Date of assignment | VVDABTR | DATS | 8 | DATUM | ||||
DVERFU | Date of restraint on disposal upto | VVDVERFU | DATS | 8 | DATUM | ||||
SFGBEW | Transaction data to be released available | VVSFGBEW | NUMC | 2 | VVSFGBEW | ||||
DELSOZ | Date of last special interest payment period | VVDLESOZ | DATS | 8 | DATUM | ||||
RPORTB | Portfolio | RPORTB | CHAR | 10 | Assigned to domain | RPORTB | T50 | H_RPORTB_CORE | |
SREGION | Sales Region | VVSREGION | CHAR | 4 | Assigned to domain | VVSREGION | |||
SGESST | Branch Office | VVSGESST | CHAR | 4 | Assigned to domain | VVSGESST | |||
SBEA | Loan Processing Indicator | VVSBEA | NUMC | 2 | VVSBEA | ||||
SOBEZ | Organizational District | VVSOBEZ | CHAR | 2 | CHAR2 | ||||
SBEZIRK | Agent District | VVSBEZIRK | CHAR | 4 | CHAR4 | ||||
SPLIT | Debit position splitting | VVSPLIT | CHAR | 1 | XFELD | ||||
BNBUERG | Initial capital not guaranteed | VVBNBUERG | CURR | 13(2) | WERTV7 | ||||
SREFZINS | Loan With Reference Interest Rate | VVSREFZINS | CHAR | 1 | XFELD | ||||
SMAHNM | Loan Manual Dunning Level | VVSMAHNM | CHAR | 1 | Assigned to domain | VVSMAHNM | |||
SIHERK | Version Number Component | CHAR2 | CHAR | 2 | CHAR2 | ||||
RGENUM | Character Field Length = 10 | CHAR10 | CHAR | 10 | CHAR10 | ||||
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 | Assigned to domain | BP_RATING | |||
SRATAGEN | Rating agency | SRATAGEN_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
RDARNEHM | Business Partner Number | BP_PARTNR_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
BPEXT | Business Partner Number in External System | BU_BPEXT | CHAR | 20 | CHAR20 | ||||
HDN_KUNNR | Main Borrower Customer Number | HDN_KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
SKWG14_NEU | Position grouping acc. Para 14 GBA (Sec. and loans) | VVSKWG14 | CHAR | 2 | VVSKWG14 | ||||
RANLSTAMNR | Master number part of loan number for finding contracts | RANLSTAMNR | CHAR | 13 | ALPHA | RANL | |||
MIGDATE | Migration date | MIGDATE | DATS | 8 | DATUM | ||||
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 | ||||
SWHRORG | Loan currency before conversion to EURO | SWHRORG | CUKY | 5 | Assigned to domain | WAERS | |||
DCONVERT | Date loan was converted to EURO | DCONVERT | DATS | 8 | DATE | ||||
DCORRECT | Date for adjustment flows resulting from EURO conversion | DCORRECT | DATS | 8 | DATE | ||||
SAKTPAS | Indicator: Asset/Liability Transaction | VVSAKTPAS | CHAR | 1 | VVSAKTPAS | ||||
RPZAHL | Payer/payee | TB_RPZAHL_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | 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 | Assigned to domain | TPM_COM_VAL_CLASS | CVC |
Key field | Non-key field |
How do I retrieve data from SAP structure JBD_STR_LOAN_ATTRIB_MAP using ABAP code?
As JBD_STR_LOAN_ATTRIB_MAP 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 JBD_STR_LOAN_ATTRIB_MAP as there is no data to select.How to access SAP table JBD_STR_LOAN_ATTRIB_MAP
Within an ECC or HANA version of SAP you can also view further information about JBD_STR_LOAN_ATTRIB_MAP 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