TRQT_FLOW

Treasury: Flow Data Quantity Ledger | #transactional | Component: Transaction Manager
Column Name Description
MANDT Client
FLOW_GUID Object Identity in Database Format
Column Name Description
NOMINAL_AMT Nominal Amount
NOMINAL_ORG_AMT Original Nominal Amount in Position Currency
POSITION_AMT Amount (Position Currency)
POSAMT_IDX_CLEAN Amount in Position Currency Index-Clean
LOCAL_AMT Amount (Local Currency)
PAYMENT_AMT Payment Amount
BBASIS Calculation Base Amount
Column Name Description
📏 Unit of Measure for the Commodity (UNIT_OF_MEASURE):
QUANTITY Quantity
Column Name Description
POSITION_DATE Position Value Date
TRD_POSITION_DATE Original Position Date
CALCULATION_DATE Calculation Date
CALC_BEGIN Start of Calculation Period
CALC_END End of Calculation Period
Column Name Description
QUANT_CAT Position Change Category: Quantity Show values
SOURCETARGET_FLG Indicator: Source or Target of a Flow Show values
LOT_CREATION Lot Creation Category Show values
CALC_DATE_INCL Inclusive indicator for beginning and end of a period Show values
RKONDGR Direction of Transaction Show values
Column Name Description Domain name
TRD_TRANSACTION Identifier of the Distributor Business Transaction SYSUUID
TRD_FLOWNR Number of a Distributor Flow TPM_TRDFLOWNR
DIS_FLOWTYPE Update Type TPM_DIS_FLOWTYPE
TRANSACTION_TYPE Financial Transaction Type T_SFHAART
DCSID Derivative Contract Specification ID TBA_DCSID
UNITS Units TPM_UNITS
TRANSFER_GROUP Group of Flows from a Source or Target TPM_SYSTEM_KEY
COUNTERPARTY Business Partner Number BU_PARTNER
Master Data Relations Join Conditions
Local Currency
  • TRQT_FLOW.MANDT == TCURC.MANDT
  • TRQT_FLOW.LOCAL_CURR == TCURC.WAERS
Nominal Currency
  • TRQT_FLOW.MANDT == TCURC.MANDT
  • TRQT_FLOW.NOMINAL_CURR == TCURC.WAERS
Position Currency
  • TRQT_FLOW.MANDT == TCURC.MANDT
  • TRQT_FLOW.POSITION_CURR == TCURC.WAERS