V_TACECOMP_SIMULATION

DDL: V_TACECOMP_SIMULATION SQL: V_TACECOMP_SIM Type: view Package: ACE_S4_COMMON

Components with simulation enabled

V_TACECOMP_SIMULATION is a CDS View that provides data about "Components with simulation enabled" in SAP S/4HANA. It reads from 2 data sources (tacecompc, tacecompt) and exposes 3 fields. Part of development package ACE_S4_COMMON.

2 data source(s) 3 fields

Data Sources (2)

SourceAliasJoin Type
tacecompc tacecompc left_outer
tacecompt tacecompt left_outer

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName V_TACECOMP_SIM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
EndUserText.label Components with simulation enabled view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (3)

KeyFieldSource TableSource FieldDescription
mandt tacecomp mandt
comp tacecomp comp
txt50 tacecompt txt50 
@AbapCatalog.sqlViewName: 'V_TACECOMP_SIM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass:  #MASTER
@ObjectModel.usageType.serviceQuality: #C
@EndUserText.label: 'Components with simulation enabled'
@ClientHandling.algorithm: #SESSION_VARIABLE
define view V_TACECOMP_SIMULATION
  as select distinct from tacecomp
    left outer join       tacecompc on(
      tacecomp.mandt    = tacecompc.mandt
      and tacecomp.comp = tacecompc.comp
    )
    left outer join       tacecompt on(
      tacecompt.mandt     = tacecomp.mandt
      and tacecompt.comp  = tacecomp.comp
      and tacecompt.spras = $session.system_language
    )
{
  tacecomp.mandt,
  tacecomp.comp,
  tacecompt.txt50
}

where
  (
         tacecomp.simulation_enabled = 'X'
    and(
         tacecompc.inactive          = ' '
      or tacecompc.inactive          is null
    )
  )

Learn More