I_OpActyAssignment

DDL: I_OPACTYASSIGNMENT SQL: IOPACTYASSGMT Type: view BASIC

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.

6 data source(s) 19 fields

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
KEY OperationActyVersionCounter I_OperationActivity OperationActyVersionCounter
KEY ProdnRsceToolBOOType I_OpActyBOOProdnRsceToolAssgmt BillOfOperationsType
KEY ProdnRsceToolBOOGrp I_OpActyBOOProdnRsceToolAssgmt BillOfOperationsGroup
KEY BOOOperationPRTInternalID I_OpActyBOOProdnRsceToolAssgmt BOOOperationPRTInternalID
KEY MfgQualifnCertificate I_OpActyCertificateAssignment MfgQualifnCertificate
KEY MfgQualifnRequiredSkillLevel I_OpActyCertificateAssignment MfgQualifnRequiredSkillLevel
KEY BOMItmBOOType I_OpActyBOOOpBOMItmAssgmt BillOfOperationsType
KEY BOMItmBOOGrp I_OpActyBOOOpBOMItmAssgmt BillOfOperationsGroup
KEY BOOOpBOMItemInternalID I_OpActyBOOOpBOMItmAssgmt BOOOpBOMItemInternalID
KEY BillOfMaterialItemQuantity I_OpActyBOOOpBOMItmAssgmt BillOfMaterialItemQuantity
KEY BillOfMaterialItemUnit I_OpActyBOOOpBOMItmAssgmt BillOfMaterialItemUnit
KEY BOOCharcBOOType I_OpActyBOOCharcAssgmt BillOfOperationsType
KEY BOOCharcBOOGrp I_OpActyBOOCharcAssgmt BillOfOperationsGroup
KEY BOOOperationInternalID I_OpActyBOOCharcAssgmt BOOOperationInternalID
KEY BOOCharacteristic I_OpActyBOOCharcAssgmt BOOCharacteristic
KEY OpActyCharacteristicItem I_OpActyBOOCharcAssgmt OpActyCharacteristicItem
KEY WorkInstruction I_OpActyWorkInstructionAssgmt WorkInstruction
KEY WorkInstructionVersionCounter I_OpActyWorkInstructionAssgmt WorkInstructionVersionCounter 
@AbapCatalog.sqlViewName: 'IOPACTYASSGMT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Operation Activity Assignments'
@VDM.viewType: #BASIC
@ObjectModel.usageType: {serviceQuality: #C,
                         dataClass: #MIXED,
                         sizeCategory: #XXL}
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_OpActyAssignment
  as select from    I_OperationActivity            as OpActy

    left outer join I_OpActyBOOProdnRsceToolAssgmt as ProdnRsceToolAssgmt   on  OpActy.OperationActivity           = ProdnRsceToolAssgmt.OperationActivity
                                                                            and OpActy.OperationActyVersionCounter = ProdnRsceToolAssgmt.OperationActyVersionCounter
    left outer join I_OpActyCertificateAssignment  as CertAssgmt            on  OpActy.OperationActivity           = CertAssgmt.OperationActivity
                                                                            and OpActy.OperationActyVersionCounter = CertAssgmt.OperationActyVersionCounter
    left outer join I_OpActyBOOOpBOMItmAssgmt      as BOMItmAssgmt          on  OpActy.OperationActivity           = BOMItmAssgmt.OperationActivity
                                                                            and OpActy.OperationActyVersionCounter = BOMItmAssgmt.OperationActyVersionCounter
    left outer join I_OpActyBOOCharcAssgmt         as CharcAssgmt           on  OpActy.OperationActivity           = CharcAssgmt.OperationActivity
                                                                            and OpActy.OperationActyVersionCounter = CharcAssgmt.OperationActyVersionCounter
    left outer join I_OpActyWorkInstructionAssgmt  as WorkInstructionAssgmt on  OpActy.OperationActivity           = WorkInstructionAssgmt.OperationActivity
                                                                            and OpActy.OperationActyVersionCounter = WorkInstructionAssgmt.OperationActyVersionCounter

{
  key OpActy.OperationActivity,
  key OpActy.OperationActyVersionCounter,
  key ProdnRsceToolAssgmt.BillOfOperationsType  as ProdnRsceToolBOOType,
  key ProdnRsceToolAssgmt.BillOfOperationsGroup as ProdnRsceToolBOOGrp,
  key ProdnRsceToolAssgmt.BOOOperationPRTInternalID,
  key CertAssgmt.MfgQualifnCertificate,
  key CertAssgmt.MfgQualifnRequiredSkillLevel,
  key BOMItmAssgmt.BillOfOperationsType         as BOMItmBOOType,
  key BOMItmAssgmt.BillOfOperationsGroup        as BOMItmBOOGrp,
  key BOMItmAssgmt.BOOOpBOMItemInternalID,
  key BOMItmAssgmt.BillOfMaterialItemQuantity,
  key BOMItmAssgmt.BillOfMaterialItemUnit,
  key CharcAssgmt.BillOfOperationsType          as BOOCharcBOOType,
  key CharcAssgmt.BillOfOperationsGroup         as BOOCharcBOOGrp,
  key CharcAssgmt.BOOOperationInternalID,
  key CharcAssgmt.BOOCharacteristic,
  key CharcAssgmt.OpActyCharacteristicItem,
  key WorkInstructionAssgmt.WorkInstruction,
  key WorkInstructionAssgmt.WorkInstructionVersionCounter

}

where
  CharcAssgmt.OpActyInspCharacteristicStatus = ' '
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_OPACTYBOOCHARCASSGMT",
"I_OPACTYBOOOPBOMITMASSGMT",
"I_OPACTYBOOPRODNRSCETOOLASSGMT",
"I_OPACTYCERTIFICATEASSIGNMENT",
"I_OPACTYWORKINSTRUCTIONASSGMT",
"I_OPERATIONACTIVITY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More