P_UnrealizedCrcyDiff

DDL: P_UNREALIZEDCRCYDIFF SQL: PUNREALZCRCYDIFF Type: view COMPOSITE
39 Fields 3 Data Sources

P_UnrealizedCrcyDiff is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_CompanyCode, I_GLAccountInCompanyCode, I_JournalEntryItem) and exposes 39 fields with key fields SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem.

Data Sources (3)

SourceAliasJoin Type
I_CompanyCode _compcode inner
I_GLAccountInCompanyCode _gl inner
I_JournalEntryItem _je from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PUNREALZCRCYDIFF view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.compiler.compareFilter true view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger I_JournalEntryItem SourceLedger Source Ledger
KEY CompanyCode I_JournalEntryItem CompanyCode Receiver Company Code
KEY FiscalYear I_JournalEntryItem FiscalYear G/L Fiscal Year
KEY AccountingDocument I_JournalEntryItem AccountingDocument Journal Entry
KEY LedgerGLLineItem I_JournalEntryItem LedgerGLLineItem Journal Entry Item
KEY Ledger I_JournalEntryItem Ledger Ledger
LogicalSystem I_JournalEntryItem LogicalSystem Logical System
TransactionCurrency I_JournalEntryItem TransactionCurrency Transaction Currency
AmountInTransactionCurrency I_JournalEntryItem AmountInTransactionCurrency Pt Crcy Amt
CompanyCodeCurrency I_JournalEntryItem CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency I_JournalEntryItem AmountInCompanyCodeCurrency Local Crcy Amt
AccountingDocCreatedByUser I_JournalEntryItem AccountingDocCreatedByUser User which created overhead document
AccountingDocumentItem I_JournalEntryItem AccountingDocumentItem Posting View Item
AccountingDocumentType I_JournalEntryItem AccountingDocumentType Journal Entry Type
FiscalPeriod I_JournalEntryItem FiscalPeriod Tax period
GLAccount I_JournalEntryItem GLAccount General Ledger
FinancialAccountType I_JournalEntryItem FinancialAccountType Fin. Account Type
DocumentItemText I_JournalEntryItem DocumentItemText Text
TransactionDate I_JournalEntryItem DocumentDate Journal Entry Date
PostingDate I_JournalEntryItem PostingDate Posting Date for GR
CashPlanningGroup I_GLAccountInCompanyCode CashPlanningGroup Planning Group
PlanningLevel I_GLAccountInCompanyCode PlanningLevel Planning Level
HouseBank I_JournalEntryItem HouseBank House Bank
HouseBankAccount I_JournalEntryItem HouseBankAccount House Bank Account
BankAccountInternalID _bankAccount BankAccountInternalID Technical ID
BankAccountCurrency
Customer I_JournalEntryItem Customer Sold-to Party
Supplier I_JournalEntryItem Supplier Supplier
PartnerCompany I_JournalEntryItem PartnerCompany Trading Partner
Material I_JournalEntryItem Material Vehicle Model
BusinessArea I_JournalEntryItem BusinessArea Business Area
ProfitCenter I_JournalEntryItem ProfitCenter Profit Center
CostCenter I_JournalEntryItem CostCenter Cost Center
Segment I_JournalEntryItem Segment Segment number
WBSElementInternalID I_JournalEntryItem WBSElementInternalID WBS Internal ID
WBSElementExternalID I_JournalEntryItem WBSElement WBS Internal ID
LiquidityItem
Fund I_JournalEntryItem Fund Sender Fund
GrantID I_JournalEntryItem GrantID Sender Grant

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_UnrealizedCrcyDiff.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PUNREALZCRCYDIFF

CREATE VIEW P_UnrealizedCrcyDiff AS
SELECT
  _je.SourceLedger AS SourceLedger,
  _je.CompanyCode AS CompanyCode,
  _je.FiscalYear AS FiscalYear,
  _je.AccountingDocument AS AccountingDocument,
  _je.LedgerGLLineItem AS LedgerGLLineItem,
  _je.Ledger AS Ledger,
  _je.LogicalSystem AS LogicalSystem,
  _je.TransactionCurrency AS TransactionCurrency,
  _je.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  _je.CompanyCodeCurrency AS CompanyCodeCurrency,
  _je.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  _je.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  _je.AccountingDocumentItem AS AccountingDocumentItem,
  _je.AccountingDocumentType AS AccountingDocumentType,
  _je.FiscalPeriod AS FiscalPeriod,
  _je.GLAccount AS GLAccount,
  _je.FinancialAccountType AS FinancialAccountType,
  _je.DocumentItemText AS DocumentItemText,
  _je.DocumentDate AS TransactionDate,
  _je.PostingDate AS PostingDate,
  _gl.CashPlanningGroup AS CashPlanningGroup,
  _gl.PlanningLevel AS PlanningLevel,
  _je.HouseBank AS HouseBank,
  _je.HouseBankAccount AS HouseBankAccount,
  _bankAccount.BankAccountInternalID AS BankAccountInternalID,
  coalesce(_bamCrcy.BankAccountCurrency, cast('' as waers)) AS BankAccountCurrency,
  _je.Customer AS Customer,
  _je.Supplier AS Supplier,
  _je.PartnerCompany AS PartnerCompany,
  _je.Material AS Material,
  _je.BusinessArea AS BusinessArea,
  _je.ProfitCenter AS ProfitCenter,
  _je.CostCenter AS CostCenter,
  _je.Segment AS Segment,
  _je.WBSElementInternalID AS WBSElementInternalID,
  _je.WBSElement AS WBSElementExternalID,
  coalesce(_lq_comp.LiquidityItem, coalesce(_lq_coa.LiquidityItem, cast('' as flqpos))) AS LiquidityItem,
  _je.Fund AS Fund,
  _je.GrantID AS GrantID
FROM I_JournalEntryItem AS _je
INNER JOIN I_CompanyCode AS _compcode ON /* join condition not captured in parsed metadata */
INNER JOIN I_GLAccountInCompanyCode AS _gl ON /* join condition not captured in parsed metadata */
;

Learn More