I_PostedMCAJournalEntry

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_PostedMCAJournalEntry.
-- 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: IGLEMCAPOST

CREATE VIEW I_PostedMCAJournalEntry AS
SELECT
  _Item.bukrs AS CompanyCode,
  _Item.belnr AS AccountingDocument,
  _Item.gjahr AS FiscalYear,
  _Item.buzei AS AccountingDocumentItem,
  _mcadocref.Runid AS MCARunID,
  _mcadocref.Rldnr AS Ledger,
  _RUNADM.Fileid AS MCAFileID,
  _Header.ldgrp AS LedgerGroup,
  _Header.blart AS AccountingDocumentType,
  _Header.hwaer AS CompanyCodeCurrency,
  _Header.hwae2 AS AdditionalCurrency1,
  _Header.hwae3 AS AdditionalCurrency2,
  _Header.waers AS AccountCurrency,
  _Item.dmbtr AS TransactionAmountInLocalCrcy,
  _Item.dmbe2 AS AmountInAdditionalCurrency1,
  _Item.dmbe3 AS AmountInAdditionalCurrency2,
  _Item.wrbtr AS PurchasingDocumentAmount,
  _Header.ppnam AS ParkedByUser,
  _Header.usnam AS ApprovedByUser,
  _Item.prctr AS ProfitCenter,
  _Item.kostl AS CostCenter,
  _Item.segment AS Segment,
  _Item.vbund AS TradingPartner,
  _Item.bschl AS PostingKey,
  _Header.bldat AS DocumentDate,
  _Header.budat AS PostingDate,
  _Header.monat AS FiscalMonth,
  _Header.bktxt AS AccountingDocumentHeaderText,
  cast( _Header.kursx as abap.dec(28,14) ) AS MarketDataExchangeRate,
  _Header.xblnr AS DocumentReferenceID,
  _Header.stodt AS PlannedReversalDate,
  _Header.stgrd AS ReversalReason,
  _Item.hkont AS GLAccount,
  _Item.pprct AS PartnerProfitCenter,
  _Item.psegment AS PartnerSegment,
  _Item.valut AS ValueDate,
  _Item.sgtxt AS DocumentItemText,
  _Item.zuonr AS AssignmentReference
FROM bseg AS _Item
INNER JOIN bkpf AS _Header ON /* join condition not captured in parsed metadata */
INNER JOIN P_MCAdocref AS _mcadocref ON /* join condition not captured in parsed metadata */
INNER JOIN P_RUNADMID AS _RUNADM ON /* join condition not captured in parsed metadata */
;