P_OpActyInstceEquipActvRegn

Q: Which tables does P_OpActyInstceEquipActvRegn use?

P_OpActyInstceEquipActvRegn reads from 3 data source(s): I_OpActyInstceNtwkElmntBasic, I_OpActyInstceEquipActvRegn, I_OrderOperationBasic.

Q: How many fields does P_OpActyInstceEquipActvRegn have?

P_OpActyInstceEquipActvRegn has 34 fields. Key fields: OpActyNtwkInstance, OpActyNtwkElement, OrderInternalID, MfgOrderOpProdnRsceToolIntID, Equipment.

DDL: P_OPACTYINSTCEEQUIPACTVREGN Type: view_entity CONSUMPTION

P_OpActyInstceEquipActvRegn is a Consumption CDS View in SAP S/4HANA. It reads from 3 data sources (I_OpActyInstceNtwkElmntBasic, I_OpActyInstceEquipActvRegn, I_OrderOperationBasic) and exposes 34 fields with key fields OpActyNtwkInstance, OpActyNtwkElement, OrderInternalID, MfgOrderOpProdnRsceToolIntID, Equipment. It has 6 associations to related views.

Data Sources (3)

Source	Alias	Join Type
I_OpActyInstceNtwkElmntBasic	OpActyInstceNtwkElmntBasic	inner
I_OpActyInstceEquipActvRegn	OpActyNrOfActvEquipRegn	from
I_OrderOperationBasic	OrderOperationBasic	inner

Associations (6)

Cardinality	Target	Alias	Condition
[1..1]	I_OpActyNtwkInstance	_OpActyNtwkInstance	`$projection.OpActyNtwkInstance = _OpActyNtwkInstance.OpActyNtwkInstance`
[1..1]	I_OperationActivityInstance	_OperationActivityInstance	`$projection.OpActyNtwkInstance = _OperationActivityInstance.OpActyNtwkInstance and $projection.OpActyNtwkElement = _OperationActivityInstance.OpActyNtwkElement`
[1..1]	I_OrderInternalID	_OrderInternalID	`$projection.OrderInternalID = _OrderInternalID.OrderInternalID`
[1..1]	I_Equipment	_Equipment	`$projection.Equipment = _Equipment.Equipment`
[1..1]	I_ProdnRsceToolCategory_2	_ProdnRsceToolCategory	`$projection.ProdnRsceToolCategory = _ProdnRsceToolCategory.ProdnRsceToolCategory`
[0..*]	I_DocumentInfoRecordDesc	_DocumentInfoRecordDesc	`$projection.DocumentType = _DocumentInfoRecordDesc.DocumentInfoRecordDocType and $projection.DocumentInfoRecord = _DocumentInfoRecordDesc.DocumentInfoRecordDocNumber and $projection.DocumentVersion = _DocumentInfoRecordDesc.DocumentInfoRecordDocVersion and $projection.DocumentPart = _DocumentInfoRecordDesc.DocumentInfoRecordDocPart`

Annotations (7)

Name	Value	Level
AccessControl.authorizationCheck	#NOT_REQUIRED	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.viewType	#CONSUMPTION	view
VDM.private	true	view

Fields (34)

