VFCO_CSKA_SHPV

DDL: VFCO_CSKA_SHV SQL: VFCO_CSKA_SHV Type: view Package: FINS_CO_UTIL

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. Part of development package FINS_CO_UTIL.

1 data source(s) 11 fields

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
KEY kstar kstar
ersda ersda
usnam usnam
func_area func_area
_TO_SETLEAF _TO_SETLEAF
_TO_CSKU _TO_CSKU
ktext _TO_CSKU ktext
_3440B5B0A0F01E_C81E72216D86E9 _3440B5B0A0F01E_C81E72216D86E9
_CSKA2KTOPL _CSKA2KTOPL
_CSKA2USER _CSKA2USER 
-- Search help view
-- This CDS view represents node CSKA of search model COST_ELEMENT_H of search software component SAPAPPLH.
-- This CDS view represents: Cost Elements (Data Dependent on Chart of Accounts).
-- CSS component (relevant to Customer Incidents): CO-OM
-- Package: BSESH_CO_OM
-- Software Component: S4CORE
@AbapCatalog.sqlViewName: 'VFCO_CSKA_SHV'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Cost Elements (Data Dependent on Chart of Accounts)'
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #P
@ObjectModel.dataCategory: #VALUE_HELP
@ClientHandling.algorithm: #SESSION_VARIABLE
@ClientHandling.type: #INHERITED
define view VFCO_CSKA_SHPV
as select from cska

//  association [0..*] to ESH_N_COST_ELM_CSKB_CSKB as _0090FA114A141E_8C124A17698D40 on $projection.kstar     = _0090FA114A141E_8C124A17698D40.kstar

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

{
  key ktopl,
  key kstar,
  ersda,
  usnam,
  func_area,
 // _0090FA114A141E_8C124A17698D40,

  _TO_SETLEAF,
  _TO_CSKU,
  _TO_CSKU.ktext,
  _3440B5B0A0F01E_C81E72216D86E9,
  _CSKA2KTOPL,
  _CSKA2USER
}

Learn More