EXBWG SAP (Export Structure Cumulative Data (Drilldown)) Structure details
Description: Export Structure Cumulative Data (Drilldown)
Structure field list including key, data, relationships and ABAP select examples
EXBWG 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 "Export Structure Cumulative Data (Drilldown)" 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_EXBWG TYPE EXBWG.
The EXBWG table consists of various fields, each holding specific information or linking keys about Export Structure Cumulative Data (Drilldown) data available in SAP. These include DVONDAT (Start Date of Evaluation), DBISDAT (Date of evaluation end), RSTICH (Key date reference), BUKRS (Company Code).. 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 EXBWG 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 | |||
DVONDAT | Start Date of Evaluation | DVONDAT | DATS | 8 | DATUM | ||||
DBISDAT | Date of evaluation end | DBISDAT | DATS | 8 | DATUM | ||||
RSTICH | Key date reference | RSTICH | CHAR | 1 | RSTICH | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
RPORTB | Portfolio | RPORTB | CHAR | 10 | Assigned to domain | RPORTB | T50 | H_RPORTB_CORE | |
RANL | Security ID Number | VVRANLW | CHAR | 13 | Assigned to domain | ALPHA | WP_RANL | RAN | SECURITY_F4 |
VVRANLWX | Secondary index class data | VVRANLWXS | CHAR | 20 | CHAR20S | ||||
RLDEPO | Securities Account | VRLDEPO | CHAR | 10 | Assigned to domain | RLDEPO | DEP | ||
SANLF | Product Category | SANLF | NUMC | 3 | Assigned to domain | VVSANLF | |||
GSART | Product Type | VVSART | CHAR | 3 | Assigned to domain | VVSART | SAN | VVSART_APPL_BAS | |
SBEWART | Flow Type | SBEWART | CHAR | 4 | Assigned to domain | SBEWART | |||
RREFKONT | Acct Assignment Ref. for Operative Valn Area and Loan | TB_REFKONT | CHAR | 8 | Assigned to domain | USTRU | |||
HKONT | General Ledger Account | HKONT | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
SBILK | Balance Sheet Indicator | SBILK | CHAR | 2 | Assigned to domain | SBILK | |||
SHWHR | Local currency | SHWHR | CUKY | 5 | Assigned to domain | WAERS | |||
SBWHR | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | Assigned to domain | WAERS | |||
SCWHR | Currency of payment amount | FTI_SCWHR | CUKY | 5 | Assigned to domain | WAERS | |||
SPLWHR | Profit/loss currency | SPLWHR | CUKY | 5 | Assigned to domain | WAERS | |||
FLG_AKTNK | Flag for activated incidental costs | TPM_F_A_NK | CHAR | 1 | XFELD | ||||
SSIGN | Direction of flow | TB_SSIGN | CHAR | 1 | T_SSIGN | ||||
D_ASTUECK | Change in no. of units (for unit-quoted securities) | D_ASTUECK | DEC | 15(5) | ASTUECK | ||||
D_BNBW | Change in nominal value in position currency | D_BNOMBW | CURR | 15(2) | WERTV8_TR | ||||
D_VAL_TI_PC | Delta Security Valuation in Position Currency | FTI_D_VAL_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_TI_LC | Delta Security Valuation in Local Currency | FTI_D_VAL_TI_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_FX_LC | Delta Foreign Currency Valuation in Local Currency | FTI_D_VAL_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_CH_TI_PC | Delta Valuation of Capitalized Costs, Security, in PC | FTI_D_VAL_CH_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_CH_TI_LC | Delta Valuation of Capitalized Costs, Security, in LC | FTI_D_VAL_CH_TI_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_CH_FX_LC | Delta Valuation of Capitalized Costs, FX, in Local Currency | FTI_D_VAL_CH_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_CAHW | Payment amount in local currency | D_CASHHW | CURR | 15(2) | WERTV8_TR | ||||
D_CACW | Payment amount in payment currency | D_CASHCW | CURR | 15(2) | WERTV8_TR | ||||
D_AWHW | Change in acquisition value in local currency | D_AWHW | CURR | 15(2) | WERTV8_TR | ||||
D_AWBW | Change in acquisition value in position currency | D_AWBW | CURR | 15(2) | WERTV8_TR | ||||
D_BWHW | Change in book value in local currency | D_BWHW | CURR | 15(2) | WERTV8_TR | ||||
D_BWBW | Change in book values in position currency | D_BWBW | CURR | 15(2) | WERTV8_TR | ||||
D_NKBWHW | Delta Incidental Costs for Book Value in Local Currency | D_NKBWHW | CURR | 15(2) | WERTV8_TR | ||||
D_NKBWBW | Delta Incidental Costs for Book Value in Position Currency | D_NKBWBW | CURR | 15(2) | WERTV8_TR | ||||
D_ERHW | Profit/loss amount in local currency | FTI_ERFOLGHW | CURR | 15(2) | WERTV8_TR | ||||
D_ERBW | Profit/loss amount in position currency | FTI_ERFOLGBW | CURR | 15(2) | WERTV8_TR | ||||
D_ERFOLGPLW | Profit/loss amount in currency of profit/loss | FTI_ERFOLGPLW | CURR | 15(2) | WERTV8_TR | ||||
PABGERFHW | Revenue Accrued/Deferred in Local Currency | PABGERFHW | CURR | 15(2) | WERTV8_TR | ||||
PABGERFPL | Revenue Accrued/Deferred in Profit/Loss Currency | PABGERFPLW | CURR | 15(2) | WERTV8_TR | ||||
PABGERFBW | Revenue accrued/deferred in position currency (PC) | PABGERFBW | CURR | 15(2) | WERTV8_TR | ||||
FLG_PERABG | Flag for revenue records accrued/deferred | TPM_F_PABG | CHAR | 1 | XFELD | ||||
BUCHST | Posting status of flow for security | BUCHST | CHAR | 1 | BUCHST | ||||
GSVGANG | TR transaction activity for securities | GSVGANG | NUMC | 3 | GSVGANG | ||||
SFHAART | Financial Transaction Type | TB_SFHAART | CHAR | 3 | AT10 | T_SFHAART | T02 | C_AT10 | |
RFHA | Financial Transaction | TB_RFHA | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | FAN | VTBA |
NORDER | Order Number | NORDER | NUMC | 8 | NUM8 | ORD | |||
DORDER | Order day | DORDER | DATS | 8 | DATUM | ||||
RDEALER | Trader | RDEALER | CHAR | 12 | Assigned to domain | RDEALER | |||
RHANDPL | Exchange | VVRHANDPL | CHAR | 10 | Assigned to domain | VVRHANDPL | WHP | ||
RKONTRA | Reference to Counterparty | RKONTRA_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
RPBANK | Partner bank details | TB_RPBANK | CHAR | 4 | BVTYP | ||||
RAHABKI | Short key for own house bank | TB_RHABKI | CHAR | 5 | Assigned to domain | HBKID | |||
RAHKTID | Short key for house bank account | TB_RHKTID | CHAR | 5 | Assigned to domain | HKTID | |||
ZLSCH | Payment Method | DZLSCH | CHAR | 1 | Assigned to domain | ZLSCH | |||
RPZAHL | Payer/payee | TB_RPZAHL_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
SSTORNO | Reversal indicator | SSTORNO | CHAR | 1 | SSTORNO | ||||
BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
GL_ACCOUNT_D | Number of G/L Account: Debit | FTI_GLACC_D | CHAR | 10 | SKB1 | ALPHA | SAKNR | SAK | C_SAKNR |
GL_ACCOUNT_C | Number of G/L Account: Credit | FTI_GLACC_C | CHAR | 10 | SKB1 | ALPHA | SAKNR | SAK | C_SAKNR |
DBESTAND | Position value date | DBESTAND | DATS | 8 | DATUM | ||||
DBUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
DFAELL | Due date | DFAELL | DATS | 8 | DATUM | ||||
DDISPO | Value date / planning day | VVDWERTST | DATS | 8 | DATUM | ||||
DSCHLUSS | Date of business closing | VVDSCHLUSS | DATS | 8 | DATUM | ||||
DGJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
DMONAT | Fiscal Period | MONAT | NUMC | 2 | MONAT | ||||
JAHR | Calendar year | TB_JAHR | NUMC | 4 | GJAHR | GJAHR | |||
MONAT | Calendar month | TB_MONAT | NUMC | 2 | TB_MONAT | ||||
ZUOND | Assignment | TB_ZUOND | CHAR | 18 | TEXT18 | ||||
REFER | Internal Reference | TB_REFER | CHAR | 16 | CHAR16 | ||||
MERKM | Characteristics | TB_MERKM | CHAR | 25 | CHAR25 | ||||
NORDEXT | External Reference | TB_NORDEXT | CHAR | 16 | FTI_CHAR16LOW | ||||
KMNR | Corporate Action Number | KMNR | CHAR | 13 | Assigned to domain | ALPHA | VKMNR | KMA | |
LOT_ID | Identifier of the Lot | TPM_LOT_ID | RAW | 16 | SYSUUID | ||||
DLOTGENERATION | Date On Which Lot Was Generated | DLOTGENERATION | DATS | 8 | DATUM | ||||
TLOTGENERATION | Lot Generation Time | TLOTGENERATION | TIMS | 6 | UZEIT | ||||
LOTGENERATION_USER | Lot Entered By | FTI_LOTGENERATIONUSER | CHAR | 12 | SYCHAR12 | ||||
LOTGENERATION_BUSTRANSCAT | Business Transaction Category Which Generated the Lot | FTI_LOTGENERATION_BUSTRANSCAT | NUMC | 4 | TRDTS_BT_CAT | TPM_BUSTRANSCAT |
Key field | Non-key field |
How do I retrieve data from SAP structure EXBWG using ABAP code?
As EXBWG 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 EXBWG as there is no data to select.How to access SAP table EXBWG
Within an ECC or HANA version of SAP you can also view further information about EXBWG 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