TRDT_FLOW

Persistent distributor flows | #transactional | Component: Transaction Manager
Column Name Description
MANDT FK Client
BUSTRANS_OS_GUID FK Object Identity in Database Format
FLOW_NUMBER Number of a Distributor Flow
Column Name Description
💲 Nominal Currency (NOMINAL_CURR):
NOMINAL_AMT Nominal Amount
NOMINAL_ORG_AMT Original Nominal Amount in Position Currency
💲 Position Currency (POSITION_CURR):
POSITION_AMT Amount (Position Currency)
POSAMT_IDX_CLEAN Amount in Position Currency Index-Clean
💲 Local Currency (LOCAL_CURR):
LOCAL_AMT Amount (Local Currency)
💲 Valuation Currency (VALUATION_CURR):
VALUATION_AMT Amount in Valuation Currency
💲 Payment Currency (PAYMENT_CURR):
PAYMENT_AMT Payment Amount
Column Name Description
📏 Unit of Measure for the Commodity (UNIT_OF_MEASURE):
QUANTITY Quantity
Column Name Description
PAYMENT_DATE Payment Date
DUE_DATE Due Date
CALCULATION_DATE Calculation Date
COUPON_DATE Date of the Next Coupon
CALC_BEGIN Start of Calculation Period
CALC_END End of Calculation Period
TRANSL_DATE Translation date
CLEARING_DATE Actual Clearing Date
FX_FIXING_DATE Fixing Date
Column Name Description
FLAG_LONG_SHORT Indicates whether it is a long or a short position Show values
QUANT_CAT Position Change Category: Quantity Show values
ACTIVE_PASSIVE Indicator: Assets/Liabilities Position Show values
SOURCETARGET_FLG Indicator: Source or Target of a Flow Show values
LOT_CREATION Lot Creation Category Show values
SIGN Direction of Flow Show values
SZART Payment Transaction Show values
SPAYRQ Payment request allowed Show values
SPRSNG Individual payment required Show values
SPRGRD Determine Grouping Definition Show values
SCSPAY Same Direction Necessary for Joint Payment? Show values
CALC_DATE_INCL Inclusive indicator for beginning and end of a period Show values
COUPON_SIGN Coupon ID for Interest and Accrued Interest Calculation Show values
SKHWFIX Indicator for Translation into Local Currency Show values
RKONDGR Direction of Transaction Show values
SNOTDELIVERED Security not delivered Show values
CLEARING_STATUS Clearing Status (TREA) Show values
SVULT Month-End Indicator for Value Date Show values
SROUNDFACTOR Rounding Category of a Factor Show values
JEXPOINTFACTOR Exponential Interest Calculation with Factor Show values
SROUNDBASEFACTOR Rounding Category of a Base Factor Show values
SROUNDRATEFACTOR Rounding Category of Interest Factor Show values
SSTCKKZ Accrued interest method Show values
SFLAT Indicator 'Traded flat',i.e.no accrued interest calculation Show values
Column Name Description Domain name
ALLOC_NMBR Assignment number ZUONR
VALUATION_AREA Treasury Valuation Area TPM_VAL_AREA
POSITION_ACCOUNT Futures Account for Listed Options and Futures TPM_POS_ACCOUNT_FUT
LOT_ID Identifier of the Lot SYSUUID
FUND Fund BP_GEBER
GRANT_NBR Grant GM_GRANT_NBR
EXTERNAL_ACCOUNT External Account TPM_EXT_ACCOUNT
UNITS Units TPM_UNITS
TRL_POS_MAN_CAT Position Change Category TPM_PM_CAT
TRANSFER_GROUP Group of Flows from a Source or Target TPM_SYSTEM_KEY
AMOUNT_FACTOR Value Coefficient TPM_AMOUNT_FACTOR
HOUSE_BANK Short Key for Own House Bank HBKID
HOUSE_BANK_ACC Short Key for House Bank Account HKTID
RPBANK Partner Bank Details BVTYP
ZLSCH Payment Method ZLSCH
ZWELS List of Respected Payment Methods ZWELS
PAYGR Grouping Field for Automatic Payments CHAR20
EFF_INT_RATE_U For Calculation of Amortization Amts (SAC) for Used EffInR DEC3_7
SCHED_EFF_RATE Key for Redemption Schedule that Explains Effect. Int. Rate
EFF_INT_RATE_N Valid Effective Interest Rate for the Next Amortization DEC3_7
SCHED_FIX Key for Fixed Redemption Schedule
LANDL Supplying Country/Region LAND1
LZBKZ State Central Bank Indicator LZBKZ
RPCODE Repetitive Code RPCODE
RP_TEXT Reference Text for Repetitive Code XTEXT50
RFHAZU Transaction Activity T_RFHAZU
NORDEXT External Reference FTI_CHAR16LOW
SFGZUSTT Transaction Activity Category T_SFGZUTY
COUNTERPARTY Business Partner Number BU_PARTNER
MNDID Unique Reference to Mandate for each Payee ID035
PRESENTATION_ID Presentation Item FTR_PRSNT_ID
HEDGED_ITEM_ID Identification Number of Hedged Item THM_HEDGE_ID
EXPOSURE_ITEM_ID Exposure Item ID TOE_EXPOSURE_ITEM_ID
EXPOSURE_SUBITEM_ID Exposure Subitem ID TOE_EXPOSURE_SUBITEM_ID
ROUNDDECFACTOR Number of Rounding Decimal Places for a Factor TFM_ROUNDDECIMALS
ROUNDDECBASEFACTOR Number of Rounding Decimal Places for a Base Factor TFM_ROUNDDECIMALS
FLOWFACTOR Flow Factor TFM_FACTOR
BASEFACTOR Base Factor TFM_FACTOR
ROUNDDECRATEFACTOR Number of Rounding Decimal Places for Interest Factor TFM_ROUNDDECIMALS
AAVGDAYS No. of Days for Interest Calc. with Average Interest Rate INT4
PAVGINTEREST Average Interest Rate DECV5_10
SSEQUENCE Processing Sequence of Conditions TFM_SEQUENCE
IB_SCHEDULE_VERSION_USED_EIR Schedule Version for Used Effective Interest Rate TRBA_VERSION_NUMBER
IB_SCHEDULE_VERSION Version Number TRBA_VERSION_NUMBER
WBS_ELEMENT Work Breakdown Structure Element (WBS Element) PS_POSNR
COST_CENTER Cost Center KOSTL
PROFIT_CENTER Profit Center PRCTR
FUNCTIONAL_AREA Functional Area FKBER
DCSID Derivative Contract Specification ID TBA_DCSID
Master Data Relations | to Other Relations ↓ Join Conditions
Company Code
  • TRDT_FLOW.MANDT == T001.MANDT
  • TRDT_FLOW.COMPANY_CODE == T001.BUKRS
