fiscds_trk_doc_02

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_trk_doc_02.
-- 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_TRK_DOC_02
-- Parameters: P_Language : sylangu

CREATE VIEW fiscds_trk_doc_02 AS
SELECT
  CompanyCode,
  Ledger,
  AccountingDocument,
  changenr,
  TableName,
  tabkey,
  fname,
  JournalEntryItem,
  case when field_text[1:language = :P_Language].ddtext <> '' then field_text[1:language = :P_Language].ddtext else dele_text[1:ddlanguage = :P_Language].ddtext end as FieldName AS ddtextendasFieldName,
  FiscalYear,
  PostingDate,
  DocumentDate,
  ChangedBy,
  ChangedAt,
  OldValue,
  NewValue,
  ChangedOn,
  CreationDate,
  CreationTime,
  text_case,
  AccountType,
  GLAccountNR,
  chngind
FROM FISVD_TRK_DOC_11
LEFT OUTER JOIN fiscds_trk_fld_text AS field_text ON TableName = field_text.tabname AND fname = field_text.fieldname  -- association [0..1]
LEFT OUTER JOIN dd04t AS dele_text ON fname = dele_text.rollname  -- association [0..1]
;