1. Home
  2. Resources
  3. SAP Tables
  4. TRQT_POSITION - Treasury: Quantity Ledger Position

SAP Table TRQT_POSITION

Treasury: Quantity Ledger Position

TRQT_POSITION (Treasury: Quantity Ledger Position) 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 TRQT_POSITION to other SAP tables.

Source: TRQT_POSITION (Treasury: Quantity Ledger Position)

TRQT_POSITION table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
OS_GUID Quantity Position TPM_QUANTITIY_POSITION CHAR 32 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
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
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
LOT_INIT_DATE Date As Of Which Item Is Managed in Lots TPM_LOT_INIT_DATE DATS 8 0
SELECTOR_OID Object Identity in Database Format TPM_DB_OS_GUID DIFT_POS_IDENT CHAR 32 0
SELECTOR_CLS Object Identity in Database Format TPM_DB_OS_GUID CHAR 32 0

TRQT_POSITION foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TRQT_POSITION SELECTOR_OID TRQT_POSITION MANDT DIFT_POS_IDENT Persistent Flow Selectors MANDT
TRQT_POSITION SELECTOR_OID TRQT_POSITION SELECTOR_OID DIFT_POS_IDENT Persistent Flow Selectors OS_GUID