R_EquipmentClfnClassTP

DDL: R_EQUIPMENTCLFNCLASSTP Type: view_entity TRANSACTIONAL

Equipment Class

R_EquipmentClfnClassTP is a Transactional CDS View that provides data about "Equipment Class" in SAP S/4HANA. It reads from 2 data sources (I_ClfnObjectClassForKeyDate, I_Equipment) and exposes 16 fields with key fields Equipment, ClassInternalID, ClassType. It has 1 association to related views.

2 data source(s) 16 fields

Data Sources (2)

SourceAliasJoin Type
I_ClfnObjectClassForKeyDate I_ClfnObjectClassForKeyDate from
I_Equipment I_Equipment inner

Associations (1)

CardinalityTargetAliasCondition
[0..*] R_EquipmentClfnClassCharTP _Characteristic

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Equipment Class view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY Equipment I_Equipment Equipment
KEY ClassInternalID Classification ClassInternalID
KEY ClassType Classification ClassType
KeyDate
ChangeNumber Classification ChangeNumber
ClfnStatus Classification ClfnStatus
ClassPositionNumber Classification ClassPositionNumber
ClassIsStandardClass Classification ClassIsStandardClass
ClfnObjectInternalID Classification ClfnObjectInternalID
ValidityEndDate Classification ValidityEndDate
EquipmentValidityEndDate I_Equipment ValidityEndDate
ClassMaintAuthGrp
ClassClassfctnAuthGrp
Class
_Characteristic _Characteristic
_Equipment _Equipment 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Equipment Class'

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED

define view entity R_EquipmentClfnClassTP 
  as select from I_ClfnObjectClassForKeyDate(P_KeyDate: $session.system_date ) as Classification
      inner join I_Equipment on I_Equipment.Equipment = Classification.ClfnObjectID 
      
      association to parent R_EquipmentTP as _Equipment on $projection.Equipment = _Equipment.Equipment  
                                                      and $projection.EquipmentValidityEndDate = _Equipment.ValidityEndDate 
                                                      
                                                                                                     
      composition [0..*] of R_EquipmentClfnClassCharTP as _Characteristic 
{
    key I_Equipment.Equipment as Equipment,  
    key Classification.ClassInternalID,
    key Classification.ClassType,
    $session.system_date as KeyDate,
    Classification.ChangeNumber,
    Classification.ClfnStatus,
    Classification.ClassPositionNumber,
    @Semantics.booleanIndicator: true
    Classification.ClassIsStandardClass,
    Classification.ClfnObjectInternalID,
    Classification.ValidityEndDate,
    @Consumption.hidden: true 
    I_Equipment.ValidityEndDate as EquipmentValidityEndDate,
    @Consumption.hidden: true 
    Classification._Class( P_KeyDate:$session.system_date ).ClassMaintAuthGrp,
    @Consumption.hidden: true 
    Classification._Class( P_KeyDate:$session.system_date ).ClassClassfctnAuthGrp,
    Classification._Class( P_KeyDate:$session.system_date ).Class,
    _Characteristic,
   _Equipment     
    
}where
      Classification.ClfnObjectTable = 'EQUI'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CLFNCLASSFORKEYDATE",
"I_CLFNOBJECTCLASSFORKEYDATE",
"I_EQUIPMENT"
],
"ASSOCIATED":
[
"R_EQUIPMENTCLFNCLASSCHARTP",
"R_EQUIPMENTTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More