I_InspPlnMatlAssignment

DDL: I_INSPPLNMATLASSIGNMENT SQL: IINSPPLMASSG Type: view BASIC

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.

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 (10)

NameValueLevelField
AbapCatalog.sqlViewName IINSPPLMASSG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Material-Plan Assignment view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE 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 
@AbapCatalog.sqlViewName: 'IINSPPLMASSG'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Material-Plan Assignment'
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: { serviceQuality: #B, sizeCategory: #M, dataClass: #MASTER }
define view 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'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BOOMATERIALASSIGNMENT"
],
"ASSOCIATED":
[
"I_BILLOFOPERATIONSGROUP",
"I_INSPECTIONPLAN",
"I_MATERIAL",
"I_PLANT"
],
"BASE":
[
"I_BOOMATERIALASSIGNMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More