1. Home
  2. Resources
  3. SAP Tables
  4. DIFT_POS_IDENT - Persistent Flow Selectors

SAP Table DIFT_POS_IDENT

Persistent Flow Selectors

DIFT_POS_IDENT (Persistent Flow Selectors) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link DIFT_POS_IDENT to other SAP tables.

DIFT_POS_IDENT table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
OS_GUID Object Identity in Database Format TPM_DB_OS_GUID CHAR 32 0
CONTEXT Context for Identifier DIF_IDENT_CONTEXT CHAR 3 0
DIF Differentiation (Test)
TRQ Quantity ledger position
TRL Treasury ledger
PCT Subledger position
ASP Class position in securities account
ACP Securities account position
COA Corporate actions
IDENTIFIED_OID Object Identity in Database Format TPM_DB_OS_GUID CHAR 32 0
IDENTIFIED_CLS Object Identity in Database Format TPM_DB_OS_GUID CHAR 32 0
VALUATION_AREA Valuation Area TPM_VAL_AREA TRGC_VAL_AREA CHAR 3 0
COM_VAL_CLASS General Valuation Class TPM_COM_VAL_CLASS TRGC_COM_VALCL NUMC 4 0
VALUATION_CLASS Valuation Class TPM_VAL_CLASS TRGC_VAL_CLASS NUMC 4 0
ACCOUNTING_CODE Accounting Code TPM_ACC_CODE TRGC_TR_ACC_CODE CHAR 4 0
COMPANY_CODE Company Code BUKRS T001 CHAR 4 0
PRODUCT_TYPE Product Type VVSART TZPA CHAR 3 0
SECURITY_ACCOUNT Securities Account RLDEPO TWD01 CHAR 10 0
SECURITY_ID Security ID Number VVRANLW VWPANLA CHAR 13 0
PORTFOLIO Portfolio as Differentiation Characteristic TPM_PORTFOLIO_DIFF TWPOB CHAR 10 0
TRADER Trader RDEALER TZDEA CHAR 12 0
ACCOUNT_GROUP Securities Account Group TPM_SEC_ACCT_GRP TRGT_SECACCGRP CHAR 10 0
LOANS_CONTRACT Contract Number RANL VDARL CHAR 13 0
POSITION_ACCOUNT Futures Account for Listed Options and Futures TPM_POS_ACCOUNT_FUT TRFT_POS_ACCOUNT CHAR 10 0
FLAG_LONG_SHORT Indicator: Long or Short Position TPM_FLAG_LONG_SHORT CHAR 1 0
L Long position
S Short position
LOT_ID Identifier of the Lot TPM_LOT_ID RAW 16 0
DEAL_NUMBER Financial Transaction TB_RFHA VTBFHA CHAR 13 0
FUND Fund FM_FUND CHAR 10 0
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
EXTERNAL_ACCOUNT External Account TPM_EXT_ACCOUNT CHAR 10 0
DIFF_CURRENCY Currency as Differentiation Term TPM_DIFF_CURRENCY TCURC CUKY 5 0

