JBTLOSTAMM SAP (Loans (Master Data)) Structure details
Description: Loans (Master Data)
Structure field list including key, data, relationships and ABAP select examples
JBTLOSTAMM 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 "Loans (Master Data)" 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_JBTLOSTAMM TYPE JBTLOSTAMM.
The JBTLOSTAMM table consists of various fields, each holding specific information or linking keys about Loans (Master Data) data available in SAP. These include BUKRS (Company Code), 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 JBTLOSTAMM 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 |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
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 | 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 | ||||
SOBJEKT | Internal key for object | VVKEYOBJ | CHAR | 10 | VVKEY | ||||
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 | ||||
RANLALT1 | Alternative Identification | RANLALT1 | CHAR | 13 | CHAR13 | ||||
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 | ||||
RPNR | Activity number/rollover number | VVRPNR | NUMC | 8 | NUMC08 | ||||
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 | Internal Source Indicator | JBSIHERK | CHAR | 2 | JBSIHERK | ||||
RGENUM | Transaction Number | JBRGENUM | CHAR | 10 | JBRGENUM | JB5 | |||
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 | Borrower/Applicant Number | RDARNEHM_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
OBJNR | Object number for financial transactions | JBOBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | |||
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 | ||||
ZUOND | Assignment | TB_ZUOND | CHAR | 18 | TEXT18 | ||||
REFER | Internal Reference | TB_REFER | CHAR | 16 | CHAR16 | ||||
MERKM | Characteristics | TB_MERKM | CHAR | 25 | CHAR25 |
Key field | Non-key field |
How do I retrieve data from SAP structure JBTLOSTAMM using ABAP code?
As JBTLOSTAMM 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 JBTLOSTAMM as there is no data to select.How to access SAP table JBTLOSTAMM
Within an ECC or HANA version of SAP you can also view further information about JBTLOSTAMM 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