P_SFIOperationActivityPRTUnion

DDL: P_SFIOPERATIONACTIVITYPRTUNION Type: view_entity CONSUMPTION
118 Fields 4 Data Sources 3 Associations

P_SFIOperationActivityPRTUnion is a Consumption CDS View in SAP S/4HANA. It reads from 4 data sources (I_EquipmentPRTByInternalKey, I_OpActyInstceEquipActvRegn, I_SFIOpActyInstcePRTRegnAggrgn, P_SFIOperationActivityPlndPRT) and exposes 118 fields with key fields OpActyNtwkInstance, OpActyNtwkElement, OrderInternalID, MfgOrderOpProdnRsceToolIntID, Equipment. It has 3 associations to related views.

Data Sources (4)

SourceAliasJoin Type
I_EquipmentPRTByInternalKey EquipmentPRTByInternalKey inner
I_OpActyInstceEquipActvRegn OpActyInstceEquipActvRegn union_all
I_SFIOpActyInstcePRTRegnAggrgn SFIOpActyInstcePRTRegnAggrgn union_all
P_SFIOperationActivityPlndPRT SFIOperationActivityPlndPRT from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_Equipment _Equipment $projection.Equipment = _Equipment.Equipment
[0..1] I_PRTRegistrationControl _PRTRegistrationControl $projection.PRTRegistrationControl = _PRTRegistrationControl.PRTRegistrationControl
[0..1] I_Material _Material $projection.Material = _Material.Material

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (118)

