What is A_OutbDeliveryItem in SAP S/4HANA?

A_OutbDeliveryItem is a basic CDS view in SAP S/4HANA. CDS view for API exposure It contains 135 fields.

Which tables does A_OutbDeliveryItem read from?

A_OutbDeliveryItem reads data from: I_DeliveryDocumentItem.

What VDM layer is A_OutbDeliveryItem?

A_OutbDeliveryItem is classified as a Basic (interface) view providing a 1:1 representation of a database table.

A_OutbDeliveryItem

DDL: A_OUTBDELIVERYITEM SQL: AOUTBDELIVERYI Type: view BASIC

135 Fields 1 Data Sources 4 Associations

CDS view for API exposure

A_OutbDeliveryItem is a Basic CDS View that provides data about "CDS view for API exposure" in SAP S/4HANA. It reads from 1 data source (I_DeliveryDocumentItem) and exposes 135 fields with key fields DeliveryDocument, DeliveryDocumentItem. It has 4 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_DeliveryDocumentItem	I_DeliveryDocumentItem	from

Associations (4)

Cardinality	Target	Alias	Condition
[0..*]	A_OutbDeliveryDocFlow	_DocumentFlow	`_DocumentFlow.PrecedingDocument = $projection.DeliveryDocument and _DocumentFlow.PrecedingDocumentItem = $projection.DeliveryDocumentItem`
[1..1]	A_OutbDeliveryHeader	_DeliveryDocument	`_DeliveryDocument.DeliveryDocument = $projection.DeliveryDocument`
[0..1]	A_SerialNmbrDelivery	_SerialDeliveryItem	`_SerialDeliveryItem.DeliveryDocument = $projection.DeliveryDocument and _SerialDeliveryItem.DeliveryDocumentItem = $projection.DeliveryDocumentItem`
[0..1]	E_DeliveryDocumentItem	_Extension	`$projection.DeliveryDocument = _Extension.DeliveryDocument and $projection.DeliveryDocumentItem = _Extension.DeliveryDocumentItem`

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	AOUTBDELIVERYI	view
AbapCatalog.compiler.compareFilter	true	view
Metadata.ignorePropagatedAnnotations	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view
EndUserText.label	CDS view for API exposure	view
AccessControl.authorizationCheck	#CHECK	view
VDM.viewType	#BASIC	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.sizeCategory	#L	view

Fields (135)

