I_LstMiUIRteCheckInProductTP

DDL: I_LSTMIUIRTECHECKINPRODUCTTP Type: view_entity TRANSACTIONAL
16 Fields 1 Data Sources 1 Associations

Last Mile UI Route Check-In Product

I_LstMiUIRteCheckInProductTP is a Transactional CDS View that provides data about "Last Mile UI Route Check-In Product" in SAP S/4HANA. It reads from 1 data source (P_LstMiUIRteChkInItemAggrgn) and exposes 16 fields with key fields LastMileRouteUUID, ProductID, Batch, LstMiRouteProductUnitOfMeasure, LastMileRteInventoryGroupCode. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_LstMiUIRteChkInItemAggrgn Prods from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_LstMiUIRouteTP _Route $projection.LastMileRouteUUID = _Route.LastMileRouteUUID

Annotations (8)

NameValueLevelField
EndUserText.label Last Mile UI Route Check-In Product view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY LastMileRouteUUID P_LstMiUIRteChkInItemAggrgn LastMileRouteUUID
KEY ProductID P_LstMiUIRteChkInItemAggrgn ProductID Product ID
KEY Batch P_LstMiUIRteChkInItemAggrgn Batch Lot No.
KEY LstMiRouteProductUnitOfMeasure P_LstMiUIRteChkInItemAggrgn LstMiRouteProductUnitOfMeasure
KEY LastMileRteInventoryGroupCode P_LstMiUIRteChkInItemAggrgn LastMileRteInventoryGroupCode
KEY LastMileRouteStopUUID P_LstMiUIRteChkInItemAggrgn LastMileRouteStopUUID
KEY LstMiRteChkInChkOutProductUUID P_LstMiUIRteChkInItemAggrgn LstMiRteChkInChkOutProductUUID
ProductName Product ProductName Description
LastMileRouteActualQuantity P_LstMiUIRteChkInItemAggrgn LastMileRouteActualQuantity
LastMileRouteUnloadedQuantity P_LstMiUIRteChkInItemAggrgn LastMileRouteUnloadedQuantity
LastMileRouteChkInReasonCode P_LstMiUIRteChkInItemAggrgn LastMileRouteChkInReasonCode
LastMileRouteIsMnllyAddedRecd P_LstMiUIRteChkInItemAggrgn LastMileRouteIsMnllyAddedRecd
PlantendasPlant
IsBatchManagementRequired
_CheckIn _CheckIn
_Route _Route

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_LstMiUIRteCheckInProductTP.
-- 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.

CREATE VIEW I_LstMiUIRteCheckInProductTP AS
SELECT
  Prods.LastMileRouteUUID AS LastMileRouteUUID,
  Prods.ProductID AS ProductID,
  Prods.Batch AS Batch,
  Prods.LstMiRouteProductUnitOfMeasure AS LstMiRouteProductUnitOfMeasure,
  Prods.LastMileRteInventoryGroupCode AS LastMileRteInventoryGroupCode,
  Prods.LastMileRouteStopUUID AS LastMileRouteStopUUID,
  Prods.LstMiRteChkInChkOutProductUUID AS LstMiRteChkInChkOutProductUUID,
  Product.ProductName AS ProductName,
  Prods.LastMileRouteActualQuantity AS LastMileRouteActualQuantity,
  Prods.LastMileRouteUnloadedQuantity AS LastMileRouteUnloadedQuantity,
  Prods.LastMileRouteChkInReasonCode AS LastMileRouteChkInReasonCode,
  Prods.LastMileRouteIsMnllyAddedRecd AS LastMileRouteIsMnllyAddedRecd,
  case when Prods.LstMiRteCOCIPlant is not initial then Prods.LstMiRteCOCIPlant else Prods.Plant end as Plant AS PlantendasPlant,
  cast ( ' ' as boolean preserving type ) AS IsBatchManagementRequired
FROM P_LstMiUIRteChkInItemAggrgn AS Prods
LEFT OUTER JOIN I_LstMiUIRouteTP AS _Route ON LastMileRouteUUID = _Route.LastMileRouteUUID  -- association [1..1]
;

Learn More