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.
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 |
Possible values
|
||||||||||||||||
| CONSUMPTION_CAT | Consumption Sequence Procedure | TPM_CONSUMPTION_CAT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| QUANTITY_CAT | Position Quantity Category | TPM_QUANTITY_CAT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| 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 | SELECTOR_OID | DIFT_POS_IDENT | Persistent Flow Selectors | OS_GUID |
| TRQT_POSITION | SELECTOR_OID | TRQT_POSITION | MANDT | DIFT_POS_IDENT | Persistent Flow Selectors | MANDT |