Key	Field	Source Table	Source Field	Description
KEY	DeliveryDocument	I_DeliveryDocumentItem	DeliveryDocument	Outbound Delivery
KEY	DeliveryDocumentItem	I_DeliveryDocumentItem	DeliveryDocumentItem	Outb. Delivery Item
	SDDocumentCategory	I_DeliveryDocumentItem	SDDocumentCategory	Document Cat.
	DeliveryDocumentItemCategory	I_DeliveryDocumentItem	DeliveryDocumentItemCategory	Item Category
	SalesDocumentItemType	I_DeliveryDocumentItem	SalesDocumentItemType	Item Type
	CreatedByUser	I_DeliveryDocumentItem	CreatedByUser	User Name
	CreationDate	I_DeliveryDocumentItem	CreationDate	Time Stamp
	CreationTime	I_DeliveryDocumentItem	CreationTime	Time of Change
	LastChangeDate	I_DeliveryDocumentItem	LastChangeDate	Time Stamp
	DistributionChannel	I_DeliveryDocumentItem	DistributionChannel	RefDistCh-Cust/Mat.
	Division	I_DeliveryDocumentItem	Division	Internal Division ID
	SalesGroup	I_DeliveryDocumentItem	SalesGroup	Sales Group
	SalesOffice	I_DeliveryDocumentItem	SalesOffice	Sales Office
	DepartmentClassificationByCust	I_DeliveryDocumentItem	DepartmentClassificationByCust	Department
	Material	I_DeliveryDocumentItem	Material	Vehicle Model
	MaterialByCustomer	I_DeliveryDocumentItem	MaterialByCustomer	Customer Mat.
	OriginallyRequestedMaterial	I_DeliveryDocumentItem	OriginallyRequestedMaterial	MaterialEntered
	InternationalArticleNumber	I_DeliveryDocumentItem	InternationalArticleNumber	EAN/UPC
	Batch	I_DeliveryDocumentItem	Batch	Lot No.
	BatchClassification	I_DeliveryDocumentItem	BatchClassification	Int.object no.
	BatchBySupplier	I_DeliveryDocumentItem	BatchBySupplier	Supplier Batch
	MaterialIsIntBatchManaged	I_DeliveryDocumentItem	MaterialIsIntBatchManaged	HU assignment
	MaterialIsBatchManaged	I_DeliveryDocumentItem	MaterialIsBatchManaged	Batch Mgmt Rqt(Plnt)
	MaterialGroup	I_DeliveryDocumentItem	MaterialGroup	Product Group
	MaterialFreightGroup	I_DeliveryDocumentItem	MaterialFreightGroup	Mat.Freight Grp
	AdditionalMaterialGroup1	I_DeliveryDocumentItem	AdditionalMaterialGroup1	MaterialGroup 1
	AdditionalMaterialGroup2	I_DeliveryDocumentItem	AdditionalMaterialGroup2	MaterialGroup 2
	AdditionalMaterialGroup3	I_DeliveryDocumentItem	AdditionalMaterialGroup3	MaterialGroup 3
	AdditionalMaterialGroup4	I_DeliveryDocumentItem	AdditionalMaterialGroup4	MaterialGroup 4
	AdditionalMaterialGroup5	I_DeliveryDocumentItem	AdditionalMaterialGroup5	MaterialGroup 5
	Plant	I_DeliveryDocumentItem	Plant	Valuation Area
	Warehouse	I_DeliveryDocumentItem	Warehouse	Warehouse No.
	StorageLocation	I_DeliveryDocumentItem	StorageLocation	StorageLocation
	StorageBin	I_DeliveryDocumentItem	StorageBin	Storage Bin
	StorageType	I_DeliveryDocumentItem	StorageType	Storage Type
	InventorySpecialStockType	I_DeliveryDocumentItem	InventorySpecialStockType	Special Stock Type
	ShelfLifeExpirationDate	I_DeliveryDocumentItem	ShelfLifeExpirationDate	SLED/BBD
	NumberOfSerialNumbers	I_DeliveryDocumentItem	NumberOfSerialNumbers	No.serial no.
	ProductConfiguration	I_DeliveryDocumentItem	ProductConfiguration	Object Number
	ProductHierarchyNode	I_DeliveryDocumentItem	ProductHierarchyNode	Prod. Hierarchy
	ManufactureDate	I_DeliveryDocumentItem	ManufactureDate	Date of Manuf.
	DeliveryDocumentItemText	I_DeliveryDocumentItem	DeliveryDocumentItemText	Short Text
	HigherLevelItem	I_DeliveryDocumentItem	HigherLevelItem	Higher-Lev.Item
	HigherLvlItmOfBatSpltItm	I_DeliveryDocumentItem	HigherLvlItmOfBatSpltItm	HghLevItmBatch
	ActualDeliveryQuantity	I_DeliveryDocumentItem	ActualDeliveryQuantity	Base quantity
	QuantityIsFixed	I_DeliveryDocumentItem	QuantityIsFixed	Qty. is fixed
	OriginalDeliveryQuantity	I_DeliveryDocumentItem	OriginalDeliveryQuantity	Base quantity
	DeliveryQuantityUnit	I_DeliveryDocumentItem	DeliveryQuantityUnit	Unit of measure
	ActualDeliveredQtyInBaseUnit	I_DeliveryDocumentItem	ActualDeliveredQtyInBaseUnit	Qty (stckp.unt)
	BaseUnit	I_DeliveryDocumentItem	BaseUnit	Unit of Measure
	DeliveryToBaseQuantityDnmntr	I_DeliveryDocumentItem	DeliveryToBaseQuantityDnmntr	Denominator
	DeliveryToBaseQuantityNmrtr	I_DeliveryDocumentItem	DeliveryToBaseQuantityNmrtr	Numerator
	ProductAvailabilityDate	I_DeliveryDocumentItem	ProductAvailabilityDate	Mat.Avail.Date
	ProductAvailabilityTime	I_DeliveryDocumentItem	ProductAvailabilityTime	Matl Staging Tme
	DeliveryGroup	I_DeliveryDocumentItem	DeliveryGroup	Delivery Group
	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
	InspectionLot	I_DeliveryDocumentItem	InspectionLot	Inspection Lot
	InspectionPartialLot	I_DeliveryDocumentItem	InspectionPartialLot	Partial Lot
	PartialDeliveryIsAllowed	I_DeliveryDocumentItem	PartialDeliveryIsAllowed	Partial Deliv.
	UnlimitedOverdeliveryIsAllowed	I_DeliveryDocumentItem	UnlimitedOverdeliveryIsAllowed	Unlimited Tol.
	OverdelivTolrtdLmtRatioInPct	I_DeliveryDocumentItem	OverdelivTolrtdLmtRatioInPct	Overdeliv. Tol.
	UnderdelivTolrtdLmtRatioInPct	I_DeliveryDocumentItem	UnderdelivTolrtdLmtRatioInPct	Underdel. Tol.
	WarehouseStorageBin	I_DeliveryDocumentItem	WarehouseStorageBin	Storage Bin
	BOMExplosion	I_DeliveryDocumentItem	BOMExplosion	Serial Number
	CustEngineeringChgStatus	I_DeliveryDocumentItem	CustEngineeringChgStatus	Engin. Change
	WarehouseStagingArea	I_DeliveryDocumentItem	WarehouseStagingArea	Staging Area
	WarehouseStockCategory	I_DeliveryDocumentItem	WarehouseStockCategory	Stock Category
	IssgOrRcvgStockCategory	I_DeliveryDocumentItem	IssgOrRcvgStockCategory	Stock Category
	IssgOrRcvgMaterial	I_DeliveryDocumentItem	IssgOrRcvgMaterial	Transfer Material
	IssuingOrReceivingPlant	I_DeliveryDocumentItem	IssuingOrReceivingPlant	Transfer Plant
	IssuingOrReceivingStorageLoc	I_DeliveryDocumentItem	IssuingOrReceivingStorageLoc	Receiving SLoc.
	IssgOrRcvgBatch	I_DeliveryDocumentItem	IssgOrRcvgBatch	Transfer Batch
	IssgOrRcvgValuationType	I_DeliveryDocumentItem	IssgOrRcvgValuationType	Val. Type Tfr.
	IssgOrRcvgSpclStockInd	I_DeliveryDocumentItem	IssgOrRcvgSpclStockInd	Special Stock
	PrimaryPostingSwitch	I_DeliveryDocumentItem	PrimaryPostingSwitch	Main posting id
	StockType	I_DeliveryDocumentItem	StockType	Stock Type
	IsNotGoodsMovementsRelevant	I_DeliveryDocumentItem	IsNotGoodsMovementsRelevant	No gds movement
	GLAccount	I_DeliveryDocumentItem	GLAccount	General Ledger
	GoodsMovementReasonCode	I_DeliveryDocumentItem	GoodsMovementReasonCode	Reason for Mvmt
	SubsequentMovementType	I_DeliveryDocumentItem	SubsequentMovementType	Sub.movmnt type
	IsCompletelyDelivered	I_DeliveryDocumentItem	IsCompletelyDelivered	Is completely delivered
	AlternateProductNumber	I_DeliveryDocumentItem	AlternateProductNumber	Alt.ProdNr.
	PickingControl	I_DeliveryDocumentItem	PickingControl	Picking ID
	LoadingGroup	I_DeliveryDocumentItem	LoadingGroup	Loading Group
	GoodsMovementType	I_DeliveryDocumentItem	GoodsMovementType	Movement Type
	TransportationGroup	I_DeliveryDocumentItem	TransportationGroup	Trans. Group
	ReceivingPoint	I_DeliveryDocumentItem	ReceivingPoint	Recv. Point
	FixedShipgProcgDurationInDays	I_DeliveryDocumentItem	FixedShipgProcgDurationInDays	Fixed proc.time
	VarblShipgProcgDurationInDays	I_DeliveryDocumentItem	VarblShipgProcgDurationInDays	Var. proc. time
	ProofOfDeliveryRelevanceCode	I_DeliveryDocumentItem	ProofOfDeliveryRelevanceCode	POD rel. RC/SC
	ItemIsBillingRelevant	I_DeliveryDocumentItem	ItemIsBillingRelevant	Relev.for Bill.
	ItemBillingBlockReason	I_DeliveryDocumentItem	ItemBillingBlockReason	Billing Block
	PaymentGuaranteeForm	I_DeliveryDocumentItem	PaymentGuaranteeForm	PaytGuarantForm
	IntercompanyBillingStatus	I_DeliveryDocumentItem	IntercompanyBillingStatus
	BusinessArea	I_DeliveryDocumentItem	BusinessArea	Business Area
	ControllingArea	I_DeliveryDocumentItem	ControllingArea	Controlling Area
	ProfitCenter	I_DeliveryDocumentItem	ProfitCenter	Profit Center
	InventoryValuationType	I_DeliveryDocumentItem	InventoryValuationType	Valuation Type
	IsSeparateValuation	I_DeliveryDocumentItem	IsSeparateValuation	Separate val.
	ConsumptionPosting	I_DeliveryDocumentItem	ConsumptionPosting	Consumption Posting
	OrderID	I_DeliveryDocumentItem	OrderID	Order ID
	OrderItem	I_DeliveryDocumentItem	OrderItem	Item Number
	CostCenter	I_DeliveryDocumentItem	CostCenter	Cost Center
	ReferenceSDDocument	I_DeliveryDocumentItem	ReferenceSDDocument	Reference Doc.
	ReferenceSDDocumentItem	I_DeliveryDocumentItem	ReferenceSDDocumentItem	Reference Item
	ReferenceSDDocumentCategory	I_DeliveryDocumentItem	ReferenceSDDocumentCategory	Prec.Doc.Categ.
	ReferenceDocumentLogicalSystem	I_DeliveryDocumentItem	ReferenceDocumentLogicalSystem	Ref. Doc. Lgcl Syst.
	AdditionalCustomerGroup1	I_DeliveryDocumentItem	AdditionalCustomerGroup1	Customer Grp 1
	AdditionalCustomerGroup2	I_DeliveryDocumentItem	AdditionalCustomerGroup2	Customer Grp 2
	AdditionalCustomerGroup3	I_DeliveryDocumentItem	AdditionalCustomerGroup3	Customer Grp 3
	AdditionalCustomerGroup4	I_DeliveryDocumentItem	AdditionalCustomerGroup4	Customer Grp 4
	AdditionalCustomerGroup5	I_DeliveryDocumentItem	AdditionalCustomerGroup5	Customer Grp 5
	RetailPromotion	I_DeliveryDocumentItem	RetailPromotion	Promotion
	StatisticsDate	I_DeliveryDocumentItem	StatisticsDate	Statistics Date
	SDProcessStatus	I_DeliveryDocumentItem	SDProcessStatus	Overall Status
	PickingConfirmationStatus	I_DeliveryDocumentItem	PickingConfirmationStatus	Confirmation
	PickingStatus	I_DeliveryDocumentItem	PickingStatus	Status Value
	WarehouseActivityStatus	I_DeliveryDocumentItem	WarehouseActivityStatus	WM Activity Sts
	PackingStatus	I_DeliveryDocumentItem	PackingStatus	Packing Status
	GoodsMovementStatus	I_DeliveryDocumentItem	GoodsMovementStatus	Gds Movemt Status
	DeliveryRelatedBillingStatus	I_DeliveryDocumentItem	DeliveryRelatedBillingStatus	Del.Rel.BillgSt
	ProofOfDeliveryStatus	I_DeliveryDocumentItem	ProofOfDeliveryStatus	POD status
	ItemGeneralIncompletionStatus	I_DeliveryDocumentItem	ItemGeneralIncompletionStatus	Overall Header
	ItemDeliveryIncompletionStatus	I_DeliveryDocumentItem	ItemDeliveryIncompletionStatus	Delivery – Item
	ItemPickingIncompletionStatus	I_DeliveryDocumentItem	ItemPickingIncompletionStatus	Picking/Putaway–Item
	ItemGdsMvtIncompletionSts	I_DeliveryDocumentItem	ItemGdsMvtIncompletionSts	GoodsMvt–Header
	ItemPackingIncompletionStatus	I_DeliveryDocumentItem	ItemPackingIncompletionStatus	Packing – Item
	ItemBillingIncompletionStatus	I_DeliveryDocumentItem	ItemBillingIncompletionStatus	Billing Doc.
	_DocumentFlow		_DocumentFlow
	_DeliveryDocument		_DeliveryDocument
	_SerialDeliveryItem		_SerialDeliveryItem

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 A_OutbDeliveryItem.
-- 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: AOUTBDELIVERYI

