P_MfgOrderOperationConf

DDL: P_MFGORDEROPERATIONCONF SQL: PPPMFGORDOPCONF Type: view BASIC

P_MfgOrderOperationConf is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (afru) and exposes 10 fields with key fields MfgOrderConfirmation, MfgOrderConfirmationCount. It has 1 association to related views.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
afru afru from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Plant _Plant $projection.Plant = _Plant.Plant

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PPPMFGORDOPCONF 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 #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.private true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY MfgOrderConfirmation afru rueck
KEY MfgOrderConfirmationCount afru rmzhl
Plant afru werks
FactoryCalendar _Plant FactoryCalendar
WorkCenter crhd arbpl
WorkCenterInternalID afru arbid
ConfirmationEntryDate afru ersda
ConfirmationEntryTime afru erzet
EnteredByUser afru ernam
_Plant _Plant 
@AbapCatalog.sqlViewName: 'PPPMFGORDOPCONF'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #M, dataClass: #TRANSACTIONAL}
@VDM.viewType: #BASIC
@VDM.private: true

define view P_MfgOrderOperationConf
// used for AMDP method (Table Function) "get_previous_workday"

  as select from           afru as afru
    left outer to one join crhd as crhd on  crhd.objid = afru.arbid
                                        and crhd.objty = 'A'

  association [1..1] to I_Plant as _Plant on $projection.Plant = _Plant.Plant
{
      // Key

  key afru.rueck as MfgOrderConfirmation,
  key afru.rmzhl as MfgOrderConfirmationCount,

      // Assignments

      afru.werks as Plant,
      _Plant.FactoryCalendar as FactoryCalendar,
      crhd.arbpl as WorkCenter,
      afru.arbid as WorkCenterInternalID,

      // Admin

      afru.ersda as ConfirmationEntryDate,
      afru.erzet as ConfirmationEntryTime,
      afru.ernam as EnteredByUser,

      // Associations

      _Plant
}
  where afru.aplzl > '00000000' and //Conf. on oper. level only

      ( afru.orind = '2' or         //Manufacturing orders only

        afru.orind = '6' );        
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PLANT",
"AFRU",
"CRHD"
],
"ASSOCIATED":
[
"I_PLANT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More