fiscds_mref_doc_07

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_07.
-- 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_07

CREATE VIEW fiscds_mref_doc_07 AS
SELECT
  a.bukrs AS CompanyCode,
  a.gjahr AS FiscalYear,
  b.Ledger AS Ledger,
  b.SourceLedger AS SourceLedger,
  b.AccountingDocument AS AccountingDocument,
  b.AccountingDocumentItem AS AccountingDocumentItem,
  a.xblnr AS DocumentReferenceID,
  FinancialAccountType,
  a.bldat AS DocumentDate,
  AccountingDocumentType,
  cast(substring( cast(b.CreationDate as abap.char(30)), 1 , 8) as abap.dats) AS CreationDate,
  a.budat AS PostingDate,
  b.AssignmentReference AS AssignmentReference,
  a.usnam AS AccountingDocCreatedByUser,
  b.PostingKey AS PostingKey,
  b.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  b.CompanyCodeCurrency AS CompanyCodeCurrency,
  b.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  b.TransactionCurrency AS TransactionCurrency,
  b.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  b.FunctionalCurrency AS FunctionalCurrency,
  b.ChartOfAccounts AS ktopl,
  b.GLAccount AS GLAccount,
  b.SpecialGLCode AS SpecialGLIndicator,
  case b.FinancialAccountType when 'D' then b.Customer when 'K' then b.Supplier end as Account AS SupplierendasAccount,
  b.FinancialAccountType AS koart
FROM bkpf AS a
INNER JOIN I_GLAccountLineItem AS b ON /* join condition not captured in parsed metadata */
;