What is C_SustGoodsMovementDocumentDEX in SAP S/4HANA?

C_SustGoodsMovementDocumentDEX is a consumption CDS view in SAP S/4HANA. Goods Movement data extractor It contains 120 fields.

Which tables does C_SustGoodsMovementDocumentDEX read from?

C_SustGoodsMovementDocumentDEX reads data from: I_MaterialDocumentRecord.

What VDM layer is C_SustGoodsMovementDocumentDEX?

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

C_SustGoodsMovementDocumentDEX

DDL: C_SUSTGOODSMOVEMENTDOCUMENTDEX Type: view_entity CONSUMPTION

120 Fields 1 Data Sources 1 Associations

Goods Movement data extractor

C_SustGoodsMovementDocumentDEX (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_SustGoodsMovementDocumentDEX is a Consumption CDS View (Fact) that provides data about "Goods Movement data extractor" in SAP S/4HANA. It reads from 1 data source (I_MaterialDocumentRecord) and exposes 120 fields with key fields MaterialDocumentKey1, MaterialDocumentKey2, MaterialDocumentKey3, MaterialDocumentKey4, MaterialDocumentKey5. It has 1 association to related views.

SAP Help Documentation

Category	CDS Views for Circular Economy

Purpose
This CDS view is used by SAP sustainability applications (such as SAP Responsible Design and Production ) for the data extraction of goods movement 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 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 StockIdentifyingMaterial Stock Identifying Material Plant Plant StorageLocationPlant Storage Location Plant StorageLocationAddressID Storage Location Address ID StorageLocationCountry Storage Location Country StorageLocationRegion Storage Location Region InventorySpecialStockType Inventory Special Stock Type CompanyCode Company Code MaterialBaseUnit Material Base Unit QuantityInBaseUnit Quantity in Base Unit MatlStkChangeQtyInBaseUnit Material Stock Change Quantity in Base Unit EntryUnit Entry Unit QuantityInEntryUnit Quantity in Entry Unit 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 MaterialDocument Material Document MaterialDocumentYear Material Document Year MaterialDocumentItem Material Document Item MaterialDocumentLine Material Document Line SalesOrder Sales Order PurchaseOrder Purchase Order InvtryMgmtReferenceDocument Inventory Management Reference Document ManufacturingOrder Manufacturing Order AccountingDocExternalReference Accounting Document External Reference DeliveryDocument Delivery Document GoodsMovementIsCancelled Goods Movement is Cancelled IsReversalMovementType Is Reversal Movement Type GoodsMovementType Goods Movement Type Material Material Batch Batch Supplier Supplier Customer Customer GoodsRecipientName Goods Recipient Name IssgOrRcvgMaterial Issuing or Receiving Material AccountingDocumentType Accounting Document Type InventoryTransactionType Inventory Transaction Type StockOwner StockOwner IssuingOrReceivingStorageLoc Issuing or Receiving Storage Location IssgOrRcvgStorLocAddressID Issuing or Receiving Storage Location Address ID IssgOrRcvgStorLocCountry Issuing or Receiving Storage Location Country IssgOrRcvgStorLocRegion Issuing or Receiving Storage Location Region PlantAddressID Plant Address ID IssgOrRcvgPlantAddressID Issuing or Receiving Plant Address ID InventoryTransactionType Inventory Transaction Type PlantCountry Plant Country PlantRegion Plant Region IssuingOrReceivingPlantCountry Issuing or Receiving Plant Country IssuingOrReceivingPlantRegion Issuing or Receiving Plant Region SupplierCountry Supplier Country SupplierRegion Supplier Region CustomerCountry Customer Country CustomerRegion Customer Region MaterialType Material Type MaterialCategory Material Category StockChangeCategory Stock Change Category IsCrossPlantTransfer Is Cross Plant Transfer IncotermsClassification Incoterms Classification OrderID Order ID in case the material document refernces an order Order Category Order Category SoldToParty Sold to Party SoldToPartyAddressID Sold to Party Address ID SoldToPartyCountry Sold to Party Country SoldToPartyRegion Sold to Party Region ShipToParty Ship to Party ShipToPartyAddressID Ship to Party Address ID ShipToPartyCountry Shi

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 data extraction of goods movement 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_MaterialDocumentRecord	MaterialDocumentRecord	from

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	I_Order	_Order	`MaterialDocumentRecord.OrderID = _Order.OrderID`

Annotations (15)

Name	Value	Level
EndUserText.label	Goods Movement data extractor	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
Metadata.ignorePropagatedAnnotations	true	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.technicalName	CSUSTGDSMVTDOCDEX	view
Analytics.dataExtraction.enabled	true	view

Fields (120)

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
	MaterialDocumentYear	I_MaterialDocumentRecord	MaterialDocumentYear	Material Document Year
	MaterialDocument	I_MaterialDocumentRecord	MaterialDocument	Number of Material Document
	MaterialDocumentItem	I_MaterialDocumentRecord	MaterialDocumentItem	Material Document Item
	MaterialDocumentLine	I_MaterialDocumentRecord	MaterialDocumentLine	Unique Identification of Document Line
	GoodsMovementType	I_MaterialDocumentRecord	GoodsMovementType	Movement Type (Inventory Management)
	GoodsMovementRefDocType	I_MaterialDocumentRecord	GoodsMovementRefDocType	Goods Movement Reference Document Type
	GoodsMovementIsCancelled	I_MaterialDocumentRecord	GoodsMovementIsCancelled	Item has been Cancelled
	IsReversalMovementType	I_MaterialDocumentRecord	IsReversalMovementType	Has Reversal Movement Type
	StockIdentifyingMaterial	I_MaterialDocumentRecord	StockIdentifyingMaterial	Material for Stock Mamangement
	Plant	I_MaterialDocumentRecord	Plant	Valuation Area
	StorageLocation	I_MaterialDocumentRecord	StorageLocation	Storage Location
	StorageLocationPlant	_StorageLocationAddress	Plant	Valuation Area
	StorageLocationAddressID	_StorageLocationAddress	AddressID	Ship-to address
	StorageLocationCountry	_StorageLocationAddress	Country	Country/Region Key
	StorageLocationRegion	_StorageLocationAddress	Region	Region (State, Province, County)
	InventorySpecialStockType	I_MaterialDocumentRecord	InventorySpecialStockType	Special Stock Type
	InventoryStockType	I_MaterialDocumentRecord	InventoryStockType	Stock Type of Goods Movement (Stock Identifier)
	CompanyCode	I_MaterialDocumentRecord	CompanyCode	Receiver Company Code
	CompanyCodeCurrency	I_MaterialDocumentRecord	CompanyCodeCurrency	Company Code Currency
	ControllingArea	I_MaterialDocumentRecord	ControllingArea	Controlling Area
	CostCenter	I_MaterialDocumentRecord	CostCenter	Cost Center
	PostingDate	I_MaterialDocumentRecord	PostingDate	Posting Date in the Document
	DocumentDate	I_MaterialDocumentRecord	DocumentDate	Document Date in Document
	ManufactureDate	I_MaterialDocumentRecord	ManufactureDate	Date of Manufacture
	CreationDate	I_MaterialDocumentRecord	CreationDate	Day On Which Accounting Document Was Entered
	CreationTime	I_MaterialDocumentRecord	CreationTime	Time of Change
	CalendarDayOfYear	I_MaterialDocumentRecord	CalendarDay	Day of Year (1 - 366)
	CalendarQuarter	I_MaterialDocumentRecord	CalendarQuarter	Calendar Quarter
	CalendarMonth	I_MaterialDocumentRecord	CalendarMonth	Calendar Month
	CalendarWeek	I_MaterialDocumentRecord	CalendarWeek	Calendar Week (1 - 53)
	SalesOrder	I_MaterialDocumentRecord	SalesOrder	Sales Order Number
	SalesOrderItem	I_MaterialDocumentRecord	SalesOrderItem	Sales Order Item
	SalesOrderScheduleLine	I_MaterialDocumentRecord	SalesOrderScheduleLine	Sales Order Schedule
	PurchaseOrder	I_MaterialDocumentRecord	PurchaseOrder	Purchase Order Number
	PurchaseOrderItem	I_MaterialDocumentRecord	PurchaseOrderItem	Item Number of Purchasing Document
	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
	DeliveryDocumentItem	I_MaterialDocumentRecord	DeliveryDocumentItem	Delivery Document Item
	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
	IssuingOrReceivingPlant	I_MaterialDocumentRecord	IssuingOrReceivingPlant	Transfer Plant
	InventoryTransactionType	I_MaterialDocumentRecord	InventoryTransactionType	Transaction/Event Type
	StockOwner	I_MaterialDocumentRecord	StockOwner	Additional Supplier for Special Stock
	IssuingOrReceivingStorageLoc	I_MaterialDocumentRecord	IssuingOrReceivingStorageLoc	Receiving/Issuing Storage Location
	IssgOrRcvgStorLocAddressID	_IssuingOrReceivingStorLocAddr	AddressID	Ship-to address
	IssgOrRcvgStorLocCountry	_IssuingOrReceivingStorLocAddr	Country	Country/Region Key
	IssgOrRcvgStorLocRegion	_IssuingOrReceivingStorLocAddr	Region	Region (State, Province, County)
	MainProduct			Main Product
	PurchasingGroup			Purchasing Group
	PurchasingOrganization			Purchasing Organization
	ProjectNetwork	I_MaterialDocumentRecord	ProjectNetwork	Network Number for Account Assignment
	WBSElementInternalID			WBS Element
	WBSElementExternalID			Work Breakdown Structure Element (WBS Element) Edited
	ProjectExternalID			Project Number (External) Edited
	ProjectInternalID			Project definition
	MaterialType			Material Type
	MaterialCategory			Material Category
	MaterialGroup			Material Group
	OrderID	_Order	OrderID	Order Number
	OrderCategory	_Order	OrderCategory	Order Category
	AccountingDocumentType	I_MaterialDocumentRecord	AccountingDocumentType	Journal Entry Type
	ManufacturingOrderCategory			Order Category
	PlantAddressID			Address
	IssgOrRcvgPlantAddressID			Address
	PlantCountry			Country/Region Key
	PlantRegion			Region (State, Province, County)
	IssuingOrReceivingPlantCountry			Country/Region Key
	IssuingOrReceivingPlantRegion			Region (State, Province, County)
	SupplierCountry			Country/Region Key
	SupplierRegion			Region (State, Province, County)
	CustomerCountry			Country/Region Key
	CustomerRegion			Region (State, Province, County)
	SoldToParty			Customer Number
	SoldToPartyAddressID			Address
	SoldToPartyCountry			Country/Region Key
	SoldToPartyRegion			Region (State, Province, County)
	ShipToParty			Customer Number
	ShipToPartyAddressID			Address
	ShipToPartyCountry			Country/Region Key
	ShipToPartyRegion			Region (State, Province, County)
	SupplyingPlant			Supplying (issuing) plant in case of stock transport order
	SupplyingPlantCountry			Country/Region Key
	SupplyingPlantRegion			Region (State, Province, County)
	SupplyingSupplier			Goods Supplier
	SupplyingSupplierCountry			Country/Region Key
	SupplyingSupplierRegion			Region (State, Province, County)
	IssuingStorageLocation			Issuing Storage Location for Stock Transport Order
	IssuingStorageLocationCountry	_PurchOrdIssuingStorLoc	Country	Country/Region Key
	IssuingStorageLocationRegion	_PurchOrdIssuingStorLoc	Region	Region (State, Province, County)
	ManualDeliveryAddressID			Manual address number in purchasing document item
	ManualDeliveryAddressCountry			Country/Region Key
	ManualDeliveryAddressRegion			Region (State, Province, County)
	Subcontractor			Supplier to be Supplied/Who is to Receive Delivery
	SubcontractorCountry			Country/Region Key
	SubcontractorRegion			Region (State, Province, County)
	PurchaseOrderReceivingCustomer			Customer
	PurOrdReceivingCustomerCountry			Country/Region Key
	PurOrdReceivingCustomerRegion			Region (State, Province, County)
	MaterialBaseUnit	I_MaterialDocumentRecord	MaterialBaseUnit	Base Unit of Measure
	EntryUnit	I_MaterialDocumentRecord	EntryUnit	Unit of Entry
	TotalGoodsMvtAmtInCCCrcy	I_MaterialDocumentRecord	TotalGoodsMvtAmtInCCCrcy	Amount in Local Currency
	GoodsMovementStkAmtInCCCrcy	I_MaterialDocumentRecord	GoodsMovementStkAmtInCCCrcy	Amount in Local Currency with Sign of Stock Quantity
	GoodsMvtCnsmpnAmtInCCCrcy	I_MaterialDocumentRecord	GoodsMvtCnsmpnAmtInCCCrcy	Amount in Local Currency with Sign of Consumption Quantity
	MatlStkChangeQtyInBaseUnit	I_MaterialDocumentRecord	MatlStkChangeQtyInBaseUnit	Stock Quantity
	MatlCnsmpnQtyInMatlBaseUnit	I_MaterialDocumentRecord	MatlCnsmpnQtyInMatlBaseUnit	Consumption Quantity
	QuantityInBaseUnit	I_MaterialDocumentRecord	QuantityInBaseUnit	Quantity
	QuantityInEntryUnit	I_MaterialDocumentRecord	QuantityInEntryUnit	Quantity in Unit of Entry

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_SustGoodsMovementDocumentDEX.
-- 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_SustGoodsMovementDocumentDEX 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.MaterialDocumentYear AS MaterialDocumentYear,
  MaterialDocumentRecord.MaterialDocument AS MaterialDocument,
  MaterialDocumentRecord.MaterialDocumentItem AS MaterialDocumentItem,
  MaterialDocumentRecord.MaterialDocumentLine AS MaterialDocumentLine,
  MaterialDocumentRecord.GoodsMovementType AS GoodsMovementType,
  MaterialDocumentRecord.GoodsMovementRefDocType AS GoodsMovementRefDocType,
  MaterialDocumentRecord.GoodsMovementIsCancelled AS GoodsMovementIsCancelled,
  MaterialDocumentRecord.IsReversalMovementType AS IsReversalMovementType,
  MaterialDocumentRecord.StockIdentifyingMaterial AS StockIdentifyingMaterial,
  MaterialDocumentRecord.Plant AS Plant,
  MaterialDocumentRecord.StorageLocation AS StorageLocation,
  _StorageLocationAddress.Plant AS StorageLocationPlant,
  _StorageLocationAddress.AddressID AS StorageLocationAddressID,
  _StorageLocationAddress.Country AS StorageLocationCountry,
  _StorageLocationAddress.Region AS StorageLocationRegion,
  MaterialDocumentRecord.InventorySpecialStockType AS InventorySpecialStockType,
  MaterialDocumentRecord.InventoryStockType AS InventoryStockType,
  MaterialDocumentRecord.CompanyCode AS CompanyCode,
  MaterialDocumentRecord.CompanyCodeCurrency AS CompanyCodeCurrency,
  MaterialDocumentRecord.ControllingArea AS ControllingArea,
  MaterialDocumentRecord.CostCenter AS CostCenter,
  MaterialDocumentRecord.PostingDate AS PostingDate,
  MaterialDocumentRecord.DocumentDate AS DocumentDate,
  MaterialDocumentRecord.ManufactureDate AS ManufactureDate,
  MaterialDocumentRecord.CreationDate AS CreationDate,
  MaterialDocumentRecord.CreationTime AS CreationTime,
  MaterialDocumentRecord.CalendarDay AS CalendarDayOfYear,
  MaterialDocumentRecord.CalendarQuarter AS CalendarQuarter,
  MaterialDocumentRecord.CalendarMonth AS CalendarMonth,
  MaterialDocumentRecord.CalendarWeek AS CalendarWeek,
  MaterialDocumentRecord.SalesOrder AS SalesOrder,
  MaterialDocumentRecord.SalesOrderItem AS SalesOrderItem,
  MaterialDocumentRecord.SalesOrderScheduleLine AS SalesOrderScheduleLine,
  MaterialDocumentRecord.PurchaseOrder AS PurchaseOrder,
  MaterialDocumentRecord.PurchaseOrderItem AS PurchaseOrderItem,
  MaterialDocumentRecord.InvtryMgmtReferenceDocument AS InvtryMgmtReferenceDocument,
  MaterialDocumentRecord.ManufacturingOrder AS ManufacturingOrder,
  MaterialDocumentRecord.ReferenceDocument AS AccountingDocExternalReference,
  MaterialDocumentRecord.DeliveryDocument AS DeliveryDocument,
  MaterialDocumentRecord.DeliveryDocumentItem AS DeliveryDocumentItem,
  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.IssuingOrReceivingPlant AS IssuingOrReceivingPlant,
  MaterialDocumentRecord.InventoryTransactionType AS InventoryTransactionType,
  MaterialDocumentRecord.StockOwner AS StockOwner,
  MaterialDocumentRecord.IssuingOrReceivingStorageLoc AS IssuingOrReceivingStorageLoc,
  _IssuingOrReceivingStorLocAddr.AddressID AS IssgOrRcvgStorLocAddressID,
  _IssuingOrReceivingStorLocAddr.Country AS IssgOrRcvgStorLocCountry,
  _IssuingOrReceivingStorLocAddr.Region AS IssgOrRcvgStorLocRegion,
  cast(MaterialDocumentRecord._ManufacturingOrder.Material as pph_matko preserving type) AS MainProduct,
  MaterialDocumentRecord._PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  MaterialDocumentRecord._PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  MaterialDocumentRecord.ProjectNetwork AS ProjectNetwork,
  cast(MaterialDocumentRecord.WBSElementInternalID as ps_s4_pspnr preserving type) AS WBSElementInternalID,
  MaterialDocumentRecord._WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  MaterialDocumentRecord._WBSElementBasicData._Project.ProjectExternalID AS ProjectExternalID,
  cast(MaterialDocumentRecord._WBSElementBasicData.ProjectInternalID as ps_pspnr preserving type) AS ProjectInternalID,
  MaterialDocumentRecord._Material.MaterialType AS MaterialType,
  MaterialDocumentRecord._Material.ProductCategory AS MaterialCategory,
  MaterialDocumentRecord._Material.MaterialGroup AS MaterialGroup,
  _Order.OrderID AS OrderID,
  _Order.OrderCategory AS OrderCategory,
  MaterialDocumentRecord.AccountingDocumentType AS AccountingDocumentType,
  MaterialDocumentRecord._ManufacturingOrder.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  MaterialDocumentRecord._Plant.AddressID AS PlantAddressID,
  MaterialDocumentRecord._IssuingOrReceivingPlant.AddressID AS IssgOrRcvgPlantAddressID,
  MaterialDocumentRecord._Plant._StandardOrganizationAddress.Country AS PlantCountry,
  MaterialDocumentRecord._Plant._StandardOrganizationAddress.Region AS PlantRegion,
  MaterialDocumentRecord._IssuingOrReceivingPlant._StandardOrganizationAddress.Country AS IssuingOrReceivingPlantCountry,
  MaterialDocumentRecord._IssuingOrReceivingPlant._StandardOrganizationAddress.Region AS IssuingOrReceivingPlantRegion,
  MaterialDocumentRecord._Supplier.Country AS SupplierCountry,
  MaterialDocumentRecord._Supplier.Region AS SupplierRegion,
  MaterialDocumentRecord._Customer.Country AS CustomerCountry,
  MaterialDocumentRecord._Customer.Region AS CustomerRegion,
  MaterialDocumentRecord._DeliveryDocument._SoldToParty.Customer AS SoldToParty,
  MaterialDocumentRecord._DeliveryDocument._SoldToParty.AddressID AS SoldToPartyAddressID,
  MaterialDocumentRecord._DeliveryDocument._SoldToParty._AddressDefaultRepresentation.Country AS SoldToPartyCountry,
  MaterialDocumentRecord._DeliveryDocument._SoldToParty._AddressDefaultRepresentation.Region AS SoldToPartyRegion,
  MaterialDocumentRecord._DeliveryDocument._ShipToParty.Customer AS ShipToParty,
  MaterialDocumentRecord._DeliveryDocument._ShipToParty.AddressID AS ShipToPartyAddressID,
  MaterialDocumentRecord._DeliveryDocument._ShipToParty._AddressDefaultRepresentation.Country AS ShipToPartyCountry,
  MaterialDocumentRecord._DeliveryDocument._ShipToParty._AddressDefaultRepresentation.Region AS ShipToPartyRegion,
  MaterialDocumentRecord._PurchaseOrder.SupplyingPlant AS SupplyingPlant,
  MaterialDocumentRecord._PurchaseOrder._SupplyingPlant._StandardOrganizationAddress.Country AS SupplyingPlantCountry,
  MaterialDocumentRecord._PurchaseOrder._SupplyingPlant._StandardOrganizationAddress.Region AS SupplyingPlantRegion,
  MaterialDocumentRecord._PurchaseOrder.SupplyingSupplier AS SupplyingSupplier,
  MaterialDocumentRecord._PurchaseOrder._SupplyingSupplier.Country AS SupplyingSupplierCountry,
  MaterialDocumentRecord._PurchaseOrder._SupplyingSupplier.Region AS SupplyingSupplierRegion,
  MaterialDocumentRecord._PurchaseOrderItem.IssuingStorageLocation AS IssuingStorageLocation,
  _PurchOrdIssuingStorLoc.Country AS IssuingStorageLocationCountry,
  _PurchOrdIssuingStorLoc.Region AS IssuingStorageLocationRegion,
  MaterialDocumentRecord._PurchaseOrderItem.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  MaterialDocumentRecord._PurchaseOrderItem._ManualDeliveryAddress_2.Country AS ManualDeliveryAddressCountry,
  MaterialDocumentRecord._PurchaseOrderItem._ManualDeliveryAddress_2.Region AS ManualDeliveryAddressRegion,
  MaterialDocumentRecord._PurchaseOrderItem.Subcontractor AS Subcontractor,
  MaterialDocumentRecord._PurchaseOrderItem._Subcontractor._AddressDefaultRepresentation.Country AS SubcontractorCountry,
  MaterialDocumentRecord._PurchaseOrderItem._Subcontractor._AddressDefaultRepresentation.Region AS SubcontractorRegion,
  MaterialDocumentRecord._PurchaseOrderItem.Customer AS PurchaseOrderReceivingCustomer,
  MaterialDocumentRecord._PurchaseOrderItem._Customer._AddressDefaultRepresentation.Country AS PurOrdReceivingCustomerCountry,
  MaterialDocumentRecord._PurchaseOrderItem._Customer._AddressDefaultRepresentation.Region AS PurOrdReceivingCustomerRegion,
  MaterialDocumentRecord.MaterialBaseUnit AS MaterialBaseUnit,
  MaterialDocumentRecord.EntryUnit AS EntryUnit,
  MaterialDocumentRecord.TotalGoodsMvtAmtInCCCrcy AS TotalGoodsMvtAmtInCCCrcy,
  MaterialDocumentRecord.GoodsMovementStkAmtInCCCrcy AS GoodsMovementStkAmtInCCCrcy,
  MaterialDocumentRecord.GoodsMvtCnsmpnAmtInCCCrcy AS GoodsMvtCnsmpnAmtInCCCrcy,
  MaterialDocumentRecord.MatlStkChangeQtyInBaseUnit AS MatlStkChangeQtyInBaseUnit,
  MaterialDocumentRecord.MatlCnsmpnQtyInMatlBaseUnit AS MatlCnsmpnQtyInMatlBaseUnit,
  MaterialDocumentRecord.QuantityInBaseUnit AS QuantityInBaseUnit,
  MaterialDocumentRecord.QuantityInEntryUnit AS QuantityInEntryUnit
FROM I_MaterialDocumentRecord AS MaterialDocumentRecord
LEFT OUTER JOIN I_Order AS _Order ON MaterialDocumentRecord.OrderID = _Order.OrderID  -- association [0..1]
;

Depth:

C_SustGoodsMovementDocumentDEX view_entity

I_MaterialDocumentRecord view