I_MaterialProdnRsceTool

DDL: I_MATERIALPRODNRSCETOOL SQL: IPPMATERIALPRT Type: view BASIC Package: VDM_PP_MD_PRT
51 Fields 1 Data Sources

Material Production Resource Tool

I_MaterialProdnRsceTool (Basic)

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

Manufacturing

I_MaterialProdnRsceTool is a Basic CDS View (Dimension) that provides data about "Material Production Resource Tool" in SAP S/4HANA. It reads from 1 data source (I_MaterialPRTByInternalKey) and exposes 51 fields with key field Plant. Part of development package VDM_PP_MD_PRT.

SAP Help Documentation

CategoryCDS Views for Basic Production Resource / Tools Data
Data CategoryDimension
StatusReleased
Purpose
With this CDS view you can retrieve material data for production resources or tools. This CDS view provides the prerequisites for answering the following business questions: Which materials in a plant are maintained as production resources or tools? Which control profile is assigned to a production resource material or production tool material? Which calculation formulas are assigned to a production resource material or production tool material? Which are the administrative data of a production resource material or production tool material?

Prerequisites
Users who want to run reports using this CDS view must have the authorization to display the following data: Read access for authorization groups M_MATE_MAN and M_MATE_WRK is required. These restriction types are edited in the Maintain Business Roles app.

Structure
Measures and attributes Some important measures and attributes are: Material Plant Internal ID for production resource/ tool Production resource/ tool usage Control profile for production resource/ tool Calculation formulas Offset duration and unit Date of creation and last change User that created or changed the record

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessManufacturing
Application ComponentPP-VDM-MD-2CL
CapabilitiesAnalytical Dimension,Data Source for Defining CDS Entities,Data Source in SQL Select,Data Source for Search
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>With this CDS view you can retrieve material data for production resources or tools.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li> <p>Which materials in a plant are maintained as production resources or tools?</p> </li> <li> <p>Which control profile is assigned to a production resource material or production tool material?</p> <p>Which calculation formulas are assigned to a production resource material or production tool material?</p> <p>Which are the administrative data of a production resource material or production tool material?</p> </li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_MaterialPRTByInternalKey PRT from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IPPMATERIALPRT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
Analytics.dataCategory #DIMENSION view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey Material view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view
EndUserText.label Material Production Resource Tool view

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY Plant I_MaterialPRTByInternalKey Plant Valuation Area
Material Material Number
Product I_MaterialPRTByInternalKey Product Material Number
ProductionResourceType I_MaterialPRTByInternalKey ProductionResourceType Production Resource Type
ProductionResourceInternalID I_MaterialPRTByInternalKey ProductionResourceInternalID Internal ID of Production Resource/Tool
ProductionResourceToolGroup1 I_MaterialPRTByInternalKey ProductionResourceToolGroup1 Grouping Key 1 for Production Resources/Tools
ProductionResourceToolGroup2 I_MaterialPRTByInternalKey ProductionResourceToolGroup2 Grouping Key 2 for Production Resources/Tools
ProductionResourceUsage I_MaterialPRTByInternalKey ProductionResourceUsage Production Resource/Tool Usage
ProdnRsceToolControlProfile ProdnRsceToolControlProfile Control Profile for Management of Production Resources/Tools
ChangeNumber I_MaterialPRTByInternalKey ChangeNumber Change Number
ProdnRsceToolStandardTextCode ProdnRsceToolStandardTextCode Standard Text Key for Production Resources/Tools
ProdnRsceToolTotQtyCalcFormula ProdnRsceToolTotQtyCalcFormula Formula for Calculating the Total Quantity of PRT
ProdnRsceToolUsageQtyCalcFmla ProdnRsceToolUsageQtyCalcFmla Formula for Calculating the Total Usage Value of PRT
StartDateOffsetReferenceCode StartDateOffsetReferenceCode Reference Date for Start of PRT Usage
EndDateOffsetReferenceCode EndDateOffsetReferenceCode Reference Date for End of PRT Usage
EndDateOffsetDurnIsReferenced EndDateOffsetDurnIsReferenced Offset to End of PRT Usage is Referenced
StartDateOffstDurnIsReferenced StartDateOffstDurnIsReferenced Offset to Start of PRT Usage is Referenced
EndDteOffstRefCodeIsReferenced EndDteOffstRefCodeIsReferenced Reference Date for End of PRT Usage is Referenced
StartDateOffsetRefCodeIsRefcd StartDateOffsetRefCodeIsRefcd Reference Date for Start of PRT Usage is Referenced
PRTTotQtyCalcFmlaIsReferenced PRTTotQtyCalcFmlaIsReferenced Formula for Calculating the Total PRT Quantity is Referenced
PRTUsgeQtyCalcFmlaIsReferenced PRTUsgeQtyCalcFmlaIsReferenced Formula for Calculating Total PRT Usage Value is Referenced
PRTControlProfileIsReferenced PRTControlProfileIsReferenced Control Profile for Management of PRT is Referenced
PRTStdTextCodeIsReferenced PRTStdTextCodeIsReferenced Standard Text Key for PRT is Referenced
StartDateOffsetDuration StartDateOffsetDuration Offset to Start of PRT Usage
StartDateOffsetDurationUnit StartDateOffsetDurationUnit Offset Unit for Start of Prodn Resource/Tool Usage
EndDateOffsetDuration EndDateOffsetDuration Offset to End of PRT Usage
EndDateOffsetDurationUnit EndDateOffsetDurationUnit Offset Unit for End of Production Resource/Tool Usage
CreationDate CreationDate Date Record Created On
CreatedByUser CreatedByUser Created By User
LastChangeDate LastChangeDate Last Changed On
LastChangedByUser LastChangedByUser Name of Person Who Changed Object
_ProductionResourceType _ProductionResourceType
_Material _Material
_Plant _Plant
_Product _Product
_ProductPlant _ProductPlant
_ProductPlant2 _ProductPlant2
_ProdnRsceToolGroup1 _ProdnRsceToolGroup1
_ProdnRsceToolGroup2 _ProdnRsceToolGroup2
_ProductionResourceUsage _ProductionResourceUsage
_ProdnRsceToolControlProfile _ProdnRsceToolControlProfile
_ProdnRsceToolStandardText _ProdnRsceToolStandardText
_ProdnRsceToolTotQtyCalcFmla _ProdnRsceToolTotQtyCalcFmla
_ProdnRsceToolUsageQtyCalcFmla _ProdnRsceToolUsageQtyCalcFmla
_StartDateOffsetReferenceCode _StartDateOffsetReferenceCode
_EndDateOffsetReferenceCode _EndDateOffsetReferenceCode
_StartDateOffsetDurationUnit _StartDateOffsetDurationUnit
_EndDateOffsetDurationUnit _EndDateOffsetDurationUnit
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_ChangeMaster _ChangeMaster

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_MaterialProdnRsceTool.
-- 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: IPPMATERIALPRT

