STR_BW_SINGLE_EXP SAP (Limit Utilizations at Transaction Level) Structure details
Description: Limit Utilizations at Transaction Level
Related tables to STR_BW_SINGLE_EXP
Access table STR_BW_SINGLE_EXP
Structure field list including key, data, relationships and ABAP select examples
STR_BW_SINGLE_EXP 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 "Limit Utilizations at Transaction Level" 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_STR_BW_SINGLE_EXP TYPE STR_BW_SINGLE_EXP.
The STR_BW_SINGLE_EXP table consists of various fields, each holding specific information or linking keys about Limit Utilizations at Transaction Level data available in SAP. These include SLA (Limit Type), RLV (Number of Limit Record), SLH (Hierarchy Level of Limit Record), SLI (Limit Utilization Status).. 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 STR_BW_SINGLE_EXP 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 |
SLA | Limit Type | TB_SLA | CHAR | 3 | Assigned to domain | T_SLA | TB_SLA | ||
RLV | Number of Limit Record | TB_RLV | NUMC | 20 | T_RLV | ||||
SLH | Hierarchy Level of Limit Record | TB_SLH | NUMC | 2 | NUMC2 | ||||
SLI | Limit Utilization Status | TB_SLI | NUMC | 1 | Assigned to domain | T_SLI | |||
DLI | Base Date for Determining Limit Utilization | TB_DLI | DATS | 8 | DATUM | ||||
VLI | 'Valid From' Date of the Limit Utilization | TB_VLI | DATS | 8 | DATUM | ||||
BLI | Limit Amount Utilized: Totals Record | TB_BLI_SUM | CURR | 17(2) | WERTV9 | ||||
CLI | Single Transaction Commitment Amount: Totals Record | TB_CLI_SUM | CURR | 17(2) | WERTV9 | ||||
BLS | Global Collateral Amount: Totals Record | TB_BLSS | CURR | 17(2) | WERTV9 | ||||
WLI | Currency of Utilization (Total) | TB_WLIS | CUKY | 5 | Assigned to domain | WAERS | |||
CLI_VW | Single Transaction Commitment Amount: Totals Record in LC/EC | TB_CLI_SUM_VW | CURR | 17(2) | WERTV9 | ||||
BLI_VW | Limit Utilization Amount: Totals Record in Limit/Displ. Crcy | TB_BLI_SUM_VW | CURR | 17(2) | WERTV9 | ||||
BLS_VW | Total Global Collateral Amount: Totals Record in LC/EC | TB_BLSS_VW | CURR | 17(2) | WERTV9 | ||||
WLIMIT | Limit Currency | TB_WLIMIT | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
FLI | Available Limit Amount | TB_BDELTA | CURR | 17(2) | WERTV9 | ||||
COMPERD | Maximum Risk Commitment Period in Months | TB_COMPERD | NUMC | 4 | NUMC4 | TB_COMPERD | |||
DLVE | Limit Valid To | TB_DLVE | DATS | 8 | DATUM | ||||
EDLVE | External Validity End Date of Limit | TB_EDLVE | DATS | 8 | DATUM | ||||
XLA | Name of Limit Type | TB_XLA | CHAR | 30 | TEXT30 | ||||
TLI | Object Number Category in Limit Management | TB_TLI | CHAR | 2 | TB_TLI | ||||
OBJNR | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
OBJTXT | Transaction Description | DTE_REP_BW_FO_TEXT | CHAR | 60 | |||||
CLI_IE | Single Transaction Commitment Amount | TB_CLI | CURR | 17(2) | WERTV9 | ||||
BLI_IE | Limit Utilization Amount: Single Record | TB_BLIE | CURR | 17(2) | WERTV9 | ||||
BLS_IE | Global Collateral Amount: Single Record | TB_BLSE | CURR | 17(2) | WERTV9 | ||||
COLI_IE | Collateral Amount For Single Transaction | TB_COLI | CURR | 17(2) | WERTV9 | ||||
WLI_IE | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
KLI | Exchange Rate for Limit Utilization | TB_KLI | DEC | 9(5) | EXCRT | UKURS | |||
CLI_IE_VW | Single Transaction Commitment Amount in Limit/Displ.Currency | TB_CLI_VW | CURR | 17(2) | WERTV9 | ||||
BLI_IE_VW | Limit Utilization Amount in Limit/Display Currency | TB_BLI_VW | CURR | 17(2) | WERTV9 | ||||
BLS_IE_VW | Global Collateral Amount: Single Record in Limit/Eval. Crcy | TB_BLSE_VW | CURR | 17(2) | WERTV9 | ||||
COLI_IE_VW | Collateral Amount for Single Trans. in Limit/Eval. Currency | TB_COLI_VW | CURR | 17(2) | WERTV9 | ||||
WLI_IE_VW | Display Currency (Single Record) | TB_WLIE_VW | CUKY | 5 | Assigned to domain | WAERS | |||
SLP | Percentage of Attribution | TB_SLP | DEC | 10(7) | DEC3_7 | ||||
RLI | Risk Commitment Period in Months | TB_RLI | NUMC | 4 | NUMC4 | ||||
SLI_IE | Limit Utilization Status | TB_SLI | NUMC | 1 | Assigned to domain | T_SLI | |||
SLE | Determination Procedure for Limit Utilizations | TB_SLE | NUMC | 2 | Assigned to domain | KL_DETPROC | |||
DLIL | Evaluation Date for Limit Utilizations | TB_DLIL | DATS | 8 | DATUM | ||||
TLIL | Time of Determination of Limit Utilizations | TB_TLIL | TIMS | 6 | UZEIT | ||||
DELTA | External Limit Amount | TB_ELIMIT | CURR | 17(2) | T_BLV | ||||
LIGHT | Traffic Light Icon | DTE_REP_BW_LIGHT | CHAR | 4 | Assigned to domain | ICON | |||
RELTEXT | Text for Release Status | TB_RELTEXT | CHAR | 12 | CHAR12 | ||||
CONSEXC | Red Traffic Light When Limit Exceeded | TB_CONSEXC | CHAR | 1 | XFELD | ||||
CONSRBD | Red Traffic Light When Risk Commitment Period Exceeded | TB_CONSRBD | CHAR | 1 | XFELD | ||||
EMPTYLI | Limits Without Utilizations | TB_EMPTYLI | CHAR | 1 | XFELD | ||||
DATEEMPTY | Start of Validity Period for Limits w/o Utilizations | TB_DATEEMPTY | DATS | 8 | DATUM | ||||
ACTDATE | Latest Determination Date per Limit Type | TB_ACTDATE | CHAR | 1 | XFELD | ||||
CALCHECK | Compare with Factory Calendar | TB_CALCHECK | CHAR | 1 | XFELD | ||||
ROUND | Rounding Control for Amount Fields | TB_ROUND | CHAR | 1 | ROUND | ||||
EXONLY | Only Exceeded Limits | TB_EXONLY | CHAR | 1 | XFELD | ||||
EXPLUS | Exceeded Limits and Analagous Characteristic Combinations | TB_EXPLUS | CHAR | 1 | XFELD | ||||
DISP_CURR | Display Currency | TB_DISP_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
PARTNR | Business Partner Number | BP_PARTNR_NEW | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BPA | BUPA |
SLPG | Limit Product Group | TB_SLPG | CHAR | 3 | ATLPG | T_SLPG | TB_SLPG | ||
RPORTB | Portfolio | RPORTB | CHAR | 10 | TWPOB | RPORTB | T50 | H_RPORTB_CORE | |
RDEALER | Trader | RDEALER | CHAR | 12 | TZDEA | RDEALER | |||
WAERS | Currency as Limit Characteristic | TB_WCHAR | CUKY | 5 | TCURC | WAERS | FWS | ||
CONTROL01 | Monitoring Unit | TB_CONTROL | CHAR | 10 | CHAR10 | TB_CONTROL | |||
INTORG | Internal Organizational Unit | TB_INTORGUNIT | CHAR | 10 | KLINTORG | KL_INTORG | TB_INTORG | ||
RCOUNTRY | Relevant Country for Country Risk | TB_RISKCOUNTRY | CHAR | 3 | T005 | LAND1 | TB_RCOUNTRY | H_T005 | |
COUNTRY | Country Key | LAND1_GP | CHAR | 3 | T005 | LAND1 | C_LAND1 | ||
SECTOR | Industry of Business Partner | TB_INDSECT | CHAR | 10 | TB038A | BU_INDSECTOR | |||
RATING | Rating | BP_RATING | CHAR | 3 | TP06 | BP_RATING | |||
CRATING | Country Rating | TB_COUNTRYRATING | CHAR | 5 | KLLRDEF01 | KL_CRATING | TB_CRATING | ||
RCID01 | Country Group | TB_RCID01 | CHAR | 5 | VTBLMCID | TB_RCID | TB_RCID01 | ||
RCID02 | Maturity Band in Credit Limit | TB_RCID02 | CHAR | 5 | VTBLMCID | TB_RCID | TB_RCID02 | ||
RCID03 | Free Characteristic 03 | TB_RCID03 | CHAR | 5 | VTBLMCID | TB_RCID | TB_RCID03 | ||
RCID04 | Free Characteristic 04 | TB_RCID04 | CHAR | 5 | VTBLMCID | TB_RCID | TB_RCID04 | ||
RCID05 | Free Characteristic 05 | TB_RCID05 | CHAR | 5 | VTBLMCID | TB_RCID | TB_RCID05 | ||
RCID06 | Free Characteristic 06 | TB_RCID06 | CHAR | 5 | VTBLMCID | TB_RCID | TB_RCID06 | ||
RCID07 | Free Characteristic 07 | TB_RCID07 | CHAR | 5 | VTBLMCID | TB_RCID | TB_RCID07 | ||
RCID08 | Free Characteristic 08 | TB_RCID08 | CHAR | 5 | VTBLMCID | TB_RCID | TB_RCID08 | ||
RCID09 | Free Characteristic 09 | TB_RCID09 | CHAR | 5 | VTBLMCID | TB_RCID | TB_RCID09 | ||
RCID10 | Free Characteristic 10 | TB_RCID10 | CHAR | 5 | VTBLMCID | TB_RCID | TB_RCID10 | ||
RCID11 | Free Characteristic 11 | TB_RCID11 | CHAR | 5 | VTBLMCID | TB_RCID | TB_RCID11 | ||
RCID12 | Free Characteristic 12 | TB_RCID12 | CHAR | 5 | VTBLMCID | TB_RCID | TB_RCID12 | ||
RCID13 | Free Characteristic 13 | TB_RCID13 | CHAR | 5 | VTBLMCID | TB_RCID | TB_RCID13 | ||
RCID14 | Free Characteristic 14 | TB_RCID14 | CHAR | 5 | VTBLMCID | TB_RCID | TB_RCID14 | ||
RCID15 | Free Characteristic 15 | TB_RCID15 | CHAR | 5 | VTBLMCID | TB_RCID | TB_RCID15 |
Key field | Non-key field |
How do I retrieve data from SAP structure STR_BW_SINGLE_EXP using ABAP code?
As STR_BW_SINGLE_EXP 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 STR_BW_SINGLE_EXP as there is no data to select.How to access SAP table STR_BW_SINGLE_EXP
Within an ECC or HANA version of SAP you can also view further information about STR_BW_SINGLE_EXP 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