I_ConfignOvwPgClass

DDL: I_CONFIGNOVWPGCLASS SQL: ICONFOVPCLS Type: view BASIC

Overview - Class

I_ConfignOvwPgClass is a Basic CDS View that provides data about "Overview - Class" in SAP S/4HANA. It reads from 1 data source (I_ClfnClass) and exposes 9 fields with key field ConfignOvwPgMDObject. It has 1 association to related views.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_ClfnClass I_ClfnClass from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ClfnClassDescription _ClassDescription I_ClfnClass.ClassInternalID = _ClassDescription.ClassInternalID and _ClassDescription.Language = $session.system_language

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICONFOVPCLS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Overview - Class view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ConfignOvwPgMDObject ClassInternalID
ClassType ClassType
ValidityStartDate ValidityStartDate
ConfignOvwPgObjName Class
ConfignOvwPgObjStatus
ClassDescription _ClassDescription ClassDescription
ConfignOvwPgObjType
ClassMaintAuthGrp ClassMaintAuthGrp
_ClassDescription _ClassDescription 
@AbapCatalog.sqlViewName: 'ICONFOVPCLS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Overview - Class'

@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #MASTER

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
define view I_ConfignOvwPgClass
  as select from I_ClfnClass
  association [0..1] to I_ClfnClassDescription as _ClassDescription on  I_ClfnClass.ClassInternalID = _ClassDescription.ClassInternalID
                                                                    and _ClassDescription.Language  = $session.system_language
{

  key ClassInternalID                                  as ConfignOvwPgMDObject,
      ClassType,
      ValidityStartDate,
      case
           when ( LastChangedByUser is null or LastChangedByUser = '' ) then CreatedByUser
           else LastChangedByUser
           end                                         as LastChangedByUser,

      case
        when ( LastChangeDate = '00000000' or LastChangeDate is null ) then CreationDate
        else LastChangeDate
        end                                            as LastChangeDate,

      Class                                            as ConfignOvwPgObjName,
      cast ( ClassStatus as vchclf_ovp_object_status ) as ConfignOvwPgObjStatus,
      _ClassDescription.ClassDescription,
      #vchclf_ovp_object_type.'4'                      as ConfignOvwPgObjType,
      ClassMaintAuthGrp,
      _ClassDescription

}
where
     ClassType = '200'
  or ClassType = '300' //Only Variant Configuration relevant class types

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CLFNCLASS",
"I_CLFNCLASSDESCRIPTION"
],
"ASSOCIATED":
[
"I_CLFNCLASSDESCRIPTION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More