I_SrvcPartsDelivery

DDL: I_SRVCPARTSDELIVERY Type: view_entity COMPOSITE
92 Fields 1 Data Sources 1 Associations 2 OData Services

Delivery Composite

I_SrvcPartsDelivery is a Composite CDS View that provides data about "Delivery Composite" in SAP S/4HANA. It reads from 1 data source (I_SrvcPartsDeliveryBasic) and exposes 92 fields with key fields SCMAdvncdShipgNotifUUID, SCMAdvncdShipgNotifItemUUID. It has 1 association to related views. It is exposed through 2 OData services (SERVICEPARTSTRANSPORTDURATION, SERVICEPARTSTRANSPORTDURATION).

Data Sources (1)

SourceAliasJoin Type
I_SrvcPartsDeliveryBasic _Delivery from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_TranspLaneMTr _LaneMot $projection.StartLocationUUID = _LaneMot.StartLocationUUID and $projection.DestinationLocationUUID = _LaneMot.DestinationLocationUUID and $projection.PlanningModel = _LaneMot.PlanningModel and $projection.MeansOfTransportVehicle = _LaneMot.MeansOfTransportVehicle

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Delivery Composite view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

OData Services (2)

ServiceBindingVersionContractRelease
SERVICEPARTSTRANSPORTDURATION UI_SRVCPARTSTRANSPDURN_V2 V2 C1 NOT_RELEASED
SERVICEPARTSTRANSPORTDURATION UI_SRVCPARTSTRANSPDURN_V4 V4 C1 NOT_RELEASED

Fields (92)

KeyFieldSource TableSource FieldDescription
KEY SCMAdvncdShipgNotifUUID SCMAdvncdShipgNotifUUID ASN (GUID)
KEY SCMAdvncdShipgNotifItemUUID SCMAdvncdShipgNotifItemUUID ASN Item
SCMAdvancedShippingNotif SCMAdvancedShippingNotif ASN (ID)
SCMAdvancedShippingNotifItem SCMAdvancedShippingNotifItem ASN Item
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
ShippingLocationTimeZone ShippingLocationTimeZone Ship-Fr. Time Zone
StartLocationUUID StartLocationUUID Start LocationID
ShippingLocationType ShippingLocationType Start Loc. Type
SCMHierarchyParentNode SCMHierarchyParentNode Location Group
ReceivingLocationTimeZone ReceivingLocationTimeZone Time Zone Cust.Loc.
DestinationLocationUUID DestinationLocationUUID Target Loc. ID
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
PlanningModel PlanningModel
StartLocationValdtyStrtDteTme _LaneMot StartLocationValdtyStrtDteTme
StartLocationValdtyEndDteTme _LaneMot StartLocationValdtyEndDteTme
StartLocation StartLocation Ship-From Location
DestinationLocation DestinationLocation Customer Location
MeansOfTransportVehicle MeansOfTransportVehicle
SCMDeliveryStatus SCMDeliveryStatus
SCMDeliveryStatusStrtDate _Status SCMDeliveryStatusStrtDate
SCMDeliveryStatusDurnInHours
SCMDeliveryAvgDurn
ServicePartsDeliveriesValue
CalendarDate CalendarDate Calendar Date
YearMonth YearMonth Year Month
YearWeek YearWeek Year and Calendar Week
YearQuarter YearQuarter Year Quarter
CalendarYear CalendarYear Year
CalendarQuarter CalendarQuarter Calendar Quarter
CalendarMonth CalendarMonth Calendar Month
CalendarWeek CalendarWeek Calendar Week
CalendarDay CalendarDay Occur Day in a Month
WeekDay WeekDay Weekdays
FirstDayOfWeekDate FirstDayOfWeekDate First day of week date
FirstDayOfMonthDate FirstDayOfMonthDate First Day of Month
CalendarDayOfYear CalendarDayOfYear Calendar day of year
YearDay YearDay Day of the year
_Periodicity _Periodicity
SrvcPartsApplication I_SrvcPartsDeliveryBasic SrvcPartsApplication
_Status _Status
_Product _Product
_StartLocationAnalytics _StartLocationAnalytics
_DestinationLocationAnalytics _DestinationLocationAnalytics
_StartLocationText _StartLocationText
_DestinationLocationText _DestinationLocationText
_Supplier _Supplier
_CalendarMonthText _CalendarMonthText
_CalendarQuarterText _CalendarQuarterText
_WeekDayText _WeekDayText

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_SrvcPartsDelivery.
-- 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_SrvcPartsDelivery AS
SELECT
  SCMAdvncdShipgNotifUUID,
  SCMAdvncdShipgNotifItemUUID,
  SCMAdvancedShippingNotif,
  SCMAdvancedShippingNotifItem,
  SCMDeliveryStatusExternal,
  SCMPurchaseOrder,
  SCMPurchaseOrderItem,
  SCMPurchaseOrderScheduleLine,
  SCMDeliveryDocumentUUID,
  SCMDeliveryDocumentItemUUID,
  SCMDeliveryDocument,
  SCMDeliveryDocumentItem,
  SCMDeliveryNote,
  SCMShipment,
  MeansOfTransportExternal,
  SCMSupplier,
  Supplier,
  ShippingLocationTimeZone,
  StartLocationUUID,
  ShippingLocationType,
  SCMHierarchyParentNode,
  ReceivingLocationTimeZone,
  DestinationLocationUUID,
  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,
  PlanningModel,
  _LaneMot.StartLocationValdtyStrtDteTme AS StartLocationValdtyStrtDteTme,
  _LaneMot.StartLocationValdtyEndDteTme AS StartLocationValdtyEndDteTme,
  StartLocation,
  DestinationLocation,
  MeansOfTransportVehicle,
  SCMDeliveryStatus,
  _Status.SCMDeliveryStatusStrtDate AS SCMDeliveryStatusStrtDate,
  cast ( cast (_Status.SCMDeliveryStatusDurnInHours as abap.int4 ) as /sapapo/tr_durat_curr ) AS SCMDeliveryStatusDurnInHours,
  cast ( cast (_Status.SCMDeliveryStatusDurnInHours as abap.int4 ) as /sapapo/tr_durat_avg ) AS SCMDeliveryAvgDurn,
  cast( 1 as abap.int4 ) AS ServicePartsDeliveriesValue,
  CalendarDate,
  YearMonth,
  YearWeek,
  YearQuarter,
  CalendarYear,
  CalendarQuarter,
  CalendarMonth,
  CalendarWeek,
  CalendarDay,
  WeekDay,
  FirstDayOfWeekDate,
  FirstDayOfMonthDate,
  CalendarDayOfYear,
  YearDay,
  _Delivery.SrvcPartsApplication AS SrvcPartsApplication
FROM I_SrvcPartsDeliveryBasic AS _Delivery
LEFT OUTER JOIN I_TranspLaneMTr AS _LaneMot ON StartLocationUUID = _LaneMot.StartLocationUUID AND DestinationLocationUUID = _LaneMot.DestinationLocationUUID AND PlanningModel = _LaneMot.PlanningModel AND MeansOfTransportVehicle = _LaneMot.MeansOfTransportVehicle  -- association [0..*]
;

Learn More