P_AUDIT_AT_KNA1

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 P_AUDIT_AT_KNA1.
-- 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: PAUDITATKNA1

CREATE VIEW P_AUDIT_AT_KNA1 AS
SELECT
  knb1.bukrs AS bukrs,
  kna1.kunnr AS kunnr,
  kna1.kunnr AS Customer,
  kna1.land1 AS land1,
  kna1.name1 AS name1,
  kna1.name2 AS name2,
  kna1.ort01 AS ort01,
  kna1.pstlz AS pstlz,
  kna1.sortl AS sortl,
  kna1.stras AS stras,
  kna1.adrnr AS adrnr,
  kna1.mcod1 AS mcod1,
  kna1.mcod2 AS mcod2,
  kna1.mcod3 AS mcod3,
  kna1.konzs AS konzs,
  kna1.lifnr AS lifnr,
  kna1.stkzu AS stkzu,
  kna1.stceg AS stceg,
  kna1.txjcd AS txjcd,
  kna1.ktokd AS ktokd,
  kna1.xdcset AS DataControllerSet,
  kna1.data_ctrlr1 AS DataController1,
  kna1.data_ctrlr2 AS DataController2,
  kna1.data_ctrlr3 AS DataController3,
  kna1.data_ctrlr4 AS DataController4,
  kna1.data_ctrlr5 AS DataController5,
  kna1.data_ctrlr6 AS DataController6,
  kna1.data_ctrlr7 AS DataController7,
  kna1.data_ctrlr8 AS DataController8,
  kna1.data_ctrlr9 AS DataController9,
  kna1.data_ctrlr10 AS DataController10
FROM kna1
;