P_AR_ElectronicDplItemsFromFI

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_AR_ElectronicDplItemsFromFI.
-- 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: PARITMSFROMFI

CREATE VIEW P_AR_ElectronicDplItemsFromFI AS
SELECT
  JournalEntry.CompanyCode AS CompanyCode,
  JournalEntry.FiscalYear AS FiscalYear,
  JournalEntry.AccountingDocument AS AccountingDocument,
  DocumentItem.AccountingDocumentItem AS AccountingDocumentItem,
  TaxItem.TaxItem AS TaxItem,
  JournalEntry.PostingDate AS PostingDate,
  JournalEntry.DocumentDate AS DocumentDate,
  JournalEntry.TaxReportingDate AS TaxReportingDate,
  JournalEntry.ReportingDate AS ReportingDate,
  JournalEntry.FiscalPeriod AS FiscalPeriod,
  JournalEntry.AccountingDocumentType AS AccountingDocumentType,
  JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  JournalEntry.AR_Branch AS AR_Branch,
  JournalEntry.AR_Branch4Digits AS AR_Branch4Digits,
  JournalEntry.AR_PrintCharacter AS AR_PrintCharacter,
  JournalEntry.AR_OfficialDocumentNumber AS AR_OfficialDocumentNumber,
  JournalEntry.IsReversal AS IsReversal,
  JournalEntry.IsReversed AS IsReversed,
  JournalEntry.ReferenceDocumentType AS ReferenceDocumentType,
  TaxItem.TaxType AS TaxType,
  TaxItem.TaxCode AS TaxCode,
  TaxItem.TaxRate AS TaxRate,
  TaxItem.StRpTaxClassification AS StRpTaxClassification,
  TaxItem.CompanyCodeCountry AS CompanyCodeCountry,
  TaxItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  DocumentItem.DebitCreditCode AS DebitCreditCode,
  DocumentItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  JournalEntry.TransactionCurrency AS TransactionCurrency,
  DocumentItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  DocumentItem.BaseUnit AS BaseUnit,
  cast( case when DocumentItem.Quantity = 0 or DocumentItem.Quantity is null then 1 when DocumentItem.Quantity <> 0 or DocumentItem.Quantity is not null then DocumentItem.Quantity end as fiar_quantity_12 ) as Quantity AS Quantityendasfiar_quantity_12asQuantity
FROM P_AR_JournalEntry AS JournalEntry
INNER JOIN P_AR_TaxItem AS TaxItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_OperationalAcctgDocItem AS DocumentItem ON /* join condition not captured in parsed metadata */
;