P_ProcOrdMgmtOpBasic

DDL: P_PROCORDMGMTOPBASIC SQL: PPORMFMTOPBASIC Type: view BASIC Package: VDM_PP_PROC_ORD_MNG

Process order operation basic (afvc)

P_ProcOrdMgmtOpBasic is a Basic CDS View that provides data about "Process order operation basic (afvc)" in SAP S/4HANA. It reads from 2 data sources (afvv, I_LogisticsOrder) and exposes 46 fields with key fields aufpl, aplzl. Part of development package VDM_PP_PROC_ORD_MNG.

2 data source(s) 46 fields

Data Sources (2)

SourceAliasJoin Type
afvv afvv inner
I_LogisticsOrder aufv inner

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PPORMFMTOPBASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #CLIENT_DEPENDENT view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.private true view

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY aufpl afvc aufpl
KEY aplzl afvc aplzl
ProcessOrder I_LogisticsOrder OrderID
ManufacturingOrderCategory I_LogisticsOrder OrderCategory
ManufacturingOrderType I_LogisticsOrder OrderType
ProductionPlant I_LogisticsOrder Plant
ProductionSupervisor I_LogisticsOrder ProductionSupervisor
aplfl afvc aplfl
vornr afvc vornr
ltxa1 afvc ltxa1
txtsp afvc txtsp
plnfl afvc plnfl
plnty afvc plnty
plnnr afvc plnnr
plnal afvc plnal
plnkn afvc plnkn
tl_versn afvc tl_versn
istty afvc istty
istnr afvc istnr
istkn afvc istkn
istpo afvc istpo
sumnr afvc sumnr
arbid afvc arbid
arbty
werks afvc werks
objnr afvc objnr
pvzkn afvc pvzkn
phflg afvc phflg
meinh afvv meinh
mgvrg afvv mgvrg
asvrg afvv asvrg
lmnga afvv lmnga
xmnga afvv xmnga
fsedd afvv fsedd
fsedz afvv fsedz
ssavd afvv ssavd
ssavz afvv ssavz
ssedd afvv ssedd
ssedz afvv ssedz
isdd afvv isdd
isdz afvv isdz
iedd afvv iedd
iedz afvv iedz
OpPlannedYieldQuantity
ScheduledBasicStartDate I_LogisticsOrder ScheduledBasicStartDate
ScheduledBasicEndDate I_LogisticsOrder ScheduledBasicEndDate 
@AbapCatalog.sqlViewName: 'PPORMFMTOPBASIC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'Process order operation basic (afvc)'

@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ClientHandling.type: #CLIENT_DEPENDENT
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #BASIC
@VDM.private: true
define view P_ProcOrdMgmtOpBasic
  as select from( 
                 afvc as afvc
      inner join I_LogisticsOrder         as aufv     on  afvc.aufpl         = aufv.OrderInternalBillOfOperations
                                                      and aufv.OrderCategory = '40'
      inner join afvv             as afvv on  afvc.aufpl = afvv.aufpl
                                          and afvc.aplzl = afvv.aplzl
  )
{
  key afvc.aufpl,
  key afvc.aplzl,

      aufv.OrderID                                 as ProcessOrder,
      aufv.OrderCategory                           as ManufacturingOrderCategory,
      aufv.OrderType                               as ManufacturingOrderType,
      aufv.Plant                                   as ProductionPlant,
      aufv.ProductionSupervisor,

      // AFVC data

      afvc.aplfl,
      afvc.vornr,
      afvc.ltxa1,
      afvc.txtsp,

      afvc.plnfl,
      afvc.plnty,
      afvc.plnnr,
      afvc.plnal,
      afvc.plnkn,
      afvc.tl_versn,

      afvc.istty,
      afvc.istnr,
      afvc.istkn,
      afvc.istpo,

      afvc.sumnr,
      afvc.arbid,
      'A'                                          as arbty,
      afvc.werks,

      afvc.objnr,
      afvc.pvzkn,
      afvc.phflg,


      // AFVV data

      afvv.meinh,

      afvv.mgvrg,
      afvv.asvrg,
      afvv.lmnga,
      afvv.xmnga,

      afvv.fsedd,
      afvv.fsedz,

      afvv.ssavd,
      afvv.ssavz,

      afvv.ssedd,
      afvv.ssedz,

      afvv.isdd,
      afvv.isdz,

      afvv.iedd,
      afvv.iedz,

      cast((afvv.mgvrg - afvv.asvrg) as vdm_gmeng) as OpPlannedYieldQuantity,
      
      //Expose Start and End dates to push-down filters to associations

      aufv.ScheduledBasicStartDate,
      aufv.ScheduledBasicEndDate
}
where
  (
    afvc.plnty = '2'
  );

Learn More