I_InspPlnMatlAssignment

DDL: I_INSPPLNMATLASSIGNMENT Type: view_entity BASIC Package: VDM_QM_PLANNING

Material-Plan Assignment

I_InspPlnMatlAssignment is a Basic CDS View that provides data about "Material-Plan Assignment" in SAP S/4HANA. It has 2 associations to related views. Part of development package VDM_QM_PLANNING.

10 fields

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_InspectionPlan _InspectionPlan $projection.InspectionPlanGroup = _InspectionPlan.InspectionPlanGroup and $projection.InspectionPlan = _InspectionPlan.InspectionPlan
[1..1] I_BillOfOperationsGroup _BillOfOperationsGroup $projection.BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType and $projection.InspectionPlanGroup = _BillOfOperationsGroup.BillOfOperationsGroup

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Material-Plan Assignment view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Material Material
KEY Plant Plant
KEY InspectionPlanGroup BillOfOperationsGroup
KEY InspectionPlan BillOfOperationsVariant
KEY InspPlanMatlAssignment BOOToMaterialInternalID
BillOfOperationsType BillOfOperationsType
_InspectionPlan _InspectionPlan
_BillOfOperationsGroup _BillOfOperationsGroup
_Material _Material
_Plant _Plant 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Material-Plan Assignment'
@VDM.viewType: #BASIC
@ObjectModel.usageType: { serviceQuality: #B, sizeCategory: #M, dataClass: #MASTER }
define view entity I_InspPlnMatlAssignment
  as select distinct from I_BOOMaterialAssignment
  association [1..1] to I_InspectionPlan        as _InspectionPlan        on  $projection.InspectionPlanGroup = _InspectionPlan.InspectionPlanGroup
                                                                          and $projection.InspectionPlan      = _InspectionPlan.InspectionPlan
  association [1..1] to I_BillOfOperationsGroup as _BillOfOperationsGroup on  $projection.BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType
                                                                          and $projection.InspectionPlanGroup  = _BillOfOperationsGroup.BillOfOperationsGroup
{
  key Material,
  key Plant,
      @ObjectModel.foreignKey.association: '_BillOfOperationsGroup'
  key BillOfOperationsGroup   as InspectionPlanGroup,
      @ObjectModel.foreignKey.association: '_InspectionPlan'
  key BillOfOperationsVariant as InspectionPlan,
  key BOOToMaterialInternalID as InspPlanMatlAssignment,
      BillOfOperationsType,
      
      //Associations

      _InspectionPlan,
      _BillOfOperationsGroup,
      _Material,
      _Plant
}
where
  BillOfOperationsType = 'Q'

Learn More