TRQS_POSITION_QUANTITY SAP (Structure for Quantity Ledger Position Display) Structure details
Description: Structure for Quantity Ledger Position Display
Related tables to TRQS_POSITION_QUANTITY
Access table TRQS_POSITION_QUANTITY
Structure field list including key, data, relationships and ABAP select examples
TRQS_POSITION_QUANTITY 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 "Structure for Quantity Ledger Position Display" 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_TRQS_POSITION_QUANTITY TYPE TRQS_POSITION_QUANTITY.
The TRQS_POSITION_QUANTITY table consists of various fields, each holding specific information or linking keys about Structure for Quantity Ledger Position Display data available in SAP. These include COMPANY_CODE_TEXT (Name of Company Code or Company), VALUATION_AREA (Valuation Area), COM_VAL_CLASS (General Valuation Class), COM_VAL_CLASS_TEXT (Name of the General Valuation Class).. 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: Cannot Be Enhanced
SAP TRQS_POSITION_QUANTITY 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 |
COMPANY_CODE | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
COMPANY_CODE_TEXT | Name of Company Code or Company | BUTXT | CHAR | 25 | TEXT25 | ||||
VALUATION_AREA | Valuation Area | TPM_VAL_AREA | CHAR | 3 | Assigned to domain | TPM_VAL_AREA | TPM_VAL_AREA | TRG_VALUATION_AREA | |
COM_VAL_CLASS | General Valuation Class | TPM_COM_VAL_CLASS | NUMC | 4 | Assigned to domain | TPM_COM_VAL_CLASS | CVC | ||
COM_VAL_CLASS_TEXT | Name of the General Valuation Class | TPM_COM_VAL_CLASS_NAME | CHAR | 60 | TPM_DESCRIPTION | ||||
SECURITY_ID | Security ID Number | VVRANLW | CHAR | 13 | Assigned to domain | ALPHA | WP_RANL | RAN | SECURITY_F4 |
SECURITY_ID_TEXT | Short name | XALKZ | CHAR | 15 | XKBEZ | ||||
ACCOUNT_GROUP | Securities Account Group | TPM_SEC_ACCT_GRP | CHAR | 10 | Assigned to domain | TPM_SEC_ACCT_GRP | TPM_SHPL_SEC_ACC_GRP | ||
PRODUCT_TYPE | Product Type | VVSART | CHAR | 3 | Assigned to domain | VVSART | SAN | VVSART_APPL_BAS | |
PRODUCT_TYPE_TEXT | Text (30 Characters) | TEXT30 | CHAR | 30 | TEXT30 | ||||
PORTFOLIO | Portfolio | RPORTB | CHAR | 10 | Assigned to domain | RPORTB | T50 | H_RPORTB_CORE | |
PORTFOLIO_TEXT | Portfolio name | VVXPORTB | CHAR | 30 | TEXT30 | ||||
TRADER | Trader | RDEALER | CHAR | 12 | Assigned to domain | RDEALER | |||
SECURITY_ACCOUNT | Securities Account | RLDEPO | CHAR | 10 | Assigned to domain | RLDEPO | DEP | ACC_CCD_CORE | |
SECURITY_ACCOUNT_TEXT | Securities account ID | XLDEPO | CHAR | 30 | XLDEPO | ||||
POSITION_ACCOUNT | Futures Account for Listed Options and Futures | TPM_POS_ACCOUNT_FUT | CHAR | 10 | Assigned to domain | TPM_POS_ACCOUNT_FUT | TRF_PAC | TRFC_F4_POS_ACCOUNT | |
POSITION_ACCOUNT_TEXT | Futures Account Text | TPM_POS_ACC_FUT_TEXT | CHAR | 30 | TPM_POS_ACC_FUT_TEXT | ||||
FLAG_LONG_SHORT | Indicator: Long or Short Position | TPM_FLAG_LONG_SHORT | CHAR | 1 | TPM_FLAG_LONG_SHORT | ||||
FLAG_LONG_SHORT_TEXT | Text (10 Characters) | TEXT10 | CHAR | 10 | TEXT10 | ||||
DEAL_NUMBER | Financial Transaction | TB_RFHA | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | FAN | VTBA |
FUND | Fund | FM_FUND | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
FUND_TEXT | Text (20 Characters) | TEXT20 | CHAR | 20 | TEXT20 | ||||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
GRANT_NBR_TEXT | Text (20 Characters) | TEXT20 | CHAR | 20 | TEXT20 | ||||
LOANS_CONTRACT | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
TRANSACTION_TYPE | Financial Transaction Type | TB_SFHAART | CHAR | 3 | Assigned to domain | T_SFHAART | T02 | C_AT10 | |
TRANSACTION_TYPE_TEXT | Name of Transaction Type | TB_FATEXT | CHAR | 30 | T_XTEXT30 | ||||
FACILITY | Transaction Number of Facility | TB_FACILITYNR | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | F4_FTR_FC | |
MASTER_AGREEMENT | Master Agreement | TB_RMAID | CHAR | 10 | Assigned to domain | ALPHA | T_RMAID | TMA | VTMA |
ASSIGNMENT | Assignment | TB_ZUOND | CHAR | 18 | TEXT18 | ||||
INTERNAL_REF | Internal Reference | TB_REFER | CHAR | 16 | CHAR16 | ||||
CHARACTERISTICS | Characteristics | TB_MERKM | CHAR | 25 | CHAR25 | ||||
FINANCE_PROJECT | Finance Project | TB_TFPROJ | CHAR | 13 | T_TFPROJ | ||||
ACTIVITY_CAT | Transaction Activity Category | TB_SFGZUTY | NUMC | 2 | Assigned to domain | T_SFGZUTY | C_AT02 | ||
ACTIVITY_CAT_TEXT | Name of activity category | TB_XTTEXT | CHAR | 30 | TEXT30 | ||||
PARTNER | Business Partner Number | BP_PARTNR_OLD | CHAR | 10 | Assigned to domain | ALPHA | BP_PARTNR | BPN | |
PARTNER_TEXT | Name and address of business partner | TB_XKONTRH | CHAR | 80 | TEXT80 | ||||
POSITION_CAT | Position Category - Collective/Single Position | TPM_QUAN_POS_CAT | CHAR | 1 | TPM_QUAN_POS_CAT | ||||
POSITION_CAT_TEXT | Text for Quantity Position Category | TPM_QUAN_POS_CAT_TEXT | CHAR | 60 | DDTEXT | ||||
CONSUMPTION_CAT | Consumption Sequence Procedure | TPM_CONSUMPTION_CAT | CHAR | 1 | TPM_CONSUMPTION_CAT | ||||
CONSUMPTION_CAT_TEXT | Text for Consumption Sequence Procedure | TPM_CONSUMPTION_CAT_TEXT | CHAR | 60 | DDTEXT | ||||
QUANTITY_CAT | Position Quantity Category | TPM_QUANTITY_CAT | CHAR | 1 | TPM_QUANTITY_CAT | ||||
NOMINAL_CURR | Nominal Currency | TPM_NOMINAL_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
NOMINAL_AMT | Nominal Amount | TPM_NOMINAL_AMT | CURR | 21(2) | TPM_AMOUNT | ||||
NOMINAL_ORG_AMT | Original Nominal Amount in Position Currency | TPM_NOMINAL_ORG_AMT | CURR | 21(2) | TPM_AMOUNT | ||||
UNITS | Units | TPM_UNITS | DEC | 22(6) | TPM_UNITS | ||||
NUMBER_OF_LOTS | Number of Lots in a Quantity Ledger Position | TPM_NUMBER_OF_LOTS | INT4 | 10 | INT4_NOS | ||||
LOTS | 0 | ||||||||
OTC_LOTS | 0 | ||||||||
NUMBER_OF_POSFLOWS | Number of Flows in a Quantity Ledger Position | TPM_NUMBER_OF_POSFLOWS | INT4 | 10 | INT4_NOS | ||||
POSITION_FLOWS | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure TRQS_POSITION_QUANTITY using ABAP code?
As TRQS_POSITION_QUANTITY 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 TRQS_POSITION_QUANTITY as there is no data to select.How to access SAP table TRQS_POSITION_QUANTITY
Within an ECC or HANA version of SAP you can also view further information about TRQS_POSITION_QUANTITY 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