I_InspPlnMatlAssgmtVersion_2

DDL: I_INSPPLNMATLASSGMTVERSION_2 Type: view_entity BASIC Package: VDM_QM_PLANNING
24 Fields 1 Data Sources 5 Associations

Version of Material Assgmt in Insp Plan

I_InspPlnMatlAssgmtVersion_2 (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Manufacturing

I_InspPlnMatlAssgmtVersion_2 is a Basic CDS View that provides data about "Version of Material Assgmt in Insp Plan" in SAP S/4HANA. It reads from 1 data source (I_BOOMaterialAssgmtChangeState) and exposes 24 fields with key fields Material, Plant, InspectionPlanGroup, InspectionPlan, InspPlanMatlAssignment. It has 5 associations to related views. Part of development package VDM_QM_PLANNING.

SAP Help Documentation

CategoryCDS Views for Quality Planning
Purpose
This CDS view provides access to the assignment of materials in a plant to an inspection plan (task list type Q). The assigment can also be based on other attributes, for example, a combination of material and supplier and/or customer. This CDS view provides the data to answer the following business questions: Which inspection plans exist for a material in a plant? Which materials are assigned to an inspection plan? Which material-supplier or material-customer combinations are assigned to an inspection plan? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have one of the following business catalogs assigned: SAP_QM_BC_INSP_PLANNING_PC (QM - Inspection Planning) SAP_QM_BC_INSP_PLNG_DSP_PC (QM - Inspection Planning Display) SAP_A4C_BC_DEV_TST_QM_PLNG_PC (Development - API Test - QM - Quality Planning)

Structure
Fields Used for Filtering The main filters are as follows: Material : This field is used to filter for one or several materials. Plant : This field is used to filter for one or several plants. Further Important Fields Important fields in this view include the following: Field Name Description InspectionPlanGroup Key for Task List Group InspectionPlan Group Counter

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessManufacturing
Application ComponentQM-PT-2CL
CapabilitiesData Source in SQL Select,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageManufacturing for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides access to the assignment of materials in a plant to an inspection plan (task list type Q). The assigment can also be based on other attributes, for example, a combination of material and supplier and/or customer.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li> <p>Which inspection plans exist for a material in a plant?</p> </li> <li> <p>Which materials are assigned to an inspection plan?</p> </li> <li> <p>Which material-supplier or material-customer combinations are assigned to an inspection plan?</p> </li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_BOOMaterialAssgmtChangeState I_BOOMaterialAssgmtChangeState from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_BillOfOperationsType _BillOfOperationsType $projection.BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType
[1..1] I_BillOfOperationsGroup _BillOfOperationsGroup $projection.BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType and $projection.InspectionPlanGroup = _BillOfOperationsGroup.BillOfOperationsGroup
[1..1] I_InspectionPlanVersion _InspectionPlanVersion $projection.InspectionPlanGroup = _InspectionPlanVersion.InspectionPlanGroup and $projection.InspectionPlan = _InspectionPlanVersion.InspectionPlan and $projection.ValidityStartDate >= _InspectionPlanVersion.ValidityStartDate and $projection.ValidityStartDate <= _InspectionPlanVersion.ValidityEndDate
[0..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier
[0..1] I_Customer _Customer $projection.Customer = _Customer.Customer

Annotations (8)

NameValueLevelField
EndUserText.label Version of Material Assgmt in Insp Plan view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY Material I_BOOMaterialAssgmtChangeState Material Material Number
KEY Plant I_BOOMaterialAssgmtChangeState Plant Valuation Area
KEY InspectionPlanGroup I_BOOMaterialAssgmtChangeState BillOfOperationsGroup Key for Task List Group
KEY InspectionPlan I_BOOMaterialAssgmtChangeState BillOfOperationsVariant Group Counter
KEY InspPlanMatlAssignment I_BOOMaterialAssgmtChangeState BOOToMaterialInternalID Counter for Additional Criteria
KEY InspPlanMatlAssgmtIntVersion I_BOOMaterialAssgmtChangeState BOOMatlInternalVersionCounter Internal counter
BillOfOperationsType I_BOOMaterialAssgmtChangeState BillOfOperationsType Task List Type
ValidityStartDate I_BOOMaterialAssgmtChangeState ValidityStartDate Validity Start Date
ValidityEndDate I_BOOMaterialAssgmtChangeState ValidityEndDate Valid-to date
ChangeNumber I_BOOMaterialAssgmtChangeState ChangeNumber Change Number
CreationDate I_BOOMaterialAssgmtChangeState CreationDate Date Record Created On
CreatedByUser I_BOOMaterialAssgmtChangeState CreatedByUser Created By User
LastChangeDate I_BOOMaterialAssgmtChangeState LastChangeDate Last Changed On
LastChangedByUser I_BOOMaterialAssgmtChangeState LastChangedByUser Last Changed By User
IsDeleted I_BOOMaterialAssgmtChangeState IsDeleted Deletion Indicator
IsImplicitlyDeleted I_BOOMaterialAssgmtChangeState IsImplicitlyDeleted Deletion Indicator
Supplier I_BOOMaterialAssgmtChangeState Supplier Supplier's Account Number
Customer I_BOOMaterialAssgmtChangeState Customer Account number of customer
BOOSearchText I_BOOMaterialAssgmtChangeState BOOSearchText Search Field for Customer-Specific Task List Selection
_BillOfOperationsGroup _BillOfOperationsGroup
_BillOfOperationsType _BillOfOperationsType
_InspectionPlanVersion _InspectionPlanVersion
_Supplier _Supplier
_Customer _Customer

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_InspPlnMatlAssgmtVersion_2.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_InspPlnMatlAssgmtVersion_2 AS
SELECT
  I_BOOMaterialAssgmtChangeState.Material AS Material,
  I_BOOMaterialAssgmtChangeState.Plant AS Plant,
  I_BOOMaterialAssgmtChangeState.BillOfOperationsGroup AS InspectionPlanGroup,
  I_BOOMaterialAssgmtChangeState.BillOfOperationsVariant AS InspectionPlan,
  I_BOOMaterialAssgmtChangeState.BOOToMaterialInternalID AS InspPlanMatlAssignment,
  I_BOOMaterialAssgmtChangeState.BOOMatlInternalVersionCounter AS InspPlanMatlAssgmtIntVersion,
  I_BOOMaterialAssgmtChangeState.BillOfOperationsType AS BillOfOperationsType,
  I_BOOMaterialAssgmtChangeState.ValidityStartDate AS ValidityStartDate,
  I_BOOMaterialAssgmtChangeState.ValidityEndDate AS ValidityEndDate,
  I_BOOMaterialAssgmtChangeState.ChangeNumber AS ChangeNumber,
  I_BOOMaterialAssgmtChangeState.CreationDate AS CreationDate,
  I_BOOMaterialAssgmtChangeState.CreatedByUser AS CreatedByUser,
  I_BOOMaterialAssgmtChangeState.LastChangeDate AS LastChangeDate,
  I_BOOMaterialAssgmtChangeState.LastChangedByUser AS LastChangedByUser,
  I_BOOMaterialAssgmtChangeState.IsDeleted AS IsDeleted,
  I_BOOMaterialAssgmtChangeState.IsImplicitlyDeleted AS IsImplicitlyDeleted,
  I_BOOMaterialAssgmtChangeState.Supplier AS Supplier,
  I_BOOMaterialAssgmtChangeState.Customer AS Customer,
  I_BOOMaterialAssgmtChangeState.BOOSearchText AS BOOSearchText
FROM I_BOOMaterialAssgmtChangeState
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsType ON BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _BillOfOperationsGroup ON BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType AND InspectionPlanGroup = _BillOfOperationsGroup.BillOfOperationsGroup  -- association [1..1]
LEFT OUTER JOIN I_InspectionPlanVersion AS _InspectionPlanVersion ON InspectionPlanGroup = _InspectionPlanVersion.InspectionPlanGroup AND InspectionPlan = _InspectionPlanVersion.InspectionPlan AND ValidityStartDate >= _InspectionPlanVersion.ValidityStartDate AND ValidityStartDate <= _InspectionPlanVersion.ValidityEndDate  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
;

Learn More