What is I_DeliveryPickViewItem in SAP S/4HANA?

I_DeliveryPickViewItem is a composite CDS view in SAP S/4HANA. Delivery Pick List Item It contains 99 fields.

Which tables does I_DeliveryPickViewItem read from?

I_DeliveryPickViewItem reads data from: I_DeliveryDocumentItem.

What VDM layer is I_DeliveryPickViewItem?

I_DeliveryPickViewItem is classified as a Composite view that combines data from multiple basic views.

I_DeliveryPickViewItem

DDL: I_DELIVERYPICKVIEWITEM SQL: IDELIVERYPICKI Type: view COMPOSITE

99 Fields 1 Data Sources 3 Associations

Delivery Pick List Item

I_DeliveryPickViewItem (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_DeliveryPickViewItem is a Composite CDS View that provides data about "Delivery Pick List Item" in SAP S/4HANA. It reads from 1 data source (I_DeliveryDocumentItem) and exposes 99 fields with key fields DeliveryDocument, DeliveryDocumentItem. It has 3 associations to related views.

SAP Help Documentation

Category	Generic CDS Views for Delivery Documents
Status	Released

Purpose
This CDS view is the basic interface view for pick list data of delivery document items. This CDS view provides the prerequisites for answering the following business questions: What is the weight of the delivery item? What is the status of goods movement for the document item? What is the overall status of picking/putaway for the document item? Where is the storage location of the delivery item?

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

Structure
Object types This view relates to the DeliveryDocumentItem 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 ) Delivery Item ( DeliveryDocumentItem ) Material Number ( Material ) Storage Location ( StorageLocation ) Actual quantity delivered in sales units ( ActualDeliveryQuantity ) Actual quantity delivered in stock-keeping units ( ActualDeliveredQtyInBaseUnit ) Gross Weight ( ItemGrossWeight ) Volume ( ItemVolume ) Status of Warehouse Management Activities ( WarehouseActivityStatus ) Picking Status / Putaway Status ( PickingStatus)

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Supply Chain
Application Component	LE-SHP-GF
Capabilities	Data Source in SQL Select, Data Source for Defining CDS Entities
Package	Supply Chain for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view is the basic interface view for pick list data of delivery document items.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>What is the weight of the delivery item?</p></li> <li><p>What is the status of goods movement for the document item?</p></li> <li><p>What is the overall status of picking/putaway for the document item?</p></li> <li><p>Where is the storage location of the delivery item?</p></li> </ul>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_DeliveryDocumentItem	I_DeliveryDocumentItem	from

Associations (3)

Cardinality	Target	Alias	Condition
[1..1]	I_DeliveryDocumentItem	_DeliveryDocumentItem	`$projection.DeliveryDocument = _DeliveryDocumentItem.DeliveryDocument and $projection.DeliveryDocumentItem = _DeliveryDocumentItem.DeliveryDocumentItem`
[0..*]	I_DeliveryPickViewDocFlow	_DocumentFlow	`_DocumentFlow.PrecedingDocument = $projection.DeliveryDocument and _DocumentFlow.PrecedingDocumentItem = $projection.DeliveryDocumentItem`
[0..1]	E_DeliveryDocumentItem	_PickViewItemExtension	`$projection.DeliveryDocument = _PickViewItemExtension.DeliveryDocument and $projection.DeliveryDocumentItem = _PickViewItemExtension.DeliveryDocumentItem`

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	IDELIVERYPICKI	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
EndUserText.label	Delivery Pick List Item	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 (99)

