FISVD_TRK_DOC_11

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 FISVD_TRK_DOC_11.
-- 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_11

CREATE VIEW FISVD_TRK_DOC_11 AS
SELECT
  CompanyCode,
  Ledger,
  AccountingDocument,
  cdpos.changenr AS changenr,
  cdpos.tabname AS TableName,
  cdpos.tabkey AS tabkey,
  fname,
  FISCDS_TRK_DOC_04.JournalEntryItem AS JournalEntryItem,
  FiscalYear,
  PostingDate,
  DocumentDate,
  username AS ChangedBy,
  utime AS ChangedAt,
  value_old AS OldValue,
  value_new AS NewValue,
  udate AS ChangedOn,
  cdpos.text_case AS text_case,
  CreationDate,
  CreationTime,
  AccountType,
  GLAccountNR,
  cdpos.chngind AS bkpf_tabkeykeyCompanyCode,
  case cdpos.tabname when 'BKPF' then '' when 'BSEGR' then '' when 'ACDOCA' then substring(cdpos.tabkey, 4,2) end as Ledger AS tabkey42endasLedger,
  fname AS rollname,
  cdpos.chngind AS field_namekeyCompanyCode,
  cdpos.chngind AS bsegadd_tabkeykeyCompanyCode,
  cdpos.chngind AS chngind
INNER JOIN FISCDS_TRK_DOC_04 ON /* join condition not captured in parsed metadata */
INNER JOIN cdpos ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t001 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fins_glo_it_fl_t AS glo_it ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fins_glo_ot_fl_t AS glo_ot ON /* join condition not captured in parsed metadata */
INNER JOIN FISCDS_TRK_DOC_07 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fins_glo_hd_fl_t AS glo_hd ON /* join condition not captured in parsed metadata */
INNER JOIN FISCDS_TRK_DOC_03 ON /* join condition not captured in parsed metadata */
INNER JOIN FISCDS_TRK_DOC_05 ON /* join condition not captured in parsed metadata */
;