General Valuation Class
  • General Valuation Class
  • Client
Financial Transaction
  • Company Code
  • Client
  • Financial Transaction
  • TRDT_FLOW.COMPANY_CODE == VTBFHA.BUKRS
  • TRDT_FLOW.MANDT == VTBFHA.MANDT
  • TRDT_FLOW.DEAL_NUMBER == VTBFHA.RFHA
Update Type
Fixed Account Assignment Reference
Loans Contract
  • ?
  • Client
  • Company Code
  • Contract Number
  • TRDT_FLOW.[column in domain "SARCHIV"] == VDARL.SARCHIV
  • TRDT_FLOW.MANDT == VDARL.MANDT
  • TRDT_FLOW.COMPANY_CODE == VDARL.BUKRS
  • TRDT_FLOW.LOANS_CONTRACT == VDARL.RANL
Client TRDT_FLOW.MANDT == T000.MANDT
Portfolio
  • Company Code
  • Portfolio
  • Client
  • TRDT_FLOW.COMPANY_CODE == TWPOB.BUKRS
  • TRDT_FLOW.PORTFOLIO == TWPOB.RPORTB
  • TRDT_FLOW.MANDT == TWPOB.MANDT
Product Type
  • Product Type
  • Client
  • TRDT_FLOW.PRODUCT_TYPE == TZPA.GSART
  • TRDT_FLOW.MANDT == TZPA.MANDT
Payer/Payee
  • Payer/Payee
  • Client
  • TRDT_FLOW.RPZAHL == BUT000.PARTNER
  • TRDT_FLOW.MANDT == BUT000.CLIENT
Securities Account
  • Securities Account
  • Company Code
  • TRDT_FLOW.MANDT == TWD01.MANDT
  • TRDT_FLOW.SECURITY_ACCOUNT == TWD01.RLDEPO
  • TRDT_FLOW.COMPANY_CODE == TWD01.BUKRS
Security ID Number
  • TRDT_FLOW.MANDT == VWPANLA.MANDT
  • TRDT_FLOW.SECURITY_ID == VWPANLA.RANL
Transaction Type
  • Financial Transaction Type
  • Client
  • Product Type
  • TRDT_FLOW.TRANSACTION_TYPE == AT10.SFHAART
  • TRDT_FLOW.MANDT == AT10.MANDT
  • TRDT_FLOW.PRODUCT_TYPE == AT10.SGSART
Payment Method Supplement
  • TRDT_FLOW.MANDT == T042F.MANDT
  • TRDT_FLOW.UZAWE == T042F.UZAWE
Valuation Class in Valuation Area
  • Treasury Valuation Area
  • Valuation Class
Other Relations | to Master Data Relations ↑ Join Conditions
Securities Account Group
  • Company Code
  • Securities Account Group
  • Client
Traders
  • Company Code
  • Trader
  • Client
  • TRDT_FLOW.COMPANY_CODE == TZDEA.BUKRS
  • TRDT_FLOW.TRADER == TZDEA.RDEALER
  • TRDT_FLOW.MANDT == TZDEA.MANDT