P_UnrealizedDiffAgg

Unrealized Currency Difference Aggregation | view: PUNREALZDIFFAGG | Extraction: Not supported | Component: SAP Cash Management
Tables used: ACDOCA, FCLM_BAM_AMD, FCLM_BAM_AMD, FCLM_BAM_ACLINK2, FCLM_BAM_AMD, FCLM_BAM_AC_TYPE, 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
💲 Company Code Currency (BaseCurrency):
BaseAmount Amount in Company Code Currency
💲 Transaction Currency (Currency):
Amount Amount in Transaction Currency
AmountInAccountCurrency Amount
Column Name Description
Column Name Description
TransactionDate Value date
PostingDate Posting Date in the Document
Column Name Description
OriginApplication Source Application Show values
CertaintyLevel Certainty Level Show values
FinancialAccountType Account Type Show values
Column Name Description Domain name
OriginDocument Source Document ID FQM_ORIGIN_DOC_ID
OriginTransaction Source Transaction ID FQM_ORIGIN_TRANS_ID
OriginTransactionQualifier Source Transaction Qualifier FQM_ORIGIN_TRANS_QUALIFIER
CashFlow Line Item in Source Document FQM_ORIGIN_FLOW_ID
AccountingDocumentItem Journal Entry Posting View Item BUZEI
FiscalPeriod Fiscal Period POPER
DocumentItemText Item Text TEXT50
PaymentMethod Payment Method ZLSCH
BankAccountId null
WBSElement Project FIS_PROJECT
LiquidityItem null
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
GrantID Grant GM_GRANT_NBR
BusinessPartner Business Partner Number BU_PARTNER
SourceCompanyCode Company Code BUKRS
Bank null
BankCountry null
BankAccount null
BankAccountType null
IBAN null
direction null
Master Data Relations Join Conditions
Company Code Currency
  • Client
  • Company Code Currency
  • P_UNREALIZEDDIFFAGG.MANDT == TCURC.MANDT
  • P_UNREALIZEDDIFFAGG.BASECURRENCY == TCURC.WAERS
Business Area
  • Client
  • Business Area
  • P_UNREALIZEDDIFFAGG.MANDT == TGSB.MANDT
  • P_UNREALIZEDDIFFAGG.BUSINESSAREA == TGSB.GSBER
Planning Group
  • Planning Group
  • Client
  • P_UNREALIZEDDIFFAGG.CASHPLANNINGGROUP == T035.GRUPP
  • P_UNREALIZEDDIFFAGG.MANDT == T035.MANDT
Company Code
  • Client
  • Company Code
  • P_UNREALIZEDDIFFAGG.MANDT == T001.MANDT
  • P_UNREALIZEDDIFFAGG.COMPANYCODE == T001.BUKRS
Cost Center
  • ?
  • Client
  • Cost Center
  • ?
  • P_UNREALIZEDDIFFAGG.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_UNREALIZEDDIFFAGG.MANDT == CSKS.MANDT
  • P_UNREALIZEDDIFFAGG.COSTCENTER == CSKS.KOSTL
  • P_UNREALIZEDDIFFAGG.[column in domain "DATBI"] == CSKS.DATBI
Transaction Currency
  • Client
  • Transaction Currency
  • P_UNREALIZEDDIFFAGG.MANDT == TCURC.MANDT
  • P_UNREALIZEDDIFFAGG.CURRENCY == TCURC.WAERS
Customer Number
  • Customer Number
  • Client
  • P_UNREALIZEDDIFFAGG.CUSTOMER == KNA1.KUNNR
  • P_UNREALIZEDDIFFAGG.MANDT == KNA1.MANDT
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_UNREALIZEDDIFFAGG.MANDT == T003.MANDT
  • P_UNREALIZEDDIFFAGG.FIDOCUMENTTYPE == T003.BLART
Fund
  • Client
  • ?
  • Fund
  • P_UNREALIZEDDIFFAGG.MANDT == FMFINCODE.MANDT
  • P_UNREALIZEDDIFFAGG.[column in domain "FIKRS"] == FMFINCODE.FIKRS
  • P_UNREALIZEDDIFFAGG.FUND == FMFINCODE.FINCODE
G/L Account
  • Client
  • G/L Account
  • Company Code
  • P_UNREALIZEDDIFFAGG.MANDT == SKB1.MANDT
  • P_UNREALIZEDDIFFAGG.GLACCOUNT == SKB1.SAKNR
  • P_UNREALIZEDDIFFAGG.COMPANYCODE == SKB1.BUKRS
House Bank Key
  • ?
  • House Bank Key
  • Client
  • P_UNREALIZEDDIFFAGG.[column in domain "BUKRS"] == T012.BUKRS
  • P_UNREALIZEDDIFFAGG.HOUSEBANK == T012.HBKID
  • P_UNREALIZEDDIFFAGG.MANDT == T012.MANDT
House Bank Account
  • ?
  • House Bank Key
  • Client
  • House Bank Account
  • P_UNREALIZEDDIFFAGG.[column in domain "BUKRS"] == T012K.BUKRS
  • P_UNREALIZEDDIFFAGG.HOUSEBANK == T012K.HBKID
  • P_UNREALIZEDDIFFAGG.MANDT == T012K.MANDT
  • P_UNREALIZEDDIFFAGG.HOUSEBANKACCOUNT == T012K.HKTID
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Material Number
  • Material Number
  • Client
  • P_UNREALIZEDDIFFAGG.MATERIAL == MARA.MATNR
  • P_UNREALIZEDDIFFAGG.MANDT == MARA.MANDT
Logical System P_UNREALIZEDDIFFAGG.ORIGINSYSTEM == TBDLS.LOGSYS
Planning Level
  • Client
  • Planning Level
  • P_UNREALIZEDDIFFAGG.MANDT == T036.MANDT
  • P_UNREALIZEDDIFFAGG.PLANNINGLEVEL == T036.EBENE
Profit Center
  • Profit Center
  • ?
  • Client
  • ?
  • P_UNREALIZEDDIFFAGG.PROFITCENTER == CEPC.PRCTR
  • P_UNREALIZEDDIFFAGG.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_UNREALIZEDDIFFAGG.MANDT == CEPC.MANDT
  • P_UNREALIZEDDIFFAGG.[column in domain "DATBI"] == CEPC.DATBI
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_UNREALIZEDDIFFAGG.MANDT == FAGL_SEGM.MANDT
  • P_UNREALIZEDDIFFAGG.SEGMENT == FAGL_SEGM.SEGMENT
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Supplier
  • Client
  • Supplier
  • P_UNREALIZEDDIFFAGG.MANDT == LFA1.MANDT
  • P_UNREALIZEDDIFFAGG.SUPPLIER == LFA1.LIFNR
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • P_UNREALIZEDDIFFAGG.MANDT == T880.MANDT
  • P_UNREALIZEDDIFFAGG.TRADINGPARTNER == T880.RCOMP