P_SFIAtOpActyTestEquipPRTUnion

DDL: P_SFIATOPACTYTESTEQUIPPRTUNION Type: view_entity CONSUMPTION
21 Fields 10 Data Sources 1 Associations

P_SFIAtOpActyTestEquipPRTUnion is a Consumption CDS View in SAP S/4HANA. It reads from 10 data sources and exposes 21 fields with key fields ShopFloorItem, OpActyNtwkElement, OpActyNtwkInstance, Equipment, OpActyNtwkElement. It has 1 association to related views.

Data Sources (10)

SourceAliasJoin Type
I_Equipment Equipment inner
I_Equipment Equipment inner
I_EquipmentPRTByInternalKey EquipmentPRT inner
I_EquipmentPRTByInternalKey EquipmentPRT inner
I_MaterialPRTByInternalKey MaterialPRT inner
I_MfgOrderPRTAssignmentDetail MfgOrderPRTAssignmentDet inner
I_MfgOrderPRTAssignmentDetail MfgOrderPRTAssignmentDet inner
I_OperationActyPRTAssignment OpActyPRTAssignment from
I_ShopFloorItemStatus ShopFloorItemStatus inner
I_ShopFloorItemStatus ShopFloorItemStatus inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_OpActyNtwkInstance _OpActyNtwkInstance $projection.OpActyNtwkInstance = _OpActyNtwkInstance.OpActyNtwkInstance

Annotations (7)

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

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY ShopFloorItem I_ShopFloorItemStatus ShopFloorItem Serial.Mat. ID
KEY OpActyNtwkElement I_OperationActyPRTAssignment OpActyNtwkElement Element Number
KEY OpActyNtwkInstance I_OperationActyPRTAssignment OpActyNtwkInstance Instance ID
KEY Equipment I_MfgOrderPRTAssignmentDetail Equipment Equipment check
Material I_MfgOrderPRTAssignmentDetail Material Vehicle Model
ShopFloorItemasShopFloorItem
KEY OpActyNtwkElement OpActyInstceEquipActvRegn OpActyNtwkElement Element Number
KEY OpActyNtwkInstance OpActyInstceEquipActvRegn OpActyNtwkInstance Instance ID
KEY Equipment OpActyInstceEquipActvRegn Equipment Equipment check
Material OpActyInstceEquipActvRegn EquipmentMaterial Vehicle Model
ShopFloorItemasShopFloorItem
KEY OpActyNtwkElement I_OperationActyPRTAssignment OpActyNtwkElement Element Number
KEY OpActyNtwkInstance I_OperationActyPRTAssignment OpActyNtwkInstance Instance ID
KEY Equipment I_EquipmentPRTByInternalKey Equipment Equipment check
Material I_MfgOrderPRTAssignmentDetail Material Vehicle Model
ShopFloorItemasShopFloorItem
KEY OpActyNtwkElement SFIOpActyInstcePRTRegnAggrgn OpActyNtwkElement Element Number
KEY OpActyNtwkInstance SFIOpActyInstcePRTRegnAggrgn OpActyNtwkInstance Instance ID
KEY Equipment I_EquipmentPRTByInternalKey Equipment Equipment check
Material I_MaterialPRTByInternalKey Material Vehicle Model
Association_OpActyNtwkInstance

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_SFIAtOpActyTestEquipPRTUnion.
-- 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_SFIAtOpActyTestEquipPRTUnion AS
SELECT
  ShopFloorItemStatus.ShopFloorItem AS ShopFloorItem,
  OpActyPRTAssignment.OpActyNtwkElement AS OpActyNtwkElement,
  OpActyPRTAssignment.OpActyNtwkInstance AS OpActyNtwkInstance,
  MfgOrderPRTAssignmentDet.Equipment AS Equipment,
  MfgOrderPRTAssignmentDet.Material AS Material
FROM I_OperationActyPRTAssignment AS OpActyPRTAssignment
INNER JOIN I_ShopFloorItemStatus AS ShopFloorItemStatus ON /* join condition not captured in parsed metadata */
INNER JOIN I_MfgOrderPRTAssignmentDetail AS MfgOrderPRTAssignmentDet ON /* join condition not captured in parsed metadata */
INNER JOIN I_Equipment AS Equipment ON /* join condition not captured in parsed metadata */
INNER JOIN I_EquipmentPRTByInternalKey AS EquipmentPRT ON /* join condition not captured in parsed metadata */
INNER JOIN I_MaterialPRTByInternalKey AS MaterialPRT ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OpActyNtwkInstance AS _OpActyNtwkInstance ON OpActyNtwkInstance = _OpActyNtwkInstance.OpActyNtwkInstance  -- association [1..1]
;

Learn More