What is I_AugmentedGoodsMovement in SAP S/4HANA?

I_AugmentedGoodsMovement is a composite CDS view in SAP S/4HANA. Augmented view of Goods Movement It contains 116 fields.

Which tables does I_AugmentedGoodsMovement read from?

I_AugmentedGoodsMovement reads data from: I_GoodsMovementDocument.

What VDM layer is I_AugmentedGoodsMovement?

I_AugmentedGoodsMovement is classified as a Composite view that combines data from multiple basic views.

I_AugmentedGoodsMovement

DDL: I_AUGMENTEDGOODSMOVEMENT Type: view_entity COMPOSITE Package: MM_IM_VDM_STOCK

116 Fields 1 Data Sources

Augmented view of Goods Movement

I_AugmentedGoodsMovement is a Composite CDS View that provides data about "Augmented view of Goods Movement" in SAP S/4HANA. It reads from 1 data source (I_GoodsMovementDocument) and exposes 116 fields with key fields MaterialDocumentYear, MaterialDocument, MaterialDocumentItem, MaterialDocumentRecordType. Part of development package MM_IM_VDM_STOCK.

Data Sources (1)

Source	Alias	Join Type
I_GoodsMovementDocument	I_GoodsMovementDocument	from

Annotations (8)

Name	Value	Level
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
EndUserText.label	Augmented view of Goods Movement	view
AccessControl.authorizationCheck	#CHECK	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
VDM.private	false	view
VDM.viewType	#COMPOSITE	view

Fields (116)

