P_SFIConfTimeTotals

DDL: P_SFICONFTIMETOTALS SQL: PMPESFICNFT Type: view COMPOSITE Package: MPE_EXEC_ANALYTICS
40 Fields 1 Data Sources 3 Associations

SFI Confirmation Time Totals

P_SFIConfTimeTotals is a Composite CDS View that provides data about "SFI Confirmation Time Totals" in SAP S/4HANA. It reads from 1 data source (P_SFIConfirmation) and exposes 40 fields with key field ShopFloorItem. It has 3 associations to related views. Part of development package MPE_EXEC_ANALYTICS.

Data Sources (1)

SourceAliasJoin Type
P_SFIConfirmation SFIConfirmation from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_Plant _ProductionPlant $projection.ProductionPlant = _ProductionPlant.Plant
[0..1] I_Plant _Plant $projection.ProductionPlant = _Plant.Plant
[1..1] I_OpActyNtwkElement _OpActyNetworkElmnt SFIConfirmation.OperationActivityNetwork = _OpActyNetworkElmnt.OperationActivityNetwork and SFIConfirmation.OpActyNtwkVersionCounter = _OpActyNetworkElmnt.OpActyNtwkVersionCounter and SFIConfirmation.OpActyNtwkElement = _OpActyNetworkElmnt.OpActyNtwkElement

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PMPESFICNFT view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY ShopFloorItem ShopFloorItem Serial.Mat. ID
OpActyNtwkInstance OpActyNtwkInstance Instance ID
OpActyNtwkElementElmntVersCntr _OpActyNetworkElmnt OpActyNtwkElementElmntVersCntr OA Version
OpActyNtwkElementExternalID _OpActyNetworkElmnt OpActyNtwkElementExternalID Op. Activity
OpActyNtwkElementType _OpActyNetworkElmnt OpActyNtwkElementType
OpActyNtwkElementElement _OpActyNetworkElmnt OpActyNtwkElementElement Operation Activity
OperationActivity
OperationActyVersionCounter
OperationActivityNetwork P_SFIConfirmation OperationActivityNetwork
OpActyNtwkVersionCounter P_SFIConfirmation OpActyNtwkVersionCounter
OpActyNtwkElement P_SFIConfirmation OpActyNtwkElement Element Number
ManufacturingOrder MfgOrdOp ManufacturingOrder Order
Material Material Vehicle Model
ProductionPlant
ShopFloorItemExternalID ShopFloorItemExternalID
SerialNumber SerialNumber Serial Number
OrderOperationInternalID OrdOpBasic OrderOperationInternalID
WorkCenterTypeCode
WorkCenter
Plant
WorkCenterInternalID MfgOrdOp WorkCenterInternalID Work Center
WorkCenterCategoryCode
OrderInternalBillOfOperations MfgOrdOp OrderInternalBillOfOperations Order Internal Bill of Operations
OrderIntBillOfOperationsItem MfgOrdOp OrderIntBillOfOperationsItem Order Internal Bill of Operations Item
Operation OrdOpBasic Operation Transaction
OperationText OrdOpBasic OperationText Description
DurationUnit P_SFIConfirmation DurationUnit Unit
LeadTimeUnit ConfUoM LeadTimeUnit
OverallProductionTimeUnit ConfUoM OverallProductionTimeUnit
_ShopFloorItem _ShopFloorItem
_OpActyNtwkInstance _OpActyNtwkInstance
_WorkCenter
_WorkCenterType
_MfgOrder _MfgOrder
_ProductionPlant _ProductionPlant
_Plant _Plant
_OperationActivity _OpActyNetworkElmnt _OperationActivity
_OperationActivityInternalId
_OperationActivityText _OpActyNetworkElmnt _OperationActivityText
_OrdInternalBillOfOperations _OrdInternalBillOfOperations

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_SFIConfTimeTotals.
-- 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: PMPESFICNFT

CREATE VIEW P_SFIConfTimeTotals AS
SELECT
  ShopFloorItem,
  OpActyNtwkInstance,
  _OpActyNetworkElmnt.OpActyNtwkElementElmntVersCntr AS OpActyNtwkElementElmntVersCntr,
  _OpActyNetworkElmnt.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
  _OpActyNetworkElmnt.OpActyNtwkElementType AS OpActyNtwkElementType,
  _OpActyNetworkElmnt.OpActyNtwkElementElement AS OpActyNtwkElementElement,
  _OpActyNetworkElmnt._OperationActivity.OperationActivity AS OperationActivity,
  _OpActyNetworkElmnt._OperationActivity.OperationActyVersionCounter AS OperationActyVersionCounter,
  SFIConfirmation.OperationActivityNetwork AS OperationActivityNetwork,
  SFIConfirmation.OpActyNtwkVersionCounter AS OpActyNtwkVersionCounter,
  SFIConfirmation.OpActyNtwkElement AS OpActyNtwkElement,
  MfgOrdOp.ManufacturingOrder AS ManufacturingOrder,
  Material,
  SFIConfirmation._OpActyNtwkInstance._MfgOrder.ProductionPlant AS ProductionPlant,
  ShopFloorItemExternalID,
  SerialNumber,
  OrdOpBasic.OrderOperationInternalID AS OrderOperationInternalID,
  MfgOrdOp._WorkCenter.WorkCenterTypeCode AS WorkCenterTypeCode,
  MfgOrdOp._WorkCenter.WorkCenter AS WorkCenter,
  MfgOrdOp._WorkCenter.Plant AS Plant,
  MfgOrdOp.WorkCenterInternalID AS WorkCenterInternalID,
  SFIConfirmation._OpActyNtwkInstance._MfgOrderOperation._WorkCenter._WorkCenter.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  MfgOrdOp.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  MfgOrdOp.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  OrdOpBasic.Operation AS Operation,
  OrdOpBasic.OperationText AS OperationText,
  SFIConfirmation.DurationUnit AS DurationUnit,
  ConfUoM.LeadTimeUnit AS LeadTimeUnit,
  ConfUoM.OverallProductionTimeUnit AS OverallProductionTimeUnit,
  MfgOrdOp._WorkCenter._WorkCenter AS _WorkCenter,
  MfgOrdOp._WorkCenter._WorkCenterType AS _WorkCenterType,
  _OpActyNetworkElmnt._OperationActivity AS _OperationActivity,
  _OpActyNetworkElmnt._OperationActivity._OperationActivityInternalId AS _OperationActivityInternalId,
  _OpActyNetworkElmnt._OperationActivityText AS _OperationActivityText
FROM P_SFIConfirmation AS SFIConfirmation
LEFT OUTER JOIN I_Plant AS _ProductionPlant ON ProductionPlant = _ProductionPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON ProductionPlant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_OpActyNtwkElement AS _OpActyNetworkElmnt ON SFIConfirmation.OperationActivityNetwork = _OpActyNetworkElmnt.OperationActivityNetwork AND SFIConfirmation.OpActyNtwkVersionCounter = _OpActyNetworkElmnt.OpActyNtwkVersionCounter AND SFIConfirmation.OpActyNtwkElement = _OpActyNetworkElmnt.OpActyNtwkElement  -- association [1..1]
;

Learn More