I_DFS_MaintEquipFlxMtPlObjRIC

DDL: I_DFS_MAINTEQUIPFLXMTPLOBJRIC SQL: IEQUIPFMPORIC Type: view COMPOSITE

Interface view of equipment FMPO and RIC

I_DFS_MaintEquipFlxMtPlObjRIC is a Composite CDS View that provides data about "Interface view of equipment FMPO and RIC" in SAP S/4HANA. It has 2 associations to related views.

7 fields

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_FlxMtPlObjVariant _FlxMtPlObjVariant _FlxMtPlObjVariant.FlxblMatlPlngObjectUUID = FlxMtPlObj.FlxblMatlPlngObjectUUID
[1..1] I_FlxMtPlObjVarModel _FlxMtPlObjVarModel _FlxMtPlObjVarModel.FlxblMatlPlngObjectUUID = FlxMtPlObj.FlxblMatlPlngObjectUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IEQUIPFMPORIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Interface view of equipment FMPO and RIC view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY FlxblMatlPlngObjectUUID FlxMtPlObj FlxblMatlPlngObjectUUID
FlxMtPlObjRIC
FlxMtPlObjRICDescription
FlxblMatlPlngObjectID FlxMtPlObj FlxblMatlPlngObjectID
FlxblMatlPlngObjDescription FlxMtPlObj FlxblMatlPlngObjDescription
FlxMtPlObjVarStatusDescription
FlxMtPlObjVarModelProductID _FlxMtPlObjVarModel FlxMtPlObjVarModelProductID 
@AbapCatalog.sqlViewName: 'IEQUIPFMPORIC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK

@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE

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

@EndUserText.label: 'Interface view of equipment FMPO and RIC'
define view I_DFS_MaintEquipFlxMtPlObjRIC
  as select distinct from I_FlxMtPlObj as FlxMtPlObj
  association [1..1] to I_FlxMtPlObjVariant  as _FlxMtPlObjVariant  on _FlxMtPlObjVariant.FlxblMatlPlngObjectUUID = FlxMtPlObj.FlxblMatlPlngObjectUUID
  association [1..1] to I_FlxMtPlObjVarModel as _FlxMtPlObjVarModel on _FlxMtPlObjVarModel.FlxblMatlPlngObjectUUID = FlxMtPlObj.FlxblMatlPlngObjectUUID
{
  key    FlxMtPlObj.FlxblMatlPlngObjectUUID,
         FlxMtPlObj._FlxMtPlObjRIC.FlxMtPlObjRIC,
         FlxMtPlObj._FlxMtPlObjRIC.FlxMtPlObjRICDescription,
         FlxMtPlObj.FlxblMatlPlngObjectID,
         FlxMtPlObj.FlxblMatlPlngObjDescription,
         _FlxMtPlObjVariant._StatusAttributes._SystemStatusText[1:Language = $session.system_language].SystemStatusName as FlxMtPlObjVarStatusDescription,
         _FlxMtPlObjVarModel.FlxMtPlObjVarModelProductID

}
where
  //Note-3086087

  //  _FlxMtPlObjVariant._StatusAttributes._SystemStatusText [1:Language = $session.system_language].SystemStatusName = 'Active'

  _FlxMtPlObjVariant._StatusAttributes.SystemStatus = 'IDFS4'
//Note-3086087

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DFS_STATUSATTRIBUTES",
"I_FLXMTPLOBJ",
"I_FLXMTPLOBJRIC",
"I_FLXMTPLOBJVARIANT",
"I_FLXMTPLOBJVARMODEL",
"I_SYSTEMSTATUSTEXT"
],
"ASSOCIATED":
[
"I_FLXMTPLOBJVARIANT",
"I_FLXMTPLOBJVARMODEL"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More