I_LstMiUIRteInvtryGrpForProdVH

DDL: I_LSTMIUIRTEINVTRYGRPFORPRODVH SQL: IIGPRPRDVH Type: view BASIC
10 Fields 2 Data Sources

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.

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 Vehicle Model
KEY LastMileRteInventoryGroupCode lmd_com_igrpmtyp inventory_group Inventory Group
KEY LastMileRouteItemCategoryCode lmd_com_igrpmtyp item_category Item Category
ProductType lmd_com_igrpmtyp material_type Material Type
LstMiRteIsDfltInventoryGroup lmd_com_igrpmtyp default_inventory_group Default Inv. Grp
MaterialType
MaterialGroup I_Material MaterialGroup Product Group
AuthorizationGroup I_Material AuthorizationGroup AuthorizGroup
_MaterialType
_MaterialGroup I_Material _MaterialGroup

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_LstMiUIRteInvtryGrpForProdVH.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IIGPRPRDVH

CREATE VIEW I_LstMiUIRteInvtryGrpForProdVH AS
SELECT
  _Product.Material AS ProductID,
  _igrpmtyp.inventory_group AS LastMileRteInventoryGroupCode,
  _igrpmtyp.item_category AS LastMileRouteItemCategoryCode,
  _igrpmtyp.material_type AS ProductType,
  _igrpmtyp.default_inventory_group AS LstMiRteIsDfltInventoryGroup,
  _Product.MaterialGroup AS MaterialGroup,
  _Product.AuthorizationGroup AS AuthorizationGroup,
  _Product._MaterialGroup AS _MaterialGroup
FROM I_Material AS _Product
INNER JOIN lmd_com_igrpmtyp AS _igrpmtyp ON /* join condition not captured in parsed metadata */
;

Learn More