TRDT_FLOW SAP (Persistent distributor flows) Table details
Dictionary Type: Table
Description: Persistent distributor flows
Description: Persistent distributor flows
Table field list including key, data, relationships and ABAP select examples
TRDT_FLOW is a standard SAP Table which is used to store Persistent distributor flows data and is available within R/3 SAP systems depending on the version and release level.
The TRDT_FLOW table consists of various fields, each holding specific information or linking keys about Persistent distributor flows data available in SAP. These include BUSTRANS_OS_GUID (Object Identity in Database Format), FLOW_NUMBER (Number of a Distributor Flow), DIS_FLOWTYPE (Update Type), ALLOC_NMBR (Assignment Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP TRDT_FLOW table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BUSTRANS_OS_GUID | Object Identity in Database Format | TPM_DB_OS_GUID | CHAR | 32 | TRDT_TRDBUSTRANS | TPM_DB_OS_GUID | |||
FLOW_NUMBER | Number of a Distributor Flow | TPM_TRDFLOWNR | INT4 | 10 | TPM_TRDFLOWNR | ||||
DIS_FLOWTYPE | Update Type | TPM_DIS_FLOWTYPE | CHAR | 8 | TRDC_DFLOWTYPE | TPM_DIS_FLOWTYPE | |||
ALLOC_NMBR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
COMPANY_CODE | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
VALUATION_AREA | Valuation Area | TPM_VAL_AREA | CHAR | 3 | Assigned to domain | TPM_VAL_AREA | TPM_VAL_AREA | TRG_VALUATION_AREA | |
PRODUCT_TYPE | Product Type | VVSART | CHAR | 3 | TZPA | VVSART | SAN | VVSART_APPL_BAS | |
TRANSACTION_TYPE | Financial Transaction Type | TB_SFHAART | CHAR | 3 | AT10 | T_SFHAART | T02 | C_AT10 | |
COM_VAL_CLASS | General Valuation Class | TPM_COM_VAL_CLASS | NUMC | 4 | TRGC_COM_VALCL | TPM_COM_VAL_CLASS | CVC | ||
VALUATION_CLASS | Valuation Class | TPM_VAL_CLASS | NUMC | 4 | TRGC_VAL_CLASS | TPM_VAL_CLASS | |||
SECURITY_ID | Security ID Number | VVRANLW | CHAR | 13 | VWPANLA | ALPHA | WP_RANL | RAN | SECURITY_F4 |
SECURITY_ACCOUNT | Securities Account | RLDEPO | CHAR | 10 | TWD01 | RLDEPO | DEP | ACC_CCD_CORE | |
ACCOUNT_GROUP | Securities Account Group | TPM_SEC_ACCT_GRP | CHAR | 10 | TRGT_SECACCGRP | TPM_SEC_ACCT_GRP | TPM_SHPL_SEC_ACC_GRP | ||
PORTFOLIO | Portfolio | RPORTB | CHAR | 10 | TWPOB | RPORTB | T50 | H_RPORTB_CORE | |
TRADER | Trader | RDEALER | CHAR | 12 | TZDEA | RDEALER | |||
LOANS_CONTRACT | Contract Number | RANL | CHAR | 13 | VDARL | ALPHA | RANL | RAN | |
DEAL_NUMBER | Financial Transaction | TB_RFHA | CHAR | 13 | VTBFHA | ALPHA | T_RFHA | FAN | VTBA |
POSITION_ACCOUNT | Futures Account for Listed Options and Futures | TPM_POS_ACCOUNT_FUT | CHAR | 10 | Assigned to domain | TPM_POS_ACCOUNT_FUT | TRF_PAC | TRFC_F4_POS_ACCOUNT | |
LOT_ID | Identifier of the Lot | TPM_LOT_ID | RAW | 16 | SYSUUID | ||||
FLAG_LONG_SHORT | Indicator: Long or Short Position | TPM_FLAG_LONG_SHORT | CHAR | 1 | TPM_FLAG_LONG_SHORT | ||||
FUND | Fund | FM_FUND | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
EXTERNAL_ACCOUNT | External Account | TPM_EXT_ACCOUNT | CHAR | 10 | TPM_EXT_ACCOUNT | TREA_EA | TREATH_EXT_ACCOUNT | ||
DIFF_CURRENCY | Currency as Differentiation Term | TPM_DIFF_CURRENCY | CUKY | 5 | Assigned to domain | WAERS | TPM_DIFF_CURR | ||
UNITS | Units | TPM_UNITS | DEC | 22(6) | TPM_UNITS | ||||
NOMINAL_CURR | Nominal Currency | TPM_NOMINAL_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
NOMINAL_AMT | Nominal Amount | TPM_NOMINAL_AMT | CURR | 21(2) | TPM_AMOUNT | ||||
NOMINAL_ORG_AMT | Original Nominal Amount in Position Currency | TPM_NOMINAL_ORG_AMT | CURR | 21(2) | TPM_AMOUNT | ||||
POSITION_CURR | Position Currency | TPM_POSITION_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
POSITION_AMT | Amount (Position Currency) | TPM_POSITION_AMT | CURR | 21(2) | TPM_AMOUNT | ||||
POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | TPM_POSITION_AMT_IDX_CLEAN | CURR | 21(2) | TPM_AMOUNT | ||||
QUANT_CAT | Position Change Category: Quantity | TPM_QTY_PM_CAT | CHAR | 4 | TPM_QTY_PM_CAT | ||||
ACTIVE_PASSIVE | Indicator: Assets/Liabilities Position | TPM_ACTIVE_PASSIVE | CHAR | 1 | TPM_ACTIVE_PASSIVE | ||||
LOCAL_CURR | Local Currency | TPM_LOCAL_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
LOCAL_AMT | Amount (Local Currency) | TPM_LOCAL_AMT | CURR | 21(2) | TPM_AMOUNT | ||||
VALUATION_CURR | Valuation Currency | TPM_VALUATION_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
VALUATION_AMT | Amount in Valuation Currency | TPM_VALUATION_AMT | CURR | 21(2) | TPM_AMOUNT | ||||
TRL_POS_MAN_CAT | Position Change Category | TPM_AMT_PM_CAT | CHAR | 4 | Assigned to domain | TPM_PM_CAT | |||
FIXED_AA_REF | Account Assignment Reference of Position Management | TPM_AA_REF | CHAR | 12 | TRACC_AA_REF | TPM_AA_REF | TRAC_AA_REF | ||
SOURCETARGET_FLG | Indicator: Source or Target of a Flow | TPM_SOURCE_TARGET_FLG | CHAR | 1 | TPM_SOURCE_TARGET_FLG | ||||
TRANSFER_GROUP | Group of Flows from a Source or Target | TPM_TRANSFER_GROUP | NUMC | 4 | TPM_SYSTEM_KEY | ||||
LOT_CREATION | Lot Creation Category | TPM_LOT_CREATION | NUMC | 1 | TPM_LOT_CREATION | ||||
AMOUNT_FACTOR | Value Coefficient | TPM_AMOUNT_FACTOR | FLTP | 16(16) | TPM_AMOUNT_FACTOR | ||||
PAYMENT_CURR | Payment Currency | TPM_PAYMENT_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
PAYMENT_AMT | Payment Amount | TPM_PAYMENT_AMT | CURR | 21(2) | TPM_AMOUNT | ||||
SIGN | Direction of flow | TB_SSIGN | CHAR | 1 | T_SSIGN | ||||
HOUSE_BANK | Short key for own house bank | TB_RHABKI | CHAR | 5 | Assigned to domain | HBKID | |||
HOUSE_BANK_ACC | Short key for house bank account | TB_RHKTID | CHAR | 5 | Assigned to domain | HKTID | |||
PAYMENT_DATE | Payment Date | TPM_PAYMENT_DATE | DATS | 8 | TPM_POSITION_DATE | ||||
DUE_DATE | Due Date | TPM_DUE_DATE | DATS | 8 | DATUM | ||||
RPBANK | Partner bank details | TB_RPBANK | CHAR | 4 | BVTYP | ||||
RPZAHL | Payer/payee | TB_RPZAHL_NEW | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BPA | BUPA |
SZART | Payment transaction | TB_SZART | CHAR | 1 | XFELD | ||||
ZLSCH | Payment Method | DZLSCH | CHAR | 1 | Assigned to domain | ZLSCH | |||
UZAWE | Payment Method Supplement | UZAWE | CHAR | 2 | T042F | UZAWE | |||
SPAYRQ | Payment request allowed | TB_SPAYRQ | CHAR | 1 | T_SPAYRQ | ||||
SPRSNG | Individual payment required | TB_SPRSNG | CHAR | 1 | T_SPAYRQ | ||||
SPRGRD | Determine grouping definition | TB_SPRGRD | CHAR | 1 | T_SPRGRD | ||||
SCSPAY | Same direction necessary for joint payment? | TB_SCSPAY | CHAR | 1 | XFELD | ||||
ZWELS | List of the Payment Methods to be Considered | DZWELS | CHAR | 10 | ZWELS | ||||
PAYGR | Grouping Field for Automatic Payments | PAYGR | CHAR | 20 | CHAR20 | ||||
CALCULATION_DATE | Calculation Date | DVALUT | DATS | 8 | DATUM | ||||
CALC_DATE_INCL | Inclusive indicator for beginning and end of a period | VVSINCL | NUMC | 1 | VVSINCL | ||||
COUPON_DATE | Date of the Next Coupon | TPM_COUPON_DATE | DATS | 8 | DATUM | ||||
COUPON_SIGN | Coupon ID for Interest and Accrued Interest Calculation | TPM_COUPON_SIGN | CHAR | 1 | VVSCOUPON | ||||
CALC_BEGIN | Start of Calculation Period | DBERVON | DATS | 8 | DATUM | ||||
CALC_END | End of Calculation Period | DBERBIS | DATS | 8 | DATUM | ||||
EFF_INT_RATE_U | For Calculation of Amortization Amts (SAC) for Used EffInR | TPM_TRL_EFF_INT_RATE_USED | DEC | 10(7) | DEC3_7 | ||||
SCHED_EFF_RATE | Key for Redemption Schedule that Explains Effect. Int. Rate | RDPT_SCHEDULE_KEY_EFF_RATE | INT4 | 10 | |||||
EFF_INT_RATE_N | Valid Effective Interest Rate for the Next Amortization | TPM_TRL_EFF_INT_RATE_NEW | DEC | 10(7) | DEC3_7 | ||||
SCHED_FIX | Key for Fixed Redemption Schedule | RDPT_SCHEDULE_KEY_FIX | INT4 | 10 | |||||
LANDL | Supplying Country | LANDL | CHAR | 3 | Assigned to domain | LAND1 | |||
LZBKZ | State Central Bank Indicator | LZBKZ | CHAR | 3 | Assigned to domain | LZBKZ | |||
RPCODE | Repetitive Code | RPCODE | CHAR | 20 | Assigned to domain | ALPHA | RPCODE | FIBL_RPCODE | |
RP_TEXT | Reference Text for Repetitive Code | RPCODE_TEXT | CHAR | 50 | XTEXT50 | ||||
RFHAZU | Transaction activity | TB_RFHAZU | NUMC | 5 | T_RFHAZU | FAS | |||
NORDEXT | External Reference | TB_NORDEXT | CHAR | 16 | FTI_CHAR16LOW | ||||
SFGZUSTT | Transaction Activity Category | TB_SFGZUTY | NUMC | 2 | Assigned to domain | T_SFGZUTY | C_AT02 | ||
SKHWFIX | Indicator for translation into local currency | TB_SKHWFIX | CHAR | 1 | T_SKHWFIX | ||||
TRANSL_DATE | Translation Date | WWERT_D | DATS | 8 | DATUM | ||||
RKONDGR | Direction of Transaction | TB_RKONDGR | NUMC | 1 | T_RKONDGR | ||||
COUNTERPARTY | Business Partner Number | TB_KUNNR_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
SNOTDELIVERED | Security not delivered | FTR_NOT_DEL_FLG | CHAR | 1 | XFELD | ||||
CLEARING_STATUS | Clearing Status (TREA) | TPM_TREA_CLEARING_STATUS | NUMC | 1 | TPM_TREA_CLEARING_STATUS | ||||
CLEARING_DATE | Actual Clearing Date | TPM_TREA_CLEARING_DATE_ACT | DATS | 8 | TPM_TREA_CLEARING_DATE | ||||
MNDID | Unique Referene to Mandate per Payment Recipient | SEPA_MNDID | CHAR | 35 | ID035 |
Key field | Non-key field |
How do I retrieve data from SAP table TRDT_FLOW using ABAP code
The following ABAP code Example will allow you to do a basic selection on TRDT_FLOW to SELECT all data from the tableDATA: WA_TRDT_FLOW TYPE TRDT_FLOW.
SELECT SINGLE *
FROM TRDT_FLOW
INTO CORRESPONDING FIELDS OF WA_TRDT_FLOW
WHERE...
How to access SAP table TRDT_FLOW
Within an ECC or HANA version of SAP you can also view further information about TRDT_FLOW and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects