EXBESTAND SAP (Export structure position data) Structure details
Description: Export structure position data
Structure field list including key, data, relationships and ABAP select examples
EXBESTAND 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 position 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_EXBESTAND TYPE EXBESTAND.
The EXBESTAND table consists of various fields, each holding specific information or linking keys about Export structure position data data available in SAP. These include RANTYP (Contract Type), BUKRS (Company Code), RANL (Security ID Number), VVRANLWX (Secondary index class data).. 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 EXBESTAND 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 | |||
RANTYP | Contract Type | RANTYP | CHAR | 1 | RANTYP | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
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 | RLDEPO | CHAR | 10 | Assigned to domain | RLDEPO | DEP | ACC_CCD_CORE | |
NORDER | Order Number | NORDER | NUMC | 8 | NUM8 | ORD | |||
STICHTAG | Key date | VVSTDAT | DATS | 8 | VVSTDAT | KEYDATE | |||
RSTICH | Key date reference | RSTICH | CHAR | 1 | RSTICH | ||||
BUCHST_BSE | Posting status for position determination (securities) | BUCHST_BSE | CHAR | 1 | BUCHST | ||||
RPORTB | Portfolio | RPORTB | CHAR | 10 | Assigned to domain | RPORTB | T50 | H_RPORTB_CORE | |
SANLF | Product Category | SANLF | NUMC | 3 | Assigned to domain | VVSANLF | |||
GSART | Product Type | VVSART | CHAR | 3 | Assigned to domain | VVSART | SAN | VVSART_APPL_BAS | |
INSTITUTE_CL | Credit rating institute: Class (Treasury - SE) | FTI_SOL_INSTITUTE_CLASS_DATA | CHAR | 4 | Assigned to domain | BP_SOL_INS | |||
RATING_CL | Class rating indicator (Treasury - SE) | FTI_RATING_CLASS_DATA | CHAR | 3 | Assigned to domain | BP_RATING | |||
RDPBANK | Depository Bank | RDEPOTBANK | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | ||
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 | ||
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
REPKE | Issuer Identity Key | REPKE_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
SNOTTYPE | Quotation type for option, future, security etc. | TB_NOTTYPE | CHAR | 1 | T_NOTTYPE | ||||
SNOTI | Quotation Indicator | SNOTI | NUMC | 1 | SNOTI | ||||
AAAAKTIE | Number of stocks issued | FTI_AAAKTIE | DEC | 12 | DEC12 | ||||
SBILK | Balance Sheet Indicator | SBILK | CHAR | 2 | Assigned to domain | SBILK | |||
SGLZB | SCB asset group indicator | SGLZB | CHAR | 4 | Assigned to domain | SGLZB | |||
SWPKLASS | Classification of bond | SWPKLASS | NUMC | 3 | Assigned to domain | SWPKLASS | |||
SROLEXT | General Security Classification | ALWPKL | CHAR | 3 | Assigned to domain | ALWPKL | |||
SWERTTYP | Security Type ID | SWERTTYP | NUMC | 1 | Assigned to domain | SAKTTYP | |||
SFOTY | Fund type indicator | SFOTY | NUMC | 1 | Assigned to domain | SFOTY | |||
SARTBET | Type of shareholding | SARTBET | NUMC | 2 | Assigned to domain | SARTBET | |||
DBLFZ | Start of Term | DBLFZ | DATS | 8 | DATUM | ||||
DELFZ | End of Term | DELFZ | DATS | 8 | DATUM | ||||
SWHRKOND | Interest Currency | TB_WHRKOND | CUKY | 5 | Assigned to domain | WAERS | |||
KBNEWE | Nominal Value per Stock (Independent of Currency) | VVBNEWE | DEC | 15(6) | VVKWKURS | ||||
KZAHLAKT | Pay-in rate | KZAHLAKT | DEC | 10(7) | DEC3_7 | ||||
PKOND | Interest rate as a percentage | TB_PKOND | DEC | 10(7) | DECV3_7 | ||||
BKOND | Interest rate as amount | TB_BKOND | CURR | 13(2) | WERTV7 | ||||
PEFFZINS | Effective Interest Rate | PEFFZINS | DEC | 10(7) | DEC3_7 | ||||
SEFFMETH | Effective Interest Method (Financial Mathematics) | SEFFMETH | NUMC | 1 | SEFFMETH | ||||
REWHR | Issue currency | REWHR | CUKY | 5 | Assigned to domain | WAERS | |||
SBWHR | Position Currency/Transaction Currency | TB_BWHR | CUKY | 5 | Assigned to domain | WAERS | |||
SHWHR | Local Currency | TB_SHWHR | CUKY | 5 | Assigned to domain | WAERS | |||
SNWHR | Quotation currency (which prices are in) | VVNOTWAERS | CUKY | 5 | Assigned to domain | WAERS | |||
ASTUECK | Number of units for unit-quoted securities | ASTUECK | DEC | 15(5) | ASTUECK | ||||
ASTUECK_SP | No. of Units Blocked for Unit-Quoted Securities | ASTUECK_SP | DEC | 15(5) | ASTUECK | ||||
BNOMINAL | Nominal amount in position currency | BNOMINAL | CURR | 15(2) | WERTV8_TR | ||||
BNOMINA_SP | Locked Nominal Amount in Position Currency | BNOMINAL_SP | CURR | 15(2) | WERTV8_TR | ||||
BKAUFWR | Acquisition value in position currency | BKAUFWR | CURR | 15(2) | WERTV8_TR | ||||
BKAUFHW | Acquisition value in local currency | BKAUFHW | CURR | 15(2) | WERTV8_TR | ||||
BBUCHWR | Book value in position currency | BBUCHWR | CURR | 15(2) | WERTV8_TR | ||||
BBUCHHW | Book value in local currency | BBUCHHW | CURR | 15(2) | WERTV8_TR | ||||
BKOSTWR | Capitalized incid.costs acquisition value in pos. currency | BKOSTWR | CURR | 15(2) | WERTV8_TR | ||||
BKOSTHW | Capitalized incid.costs acquisition value in local currency | BKOSTHW | CURR | 15(2) | WERTV8_TR | ||||
BKSTBWR | Book value of capitalized incid. costs in position currency | VVBKSTBWR | CURR | 15(2) | WERTV8_TR | ||||
BKSTBHW | Book value of activated incid. costs in local currency | VVBKSTBHW | CURR | 15(2) | WERTV8_TR | ||||
BAMORTWR | Total of amortization in position currency | FTI_BAMORTWR | CURR | 15(2) | WERTV8_TR | ||||
BAMORTHW | Total of amortization in local currency | FTI_BAMORTHW | CURR | 15(2) | WERTV8_TR | ||||
BAGIOWR | Remaining premium/discount in position currency | FTI_BAGIOWR | CURR | 15(2) | WERTV8_TR | ||||
BAGIOHW | Remaining premium/discount in local currency | FTI_BAGIOHW | CURR | 15(2) | WERTV8_TR | ||||
BNOMS | Nominal value | BNOMS | CURR | 13(2) | BWHR | ||||
KURSABSPRZ | Price of Unit- or Percentage-Quoted Security | VVPKTKUR | DEC | 15(6) | VVPKTKUR | ||||
KURSPROZ | Price of percentage-quoted security in percent | VVKURSPROZ | DEC | 15(6) | VVPKTKUR | ||||
KURSABS | Price of a unit-quoted security in quotation currency | VVKURSABS | DEC | 15(6) | VVPKTKUR | ||||
KURSSTNW | Market price for unit-quoted securities | FTI_KSTST | DEC | 15(6) | VVPKTKUR | ||||
KURSSTFW | Market Price/Unit in Position Crcy (Unit-Quoted Securities) | FTI_KURSBW | DEC | 15(6) | VVPKTKUR | ||||
BKURSWEFW | Market value of position in position currency | TB_BKURSWR | CURR | 15(2) | WERTV8_TR | ||||
BKURSWEHW | Market value of position in local currency | TB_BKURSHW | CURR | 15(2) | WERTV8_TR | ||||
FLG_SIMBEW | Flag for data from simulated valuation | TPM_F_SBW | CHAR | 1 | XFELD | ||||
BWPBWWR | Price valuation in position currency | VVBWPBWWR | CURR | 15(2) | WERTV8_TR | ||||
BWPBWHW | Price valuation in local currency | VVBWPBWHW | CURR | 15(2) | WERTV8_TR | ||||
BFWBWHW | Foreign exchange valuation in local currency | VVBFWBWHW | CURR | 15(2) | WERTV8_TR | ||||
BKOBWWR | Valuation of capitalized costs from price in pos. currency | VVBKOBWWR | CURR | 15(2) | WERTV8_TR | ||||
BKOBWHW | Valuation of capitalized costs from price in local currency | VVBKOBWHW | CURR | 15(2) | WERTV8_TR | ||||
BKOFBHW | Forex valuation of capitalized costs in local currency | VVBKOFBHW | CURR | 15(2) | WERTV8_TR | ||||
DEVKURTAG | Exchange rate key date PC to LC | DEVKURTAG | DEC | 9(5) | EXCRT | KURSF | |||
DEVKURKAUF | Purchase exchange rate | DEVKURKAUF | DEC | 9(5) | EXCRT | KURSF | |||
DEVKURBUCH | Exchange rate (book rate) | DEVKURBUCH | DEC | 9(5) | EXCRT | KURSF | |||
STUECKZINS | Accrued Interest in Position Currency | TB_STZINS | CURR | 21(2) | TPM_AMOUNT | ||||
WERTAUFKUM | Cumulated reinst.orig.value acc. to §280 of the GCC in LC | WERTAUFKUM | CURR | 15(2) | WERTV8 | ||||
WERTAUFDEL | Rev.oriented reinst.orig.val.acc.to §280 HGB (Germany)in LC | WERTAUFDEL | CURR | 15(2) | WERTV8_TR | ||||
VAL_TI_PC | Security Valuation in Position Currency | FTI_VAL_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_TI_LC | Security Valuation in Local Currency | FTI_VAL_TI_LC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_FX_LC | Foreign Currency Valuation in Local Currency | FTI_VAL_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_TI_PC | Valuation of Cap. Costs, Security, in Position Currency | FTI_VAL_CH_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_TI_LC | Valuation of Cap. Costs, Security, in Local Currency | FTI_VAL_CH_TI_LC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_FX_LC | Valuation of Capitalized Costs, FX, in Local Currency | FTI_VAL_CH_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
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 EXBESTAND using ABAP code?
As EXBESTAND 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 EXBESTAND as there is no data to select.How to access SAP table EXBESTAND
Within an ECC or HANA version of SAP you can also view further information about EXBESTAND 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