What is C_SustDeliveryDocumentItemDEX in SAP S/4HANA?

C_SustDeliveryDocumentItemDEX is a consumption CDS view in SAP S/4HANA. Delivery Document Item Extractor It contains 43 fields.

Which tables does C_SustDeliveryDocumentItemDEX read from?

C_SustDeliveryDocumentItemDEX reads data from: I_DeliveryDocumentItem.

What VDM layer is C_SustDeliveryDocumentItemDEX?

C_SustDeliveryDocumentItemDEX is classified as a Consumption view optimized for specific business scenarios and reporting.

C_SustDeliveryDocumentItemDEX

DDL: C_SUSTDELIVERYDOCUMENTITEMDEX Type: view_entity CONSUMPTION

43 Fields 1 Data Sources 2 Associations

Delivery Document Item Extractor

C_SustDeliveryDocumentItemDEX (Consumption)

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

DeliveryDocumentItem · Cross Applications

C_SustDeliveryDocumentItemDEX is a Consumption CDS View (Fact) that provides data about "Delivery Document Item Extractor" in SAP S/4HANA. It reads from 1 data source (I_DeliveryDocumentItem) and exposes 43 fields with key fields DeliveryDocument, DeliveryDocumentItem. It has 2 associations to related views.

SAP Help Documentation

Category	CDS Views for Circular Economy
Status	Overall Sales and Distribution Process Status

Purpose
This CDS view is used by SAP sustainability applications (such as SAP Responsible Design and Production ) for the extraction of delivery document item data. To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view don't need any special authorization.

Structure
Important Fields Important fields in this view include the following: Field Name Description DeliveryDocument Delivery Document DeliveryDocumentItem Delivery Document Item DeliveryDocumentItemCategory Delivery Document Item Category Material Material Batch Batch ActualDeliveredQtyInBaseUnit Actual Delivered Quantity in Base Unit BaseUnit Base Unit ActualDeliveryQuantity Actual Delivery Quantity DeliveryQuantityUnit Delivery Quantity Unit OverallGoodsMovementStatus Overall Goods Movement Status OverallSDProcessStatus Overall Sales and Distribution Process Status DeliveryDocumentType Delivery Document Type SalesOrganization Sales Organization ShippingPoint Shipping Point DistributionChannel Distribution Channel Division Division Plant Plant PlantCountry Plant Country PlantRegion Plant Region PlantAddressID Plant Address ID ShipToParty Ship to Party ShipToPartyAddressID Ship to Party Address ID ShipToPartyCountry Ship to Party Country ShipToPartyRegion Ship to Party Region ActualGoodsMovementDate Actual Goods Movement Date IncotermsClassification Incoterms Classification CreatedByUser Created by User CreationDate Creation Date CreationTime Creation Time LastChangeDate Last Change Date SoldToParty Sold to Party SoldToPartyAddressID Sold to Party Address ID SoldToPartyCountry Sold to Party Country SoldToPartyRegion Sold to Party Region ReferenceSDDocument Reference Sales and Distribution Document ReferenceSDDocumentItem Reference Sales and Distribution Document Item ReferenceSDDocumentCategory Reference Sales and Distribution Document Category PurchaseOrder Purchase Order PurchaseOrderItem Purchase Order Item StorageLocation Storage Location StorageLocationCountry Storage Location Country StorageLocationRegion Storage Location Region

Data Extraction
Data Extraction Type This CDS view is enabled for data extraction in full mode.

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Cross Applications
Application Component	SUS-INT
Capabilities	Data Source for Data Extraction
Package	Cross Applications for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view is used by SAP sustainability applications (such as SAP Responsible Design and Production) for the extraction of delivery document item data.</p> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

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 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	DeliveryDocumentItem	from

Associations (2)

Cardinality	Target	Alias	Condition
[1..1]	I_DeliveryDocument	_DeliveryDocument	`$projection.DeliveryDocument = _DeliveryDocument.DeliveryDocument`
[0..1]	I_SDDocumentPartner	_SDDocumentCompletePartners	`$projection.DeliveryDocument = _SDDocumentCompletePartners.SDDocument and _SDDocumentCompletePartners.PartnerFunction = 'WE' and ( _SDDocumentCompletePartners.SDDocPartnerAddressRefType = 'D' or _SDDocumentCompletePartners.SDDocPartnerAddressRefType = 'E' or _SDDocumentCompletePartners.SDDocPartnerAddressRefType = 'F' )`