Key	Field	Source Table	Source Field	Description
KEY	DeliveryDocument	I_DeliveryDocumentItem	DeliveryDocument	Outbound Delivery
KEY	DeliveryDocumentItem	I_DeliveryDocumentItem	DeliveryDocumentItem	Outb. Delivery Item
	DeliveryDocumentItemText	I_DeliveryDocumentItem	DeliveryDocumentItemText	Short text for sales order item
	RetailPromotion	I_DeliveryDocumentItem	RetailPromotion	Retail Promotion
	serail
	sgt_rcat
	sgt_scat
	wrf_charstc1
	wrf_charstc2
	wrf_charstc3
	GoodsMovementType	I_DeliveryDocumentItem	GoodsMovementType	Movement Type (Inventory Management)
	bwlvs
	Batch	I_DeliveryDocumentItem	Batch	Batch Number
	InventoryValuationType	I_DeliveryDocumentItem	InventoryValuationType	Valuation Type
	MaterialByCustomer	I_DeliveryDocumentItem	MaterialByCustomer	Customer Material
	kzdlg
	ActualDeliveryQuantity	I_DeliveryDocumentItem	ActualDeliveryQuantity	Actual quantity delivered (in sales units)
	ActualDeliveredQtyInBaseUnit	I_DeliveryDocumentItem	ActualDeliveredQtyInBaseUnit	Actual quantity delivered in stockkeeping units
	lfimg_flo
	lgmng_flo
	Warehouse	I_DeliveryDocumentItem	Warehouse	Warehouse Number / Warehouse Complex
	StorageLocation	I_DeliveryDocumentItem	StorageLocation	Storage Location
	WarehouseStorageBin	I_DeliveryDocumentItem	WarehouseStorageBin	Storage Bin
	StorageBin	I_DeliveryDocumentItem	StorageBin	Storage Bin
	StorageType	I_DeliveryDocumentItem	StorageType	Storage Type
	flgwm
	Material	I_DeliveryDocumentItem	Material	Material Number
	ProductAvailabilityDate	I_DeliveryDocumentItem	ProductAvailabilityDate	Material Staging/Availability Date
	BaseUnit	I_DeliveryDocumentItem	BaseUnit	Base Unit of Measure
	HigherLvlItmOfBatSpltItm	I_DeliveryDocumentItem	HigherLvlItmOfBatSpltItm	Higher-Level Item of Batch Split Item
	DeliveryToBaseQuantityDnmntr	I_DeliveryDocumentItem	DeliveryToBaseQuantityDnmntr	Denominator (divisor) for conversion of sales Qty into SKU
	DeliveryToBaseQuantityNmrtr	I_DeliveryDocumentItem	DeliveryToBaseQuantityNmrtr	Numerator (factor) for conversion of sales quantity into SKU
	umrev
	DeliveryQuantityUnit	I_DeliveryDocumentItem	DeliveryQuantityUnit	Unit of measure
	Plant	I_DeliveryDocumentItem	Plant	Valuation Area
	InventorySpecialStockType	I_DeliveryDocumentItem	InventorySpecialStockType	Special Stock Indicator
	PickingControl	I_DeliveryDocumentItem	PickingControl	Indicator for picking control
	ReferenceSDDocument	I_DeliveryDocumentItem	ReferenceSDDocument	Document Number of Reference Document
	ReferenceSDDocumentItem	I_DeliveryDocumentItem	ReferenceSDDocumentItem	Item number of the reference item
	ReferenceSDDocumentCategory	I_DeliveryDocumentItem	ReferenceSDDocumentCategory	Document Category of Preceding SD Document
	ItemGrossWeight	I_DeliveryDocumentItem	ItemGrossWeight	Gross Weight
	ItemNetWeight	I_DeliveryDocumentItem	ItemNetWeight	Net Weight
	ItemWeightUnit	I_DeliveryDocumentItem	ItemWeightUnit	Unit of Weight
	ItemVolume	I_DeliveryDocumentItem	ItemVolume	Volume
	ItemVolumeUnit	I_DeliveryDocumentItem	ItemVolumeUnit	Volume Unit
	MaterialIsBatchManaged	I_DeliveryDocumentItem	MaterialIsBatchManaged	Batch Management Requirement Indicator
	MaterialIsIntBatchManaged	I_DeliveryDocumentItem	MaterialIsIntBatchManaged	Batch management indicator (internal)
	ReceivingPoint	I_DeliveryDocumentItem	ReceivingPoint	Receiving Point
	DepartmentClassificationByCust	I_DeliveryDocumentItem	DepartmentClassificationByCust	Department number
	NumberOfSerialNumbers	I_DeliveryDocumentItem	NumberOfSerialNumbers	Number of serial numbers
	kzwi1
	kzwi2
	kzwi3
	kzwi4
	kzwi5
	kzwi6
	kpein
	kmein
	netpr
	netwr
	uecha
	ps_psp_pnr
	vbelv
	posnv
	magrv
	kzfme
	BatchBySupplier	I_DeliveryDocumentItem	BatchBySupplier	Supplier Batch Number
	InternationalArticleNumber	I_DeliveryDocumentItem	InternationalArticleNumber	International Article Number (EAN/UPC)
	kzbew
	mtart
	rblvs
	WarehouseStockCategory	I_DeliveryDocumentItem	WarehouseStockCategory	Stock Category in the Warehouse Management System
	IssgOrRcvgStockCategory	I_DeliveryDocumentItem	IssgOrRcvgStockCategory	Stock Category in the Warehouse Management System
	IssgOrRcvgMaterial	I_DeliveryDocumentItem	IssgOrRcvgMaterial	Receiving/Issuing Material
	IssuingOrReceivingPlant	I_DeliveryDocumentItem	IssuingOrReceivingPlant	Receiving plant/issuing plant
	IssuingOrReceivingStorageLoc	I_DeliveryDocumentItem	IssuingOrReceivingStorageLoc	Receiving/issuing storage location
	IssgOrRcvgBatch	I_DeliveryDocumentItem	IssgOrRcvgBatch	Receiving/Issuing Batch
	IssgOrRcvgSpclStockInd	I_DeliveryDocumentItem	IssgOrRcvgSpclStockInd	Special stock indicator for physical stock transfer
	sonum
	usonu
	WarehouseStagingArea	I_DeliveryDocumentItem	WarehouseStagingArea	Staging Area for Warehouse Complex
	kzech
	hupos
	PrimaryPostingSwitch	I_DeliveryDocumentItem	PrimaryPostingSwitch	Indicator: UNMAT in main posting
	InspectionLot	I_DeliveryDocumentItem	InspectionLot	Inspection Lot Number
	rsnum
	rsart
	rspos
	OrderID	I_DeliveryDocumentItem	OrderID	Order Number
	pckpf
	ShelfLifeExpirationDate	I_DeliveryDocumentItem	ShelfLifeExpirationDate	Shelf Life Expiration or Best-Before Date
	WarehouseActivityStatus	I_DeliveryDocumentItem	WarehouseActivityStatus	Status of Warehouse Management Activities (Item)
	PickingStatus	I_DeliveryDocumentItem	PickingStatus	Picking Status/Putaway Status (Item)
	HigherLevelItem	I_DeliveryDocumentItem	HigherLevelItem	Higher-Level Item in Bill of Material Structures
	HigherLevelItemUsage	I_DeliveryDocumentItem	HigherLevelItemUsage	ID for higher-level item usage
	DeliveryGroup	I_DeliveryDocumentItem	DeliveryGroup	Delivery Group (Items are delivered together)
	_DeliveryDocument		_DeliveryDocument
	_DeliveryDocumentItem		_DeliveryDocumentItem
	_DocumentFlow		_DocumentFlow

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_DeliveryPickViewItem.
-- 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: IDELIVERYPICKI

