VFCO_CSKA_SHPV

DDL: VFCO_CSKA_SHV SQL: VFCO_CSKA_SHV Type: view
11 Fields 1 Data Sources 5 Associations

Cost Elements (Data Dependent on Chart of Accounts)

VFCO_CSKA_SHPV is a CDS View that provides data about "Cost Elements (Data Dependent on Chart of Accounts)" in SAP S/4HANA. It reads from 1 data source (cska) and exposes 11 fields with key fields ktopl, kstar. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
cska cska from

Associations (5)

CardinalityTargetAliasCondition
[1..1] setleaf _TO_SETLEAF $projection.ktopl = _TO_SETLEAF.subclass and $projection.kstar = _TO_SETLEAF.valfrom and $projection.kstar = _TO_SETLEAF.valto and _TO_SETLEAF.setclass = '0102'
[0..1] csku _TO_CSKU $projection.ktopl = _TO_CSKU.ktopl and $projection.kstar = _TO_CSKU.kstar and _TO_CSKU.spras = $session.system_language
[0..*] tfkbt _3440B5B0A0F01E_C81E72216D86E9 $projection.func_area = _3440B5B0A0F01E_C81E72216D86E9.fkber
[0..*] ESH_N_KTOPL_KTOPL _CSKA2KTOPL $projection.ktopl = _CSKA2KTOPL.DOMVALUE_L
[1..1] ESH_N_USER_USER _CSKA2USER $projection.usnam = _CSKA2USER.bname

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName VFCO_CSKA_SHV view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Cost Elements (Data Dependent on Chart of Accounts) view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.dataCategory #VALUE_HELP view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #INHERITED view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ktopl ktopl G/L Chart of Accounts
KEY kstar kstar Settlement CE
ersda ersda Entry Date
usnam usnam User Name
func_area func_area Receiving Func. Area
_TO_SETLEAF _TO_SETLEAF
_TO_CSKU _TO_CSKU
ktext _TO_CSKU ktext Text
_3440B5B0A0F01E_C81E72216D86E9 _3440B5B0A0F01E_C81E72216D86E9
_CSKA2KTOPL _CSKA2KTOPL
_CSKA2USER _CSKA2USER

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_CSKA_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_CSKA_SHV

CREATE VIEW VFCO_CSKA_SHPV AS
SELECT
  ktopl,
  kstar,
  ersda,
  usnam,
  func_area,
  _TO_CSKU.ktext AS ktext
FROM cska
LEFT OUTER JOIN setleaf AS _TO_SETLEAF ON ktopl = _TO_SETLEAF.subclass AND kstar = _TO_SETLEAF.valfrom AND kstar = _TO_SETLEAF.valto AND _TO_SETLEAF.setclass = '0102'  -- association [1..1]
LEFT OUTER JOIN csku AS _TO_CSKU ON ktopl = _TO_CSKU.ktopl AND kstar = _TO_CSKU.kstar AND _TO_CSKU.spras = $session.system_language  -- association [0..1]
LEFT OUTER JOIN tfkbt AS _3440B5B0A0F01E_C81E72216D86E9 ON func_area = _3440B5B0A0F01E_C81E72216D86E9.fkber  -- association [0..*]
LEFT OUTER JOIN ESH_N_KTOPL_KTOPL AS _CSKA2KTOPL ON ktopl = _CSKA2KTOPL.DOMVALUE_L  -- association [0..*]
LEFT OUTER JOIN ESH_N_USER_USER AS _CSKA2USER ON usnam = _CSKA2USER.bname  -- association [1..1]
;

Learn More