I_MfgOrderMfgExecDistrInfo

DDL: I_MFGORDERMFGEXECDISTRINFO SQL: IMFGORDDISTRINFO Type: view BASIC

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.

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

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MFGORDERBASIC",
"AFDIST"
],
"ASSOCIATED":
[
"I_MFGORDERTYPE"
],
"BASE":
[
"I_MFGORDERBASIC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More