I_SrvcPartsInboundMonitorC

DDL: I_SRVCPARTSINBOUNDMONITORC SQL: ISPINBOUNDMNTRC Type: view COMPOSITE
62 Fields 1 Data Sources

Analytics - Inbound Monitor Cube

I_SrvcPartsInboundMonitorC is a Composite CDS View (Cube) that provides data about "Analytics - Inbound Monitor Cube" in SAP S/4HANA. It reads from 1 data source (I_SrvcPartsInboundMonitor) and exposes 62 fields with key fields SCMAdvncdShipgNotifUUID, SCMAdvncdShipgNotifItemUUID.

Data Sources (1)

SourceAliasJoin Type
I_SrvcPartsInboundMonitor I_SrvcPartsInboundMonitor from

Annotations (14)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Analytics - Inbound Monitor Cube view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ISPINBOUNDMNTRC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view
Analytics.dataCategory #CUBE view
Metadata.ignorePropagatedAnnotations true view
Analytics.internalName #LOCAL view
Metadata.allowExtensions true view

Fields (62)

KeyFieldSource TableSource FieldDescription
KEY SCMAdvncdShipgNotifUUID SCMAdvncdShipgNotifUUID ASN (GUID)
KEY SCMAdvncdShipgNotifItemUUID SCMAdvncdShipgNotifItemUUID ASN Item
SCMAdvancedShippingNotif SCMAdvancedShippingNotif ASN (ID)
SCMAdvancedShippingNotifItem SCMAdvancedShippingNotifItem ASN Item
SCMDeliveryStatus SCMDeliveryStatus Delivery Status
SCMDeliveryStatusExternal SCMDeliveryStatusExternal External Status
SCMPurchaseOrder SCMPurchaseOrder Reference PO
SCMPurchaseOrderItem SCMPurchaseOrderItem Ref. PO Item
SCMPurchaseOrderScheduleLine SCMPurchaseOrderScheduleLine Ref.PO Schedule Line
SCMDeliveryDocumentUUID SCMDeliveryDocumentUUID Ref. Del. Doc.(GUID)
SCMDeliveryDocumentItemUUID SCMDeliveryDocumentItemUUID Ref.Deliv.Item GUID
SCMDeliveryDocument SCMDeliveryDocument Ref.Deliv. Doc.
SCMDeliveryDocumentItem SCMDeliveryDocumentItem Ref. Del. Item
SCMDeliveryNote SCMDeliveryNote Lifex
SCMShipment SCMShipment Shipment ID
MeansOfTransportExternal MeansOfTransportExternal MOT in Inb. Monitor
SCMSupplier SCMSupplier Vendor
Supplier Supplier Supplier
StartLocation StartLocation Ship-From Location
StartLocationDescription _StartLocationText LocationDescription Current Location
ShippingLocationTimeZone ShippingLocationTimeZone Ship-Fr. Time Zone
ShippingLocationType ShippingLocationType Start Loc. Type
SCMHierarchyParentNode SCMHierarchyParentNode Location Group
DestinationLocation DestinationLocation Customer Location
DestinationLocationDescription _DestinationLocationText LocationDescription Current Location
ReceivingLocationTimeZone ReceivingLocationTimeZone Time Zone Cust.Loc.
ReceivingLocationType ReceivingLocationType Target Loc. Type
SCMPlant SCMPlant Valuation Area
ProductGroupValue ProductGroupValue Product Group
SCMProductUUID SCMProductUUID Product
Product Product Product Sold
TotDeliveryQuantityInBaseUnit TotDeliveryQuantityInBaseUnit Delivery Qty
DeliveryStatusQuantity DeliveryStatusQuantity Qty Status
CumulativeGoodsReceiptQuantity CumulativeGoodsReceiptQuantity Cum. GR Qty
TotalAlertQuantity TotalAlertQuantity Alert Quantity
TotReceiptQuantityInBaseUnit TotReceiptQuantityInBaseUnit Total GR Qty
LastGoodsReceiptQuantity LastGoodsReceiptQuantity Last GR Qty
ProductBaseUnit ProductBaseUnit Weight UoM
SCMDeliveryStartDateTime SCMDeliveryStartDateTime
SCMDeliveryAvailyDateTime SCMDeliveryAvailyDateTime
SCMDeliveryStatusChgDateTime SCMDeliveryStatusChgDateTime
WarehouseTimeZone WarehouseTimeZone Time Zone
SCMDeliveryIsOpen SCMDeliveryIsOpen ASN Open
SCMDeliveryIsLate SCMDeliveryIsLate Delivery Late
WarehouseLogicalSystem WarehouseLogicalSystem Logical System of Warehouse
DeliveryIsMarkedForDeletion DeliveryIsMarkedForDeletion Deletion Indicator
DeliveryUpdateCode DeliveryUpdateCode Update Mode BW
DeliveryPriorityPointsValue DeliveryPriorityPointsValue Priority Points
DelivPriorityPointsLastDteTime DelivPriorityPointsLastDteTime
DelivIsPlndForPriorityPoints DelivIsPlndForPriorityPoints Prio. Points Req.
DelivPriorityPointsReqdDteTime DelivPriorityPointsReqdDteTime
DelivIsMarkedForCriticalAlert DelivIsMarkedForCriticalAlert Flgd Alert 7801
ContractPackagerLocation ContractPackagerLocation CP Assigned Loc.
ContractPackagerLocationType ContractPackagerLocationType Loc.Type of Ass.Loc.
SCMProcessCategory SCMProcessCategory Type of Data
SCMPutawayQuantity SCMPutawayQuantity Putaway Quantity
SCMFirstDeliveryStatus SCMFirstDeliveryStatus First Delivery Sts
DeliveryIsPushScenario DeliveryIsPushScenario TRUE
_Product _Product
_Supplier _Supplier
_StartLocationAnalytics _StartLocationAnalytics
_DestinationLocationAnalytics _DestinationLocationAnalytics

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_SrvcPartsInboundMonitorC.
-- 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: ISPINBOUNDMNTRC

