P_MfgOrderOperationConf

DDL: P_MFGORDEROPERATIONCONF Type: view_entity BASIC Package: VDM_PP_CNF

Private MfgOrderOperationConfirmation view

P_MfgOrderOperationConf is a Basic CDS View that provides data about "Private MfgOrderOperationConfirmation 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. Part of development package VDM_PP_CNF.

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 (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED 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 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #M, dataClass: #TRANSACTIONAL}
@VDM.viewType: #BASIC
@VDM.private: true

define view entity 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' );

Learn More