CUAN_TG_OPERATION_SOURCE

DDL: CUAN_TG_OPERATION_SOURCE Type: view_entity Package: CUAN_CDS_TARGET_GROUP_NO_TRANS

AT_TG_OPERATION_SOURCE

CUAN_TG_OPERATION_SOURCE is a CDS View that provides data about "AT_TG_OPERATION_SOURCE" in SAP S/4HANA. It reads from 4 data sources (dd07t, cuan_d_tg_operat, cuan_d_tg_root, cuan_d_tg_root) and exposes 9 fields with key field db_key. Part of development package CUAN_CDS_TARGET_GROUP_NO_TRANS.

4 data source(s) 9 fields

Data Sources (4)

SourceAliasJoin Type
dd07t dd07t left_outer
cuan_d_tg_operat op inner
cuan_d_tg_root rt from
cuan_d_tg_root sc inner

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label AT_TG_OPERATION_SOURCE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY db_key cuan_d_tg_operat db_key
source_tg_id cuan_d_tg_root id
operation_id cuan_d_tg_root id
source_key cuan_d_tg_root db_key
operation cuan_d_tg_operat operation
type cuan_d_tg_root type
mkt_area_id cuan_d_tg_root mkt_area_id
parent_key cuan_d_tg_operat parent_key
operation_t dd07t ddtext 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'AT_TG_OPERATION_SOURCE'
//@ObjectModel.representativeKey: 'waers'

@ObjectModel.usageType: {serviceQuality: #X, sizeCategory: #XL, dataClass: #MIXED}
@Search.searchable
@AccessControl.personalData.blocking: #NOT_REQUIRED

define view entity CUAN_TG_OPERATION_SOURCE
  as select from    cuan_d_tg_root as rt
  
    inner join cuan_d_tg_operat as op
      on op.parent_key = rt.db_key
      
    inner join cuan_d_tg_root as sc
      on sc.db_key = op.source_key

    left outer join dd07t                               on  op.operation                     = dd07t.domvalue_l
                                                        and dd07t.domname                    = 'CUAN_TG_OPERATION'
                                                        and dd07t.as4local                   = 'A'
                                                        and dd07t.ddlanguage                 = $session.system_language

{
  key op.db_key as db_key,
  sc.id as source_tg_id,
  rt.id as operation_id,
  rt.db_key as operation_key,
  sc.db_key as source_key,
  op.operation as operation,
  rt.type as type,
  rt.mkt_area_id as mkt_area_id,
  rt.life_cycle_status as life_cycle_status,
  op.parent_key as parent_key,
  @Search: { defaultSearchElement:true, ranking: #HIGH }
  dd07t.ddtext as operation_t
}

Learn More