CREATE VIEW I_SrvcPartsInboundMonitorC AS
SELECT
  SCMAdvncdShipgNotifUUID,
  SCMAdvncdShipgNotifItemUUID,
  SCMAdvancedShippingNotif,
  SCMAdvancedShippingNotifItem,
  SCMDeliveryStatus,
  SCMDeliveryStatusExternal,
  SCMPurchaseOrder,
  SCMPurchaseOrderItem,
  SCMPurchaseOrderScheduleLine,
  SCMDeliveryDocumentUUID,
  SCMDeliveryDocumentItemUUID,
  SCMDeliveryDocument,
  SCMDeliveryDocumentItem,
  SCMDeliveryNote,
  SCMShipment,
  MeansOfTransportExternal,
  SCMSupplier,
  Supplier,
  StartLocation,
  _StartLocationText.LocationDescription AS StartLocationDescription,
  ShippingLocationTimeZone,
  ShippingLocationType,
  SCMHierarchyParentNode,
  DestinationLocation,
  _DestinationLocationText.LocationDescription AS DestinationLocationDescription,
  ReceivingLocationTimeZone,
  ReceivingLocationType,
  SCMPlant,
  ProductGroupValue,
  SCMProductUUID,
  Product,
  TotDeliveryQuantityInBaseUnit,
  DeliveryStatusQuantity,
  CumulativeGoodsReceiptQuantity,
  TotalAlertQuantity,
  TotReceiptQuantityInBaseUnit,
  LastGoodsReceiptQuantity,
  ProductBaseUnit,
  SCMDeliveryStartDateTime,
  SCMDeliveryAvailyDateTime,
  SCMDeliveryStatusChgDateTime,
  WarehouseTimeZone,
  SCMDeliveryIsOpen,
  SCMDeliveryIsLate,
  WarehouseLogicalSystem,
  DeliveryIsMarkedForDeletion,
  DeliveryUpdateCode,
  DeliveryPriorityPointsValue,
  DelivPriorityPointsLastDteTime,
  DelivIsPlndForPriorityPoints,
  DelivPriorityPointsReqdDteTime,
  DelivIsMarkedForCriticalAlert,
  ContractPackagerLocation,
  ContractPackagerLocationType,
  SCMProcessCategory,
  SCMPutawayQuantity,
  SCMFirstDeliveryStatus,
  DeliveryIsPushScenario
FROM I_SrvcPartsInboundMonitor
;

Learn More