C_ShopFloorItemOperation

DDL: C_SHOPFLOORITEMOPERATION SQL: CMPESFIOPER Type: view CONSUMPTION Package: MPE_EXEC_SFI
24 Fields 2 Data Sources 2 Associations

Shop Floor Item Operation

C_ShopFloorItemOperation is a Consumption CDS View that provides data about "Shop Floor Item Operation" in SAP S/4HANA. It reads from 2 data sources (I_MfgOrderOperationBasic, I_ShopFloorItem) and exposes 24 fields with key fields OrderInternalID, OrderOperationInternalID. It has 2 associations to related views. Part of development package MPE_EXEC_SFI.

Data Sources (2)

SourceAliasJoin Type
I_MfgOrderOperationBasic MfgOrderOperation inner
I_ShopFloorItem ShopFloorItem from

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_ShopFloorItemOperationActy _ShopFloorItemOperationActy $projection.ShopFloorItem = _ShopFloorItemOperationActy.ShopFloorItem and $projection.OrderInternalID = _ShopFloorItemOperationActy.OrderInternalID and $projection.OrderOperationInternalID = _ShopFloorItemOperationActy.OrderOperationInternalID
[0..*] I_MfgOrderOpDocInfoRecdObjLink _MfgOrderOpDocInfoRecdObjLink $projection.ManufacturingOrder = _MfgOrderOpDocInfoRecdObjLink.ManufacturingOrder and $projection.OrderOperationInternalID = _MfgOrderOpDocInfoRecdObjLink.OrderOperationInternalID

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CMPESFIOPER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
Metadata.allowExtensions true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
UI.headerInfo.typeName Shop Floor Item Operation view
UI.headerInfo.typeNamePlural Shop Floor Item Operations view
UI.headerInfo.title.label Shop Floor Item Operation view
UI.presentationVariant.sortOrder.by ManufacturingOrderOperation view
UI.presentationVariant.sortOrder.direction #ASC view
UI.textArrangement #TEXT_LAST view
EndUserText.label Shop Floor Item Operation view

Fields (24)

KeyFieldSource TableSource FieldDescription
ShopFloorItem
KEY OrderInternalID I_MfgOrderOperationBasic OrderInternalBillOfOperations Order Internal Bill of Operations
KEY OrderOperationInternalID I_MfgOrderOperationBasic OrderIntBillOfOperationsItem Order Internal Bill of Operations Item
ShopFloorItemExternalID
SerialNumber I_ShopFloorItem SerialNumber Serial Number
ManufacturingOrderOperation
MfgOrderOperationText I_MfgOrderOperationBasic MfgOrderOperationText Description
Material
MaterialName
OperationControlProfile I_MfgOrderOperationBasic OperationControlProfile Control Key
OperationControlProfileName
WorkCenterInternalID I_MfgOrderOperationBasic WorkCenterInternalID Work Center
WorkCenterTypeCode I_MfgOrderOperationBasic WorkCenterTypeCode_2
WorkCenter
OpActyNtwkInstance I_MfgOrderOperationBasic ProduceOpActyNtwkInstance
ProductionPlant I_MfgOrderOperationBasic ProductionPlant Prod plnt
_ShopFloorItemOperationActy _ShopFloorItemOperationActy
_OperationControlProfile _OperationControlProfile
_OrdInternalBillOfOperations _OrdInternalBillOfOperations
_MfgOrder I_ShopFloorItem _MfgOrder
_Material _Material
_WorkCenter _WorkCenter
_WorkCenterType _WorkCenterType
_MfgOrderOpDocInfoRecdObjLink _MfgOrderOpDocInfoRecdObjLink

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 C_ShopFloorItemOperation.
-- 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.
-- SQL view name: CMPESFIOPER

CREATE VIEW C_ShopFloorItemOperation AS
SELECT
  MfgOrderOperation.OrderInternalBillOfOperations AS OrderInternalID,
  MfgOrderOperation.OrderIntBillOfOperationsItem AS OrderOperationInternalID,
  ShopFloorItem.SerialNumber AS SerialNumber,
  MfgOrderOperation.MfgOrderOperationText AS MfgOrderOperationText,
  ShopFloorItem._Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  MfgOrderOperation.OperationControlProfile AS OperationControlProfile,
  MfgOrderOperation._OperationControlProfile._Text[1: Language=$session.system_language].OperationControlProfileName AS OperationControlProfileName,
  MfgOrderOperation.WorkCenterInternalID AS WorkCenterInternalID,
  MfgOrderOperation.WorkCenterTypeCode_2 AS WorkCenterTypeCode,
  MfgOrderOperation._WorkCenter.WorkCenter AS WorkCenter,
  MfgOrderOperation.ProduceOpActyNtwkInstance AS OpActyNtwkInstance,
  MfgOrderOperation.ProductionPlant AS ProductionPlant,
  ShopFloorItem._MfgOrder AS _MfgOrder
FROM I_ShopFloorItem AS ShopFloorItem
INNER JOIN I_MfgOrderOperationBasic AS MfgOrderOperation ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_ShopFloorItemOperationActy AS _ShopFloorItemOperationActy ON ShopFloorItem = _ShopFloorItemOperationActy.ShopFloorItem AND OrderInternalID = _ShopFloorItemOperationActy.OrderInternalID AND OrderOperationInternalID = _ShopFloorItemOperationActy.OrderOperationInternalID  -- association [0..*]
LEFT OUTER JOIN I_MfgOrderOpDocInfoRecdObjLink AS _MfgOrderOpDocInfoRecdObjLink ON ManufacturingOrder = _MfgOrderOpDocInfoRecdObjLink.ManufacturingOrder AND OrderOperationInternalID = _MfgOrderOpDocInfoRecdObjLink.OrderOperationInternalID  -- association [0..*]
;

Learn More