What is C_RDPGoodsMovementDocumentDEX in SAP S/4HANA?

C_RDPGoodsMovementDocumentDEX is a consumption CDS view in SAP S/4HANA. Goods Movement Extractor for RDP It contains 55 fields.

Which tables does C_RDPGoodsMovementDocumentDEX read from?

C_RDPGoodsMovementDocumentDEX reads data from: I_MaterialDocumentRecord.

What VDM layer is C_RDPGoodsMovementDocumentDEX?

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

C_RDPGoodsMovementDocumentDEX

DDL: C_RDPGOODSMOVEMENTDOCUMENTDEX Type: view CONSUMPTION

55 Fields 1 Data Sources 5 Associations

Goods Movement Extractor for RDP

C_RDPGoodsMovementDocumentDEX (Consumption)

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

Material Document · Cross Applications

C_RDPGoodsMovementDocumentDEX is a Consumption CDS View (Fact) that provides data about "Goods Movement Extractor for RDP" in SAP S/4HANA. It reads from 1 data source (I_MaterialDocumentRecord) and exposes 55 fields with key fields MaterialDocumentKey1, MaterialDocumentKey2, MaterialDocumentKey3, MaterialDocumentKey4, MaterialDocumentKey5. It has 5 associations to related views.

SAP Help Documentation

Category	CDS Views for Circular Economy

Purpose
This CDS view is used by SAP Responsible Design and Production for the data extraction of relevant material flows. The view provides the necessary data based upon posted material documents.

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

Structure
This view includes the following field: Field Name Description Primary Key MaterialDocumentKey1 Material document key 1 MaterialDocumentKey2 Material document key 2 MaterialDocumentKey3 Material document key 3 MaterialDocumentKey4 Material document key 4 MaterialDocumentKey5 Material document key 5 MaterialDocumentKey6 Material document key 6 Goods Movement Data MaterialDocument Material document MaterialDocumentItem Material document item MaterialDocumentLine Material document line GoodsMovementIsCancelled Goods movement is cancelled IsReversalMovementType Is reversal movement type GoodsMovementType Goods movement type GoodsRecipientName Goods recipient name IssgOrRcvgMaterial Issuing or receiving material IssgOrRcvgBatch Issuing or receiving batch Batch Batch Supplier Supplier Customer Customer GoodsMovementRefDocType Goods movement reference document type AccountingDocumentType Accounting document type InventoryTransactionType Inventory transaction type IncotermsClassification Incoterms classification Product Data Material Material MaterialType Material type MaterialCategory Material category Periods and Times PostingDate Posting date CreationDate Creation date CreationTime Creation time CalendarQuarter Calendar quarter CalendarMonth Calendar month CalendarWeek Calendar week CalendarDayOfYear Calendar day of year ManufactureDate Manufacture date MaterialDocumentYear Material document year Quantities and Units QuantityInBaseUnit Quantitiy in base unit MaterialBaseUnit Material base unit MatlStkChangeQtyInBaseUnit Material stock change quantity in base unit QuantityInEntryUnit Quantity in entry unit EntryUnit Entry unit Reference Documents SalesOrder Sales order PurchaseOrder Purchase order InvtryMgmtReferenceDocument Inventory management reference document ManufacturingOrder Manufacturing order AccountingDocExternalReference Accounting document external reference DeliveryDocument Delivery document Other StockIdentifyingMaterial Stock identifying material Plant Plant InventorySpecialStockType Inventory spcial stock type CompanyCode Company code StockChangeCategory Stock change category IsCrossPlantTransfer Is cross plant transfer IssuingOrReceivingPlant Issuing or receiving plant PlantCountry Plant country IssuingOrReceivingPlantCountry Issuing or receinving plant country SupplierCountry Supplier country CustomerCountry Customer country StorageLocation Storage Location SalesOrderItem Sales Order Item SalesOrderScheduleLine Salesorder Schedule Line DeliveryDocumentItem Delivery Document Item SoldToParty Sold to Party SoldToPartyCountry Sold to Party Country ShipToParty Ship to Party ShipToPartyCountry Ship to Party Country SupplyingSupplier Supplying Supplier SupplyingSupplierCountry Supplying Supplier Country SupplyingPlant Supplying Plant SupplyingPlantCountry Supplying Plant Country StorageLocationCountry Storage Location Country IssuingStorageLocation Issuing Storage Location IssuingStorageLocationCountry Issuing Storage Location Country ManualDeliveryAddressID Manual Delivery Address ID ManualDeliveryAddressCountry Manual Delivery Address Country SubContractor Subcontractor SubContractorCountry Subcontractor Country DropShipmentCustomer Drop Shipment Customer DropShipmentCustomerCountry Drop Shipment Customer Country

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

