R_FuncnlLocClfnClassTP

DDL: R_FUNCNLLOCCLFNCLASSTP Type: view_entity TRANSACTIONAL

Functional Location Class

R_FuncnlLocClfnClassTP is a Transactional CDS View that provides data about "Functional Location Class" in SAP S/4HANA. It reads from 1 data source (I_ClfnObjectClassForKeyDate) and exposes 16 fields with key fields FunctionalLocation, ClassInternalID, ClassType. It has 1 association to related views.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_ClfnObjectClassForKeyDate I_ClfnObjectClassForKeyDate from

Associations (1)

CardinalityTargetAliasCondition
[0..*] R_FuncnlLocClfnClassCharTP _Characteristic

Annotations (8)

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

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY FunctionalLocation ClfnObjectID
KEY ClassInternalID ClassInternalID
KEY ClassType ClassType
FunctionalLocationLabelName _FunctionalLocation FunctionalLocationLabelName
KeyDate
ChangeNumber ChangeNumber
Class
ClfnStatus ClfnStatus
ClassPositionNumber ClassPositionNumber
ClassIsStandardClass
ClfnObjectInternalID ClfnObjectInternalID
ValidityEndDate Classification ValidityEndDate
ClassMaintAuthGrp
ClassClassfctnAuthGrp
_Characteristic _Characteristic
_FunctionalLocation _FunctionalLocation 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Functional Location Class'

@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED

define view entity R_FuncnlLocClfnClassTP

  as select from I_ClfnObjectClassForKeyDate(P_KeyDate: $session.system_date ) as Classification
  association to parent R_FunctionalLocationTP     as _FunctionalLocation on $projection.FunctionalLocation = _FunctionalLocation.FunctionalLocation
  composition [0..*] of R_FuncnlLocClfnClassCharTP as _Characteristic

{
  key  ClfnObjectID         as FunctionalLocation,
  key  ClassInternalID ,
  key  ClassType,
       _FunctionalLocation.FunctionalLocationLabelName,
       $session.system_date as KeyDate,
       ChangeNumber,
       Classification._Class( P_KeyDate:$session.system_date).Class,
       ClfnStatus,
       ClassPositionNumber,
       cast ( ClassIsStandardClass as stdclass ) as ClassIsStandardClass, //2308 CE - Adapt XFELD from CA Team

       ClfnObjectInternalID,
       Classification.ValidityEndDate,
       @Consumption.hidden: true
       Classification._Class( P_KeyDate:$session.system_date ).ClassMaintAuthGrp,
       @Consumption.hidden: true
       Classification._Class( P_KeyDate:$session.system_date ).ClassClassfctnAuthGrp,
       _Characteristic,
       _FunctionalLocation
}
where
  ClfnObjectTable = 'IFLOT'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CLFNCLASSFORKEYDATE",
"I_CLFNOBJECTCLASSFORKEYDATE",
"R_FUNCTIONALLOCATIONTP"
],
"ASSOCIATED":
[
"R_FUNCNLLOCCLFNCLASSCHARTP",
"R_FUNCTIONALLOCATIONTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More