P_MfgOrder

DDL: P_MFGORDER SQL: PPPMFGORDER Type: view BASIC Package: PPH_ANALYTICS

Manufacturing Order Header

P_MfgOrder is a Basic CDS View that provides data about "Manufacturing Order Header" in SAP S/4HANA. It reads from 1 data source (caufv) and exposes 13 fields with key field ManufacturingOrder. Part of development package PPH_ANALYTICS.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
caufv aufv from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PPPMFGORDER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.private true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ManufacturingOrder caufv aufnr
MfgOrderPlannedStartDate caufv gstrp
MfgOrderPlannedStartTime caufv gsuzp
MfgOrderPlannedEndDate caufv gltrp
MfgOrderPlannedEndTime caufv gluzp
MfgOrderScheduledStartDate caufv gstrs
MfgOrderScheduledStartTime caufv gsuzs
MfgOrderScheduledEndDate caufv gltrs
MfgOrderScheduledEndTime caufv gluzs
MfgOrderActualStartDate caufv gstri
MfgOrderActualStartTime caufv gsuzi
MfgOrderConfirmedEndDate caufv getri
MfgOrderConfirmedEndTime caufv geuzi 
@AbapCatalog.sqlViewName: 'PPPMFGORDER'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #BASIC
@VDM.private: true

define view P_MfgOrder
// used for AMDP method (Table Function) determine_ord_duration_in_sec

  as select from caufv as aufv
{
      // Key

  key aufv.aufnr as ManufacturingOrder,

      // Dates and Times

      aufv.gstrp as MfgOrderPlannedStartDate,
      aufv.gsuzp as MfgOrderPlannedStartTime,

      aufv.gltrp as MfgOrderPlannedEndDate,
      aufv.gluzp as MfgOrderPlannedEndTime,

      aufv.gstrs as MfgOrderScheduledStartDate,
      aufv.gsuzs as MfgOrderScheduledStartTime,

      aufv.gltrs as MfgOrderScheduledEndDate,
      aufv.gluzs as MfgOrderScheduledEndTime,

      aufv.gstri as MfgOrderActualStartDate,
      aufv.gsuzi as MfgOrderActualStartTime,

      aufv.getri as MfgOrderConfirmedEndDate,
      aufv.geuzi as MfgOrderConfirmedEndTime   
}
where
  (    aufv.autyp = '10'
    or aufv.autyp = '40' //Manufacturing orders only

  );

Learn More