P_ProdOrdMgmtOpBasic

DDL: P_PRODORDMGMTOPBASIC Type: view_entity BASIC Package: ODATA_MPE_MFGORDER

Production Order Operations Basic View (AFVC)

P_ProdOrdMgmtOpBasic is a Basic CDS View that provides data about "Production Order Operations Basic View (AFVC)" in SAP S/4HANA. It reads from 2 data sources (afvv, I_LogisticsOrder) and exposes 43 fields with key fields aufpl, aplzl. Part of development package ODATA_MPE_MFGORDER.

2 data source(s) 43 fields

Data Sources (2)

SourceAliasJoin Type
afvv afvv inner
I_LogisticsOrder aufv inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED 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 (43)

KeyFieldSource TableSource FieldDescription
KEY aufpl afvc aufpl
KEY aplzl afvc aplzl
ManufacturingOrder 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 
//@EndUserText.label: 'Production Order Operations Basic View (AFVC)'

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

      aufv.OrderID                          as ManufacturingOrder,
      aufv.OrderCategory                    as ManufacturingOrderCategory,
      aufv.OrderType                        as ManufacturingOrderType,
      aufv.Plant                            as ProductionPlant,
      aufv.ProductionSupervisor             as 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
}
where
  ( afvc.plnty <> 'R'
    and afvc.plnty <> '3' );

Learn More