Key	Field	Source Table	Source Field
KEY	OpActyNtwkInstance	I_OpActyInstceNtwkElmntBasic	OpActyNtwkInstance
KEY	OpActyNtwkElement	I_OpActyInstceNtwkElmntBasic	OpActyNtwkElement
KEY	OrderInternalID	I_OpActyInstceEquipActvRegn	OrderInternalID
KEY	MfgOrderOpProdnRsceToolIntID	I_OpActyInstceEquipActvRegn	MfgOrderOpProdnRsceToolIntID
KEY	Equipment	I_OpActyInstceEquipActvRegn	Equipment
	MiscProductionResourceTool	OperationActyPRTAssignment	MiscProductionResourceTool
	PRTIsUsedAsTestEquipment	OperationActyPRTAssignment	PRTIsUsedAsTestEquipment
	Material	OperationActyPRTAssignment	Material
	ProductionResourceType	OperationActyPRTAssignment	ProductionResourceType
	ProductionResourceInternalID	OperationActyPRTAssignment	ProductionResourceInternalID
	OrderProdnRsceToolText
	ProdnRsceToolItemNumber	OrderProdnResourceTool	ProdnRsceToolItemNumber
	MfgOrderOperationText	I_OrderOperationBasic	OperationText
	OpActyNtwkElementElement	I_OpActyInstceNtwkElmntBasic	OpActyNtwkElementElement
	OpActyNtwkElementElmntVersCntr	I_OpActyInstceNtwkElmntBasic	OpActyNtwkElementElmntVersCntr
	ManufacturingOrderType	OperationActyPRTAssignment	ManufacturingOrderType
	ProductionPlant	OperationActyPRTAssignment	ProductionPlant
	PRTRegistrationControl	OperationActyPRTAssignment	PRTRegistrationControl
	DocumentType
	DocumentInfoRecord	OperationActyPRTAssignment	DocumentInfoRecord
	DocumentVersion	OperationActyPRTAssignment	DocumentVersion
	DocumentPart	OperationActyPRTAssignment	DocumentPart
	_OpActyNtwkInstance		_OpActyNtwkInstance
	_OperationActivityInstance		_OperationActivityInstance
	_OrderInternalID		_OrderInternalID
	_ProdnRsceToolCategory		_ProdnRsceToolCategory
	_Equipment		_Equipment
	_DocumentInfoRecordDesc		_DocumentInfoRecordDesc
	_MiscProdnRsceToolText	OperationActyPRTAssignment	_MiscProdnRsceToolText
	_Material	OperationActyPRTAssignment	_Material
	_MfgOrderCategory	OperationActyPRTAssignment	_MfgOrderCategory
	_MfgOrderType	OperationActyPRTAssignment	_MfgOrderType
	_ProductionPlant	OperationActyPRTAssignment	_ProductionPlant
	_OperationActivityText	I_OpActyInstceNtwkElmntBasic	_OperationActivityText

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #XL,
  dataClass: #MIXED
}
@VDM.viewType: #CONSUMPTION
@VDM.private: true
define view entity P_OpActyInstceEquipActvRegn
  as select from           I_OpActyInstceEquipActvRegn  as OpActyNrOfActvEquipRegn
    inner join             I_OpActyInstceNtwkElmntBasic as OpActyInstceNtwkElmntBasic on  OpActyInstceNtwkElmntBasic.OpActyNtwkInstance = OpActyNrOfActvEquipRegn.OpActyNtwkInstance
                                                                                      and OpActyInstceNtwkElmntBasic.OpActyNtwkElement  = OpActyNrOfActvEquipRegn.OpActyNtwkElement
    inner join             I_OrderOperationBasic        as OrderOperationBasic        on  OrderOperationBasic.OrderInternalID          = OpActyInstceNtwkElmntBasic.OrderInternalID
                                                                                      and OrderOperationBasic.OrderOperationInternalID = OpActyInstceNtwkElmntBasic.OrderOperationInternalID
    left outer to one join P_OperationActyPRTAssignment as OperationActyPRTAssignment on  OperationActyPRTAssignment.OpActyNtwkInstance           = OpActyNrOfActvEquipRegn.OpActyNtwkInstance
                                                                                      and OperationActyPRTAssignment.OpActyNtwkElement            = OpActyNrOfActvEquipRegn.OpActyNtwkElement
                                                                                      and OperationActyPRTAssignment.OrderInternalID              = OpActyNrOfActvEquipRegn.OrderInternalID
                                                                                      and OperationActyPRTAssignment.MfgOrderOpProdnRsceToolIntID = OpActyNrOfActvEquipRegn.MfgOrderOpProdnRsceToolIntID
                                                                                      and (
                                                                                         (
                                                                                           OperationActyPRTAssignment.ProdnRsceToolCategory       = 'E'
                                                                                           and OperationActyPRTAssignment.Equipment               = OpActyNrOfActvEquipRegn.Equipment
                                                                                         )
                                                                                         or(
                                                                                           OperationActyPRTAssignment.ProdnRsceToolCategory       = 'M'
                                                                                           and OperationActyPRTAssignment.Material                = OpActyNrOfActvEquipRegn.EquipmentMaterial
                                                                                         )
                                                                                       )
    left outer to one join I_OrderProdnResourceTool     as OrderProdnResourceTool     on  OrderProdnResourceTool.OrderInternalBillOfOperations = OperationActyPRTAssignment.OrderInternalID
                                                                                      and OrderProdnResourceTool.OrderProdnRsceToolInternalID  = OperationActyPRTAssignment.MfgOrderOpProdnRsceToolIntID
                                                                                      and OrderProdnResourceTool.IsDeleted                     = ''
  association [1..1] to I_OpActyNtwkInstance        as _OpActyNtwkInstance        on  $projection.OpActyNtwkInstance = _OpActyNtwkInstance.OpActyNtwkInstance
  association [1..1] to I_OperationActivityInstance as _OperationActivityInstance on  $projection.OpActyNtwkInstance = _OperationActivityInstance.OpActyNtwkInstance
                                                                                  and $projection.OpActyNtwkElement  = _OperationActivityInstance.OpActyNtwkElement
  association [1..1] to I_OrderInternalID           as _OrderInternalID           on  $projection.OrderInternalID = _OrderInternalID.OrderInternalID
  association [1..1] to I_Equipment                 as _Equipment                 on  $projection.Equipment = _Equipment.Equipment
  association [1..1] to I_ProdnRsceToolCategory_2   as _ProdnRsceToolCategory     on  $projection.ProdnRsceToolCategory = _ProdnRsceToolCategory.ProdnRsceToolCategory
  association [0..*] to I_DocumentInfoRecordDesc    as _DocumentInfoRecordDesc    on  $projection.DocumentType       = _DocumentInfoRecordDesc.DocumentInfoRecordDocType
                                                                                  and $projection.DocumentInfoRecord = _DocumentInfoRecordDesc.DocumentInfoRecordDocNumber
                                                                                  and $projection.DocumentVersion    = _DocumentInfoRecordDesc.DocumentInfoRecordDocVersion
                                                                                  and $projection.DocumentPart       = _DocumentInfoRecordDesc.DocumentInfoRecordDocPart

