I_DeliveryPickViewHeader

DDL: I_DELIVERYPICKVIEWHEADER SQL: IDELIVERYPICKH Type: view COMPOSITE
31 Fields 1 Data Sources 5 Associations

Delivery Pick List Header

I_DeliveryPickViewHeader (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Supply Chain

I_DeliveryPickViewHeader is a Composite CDS View that provides data about "Delivery Pick List Header" in SAP S/4HANA. It reads from 1 data source (I_DeliveryDocument) and exposes 31 fields with key field DeliveryDocument. It has 5 associations to related views.

SAP Help Documentation

CategoryGeneric CDS Views for Delivery Documents
StatusReleased
Purpose
This CDS view is the basic interface view for pick list data of delivery documents. This CDS view provides the prerequisites for answering the following business questions: What is the total weight of the delivery? What is the overall status of goods movement for the document? What is the overall status of picking/putaway for the document? Where are the picked items located?

Prerequisites
This CDS view is available only for users with the shipping point display authorization.

Structure
Object types This view relates to the DeliveryDocument SAP object type. Main parameters and filters of the CDS view The CDS view has no parameters or filters. Measures and attributes Some important measures and attributes are: Delivery ( DeliveryDocument ) SD Document Category ( SDDocumentCategory ) Picking Date ( PickingDate ) Goods Movement Status ( OverallGoodsMovementStatus ) Picking Status / Putaway Status ( OverallPickingStatus ) Picked Items Location ( PickedItemsLocation ) Total Weight ( HeaderGrossWeight ) Volume (HeaderVolume )

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessSupply Chain
Application ComponentLE-SHP-GF
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities
PackageSupply Chain for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_DeliveryDocument I_DeliveryDocument from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_DeliveryDocument _DeliveryDocument $projection.DeliveryDocument = _DeliveryDocument.DeliveryDocument
[0..*] I_DeliveryPickViewDocFlow _DeliveryDocumentFlow _DeliveryDocumentFlow.PrecedingDocument = $projection.DeliveryDocument
[0..*] I_DeliveryPickViewItem _DeliveryDocumentItem _DeliveryDocumentItem.DeliveryDocument = $projection.DeliveryDocument
[0..1] I_DeliveryPickViewShpPoint _ShippingPoint _ShippingPoint.ShippingPoint = $projection.ShippingPoint
[0..1] E_DeliveryDocument _PickViewHeaderExtension $projection.DeliveryDocument = _PickViewHeaderExtension.DeliveryDocument

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IDELIVERYPICKH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Delivery Pick List Header view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY DeliveryDocument I_DeliveryDocument DeliveryDocument Outbound Delivery
PickedItemsLocation I_DeliveryDocument PickedItemsLocation Picked Items Location
HeaderGrossWeight I_DeliveryDocument HeaderGrossWeight Total Weight
HeaderWeightUnit I_DeliveryDocument HeaderWeightUnit Unit of Weight
PickingDate I_DeliveryDocument PickingDate Picking Date
ShipToParty I_DeliveryDocument ShipToParty Ship-To Party (obsolete)
LoadingDate I_DeliveryDocument LoadingDate Loading Date
DeliveryPriority I_DeliveryDocument DeliveryPriority Delivery Priority
ProposedDeliveryRoute I_DeliveryDocument ProposedDeliveryRoute Vehicle route
HeaderVolumeUnit I_DeliveryDocument HeaderVolumeUnit Volume Unit
HeaderVolume I_DeliveryDocument HeaderVolume Volume
ShippingPoint I_DeliveryDocument ShippingPoint Shipping Point / Receiving Point
WarehouseGate I_DeliveryDocument WarehouseGate Door for Warehouse Number
WarehouseStagingArea I_DeliveryDocument WarehouseStagingArea Staging Area for Warehouse Complex
DeliveryDocumentBySupplier I_DeliveryDocument DeliveryDocumentBySupplier External Identification of Delivery Note
Supplier I_DeliveryDocument Supplier Supplier
DeliveryDate I_DeliveryDocument DeliveryDate Delivery Date
SDDocumentCategory I_DeliveryDocument SDDocumentCategory SD Document Category
OverallGoodsMovementStatus I_DeliveryDocument OverallGoodsMovementStatus Goods Movement Status (All Items)
OverallWarehouseActivityStatus I_DeliveryDocument OverallWarehouseActivityStatus Status of Warehouse Management Activities (All Items)
TotalCreditCheckStatus I_DeliveryDocument TotalCreditCheckStatus Overall Status of Credit Checks
TransactionCurrency I_DeliveryDocument TransactionCurrency Transaction Currency
OverallPickingStatus I_DeliveryDocument OverallPickingStatus Picking Status/Putaway Status (All Items)
PlantName Plant Name
PlannedGoodsIssueDate I_DeliveryDocument PlannedGoodsIssueDate Planned Goods Movement Date
_Item I_DeliveryDocument _Item
_ShipToParty I_DeliveryDocument _ShipToParty
_DeliveryDocument _DeliveryDocument
_DeliveryDocumentFlow _DeliveryDocumentFlow
_DeliveryDocumentItem _DeliveryDocumentItem
_ShippingPoint _ShippingPoint

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_DeliveryPickViewHeader.
-- 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: IDELIVERYPICKH

CREATE VIEW I_DeliveryPickViewHeader AS
SELECT
  I_DeliveryDocument.DeliveryDocument AS DeliveryDocument,
  I_DeliveryDocument.PickedItemsLocation AS PickedItemsLocation,
  I_DeliveryDocument.HeaderGrossWeight AS HeaderGrossWeight,
  I_DeliveryDocument.HeaderWeightUnit AS HeaderWeightUnit,
  I_DeliveryDocument.PickingDate AS PickingDate,
  I_DeliveryDocument.ShipToParty AS ShipToParty,
  I_DeliveryDocument.LoadingDate AS LoadingDate,
  I_DeliveryDocument.DeliveryPriority AS DeliveryPriority,
  I_DeliveryDocument.ProposedDeliveryRoute AS ProposedDeliveryRoute,
  I_DeliveryDocument.HeaderVolumeUnit AS HeaderVolumeUnit,
  I_DeliveryDocument.HeaderVolume AS HeaderVolume,
  I_DeliveryDocument.ShippingPoint AS ShippingPoint,
  I_DeliveryDocument.WarehouseGate AS WarehouseGate,
  I_DeliveryDocument.WarehouseStagingArea AS WarehouseStagingArea,
  I_DeliveryDocument.DeliveryDocumentBySupplier AS DeliveryDocumentBySupplier,
  I_DeliveryDocument.Supplier AS Supplier,
  I_DeliveryDocument.DeliveryDate AS DeliveryDate,
  I_DeliveryDocument.SDDocumentCategory AS SDDocumentCategory,
  I_DeliveryDocument.OverallGoodsMovementStatus AS OverallGoodsMovementStatus,
  I_DeliveryDocument.OverallWarehouseActivityStatus AS OverallWarehouseActivityStatus,
  I_DeliveryDocument.TotalCreditCheckStatus AS TotalCreditCheckStatus,
  I_DeliveryDocument.TransactionCurrency AS TransactionCurrency,
  I_DeliveryDocument.OverallPickingStatus AS OverallPickingStatus,
  I_DeliveryDocument._ReceivingPlant.PlantName AS PlantName,
  I_DeliveryDocument.PlannedGoodsIssueDate AS PlannedGoodsIssueDate,
  I_DeliveryDocument._Item AS _Item,
  I_DeliveryDocument._ShipToParty AS _ShipToParty
FROM I_DeliveryDocument
LEFT OUTER JOIN I_DeliveryDocument AS _DeliveryDocument ON DeliveryDocument = _DeliveryDocument.DeliveryDocument  -- association [1..1]
LEFT OUTER JOIN I_DeliveryPickViewDocFlow AS _DeliveryDocumentFlow ON _DeliveryDocumentFlow.PrecedingDocument = DeliveryDocument  -- association [0..*]
LEFT OUTER JOIN I_DeliveryPickViewItem AS _DeliveryDocumentItem ON _DeliveryDocumentItem.DeliveryDocument = DeliveryDocument  -- association [0..*]
LEFT OUTER JOIN I_DeliveryPickViewShpPoint AS _ShippingPoint ON _ShippingPoint.ShippingPoint = ShippingPoint  -- association [0..1]
LEFT OUTER JOIN E_DeliveryDocument AS _PickViewHeaderExtension ON DeliveryDocument = _PickViewHeaderExtension.DeliveryDocument  -- association [0..1]
;

Learn More