CREATE VIEW A_OutbDeliveryItem AS
SELECT
  I_DeliveryDocumentItem.DeliveryDocument AS DeliveryDocument,
  I_DeliveryDocumentItem.DeliveryDocumentItem AS DeliveryDocumentItem,
  I_DeliveryDocumentItem.SDDocumentCategory AS SDDocumentCategory,
  I_DeliveryDocumentItem.DeliveryDocumentItemCategory AS DeliveryDocumentItemCategory,
  I_DeliveryDocumentItem.SalesDocumentItemType AS SalesDocumentItemType,
  I_DeliveryDocumentItem.CreatedByUser AS CreatedByUser,
  I_DeliveryDocumentItem.CreationDate AS CreationDate,
  I_DeliveryDocumentItem.CreationTime AS CreationTime,
  I_DeliveryDocumentItem.LastChangeDate AS LastChangeDate,
  I_DeliveryDocumentItem.DistributionChannel AS DistributionChannel,
  I_DeliveryDocumentItem.Division AS Division,
  I_DeliveryDocumentItem.SalesGroup AS SalesGroup,
  I_DeliveryDocumentItem.SalesOffice AS SalesOffice,
  I_DeliveryDocumentItem.DepartmentClassificationByCust AS DepartmentClassificationByCust,
  I_DeliveryDocumentItem.Material AS Material,
  I_DeliveryDocumentItem.MaterialByCustomer AS MaterialByCustomer,
  I_DeliveryDocumentItem.OriginallyRequestedMaterial AS OriginallyRequestedMaterial,
  I_DeliveryDocumentItem.InternationalArticleNumber AS InternationalArticleNumber,
  I_DeliveryDocumentItem.Batch AS Batch,
  I_DeliveryDocumentItem.BatchClassification AS BatchClassification,
  I_DeliveryDocumentItem.BatchBySupplier AS BatchBySupplier,
  I_DeliveryDocumentItem.MaterialIsIntBatchManaged AS MaterialIsIntBatchManaged,
  I_DeliveryDocumentItem.MaterialIsBatchManaged AS MaterialIsBatchManaged,
  I_DeliveryDocumentItem.MaterialGroup AS MaterialGroup,
  I_DeliveryDocumentItem.MaterialFreightGroup AS MaterialFreightGroup,
  I_DeliveryDocumentItem.AdditionalMaterialGroup1 AS AdditionalMaterialGroup1,
  I_DeliveryDocumentItem.AdditionalMaterialGroup2 AS AdditionalMaterialGroup2,
  I_DeliveryDocumentItem.AdditionalMaterialGroup3 AS AdditionalMaterialGroup3,
  I_DeliveryDocumentItem.AdditionalMaterialGroup4 AS AdditionalMaterialGroup4,
  I_DeliveryDocumentItem.AdditionalMaterialGroup5 AS AdditionalMaterialGroup5,
  I_DeliveryDocumentItem.Plant AS Plant,
  I_DeliveryDocumentItem.Warehouse AS Warehouse,
  I_DeliveryDocumentItem.StorageLocation AS StorageLocation,
  I_DeliveryDocumentItem.StorageBin AS StorageBin,
  I_DeliveryDocumentItem.StorageType AS StorageType,
  I_DeliveryDocumentItem.InventorySpecialStockType AS InventorySpecialStockType,
  I_DeliveryDocumentItem.ShelfLifeExpirationDate AS ShelfLifeExpirationDate,
  I_DeliveryDocumentItem.NumberOfSerialNumbers AS NumberOfSerialNumbers,
  I_DeliveryDocumentItem.ProductConfiguration AS ProductConfiguration,
  I_DeliveryDocumentItem.ProductHierarchyNode AS ProductHierarchyNode,
  I_DeliveryDocumentItem.ManufactureDate AS ManufactureDate,
  I_DeliveryDocumentItem.DeliveryDocumentItemText AS DeliveryDocumentItemText,
  I_DeliveryDocumentItem.HigherLevelItem AS HigherLevelItem,
  I_DeliveryDocumentItem.HigherLvlItmOfBatSpltItm AS HigherLvlItmOfBatSpltItm,
  I_DeliveryDocumentItem.ActualDeliveryQuantity AS ActualDeliveryQuantity,
  I_DeliveryDocumentItem.QuantityIsFixed AS QuantityIsFixed,
  I_DeliveryDocumentItem.OriginalDeliveryQuantity AS OriginalDeliveryQuantity,
  I_DeliveryDocumentItem.DeliveryQuantityUnit AS DeliveryQuantityUnit,
  I_DeliveryDocumentItem.ActualDeliveredQtyInBaseUnit AS ActualDeliveredQtyInBaseUnit,
  I_DeliveryDocumentItem.BaseUnit AS BaseUnit,
  I_DeliveryDocumentItem.DeliveryToBaseQuantityDnmntr AS DeliveryToBaseQuantityDnmntr,
  I_DeliveryDocumentItem.DeliveryToBaseQuantityNmrtr AS DeliveryToBaseQuantityNmrtr,
  I_DeliveryDocumentItem.ProductAvailabilityDate AS ProductAvailabilityDate,
  I_DeliveryDocumentItem.ProductAvailabilityTime AS ProductAvailabilityTime,
  I_DeliveryDocumentItem.DeliveryGroup AS DeliveryGroup,
  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.InspectionLot AS InspectionLot,
  I_DeliveryDocumentItem.InspectionPartialLot AS InspectionPartialLot,
  I_DeliveryDocumentItem.PartialDeliveryIsAllowed AS PartialDeliveryIsAllowed,
  I_DeliveryDocumentItem.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  I_DeliveryDocumentItem.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  I_DeliveryDocumentItem.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  I_DeliveryDocumentItem.WarehouseStorageBin AS WarehouseStorageBin,
  I_DeliveryDocumentItem.BOMExplosion AS BOMExplosion,
  I_DeliveryDocumentItem.CustEngineeringChgStatus AS CustEngineeringChgStatus,
  I_DeliveryDocumentItem.WarehouseStagingArea AS WarehouseStagingArea,
  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.IssgOrRcvgValuationType AS IssgOrRcvgValuationType,
  I_DeliveryDocumentItem.IssgOrRcvgSpclStockInd AS IssgOrRcvgSpclStockInd,
  I_DeliveryDocumentItem.PrimaryPostingSwitch AS PrimaryPostingSwitch,
  I_DeliveryDocumentItem.StockType AS StockType,
  I_DeliveryDocumentItem.IsNotGoodsMovementsRelevant AS IsNotGoodsMovementsRelevant,
  I_DeliveryDocumentItem.GLAccount AS GLAccount,
  I_DeliveryDocumentItem.GoodsMovementReasonCode AS GoodsMovementReasonCode,
  I_DeliveryDocumentItem.SubsequentMovementType AS SubsequentMovementType,
  I_DeliveryDocumentItem.IsCompletelyDelivered AS IsCompletelyDelivered,
  I_DeliveryDocumentItem.AlternateProductNumber AS AlternateProductNumber,
  I_DeliveryDocumentItem.PickingControl AS PickingControl,
  I_DeliveryDocumentItem.LoadingGroup AS LoadingGroup,
  I_DeliveryDocumentItem.GoodsMovementType AS GoodsMovementType,
  I_DeliveryDocumentItem.TransportationGroup AS TransportationGroup,
  I_DeliveryDocumentItem.ReceivingPoint AS ReceivingPoint,
  I_DeliveryDocumentItem.FixedShipgProcgDurationInDays AS FixedShipgProcgDurationInDays,
  I_DeliveryDocumentItem.VarblShipgProcgDurationInDays AS VarblShipgProcgDurationInDays,
  I_DeliveryDocumentItem.ProofOfDeliveryRelevanceCode AS ProofOfDeliveryRelevanceCode,
  I_DeliveryDocumentItem.ItemIsBillingRelevant AS ItemIsBillingRelevant,
  I_DeliveryDocumentItem.ItemBillingBlockReason AS ItemBillingBlockReason,
  I_DeliveryDocumentItem.PaymentGuaranteeForm AS PaymentGuaranteeForm,
  I_DeliveryDocumentItem.IntercompanyBillingStatus AS IntercompanyBillingStatus,
  I_DeliveryDocumentItem.BusinessArea AS BusinessArea,
  I_DeliveryDocumentItem.ControllingArea AS ControllingArea,
  I_DeliveryDocumentItem.ProfitCenter AS ProfitCenter,
  I_DeliveryDocumentItem.InventoryValuationType AS InventoryValuationType,
  I_DeliveryDocumentItem.IsSeparateValuation AS IsSeparateValuation,
  I_DeliveryDocumentItem.ConsumptionPosting AS ConsumptionPosting,
  I_DeliveryDocumentItem.OrderID AS OrderID,
  I_DeliveryDocumentItem.OrderItem AS OrderItem,
  I_DeliveryDocumentItem.CostCenter AS CostCenter,
  I_DeliveryDocumentItem.ReferenceSDDocument AS ReferenceSDDocument,
  I_DeliveryDocumentItem.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
  I_DeliveryDocumentItem.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  I_DeliveryDocumentItem.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
  I_DeliveryDocumentItem.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
  I_DeliveryDocumentItem.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
  I_DeliveryDocumentItem.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
  I_DeliveryDocumentItem.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
  I_DeliveryDocumentItem.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
  I_DeliveryDocumentItem.RetailPromotion AS RetailPromotion,
  I_DeliveryDocumentItem.StatisticsDate AS StatisticsDate,
  I_DeliveryDocumentItem.SDProcessStatus AS SDProcessStatus,
  I_DeliveryDocumentItem.PickingConfirmationStatus AS PickingConfirmationStatus,
  I_DeliveryDocumentItem.PickingStatus AS PickingStatus,
  I_DeliveryDocumentItem.WarehouseActivityStatus AS WarehouseActivityStatus,
  I_DeliveryDocumentItem.PackingStatus AS PackingStatus,
  I_DeliveryDocumentItem.GoodsMovementStatus AS GoodsMovementStatus,
  I_DeliveryDocumentItem.DeliveryRelatedBillingStatus AS DeliveryRelatedBillingStatus,
  I_DeliveryDocumentItem.ProofOfDeliveryStatus AS ProofOfDeliveryStatus,
  I_DeliveryDocumentItem.ItemGeneralIncompletionStatus AS ItemGeneralIncompletionStatus,
  I_DeliveryDocumentItem.ItemDeliveryIncompletionStatus AS ItemDeliveryIncompletionStatus,
  I_DeliveryDocumentItem.ItemPickingIncompletionStatus AS ItemPickingIncompletionStatus,
  I_DeliveryDocumentItem.ItemGdsMvtIncompletionSts AS ItemGdsMvtIncompletionSts,
  I_DeliveryDocumentItem.ItemPackingIncompletionStatus AS ItemPackingIncompletionStatus,
  I_DeliveryDocumentItem.ItemBillingIncompletionStatus AS ItemBillingIncompletionStatus
FROM I_DeliveryDocumentItem
LEFT OUTER JOIN A_OutbDeliveryDocFlow AS _DocumentFlow ON _DocumentFlow.PrecedingDocument = DeliveryDocument AND _DocumentFlow.PrecedingDocumentItem = DeliveryDocumentItem  -- association [0..*]
LEFT OUTER JOIN A_OutbDeliveryHeader AS _DeliveryDocument ON _DeliveryDocument.DeliveryDocument = DeliveryDocument  -- association [1..1]
LEFT OUTER JOIN A_SerialNmbrDelivery AS _SerialDeliveryItem ON _SerialDeliveryItem.DeliveryDocument = DeliveryDocument AND _SerialDeliveryItem.DeliveryDocumentItem = DeliveryDocumentItem  -- association [0..1]
LEFT OUTER JOIN E_DeliveryDocumentItem AS _Extension ON DeliveryDocument = _Extension.DeliveryDocument AND DeliveryDocumentItem = _Extension.DeliveryDocumentItem  -- association [0..1]
;

Depth:

A_OutbDeliveryItem view

I_DeliveryDocumentItem view