View on SAP Help Portal →

SAP API Hub

State	Deprecated
Line of Business	Cross Applications
Application Component	SUS-RDP-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 Responsible Design and Production for the data extraction of relevant material flows. The view provides the necessary data based upon posted material documents.</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_MaterialDocumentRecord	MaterialDocumentRecord	from

Associations (5)

Cardinality	Target	Alias	Condition
[0..1]	I_Plant	_Plant	`$projection.Plant = _Plant.Plant`
[0..1]	I_Plant	_IssuingOrReceivingPlant	`$projection.IssuingOrReceivingPlant = _IssuingOrReceivingPlant.Plant`
[0..1]	I_Supplier	_Supplier	`$projection.Supplier = _Supplier.Supplier`
[0..1]	I_Customer	_Customer	`$projection.Customer = _Customer.Customer`
[0..1]	I_Product	_Product	`$projection.Material = _Product.Product`

Annotations (19)

Name	Value	Level
EndUserText.label	Goods Movement Extractor for RDP	view
AbapCatalog.sqlViewName	CRDPGDSMVTDDEX	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	#XXL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.sapObjectNodeType.name	MaterialDocument	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
VDM.lifecycle.status	#DEPRECATED	view
VDM.lifecycle.successor	C_SustGoodsMovementDocumentDEX	view

Fields (55)

