I_CshJrnlEntrForUnrlzdCrcyDiff

Unrealized Currency Differences | view: ICSHUNRLZDDIFF | 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
WBSElementInternalID WBS Element PS_S4_PSPNR
LiquidityItem null
GrantID Grant GM_GRANT_NBR
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.MANDT == T003.MANDT
Bank Account Technical ID
  • ?
  • Bank Account Technical ID
  • Client
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.[column in domain "FCLM_REVISION"] == FCLM_BAM_AMD.REVISION
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.BANKACCOUNTINTERNALID == FCLM_BAM_AMD.ACC_ID
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.MANDT == FCLM_BAM_AMD.MANDT
Business Area
  • Business Area
  • Client
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.BUSINESSAREA == TGSB.GSBER
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.MANDT == TGSB.MANDT
Planning Group
  • Client
  • Planning Group
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.MANDT == T035.MANDT
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.CASHPLANNINGGROUP == T035.GRUPP
Company Code
  • Company Code
  • Client
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.COMPANYCODE == T001.BUKRS
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.COMPANYCODECURRENCY == TCURC.WAERS
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.MANDT == TCURC.MANDT
Cost Center
  • ?
  • ?
  • Client
  • Cost Center
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.[column in domain "DATBI"] == CSKS.DATBI
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.[column in domain "KOKRS"] == CSKS.KOKRS
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.MANDT == CSKS.MANDT
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.COSTCENTER == CSKS.KOSTL
Customer Number
  • Customer Number
  • Client
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.CUSTOMER == KNA1.KUNNR
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.MANDT == KNA1.MANDT
Fund
  • Fund
  • ?
  • Client
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.FUND == FMFINCODE.FINCODE
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.[column in domain "FIKRS"] == FMFINCODE.FIKRS
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.MANDT == FMFINCODE.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.GLACCOUNT == SKB1.SAKNR
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.COMPANYCODE == SKB1.BUKRS
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.MANDT == SKB1.MANDT
House Bank Key
  • House Bank Key
  • Client
  • ?
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.HOUSEBANK == T012.HBKID
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.MANDT == T012.MANDT
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.[column in domain "BUKRS"] == T012.BUKRS
House Bank Account
  • House Bank Key
  • House Bank Account
  • Client
  • ?
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.HOUSEBANK == T012K.HBKID
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.HOUSEBANKACCOUNT == T012K.HKTID
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.MANDT == T012K.MANDT
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.[column in domain "BUKRS"] == T012K.BUKRS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.MANDT == FINSC_LEDGER.MANDT
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.LEDGER == FINSC_LEDGER.RLDNR
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.SOURCELEDGER == FINSC_LEDGER.RLDNR
Logical System I_CSHJRNLENTRFORUNRLZDCRCYDIFF.LOGICALSYSTEM == TBDLS.LOGSYS
Material Number
  • Material Number
  • Client
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.MATERIAL == MARA.MATNR
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.MANDT == MARA.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.PARTNERCOMPANY == T880.RCOMP
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.MANDT == T880.MANDT
Planning Level
  • Client
  • Planning Level
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.MANDT == T036.MANDT
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.PLANNINGLEVEL == T036.EBENE
Profit Center
  • ?
  • ?
  • Profit Center
  • Client
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.[column in domain "DATBI"] == CEPC.DATBI
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.[column in domain "KOKRS"] == CEPC.KOKRS
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.PROFITCENTER == CEPC.PRCTR
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.MANDT == CEPC.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.SEGMENT == FAGL_SEGM.SEGMENT
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.MANDT == FAGL_SEGM.MANDT
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.MANDT == FINSC_LEDGER.MANDT
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.LEDGER == FINSC_LEDGER.RLDNR
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.SOURCELEDGER == FINSC_LEDGER.RLDNR
Supplier
  • Supplier
  • Client
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.SUPPLIER == LFA1.LIFNR
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.MANDT == LFA1.MANDT
Transaction Currency
  • Client
  • Transaction Currency
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.MANDT == TCURC.MANDT
  • I_CSHJRNLENTRFORUNRLZDCRCYDIFF.TRANSACTIONCURRENCY == TCURC.WAERS