C_SFIOutputControlParameter

DDL: C_SFIOUTPUTCONTROLPARAMETER Type: view_entity CONSUMPTION
15 Fields 2 Data Sources 1 Associations

Shop Floor Item Output Control Param

C_SFIOutputControlParameter is a Consumption CDS View that provides data about "Shop Floor Item Output Control Param" in SAP S/4HANA. It reads from 2 data sources (I_LogisticsOrder, I_ShopFloorItem) and exposes 15 fields with key field ShopFloorItemConverted. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_LogisticsOrder LogisticsOrder inner
I_ShopFloorItem ShopFloorItem from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ShopFloorItem _ShopFloorItem _ShopFloorItem.ShopFloorItem = $projection.ShopFloorItem

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Shop Floor Item Output Control Param view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY ShopFloorItemConverted
ShopFloorItem I_ShopFloorItem ShopFloorItem Serial.Mat. ID
Material I_ShopFloorItem Material Vehicle Model
SerialNumber I_ShopFloorItem SerialNumber Serial Number
ProductionPlant
ShopFloorItemExternalID I_ShopFloorItem ShopFloorItemExternalID SFI Number
ManufacturingOrder I_ShopFloorItem ManufacturingOrder Order
ManufacturingOrderItem I_ShopFloorItem ManufacturingOrderItem Manufacturing Order Item
ShopFloorItemProductionStatus I_ShopFloorItem ShopFloorItemProductionStatus Production Status
ReplacedShopFloorItem I_ShopFloorItem ReplacedShopFloorItem ID of Replaced Matl
_ShopFloorItem _ShopFloorItem
_Material I_ShopFloorItem _Material
_MfgOrder I_ShopFloorItem _MfgOrder
_SFIProductionStatus I_ShopFloorItem _SFIProductionStatus
_Equipment I_ShopFloorItem _Equipment

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_SFIOutputControlParameter.
-- 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_SFIOutputControlParameter AS
SELECT
  cast(ShopFloorItem.ShopFloorItem as mpe_sfi_id_char) AS ShopFloorItemConverted,
  ShopFloorItem.ShopFloorItem AS ShopFloorItem,
  ShopFloorItem.Material AS Material,
  ShopFloorItem.SerialNumber AS SerialNumber,
  cast(LogisticsOrder.Plant as pwwrk preserving type) AS ProductionPlant,
  ShopFloorItem.ShopFloorItemExternalID AS ShopFloorItemExternalID,
  ShopFloorItem.ManufacturingOrder AS ManufacturingOrder,
  ShopFloorItem.ManufacturingOrderItem AS ManufacturingOrderItem,
  ShopFloorItem.ShopFloorItemProductionStatus AS ShopFloorItemProductionStatus,
  ShopFloorItem.ReplacedShopFloorItem AS ReplacedShopFloorItem,
  ShopFloorItem._Material AS _Material,
  ShopFloorItem._MfgOrder AS _MfgOrder,
  ShopFloorItem._SFIProductionStatus AS _SFIProductionStatus,
  ShopFloorItem._Equipment AS _Equipment
FROM I_ShopFloorItem AS ShopFloorItem
INNER JOIN I_LogisticsOrder AS LogisticsOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ShopFloorItem AS _ShopFloorItem ON _ShopFloorItem.ShopFloorItem = ShopFloorItem  -- association [1..1]
;

Learn More