C_CapEvalWorkCenterGroup

DDL: C_CAPEVALWORKCENTERGROUP SQL: CCAPEVALWRKCTGP Type: view CONSUMPTION

Work Center Monitor Work Center Group

C_CapEvalWorkCenterGroup is a Consumption CDS View that provides data about "Work Center Monitor Work Center Group" in SAP S/4HANA. It reads from 1 data source (I_WorkCenterGroupStructure) and exposes 12 fields with key fields WorkCenterGroupTypeCode, WorkCenterGroupInternalID, ObjectTypeCode, ObjectInternalID, WorkCenterTypeCode.

Data Sources (1)

SourceAliasJoin Type
I_WorkCenterGroupStructure _wrkcntrgrp from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CCAPEVALWRKCTGP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Work Center Monitor Work Center Group view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterGroupTypeCode WorkCenterGroupTypeCode
KEY WorkCenterGroupInternalID WorkCenterGroupInternalID
KEY ObjectTypeCode ObjectTypeCode
KEY ObjectInternalID ObjectInternalID
KEY WorkCenterTypeCode WorkCenterTypeCode
KEY WorkCenterInternalID WorkCenterInternalID
WorkCenterGroup WorkCenterGroup Work Center Group
WorkCenterGroupType WorkCenterGroupType Group Type
WorkCenterGroupTypeDescription WorkCenterGroupTypeDescription Group Type Description
WorkCenter Work Center
Plant Plant Plant
WorkCenterGroupDescription WorkCenterGroupDescription Group Description
@AbapCatalog.sqlViewName: 'CCAPEVALWRKCTGP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Work Center Monitor Work Center Group' 
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: { usageType: { dataClass:      #TRANSACTIONAL,
                             sizeCategory:   #XL,
                             serviceQuality: #C }}
define view C_CapEvalWorkCenterGroup 
  as select from I_WorkCenterGroupStructure as _wrkcntrgrp  {
  
    key WorkCenterGroupTypeCode,
    key WorkCenterGroupInternalID,
    key ObjectTypeCode,
    key ObjectInternalID,
    key WorkCenterTypeCode,
    key WorkCenterInternalID,
        @ObjectModel.text.element: 'WorkCenterGroupDescription'
        @EndUserText.label: 'Work Center Group'
        WorkCenterGroup,
        @EndUserText.label: 'Group Type'
        WorkCenterGroupType,
        @EndUserText.label: 'Group Type Description'
        WorkCenterGroupTypeDescription,
        @EndUserText.label: 'Work Center'
        cast(ObjectName as arbpl)    as WorkCenter,
        @EndUserText.label: 'Plant'
        Plant,
        @EndUserText.label: 'Group Description'
        WorkCenterGroupDescription as WorkCenterGroupDescription
    
}
  where ObjectTypeCode   = 'A'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WORKCENTERGROUPSTRUCTURE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/