P_UnrealizedCrcyDiff

Unrealized Currency Difference | view: PUNREALZCRCYDIFF | Extraction: Not supported | Component: SAP Cash Management
Tables used: ACDOCA, FCLM_BAM_AMD, FCLM_BAM_ACLINK2, T001, TKA02, SKB1, FCLM_FCV_LQITEM, FINSC_LEDGER_REP
Column Name Description
SourceLedger FK Source Ledger
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Ledger FK Ledger in General Ledger Accounting
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
Column Name Description
Column Name Description
TransactionDate Journal Entry Date
PostingDate Posting Date
Column Name Description
FinancialAccountType Account Type Show values
Column Name Description Domain name
AccountingDocumentItem Journal Entry Posting View Item BUZEI
FiscalPeriod Fiscal Period POPER
DocumentItemText Item Text TEXT50
WBSElement Project FIS_PROJECT
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
LiquidityItem null
GrantID Grant GM_GRANT_NBR
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_UNREALIZEDCRCYDIFF.MANDT == T003.MANDT
  • P_UNREALIZEDCRCYDIFF.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Bank Account Technical ID
  • Bank Account Technical ID
  • Client
  • ?
  • P_UNREALIZEDCRCYDIFF.BANKACCOUNTINTERNALID == FCLM_BAM_AMD.ACC_ID
  • P_UNREALIZEDCRCYDIFF.MANDT == FCLM_BAM_AMD.MANDT
  • P_UNREALIZEDCRCYDIFF.[column in domain "FCLM_REVISION"] == FCLM_BAM_AMD.REVISION
Business Area
  • Client
  • Business Area
  • P_UNREALIZEDCRCYDIFF.MANDT == TGSB.MANDT
  • P_UNREALIZEDCRCYDIFF.BUSINESSAREA == TGSB.GSBER
Planning Group
  • Client
  • Planning Group
  • P_UNREALIZEDCRCYDIFF.MANDT == T035.MANDT
  • P_UNREALIZEDCRCYDIFF.CASHPLANNINGGROUP == T035.GRUPP
Company Code
  • Client
  • Company Code
  • P_UNREALIZEDCRCYDIFF.MANDT == T001.MANDT
  • P_UNREALIZEDCRCYDIFF.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • P_UNREALIZEDCRCYDIFF.MANDT == TCURC.MANDT
  • P_UNREALIZEDCRCYDIFF.COMPANYCODECURRENCY == TCURC.WAERS
Cost Center
  • ?
  • Client
  • Cost Center
  • ?
  • P_UNREALIZEDCRCYDIFF.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_UNREALIZEDCRCYDIFF.MANDT == CSKS.MANDT
  • P_UNREALIZEDCRCYDIFF.COSTCENTER == CSKS.KOSTL
  • P_UNREALIZEDCRCYDIFF.[column in domain "DATBI"] == CSKS.DATBI
Customer Number
  • Client
  • Customer Number
  • P_UNREALIZEDCRCYDIFF.MANDT == KNA1.MANDT
  • P_UNREALIZEDCRCYDIFF.CUSTOMER == KNA1.KUNNR
Fund
  • ?
  • Fund
  • Client
  • P_UNREALIZEDCRCYDIFF.[column in domain "FIKRS"] == FMFINCODE.FIKRS
  • P_UNREALIZEDCRCYDIFF.FUND == FMFINCODE.FINCODE
  • P_UNREALIZEDCRCYDIFF.MANDT == FMFINCODE.MANDT
G/L Account
  • Client
  • G/L Account
  • Company Code
  • P_UNREALIZEDCRCYDIFF.MANDT == SKB1.MANDT
  • P_UNREALIZEDCRCYDIFF.GLACCOUNT == SKB1.SAKNR
  • P_UNREALIZEDCRCYDIFF.COMPANYCODE == SKB1.BUKRS
House Bank Key
  • Client
  • ?
  • House Bank Key
  • P_UNREALIZEDCRCYDIFF.MANDT == T012.MANDT
  • P_UNREALIZEDCRCYDIFF.[column in domain "BUKRS"] == T012.BUKRS
  • P_UNREALIZEDCRCYDIFF.HOUSEBANK == T012.HBKID
House Bank Account
  • Client
  • House Bank Account
  • ?
  • House Bank Key
  • P_UNREALIZEDCRCYDIFF.MANDT == T012K.MANDT
  • P_UNREALIZEDCRCYDIFF.HOUSEBANKACCOUNT == T012K.HKTID
  • P_UNREALIZEDCRCYDIFF.[column in domain "BUKRS"] == T012K.BUKRS
  • P_UNREALIZEDCRCYDIFF.HOUSEBANK == T012K.HBKID
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
Logical System P_UNREALIZEDCRCYDIFF.LOGICALSYSTEM == TBDLS.LOGSYS
Material Number
  • Material Number
  • Client
  • P_UNREALIZEDCRCYDIFF.MATERIAL == MARA.MATNR
  • P_UNREALIZEDCRCYDIFF.MANDT == MARA.MANDT
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • P_UNREALIZEDCRCYDIFF.MANDT == T880.MANDT
  • P_UNREALIZEDCRCYDIFF.PARTNERCOMPANY == T880.RCOMP
Planning Level
  • Client
  • Planning Level
  • P_UNREALIZEDCRCYDIFF.MANDT == T036.MANDT
  • P_UNREALIZEDCRCYDIFF.PLANNINGLEVEL == T036.EBENE
Profit Center
  • ?
  • Client
  • ?
  • Profit Center
  • P_UNREALIZEDCRCYDIFF.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_UNREALIZEDCRCYDIFF.MANDT == CEPC.MANDT
  • P_UNREALIZEDCRCYDIFF.[column in domain "DATBI"] == CEPC.DATBI
  • P_UNREALIZEDCRCYDIFF.PROFITCENTER == CEPC.PRCTR
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_UNREALIZEDCRCYDIFF.MANDT == FAGL_SEGM.MANDT
  • P_UNREALIZEDCRCYDIFF.SEGMENT == FAGL_SEGM.SEGMENT
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Supplier
  • Supplier
  • Client
  • P_UNREALIZEDCRCYDIFF.SUPPLIER == LFA1.LIFNR
  • P_UNREALIZEDCRCYDIFF.MANDT == LFA1.MANDT
Transaction Currency
  • Client
  • Transaction Currency
  • P_UNREALIZEDCRCYDIFF.MANDT == TCURC.MANDT
  • P_UNREALIZEDCRCYDIFF.TRANSACTIONCURRENCY == TCURC.WAERS