C_MX_JrnlEntrItmInvcDetailsC

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 C_MX_JrnlEntrItmInvcDetailsC.
-- 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: CMXJEINVDETC
-- Parameters: P_AlternativeGLAccount : figlmx_prim, P_Ledger : fins_ledger, P_FiscalYear : fis_gjahr_no_conv, P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to

CREATE VIEW C_MX_JrnlEntrItmInvcDetailsC AS
SELECT
  JournalEntryWithCompType.SourceLedger AS SourceLedger,
  JournalEntryWithCompType.Ledger AS Ledger,
  JournalEntryWithCompType.CompanyCode AS CompanyCode,
  JournalEntryWithCompType.AccountingDocument AS AccountingDocument,
  JournalEntryWithCompType.FiscalYear AS FiscalYear,
  P_MX_JrnlEntryDistinctGLAcct.GLAccount AS GLAccount,
  P_MX_JrnlEntryDistinctGLAcct.DocumentItemText AS DocumentItemText,
  JournalEntryWithCompType.StatryRptCategory AS StatryRptCategory,
  JournalEntryWithCompType.StatryRptgEntity AS StatryRptgEntity,
  JournalEntryWithCompType.StatryRptRunID AS StatryRptRunID,
  cast ('' as augbl ) AS ClearingAccountingDocument,
  JournalEntryWithCompType.DocumentReferenceID AS DocumentReferenceID,
  JournalEntryWithCompType.ElectronicInvoiceUUID AS ElectronicInvoiceUUID,
  cast ('' as land1 ) AS Country,
  JournalEntryWithCompType.TaxNumber1 AS TaxNumber1,
  cast ('0000' as fis_gjahr_no_conv preserving type ) AS InvoiceReferenceFiscalYear,
  cast ('' as blart ) AS AccountingDocumentType,
  cast ('' as lifnr ) AS Supplier,
  cast ('' as kunnr ) AS Customer,
  '' AS FinancialAccountType,
  cast ('00000000' as augdt ) AS ClearingDate,
  cast ('00000000' as budat ) AS PostingDate,
  abs(cast(sum( JournalEntryWithCompType.AmountInTransactionCurrency ) as fis_wsl preserving type ) ) AS AmountInTransactionCurrency,
  JournalEntryWithCompType.TransactionCurrency AS TransactionCurrency,
  cast(JournalEntryWithCompType.ExchangeRate as abap.dec(9,5)) AS ExchangeRate,
  '' AS LedgerGLLineItem
FROM P_MX_JrnlEntrItmInvcCompType
INNER JOIN P_MX_JrnlEntryDistinctGLAcct ON /* join condition not captured in parsed metadata */
;