I_CFinAAPurchasingItemPosting

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 I_CFinAAPurchasingItemPosting.
-- 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.

CREATE VIEW I_CFinAAPurchasingItemPosting AS
SELECT
  I_CFinAAPurchasingValidItem.SenderLogicalSystem AS SenderLogicalSystem,
  I_CFinAAPurchasingValidItem.CFinRpldPurchasingDocument AS CFinRpldPurchasingDocument,
  I_CFinAAPurchasingValidItem.CFinRpldPurchasingDocumentItem AS CFinRpldPurchasingDocumentItem,
  I_JournalEntry.CompanyCode AS CompanyCode,
  I_JournalEntry.FiscalYear AS FiscalYear,
  I_JournalEntry.AccountingDocument AS AccountingDocument,
  I_JournalEntry.FiscalPeriod AS FiscalPeriod,
  I_JournalEntry.DocumentDate AS DocumentDate,
  I_JournalEntry.PostingDate AS PostingDate,
  I_JournalEntry.AccountingDocumentType AS AccountingDocumentType,
  I_JournalEntry.LedgerGroup AS LedgerGroup,
  cast( I_JournalEntry.ReferenceDocumentType as awtyp preserving type ) AS ReferenceDocumentType,
  cast( I_JournalEntry.OriginalReferenceDocument as awkey preserving type ) AS OriginalReferenceDocument,
  I_JournalEntry.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
  I_JournalEntry.AccountingDocumentClass AS AccountingDocumentClass,
  I_JournalEntry.ReverseDocument AS ReverseDocument,
  I_JournalEntry.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  I_JournalEntry.IsReversed AS IsReversed,
  I_JournalEntry.IsReversal AS IsReversal,
  I_JournalEntry.SenderCompanyCode AS SenderCompanyCode,
  I_JournalEntry.SenderAccountingDocument AS SenderAccountingDocument,
  I_JournalEntry.SenderFiscalYear AS SenderFiscalYear,
  I_CFinAAPurchasingValidItem.CFinAAPurchasingValidItemUUID AS CFinAAPurchasingValidItemUUID,
  I_CFinAAPurchasingValidItem.CFinAAManagedAssetUUID AS CFinAAManagedAssetUUID,
  I_CFinAAPurchasingValidItem.CFinAAPurchasingItemStatus AS CFinAAPurchasingItemStatus,
  I_CFinAAPurchasingValidItem.MaterialGroup AS MaterialGroup,
  I_CFinAAPurchasingValidItem.AccountAssignmentCategory AS AccountAssignmentCategory,
  I_CFinAAPurchasingValidItem.CFinAAAssetCompanyCode AS CFinAAAssetCompanyCode,
  I_CFinAAPurchasingValidItem.CFinAAPurgConfignIsConsistent AS CFinAAPurgConfignIsConsistent,
  I_CFinAAPurchasingValidItem.MasterFixedAsset AS MasterFixedAsset,
  I_CFinAAPurchasingValidItem.FixedAsset AS FixedAsset,
  I_CFinAAPurchasingValidItem.CFinAAHasAssetCreationMessage AS CFinAAHasAssetCreationMessage,
  I_CFinAAPurchasingValidItem.CFinAAHasAssetPostingMessage AS CFinAAHasAssetPostingMessage,
  I_CFinAAPurchasingValidItem.CFinAAHasPurgItemUpdateMessage AS CFinAAHasPurgItemUpdateMessage
INNER JOIN I_JournalEntry ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ReferenceDocumentTypeText AS _ReferenceDocumentTypeText ON ReferenceDocumentType = _ReferenceDocumentTypeText.ReferenceDocumentType AND _ReferenceDocumentTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LedgerGroupText AS _LedgerGroupText ON LedgerGroup = _LedgerGroupText.LedgerGroup AND _LedgerGroupText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentTypeText AS _AccountingDocumentTypeText ON AccountingDocumentType = _AccountingDocumentTypeText.AccountingDocumentType AND _AccountingDocumentTypeText.Language = $session.system_language  -- association [0..1]
;