P_MX_JrnlEntrItmInvcDetails

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_MX_JrnlEntrItmInvcDetails.
-- 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: PMXJEINVDET
-- Parameters: P_Ledger : fins_ledger, P_FiscalYear : fis_gjahr_no_conv, P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to

CREATE VIEW P_MX_JrnlEntrItmInvcDetails AS
SELECT
  MX_OperationalAcctDocItem.SourceLedger AS SourceLedger,
  MX_OperationalAcctDocItem.Ledger AS Ledger,
  MX_OperationalAcctDocItem.CompanyCode AS CompanyCode,
  MX_OperationalAcctDocItem.AccountingDocument AS AccountingDocument,
  MX_OperationalAcctDocItem.FiscalYear AS FiscalYear,
  MX_OperationalAcctDocItem.StatryRptCategory AS StatryRptCategory,
  MX_OperationalAcctDocItem.StatryRptgEntity AS StatryRptgEntity,
  MX_OperationalAcctDocItem.StatryRptRunID AS StatryRptRunID,
  MX_OperationalAcctDocItem.AccountingDocumentItem AS AccountingDocumentItem,
  MX_OperationalAcctDocItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  MX_OperationalAcctDocItem.TransactionCurrency AS TransactionCurrency,
  MX_OperationalAcctDocItem.ExchangeRate AS ExchangeRate,
  MX_OperationalAcctDocItem.JrnlEntryCntrySpecificRef5 AS JrnlEntryCntrySpecificRef5,
  MX_OperationalAcctDocItem.Country AS Country,
  MX_OperationalAcctDocItem.TaxNumberLineItem AS TaxNumberLineItem,
  MX_OperationalAcctDocItem.DocumentReferenceID AS DocumentReferenceID,
  MX_OperationalAcctDocItem.Supplier AS Supplier,
  MX_OperationalAcctDocItem.Customer AS Customer,
  MX_OperationalAcctDocItem.FinancialAccountType AS FinancialAccountType,
  MX_OperationalAcctDocItem.DebitCreditCode AS DebitCreditCode,
  MX_OperationalAcctDocItem.DigInvcOp1 AS DigInvcOp1,
  MX_OperationalAcctDocItem.DigInvcOp2 AS DigInvcOp2,
  MX_OperationalAcctDocItem.PostingDate AS PostingDate,
  MX_OperationalAcctDocItem.AccountingDocumentType AS AccountingDocumentType,
  MX_OperationalAcctDocItem.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  MX_OperationalAcctDocItem.ClearingDate AS ClearingDate,
  MX_OperationalAcctDocItem.FiscalYear AS InvoiceReferenceFiscalYear,
  MX_OperationalAcctDocItem.IsReversal AS IsReversal,
  MX_OperationalAcctDocItem.IsReversed AS IsReversed,
  MX_OperationalAcctDocItem.PaymentMethod AS PaymentMethod,
  MX_OperationalAcctDocItem.ReferenceDocumentContext AS ReferenceDocumentContext,
  MX_OperationalAcctDocItem.ReferenceDocument AS ReferenceDocument,
  MX_OperationalAcctDocItem.ReferenceDocumentType AS ReferenceDocumentType,
  '' AS IsFormatedForDigitalInvoice
FROM P_MX_OperationalAcctDocItem
LEFT OUTER JOIN P_MX_eDocInvcDetails ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_MX_eDocumentPaymentDetails AS MX_eDocumentPaymentDetails ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON MX_OperationalAcctDocItem.TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
;