C_ShopFloorOrderSFI

DDL: C_SHOPFLOORORDERSFI Type: view CONSUMPTION Package: MPE_EXEC_COMMON
16 Fields 1 Data Sources

Serial Numbers of a Shop Floor Order

C_ShopFloorOrderSFI is a Consumption CDS View that provides data about "Serial Numbers of a Shop Floor Order" in SAP S/4HANA. It reads from 1 data source (I_ShopFloorItemGenealogy) and exposes 16 fields with key field ShopFloorItem. Part of development package MPE_EXEC_COMMON.

Data Sources (1)

SourceAliasJoin Type
I_ShopFloorItemGenealogy I_ShopFloorItemGenealogy from

Annotations (11)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName CMPESFOSFI view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Serial Numbers of a Shop Floor Order view
Metadata.allowExtensions true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ShopFloorItem ShopFloorItem Serial.Mat. ID
OriginalReplacedShopFloorItem OriginalReplacedShopFloorItem
ShopFloorItemExternalID ShopFloorItemExternalID
ManufacturingOrder ManufacturingOrder Order
ManufacturingOrderItem ManufacturingOrderItem Manufacturing Order Item
Material Material Vehicle Model
CreationDateTime CreationDateTime Timestamp
SerialNumber SerialNumber Serial Number
ShopFloorItemProductionStatus ShopFloorItemProductionStatus
SFIProductionStatusName
ReplacedShopFloorItem ReplacedShopFloorItem
_Equipment _Equipment
_LogisticsOrder _LogisticsOrder
_Material _Material
_MfgOrder _MfgOrder
_SFIProductionStatus _SFIProductionStatus

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_ShopFloorOrderSFI.
-- 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 C_ShopFloorOrderSFI AS
SELECT
  ShopFloorItem,
  OriginalReplacedShopFloorItem,
  ShopFloorItemExternalID,
  ManufacturingOrder,
  ManufacturingOrderItem,
  Material,
  CreationDateTime,
  SerialNumber,
  ShopFloorItemProductionStatus,
  _SFIProductionStatus._Text[1: Language=$session.system_language].SFIProductionStatusName AS SFIProductionStatusName,
  ReplacedShopFloorItem
FROM I_ShopFloorItemGenealogy
;

Learn More