SAP table TRQT_POSITION (Treasury: Quantity Ledger Position)
SAP table TRQT_POSITION has 2 primary key fields being MANDT,OS_GUID.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
Client
CLNT
3
0
*
MANDT
Quantity Position
CHAR
32
0
TPM_QUANTITIY_POSITION
POSITION_CAT
Position Category - Collective/Single Position
CHAR
1
0
TPM_QUAN_POS_CAT
Possible values
1
Single position
2
Collective position
3
OTC Lot position
CONSUMPTION_CAT
Consumption Sequence Procedure
CHAR
1
0
TPM_CONSUMPTION_CAT
Possible values
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
CHAR
1
0
TPM_QUANTITY_CAT
Possible values
1
Nominal amount with currency
2
Units
NOMINAL_CURR
Nominal Currency
CUKY
5
0
*
TPM_NOMINAL_CURR
LOT_INIT_DATE
Date As Of Which Item Is Managed in Lots
DATS
8
0
TPM_LOT_INIT_DATE
SELECTOR_OID
Object Identity in Database Format
CHAR
32
0
DIFT_POS_IDENT
TPM_DB_OS_GUID
SELECTOR_CLS
Object Identity in Database Format
CHAR
32
0
TPM_DB_OS_GUID
TRQT_POSITION foreign key relationships
Table
Field
Check Table
Check Field
0 TRQT_POSITION
SELECTOR_OID
DIFT_POS_IDENT Persistent Flow Selectors
MANDT
0 TRQT_POSITION
SELECTOR_OID
DIFT_POS_IDENT Persistent Flow Selectors
OS_GUID