CREATE VIEW I_DeliveryPickViewItem AS
SELECT
  I_DeliveryDocumentItem.DeliveryDocument AS DeliveryDocument,
  I_DeliveryDocumentItem.DeliveryDocumentItem AS DeliveryDocumentItem,
  I_DeliveryDocumentItem.DeliveryDocumentItemText AS DeliveryDocumentItemText,
  I_DeliveryDocumentItem.RetailPromotion AS RetailPromotion,
  I_DeliveryDocumentItem.GoodsMovementType AS GoodsMovementType,
  I_DeliveryDocumentItem.Batch AS Batch,
  I_DeliveryDocumentItem.InventoryValuationType AS InventoryValuationType,
  I_DeliveryDocumentItem.MaterialByCustomer AS MaterialByCustomer,
  I_DeliveryDocumentItem.ActualDeliveryQuantity AS ActualDeliveryQuantity,
  I_DeliveryDocumentItem.ActualDeliveredQtyInBaseUnit AS ActualDeliveredQtyInBaseUnit,
  I_DeliveryDocumentItem.Warehouse AS Warehouse,
  I_DeliveryDocumentItem.StorageLocation AS StorageLocation,
  I_DeliveryDocumentItem.WarehouseStorageBin AS WarehouseStorageBin,
  I_DeliveryDocumentItem.StorageBin AS StorageBin,
  I_DeliveryDocumentItem.StorageType AS StorageType,
  I_DeliveryDocumentItem.Material AS Material,
  I_DeliveryDocumentItem.ProductAvailabilityDate AS ProductAvailabilityDate,
  I_DeliveryDocumentItem.BaseUnit AS BaseUnit,
  I_DeliveryDocumentItem.HigherLvlItmOfBatSpltItm AS HigherLvlItmOfBatSpltItm,
  I_DeliveryDocumentItem.DeliveryToBaseQuantityDnmntr AS DeliveryToBaseQuantityDnmntr,
  I_DeliveryDocumentItem.DeliveryToBaseQuantityNmrtr AS DeliveryToBaseQuantityNmrtr,
  I_DeliveryDocumentItem.DeliveryQuantityUnit AS DeliveryQuantityUnit,
  I_DeliveryDocumentItem.Plant AS Plant,
  I_DeliveryDocumentItem.InventorySpecialStockType AS InventorySpecialStockType,
  I_DeliveryDocumentItem.PickingControl AS PickingControl,
  I_DeliveryDocumentItem.ReferenceSDDocument AS ReferenceSDDocument,
  I_DeliveryDocumentItem.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
  I_DeliveryDocumentItem.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  I_DeliveryDocumentItem.ItemGrossWeight AS ItemGrossWeight,
  I_DeliveryDocumentItem.ItemNetWeight AS ItemNetWeight,
  I_DeliveryDocumentItem.ItemWeightUnit AS ItemWeightUnit,
  I_DeliveryDocumentItem.ItemVolume AS ItemVolume,
  I_DeliveryDocumentItem.ItemVolumeUnit AS ItemVolumeUnit,
  I_DeliveryDocumentItem.MaterialIsBatchManaged AS MaterialIsBatchManaged,
  I_DeliveryDocumentItem.MaterialIsIntBatchManaged AS MaterialIsIntBatchManaged,
  I_DeliveryDocumentItem.ReceivingPoint AS ReceivingPoint,
  I_DeliveryDocumentItem.DepartmentClassificationByCust AS DepartmentClassificationByCust,
  I_DeliveryDocumentItem.NumberOfSerialNumbers AS NumberOfSerialNumbers,
  I_DeliveryDocumentItem.BatchBySupplier AS BatchBySupplier,
  I_DeliveryDocumentItem.InternationalArticleNumber AS InternationalArticleNumber,
  I_DeliveryDocumentItem.WarehouseStockCategory AS WarehouseStockCategory,
  I_DeliveryDocumentItem.IssgOrRcvgStockCategory AS IssgOrRcvgStockCategory,
  I_DeliveryDocumentItem.IssgOrRcvgMaterial AS IssgOrRcvgMaterial,
  I_DeliveryDocumentItem.IssuingOrReceivingPlant AS IssuingOrReceivingPlant,
  I_DeliveryDocumentItem.IssuingOrReceivingStorageLoc AS IssuingOrReceivingStorageLoc,
  I_DeliveryDocumentItem.IssgOrRcvgBatch AS IssgOrRcvgBatch,
  I_DeliveryDocumentItem.IssgOrRcvgSpclStockInd AS IssgOrRcvgSpclStockInd,
  I_DeliveryDocumentItem.WarehouseStagingArea AS WarehouseStagingArea,
  I_DeliveryDocumentItem.PrimaryPostingSwitch AS PrimaryPostingSwitch,
  I_DeliveryDocumentItem.InspectionLot AS InspectionLot,
  I_DeliveryDocumentItem.OrderID AS OrderID,
  I_DeliveryDocumentItem.ShelfLifeExpirationDate AS ShelfLifeExpirationDate,
  I_DeliveryDocumentItem.WarehouseActivityStatus AS WarehouseActivityStatus,
  I_DeliveryDocumentItem.PickingStatus AS PickingStatus,
  I_DeliveryDocumentItem.HigherLevelItem AS HigherLevelItem,
  I_DeliveryDocumentItem.HigherLevelItemUsage AS HigherLevelItemUsage,
  I_DeliveryDocumentItem.DeliveryGroup AS DeliveryGroup
FROM I_DeliveryDocumentItem
LEFT OUTER JOIN I_DeliveryDocumentItem AS _DeliveryDocumentItem ON DeliveryDocument = _DeliveryDocumentItem.DeliveryDocument AND DeliveryDocumentItem = _DeliveryDocumentItem.DeliveryDocumentItem  -- association [1..1]
LEFT OUTER JOIN I_DeliveryPickViewDocFlow AS _DocumentFlow ON _DocumentFlow.PrecedingDocument = DeliveryDocument AND _DocumentFlow.PrecedingDocumentItem = DeliveryDocumentItem  -- association [0..*]
LEFT OUTER JOIN E_DeliveryDocumentItem AS _PickViewItemExtension ON DeliveryDocument = _PickViewItemExtension.DeliveryDocument AND DeliveryDocumentItem = _PickViewItemExtension.DeliveryDocumentItem  -- association [0..1]
;

Depth:

I_DeliveryPickViewItem view

I_DeliveryDocumentItem view

P_PCLblProdCmbndByBusProc view