Annotations (15)

Name	Value	Level
EndUserText.label	Delivery Document Item Extractor	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.sapObjectNodeType.name	DeliveryDocumentItem	view
ObjectModel.modelingPattern	#NONE	view
VDM.viewType	#CONSUMPTION	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
Analytics.dataCategory	#FACT	view
Analytics.internalName	#LOCAL	view
Analytics.technicalName	CSUSTDLVRYDOCITEMDEX	view
Analytics.dataExtraction.enabled	true	view

Fields (43)

Key	Field	Source Table	Source Field	Description
KEY	DeliveryDocument	I_DeliveryDocumentItem	DeliveryDocument	Outbound Delivery
KEY	DeliveryDocumentItem	I_DeliveryDocumentItem	DeliveryDocumentItem	Outb. Delivery Item
	DeliveryDocumentItemCategory	I_DeliveryDocumentItem	DeliveryDocumentItemCategory	Delivery Item Category
	Material	I_DeliveryDocumentItem	Material	Material Number
	Batch	I_DeliveryDocumentItem	Batch	Batch Number
	Plant	I_DeliveryDocumentItem	Plant	Valuation Area
	PlantCountry			Country/Region Key
	PlantRegion			Region (State, Province, County)
	PlantAddressID			Address
	StorageLocation	I_DeliveryDocumentItem	StorageLocation	Storage Location
	StorageLocationAddressID	_StorageLocationAddress	AddressID	Ship-to address
	StorageLocationCountry	_StorageLocationAddress	Country	Country/Region Key
	StorageLocationRegion	_StorageLocationAddress	Region	Region (State, Province, County)
	ActualDeliveredQtyInBaseUnit	I_DeliveryDocumentItem	ActualDeliveredQtyInBaseUnit	Actual quantity delivered in stockkeeping units
	BaseUnit	I_DeliveryDocumentItem	BaseUnit	Base Unit of Measure
	ActualDeliveryQuantity	I_DeliveryDocumentItem	ActualDeliveryQuantity	Actual quantity delivered (in sales units)
	DeliveryQuantityUnit	I_DeliveryDocumentItem	DeliveryQuantityUnit	Unit of measure
	SoldToPartyRegion			Region (State, Province, County)
	SoldToPartyCountry			Country/Region Key
	SoldToPartyAddressID			Address
	SoldToParty	_DeliveryDocument	SoldToParty	Sold-to Party
	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
	PurchaseOrder	I_DeliveryDocumentItem	PurchaseOrder	Purchase Order Number
	PurchaseOrderItem	I_DeliveryDocumentItem	PurchaseOrderItem	Item Number of Purchase Order
	OverallGoodsMovementStatus	_DeliveryDocument	OverallGoodsMovementStatus	Goods Movement Status (All Items)
	OverallSDProcessStatus	_DeliveryDocument	OverallSDProcessStatus	Overall Processing Status (Header/All Items)
	DeliveryDocumentType	_DeliveryDocument	DeliveryDocumentType	Delivery Type
	SalesOrganization	_DeliveryDocument	SalesOrganization	Sales Organization
	ShippingPoint	_DeliveryDocument	ShippingPoint	Shipping Point / Receiving Point
	DistributionChannel	I_DeliveryDocumentItem	DistributionChannel	Distribution Channel
	Division	I_DeliveryDocumentItem	Division	Internal Division ID
	ShipToParty	_DeliveryDocument	ShipToParty	Ship-To Party (obsolete)
	ShipToPartyAddressID	_SDDocumentCompletePartners	AddressID	Ship-to address
	ShipToPartyCountry			Country/Region Key
	ShipToPartyRegion			Region (State, Province, County)
	ActualGoodsMovementDate	_DeliveryDocument	ActualGoodsMovementDate	Actual Goods Movement Date
	IncotermsClassification	_DeliveryDocument	IncotermsClassification	Incoterms (Part 1)
	CreatedByUser	I_DeliveryDocumentItem	CreatedByUser	Name of Person Responsible for Creating the Object
	CreationDate	I_DeliveryDocumentItem	CreationDate	Record Created On
	CreationTime	I_DeliveryDocumentItem	CreationTime	Time of Change
	LastChangeDate	I_DeliveryDocumentItem	LastChangeDate	Last Changed On

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 C_SustDeliveryDocumentItemDEX.
-- 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 C_SustDeliveryDocumentItemDEX AS
SELECT
  DeliveryDocumentItem.DeliveryDocument AS DeliveryDocument,
  DeliveryDocumentItem.DeliveryDocumentItem AS DeliveryDocumentItem,
  DeliveryDocumentItem.DeliveryDocumentItemCategory AS DeliveryDocumentItemCategory,
  DeliveryDocumentItem.Material AS Material,
  DeliveryDocumentItem.Batch AS Batch,
  DeliveryDocumentItem.Plant AS Plant,
  DeliveryDocumentItem._Plant._StandardOrganizationAddress.Country AS PlantCountry,
  DeliveryDocumentItem._Plant._StandardOrganizationAddress.Region AS PlantRegion,
  DeliveryDocumentItem._Plant.AddressID AS PlantAddressID,
  DeliveryDocumentItem.StorageLocation AS StorageLocation,
  _StorageLocationAddress.AddressID AS StorageLocationAddressID,
  _StorageLocationAddress.Country AS StorageLocationCountry,
  _StorageLocationAddress.Region AS StorageLocationRegion,
  DeliveryDocumentItem.ActualDeliveredQtyInBaseUnit AS ActualDeliveredQtyInBaseUnit,
  DeliveryDocumentItem.BaseUnit AS BaseUnit,
  DeliveryDocumentItem.ActualDeliveryQuantity AS ActualDeliveryQuantity,
  DeliveryDocumentItem.DeliveryQuantityUnit AS DeliveryQuantityUnit,
  _DeliveryDocument._SoldToParty.Region AS SoldToPartyRegion,
  _DeliveryDocument._SoldToParty.Country AS SoldToPartyCountry,
  _DeliveryDocument._SoldToParty.AddressID AS SoldToPartyAddressID,
  _DeliveryDocument.SoldToParty AS SoldToParty,
  DeliveryDocumentItem.ReferenceSDDocument AS ReferenceSDDocument,
  DeliveryDocumentItem.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
  DeliveryDocumentItem.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  DeliveryDocumentItem.PurchaseOrder AS PurchaseOrder,
  DeliveryDocumentItem.PurchaseOrderItem AS PurchaseOrderItem,
  _DeliveryDocument.OverallGoodsMovementStatus AS OverallGoodsMovementStatus,
  _DeliveryDocument.OverallSDProcessStatus AS OverallSDProcessStatus,
  _DeliveryDocument.DeliveryDocumentType AS DeliveryDocumentType,
  _DeliveryDocument.SalesOrganization AS SalesOrganization,
  _DeliveryDocument.ShippingPoint AS ShippingPoint,
  DeliveryDocumentItem.DistributionChannel AS DistributionChannel,
  DeliveryDocumentItem.Division AS Division,
  _DeliveryDocument.ShipToParty AS ShipToParty,
  _SDDocumentCompletePartners.AddressID AS ShipToPartyAddressID,
  _SDDocumentCompletePartners._DfltAddrRprstn.Country AS ShipToPartyCountry,
  _SDDocumentCompletePartners._DfltAddrRprstn.Region AS ShipToPartyRegion,
  _DeliveryDocument.ActualGoodsMovementDate AS ActualGoodsMovementDate,
  _DeliveryDocument.IncotermsClassification AS IncotermsClassification,
  DeliveryDocumentItem.CreatedByUser AS CreatedByUser,
  DeliveryDocumentItem.CreationDate AS CreationDate,
  DeliveryDocumentItem.CreationTime AS CreationTime,
  DeliveryDocumentItem.LastChangeDate AS LastChangeDate
FROM I_DeliveryDocumentItem AS DeliveryDocumentItem
LEFT OUTER JOIN I_DeliveryDocument AS _DeliveryDocument ON DeliveryDocument = _DeliveryDocument.DeliveryDocument  -- association [1..1]
LEFT OUTER JOIN I_SDDocumentPartner AS _SDDocumentCompletePartners ON DeliveryDocument = _SDDocumentCompletePartners.SDDocument AND _SDDocumentCompletePartners.PartnerFunction = 'WE' AND ( _SDDocumentCompletePartners.SDDocPartnerAddressRefType = 'D' OR _SDDocumentCompletePartners.SDDocPartnerAddressRefType = 'E' OR _SDDocumentCompletePartners.SDDocPartnerAddressRefType = 'F' )  -- association [0..1]
;

Depth:

C_SustDeliveryDocumentItemDEX view_entity

I_DeliveryDocumentItem view