I_SFIAtOperationActivityBasic

DDL: I_SFIATOPERATIONACTIVITYBASIC Type: view_entity COMPOSITE
16 Fields 2 Data Sources

Basic data of a Shop Floor Item at an Operation Activity

I_SFIAtOperationActivityBasic is a Composite CDS View that provides data about "Basic data of a Shop Floor Item at an Operation Activity" in SAP S/4HANA. It reads from 2 data sources (I_OpActyNtwkElement, P_SFIAtOperationActivityBasic) and exposes 16 fields with key fields ShopFloorItem, OpActyNtwkInstance, OpActyNtwkElement.

Data Sources (2)

SourceAliasJoin Type
I_OpActyNtwkElement OpActyNtwkElement inner
P_SFIAtOperationActivityBasic SFIAtOperationActivityBasic from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Basic data of a Shop Floor Item at an Operation Activity view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ShopFloorItem P_SFIAtOperationActivityBasic ShopFloorItem Serial.Mat. ID
KEY OpActyNtwkInstance P_SFIAtOperationActivityBasic OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement P_SFIAtOperationActivityBasic OpActyNtwkElement Element Number
SerialNumber
Material
ManufacturingOrder
ManufacturingOrderItem
OrderInternalID P_SFIAtOperationActivityBasic OrderInternalID Plan No.f.Oper.
OrderOperationInternalID P_SFIAtOperationActivityBasic OrderOperationInternalID
ManufacturingOrderOperation P_SFIAtOperationActivityBasic ManufacturingOrderOperation Activity
OpActyNtwkSegmentType P_SFIAtOperationActivityBasic OpActyNtwkSegmentType
SFIIsInactiveAtOpActy P_SFIAtOperationActivityBasic SFIIsInactiveAtOpActy
OpActyNtwkElementExternalID I_OpActyNtwkElement OpActyNtwkElementExternalID Op. Activity
_ShopFloorItem P_SFIAtOperationActivityBasic _ShopFloorItem
_OpActyNtwkInstance P_SFIAtOperationActivityBasic _OpActyNtwkInstance
_OperationActivityInstance P_SFIAtOperationActivityBasic _OperationActivityInstance

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 I_SFIAtOperationActivityBasic.
-- 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 I_SFIAtOperationActivityBasic AS
SELECT
  SFIAtOperationActivityBasic.ShopFloorItem AS ShopFloorItem,
  SFIAtOperationActivityBasic.OpActyNtwkInstance AS OpActyNtwkInstance,
  SFIAtOperationActivityBasic.OpActyNtwkElement AS OpActyNtwkElement,
  SFIAtOperationActivityBasic._ShopFloorItem.SerialNumber AS SerialNumber,
  SFIAtOperationActivityBasic._ShopFloorItem.Material AS Material,
  SFIAtOperationActivityBasic._ShopFloorItem.ManufacturingOrder AS ManufacturingOrder,
  SFIAtOperationActivityBasic._ShopFloorItem.ManufacturingOrderItem AS ManufacturingOrderItem,
  SFIAtOperationActivityBasic.OrderInternalID AS OrderInternalID,
  SFIAtOperationActivityBasic.OrderOperationInternalID AS OrderOperationInternalID,
  SFIAtOperationActivityBasic.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  SFIAtOperationActivityBasic.OpActyNtwkSegmentType AS OpActyNtwkSegmentType,
  SFIAtOperationActivityBasic.SFIIsInactiveAtOpActy AS SFIIsInactiveAtOpActy,
  OpActyNtwkElement.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
  SFIAtOperationActivityBasic._ShopFloorItem AS _ShopFloorItem,
  SFIAtOperationActivityBasic._OpActyNtwkInstance AS _OpActyNtwkInstance,
  SFIAtOperationActivityBasic._OperationActivityInstance AS _OperationActivityInstance
FROM P_SFIAtOperationActivityBasic AS SFIAtOperationActivityBasic
INNER JOIN I_OpActyNtwkElement AS OpActyNtwkElement ON /* join condition not captured in parsed metadata */
;

Learn More