I_AugmentedGoodsMovement

DDL: I_AUGMENTEDGOODSMOVEMENT SQL: IAUGMGOODSMVMT Type: view COMPOSITE
114 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 114 fields with key fields MaterialDocumentYear, MaterialDocument, MaterialDocumentItem, MaterialDocumentRecordType.

Data Sources (1)

SourceAliasJoin Type
I_GoodsMovementDocument I_GoodsMovementDocument from

Annotations (12)

NameValueLevelField
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName IAUGMGOODSMVMT view
EndUserText.label Augmented view of Goods Movement view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private false view
VDM.viewType #COMPOSITE view

Fields (114)

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

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.
-- SQL view name: IAUGMGOODSMVMT

CREATE VIEW I_AugmentedGoodsMovement AS
SELECT
  MaterialDocumentYear,
  MaterialDocument,
  MaterialDocumentItem,
  MaterialDocumentRecordType,
  I_GoodsMovementDocument.Plant AS Plant,
  I_GoodsMovementDocument.StorageLocation AS StorageLocation,
  Material,
  Batch,
  InventorySpecialStockType,
  InventoryStockType,
  StockOwner,
  CompanyCode,
  InventorySpecialStockValnType,
  CompanyCodeCurrency,
  MaterialBaseUnit,
  IsReversalMovementType,
  IssuingOrReceivingPlant,
  IssuingOrReceivingStorageLoc,
  IssgOrRcvgMaterial,
  IssgOrRcvgBatch,
  IssgOrRcvgSpclStockInd,
  IssuingOrReceivingStockType,
  ResourceID,
  IssgOrRcvgResourceID,
  GoodsMovementIsCancelled,
  DocumentDate,
  PostingDate,
  FiscalYearVariant,
  FiscalYear,
  FiscalYearPeriod,
  YearDay,
  YearWeek,
  YearMonth,
  YearQuarter,
  CalendarQuarter,
  CalendarMonth,
  CalendarWeek,
  CalendarDay,
  WeekDay,
  SalesOrder,
  SalesOrderItem,
  SalesOrderScheduleLine,
  PurchaseOrder,
  PurchaseOrderItem,
  DeliveryDocument,
  DeliveryDocumentItem,
  WBSElementInternalID,
  ManufacturingOrder,
  ManufacturingOrderItem,
  GoodsMovementType,
  GoodsMovementReasonCode,
  InventoryValuationType,
  Supplier,
  Customer,
  AccountAssignmentCategory,
  CostObject,
  CostCenter,
  ControllingArea,
  ProfitabilitySegment,
  ProfitabilitySegment_2,
  ProfitCenter,
  GLAccount,
  FunctionalArea,
  StockChangeCategory,
  IsEffectiveGoodsMovement,
  IsConsumptionMovement,
  IsCrossPlantTransfer,
  IsStorageLocChangeByTransf,
  IsMaterialChangeByTransf,
  IsBatchChangeByTransf,
  IsSpclStkTypeChangeByTransf,
  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
FROM I_GoodsMovementDocument
;

Learn More