I_MfgOrderMfgExecDistrInfo

DDL: I_MFGORDERMFGEXECDISTRINFO SQL: IMFGORDDISTRINFO Type: view BASIC Package: CO_MES_INT

Distribution Information on Production Order

I_MfgOrderMfgExecDistrInfo is a Basic CDS View that provides data about "Distribution Information on Production Order" in SAP S/4HANA. It reads from 2 data sources (I_MfgOrderBasic, afdist) and exposes 6 fields with key field ManufacturingOrder. Part of development package CO_MES_INT.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
I_MfgOrderBasic aufv inner
afdist orderDistr from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMFGORDDISTRINFO view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK 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
EndUserText.label Distribution Information on Production Order view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ManufacturingOrder afdist pp_order
ManufacturingOrderCategory I_MfgOrderBasic ManufacturingOrderCategory
ManufacturingOrderType I_MfgOrderBasic ManufacturingOrderType
ProductionPlant I_MfgOrderBasic ProductionPlant
ProductionOrderDistributionSts afdist dist_status
_MfgOrderType _MfgOrderType 
@AbapCatalog.sqlViewName: 'IMFGORDDISTRINFO'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #BASIC
@EndUserText.label: 'Distribution Information on Production Order'
define view I_MfgOrderMfgExecDistrInfo 
  as select from afdist as orderDistr 
    inner join   I_MfgOrderBasic     as aufv on orderDistr.pp_order = aufv.ManufacturingOrder
 {
    key orderDistr.pp_order                     as ManufacturingOrder,
    
    aufv.ManufacturingOrderCategory             as ManufacturingOrderCategory,
    aufv.ManufacturingOrderType                 as ManufacturingOrderType,
    aufv.ProductionPlant                        as ProductionPlant,
    orderDistr.dist_status                      as ProductionOrderDistributionSts,
    
    
    // Associations

    _MfgOrderType
}
where
     aufv.ManufacturingOrderCategory = '10'
  or aufv.ManufacturingOrderCategory = '40'; //Manufacturing orders only

Learn More