P_SFOOpActyTrcblUsedPRT

Q: Which tables does P_SFOOpActyTrcblUsedPRT use?

P_SFOOpActyTrcblUsedPRT reads from 4 data source(s): I_LogisticsOrder, I_OpActyInstceNtwkElmntBasic, I_OrderOperationBasic, P_SFOOpActyTrcblUsedPRTUnion.

Q: How many fields does P_SFOOpActyTrcblUsedPRT have?

P_SFOOpActyTrcblUsedPRT has 42 fields. Key fields: OpActyNtwkInstance, OpActyNtwkElement, OrderInternalID, MfgOrderOpProdnRsceToolIntID, Equipment.

DDL: P_SFOOPACTYTRCBLUSEDPRT Type: view_entity CONSUMPTION

P_SFOOpActyTrcblUsedPRT is a Consumption CDS View in SAP S/4HANA. It reads from 4 data sources (I_LogisticsOrder, I_OpActyInstceNtwkElmntBasic, I_OrderOperationBasic, P_SFOOpActyTrcblUsedPRTUnion) and exposes 42 fields with key fields OpActyNtwkInstance, OpActyNtwkElement, OrderInternalID, MfgOrderOpProdnRsceToolIntID, Equipment. It has 5 associations to related views.

Data Sources (4)

Source	Alias	Join Type
I_LogisticsOrder	LogisticsOrder	inner
I_OpActyInstceNtwkElmntBasic	OpActyInstceNtwkElmntBasic	inner
I_OrderOperationBasic	OrderOperationBasic	inner
P_SFOOpActyTrcblUsedPRTUnion	SFOOpActyTrcblUsedPRTUnion	from

