SAP Table TRDT_FLOW - Persistent distributor flows

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
BUSTRANS_OS_GUID X TPM_DB_OS_GUID CHAR 3 32 0 TRACT_DOCUMENT Object Identity in Database Format
FLOW_NUMBER X TPM_TRDFLOWNR INT4 36 10 0 Number of a Distributor Flow
DIS_FLOWTYPE TPM_DIS_FLOWTYPE CHAR 40 8 0 TRDC_DFLOWTYPE Update Type
ALLOC_NMBR DZUONR CHAR 48 18 0 Assignment Number
COMPANY_CODE BUKRS CHAR 66 4 0 T001 Company Code
VALUATION_AREA TPM_VAL_AREA CHAR 70 3 0 TRGC_VAL_AREA Valuation Area
PRODUCT_TYPE VVSART CHAR 73 3 0 TZPA Product Type
TRANSACTION_TYPE TB_SFHAART CHAR 76 3 0 AT10 Financial Transaction Type
COM_VAL_CLASS TPM_COM_VAL_CLASS NUMC 79 4 0 General Valuation Class
VALUATION_CLASS TPM_VAL_CLASS NUMC 83 4 0 Valuation Class
SECURITY_ID VVRANLW CHAR 87 13 0 Security ID Number
SECURITY_ACCOUNT RLDEPO CHAR 100 10 0 Securities Account
ACCOUNT_GROUP TPM_SEC_ACCT_GRP CHAR 110 10 0 TRGT_SECACCGRP Securities Account Group
PORTFOLIO RPORTB CHAR 120 10 0 Portfolio
TRADER RDEALER CHAR 130 12 0 TZDEA Trader
LOANS_CONTRACT RANL CHAR 142 13 0 Contract Number
DEAL_NUMBER TB_RFHA CHAR 155 13 0 Financial Transaction
POSITION_ACCOUNT TPM_POS_ACCOUNT_FUT CHAR 168 10 0 TRFT_POS_ACCOUNT Futures Account for Listed Options and Futures
LOT_ID TPM_LOT_ID RAW 178 16 0 Identifier of the Lot
FLAG_LONG_SHORT TPM_FLAG_LONG_SHORT CHAR 194 1 0 Indicator: Long or Short Position
UNITS TPM_UNITS DEC 195 22 6 Units
NOMINAL_CURR TPM_NOMINAL_CURR CUKY 207 5 0 TCURC Nominal Currency
NOMINAL_AMT TPM_NOMINAL_AMT CURR 212 21 2 Nominal Amount
NOMINAL_ORG_AMT TPM_NOMINAL_ORG_AMT CURR 223 21 2 Original Nominal Amount in Position Currency
POSITION_CURR TPM_POSITION_CURR CUKY 234 5 0 TCURC Position Currency
POSITION_AMT TPM_POSITION_AMT CURR 239 21 2 Amount in Position Currency
POSAMT_IDX_CLEAN TPM_POSITION_AMT_IDX_CLEAN CURR 250 21 2 Amount in Position Currency Index-Clean
QUANT_CAT TPM_QTY_PM_CAT CHAR 261 4 0 Position Change Category: Quantity
ACTIVE_PASSIVE TPM_ACTIVE_PASSIVE CHAR 265 1 0 Indicator: Assets/Liabilities Position
LOCAL_CURR TPM_LOCAL_CURR CUKY 266 5 0 TCURC Local Currency
LOCAL_AMT TPM_LOCAL_AMT CURR 271 21 2 Amount in Local Currency
VALUATION_CURR TPM_VALUATION_CURR CUKY 282 5 0 TCURC Valuation Currency
VALUATION_AMT TPM_VALUATION_AMT CURR 287 21 2 Amount in Valuation Currency
TRL_POS_MAN_CAT TPM_AMT_PM_CAT CHAR 298 4 0 Position Change Category
FIXED_AA_REF TPM_AA_REF CHAR 302 12 0 Account Assignment Reference of Position Management
SOURCETARGET_FLG TPM_SOURCE_TARGET_FLG CHAR 314 1 0 Indicator: Source or Target of a Flow
TRANSFER_GROUP TPM_TRANSFER_GROUP NUMC 315 4 0 Group of Flows from a Source or Target
LOT_CREATION TPM_LOT_CREATION NUMC 319 1 0 Lot Creation Category
AMOUNT_FACTOR TPM_AMOUNT_FACTOR FLTP 320 16 16 Value Coefficient
PAYMENT_CURR TPM_PAYMENT_CURR CUKY 328 5 0 TCURC Payment Currency
PAYMENT_AMT TPM_PAYMENT_AMT CURR 333 21 2 Amount in Payment Currency
SIGN TB_SSIGN CHAR 344 1 0 Direction of flow
HOUSE_BANK TB_RHABKI CHAR 345 5 0 T012 Short key for own house bank
HOUSE_BANK_ACC TB_RHKTID CHAR 350 5 0 T012K Short key for house bank account
PAYMENT_DATE TPM_PAYMENT_DATE DATS 355 8 0 Payment Date
DUE_DATE TPM_DUE_DATE DATS 363 8 0 Due Date
RPBANK TB_RPBANK CHAR 371 4 0 Partner bank details
RPZAHL TB_RPZAHL_NEW CHAR 375 10 0 Payer/payee
SZART TB_SZART CHAR 385 1 0 Payment transaction
ZLSCH DZLSCH CHAR 386 1 0 T042E Payment Method
UZAWE UZAWE CHAR 387 2 0 Payment Method Supplement
SPAYRQ TB_SPAYRQ CHAR 389 1 0 Payment request allowed
SPRSNG TB_SPRSNG CHAR 390 1 0 Individual payment required
SPRGRD TB_SPRGRD CHAR 391 1 0 Determine grouping definition
SCSPAY TB_SCSPAY CHAR 392 1 0 Same direction necessary for joint payment?
ZWELS DZWELS CHAR 393 10 0 List of the Payment Methods to be Considered
PAYGR PAYGR CHAR 403 20 0 Grouping Field for Automatic Payments
CALCULATION_DATE DVALUT DATS 423 8 0 Calculation Date
CALC_DATE_INCL VVSINCL NUMC 431 1 0 Inclusive indicator for beginning and end of a period
COUPON_DATE TPM_COUPON_DATE DATS 432 8 0 Date of the Next Coupon
COUPON_SIGN TPM_COUPON_SIGN CHAR 440 1 0 Coupon ID for Interest and Accrued Interest Calculation
CALC_BEGIN DBERVON DATS 441 8 0 Start of Calculation Period
CALC_END DBERBIS DATS 449 8 0 End of Calculation Period
EFF_INT_RATE_U TPM_TRL_EFF_INT_RATE_USED DEC 457 10 7 For Calculation of Amortization Amts (SAC) for Used EffInR
SCHED_EFF_RATE RDPT_SCHEDULE_KEY_EFF_RATE CHAR 464 1 0 Key for Redemption Schedule that Explains Effect. Int. Rate
EFF_INT_RATE_N TPM_TRL_EFF_INT_RATE_NEW DEC 468 10 7 Valid Effective Interest Rate for the Next Amortization
SCHED_FIX RDPT_SCHEDULE_KEY_FIX CHAR 476 1 0 Key for Fixed Redemption Schedule
LANDL LANDL CHAR 480 3 0 T005 Supplying Country
LZBKZ LZBKZ CHAR 483 3 0 State Central Bank Indicator
RPCODE RPCODE CHAR 486 20 0 Repetitive Code
RP_TEXT RPCODE_TEXT CHAR 506 50 0 Reference Text for Repetitive Code
RFHAZU TB_RFHAZU NUMC 556 5 0 Transaction activity
NORDEXT TB_NORDEXT CHAR 561 16 0 External Reference
SFGZUSTT TB_SFGZUTY NUMC 577 2 0 Transaction Activity Category