TRQT_FLOW - Treasury: Flow Data Quantity Ledger
Treasury: Flow Data Quantity Ledger information is stored in SAP table TRQT_FLOW.
It is part of development package FTR_QUANTITY_LEDGER in software component FIN-FSCM-TRM-TM. This development package consists of objects that can be grouped under "Treasury: Quantity Ledger".
It is part of development package FTR_QUANTITY_LEDGER in software component FIN-FSCM-TRM-TM. This development package consists of objects that can be grouped under "Treasury: Quantity Ledger".
Fields for table TRQT_FLOW
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| FLOW_GUID | Object Identity in Database Format | X | TPM_DB_OS_GUID | CHAR | 64 | |
| .INCLUDE | TRQS_FLOW_DATA | 0 | ||||
| .INCLUDE | TRQS_TRD_FLOW_ID | 0 | ||||
| TRD_TRANSACTION | Identifier of the Distributor Business Transaction | TPM_BUSTRANSID | RAW | 16 | ||
| TRD_FLOWNR | Number of a Distributor Flow | TPM_TRDFLOWNR | INT4 | 4 | ||
| .INCLUDE | TRQS_DIS_FLOW_INFO | 0 | ||||
| DIS_FLOWTYPE | Update Type | TPM_DIS_FLOWTYPE | CHAR | 16 | * | |
| .INCLUDE | TRQS_FLOW_DIFF_DATA_ADD | 0 | ||||
| TRANSACTION_TYPE | Financial Transaction Type | TB_SFHAART | CHAR | 6 | ||
| .INCLUDE | CMMS_HACC_DCS | 0 | ||||
| DCSID | Derivative Contract Specification ID | TBA_DCSID | CHAR | 40 | ||
| .INCLUDE | TRQS_FLOW_POSITION_DATA | 0 | ||||
| UNITS | Units | TPM_UNITS | DEC | 12 | ||
| NOMINAL_CURR | Nominal Currency | TPM_NOMINAL_CURR | CUKY | 10 | TCURC | |
| NOMINAL_AMT | Nominal Amount | TPM_NOMINAL_AMT | CURR | 11 | ||
| NOMINAL_ORG_AMT | Original Nominal Amount in Position Currency | TPM_NOMINAL_ORG_AMT | CURR | 11 | ||
| POSITION_CURR | Position Currency | TPM_POSITION_CURR | CUKY | 10 | TCURC | |
| POSITION_AMT | Amount (Position Currency) | TPM_POSITION_AMT | CURR | 11 | ||
| POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | TPM_POSITION_AMT_IDX_CLEAN | CURR | 11 | ||
| POSITION_DATE | Position Value Date | TPM_POSITION_DATE | DATS | 16 | ||
| QUANT_CAT | Position Change Category: Quantity | TPM_QTY_PM_CAT | CHAR | 8 | ||
| TRD_POSITION_DATE | Original Position Date | TPM_ORG_POSITION_DATE | DATS | 16 | ||
| .INCLUDE | CMMS_HACC_QUANTITY | 0 | ||||
| QUANTITY | Quantity | FTR_QUAN | QUAN | 7 | ||
| UNIT_OF_MEASURE | Unit of Measure for the Commodity | TPM_CTY_UOM | UNIT | 6 | * | |
| .INCLUDE | TRQS_FLOW_LOCAL_CURR_DATA | 0 | ||||
| LOCAL_CURR | Local Currency | TPM_LOCAL_CURR | CUKY | 10 | TCURC | |
| LOCAL_AMT | Amount (Local Currency) | TPM_LOCAL_AMT | CURR | 11 | ||
| .INCLUDE | TRQS_FLOW_TRANSFER_DATA | 0 | ||||
| SOURCETARGET_FLG | Indicator: Source or Target of a Flow | TPM_SOURCE_TARGET_FLG | CHAR | 2 | ||
| TRANSFER_GROUP | Group of Flows from a Source or Target | TPM_TRANSFER_GROUP | NUMC | 8 | ||
| LOT_CREATION | Lot Creation Category | TPM_LOT_CREATION | NUMC | 2 | ||
| .INCLUDE | TRQS_FLOW_PAYMENT_AMT_DATA | 0 | ||||
| PAYMENT_CURR | Payment Currency | TPM_PAYMENT_CURR | CUKY | 10 | * | |
| PAYMENT_AMT | Payment Amount | TPM_PAYMENT_AMT | CURR | 11 | ||
| .INCLUDE | TRQS_FLOW_FIMA_DATA | 0 | ||||
| CALCULATION_DATE | Calculation Date | DVALUT | DATS | 16 | ||
| CALC_DATE_INCL | Inclusive indicator for beginning and end of a period | VVSINCL | NUMC | 2 | ||
| CALC_BEGIN | Start of Calculation Period | DBERVON | DATS | 16 | ||
| CALC_END | End of Calculation Period | DBERBIS | DATS | 16 | ||
| .INCLUDE | TRQS_FLOW_SEC_BEPP_DATA | 0 | ||||
| BBASIS | Calculation Base Amount | BBASIS | CURR | 7 | ||
| .INCLUDE | TRQS_FLOW_DEAL_INFO | 0 | ||||
| RKONDGR | Direction of Transaction | TB_RKONDGR | NUMC | 2 | ||
| COUNTERPARTY | Business Partner Number | TB_KUNNR_NEW | CHAR | 20 |