I_DocumentProdnRsceTool

DDL: I_DOCUMENTPRODNRSCETOOL SQL: IPPDOCUMENTPRT Type: view BASIC
19 Fields 1 Data Sources

Document Production Resource Tool

I_DocumentProdnRsceTool (Basic)

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

Manufacturing

I_DocumentProdnRsceTool is a Basic CDS View (Dimension) that provides data about "Document Production Resource Tool" in SAP S/4HANA. It reads from 1 data source (I_DocumentPRTByInternalKey) and exposes 19 fields with key fields DocumentType, DocumentInfoRecord, DocumentVersion.

SAP Help Documentation

CategoryCDS Views for Basic Production Resource / Tools Data
Data CategoryDimension
StatusReleased
Purpose
With this CDS view you can retrieve document data for a production resource or a production tool. This CDS view provides the prerequisites for answering the following business questions: Which documents exist as production resource or production tool? Which are the administrative data of a document for a production resource or tool?

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 C_DRAW_BGR and C_DRAW_TCD and C_DRAW_TCS is required.

Structure
Measures and attributes Some important measures and attributes are: Document type Document number Document version Document part Date of creation and last change User that created or changed the record Authorization group

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessManufacturing
Application ComponentPP-VDM-MD
CapabilitiesAnalytical Dimension, Data Source for Defining CDS Entities, Data Source in SQL Select
PackageManufacturing for SAP S/4HANA Cloud Private Edition
Description <p>With this CDS view you can retrieve document data for a production resource or a production tool. </p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>Which documents exist as production resource or production tool?</p></li> <li><p>Which are the administrative data of a document for a production resource or tool?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_DocumentPRTByInternalKey PRT from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IPPDOCUMENTPRT 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 DocumentPart view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view
EndUserText.label Document Production Resource Tool view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY DocumentType I_DocumentPRTByInternalKey DocumentType Document Type
KEY DocumentInfoRecord I_DocumentPRTByInternalKey DocumentInfoRecord Document number
KEY DocumentVersion I_DocumentPRTByInternalKey DocumentVersion Document Version
DocumentPartasDocumentPart
ProductionResourceType I_DocumentPRTByInternalKey ProductionResourceType Production Resource Type
ProductionResourceInternalID I_DocumentPRTByInternalKey ProductionResourceInternalID Internal ID of Production Resource/Tool
AuthorizationGroup AuthorizationGroup Authorization Group
InternalDocumentStatus InternalDocumentStatus Document Status
CreationDate CreationDate Date Record Created On
CreatedByUser CreatedByUser Created By User
LastChangeDate LastChangeDate Last Changed On
LastChangedByUser LastChangedByUser Name of Person Who Changed Object
_DocumentType _DocumentType
_DocumentNumber _DocumentNumber
_DocumentVersion _DocumentVersion
_DocumentInfoRecord _DocumentInfoRecord
_ProductionResourceType _ProductionResourceType
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser

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_DocumentProdnRsceTool.
-- 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: IPPDOCUMENTPRT

CREATE VIEW I_DocumentProdnRsceTool AS
SELECT
  PRT.DocumentType AS DocumentType,
  PRT.DocumentInfoRecord AS DocumentInfoRecord,
  PRT.DocumentVersion AS DocumentVersion,
  PRT.ProductionResourceType AS ProductionResourceType,
  PRT.ProductionResourceInternalID AS ProductionResourceInternalID,
  AuthorizationGroup,
  InternalDocumentStatus,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser
FROM I_DocumentPRTByInternalKey AS PRT
;

Learn More