I_ManufacturingFeatureStatus

DDL: I_MANUFACTURINGFEATURESTATUS SQL: IMPEFEATURESTS Type: view BASIC

Manufacturing Feature Status

I_ManufacturingFeatureStatus is a Basic CDS View that provides data about "Manufacturing Feature Status" in SAP S/4HANA. It reads from 3 data sources (I_ManufacturingFeature, mpe_featuractiv, I_Plant) and exposes 4 fields with key fields Plant, ManufacturingFeature. It has 2 associations to related views.

3 data source(s) 4 fields

Data Sources (3)

SourceAliasJoin Type
I_ManufacturingFeature f cross
mpe_featuractiv fa left_outer
I_Plant p from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_Plant _Plant $projection.Plant = _Plant.Plant
[1..1] I_ManufacturingFeature _ManufacturingFeature $projection.ManufacturingFeature = _ManufacturingFeature.ManufacturingFeature

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IMPEFEATURESTS view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Manufacturing Feature Status view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY Plant I_Plant Plant
KEY ManufacturingFeature I_ManufacturingFeature ManufacturingFeature
_Plant _Plant
_ManufacturingFeature _ManufacturingFeature 
@AbapCatalog.sqlViewName: 'IMPEFEATURESTS'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #S, dataClass: #MIXED}
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Manufacturing Feature Status'
define view I_ManufacturingFeatureStatus
  as select from    I_Plant                as p
    cross join      I_ManufacturingFeature as f
    left outer join mpe_featuractiv        as fa on  fa.feature = f.ManufacturingFeature
                                                 and fa.werks   = p.Plant
  association [1..1] to I_Plant                as _Plant                on $projection.Plant = _Plant.Plant
  association [1..1] to I_ManufacturingFeature as _ManufacturingFeature on $projection.ManufacturingFeature = _ManufacturingFeature.ManufacturingFeature
{
  key p.Plant,
  key f.ManufacturingFeature,
      case fa.feature                          
      when f.ManufacturingFeature then 'X' else '' end as ManufacturingFeatureIsActive,
      case _ManufacturingFeature.ManufacturingFeatureIsActive
      when f.ManufacturingFeature then 'X' else '' end as MfgFeatureIsActiveInAnyPlant,
      _Plant,
      _ManufacturingFeature
} // group by p.Plant, fa.feature, fa2.feature, ManufacturingFeature

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

Learn More