{
       @ObjectModel.foreignKey.association: '_OpActyNtwkInstance'
  key  OpActyInstceNtwkElmntBasic.OpActyNtwkInstance,

       @ObjectModel.foreignKey.association: '_OperationActivityInstance'
  key  OpActyInstceNtwkElmntBasic.OpActyNtwkElement,

       @ObjectModel.foreignKey.association: '_OrderInternalID'
  key  OpActyNrOfActvEquipRegn.OrderInternalID,

  key  OpActyNrOfActvEquipRegn.MfgOrderOpProdnRsceToolIntID,

  key  OpActyNrOfActvEquipRegn.Equipment                                                                 as Equipment,

       @ObjectModel.foreignKey.association: '_ProdnRsceToolCategory'
       cast(case
        when OperationActyPRTAssignment.ProdnRsceToolCategory is null then 'E'
        else OperationActyPRTAssignment.ProdnRsceToolCategory
        end as mpe_fhmar preserving type)                                                                as ProdnRsceToolCategory,

       @UI.hidden: true
       OperationActyPRTAssignment.MiscProductionResourceTool                                             as MiscProductionResourceTool,

       OperationActyPRTAssignment.PRTIsUsedAsTestEquipment                                               as PRTIsUsedAsTestEquipment,

       OperationActyPRTAssignment.Material                                                               as Material,

       OperationActyPRTAssignment.ProductionResourceType                                                 as ProductionResourceType,

       OperationActyPRTAssignment.ProductionResourceInternalID                                           as ProductionResourceInternalID,

       cast(coalesce(OrderProdnResourceTool.OrderProdnRsceToolText, '') as txtz1)                        as OrderProdnRsceToolText,

       OrderProdnResourceTool.ProdnRsceToolItemNumber                                                    as ProdnRsceToolItemNumber,

       --Operation Fields
       cast(OrderOperationBasic.Operation as mpe_vornr_char preserving type)                             as ManufacturingOrderOperation,

       OrderOperationBasic.OperationText                                                                 as MfgOrderOperationText,

       -- OA Details Fields
       cast(OpActyInstceNtwkElmntBasic.OpActyNtwkElementExternalID as mpe_oa_number_ext preserving type) as OpActyNtwkElementExternalID,

       OpActyInstceNtwkElmntBasic.OpActyNtwkElementElement                                               as OpActyNtwkElementElement,

       OpActyInstceNtwkElmntBasic.OpActyNtwkElementElmntVersCntr                                         as OpActyNtwkElementElmntVersCntr,

       -- Order fields
       @ObjectModel.foreignKey.association: '_MfgOrderCategory'
       OperationActyPRTAssignment.ManufacturingOrderCategory                                             as ManufacturingOrderCategory,

       @ObjectModel.foreignKey.association: '_MfgOrderType'
       OperationActyPRTAssignment.ManufacturingOrderType                                                 as ManufacturingOrderType,

       @ObjectModel.foreignKey.association: '_ProductionPlant'
       OperationActyPRTAssignment.ProductionPlant                                                        as ProductionPlant,

       OperationActyPRTAssignment.PRTRegistrationControl                                                 as PRTRegistrationControl,
       case OperationActyPRTAssignment.ProdnRsceToolRegnIsAllowed
       when 'X' then
       OperationActyPRTAssignment._PRTRegistrationControl._PRTRegistrationControlText[1: Language=$session.system_language].PRTRegistrationControlName
       else '' end                                                                                       as PRTRegistrationControlName,

       -- Document Identifiers
       OperationActyPRTAssignment.DocumentType,

       OperationActyPRTAssignment.DocumentInfoRecord,

       OperationActyPRTAssignment.DocumentVersion,

       OperationActyPRTAssignment.DocumentPart,


       _OpActyNtwkInstance,
       _OperationActivityInstance,
       _OrderInternalID,
       _ProdnRsceToolCategory,
       _Equipment,
       _DocumentInfoRecordDesc,
       OperationActyPRTAssignment._MiscProdnRsceToolText,
       OperationActyPRTAssignment._Material,
       OperationActyPRTAssignment._MfgOrderCategory,
       OperationActyPRTAssignment._MfgOrderType,
       OperationActyPRTAssignment._ProductionPlant,
       OpActyInstceNtwkElmntBasic._OperationActivityText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_OPACTYINSTCEEQUIPACTVREGN",
"I_OPACTYINSTCENTWKELMNTBASIC",
"I_ORDEROPERATIONBASIC",
"I_ORDERPRODNRESOURCETOOL",
"I_PRTREGISTRATIONCONTROL",
"I_PRTREGISTRATIONCONTROLTEXT",
"P_OPERATIONACTYPRTASSIGNMENT"
],
"ASSOCIATED":
[
"I_DOCUMENTINFORECORDDESC",
"I_EQUIPMENT",
"I_MATERIAL",
"I_MFGORDERCATEGORY",
"I_MFGORDERTYPE",
"I_MISCPRODNRSCETOOLTEXT",
"I_OPACTYNTWKINSTANCE",
"I_OPERATIONACTIVITYINSTANCE",
"I_OPERATIONACTIVITYTEXT",
"I_ORDERINTERNALID",
"I_PLANT",
"I_PRODNRSCETOOLCATEGORY_2"
],
"BASE":
[
"I_OPACTYINSTCENTWKELMNTBASIC",
"P_OPERATIONACTYPRTASSIGNMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

P_OpActyInstceEquipActvRegn view_entity

C_OpActyInstceEquipActvRegn view