P_SI_LineItemsNonResident

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_SI_LineItemsNonResident.
-- 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 P_SI_LineItemsNonResident AS
SELECT
  vfd.CompanyCode AS CompanyCode,
  vfd.AccountingDocument AS AccountingDocument,
  vfd.FiscalYear AS FiscalYear,
  GLAcntIItmRD.SourceLedger AS Ledger,
  GLAcntIItmRD.LedgerGLLineItem AS LedgerGLLineItem,
  GLAcntIItmRD.AccountingDocumentItem AS AccountingDocumentItem,
  GLAcntIItmRD.GLAccount AS GLAccount,
  vfd.Customer AS Customer,
  customer.CustomerName AS CustomerName,
  vfd.Supplier AS Supplier,
  supplier.SupplierName AS SupplierName,
  GLAcntIItmRD.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  OperAccDocItm.AccountingDocumentItemType AS AccountingDocumentItemType,
  OperAccDocItm.TaxCode AS TaxCode,
  GLAcntIItmRD.CompanyCodeCurrency AS CompanyCodeCurrency,
  cast( 'EUR' as fis_hwaer ) AS ReportingCurrency,
  GLAcntIItmRD.PostingDate AS PostingDate,
  GLAcntIItmRD.DocumentDate AS DocumentDate,
  GLAcntIItmRD.FinancialAccountType AS FinancialAccountType,
  GLAcntIItmRD.Product AS Product,
  mak.ProductName AS ProductName,
  GLAcntIItmRD.ChartOfAccounts AS ChartOfAccounts,
  ska.GLAccountName AS GLAccountName,
  GLAcntIItmRD.DocumentItemText AS DocumentItemText,
  GLAcntIItmRD.DebitCreditCode AS DebitCreditCode,
  GLAcntIItmRD._ClearingAccountingDocument.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  coalesce( country_added.Country, vfd.Country ) AS Country,
  sif.LastChangedAtDateTime AS LastChangedAtDateTime,
  sif.LocalLastChangedAtDateTime AS LocalLastChangedAtDateTime,
  GLAcntIItmRD.AccountingDocumentType AS AccountingDocumentType,
  vfd.DocumentIsAdded AS DocumentIsAdded
FROM P_SI_AddNonResidentDocument AS vfd
LEFT OUTER JOIN I_Customer AS customer ON Customer = customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_ProductText AS mak ON mak.Language = $session.system_language AND Product = mak.Product  -- association [0..1]
LEFT OUTER JOIN I_GLAccountText AS ska ON ska.Language = $session.system_language AND ChartOfAccounts = ska.ChartOfAccounts AND GLAccount = ska.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_SI_TradeIDCodeAssignment AS assign ON assign.GLAccount is not initial AND assign.Material is not initial AND CompanyCode = assign.CompanyCode AND Product = assign.Material AND GLAccount = assign.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_SI_TradeIDCodeAssignment AS assign2 ON assign2.Material is not initial AND assign2.GLAccount is initial AND CompanyCode = assign2.CompanyCode AND Product = assign2.Material  -- association [0..1]
LEFT OUTER JOIN I_SI_TradeIDCodeAssignment AS assign3 ON assign3.GLAccount is not initial AND assign3.Material is initial AND CompanyCode = assign3.CompanyCode AND GLAccount = assign3.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_SI_TradeIdentifierCodeLog AS sif ON sif.TradeIdentificationCode is not initial AND CompanyCode = sif.CompanyCode AND Ledger = sif.Ledger AND FiscalYear = sif.FiscalYear AND AccountingDocument = sif.AccountingDocument AND LedgerGLLineItem = sif.LedgerGLLineItem  -- association [0..1]
LEFT OUTER JOIN I_SI_TradeIdentifierCodeLog AS sif_added ON vfd.DocumentIsAdded is not initial AND sif_added.LedgerGLLineItem is initial AND sif_added.TradeIdentificationCode is not initial AND CompanyCode = sif_added.CompanyCode AND Ledger = sif_added.Ledger AND FiscalYear = sif_added.FiscalYear AND AccountingDocument = sif_added.AccountingDocument  -- association [0..1]
LEFT OUTER JOIN I_SI_TradeIdentifierCodeLog AS country_added ON vfd.DocumentIsAdded is not initial AND LedgerGLLineItem = country_added.LedgerGLLineItem AND country_added.Country is not initial AND CompanyCode = country_added.CompanyCode AND Ledger = country_added.Ledger AND FiscalYear = country_added.FiscalYear AND AccountingDocument = country_added.AccountingDocument  -- association [0..1]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS OperAccDocItm ON CompanyCode = OperAccDocItm.CompanyCode AND AccountingDocument = OperAccDocItm.AccountingDocument AND FiscalYear = OperAccDocItm.FiscalYear AND AccountingDocumentItem = OperAccDocItm.AccountingDocumentItem  -- association [1..1]
;