KeyFieldSource TableSource FieldDescription
KEY OpActyNtwkInstance P_SFIOperationActivityPlndPRT OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement P_SFIOperationActivityPlndPRT OpActyNtwkElement Element Number
KEY OrderInternalID P_SFIOperationActivityPlndPRT OrderInternalID Plan No.f.Oper.
KEY MfgOrderOpProdnRsceToolIntID P_SFIOperationActivityPlndPRT MfgOrderOpProdnRsceToolIntID
KEY Equipment P_SFIOperationActivityPlndPRT Equipment Equipment check
KEY ProductionResourceType P_SFIOperationActivityPlndPRT ProductionResourceType Object Type
KEY ProductionResourceInternalID P_SFIOperationActivityPlndPRT ProductionResourceInternalID Object ID
KEY ShopFloorItem P_SFIOperationActivityPlndPRT ShopFloorItem Serial.Mat. ID
PRTIsUsedAsTestEquipment P_SFIOperationActivityPlndPRT PRTIsUsedAsTestEquipment Test Equipment
ProdnRsceToolCategory P_SFIOperationActivityPlndPRT ProdnRsceToolCategory
Material P_SFIOperationActivityPlndPRT Material Vehicle Model
DocumentType P_SFIOperationActivityPlndPRT DocumentType Order Type
DocumentInfoRecord P_SFIOperationActivityPlndPRT DocumentInfoRecord Document
DocumentVersion P_SFIOperationActivityPlndPRT DocumentVersion Docu. Version
DocumentPart P_SFIOperationActivityPlndPRT DocumentPart Document Part
MiscProductionResourceTool P_SFIOperationActivityPlndPRT MiscProductionResourceTool
ProdnRsceToolStdWorkQtyUnit P_SFIOperationActivityPlndPRT ProdnRsceToolStdWorkQtyUnit Unit
ProdnRsceToolStandardWorkQty P_SFIOperationActivityPlndPRT ProdnRsceToolStandardWorkQty Quantity
PlannedProdnRsceToolQtyUnit P_SFIOperationActivityPlndPRT PlannedProdnRsceToolQtyUnit
PlannedTotalProdnRsceToolQty P_SFIOperationActivityPlndPRT PlannedTotalProdnRsceToolQty
NumberOfActvEquipRegistrations P_SFIOperationActivityPlndPRT NumberOfActvEquipRegistrations
BaseUnit P_SFIOperationActivityPlndPRT BaseUnit Valuation Unit
RegisteredPRTQtyInBaseUnit P_SFIOperationActivityPlndPRT RegisteredPRTQtyInBaseUnit
OrderProdnRsceToolText P_SFIOperationActivityPlndPRT OrderProdnRsceToolText
ProdnRsceToolRegnIsAllowed P_SFIOperationActivityPlndPRT ProdnRsceToolRegnIsAllowed Registrable
ManufacturingOrderCategory P_SFIOperationActivityPlndPRT ManufacturingOrderCategory
ManufacturingOrderType P_SFIOperationActivityPlndPRT ManufacturingOrderType
ProductionPlant P_SFIOperationActivityPlndPRT ProductionPlant Prod plnt
ProdnRsceToolItemNumber P_SFIOperationActivityPlndPRT ProdnRsceToolItemNumber Item Number
BOOOperationPRTInternalID P_SFIOperationActivityPlndPRT BOOOperationPRTInternalID
ShopFloorRtgPRTIsRegistrable P_SFIOperationActivityPlndPRT ShopFloorRtgPRTIsRegistrable
PRTRegistrationControl P_SFIOperationActivityPlndPRT PRTRegistrationControl
_OpActyNtwkInstance
_OperationActivityInstance P_SFIOperationActivityPlndPRT _OperationActivityInstance
_OrdInternalBillOfOperations P_SFIOperationActivityPlndPRT _OrdInternalBillOfOperations
_Material P_SFIOperationActivityPlndPRT _Material
_Equipment P_SFIOperationActivityPlndPRT _Equipment
_MfgOrderCategory P_SFIOperationActivityPlndPRT _MfgOrderCategory
_MfgOrderType P_SFIOperationActivityPlndPRT _MfgOrderType
OpActyNtwkInstanceasOpActyNtwkInstance
KEY OpActyNtwkElement I_OpActyInstceEquipActvRegn OpActyNtwkElement Element Number
KEY OrderInternalID I_OpActyInstceEquipActvRegn OrderInternalID Plan No.f.Oper.
KEY MfgOrderOpProdnRsceToolIntID I_OpActyInstceEquipActvRegn MfgOrderOpProdnRsceToolIntID
KEY Equipment I_OpActyInstceEquipActvRegn Equipment Equipment check
KEY ProductionResourceType I_EquipmentPRTByInternalKey ProductionResourceType Object Type
KEY ProductionResourceInternalID I_EquipmentPRTByInternalKey ProductionResourceInternalID Object ID
KEY ShopFloorItem I_OpActyInstceEquipActvRegn ShopFloorItem Serial.Mat. ID
PRTIsUsedAsTestEquipment Test Equipment
ProdnRsceToolCategory
Material I_OpActyInstceEquipActvRegn EquipmentMaterial Vehicle Model
DocumentType Order Type
DocumentInfoRecord Document
DocumentVersion Docu. Version
DocumentPart Document Part
MiscProductionResourceTool
ProdnRsceToolStdWorkQtyUnit Unit
ProdnRsceToolStandardWorkQty Quantity
PlannedProdnRsceToolQtyUnit
PlannedTotalProdnRsceToolQty
NumberOfActvEquipRegistrations
BaseUnit Valuation Unit
RegisteredPRTQtyInBaseUnit
OrderProdnRsceToolText
ProdnRsceToolRegnIsAllowed Registrable
ManufacturingOrderCategory
ManufacturingOrderType
ProductionPlant Prod plnt
ProdnRsceToolItemNumber Item Number
BOOOperationPRTInternalID
ShopFloorRtgPRTIsRegistrable
PRTRegistrationControl
_OpActyNtwkInstance
_OperationActivityInstance I_OpActyInstceEquipActvRegn _OperationActivityInstance
_OrdInternalBillOfOperations I_OpActyInstceEquipActvRegn _OrdInternalBillOfOperations
_Material I_OpActyInstceEquipActvRegn _Material
_Equipment _Equipment
_MfgOrderCategory
_MfgOrderType
OpActyNtwkInstanceasOpActyNtwkInstance
KEY OpActyNtwkElement I_SFIOpActyInstcePRTRegnAggrgn OpActyNtwkElement Element Number
KEY OrderInternalID I_SFIOpActyInstcePRTRegnAggrgn OrderInternalID Plan No.f.Oper.
KEY MfgOrderOpProdnRsceToolIntID I_SFIOpActyInstcePRTRegnAggrgn MfgOrderOpProdnRsceToolIntID
KEY Equipment Equipment check
KEY ProductionResourceType I_SFIOpActyInstcePRTRegnAggrgn ProductionResourceType Object Type
KEY ProductionResourceInternalID I_SFIOpActyInstcePRTRegnAggrgn ProductionResourceInternalID Object ID
KEY ShopFloorItem I_SFIOpActyInstcePRTRegnAggrgn ShopFloorItem Serial.Mat. ID
PRTIsUsedAsTestEquipment Test Equipment
ProdnRsceToolCategory
Material MaterialPRT Material Vehicle Model
DocumentType Order Type
DocumentInfoRecord Document
DocumentVersion Docu. Version
DocumentPart Document Part
MiscProductionResourceTool
ProdnRsceToolStdWorkQtyUnit Unit
ProdnRsceToolStandardWorkQty Quantity
PlannedProdnRsceToolQtyUnit
PlannedTotalProdnRsceToolQty
NumberOfActvEquipRegistrations
BaseUnit I_SFIOpActyInstcePRTRegnAggrgn MaterialBaseUnit Valuation Unit
RegisteredPRTQtyInBaseUnit I_SFIOpActyInstcePRTRegnAggrgn RegisteredPRTQtyInBaseUnit
OrderProdnRsceToolText
ProdnRsceToolRegnIsAllowed Registrable
ManufacturingOrderCategory
ManufacturingOrderType
ProductionPlant Prod plnt
ProdnRsceToolItemNumber Item Number
BOOOperationPRTInternalID
ShopFloorRtgPRTIsRegistrable
PRTRegistrationControl
_OpActyNtwkInstance
_OperationActivityInstance I_SFIOpActyInstcePRTRegnAggrgn _OperationActivityInstance
_OrdInternalBillOfOperations I_SFIOpActyInstcePRTRegnAggrgn _OrdInternalBillOfOperations
_Material _Material
_Equipment _Equipment
_MfgOrderCategory
_MfgOrderType
_PRTRegistrationControl _PRTRegistrationControl

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 P_SFIOperationActivityPRTUnion.
-- 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 P_SFIOperationActivityPRTUnion AS
SELECT
  SFIOperationActivityPlndPRT.OpActyNtwkInstance AS OpActyNtwkInstance,
  SFIOperationActivityPlndPRT.OpActyNtwkElement AS OpActyNtwkElement,
  SFIOperationActivityPlndPRT.OrderInternalID AS OrderInternalID,
  SFIOperationActivityPlndPRT.MfgOrderOpProdnRsceToolIntID AS MfgOrderOpProdnRsceToolIntID,
  SFIOperationActivityPlndPRT.Equipment AS Equipment,
  SFIOperationActivityPlndPRT.ProductionResourceType AS ProductionResourceType,
  SFIOperationActivityPlndPRT.ProductionResourceInternalID AS ProductionResourceInternalID,
  SFIOperationActivityPlndPRT.ShopFloorItem AS ShopFloorItem,
  SFIOperationActivityPlndPRT.PRTIsUsedAsTestEquipment AS PRTIsUsedAsTestEquipment,
  SFIOperationActivityPlndPRT.ProdnRsceToolCategory AS ProdnRsceToolCategory,
  SFIOperationActivityPlndPRT.Material AS Material,
  SFIOperationActivityPlndPRT.DocumentType AS DocumentType,
  SFIOperationActivityPlndPRT.DocumentInfoRecord AS DocumentInfoRecord,
  SFIOperationActivityPlndPRT.DocumentVersion AS DocumentVersion,
  SFIOperationActivityPlndPRT.DocumentPart AS DocumentPart,
  SFIOperationActivityPlndPRT.MiscProductionResourceTool AS MiscProductionResourceTool,
  SFIOperationActivityPlndPRT.ProdnRsceToolStdWorkQtyUnit AS ProdnRsceToolStdWorkQtyUnit,
  SFIOperationActivityPlndPRT.ProdnRsceToolStandardWorkQty AS ProdnRsceToolStandardWorkQty,
  SFIOperationActivityPlndPRT.PlannedProdnRsceToolQtyUnit AS PlannedProdnRsceToolQtyUnit,
  SFIOperationActivityPlndPRT.PlannedTotalProdnRsceToolQty AS PlannedTotalProdnRsceToolQty,
  SFIOperationActivityPlndPRT.NumberOfActvEquipRegistrations AS NumberOfActvEquipRegistrations,
  SFIOperationActivityPlndPRT.BaseUnit AS BaseUnit,
  SFIOperationActivityPlndPRT.RegisteredPRTQtyInBaseUnit AS RegisteredPRTQtyInBaseUnit,
  SFIOperationActivityPlndPRT.OrderProdnRsceToolText AS OrderProdnRsceToolText,
  SFIOperationActivityPlndPRT.ProdnRsceToolRegnIsAllowed AS ProdnRsceToolRegnIsAllowed,
  SFIOperationActivityPlndPRT.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  SFIOperationActivityPlndPRT.ManufacturingOrderType AS ManufacturingOrderType,
  SFIOperationActivityPlndPRT.ProductionPlant AS ProductionPlant,
  SFIOperationActivityPlndPRT.ProdnRsceToolItemNumber AS ProdnRsceToolItemNumber,
  SFIOperationActivityPlndPRT.BOOOperationPRTInternalID AS BOOOperationPRTInternalID,
  SFIOperationActivityPlndPRT.ShopFloorRtgPRTIsRegistrable AS ShopFloorRtgPRTIsRegistrable,
  SFIOperationActivityPlndPRT.PRTRegistrationControl AS PRTRegistrationControl,
  SFIOperationActivityPlndPRT._OperationActivityInstance AS _OperationActivityInstance,
  SFIOperationActivityPlndPRT._OrdInternalBillOfOperations AS _OrdInternalBillOfOperations,
  SFIOperationActivityPlndPRT._Material AS _Material,
  SFIOperationActivityPlndPRT._Equipment AS _Equipment,
  SFIOperationActivityPlndPRT._MfgOrderCategory AS _MfgOrderCategory,
  SFIOperationActivityPlndPRT._MfgOrderType AS _MfgOrderType,
  SFIOperationActivityPlndPRT._PRTRegistrationControl AS OpActyNtwkInstanceasOpActyNtwkInstance
FROM P_SFIOperationActivityPlndPRT AS SFIOperationActivityPlndPRT
INNER JOIN I_EquipmentPRTByInternalKey AS EquipmentPRTByInternalKey ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Equipment AS _Equipment ON Equipment = _Equipment.Equipment  -- association [0..1]
LEFT OUTER JOIN I_PRTRegistrationControl AS _PRTRegistrationControl ON PRTRegistrationControl = _PRTRegistrationControl.PRTRegistrationControl  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
-- UNION ALL with additional select branch(es): I_OpActyInstceEquipActvRegn, I_SFIOpActyInstcePRTRegnAggrgn
;

Learn More