Deprecated PUBLIC_LOCAL_API
This CDS view is deprecated in S/4HANA. Use C_SustDeliveryDocumentItemDEX instead. View all deprecated CDS views →

C_RDPDeliveryDocumentItemDEX

DDL: C_RDPDELIVERYDOCUMENTITEMDEX Type: view CONSUMPTION
26 Fields 1 Data Sources 2 Associations

Delivery Document Item Extractor for RDP

C_RDPDeliveryDocumentItemDEX (Consumption)

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

SalesDocumentItem · Cross Applications

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

SAP Help Documentation

CategoryCDS Views for Circular Economy
StatusOverall goods movement status
Purpose
This CDS view is used by SAP Responsible Design and Production for the data extraction of relevant delivery document items. The view provides the necessary data based upon delivery document items. See also CDS view I_DeliveryDocumentItem . See Delivery Document Item . Note: The view does support delta extraction.

Prerequisites
Authorizations Since the CDS entity uses a privileged access control, access is only possible through the data extraction runtime or through other CDS access controls. Therefore, no additional authorizations are needed.

Structure
Field Name Description DeliveryDocument Number and type of the delivery document DeliveryDocumentItem Number of the delivery document item DeliveryDocumentType Type of the delivery document item DeliveryDocumentItemCategory Category of the delivery document item OverallSDProcessStatus Overall processing status of a customer return OverallGoodsMovementStatus Overall goods movement status ActualGoodsMovementDate Actual goods movement date Further important fields Important fields in this view include the following: Field Name Description Material Product number Batch Batch ID ActualDeliveredQtyInBaseUnit Actual quantity delivered in base quantity BaseUnit Unit of measure that belongs to the base quantity ActualDeliveryQuantity Quantity of the delivered item in sales units DeliveryQuantityUnit Unit that belongs to the sales quantity DistributionChannel The distribution channel used for this delivery item Plant Plant the delivery was sent from CreatedByUser Administrative information CreationDate CreationTime LastChangeDate Division Division IncotermsClassification Incoterms for the delivery item

SAP Business Warehouse (SAP BW) Extraction
Data extraction type Full (physical deletions are possible in source tables) Delta (change data capture) Note: In general, for the extraction of delivery documents use the I_DeliveryDocumentItem extraction CDS view. See Delivery Document Item .

View on SAP Help Portal →

SAP API Hub

StateDeprecated
Line of BusinessCross Applications
Application ComponentSUS-RDP-INT
CapabilitiesData Source for Data Extraction
PackageCross Applications for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view is used by SAP Responsible Design and Production for the data extraction of relevant delivery document items. The view provides the necessary data based upon delivery document items. See also CDS view I_DeliveryDocumentItem. See Delivery Document Item.</p> <p>Note: The view does support delta extraction.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_DeliveryDocumentItem I_DeliveryDocumentItem from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_DeliveryDocument _DeliveryDocument $projection.DeliveryDocument = _DeliveryDocument.DeliveryDocument
[0..1] I_SDDocumentCompletePartners _SDDocumentCompletePartners $projection.DeliveryDocument = _SDDocumentCompletePartners.SDDocument and _SDDocumentCompletePartners.SDDocumentItem = '000000' and _SDDocumentCompletePartners.PartnerFunction = 'WE' and ( _SDDocumentCompletePartners.SDDocPartnerAddressRefType = 'D' or _SDDocumentCompletePartners.SDDocPartnerAddressRefType = 'E' or _SDDocumentCompletePartners.SDDocPartnerAddressRefType = 'F' )

Annotations (20)

NameValueLevelField
AbapCatalog.sqlViewName CRDPDLVYDCITMDEX view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name SalesDocumentItem 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.dataExtraction.enabled true view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
EndUserText.label Delivery Document Item Extractor for RDP view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor C_SustDeliveryDocumentItemDEX view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY DeliveryDocument DeliveryDocument Outbound Delivery
KEY DeliveryDocumentItem DeliveryDocumentItem Outb. Delivery Item
DeliveryDocumentItemCategory DeliveryDocumentItemCategory Delivery Item Category
Material Material Material Number
Batch Batch Batch Number
ActualDeliveredQtyInBaseUnit ActualDeliveredQtyInBaseUnit Actual quantity delivered in stockkeeping units
BaseUnit BaseUnit Base Unit of Measure
ActualDeliveryQuantity ActualDeliveryQuantity Actual quantity delivered (in sales units)
DeliveryQuantityUnit DeliveryQuantityUnit Unit of measure
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
DistributionChannel DistributionChannel Distribution Channel
Division Division Internal Division ID
Plant Plant Valuation Area
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 CreatedByUser Name of Person Responsible for Creating the Object
CreationDate CreationDate Record Created On
CreationTime CreationTime Time of Change
LastChangeDate 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_RDPDeliveryDocumentItemDEX.
-- 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_RDPDeliveryDocumentItemDEX AS
SELECT
  DeliveryDocument,
  DeliveryDocumentItem,
  DeliveryDocumentItemCategory,
  Material,
  Batch,
  ActualDeliveredQtyInBaseUnit,
  BaseUnit,
  ActualDeliveryQuantity,
  DeliveryQuantityUnit,
  _DeliveryDocument.OverallGoodsMovementStatus AS OverallGoodsMovementStatus,
  _DeliveryDocument.OverallSDProcessStatus AS OverallSDProcessStatus,
  _DeliveryDocument.DeliveryDocumentType AS DeliveryDocumentType,
  _DeliveryDocument.SalesOrganization AS SalesOrganization,
  DistributionChannel,
  Division,
  Plant,
  _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,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate
FROM I_DeliveryDocumentItem
LEFT OUTER JOIN I_DeliveryDocument AS _DeliveryDocument ON DeliveryDocument = _DeliveryDocument.DeliveryDocument  -- association [1..1]
LEFT OUTER JOIN I_SDDocumentCompletePartners AS _SDDocumentCompletePartners ON DeliveryDocument = _SDDocumentCompletePartners.SDDocument AND _SDDocumentCompletePartners.SDDocumentItem = '000000' AND _SDDocumentCompletePartners.PartnerFunction = 'WE' AND ( _SDDocumentCompletePartners.SDDocPartnerAddressRefType = 'D' OR _SDDocumentCompletePartners.SDDocPartnerAddressRefType = 'E' OR _SDDocumentCompletePartners.SDDocPartnerAddressRefType = 'F' )  -- association [0..1]
;

Learn More