Key	Field	Source Table	Source Field	Description
KEY	MaterialDocumentKey1	I_MaterialDocumentRecord	MaterialDocumentKey1	Key field 1
KEY	MaterialDocumentKey2	I_MaterialDocumentRecord	MaterialDocumentKey2	Key field 2
KEY	MaterialDocumentKey3	I_MaterialDocumentRecord	MaterialDocumentKey3	Key field 3
KEY	MaterialDocumentKey4	I_MaterialDocumentRecord	MaterialDocumentKey4	Key field 4
KEY	MaterialDocumentKey5	I_MaterialDocumentRecord	MaterialDocumentKey5	Key field 5
KEY	MaterialDocumentKey6	I_MaterialDocumentRecord	MaterialDocumentKey6	Key field 6
	StockIdentifyingMaterial	I_MaterialDocumentRecord	StockIdentifyingMaterial	Material for Stock Mamangement
	Plant	I_MaterialDocumentRecord	Plant	Valuation Area
	InventorySpecialStockType	I_MaterialDocumentRecord	InventorySpecialStockType	Special Stock Type
	CompanyCode	I_MaterialDocumentRecord	CompanyCode	Receiver Company Code
	MaterialBaseUnit	I_MaterialDocumentRecord	MaterialBaseUnit	Base Unit of Measure
	QuantityInBaseUnit	I_MaterialDocumentRecord	QuantityInBaseUnit	Quantity
	MatlStkChangeQtyInBaseUnit	I_MaterialDocumentRecord	MatlStkChangeQtyInBaseUnit	Stock Quantity
	EntryUnit	I_MaterialDocumentRecord	EntryUnit	Unit of Entry
	QuantityInEntryUnit	I_MaterialDocumentRecord	QuantityInEntryUnit	Quantity in Unit of Entry
	PostingDate	I_MaterialDocumentRecord	PostingDate	Posting Date in the Document
	CreationDate	I_MaterialDocumentRecord	CreationDate	Day On Which Accounting Document Was Entered
	CreationTime	I_MaterialDocumentRecord	CreationTime	Time of Change
	CalendarQuarter	I_MaterialDocumentRecord	CalendarQuarter	Calendar Quarter
	CalendarMonth	I_MaterialDocumentRecord	CalendarMonth	Calendar Month
	CalendarWeek	I_MaterialDocumentRecord	CalendarWeek	Calendar Week (1 - 53)
	CalendarDayOfYear	I_MaterialDocumentRecord	CalendarDay	Day of Year (1 - 366)
	ManufactureDate	I_MaterialDocumentRecord	ManufactureDate	Date of Manufacture
	MaterialDocument	I_MaterialDocumentRecord	MaterialDocument	Number of Material Document
	MaterialDocumentYear	I_MaterialDocumentRecord	MaterialDocumentYear	Material Document Year
	MaterialDocumentItem	I_MaterialDocumentRecord	MaterialDocumentItem	Material Document Item
	MaterialDocumentLine	I_MaterialDocumentRecord	MaterialDocumentLine	Unique Identification of Document Line
	SalesOrder	I_MaterialDocumentRecord	SalesOrder	Sales Order Number
	PurchaseOrder	I_MaterialDocumentRecord	PurchaseOrder	Purchase Order Number
	InvtryMgmtReferenceDocument	I_MaterialDocumentRecord	InvtryMgmtReferenceDocument	Document No. of a Reference Document
	ManufacturingOrder	I_MaterialDocumentRecord	ManufacturingOrder	Manufacturing Order
	AccountingDocExternalReference	I_MaterialDocumentRecord	ReferenceDocument	Reference Document Number
	DeliveryDocument	I_MaterialDocumentRecord	DeliveryDocument	Outbound Delivery
	GoodsMovementIsCancelled	I_MaterialDocumentRecord	GoodsMovementIsCancelled	Item has been Cancelled
	IsReversalMovementType	I_MaterialDocumentRecord	IsReversalMovementType	Has Reversal Movement Type
	GoodsMovementType	I_MaterialDocumentRecord	GoodsMovementType	Movement Type (Inventory Management)
	Material	I_MaterialDocumentRecord	Material	Material Number
	Batch	I_MaterialDocumentRecord	Batch	Batch Number
	Supplier	I_MaterialDocumentRecord	Supplier	Supplier's Account Number
	Customer	I_MaterialDocumentRecord	Customer	Account Number of Customer
	GoodsRecipientName	I_MaterialDocumentRecord	GoodsRecipientName	Goods Recipient
	IssgOrRcvgMaterial	I_MaterialDocumentRecord	IssgOrRcvgMaterial	Transfer Material
	IssgOrRcvgBatch	I_MaterialDocumentRecord	IssgOrRcvgBatch	Transfer Batch
	GoodsMovementRefDocType	I_MaterialDocumentRecord	GoodsMovementRefDocType	Goods Movement Reference Document Type
	IssuingOrReceivingPlant	I_MaterialDocumentRecord	IssuingOrReceivingPlant	Transfer Plant
	AccountingDocumentType	I_MaterialDocumentRecord	AccountingDocumentType	Journal Entry Type
	InventoryTransactionType	I_MaterialDocumentRecord	InventoryTransactionType	Transaction/Event Type
	PlantAddressID	_Plant	AddressID	Ship-to address
	IssgOrRcvgPlantAddressID	_IssuingOrReceivingPlant	AddressID	Ship-to address
	PlantCountry			Country/Region Key
	IssuingOrReceivingPlantCountry			Country/Region Key
	SupplierCountry	_Supplier	Country	Country/Region Key
	CustomerCountry	_Customer	Country	Country/Region Key
	MaterialType	_Product	ProductType	Product Type Group
	MaterialCategory	_Product	ProductCategory	Product Category

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_RDPGoodsMovementDocumentDEX.
-- 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_RDPGoodsMovementDocumentDEX AS
SELECT
  MaterialDocumentRecord.MaterialDocumentKey1 AS MaterialDocumentKey1,
  MaterialDocumentRecord.MaterialDocumentKey2 AS MaterialDocumentKey2,
  MaterialDocumentRecord.MaterialDocumentKey3 AS MaterialDocumentKey3,
  MaterialDocumentRecord.MaterialDocumentKey4 AS MaterialDocumentKey4,
  MaterialDocumentRecord.MaterialDocumentKey5 AS MaterialDocumentKey5,
  MaterialDocumentRecord.MaterialDocumentKey6 AS MaterialDocumentKey6,
  MaterialDocumentRecord.StockIdentifyingMaterial AS StockIdentifyingMaterial,
  MaterialDocumentRecord.Plant AS Plant,
  MaterialDocumentRecord.InventorySpecialStockType AS InventorySpecialStockType,
  MaterialDocumentRecord.CompanyCode AS CompanyCode,
  MaterialDocumentRecord.MaterialBaseUnit AS MaterialBaseUnit,
  MaterialDocumentRecord.QuantityInBaseUnit AS QuantityInBaseUnit,
  MaterialDocumentRecord.MatlStkChangeQtyInBaseUnit AS MatlStkChangeQtyInBaseUnit,
  MaterialDocumentRecord.EntryUnit AS EntryUnit,
  MaterialDocumentRecord.QuantityInEntryUnit AS QuantityInEntryUnit,
  MaterialDocumentRecord.PostingDate AS PostingDate,
  MaterialDocumentRecord.CreationDate AS CreationDate,
  MaterialDocumentRecord.CreationTime AS CreationTime,
  MaterialDocumentRecord.CalendarQuarter AS CalendarQuarter,
  MaterialDocumentRecord.CalendarMonth AS CalendarMonth,
  MaterialDocumentRecord.CalendarWeek AS CalendarWeek,
  MaterialDocumentRecord.CalendarDay AS CalendarDayOfYear,
  MaterialDocumentRecord.ManufactureDate AS ManufactureDate,
  MaterialDocumentRecord.MaterialDocument AS MaterialDocument,
  MaterialDocumentRecord.MaterialDocumentYear AS MaterialDocumentYear,
  MaterialDocumentRecord.MaterialDocumentItem AS MaterialDocumentItem,
  MaterialDocumentRecord.MaterialDocumentLine AS MaterialDocumentLine,
  MaterialDocumentRecord.SalesOrder AS SalesOrder,
  MaterialDocumentRecord.PurchaseOrder AS PurchaseOrder,
  MaterialDocumentRecord.InvtryMgmtReferenceDocument AS InvtryMgmtReferenceDocument,
  MaterialDocumentRecord.ManufacturingOrder AS ManufacturingOrder,
  MaterialDocumentRecord.ReferenceDocument AS AccountingDocExternalReference,
  MaterialDocumentRecord.DeliveryDocument AS DeliveryDocument,
  MaterialDocumentRecord.GoodsMovementIsCancelled AS GoodsMovementIsCancelled,
  MaterialDocumentRecord.IsReversalMovementType AS IsReversalMovementType,
  MaterialDocumentRecord.GoodsMovementType AS GoodsMovementType,
  MaterialDocumentRecord.Material AS Material,
  MaterialDocumentRecord.Batch AS Batch,
  MaterialDocumentRecord.Supplier AS Supplier,
  MaterialDocumentRecord.Customer AS Customer,
  MaterialDocumentRecord.GoodsRecipientName AS GoodsRecipientName,
  MaterialDocumentRecord.IssgOrRcvgMaterial AS IssgOrRcvgMaterial,
  MaterialDocumentRecord.IssgOrRcvgBatch AS IssgOrRcvgBatch,
  MaterialDocumentRecord.GoodsMovementRefDocType AS GoodsMovementRefDocType,
  MaterialDocumentRecord.IssuingOrReceivingPlant AS IssuingOrReceivingPlant,
  MaterialDocumentRecord.AccountingDocumentType AS AccountingDocumentType,
  MaterialDocumentRecord.InventoryTransactionType AS InventoryTransactionType,
  _Plant.AddressID AS PlantAddressID,
  _IssuingOrReceivingPlant.AddressID AS IssgOrRcvgPlantAddressID,
  _Plant._StandardOrganizationAddress.Country AS PlantCountry,
  _IssuingOrReceivingPlant._StandardOrganizationAddress.Country AS IssuingOrReceivingPlantCountry,
  _Supplier.Country AS SupplierCountry,
  _Customer.Country AS CustomerCountry,
  _Product.ProductType AS MaterialType,
  _Product.ProductCategory AS MaterialCategory
FROM I_MaterialDocumentRecord AS MaterialDocumentRecord
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _IssuingOrReceivingPlant ON IssuingOrReceivingPlant = _IssuingOrReceivingPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [0..1]
;

Depth:

C_RDPGoodsMovementDocumentDEX view

I_MaterialDocumentRecord view