VFCO_CSKS_SHPV

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_SHPV.
-- 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

CREATE VIEW VFCO_CSKS_SHPV AS
SELECT
  kokrs,
  kostl,
  datbi,
  datab,
  bkzkp,
  pkzkp,
  bukrs,
  gsber,
  kosar,
  verak,
  verak_user,
  prctr,
  ersda,
  usnam,
  bkzks,
  bkzer,
  bkzob,
  pkzks,
  pkzer,
  abtei,
  spras,
  khinr,
  func_area,
  _TO_CSKT.ktext AS ktext
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 AND _TO_CSKT.spras = $session.system_language  -- association [0..1]
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 ESH_N_USER_USER AS _CKKS2USER_VERAK_USR ON verak_user = _CKKS2USER_VERAK_USR.bname  -- association [1..1]
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..*]
;