I_OpActyAssignment

DDL: I_OPACTYASSIGNMENT SQL: IOPACTYASSGMT Type: view BASIC
19 Fields 6 Data Sources

Operation Activity Assignments

I_OpActyAssignment is a Basic CDS View that provides data about "Operation Activity Assignments" in SAP S/4HANA. It reads from 6 data sources and exposes 19 fields with key fields OperationActivity, OperationActyVersionCounter, ProdnRsceToolBOOType, ProdnRsceToolBOOGrp, BOOOperationPRTInternalID.

Data Sources (6)

SourceAliasJoin Type
I_OpActyBOOOpBOMItmAssgmt BOMItmAssgmt left_outer
I_OpActyCertificateAssignment CertAssgmt left_outer
I_OpActyBOOCharcAssgmt CharcAssgmt left_outer
I_OperationActivity OpActy from
I_OpActyBOOProdnRsceToolAssgmt ProdnRsceToolAssgmt left_outer
I_OpActyWorkInstructionAssgmt WorkInstructionAssgmt left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IOPACTYASSGMT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Operation Activity Assignments view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY OperationActivity I_OperationActivity OperationActivity Operation Activity
KEY OperationActyVersionCounter I_OperationActivity OperationActyVersionCounter OA Version
KEY ProdnRsceToolBOOType I_OpActyBOOProdnRsceToolAssgmt BillOfOperationsType Task List Type
KEY ProdnRsceToolBOOGrp I_OpActyBOOProdnRsceToolAssgmt BillOfOperationsGroup Group
KEY BOOOperationPRTInternalID I_OpActyBOOProdnRsceToolAssgmt BOOOperationPRTInternalID Test equipment
KEY MfgQualifnCertificate I_OpActyCertificateAssignment MfgQualifnCertificate Certification
KEY MfgQualifnRequiredSkillLevel I_OpActyCertificateAssignment MfgQualifnRequiredSkillLevel SkillLevel
KEY BOMItmBOOType I_OpActyBOOOpBOMItmAssgmt BillOfOperationsType Task List Type
KEY BOMItmBOOGrp I_OpActyBOOOpBOMItmAssgmt BillOfOperationsGroup Group
KEY BOOOpBOMItemInternalID I_OpActyBOOOpBOMItmAssgmt BOOOpBOMItemInternalID Allocation no.
KEY BillOfMaterialItemQuantity I_OpActyBOOOpBOMItmAssgmt BillOfMaterialItemQuantity Quantity
KEY BillOfMaterialItemUnit I_OpActyBOOOpBOMItmAssgmt BillOfMaterialItemUnit Component UoM
KEY BOOCharcBOOType I_OpActyBOOCharcAssgmt BillOfOperationsType Task List Type
KEY BOOCharcBOOGrp I_OpActyBOOCharcAssgmt BillOfOperationsGroup Group
KEY BOOOperationInternalID I_OpActyBOOCharcAssgmt BOOOperationInternalID Task list node
KEY BOOCharacteristic I_OpActyBOOCharcAssgmt BOOCharacteristic Characteristic
KEY OpActyCharacteristicItem I_OpActyBOOCharcAssgmt OpActyCharacteristicItem Sort No.
KEY WorkInstruction I_OpActyWorkInstructionAssgmt WorkInstruction WorkItem ID
KEY WorkInstructionVersionCounter I_OpActyWorkInstructionAssgmt WorkInstructionVersionCounter Version No.

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_OpActyAssignment.
-- 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: IOPACTYASSGMT

CREATE VIEW I_OpActyAssignment AS
SELECT
  OpActy.OperationActivity AS OperationActivity,
  OpActy.OperationActyVersionCounter AS OperationActyVersionCounter,
  ProdnRsceToolAssgmt.BillOfOperationsType AS ProdnRsceToolBOOType,
  ProdnRsceToolAssgmt.BillOfOperationsGroup AS ProdnRsceToolBOOGrp,
  ProdnRsceToolAssgmt.BOOOperationPRTInternalID AS BOOOperationPRTInternalID,
  CertAssgmt.MfgQualifnCertificate AS MfgQualifnCertificate,
  CertAssgmt.MfgQualifnRequiredSkillLevel AS MfgQualifnRequiredSkillLevel,
  BOMItmAssgmt.BillOfOperationsType AS BOMItmBOOType,
  BOMItmAssgmt.BillOfOperationsGroup AS BOMItmBOOGrp,
  BOMItmAssgmt.BOOOpBOMItemInternalID AS BOOOpBOMItemInternalID,
  BOMItmAssgmt.BillOfMaterialItemQuantity AS BillOfMaterialItemQuantity,
  BOMItmAssgmt.BillOfMaterialItemUnit AS BillOfMaterialItemUnit,
  CharcAssgmt.BillOfOperationsType AS BOOCharcBOOType,
  CharcAssgmt.BillOfOperationsGroup AS BOOCharcBOOGrp,
  CharcAssgmt.BOOOperationInternalID AS BOOOperationInternalID,
  CharcAssgmt.BOOCharacteristic AS BOOCharacteristic,
  CharcAssgmt.OpActyCharacteristicItem AS OpActyCharacteristicItem,
  WorkInstructionAssgmt.WorkInstruction AS WorkInstruction,
  WorkInstructionAssgmt.WorkInstructionVersionCounter AS WorkInstructionVersionCounter
FROM I_OperationActivity AS OpActy
LEFT OUTER JOIN I_OpActyBOOProdnRsceToolAssgmt AS ProdnRsceToolAssgmt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OpActyCertificateAssignment AS CertAssgmt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OpActyBOOOpBOMItmAssgmt AS BOMItmAssgmt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OpActyBOOCharcAssgmt AS CharcAssgmt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OpActyWorkInstructionAssgmt AS WorkInstructionAssgmt ON /* join condition not captured in parsed metadata */
;

Learn More