DIFT_POS_IDENT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
DIFT_POS_IDENT ACCOUNTING_CODE * TRGC_TR_ACC_CODE Accounting Code MANDT
DIFT_POS_IDENT ACCOUNTING_CODE DIFT_POS_IDENT ACCOUNTING_CODE TRGC_TR_ACC_CODE Accounting Code TR_ACC_CODE
DIFT_POS_IDENT ACCOUNT_GROUP * TRGT_SECACCGRP Securities Account Groups (Definition) MANDT
DIFT_POS_IDENT ACCOUNT_GROUP DIFT_POS_IDENT COMPANY_CODE TRGT_SECACCGRP Securities Account Groups (Definition) COMPANY_CODE
DIFT_POS_IDENT ACCOUNT_GROUP DIFT_POS_IDENT ACCOUNT_GROUP TRGT_SECACCGRP Securities Account Groups (Definition) SEC_ACCT_GRP
DIFT_POS_IDENT COMPANY_CODE * T001 Company Codes MANDT
DIFT_POS_IDENT COMPANY_CODE DIFT_POS_IDENT COMPANY_CODE T001 Company Codes BUKRS
DIFT_POS_IDENT COM_VAL_CLASS * TRGC_COM_VALCL General valuation class MANDT
DIFT_POS_IDENT COM_VAL_CLASS DIFT_POS_IDENT COM_VAL_CLASS TRGC_COM_VALCL General valuation class COM_VAL_CLASS
DIFT_POS_IDENT DEAL_NUMBER DIFT_POS_IDENT DEAL_NUMBER VTBFHA Transaction RFHA
DIFT_POS_IDENT DEAL_NUMBER SYST MANDT VTBFHA Transaction MANDT
DIFT_POS_IDENT DEAL_NUMBER DIFT_POS_IDENT COMPANY_CODE VTBFHA Transaction BUKRS
DIFT_POS_IDENT DIFF_CURRENCY SYST MANDT TCURC Currency Codes MANDT
DIFT_POS_IDENT DIFF_CURRENCY DIFT_POS_IDENT DIFF_CURRENCY TCURC Currency Codes WAERS
DIFT_POS_IDENT LOANS_CONTRACT * VDARL Loans MANDT
DIFT_POS_IDENT LOANS_CONTRACT DIFT_POS_IDENT COMPANY_CODE VDARL Loans BUKRS
DIFT_POS_IDENT LOANS_CONTRACT * VDARL Loans SARCHIV
DIFT_POS_IDENT LOANS_CONTRACT DIFT_POS_IDENT LOANS_CONTRACT VDARL Loans RANL
DIFT_POS_IDENT PORTFOLIO * TWPOB Portfolio position MANDT
DIFT_POS_IDENT PORTFOLIO DIFT_POS_IDENT COMPANY_CODE TWPOB Portfolio position BUKRS
DIFT_POS_IDENT PORTFOLIO DIFT_POS_IDENT PORTFOLIO TWPOB Portfolio position RPORTB
DIFT_POS_IDENT POSITION_ACCOUNT DIFT_POS_IDENT MANDT TRFT_POS_ACCOUNT Treasury: Futures Account Master Data MANDT
DIFT_POS_IDENT POSITION_ACCOUNT DIFT_POS_IDENT COMPANY_CODE TRFT_POS_ACCOUNT Treasury: Futures Account Master Data COMPANY_CODE
DIFT_POS_IDENT POSITION_ACCOUNT DIFT_POS_IDENT POSITION_ACCOUNT TRFT_POS_ACCOUNT Treasury: Futures Account Master Data POS_ACCOUNT
DIFT_POS_IDENT PRODUCT_TYPE * TZPA Financial Assets Management Product Types MANDT
DIFT_POS_IDENT PRODUCT_TYPE DIFT_POS_IDENT PRODUCT_TYPE TZPA Financial Assets Management Product Types GSART
DIFT_POS_IDENT SECURITY_ACCOUNT DIFT_POS_IDENT COMPANY_CODE TWD01 Treasury: Securities Account Master Data BUKRS
DIFT_POS_IDENT SECURITY_ACCOUNT DIFT_POS_IDENT SECURITY_ACCOUNT TWD01 Treasury: Securities Account Master Data RLDEPO
DIFT_POS_IDENT SECURITY_ACCOUNT * TWD01 Treasury: Securities Account Master Data MANDT
DIFT_POS_IDENT SECURITY_ID * VWPANLA Asset master for securities MANDT
DIFT_POS_IDENT SECURITY_ID DIFT_POS_IDENT SECURITY_ID VWPANLA Asset master for securities RANL
DIFT_POS_IDENT TRADER * TZDEA Trader register MANDT
DIFT_POS_IDENT TRADER DIFT_POS_IDENT COMPANY_CODE TZDEA Trader register BUKRS
DIFT_POS_IDENT TRADER DIFT_POS_IDENT TRADER TZDEA Trader register RDEALER
DIFT_POS_IDENT VALUATION_AREA * TRGC_VAL_AREA Valuation Areas MANDT
DIFT_POS_IDENT VALUATION_AREA DIFT_POS_IDENT VALUATION_AREA TRGC_VAL_AREA Valuation Areas VALUATION_AREA
DIFT_POS_IDENT VALUATION_CLASS DIFT_POS_IDENT VALUATION_AREA TRGC_VAL_CLASS Treasury: Valuation Class VALUATION_AREA
DIFT_POS_IDENT VALUATION_CLASS DIFT_POS_IDENT VALUATION_CLASS TRGC_VAL_CLASS Treasury: Valuation Class VALUATION_CLASS
DIFT_POS_IDENT VALUATION_CLASS * TRGC_VAL_CLASS Treasury: Valuation Class MANDT