fiscds_mref_doc_01

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 fiscds_mref_doc_01.
-- 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: FISV_MREF_DOC_01

CREATE VIEW fiscds_mref_doc_01 AS
SELECT
  a.bukrs AS bukrs,
  a.gjahr AS gjahr,
  a.xblnr AS xblnr,
  c.Ledger AS rldnr,
  c.SourceLedger AS rldnr_pers,
  c.LedgerGLLineItem AS docln,
  b.belnr AS belnr,
  c.FinancialAccountType AS koart,
  b.bldat AS bldat,
  b.blart AS blart,
  b.cpudt AS CreationDate,
  b.budat AS budat,
  c.AssignmentReference AS zuonr,
  c.AccountingDocCreatedByUser AS usnam,
  c.PostingKey AS bschl,
  c.AmountInCompanyCodeCurrency AS hsl,
  c.CompanyCodeCurrency AS rhcur,
  c.AmountInTransactionCurrency AS wsl,
  c.TransactionCurrency AS rwcur,
  c.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  c.FunctionalCurrency AS FunctionalCurrency,
  c.ChartOfAccounts AS ktopl,
  c.GLAccount AS racct,
  c.SpecialGLCode AS umskz,
  case c.FinancialAccountType when 'D' then c.Customer when 'K' then c.Supplier end as wakonto AS Supplierendaswakonto,
  b.stblg AS stblg,
  b.stgrd AS stgrd
FROM fiscds_mref_invoice AS a
INNER JOIN bkpf AS b ON /* join condition not captured in parsed metadata */
INNER JOIN I_GLAccountLineItem AS c ON /* join condition not captured in parsed metadata */
;