I_LstMiUIRteInvtryGrpForProdVH

DDL: I_LSTMIUIRTEINVTRYGRPFORPRODVH SQL: IIGPRPRDVH Type: view BASIC

LstMi UI Route Product Inventory Group

I_LstMiUIRteInvtryGrpForProdVH is a Basic CDS View that provides data about "LstMi UI Route Product Inventory Group" in SAP S/4HANA. It reads from 2 data sources (lmd_com_igrpmtyp, I_Material) and exposes 10 fields with key fields ProductID, LastMileRteInventoryGroupCode, LastMileRouteItemCategoryCode.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
lmd_com_igrpmtyp _igrpmtyp inner
I_Material _Product from

Annotations (11)

NameValueLevelField
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IIGPRPRDVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label LstMi UI Route Product Inventory Group view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #VALUE_HELP view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ProductID I_Material Material
KEY LastMileRteInventoryGroupCode lmd_com_igrpmtyp inventory_group
KEY LastMileRouteItemCategoryCode lmd_com_igrpmtyp item_category
ProductType lmd_com_igrpmtyp material_type
LstMiRteIsDfltInventoryGroup lmd_com_igrpmtyp default_inventory_group
MaterialType
MaterialGroup I_Material MaterialGroup
AuthorizationGroup I_Material AuthorizationGroup
_MaterialType
_MaterialGroup I_Material _MaterialGroup 
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'IIGPRPRDVH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'LstMi UI Route Product Inventory Group'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory : #L
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.dataCategory: #VALUE_HELP
define view I_LstMiUIRteInvtryGrpForProdVH
  as select from I_Material       as _Product

    inner join   lmd_com_igrpmtyp as _igrpmtyp on _igrpmtyp.material_type = _Product.MaterialType
{
  key _Product.Material                 as ProductID,
  key _igrpmtyp.inventory_group         as LastMileRteInventoryGroupCode,
  key _igrpmtyp.item_category           as LastMileRouteItemCategoryCode,
      _igrpmtyp.material_type           as ProductType,
      _igrpmtyp.default_inventory_group as LstMiRteIsDfltInventoryGroup,

      -- For DCL use
      @UI.hidden: true
      _Product.MaterialType,
      @UI.hidden: true
      _Product.MaterialGroup,
      @UI.hidden: true
      _Product.AuthorizationGroup,

      -- Associations for DCL
      _Product._MaterialType,
      _Product._MaterialGroup
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MATERIAL",
"LMD_COM_IGRPMTYP"
],
"ASSOCIATED":
[
"I_MATERIALGROUP",
"I_MATERIALTYPE"
],
"BASE":
[
"I_MATERIAL"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More