C_InspPlanMatlAssgmt

DDL: C_INSPPLANMATLASSGMT Type: view_entity CONSUMPTION Package: ODATA_QM_INSP_PLAN
34 Fields 1 Data Sources 5 Associations

Insp Plan Version-Material Assignment

C_InspPlanMatlAssgmt is a Consumption CDS View that provides data about "Insp Plan Version-Material Assignment" in SAP S/4HANA. It reads from 1 data source (I_InspPlanMaterialAssgmtTP) and exposes 34 fields with key fields InspectionPlanGroup, InspectionPlan, InspectionPlanInternalVersion, Material, Plant. It has 5 associations to related views. Part of development package ODATA_QM_INSP_PLAN.

Data Sources (1)

SourceAliasJoin Type
I_InspPlanMaterialAssgmtTP _InspPlanMatlAssgmt from

Associations (5)

CardinalityTargetAliasCondition
[1..1] C_InspectionPlan _InspPlan $projection.InspectionPlanGroup = _InspPlan.InspectionPlanGroup and $projection.InspectionPlan = _InspPlan.InspectionPlan and $projection.InspectionPlanInternalVersion = _InspPlan.InspectionPlanInternalVersion and $projection.BillOfOperationsType = _InspPlan.BillOfOperationsType
[1..1] I_MaterialStdVH _Product $projection.Material = _Product.Material
[1..1] I_MaterialStdVH _ProductForEdit $projection.MaterialForEdit = _ProductForEdit.Material
[0..1] I_Supplier_VH _Supplier $projection.Supplier = _Supplier.Supplier
[0..1] I_Customer_VH _Customer $projection.Customer = _Customer.Customer

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Insp Plan Version-Material Assignment view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.personalData.blocking #REQUIRED view
Search.searchable true view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY InspectionPlanGroup InspectionPlanGroup
KEY InspectionPlan InspectionPlan
KEY InspectionPlanInternalVersion InspectionPlanInternalVersion
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
KEY InspPlanMatlAssignment InspPlanMatlAssignment
KEY InspPlanMatlAssgmtIntVersion InspPlanMatlAssgmtIntVersion
KEY BillOfOperationsType BillOfOperationsType Task List Type
MaterialForEdit MaterialForEdit Product
PlantForEdit PlantForEdit Plant ID
BillOfOperationsDesc BillOfOperationsDesc
IsValid IsValid Truth Value
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
ChangeNumber ChangeNumber Change Number
CreationDate CreationDate Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangedByUser LastChangedByUser User Name
IsDeleted IsDeleted TRUE
MaterialName
Supplier Supplier Supplier
SupplierName _Supplier SupplierName Supplier Name
Customer Customer Sold-to Party
CustomerName _Customer CustomerName Name of Customer
BOOSearchText BOOSearchText
_Customer _Customer
_InspectionPlan _InspectionPlan
_InspectionPlanVersion _InspectionPlanVersion
_InspPlnMatlAssignment _InspPlnMatlAssignment
_Product _Product
_ProductForEdit _ProductForEdit
_Supplier _Supplier
_InspPlan _InspPlan

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 C_InspPlanMatlAssgmt.
-- 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 C_InspPlanMatlAssgmt AS
SELECT
  InspectionPlanGroup,
  InspectionPlan,
  InspectionPlanInternalVersion,
  Material,
  Plant,
  InspPlanMatlAssignment,
  InspPlanMatlAssgmtIntVersion,
  BillOfOperationsType,
  MaterialForEdit,
  PlantForEdit,
  BillOfOperationsDesc,
  IsValid,
  ValidityStartDate,
  ValidityEndDate,
  ChangeNumber,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  IsDeleted,
  _Material._Text[1:Language=$session.system_language].MaterialName AS MaterialName,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  Customer,
  _Customer.CustomerName AS CustomerName,
  BOOSearchText
FROM I_InspPlanMaterialAssgmtTP AS _InspPlanMatlAssgmt
LEFT OUTER JOIN C_InspectionPlan AS _InspPlan ON InspectionPlanGroup = _InspPlan.InspectionPlanGroup AND InspectionPlan = _InspPlan.InspectionPlan AND InspectionPlanInternalVersion = _InspPlan.InspectionPlanInternalVersion AND BillOfOperationsType = _InspPlan.BillOfOperationsType  -- association [1..1]
LEFT OUTER JOIN I_MaterialStdVH AS _Product ON Material = _Product.Material  -- association [1..1]
LEFT OUTER JOIN I_MaterialStdVH AS _ProductForEdit ON MaterialForEdit = _ProductForEdit.Material  -- association [1..1]
LEFT OUTER JOIN I_Supplier_VH AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer_VH AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
;

Learn More