Key	Field	Source Table	Source Field	Description
KEY	MaterialDocumentYear	I_GoodsMovementDocument	MaterialDocumentYear	Material Document Year
KEY	MaterialDocument	I_GoodsMovementDocument	MaterialDocument	Material Doc.
KEY	MaterialDocumentItem	I_GoodsMovementDocument	MaterialDocumentItem	Material Document Item
KEY	MaterialDocumentRecordType	I_GoodsMovementDocument	MaterialDocumentRecordType
	Plant	I_GoodsMovementDocument	Plant	Valuation Area
	StorageLocation	I_GoodsMovementDocument	StorageLocation	StorageLocation
	Material	I_GoodsMovementDocument	Material	Vehicle Model
	Batch	I_GoodsMovementDocument	Batch	Lot No.
	InventorySpecialStockType	I_GoodsMovementDocument	InventorySpecialStockType	Special Stock Type
	InventoryStockType	I_GoodsMovementDocument	InventoryStockType	Stock Type
	StockOwner	I_GoodsMovementDocument	StockOwner	Owner of stock
	CompanyCode	I_GoodsMovementDocument	CompanyCode	Receiver Company Code
	InventorySpecialStockValnType	I_GoodsMovementDocument	InventorySpecialStockValnType	Valuation
	CompanyCodeCurrency	I_GoodsMovementDocument	CompanyCodeCurrency	Local Currency
	MaterialBaseUnit	I_GoodsMovementDocument	MaterialBaseUnit	Valuation Unit
	IsReversalMovementType	I_GoodsMovementDocument	IsReversalMovementType
	IssuingOrReceivingPlant	I_GoodsMovementDocument	IssuingOrReceivingPlant	Transfer Plant
	IssuingOrReceivingStorageLoc	I_GoodsMovementDocument	IssuingOrReceivingStorageLoc	Receiving SLoc.
	IssgOrRcvgMaterial	I_GoodsMovementDocument	IssgOrRcvgMaterial	Transfer Material
	IssgOrRcvgBatch	I_GoodsMovementDocument	IssgOrRcvgBatch	Transfer Batch
	IssgOrRcvgSpclStockInd	I_GoodsMovementDocument	IssgOrRcvgSpclStockInd	Special Stock
	IssuingOrReceivingStockType	I_GoodsMovementDocument	IssuingOrReceivingStockType
	ResourceID	I_GoodsMovementDocument	ResourceID	Vehicle ID
	IssgOrRcvgResourceID	I_GoodsMovementDocument	IssgOrRcvgResourceID
	GoodsMovementIsCancelled	I_GoodsMovementDocument	GoodsMovementIsCancelled	Is Item Cancelled
	GoodsMovementCancellationType	I_GoodsMovementDocument	GoodsMovementCancellationType
	DocumentDate	I_GoodsMovementDocument	DocumentDate	Journal Entry Date
	PostingDate	I_GoodsMovementDocument	PostingDate	Posting Date for GR
	FiscalYearVariant	I_GoodsMovementDocument	FiscalYearVariant	FY Variant
	FiscalYear	I_GoodsMovementDocument	FiscalYear	G/L Fiscal Year
	FiscalYearPeriod	I_GoodsMovementDocument	FiscalYearPeriod	Period/Year
	YearDay	I_GoodsMovementDocument	YearDay	Day of the year
	YearWeek	I_GoodsMovementDocument	YearWeek	Year and Calendar Week
	YearMonth	I_GoodsMovementDocument	YearMonth	Year Month
	YearQuarter	I_GoodsMovementDocument	YearQuarter	Year Quarter
	CalendarQuarter	I_GoodsMovementDocument	CalendarQuarter	Calendar Quarter
	CalendarMonth	I_GoodsMovementDocument	CalendarMonth	Calendar Month
	CalendarWeek	I_GoodsMovementDocument	CalendarWeek	Calendar Week
	CalendarDay	I_GoodsMovementDocument	CalendarDay	Occur Day in a Month
	WeekDay	I_GoodsMovementDocument	WeekDay	Weekdays
	SalesOrder	I_GoodsMovementDocument	SalesOrder	SD Document
	SalesOrderItem	I_GoodsMovementDocument	SalesOrderItem	Sales Order Item
	SalesOrderScheduleLine	I_GoodsMovementDocument	SalesOrderScheduleLine	SOrder schedule
	PurchaseOrder	I_GoodsMovementDocument	PurchaseOrder	Purchasing Document
	PurchaseOrderItem	I_GoodsMovementDocument	PurchaseOrderItem	Purchasing Document Item
	DeliveryDocument	I_GoodsMovementDocument	DeliveryDocument	Outbound Delivery
	DeliveryDocumentItem	I_GoodsMovementDocument	DeliveryDocumentItem	Outb. Delivery Item
	WBSElementInternalID	I_GoodsMovementDocument	WBSElementInternalID	WBS Internal ID
	ManufacturingOrder	I_GoodsMovementDocument	ManufacturingOrder	Order
	ManufacturingOrderItem	I_GoodsMovementDocument	ManufacturingOrderItem	Manufacturing Order Item
	GoodsMovementType	I_GoodsMovementDocument	GoodsMovementType	Movement Type
	GoodsMovementReasonCode	I_GoodsMovementDocument	GoodsMovementReasonCode	Reason for Mvmt
	InventoryValuationType	I_GoodsMovementDocument	InventoryValuationType	Valuation Type
	Supplier	I_GoodsMovementDocument	Supplier	Supplier
	Customer	I_GoodsMovementDocument	Customer	Sold-to Party
	AccountAssignmentCategory	I_GoodsMovementDocument	AccountAssignmentCategory	Acct Assgmt Cat
	CostObject	I_GoodsMovementDocument	CostObject	Cost Object
	CostCenter	I_GoodsMovementDocument	CostCenter	Cost Center
	ControllingArea	I_GoodsMovementDocument	ControllingArea	Controlling Area
	ProfitabilitySegment	I_GoodsMovementDocument	ProfitabilitySegment	Profitability Segment
	ProfitabilitySegment_2	I_GoodsMovementDocument	ProfitabilitySegment_2	Profit. segment
	ProfitCenter	I_GoodsMovementDocument	ProfitCenter	Profit Center
	GLAccount	I_GoodsMovementDocument	GLAccount	General Ledger
	FunctionalArea	I_GoodsMovementDocument	FunctionalArea	Sendr Fctl Area
	StockChangeCategory	I_GoodsMovementDocument	StockChangeCategory
	IsEffectiveGoodsMovement	I_GoodsMovementDocument	IsEffectiveGoodsMovement
	IsConsumptionMovement	I_GoodsMovementDocument	IsConsumptionMovement
	IsCrossPlantTransfer	I_GoodsMovementDocument	IsCrossPlantTransfer
	IsStorageLocChangeByTransf	I_GoodsMovementDocument	IsStorageLocChangeByTransf
	IsMaterialChangeByTransf	I_GoodsMovementDocument	IsMaterialChangeByTransf
	IsBatchChangeByTransf	I_GoodsMovementDocument	IsBatchChangeByTransf
	IsSpclStkTypeChangeByTransf	I_GoodsMovementDocument	IsSpclStkTypeChangeByTransf
	IsStockTypeChangeByTransf	I_GoodsMovementDocument	IsStockTypeChangeByTransf
	NumberOfGoodsMovements
	IsStorLocAuthznCheckActive	_AuthStorageLocation	IsStorLocAuthznCheckActive
	IsIssgOrRcvgStorLocAuthChkActv	_AuthStorageLocationTr	IsStorLocAuthznCheckActive
	_Plant	I_GoodsMovementDocument	_Plant
	_StorageLocation	I_GoodsMovementDocument	_StorageLocation
	_Material	I_GoodsMovementDocument	_Material
	_InventorySpecialStockType	I_GoodsMovementDocument	_InventorySpecialStockType
	_InventoryStockType	I_GoodsMovementDocument	_InventoryStockType
	_BPStockOwner	I_GoodsMovementDocument	_BPStockOwner
	_IssgOrRcvgMaterial	I_GoodsMovementDocument	_IssgOrRcvgMaterial
	_IssuingOrReceivingPlant	I_GoodsMovementDocument	_IssuingOrReceivingPlant
	_IssuingOrReceivingStorageLoc	I_GoodsMovementDocument	_IssuingOrReceivingStorageLoc
	_IssgOrRcvgSpclStockInd	I_GoodsMovementDocument	_IssgOrRcvgSpclStockInd
	_IssuingOrReceivingStockType	I_GoodsMovementDocument	_IssuingOrReceivingStockType
	_CostCenter	I_GoodsMovementDocument	_CostCenter
	_ControllingArea	I_GoodsMovementDocument	_ControllingArea
	_AccountAssignmentCategory	I_GoodsMovementDocument	_AccountAssignmentCategory
	_ProfitCenter	I_GoodsMovementDocument	_ProfitCenter
	_GLAccount	I_GoodsMovementDocument	_GLAccount
	_FunctionalArea	I_GoodsMovementDocument	_FunctionalArea
	_GoodsMovementType	I_GoodsMovementDocument	_GoodsMovementType
	_GoodsMovementReasonCode	I_GoodsMovementDocument	_GoodsMovementReasonCode
	_InventoryValuationType	I_GoodsMovementDocument	_InventoryValuationType
	_CompanyCode	I_GoodsMovementDocument	_CompanyCode
	_SalesOrder	I_GoodsMovementDocument	_SalesOrder
	_SalesOrderItem	I_GoodsMovementDocument	_SalesOrderItem
	_SalesOrderScheduleLine	I_GoodsMovementDocument	_SalesOrderScheduleLine
	_PurchaseOrder	I_GoodsMovementDocument	_PurchaseOrder
	_PurchaseOrderItem	I_GoodsMovementDocument	_PurchaseOrderItem
	_DeliveryDocument	I_GoodsMovementDocument	_DeliveryDocument
	_DeliveryDocumentItem	I_GoodsMovementDocument	_DeliveryDocumentItem
	_MfgOrder	I_GoodsMovementDocument	_MfgOrder
	_MfgOrderItem	I_GoodsMovementDocument	_MfgOrderItem
	_Supplier	I_GoodsMovementDocument	_Supplier
	_Customer	I_GoodsMovementDocument	_Customer
	_SupplierCompanyByPlant	I_GoodsMovementDocument	_SupplierCompanyByPlant
	_CustomerCompanyByPlant	I_GoodsMovementDocument	_CustomerCompanyByPlant
	_Currency	I_GoodsMovementDocument	_Currency
	_MaterialBaseUnit	I_GoodsMovementDocument	_MaterialBaseUnit
	_StockChangeCategory	I_GoodsMovementDocument	_StockChangeCategory
	_ResourceBasic	I_GoodsMovementDocument	_ResourceBasic
	_IssgOrRcvgResourceBasic	I_GoodsMovementDocument	_IssgOrRcvgResourceBasic
	_CancelationType	I_GoodsMovementDocument	_CancelationType

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 I_AugmentedGoodsMovement.
-- 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 I_AugmentedGoodsMovement AS
SELECT
  I_GoodsMovementDocument.MaterialDocumentYear AS MaterialDocumentYear,
  I_GoodsMovementDocument.MaterialDocument AS MaterialDocument,
  I_GoodsMovementDocument.MaterialDocumentItem AS MaterialDocumentItem,
  I_GoodsMovementDocument.MaterialDocumentRecordType AS MaterialDocumentRecordType,
  I_GoodsMovementDocument.Plant AS Plant,
  I_GoodsMovementDocument.StorageLocation AS StorageLocation,
  I_GoodsMovementDocument.Material AS Material,
  I_GoodsMovementDocument.Batch AS Batch,
  I_GoodsMovementDocument.InventorySpecialStockType AS InventorySpecialStockType,
  I_GoodsMovementDocument.InventoryStockType AS InventoryStockType,
  I_GoodsMovementDocument.StockOwner AS StockOwner,
  I_GoodsMovementDocument.CompanyCode AS CompanyCode,
  I_GoodsMovementDocument.InventorySpecialStockValnType AS InventorySpecialStockValnType,
  I_GoodsMovementDocument.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_GoodsMovementDocument.MaterialBaseUnit AS MaterialBaseUnit,
  I_GoodsMovementDocument.IsReversalMovementType AS IsReversalMovementType,
  I_GoodsMovementDocument.IssuingOrReceivingPlant AS IssuingOrReceivingPlant,
  I_GoodsMovementDocument.IssuingOrReceivingStorageLoc AS IssuingOrReceivingStorageLoc,
  I_GoodsMovementDocument.IssgOrRcvgMaterial AS IssgOrRcvgMaterial,
  I_GoodsMovementDocument.IssgOrRcvgBatch AS IssgOrRcvgBatch,
  I_GoodsMovementDocument.IssgOrRcvgSpclStockInd AS IssgOrRcvgSpclStockInd,
  I_GoodsMovementDocument.IssuingOrReceivingStockType AS IssuingOrReceivingStockType,
  I_GoodsMovementDocument.ResourceID AS ResourceID,
  I_GoodsMovementDocument.IssgOrRcvgResourceID AS IssgOrRcvgResourceID,
  I_GoodsMovementDocument.GoodsMovementIsCancelled AS GoodsMovementIsCancelled,
  I_GoodsMovementDocument.GoodsMovementCancellationType AS GoodsMovementCancellationType,
  I_GoodsMovementDocument.DocumentDate AS DocumentDate,
  I_GoodsMovementDocument.PostingDate AS PostingDate,
  I_GoodsMovementDocument.FiscalYearVariant AS FiscalYearVariant,
  I_GoodsMovementDocument.FiscalYear AS FiscalYear,
  I_GoodsMovementDocument.FiscalYearPeriod AS FiscalYearPeriod,
  I_GoodsMovementDocument.YearDay AS YearDay,
  I_GoodsMovementDocument.YearWeek AS YearWeek,
  I_GoodsMovementDocument.YearMonth AS YearMonth,
  I_GoodsMovementDocument.YearQuarter AS YearQuarter,
  I_GoodsMovementDocument.CalendarQuarter AS CalendarQuarter,
  I_GoodsMovementDocument.CalendarMonth AS CalendarMonth,
  I_GoodsMovementDocument.CalendarWeek AS CalendarWeek,
  I_GoodsMovementDocument.CalendarDay AS CalendarDay,
  I_GoodsMovementDocument.WeekDay AS WeekDay,
  I_GoodsMovementDocument.SalesOrder AS SalesOrder,
  I_GoodsMovementDocument.SalesOrderItem AS SalesOrderItem,
  I_GoodsMovementDocument.SalesOrderScheduleLine AS SalesOrderScheduleLine,
  I_GoodsMovementDocument.PurchaseOrder AS PurchaseOrder,
  I_GoodsMovementDocument.PurchaseOrderItem AS PurchaseOrderItem,
  I_GoodsMovementDocument.DeliveryDocument AS DeliveryDocument,
  I_GoodsMovementDocument.DeliveryDocumentItem AS DeliveryDocumentItem,
  I_GoodsMovementDocument.WBSElementInternalID AS WBSElementInternalID,
  I_GoodsMovementDocument.ManufacturingOrder AS ManufacturingOrder,
  I_GoodsMovementDocument.ManufacturingOrderItem AS ManufacturingOrderItem,
  I_GoodsMovementDocument.GoodsMovementType AS GoodsMovementType,
  I_GoodsMovementDocument.GoodsMovementReasonCode AS GoodsMovementReasonCode,
  I_GoodsMovementDocument.InventoryValuationType AS InventoryValuationType,
  I_GoodsMovementDocument.Supplier AS Supplier,
  I_GoodsMovementDocument.Customer AS Customer,
  I_GoodsMovementDocument.AccountAssignmentCategory AS AccountAssignmentCategory,
  I_GoodsMovementDocument.CostObject AS CostObject,
  I_GoodsMovementDocument.CostCenter AS CostCenter,
  I_GoodsMovementDocument.ControllingArea AS ControllingArea,
  I_GoodsMovementDocument.ProfitabilitySegment AS ProfitabilitySegment,
  I_GoodsMovementDocument.ProfitabilitySegment_2 AS ProfitabilitySegment_2,
  I_GoodsMovementDocument.ProfitCenter AS ProfitCenter,
  I_GoodsMovementDocument.GLAccount AS GLAccount,
  I_GoodsMovementDocument.FunctionalArea AS FunctionalArea,
  I_GoodsMovementDocument.StockChangeCategory AS StockChangeCategory,
  I_GoodsMovementDocument.IsEffectiveGoodsMovement AS IsEffectiveGoodsMovement,
  I_GoodsMovementDocument.IsConsumptionMovement AS IsConsumptionMovement,
  I_GoodsMovementDocument.IsCrossPlantTransfer AS IsCrossPlantTransfer,
  I_GoodsMovementDocument.IsStorageLocChangeByTransf AS IsStorageLocChangeByTransf,
  I_GoodsMovementDocument.IsMaterialChangeByTransf AS IsMaterialChangeByTransf,
  I_GoodsMovementDocument.IsBatchChangeByTransf AS IsBatchChangeByTransf,
  I_GoodsMovementDocument.IsSpclStkTypeChangeByTransf AS IsSpclStkTypeChangeByTransf,
  I_GoodsMovementDocument.IsStockTypeChangeByTransf AS IsStockTypeChangeByTransf,
  cast ( 1 as nsdm_number_of_gds_mvt) AS NumberOfGoodsMovements,
  _AuthStorageLocation.IsStorLocAuthznCheckActive AS IsStorLocAuthznCheckActive,
  _AuthStorageLocationTr.IsStorLocAuthznCheckActive AS IsIssgOrRcvgStorLocAuthChkActv,
  I_GoodsMovementDocument._Plant AS _Plant,
  I_GoodsMovementDocument._StorageLocation AS _StorageLocation,
  I_GoodsMovementDocument._Material AS _Material,
  I_GoodsMovementDocument._InventorySpecialStockType AS _InventorySpecialStockType,
  I_GoodsMovementDocument._InventoryStockType AS _InventoryStockType,
  I_GoodsMovementDocument._BPStockOwner AS _BPStockOwner,
  I_GoodsMovementDocument._IssgOrRcvgMaterial AS _IssgOrRcvgMaterial,
  I_GoodsMovementDocument._IssuingOrReceivingPlant AS _IssuingOrReceivingPlant,
  I_GoodsMovementDocument._IssuingOrReceivingStorageLoc AS _IssuingOrReceivingStorageLoc,
  I_GoodsMovementDocument._IssgOrRcvgSpclStockInd AS _IssgOrRcvgSpclStockInd,
  I_GoodsMovementDocument._IssuingOrReceivingStockType AS _IssuingOrReceivingStockType,
  I_GoodsMovementDocument._CostCenter AS _CostCenter,
  I_GoodsMovementDocument._ControllingArea AS _ControllingArea,
  I_GoodsMovementDocument._AccountAssignmentCategory AS _AccountAssignmentCategory,
  I_GoodsMovementDocument._ProfitCenter AS _ProfitCenter,
  I_GoodsMovementDocument._GLAccount AS _GLAccount,
  I_GoodsMovementDocument._FunctionalArea AS _FunctionalArea,
  I_GoodsMovementDocument._GoodsMovementType AS _GoodsMovementType,
  I_GoodsMovementDocument._GoodsMovementReasonCode AS _GoodsMovementReasonCode,
  I_GoodsMovementDocument._InventoryValuationType AS _InventoryValuationType,
  I_GoodsMovementDocument._CompanyCode AS _CompanyCode,
  I_GoodsMovementDocument._SalesOrder AS _SalesOrder,
  I_GoodsMovementDocument._SalesOrderItem AS _SalesOrderItem,
  I_GoodsMovementDocument._SalesOrderScheduleLine AS _SalesOrderScheduleLine,
  I_GoodsMovementDocument._PurchaseOrder AS _PurchaseOrder,
  I_GoodsMovementDocument._PurchaseOrderItem AS _PurchaseOrderItem,
  I_GoodsMovementDocument._DeliveryDocument AS _DeliveryDocument,
  I_GoodsMovementDocument._DeliveryDocumentItem AS _DeliveryDocumentItem,
  I_GoodsMovementDocument._MfgOrder AS _MfgOrder,
  I_GoodsMovementDocument._MfgOrderItem AS _MfgOrderItem,
  I_GoodsMovementDocument._Supplier AS _Supplier,
  I_GoodsMovementDocument._Customer AS _Customer,
  I_GoodsMovementDocument._SupplierCompanyByPlant AS _SupplierCompanyByPlant,
  I_GoodsMovementDocument._CustomerCompanyByPlant AS _CustomerCompanyByPlant,
  I_GoodsMovementDocument._Currency AS _Currency,
  I_GoodsMovementDocument._MaterialBaseUnit AS _MaterialBaseUnit,
  I_GoodsMovementDocument._StockChangeCategory AS _StockChangeCategory,
  I_GoodsMovementDocument._ResourceBasic AS _ResourceBasic,
  I_GoodsMovementDocument._IssgOrRcvgResourceBasic AS _IssgOrRcvgResourceBasic,
  I_GoodsMovementDocument._CancelationType AS _CancelationType
FROM I_GoodsMovementDocument
;

Depth:

I_AugmentedGoodsMovement view_entity

I_GoodsMovementDocument view_entity

I_GoodsMovementCube view_entity