I_InspPlanMaterialAssgmtTP

DDL: I_INSPPLANMATERIALASSGMTTP SQL: IIPMATLTP Type: view TRANSACTIONAL
30 Fields 1 Data Sources 1 Associations

Insp Plan Version-Material Assignment

I_InspPlanMaterialAssgmtTP is a Transactional CDS View that provides data about "Insp Plan Version-Material Assignment" in SAP S/4HANA. It reads from 1 data source (I_InspPlnMatlAssgmtVersion) and exposes 30 fields with key fields InspectionPlanGroup, InspectionPlan, InspectionPlanInternalVersion, Material, Plant. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_InspPlnMatlAssgmtVersion _InspPlanMatlAssgmt from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_InspectionPlanTP _InspPlan $projection.InspectionPlanGroup = _InspPlan.InspectionPlanGroup and $projection.InspectionPlan = _InspPlan.InspectionPlan and $projection.InspectionPlanInternalVersion = _InspPlan.InspectionPlanInternalVersion and $projection.billofoperationstype = _InspPlan.BillOfOperationsType

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IIPMATLTP view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Insp Plan Version-Material Assignment view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeDraftPersistence QIPMATL_D view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY InspectionPlanGroup InspectionPlanGroup Group
KEY InspectionPlan InspectionPlan Group Counter
KEY InspectionPlanInternalVersion
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
KEY InspPlanMatlAssignment InspPlanMatlAssignment
KEY InspPlanMatlAssgmtIntVersion InspPlanMatlAssgmtIntVersion
KEY BillOfOperationsType
MaterialForEdit Material Vehicle Model
PlantForEdit Plant Valuation Area
BillOfOperationsDesc
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
ChangeNumber I_InspPlnMatlAssgmtVersion ChangeNumber Change Number
CreationDate I_InspPlnMatlAssgmtVersion CreationDate Time Stamp
CreatedByUser I_InspPlnMatlAssgmtVersion CreatedByUser User Name
LastChangeDate I_InspPlnMatlAssgmtVersion LastChangeDate Time Stamp
LastChangedByUser I_InspPlnMatlAssgmtVersion LastChangedByUser User Name
IsDeleted I_InspPlnMatlAssgmtVersion IsDeleted TRUE
Supplier I_InspPlnMatlAssgmtVersion Supplier Supplier
Customer I_InspPlnMatlAssgmtVersion Customer Sold-to Party
BOOSearchText I_InspPlnMatlAssgmtVersion BOOSearchText
IsValid
_Customer I_InspPlnMatlAssgmtVersion _Customer
_InspectionPlan I_InspPlnMatlAssgmtVersion _InspectionPlan
_InspectionPlanVersion I_InspPlnMatlAssgmtVersion _InspectionPlanVersion
_InspPlnMatlAssignment I_InspPlnMatlAssgmtVersion _InspPlnMatlAssignment
_Material I_InspPlnMatlAssgmtVersion _Material
_Supplier I_InspPlnMatlAssgmtVersion _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 I_InspPlanMaterialAssgmtTP.
-- 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.
-- SQL view name: IIPMATLTP

CREATE VIEW I_InspPlanMaterialAssgmtTP AS
SELECT
  InspectionPlanGroup,
  InspectionPlan,
  _InspPlanMatlAssgmt._InspectionPlanVersion.InspectionPlanInternalVersion AS InspectionPlanInternalVersion,
  Material,
  Plant,
  InspPlanMatlAssignment,
  InspPlanMatlAssgmtIntVersion,
  _InspPlanMatlAssgmt._InspectionPlanVersion.BillOfOperationsType AS BillOfOperationsType,
  Material AS MaterialForEdit,
  Plant AS PlantForEdit,
  _InspPlanMatlAssgmt._InspectionPlanVersion.BillOfOperationsDesc AS BillOfOperationsDesc,
  ValidityStartDate,
  ValidityEndDate,
  _InspPlanMatlAssgmt.ChangeNumber AS ChangeNumber,
  _InspPlanMatlAssgmt.CreationDate AS CreationDate,
  _InspPlanMatlAssgmt.CreatedByUser AS CreatedByUser,
  _InspPlanMatlAssgmt.LastChangeDate AS LastChangeDate,
  _InspPlanMatlAssgmt.LastChangedByUser AS LastChangedByUser,
  _InspPlanMatlAssgmt.IsDeleted AS IsDeleted,
  _InspPlanMatlAssgmt.Supplier AS Supplier,
  _InspPlanMatlAssgmt.Customer AS Customer,
  _InspPlanMatlAssgmt.BOOSearchText AS BOOSearchText,
  cast('X' as abap.char( 1 )) AS IsValid,
  _InspPlanMatlAssgmt._Customer AS _Customer,
  _InspPlanMatlAssgmt._InspectionPlan AS _InspectionPlan,
  _InspPlanMatlAssgmt._InspectionPlanVersion AS _InspectionPlanVersion,
  _InspPlanMatlAssgmt._InspPlnMatlAssignment AS _InspPlnMatlAssignment,
  _InspPlanMatlAssgmt._Material AS _Material,
  _InspPlanMatlAssgmt._Supplier AS _Supplier
FROM I_InspPlnMatlAssgmtVersion AS _InspPlanMatlAssgmt
LEFT OUTER JOIN I_InspectionPlanTP AS _InspPlan ON InspectionPlanGroup = _InspPlan.InspectionPlanGroup AND InspectionPlan = _InspPlan.InspectionPlan AND InspectionPlanInternalVersion = _InspPlan.InspectionPlanInternalVersion AND billofoperationstype = _InspPlan.BillOfOperationsType  -- association [1..1]
;

Learn More