I_MfgWorkInstructionPRTDocLink

DDL: I_MFGWORKINSTRUCTIONPRTDOCLINK SQL: IMFGWORKINSDOC Type: view BASIC
21 Fields 3 Data Sources

Documents linked to a PRT assigned to OA

I_MfgWorkInstructionPRTDocLink is a Basic CDS View that provides data about "Documents linked to a PRT assigned to OA" in SAP S/4HANA. It reads from 3 data sources (I_OpActyBOOProdnRsceToolAssgmt, I_BOOOperationPRTChangeState, I_DocumentPRTByInternalKey) and exposes 21 fields with key fields OperationActivity, OperationActyVersionCounter, BillOfOperationsType, BillOfOperationsGroup, BOOOperationPRTInternalID.

Data Sources (3)

SourceAliasJoin Type
I_OpActyBOOProdnRsceToolAssgmt PRT from
I_BOOOperationPRTChangeState PRTChangeState inner
I_DocumentPRTByInternalKey PRTDocInternalKey inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMFGWORKINSDOC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Documents linked to a PRT assigned to OA view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY OperationActivity I_OpActyBOOProdnRsceToolAssgmt OperationActivity Operation Activity
KEY OperationActyVersionCounter I_OpActyBOOProdnRsceToolAssgmt OperationActyVersionCounter OA Version
KEY BillOfOperationsType I_OpActyBOOProdnRsceToolAssgmt BillOfOperationsType Task List Type
KEY BillOfOperationsGroup I_OpActyBOOProdnRsceToolAssgmt BillOfOperationsGroup Group
KEY BOOOperationPRTInternalID I_OpActyBOOProdnRsceToolAssgmt BOOOperationPRTInternalID Test equipment
KEY BOOOperationPRTIntVersCounter I_BOOOperationPRTChangeState BOOOperationPRTIntVersCounter
ProductionResourceType I_DocumentPRTByInternalKey ProductionResourceType Object Type
DocumentType I_DocumentPRTByInternalKey DocumentType Order Type
DocumentInfoRecord I_DocumentPRTByInternalKey DocumentInfoRecord Document
DocumentVersion I_DocumentPRTByInternalKey DocumentVersion Docu. Version
DocumentPart I_DocumentPRTByInternalKey DocumentPart Document Part
DocumentInfoRecordDocNumber I_DocumentPRTByInternalKey DocumentInfoRecord Document
_OperationActivityInternalId
_OperationActivity I_OpActyBOOProdnRsceToolAssgmt _OperationActivity
_BillOfOperationsGroup I_OpActyBOOProdnRsceToolAssgmt _BillOfOperationsGroup
_BillOfOperationsType I_OpActyBOOProdnRsceToolAssgmt _BillOfOperationsType
_ProductionResourceType I_DocumentPRTByInternalKey _ProductionResourceType
_DocumentNumber I_DocumentPRTByInternalKey _DocumentNumber
_DocumentType I_DocumentPRTByInternalKey _DocumentType
_DocumentVersion I_DocumentPRTByInternalKey _DocumentVersion
_DocumentInfoRecord I_DocumentPRTByInternalKey _DocumentInfoRecord

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_MfgWorkInstructionPRTDocLink.
-- 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: IMFGWORKINSDOC

CREATE VIEW I_MfgWorkInstructionPRTDocLink AS
SELECT
  PRT.OperationActivity AS OperationActivity,
  PRT.OperationActyVersionCounter AS OperationActyVersionCounter,
  PRT.BillOfOperationsType AS BillOfOperationsType,
  PRT.BillOfOperationsGroup AS BillOfOperationsGroup,
  PRT.BOOOperationPRTInternalID AS BOOOperationPRTInternalID,
  PRTChangeState.BOOOperationPRTIntVersCounter AS BOOOperationPRTIntVersCounter,
  PRTDocInternalKey.ProductionResourceType AS ProductionResourceType,
  PRTDocInternalKey.DocumentType AS DocumentType,
  PRTDocInternalKey.DocumentInfoRecord AS DocumentInfoRecord,
  PRTDocInternalKey.DocumentVersion AS DocumentVersion,
  PRTDocInternalKey.DocumentPart AS DocumentPart,
  PRTDocInternalKey.DocumentInfoRecord AS DocumentInfoRecordDocNumber,
  PRT._OperationActivity AS _OperationActivity,
  PRT._BillOfOperationsGroup AS _BillOfOperationsGroup,
  PRT._BillOfOperationsType AS _BillOfOperationsType,
  PRTDocInternalKey._ProductionResourceType AS _ProductionResourceType,
  PRTDocInternalKey._DocumentNumber AS _DocumentNumber,
  PRTDocInternalKey._DocumentType AS _DocumentType,
  PRTDocInternalKey._DocumentVersion AS _DocumentVersion,
  PRTDocInternalKey._DocumentInfoRecord AS _DocumentInfoRecord
FROM I_OpActyBOOProdnRsceToolAssgmt AS PRT
INNER JOIN I_BOOOperationPRTChangeState AS PRTChangeState ON /* join condition not captured in parsed metadata */
INNER JOIN I_DocumentPRTByInternalKey AS PRTDocInternalKey ON /* join condition not captured in parsed metadata */
;

Learn More