Associations (5)

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`

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 (42)

Key	Field	Source Table	Source Field
KEY	OpActyNtwkInstance	I_OpActyInstceNtwkElmntBasic	OpActyNtwkInstance
KEY	OpActyNtwkElement	I_OpActyInstceNtwkElmntBasic	OpActyNtwkElement
KEY	OrderInternalID	P_SFOOpActyTrcblUsedPRTUnion	OrderInternalID
KEY	MfgOrderOpProdnRsceToolIntID	P_SFOOpActyTrcblUsedPRTUnion	MfgOrderOpProdnRsceToolIntID
KEY	Equipment	P_SFOOpActyTrcblUsedPRTUnion	Equipment
KEY	ProductionResourceType	P_SFOOpActyTrcblUsedPRTUnion	ProductionResourceType
KEY	ProductionResourceInternalID	P_SFOOpActyTrcblUsedPRTUnion	ProductionResourceInternalID
	ProdnRsceToolCategory	P_SFOOpActyTrcblUsedPRTUnion	UnplndProdnRsceToolCategory
	MiscProductionResourceTool	MfgOrderPRTAssgmtDetail	MiscProductionResourceTool
	PRTIsUsedAsTestEquipment	OperationActyPRTAssignment	PRTIsUsedAsTestEquipment
	Material	P_SFOOpActyTrcblUsedPRTUnion	Material
	MaterialName	P_SFOOpActyTrcblUsedPRTUnion	MaterialName
	ProdnRsceToolPlant	P_SFOOpActyTrcblUsedPRTUnion	ProdnRsceToolPlant
	EquipmentName	P_SFOOpActyTrcblUsedPRTUnion	EquipmentName
	EquipmentSerialNumber	P_SFOOpActyTrcblUsedPRTUnion	EquipmentSerialNumber
	UniqueItemIdentifier	P_SFOOpActyTrcblUsedPRTUnion	UniqueItemIdentifier
	RegisteredPRTQtyInBaseUnit	P_SFOOpActyTrcblUsedPRTUnion	RegisteredPRTQtyInBaseUnit
	BaseUnit	P_SFOOpActyTrcblUsedPRTUnion	BaseUnit
	PlannedTotalProdnRsceToolQty	MfgOrderPRTAssgmtDetail	PlannedTotalProdnRsceToolQty
	PlannedProdnRsceToolQtyUnit
	ProdnRsceToolItemNumber	OrderProdnResourceTool	ProdnRsceToolItemNumber
	OrderProdnRsceToolText
	MfgOrderOperationText	I_OrderOperationBasic	OperationText
	OpActyNtwkElementElement	I_OpActyInstceNtwkElmntBasic	OpActyNtwkElementElement
	OpActyNtwkElementElmntVersCntr	I_OpActyInstceNtwkElmntBasic	OpActyNtwkElementElmntVersCntr
	OrderIDasManufacturingOrder
	ManufacturingOrderCategory	I_LogisticsOrder	OrderCategory
	ManufacturingOrderType	I_LogisticsOrder	OrderType
	ProductionPlant	MfgOrderPRTAssgmtDetail	ProductionPlant
	PRTRegistrationControl	P_SFOOpActyTrcblUsedPRTUnion	PRTRegistrationControl
	PRTRegistrationControlName
	_OpActyNtwkInstance		_OpActyNtwkInstance
	_OperationActivityInstance		_OperationActivityInstance
	_OrderInternalID		_OrderInternalID
	_ProdnRsceToolCategory		_ProdnRsceToolCategory
	_Equipment		_Equipment
	_Material	P_SFOOpActyTrcblUsedPRTUnion	_Material
	_ProdnRsceToolPlant	P_SFOOpActyTrcblUsedPRTUnion	_ProdnRsceToolPlant
	_ProductionPlant	MfgOrderPRTAssgmtDetail	_ProductionPlant
	_MfgOrderCategory	I_LogisticsOrder	_OrderCategory
	_MfgOrderType	I_LogisticsOrder	_OrderType
	_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_SFOOpActyTrcblUsedPRT
  as select from           P_SFOOpActyTrcblUsedPRTUnion as SFOOpActyTrcblUsedPRTUnion
    inner join             I_OpActyInstceNtwkElmntBasic as OpActyInstceNtwkElmntBasic on  OpActyInstceNtwkElmntBasic.OpActyNtwkInstance = SFOOpActyTrcblUsedPRTUnion.OpActyNtwkInstance
                                                                                      and OpActyInstceNtwkElmntBasic.OpActyNtwkElement  = SFOOpActyTrcblUsedPRTUnion.OpActyNtwkElement
    inner join             I_OrderOperationBasic        as OrderOperationBasic        on  OrderOperationBasic.OrderInternalID          = OpActyInstceNtwkElmntBasic.OrderInternalID
                                                                                      and OrderOperationBasic.OrderOperationInternalID = OpActyInstceNtwkElmntBasic.OrderOperationInternalID
    inner join             I_LogisticsOrder             as LogisticsOrder             on LogisticsOrder.OrderID = OpActyInstceNtwkElmntBasic.ManufacturingOrder
    left outer to one join I_OperationActyPRTAssignment as OperationActyPRTAssignment on  OperationActyPRTAssignment.OpActyNtwkInstance           = SFOOpActyTrcblUsedPRTUnion.OpActyNtwkInstance
                                                                                      and OperationActyPRTAssignment.OpActyNtwkElement            = SFOOpActyTrcblUsedPRTUnion.OpActyNtwkElement
                                                                                      and OperationActyPRTAssignment.OrderInternalID              = SFOOpActyTrcblUsedPRTUnion.OrderInternalID
                                                                                      and OperationActyPRTAssignment.MfgOrderOpProdnRsceToolIntID = SFOOpActyTrcblUsedPRTUnion.MfgOrderOpProdnRsceToolIntID
    left outer to one join P_MfgOrderPRTAssgmtDetail    as MfgOrderPRTAssgmtDetail    on  MfgOrderPRTAssgmtDetail.OrderInternalID              = OperationActyPRTAssignment.OrderInternalID
                                                                                      and MfgOrderPRTAssgmtDetail.MfgOrderOpProdnRsceToolIntID = OperationActyPRTAssignment.MfgOrderOpProdnRsceToolIntID
    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

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

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

       @ObjectModel.foreignKey.association: '_OrderInternalID'
  key  SFOOpActyTrcblUsedPRTUnion.OrderInternalID                                                                                                      as OrderInternalID,

  key  SFOOpActyTrcblUsedPRTUnion.MfgOrderOpProdnRsceToolIntID                                                                                         as MfgOrderOpProdnRsceToolIntID,

  key  SFOOpActyTrcblUsedPRTUnion.Equipment                                                                                                            as Equipment,

  key  SFOOpActyTrcblUsedPRTUnion.ProductionResourceType                                                                                               as ProductionResourceType,

  key  SFOOpActyTrcblUsedPRTUnion.ProductionResourceInternalID                                                                                         as ProductionResourceInternalID,

       @ObjectModel.foreignKey.association: '_ProdnRsceToolCategory'
       SFOOpActyTrcblUsedPRTUnion.UnplndProdnRsceToolCategory                                                                                          as ProdnRsceToolCategory,

       MfgOrderPRTAssgmtDetail.MiscProductionResourceTool                                                                                              as MiscProductionResourceTool,

       OperationActyPRTAssignment.PRTIsUsedAsTestEquipment                                                                                             as PRTIsUsedAsTestEquipment,

       SFOOpActyTrcblUsedPRTUnion.Material                                                                                                             as Material,

       SFOOpActyTrcblUsedPRTUnion.MaterialName                                                                                                         as MaterialName,

       SFOOpActyTrcblUsedPRTUnion.ProdnRsceToolPlant                                                                                                   as ProdnRsceToolPlant,

       SFOOpActyTrcblUsedPRTUnion.EquipmentName                                                                                                        as EquipmentName,

       SFOOpActyTrcblUsedPRTUnion.EquipmentSerialNumber                                                                                                as EquipmentSerialNumber,

       SFOOpActyTrcblUsedPRTUnion.UniqueItemIdentifier                                                                                                 as UniqueItemIdentifier,

       @Semantics.quantity.unitOfMeasure: 'BaseUnit'
       SFOOpActyTrcblUsedPRTUnion.RegisteredPRTQtyInBaseUnit                                                                                           as RegisteredPRTQtyInBaseUnit,

       SFOOpActyTrcblUsedPRTUnion.BaseUnit                                                                                                             as BaseUnit,

       @Semantics.quantity.unitOfMeasure: 'PlannedProdnRsceToolQtyUnit'
       MfgOrderPRTAssgmtDetail.PlannedTotalProdnRsceToolQty                                                                                            as PlannedTotalProdnRsceToolQty,

       cast(coalesce(MfgOrderPRTAssgmtDetail.PlannedProdnRsceToolQtyUnit, SFOOpActyTrcblUsedPRTUnion.BaseUnit) as pph_mgsoleh preserving type )        as PlannedProdnRsceToolQtyUnit,

       OrderProdnResourceTool.ProdnRsceToolItemNumber                                                                                                  as ProdnRsceToolItemNumber,

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

       --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
       LogisticsOrder.OrderID                                                                                                                          as ManufacturingOrder,

       @ObjectModel.foreignKey.association: '_MfgOrderCategory'
       LogisticsOrder.OrderCategory                                                                                                                    as ManufacturingOrderCategory,

       @ObjectModel.foreignKey.association: '_MfgOrderType'
       LogisticsOrder.OrderType                                                                                                                        as ManufacturingOrderType,

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

       SFOOpActyTrcblUsedPRTUnion.PRTRegistrationControl                                                                                               as PRTRegistrationControl,

       SFOOpActyTrcblUsedPRTUnion._PRTRegistrationControl._PRTRegistrationControlText[1: Language=$session.system_language].PRTRegistrationControlName as PRTRegistrationControlName,

       _OpActyNtwkInstance,
       _OperationActivityInstance,
       _OrderInternalID,
       _ProdnRsceToolCategory,
       _Equipment,
       SFOOpActyTrcblUsedPRTUnion._Material,
       SFOOpActyTrcblUsedPRTUnion._ProdnRsceToolPlant,
       MfgOrderPRTAssgmtDetail._ProductionPlant,
       LogisticsOrder._OrderCategory                                                                                                                   as _MfgOrderCategory,
       LogisticsOrder._OrderType                                                                                                                       as _MfgOrderType,
       OpActyInstceNtwkElmntBasic._OperationActivityText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LOGISTICSORDER",
"I_OPACTYINSTCENTWKELMNTBASIC",
"I_OPERATIONACTYPRTASSIGNMENT",
"I_ORDEROPERATIONBASIC",
"I_ORDERPRODNRESOURCETOOL",
"I_PRTREGISTRATIONCONTROL",
"I_PRTREGISTRATIONCONTROLTEXT",
"P_MFGORDERPRTASSGMTDETAIL",
"P_SFOOPACTYTRCBLUSEDPRTUNION"
],
"ASSOCIATED":
[
"I_EQUIPMENT",
"I_MATERIAL",
"I_OPACTYNTWKINSTANCE",
"I_OPERATIONACTIVITYINSTANCE",
"I_OPERATIONACTIVITYTEXT",
"I_ORDERCATEGORY",
"I_ORDERINTERNALID",
"I_ORDERTYPE",
"I_PLANT",
"I_PRODNRSCETOOLCATEGORY_2"
],
"BASE":
[
"I_LOGISTICSORDER",
"I_OPACTYINSTCENTWKELMNTBASIC",
"P_MFGORDERPRTASSGMTDETAIL",
"P_SFOOPACTYTRCBLUSEDPRTUNION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

P_SFOOpActyTrcblUsedPRT view_entity

P_SFOOpActyTrcblUsedPRTUnion view_entity
I_LogisticsOrder view
I_OpActyInstceNtwkElmntBasic view
I_OrderOperationBasic view

C_SFOOpActyTrcblUsedPRT view_entity