P_UnrealizedCrcyDiffFilter

Filter on Unrealized Currency Difference | view: PUNCRCYDIFFFTR | Extraction: Not supported | Component: SAP Cash Management
Tables used: ACDOCA, FQM_FLOW, FCLM_BAM_AMD, FCLM_BAM_ACLINK2, T030H, T001, TKA02, SKB1, FINSC_LEDGER, FCLM_KF_SCOPE, FQM_FLOW_CAT_KF, FCLM_FCV_LQITEM, FINSC_ACTVE_APPL, FINSC_LEDGER_REP
Column Name Description
OriginSystem Logical system
OriginApplication Source Application Show values
OriginDocument Source Document ID
OriginTransaction Source Transaction ID
OriginTransactionQualifier Source Transaction Qualifier
CashFlow Line Item in Source Document
ValidFrom UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
ValidTo UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
CashFlowScopeForAccounting Cash Flow Scope for Accounting Show values
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Transaction Amount
💲 Currency Key (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Transaction Amount
Column Name Description
Column Name Description
TransactionDate Value date
PostingDate Posting Date in the Document
ExpirationDate Date
Column Name Description
OriginApplication Source Application Show values
CashFlowScopeForAccounting Cash Flow Scope for Accounting Show values
IsValid Boolean Variable (X = True, - = False, Space = Unknown) Show values
CertaintyLevel Certainty Level Show values
CashReleaseStatus Release Status Show values
FinancialAccountType Account Type Show values
Column Name Description Domain name
CashFlowSnapshotValue null
CashFlowID Flow ID FQM_ID
CreationDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
LastChangedByUser Last Changed By USNAM
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
CashTransactionOwner Owner of a Business Transaction FQM_OWNER
AccountingDocument Journal Entry BELNR
AccountingDocumentItem Number of Line Item Within Accounting Document
FiscalYear Fiscal Year GJAHR
PostingFiscalPeriod Fiscal period MONAT
PaymentMethod Payment Method ZLSCH
DocumentItemText Item Text TEXT50
BusinessPartner Business Partner Number BU_PARTNER
WBSElementInternalID WBS Element PS_S4_PSPNR
LiquidityItem null
SourceCompanyCode Company Code BUKRS
FinancialInstrumentProductType Product Type VVSART
FinancialTransactionType Financial Transaction Type T_SFHAART
SecurityClass Security Class ID Number WP_RANL
SecurityAccount Securities Account RLDEPO
AssetContract Contract Number CHAR13
Portfolio Portfolio RPORTB
OriginTransactionValue Source Transaction ID FQM_ORIGIN_TRANS_ID
OriginFlowID Line Item in Source Document FQM_ORIGIN_FLOW_ID
OriginDocumentValue Origin Document ID FQM_ORIGIN_DOC_ID
BankStatementShortID null
BankStatementItem null
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_UNREALIZEDCRCYDIFFFILTER.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_UNREALIZEDCRCYDIFFFILTER.MANDT == T003.MANDT
Bank Account Technical ID
  • ?
  • Bank Account Technical ID
  • Client
  • P_UNREALIZEDCRCYDIFFFILTER.[column in domain "FCLM_REVISION"] == FCLM_BAM_AMD.REVISION
  • P_UNREALIZEDCRCYDIFFFILTER.BANKACCOUNTINTERNALID == FCLM_BAM_AMD.ACC_ID
  • P_UNREALIZEDCRCYDIFFFILTER.MANDT == FCLM_BAM_AMD.MANDT
Business Area
  • Business Area
  • Client
  • P_UNREALIZEDCRCYDIFFFILTER.BUSINESSAREA == TGSB.GSBER
  • P_UNREALIZEDCRCYDIFFFILTER.MANDT == TGSB.MANDT
Planning Group
  • Planning Group
  • Client
  • P_UNREALIZEDCRCYDIFFFILTER.CASHPLANNINGGROUP == T035.GRUPP
  • P_UNREALIZEDCRCYDIFFFILTER.MANDT == T035.MANDT
Company Code
  • Company Code
  • Client
  • P_UNREALIZEDCRCYDIFFFILTER.COMPANYCODE == T001.BUKRS
  • P_UNREALIZEDCRCYDIFFFILTER.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • P_UNREALIZEDCRCYDIFFFILTER.MANDT == TCURC.MANDT
  • P_UNREALIZEDCRCYDIFFFILTER.COMPANYCODECURRENCY == TCURC.WAERS
Cost Center
  • ?
  • ?
  • Cost Center
  • Client
  • P_UNREALIZEDCRCYDIFFFILTER.[column in domain "DATBI"] == CSKS.DATBI
  • P_UNREALIZEDCRCYDIFFFILTER.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_UNREALIZEDCRCYDIFFFILTER.COSTCENTER == CSKS.KOSTL
  • P_UNREALIZEDCRCYDIFFFILTER.MANDT == CSKS.MANDT
Customer Number
  • Customer Number
  • Client
  • P_UNREALIZEDCRCYDIFFFILTER.CUSTOMER == KNA1.KUNNR
  • P_UNREALIZEDCRCYDIFFFILTER.MANDT == KNA1.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • P_UNREALIZEDCRCYDIFFFILTER.GLACCOUNT == SKB1.SAKNR
  • P_UNREALIZEDCRCYDIFFFILTER.COMPANYCODE == SKB1.BUKRS
  • P_UNREALIZEDCRCYDIFFFILTER.MANDT == SKB1.MANDT
House Bank Key
  • House Bank Key
  • ?
  • Client
  • P_UNREALIZEDCRCYDIFFFILTER.HOUSEBANK == T012.HBKID
  • P_UNREALIZEDCRCYDIFFFILTER.[column in domain "BUKRS"] == T012.BUKRS
  • P_UNREALIZEDCRCYDIFFFILTER.MANDT == T012.MANDT
House Bank Account
  • House Bank Account
  • House Bank Key
  • ?
  • Client
  • P_UNREALIZEDCRCYDIFFFILTER.HOUSEBANKACCOUNT == T012K.HKTID
  • P_UNREALIZEDCRCYDIFFFILTER.HOUSEBANK == T012K.HBKID
  • P_UNREALIZEDCRCYDIFFFILTER.[column in domain "BUKRS"] == T012K.BUKRS
  • P_UNREALIZEDCRCYDIFFFILTER.MANDT == T012K.MANDT
Material Number
  • Material Number
  • Client
  • P_UNREALIZEDCRCYDIFFFILTER.MATERIAL == MARA.MATNR
  • P_UNREALIZEDCRCYDIFFFILTER.MANDT == MARA.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • P_UNREALIZEDCRCYDIFFFILTER.PARTNERCOMPANY == T880.RCOMP
  • P_UNREALIZEDCRCYDIFFFILTER.MANDT == T880.MANDT
Planning Level
  • Planning Level
  • Client
  • P_UNREALIZEDCRCYDIFFFILTER.PLANNINGLEVEL == T036.EBENE
  • P_UNREALIZEDCRCYDIFFFILTER.MANDT == T036.MANDT
Profit Center
  • ?
  • ?
  • Profit Center
  • Client
  • P_UNREALIZEDCRCYDIFFFILTER.[column in domain "DATBI"] == CEPC.DATBI
  • P_UNREALIZEDCRCYDIFFFILTER.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_UNREALIZEDCRCYDIFFFILTER.PROFITCENTER == CEPC.PRCTR
  • P_UNREALIZEDCRCYDIFFFILTER.MANDT == CEPC.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • P_UNREALIZEDCRCYDIFFFILTER.SEGMENT == FAGL_SEGM.SEGMENT
  • P_UNREALIZEDCRCYDIFFFILTER.MANDT == FAGL_SEGM.MANDT
Supplier
  • Supplier
  • Client
  • P_UNREALIZEDCRCYDIFFFILTER.SUPPLIER == LFA1.LIFNR
  • P_UNREALIZEDCRCYDIFFFILTER.MANDT == LFA1.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • P_UNREALIZEDCRCYDIFFFILTER.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_UNREALIZEDCRCYDIFFFILTER.MANDT == TCURC.MANDT