SHSM_FKK_CM_CPERS

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 SHSM_FKK_CM_CPERS.
-- 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: SHSMFKKCMCPERS

CREATE VIEW SHSM_FKK_CM_CPERS AS
SELECT
  but050.client AS client,
  but050.relnr AS relnr,
  but050.partner1 AS partner1,
  but050.partner2 AS partner2,
  but050.date_to AS date_to,
  but050.date_from AS date_from,
  but000.name_last AS name_last,
  but000.name_first AS name_first,
  but000.augrp AS augrp,
  but050.rltyp AS rltyp,
  but000.xpcpt AS xpcpt,
  but000.xdcset AS xdcset,
  but000.data_ctrlr1 AS data_ctrlr1,
  but000.data_ctrlr2 AS data_ctrlr2,
  but000.data_ctrlr3 AS data_ctrlr3,
  but000.data_ctrlr4 AS data_ctrlr4,
  but000.data_ctrlr5 AS data_ctrlr5,
  but000.data_ctrlr6 AS data_ctrlr6,
  but000.data_ctrlr7 AS data_ctrlr7,
  but000.data_ctrlr8 AS data_ctrlr8,
  but000.data_ctrlr9 AS data_ctrlr9,
  but000.data_ctrlr10 AS data_ctrlr10
FROM but000
;