C_OpActyInstceDocPRT

DDL: C_OPACTYINSTCEDOCPRT Type: view_entity CONSUMPTION
23 Fields 3 Data Sources 1 OData Services

Planned Documents at Operation Activity

C_OpActyInstceDocPRT is a Consumption CDS View that provides data about "Planned Documents at Operation Activity" in SAP S/4HANA. It reads from 3 data sources (I_DocumentPRTByInternalKey, I_OperationActyPRTAssignment, I_OrderProdnResourceTool) and exposes 23 fields with key fields OpActyNtwkInstance, OpActyNtwkElement, OrderInternalID, MfgOrderOpProdnRsceToolIntID. It is exposed through 1 OData service (UI_OPACTYINSTANCEASSIGNMENT).

Data Sources (3)

SourceAliasJoin Type
I_DocumentPRTByInternalKey DocumentPRT inner
I_OperationActyPRTAssignment OperationActyPRTAssignment from
I_OrderProdnResourceTool OrderProdnResourceTool inner

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Planned Documents at Operation Activity view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
UI_OPACTYINSTANCEASSIGNMENT UI_OPACTYINSTANCEASSIGNMENT V4 C1 NOT_RELEASED

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY OpActyNtwkInstance I_OperationActyPRTAssignment OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement I_OperationActyPRTAssignment OpActyNtwkElement Element Number
KEY OrderInternalID I_OperationActyPRTAssignment OrderInternalID Plan No.f.Oper.
KEY MfgOrderOpProdnRsceToolIntID I_OperationActyPRTAssignment MfgOrderOpProdnRsceToolIntID Test equipment
DocumentType I_DocumentPRTByInternalKey DocumentType Order Type
DocumentInfoRecord I_DocumentPRTByInternalKey DocumentInfoRecord Document
DocumentVersion I_DocumentPRTByInternalKey DocumentVersion Docu. Version
DocumentPart I_DocumentPRTByInternalKey DocumentPart Document Part
PlantasPlant
OrderCategory I_OrderProdnResourceTool OrderCategory Order Category
OrderType I_OrderProdnResourceTool OrderType Order Type
MRPController I_OrderProdnResourceTool MRPController MRP Controller
_OpActyNtwkInstance
_OperationActivityInstance I_OperationActyPRTAssignment _OperationActivityInstance
_OrdInternalBillOfOperations I_OperationActyPRTAssignment _OrdInternalBillOfOperations
_OrderProdnResourceTool I_OperationActyPRTAssignment _OrderProdnResourceTool
_DocumentType I_DocumentPRTByInternalKey _DocumentType
_DocumentNumber I_DocumentPRTByInternalKey _DocumentNumber
_DocumentVersion I_DocumentPRTByInternalKey _DocumentVersion
_DocumentInfoRecord I_DocumentPRTByInternalKey _DocumentInfoRecord
_Plant I_OrderProdnResourceTool _Plant
_OrderCategory I_OrderProdnResourceTool _OrderCategory
_OrderType I_OrderProdnResourceTool _OrderType

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_OpActyInstceDocPRT.
-- 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_OpActyInstceDocPRT AS
SELECT
  OperationActyPRTAssignment.OpActyNtwkInstance AS OpActyNtwkInstance,
  OperationActyPRTAssignment.OpActyNtwkElement AS OpActyNtwkElement,
  OperationActyPRTAssignment.OrderInternalID AS OrderInternalID,
  OperationActyPRTAssignment.MfgOrderOpProdnRsceToolIntID AS MfgOrderOpProdnRsceToolIntID,
  DocumentPRT.DocumentType AS DocumentType,
  DocumentPRT.DocumentInfoRecord AS DocumentInfoRecord,
  DocumentPRT.DocumentVersion AS DocumentVersion,
  DocumentPRT.DocumentPart AS DocumentPart,
  OrderProdnResourceTool.OrderCategory AS OrderCategory,
  OrderProdnResourceTool.OrderType AS OrderType,
  OrderProdnResourceTool.MRPController AS MRPController,
  OperationActyPRTAssignment._OperationActivityInstance AS _OperationActivityInstance,
  OperationActyPRTAssignment._OrdInternalBillOfOperations AS _OrdInternalBillOfOperations,
  OperationActyPRTAssignment._OrderProdnResourceTool AS _OrderProdnResourceTool,
  DocumentPRT._DocumentType AS _DocumentType,
  DocumentPRT._DocumentNumber AS _DocumentNumber,
  DocumentPRT._DocumentVersion AS _DocumentVersion,
  DocumentPRT._DocumentInfoRecord AS _DocumentInfoRecord,
  OrderProdnResourceTool._Plant AS _Plant,
  OrderProdnResourceTool._OrderCategory AS _OrderCategory,
  OrderProdnResourceTool._OrderType AS _OrderType
FROM I_OperationActyPRTAssignment AS OperationActyPRTAssignment
INNER JOIN I_OrderProdnResourceTool AS OrderProdnResourceTool ON /* join condition not captured in parsed metadata */
INNER JOIN I_DocumentPRTByInternalKey AS DocumentPRT ON /* join condition not captured in parsed metadata */
;

Learn More