VFCO_CSKS_SHV_NO_AUTH

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 VFCO_CSKS_SHV_NO_AUTH.
-- 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: VFCO_CSKS_SHV_NA

CREATE VIEW VFCO_CSKS_SHV_NO_AUTH AS
SELECT
  kokrs,
  kostl,
  datbi,
  datab,
  bkzkp,
  pkzkp,
  bukrs,
  gsber,
  kosar,
  prctr,
  ersda,
  usnam,
  bkzks,
  bkzer,
  bkzob,
  pkzks,
  pkzer,
  spras,
  khinr,
  func_area
FROM csks
LEFT OUTER JOIN ESH_N_COST_CENTER_ONRKS AS _TO_ONRKS ON kostl = _TO_ONRKS.kostl AND kokrs = _TO_ONRKS.kokrs  -- association [1..*]
LEFT OUTER JOIN cskt AS _TO_CSKT ON datbi = _TO_CSKT.datbi AND kostl = _TO_CSKT.kostl AND kokrs = _TO_CSKT.kokrs  -- association [0..*]
LEFT OUTER JOIN setleaf AS _TO_SETLEAF ON kostl = _TO_SETLEAF.valto AND kostl = _TO_SETLEAF.valfrom AND kokrs = _TO_SETLEAF.subclass AND _TO_SETLEAF.setclass = '0101'  -- association [0..*]
LEFT OUTER JOIN tgsbt AS _CSKS2BUSINESS_AREA_TEXT ON gsber = _CSKS2BUSINESS_AREA_TEXT.gsber  -- association [0..*]
LEFT OUTER JOIN cepct AS _CSKS2CEPCT ON kokrs = _CSKS2CEPCT.kokrs AND prctr = _CSKS2CEPCT.prctr  -- association [0..*]
LEFT OUTER JOIN ESH_N_COMPANY_CODE_OMPANY_CODE AS _CSKS2COMPANY_CODE ON bukrs = _CSKS2COMPANY_CODE.bukrs  -- association [1..1]
LEFT OUTER JOIN tfkbt AS _CSKS2FUNCTIONAL_AREA_TEXT ON func_area = _CSKS2FUNCTIONAL_AREA_TEXT.fkber  -- association [0..*]
LEFT OUTER JOIN tka01 AS _CSKS2TKA01 ON kokrs = _CSKS2TKA01.kokrs  -- association [1..1]
LEFT OUTER JOIN tkt05 AS _CSKS2TKT05 ON kosar = _CSKS2TKT05.kosar  -- association [0..*]
LEFT OUTER JOIN ESH_N_USER_USER AS _CSKS2USER ON usnam = _CSKS2USER.bname  -- association [1..1]
LEFT OUTER JOIN ESH_N_XFELD_3_XFELD AS _CSKS2XFELD_BKZER ON bkzer = _CSKS2XFELD_BKZER.domvalue_l  -- association [0..*]
LEFT OUTER JOIN ESH_N_XFELD_3_XFELD AS _CSKS2XFELD_BKZKP ON bkzkp = _CSKS2XFELD_BKZKP.domvalue_l  -- association [0..*]
LEFT OUTER JOIN ESH_N_XFELD_3_XFELD AS _CSKS2XFELD_BKZKS ON bkzks = _CSKS2XFELD_BKZKS.domvalue_l  -- association [0..*]
LEFT OUTER JOIN ESH_N_XFELD_3_XFELD AS _CSKS2XFELD_BKZOB ON bkzob = _CSKS2XFELD_BKZOB.domvalue_l  -- association [0..*]
LEFT OUTER JOIN ESH_N_XFELD_3_XFELD AS _CSKS2XFELD_PKZER ON pkzer = _CSKS2XFELD_PKZER.domvalue_l  -- association [0..*]
LEFT OUTER JOIN ESH_N_XFELD_3_XFELD AS _CSKS2XFELD_PKZKP ON pkzkp = _CSKS2XFELD_PKZKP.domvalue_l  -- association [0..*]
LEFT OUTER JOIN ESH_N_XFELD_3_XFELD AS _CSKS2XFELD_PKZKS ON pkzks = _CSKS2XFELD_PKZKS.domvalue_l  -- association [0..*]
;