CREATE VIEW I_MaterialProdnRsceTool AS
SELECT
  PRT.Plant AS Plant,
  PRT.Product AS Product,
  PRT.ProductionResourceType AS ProductionResourceType,
  PRT.ProductionResourceInternalID AS ProductionResourceInternalID,
  PRT.ProductionResourceToolGroup1 AS ProductionResourceToolGroup1,
  PRT.ProductionResourceToolGroup2 AS ProductionResourceToolGroup2,
  PRT.ProductionResourceUsage AS ProductionResourceUsage,
  ProdnRsceToolControlProfile,
  PRT.ChangeNumber AS ChangeNumber,
  ProdnRsceToolStandardTextCode,
  ProdnRsceToolTotQtyCalcFormula,
  ProdnRsceToolUsageQtyCalcFmla,
  StartDateOffsetReferenceCode,
  EndDateOffsetReferenceCode,
  EndDateOffsetDurnIsReferenced,
  StartDateOffstDurnIsReferenced,
  EndDteOffstRefCodeIsReferenced,
  StartDateOffsetRefCodeIsRefcd,
  PRTTotQtyCalcFmlaIsReferenced,
  PRTUsgeQtyCalcFmlaIsReferenced,
  PRTControlProfileIsReferenced,
  PRTStdTextCodeIsReferenced,
  StartDateOffsetDuration,
  StartDateOffsetDurationUnit,
  EndDateOffsetDuration,
  EndDateOffsetDurationUnit,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser
FROM I_MaterialPRTByInternalKey AS PRT
;

Learn More