F_Mmim_OrderItem_Vh

DDL: F_MMIM_ORDERITEM_VH SQL: FMMIMORDITMVH Type: view

Value Help Order Items

F_Mmim_OrderItem_Vh is a CDS View that provides data about "Value Help Order Items" in SAP S/4HANA. It reads from 3 data sources (aufk, afpo, F2_Mmim_OrderItem_Vh) and exposes 9 fields with key fields OrderID, OrderItem. It has 2 associations to related views.

3 data source(s) 9 fields

Data Sources (3)

SourceAliasJoin Type
aufk head inner
afpo item inner
F2_Mmim_OrderItem_Vh mdoc from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_OrderCategoryText _OrderCategoryText $projection.OrderCategory = _OrderCategoryText.OrderCategory and _OrderCategoryText.Language = $session.system_language
[1..1] I_OrderTypeText _OrderTypeText $projection.OrderType = _OrderTypeText.OrderType and _OrderTypeText.Language = $session.system_language

Annotations (12)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName FMMIMORDITMVH view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Value Help Order Items view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #VALUE_HELP view
Search.searchable true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY OrderID aufk aufnr
KEY OrderItem afpo posnr
OrderType aufk auart
OrderTypeName _OrderTypeText OrderTypeName
OrderCategory aufk autyp
OrderCategoryName _OrderCategoryText OrderCategoryName
ProductionPlant aufk werks
Material afpo matnr
MRPPlant afpo pwerk 
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'FMMIMORDITMVH'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Value Help Order Items'
@AccessControl.authorizationCheck:#CHECK

@AccessControl.personalData.blocking: #NOT_REQUIRED
 
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass:#MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.dataCategory:#VALUE_HELP
@Search.searchable: true

define view F_Mmim_OrderItem_Vh as select from F2_Mmim_OrderItem_Vh as mdoc
   inner join aufk as head on head.aufnr = mdoc.OrderID
   inner join afpo as item on head.aufnr = item.aufnr
  
  association [1..1] to I_OrderCategoryText as _OrderCategoryText on $projection.OrderCategory = _OrderCategoryText.OrderCategory
                                                                  and _OrderCategoryText.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 head.aufnr as OrderID,
  key item.posnr as OrderItem,
  head.auart as OrderType, 
  _OrderTypeText.OrderTypeName as OrderTypeName,
  head.autyp as OrderCategory,
  _OrderCategoryText.OrderCategoryName as OrderCategoryName,
 @Search.defaultSearchElement: true
 @Search.fuzzinessThreshold: 0.8
 @Search.ranking: #HIGH    
  head.werks as ProductionPlant,
 @Search.defaultSearchElement: true
 @Search.fuzzinessThreshold: 0.8
 @Search.ranking: #HIGH   
  item.matnr as Material,
  item.pwerk as MRPPlant
}
//where mdoc.OrderID <> ''


/*+[internal] {
"BASEINFO":
{
"FROM":
[
"F2_MMIM_ORDERITEM_VH",
"I_ORDERCATEGORYTEXT",
"I_ORDERTYPETEXT",
"AFPO",
"AUFK"
],
"ASSOCIATED":
[
"I_ORDERCATEGORYTEXT",
"I_ORDERTYPETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More