MMIMProductionOrderVH

DDL: MMIMPRODUCTIONORDERVH SQL: MMIMPRODORDVH Type: view

Value Help for Production Plants

MMIMProductionOrderVH is a CDS View that provides data about "Value Help for Production Plants" in SAP S/4HANA. It reads from 1 data source (I_OrderItem) and exposes 13 fields with key fields OrderID, OrderItem. It has 2 associations to related views.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_OrderItem I_OrderItem from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_MaterialText _Text $projection.Material = _Text.Material and _Text.Language = $session.system_language
[1..1] I_OrderTypeText _OrderTypeText $projection.OrderType = _OrderTypeText.OrderType and _OrderTypeText.Language = $session.system_language

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName MMIMPRODORDVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.dataCategory #VALUE_HELP view
EndUserText.label Value Help for Production Plants view
Search.searchable true view
Consumption.ranked true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY OrderID OrderID
KEY OrderItem OrderItem
OrderType OrderType
OrderTypeName _OrderTypeText OrderTypeName
Material Material
MaterialName _Text MaterialName
PlannedPlant MRPPlant
PlannedPlantName _MRPPlant PlantName
ProductionPlant ProductionPlant
ProductionPlantName _ProductionPlant PlantName
PlannedStartDate _Order PlannedStartDate
PlannedEndDate _Order PlannedEndDate
OrderCategory OrderCategory 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'MMIMPRODORDVH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass:#MIXED
@AccessControl.personalData.blocking:#NOT_REQUIRED 
@ObjectModel.dataCategory:#VALUE_HELP
@EndUserText.label: 'Value Help for Production Plants'
@Search.searchable: true
@Consumption.ranked: true
define view MMIMProductionOrderVH as select from I_OrderItem
  
//association [1..1] to I_ProductPlant as _ProductPlant  on $projection.Material = _ProductPlant.Product

//                                                      and $projection.PlannedPlant = _ProductPlant.Plant     

        
association [1..1] to I_MaterialText as _Text on $projection.Material = _Text.Material
                                             and _Text.Language = $session.system_language
                                              
association [1..1] to I_OrderTypeText as _OrderTypeText on $projection.OrderType   = _OrderTypeText.OrderType 
                                                       and _OrderTypeText.Language = $session.system_language                                             
 { 
            @Search.defaultSearchElement: true
            @Search.fuzzinessThreshold: 0.8 
            @Search.ranking: #HIGH
        key OrderID,
        key OrderItem,
            @Search.defaultSearchElement: true
            @Search.fuzzinessThreshold: 0.8 
            @Search.ranking: #LOW
            OrderType,
            @Search.defaultSearchElement: true
            @Search.fuzzinessThreshold: 0.8
            @Search.ranking: #LOW 
            _OrderTypeText.OrderTypeName as OrderTypeName,
            @Search.defaultSearchElement: true
            @Search.fuzzinessThreshold: 0.8 
            @Search.ranking: #LOW
            Material,
            @Search.defaultSearchElement: true
            @Search.fuzzinessThreshold: 0.8 
            @Search.ranking: #LOW
            _Text.MaterialName as MaterialName,
            @Search.defaultSearchElement: true
            @Search.fuzzinessThreshold: 0.8
            @Search.ranking: #LOW
            MRPPlant as PlannedPlant,
            @Search.defaultSearchElement: true
            @Search.fuzzinessThreshold: 0.8
            @Search.ranking: #LOW
            _MRPPlant.PlantName as PlannedPlantName,
            @Search.defaultSearchElement: true
            @Search.fuzzinessThreshold: 0.8
            @Search.ranking: #LOW
            ProductionPlant,
            @Search.defaultSearchElement: true
            @Search.fuzzinessThreshold: 0.8
            @Search.ranking: #LOW
            _ProductionPlant.PlantName as ProductionPlantName,
   
            _Order.PlannedStartDate as PlannedStartDate,
            _Order.PlannedEndDate as PlannedEndDate,
            OrderCategory          

}


     where   GoodsReceiptIsExpected = 'X'
       and   IsCompletelyDelivered  = ' '
       and ( InventorySpecialStockType = ' '
        or   InventorySpecialStockType = 'E'
        or   InventorySpecialStockType = 'Q' )
    --   and _ProductPlant.SerialNumberProfile = ' ' 
       

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LOGISTICSORDER",
"I_MATERIALTEXT",
"I_ORDERITEM",
"I_ORDERTYPETEXT",
"I_PLANT"
],
"ASSOCIATED":
[
"I_MATERIALTEXT",
"I_ORDERTYPETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More