1. Home
  2. Resources
  3. SAP Tables
  4. TRQS_POSITION_QUANTITY - Structure for Quantity Ledger Position Display

SAP Table TRQS_POSITION_QUANTITY

Structure for Quantity Ledger Position Display

TRQS_POSITION_QUANTITY (Structure for Quantity Ledger Position Display) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TRQS_POSITION_QUANTITY to other SAP tables.

TRQS_POSITION_QUANTITY table fields

Field Data element Checktable Datatype Length Decimals
COMPANY_CODE Company Code BUKRS CHAR 4 0
COMPANY_CODE_TEXT Name of Company Code or Company BUTXT CHAR 25 0
VALUATION_AREA Valuation Area TPM_VAL_AREA CHAR 3 0
COM_VAL_CLASS General Valuation Class TPM_COM_VAL_CLASS NUMC 4 0
COM_VAL_CLASS_TEXT Name of the General Valuation Class TPM_COM_VAL_CLASS_NAME CHAR 60 0
SECURITY_ID Security ID Number VVRANLW CHAR 13 0
SECURITY_ID_TEXT Short name XALKZ CHAR 15 0
ACCOUNT_GROUP Securities Account Group TPM_SEC_ACCT_GRP CHAR 10 0
PRODUCT_TYPE Product Type VVSART CHAR 3 0
PRODUCT_TYPE_TEXT Text (30 Characters) TEXT30 CHAR 30 0
PORTFOLIO Portfolio RPORTB CHAR 10 0
PORTFOLIO_TEXT Portfolio name VVXPORTB CHAR 30 0
TRADER Trader RDEALER CHAR 12 0
SECURITY_ACCOUNT Securities Account RLDEPO CHAR 10 0
SECURITY_ACCOUNT_TEXT Securities account ID XLDEPO CHAR 30 0
POSITION_ACCOUNT Futures Account for Listed Options and Futures TPM_POS_ACCOUNT_FUT CHAR 10 0
POSITION_ACCOUNT_TEXT Futures Account Text TPM_POS_ACC_FUT_TEXT CHAR 30 0
FLAG_LONG_SHORT Indicator: Long or Short Position TPM_FLAG_LONG_SHORT CHAR 1 0
L Long position
S Short position
FLAG_LONG_SHORT_TEXT Text (10 Characters) TEXT10 CHAR 10 0
DEAL_NUMBER Financial Transaction TB_RFHA CHAR 13 0
FUND Fund FM_FUND CHAR 10 0
FUND_TEXT Text (20 Characters) TEXT20 CHAR 20 0
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
GRANT_NBR_TEXT Text (20 Characters) TEXT20 CHAR 20 0
LOANS_CONTRACT Contract Number RANL CHAR 13 0
TRANSACTION_TYPE Financial Transaction Type TB_SFHAART CHAR 3 0
TRANSACTION_TYPE_TEXT Name of Transaction Type TB_FATEXT CHAR 30 0
FACILITY Transaction Number of Facility TB_FACILITYNR CHAR 13 0
MASTER_AGREEMENT Master Agreement TB_RMAID CHAR 10 0
ASSIGNMENT Assignment TB_ZUOND CHAR 18 0
INTERNAL_REF Internal Reference TB_REFER CHAR 16 0
CHARACTERISTICS Characteristics TB_MERKM CHAR 25 0
FINANCE_PROJECT Finance Project TB_TFPROJ CHAR 13 0
ACTIVITY_CAT Transaction Activity Category TB_SFGZUTY NUMC 2 0
ACTIVITY_CAT_TEXT Name of activity category TB_XTTEXT CHAR 30 0
PARTNER Business Partner Number BP_PARTNR_OLD CHAR 10 0
PARTNER_TEXT Name and address of business partner TB_XKONTRH CHAR 80 0
POSITION_CAT Position Category - Collective/Single Position TPM_QUAN_POS_CAT CHAR 1 0
1 Single position
2 Collective position
3 OTC Lot position
POSITION_CAT_TEXT Text for Quantity Position Category TPM_QUAN_POS_CAT_TEXT CHAR 60 0
CONSUMPTION_CAT Consumption Sequence Procedure TPM_CONSUMPTION_CAT CHAR 1 0
1 Manual Assignment
2 LIFO
3 FIFO
4 Manual Assignment for Zero Bonds
5 Procedure for Migration to CFM 1.0
6 HIFO
7 LOFO
CONSUMPTION_CAT_TEXT Text for Consumption Sequence Procedure TPM_CONSUMPTION_CAT_TEXT CHAR 60 0
QUANTITY_CAT Position Quantity Category TPM_QUANTITY_CAT CHAR 1 0
1 Nominal amount with currency
2 Units
NOMINAL_CURR Nominal Currency TPM_NOMINAL_CURR CUKY 5 0
NOMINAL_AMT Nominal Amount TPM_NOMINAL_AMT CURR 21 2
NOMINAL_ORG_AMT Original Nominal Amount in Position Currency TPM_NOMINAL_ORG_AMT CURR 21 2
UNITS Units TPM_UNITS DEC 22 6
NUMBER_OF_LOTS Number of Lots in a Quantity Ledger Position TPM_NUMBER_OF_LOTS INT4 10 0
LOTS TRQY_LOT_OBJ TTYP 0 0
OTC_LOTS TRQY_OTC_LOT_OBJ TTYP 0 0
NUMBER_OF_POSFLOWS Number of Flows in a Quantity Ledger Position TPM_NUMBER_OF_POSFLOWS INT4 10 0
POSITION_FLOWS TRQY_POS_FLOW TTYP 0 0