I_GoodsMovementDocumentDEX

DDL: I_GOODSMOVEMENTDOCUMENTDEX Type: view COMPOSITE

Material document data extraction

I_GoodsMovementDocumentDEX (Composite)

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

Material Stock · Supply Chain

I_GoodsMovementDocumentDEX is a Composite CDS View (Fact) that provides data about "Material document data extraction" in SAP S/4HANA. It reads from 1 data source (I_MaterialDocumentRecord) and exposes 140 fields with key fields MaterialDocumentKey1, MaterialDocumentKey2, MaterialDocumentKey3, MaterialDocumentKey4, MaterialDocumentKey5.

SAP Help Documentation

CategoryCDS Views for Stock and Material Documents
Data CategoryFact
StatusReleased
Purpose
This CDS view is intended to be used for data extraction of the material document. The view provides all important data of the material document posting. The view is enabled for delta extraction. You may build your own BW content based on the data provided by this view. Note Important technical information: The view provides 6 technical key fields MaterialDocumentKey1 to MaterialDocumentKey6 . These fields are required for the delta extraction only. They have no business meaning. In the view these fields are defined as RAW type. The BW transformation cannot handle such RAW field types and therefore these fields need to be defined in the transformation as type CHAR where the length of the CHAR field is 4 times the length of the corresponding RAW field. This CDS view provides the prerequisites for answering the following business questions: Which material has been posted to which stock type? Which material has been posted to which special stock type and to which reference object? How many transfer postings have been done last month? Between which plants have materials be transferred? Note This extractor and the CDS view I_GoodsMovementSubstituteDEX should be used in combination to calculate stocks.

Prerequisites
The following authorization objects are required: M_MSEG_WMB M_MSEG_BMB F_LFA1_BEK F_KNA1_BED M_MSEG_LGO (only relevant for on-premise system if activated in the customizing)

Structure
Parameters The main filters are as follows: Material Plant StorageLocation InventoryStockType Further important fields Important fields in this view include the following: Field Name Description MaterialDocumentYear MaterialDocument MaterialDocumentItem Plant StorageLocation Material Batch InventorySpecialStockType InventoryStockType StockOwner CompanyCode InventorySpecialStockValnType CompanyCodeCurrency MaterialBaseUnit EntryUnit OrderQuantityUnit IsReversalMovementType InventoryTransactionType ConsumptionPosting GoodsReceiptType IssuingOrReceivingPlant IssuingOrReceivingStorageLoc IssgOrRcvgMaterial IssgOrRcvgBatch IssgOrRcvgSpclStockInd IssuingOrReceivingStockType IssuingOrReceivingValType ResourceID IssgOrRcvgResourceID Cancellation Information GoodsMovementIsCancelled ReversedMaterialDocument ReversedMaterialDocumentItem ReversedMaterialDocumentYear Periods & Times DocumentDate AccountingDocumentType CreationDate CreationTime PostingDate FiscalYearVariant FiscalYear FiscalYearPeriod YearDay YearWeek YearMonth YearQuarter CalendarQuarter CalendarMonth CalendarWeek CalendarDay WeekDay Reference Documents SalesOrder SalesOrderItem SalesOrderScheduleLine PurchaseOrder PurchaseOrderItem ProjectNetwork DeliveryDocument DeliveryDocumentItem WBSElementInternalID ManufacturingOrder ManufacturingOrderItem SpecialStockIdfgSalesOrder SpecialStockIdfgSalesOrderItem SpecialStockIdfgWBSElement ReferenceDocument GoodsIssueOrReceiptSlipNumber ReferenceDocumentFiscalYear InvtryMgmtRefDocumentItem InvtryMgmtReferenceDocument Other GoodsMovementType InventoryValuationType Supplier Customer MaterialDocumentHeaderText MaterialDocumentItemText IsCompletelyDelivered GoodsRecipientName UnloadingPointName GoodsMovementRefDocType GoodsMovementReasonCode ShelfLifeExpirationDate ManufactureDate SerialNumbersAreCreatedAutomly VersionForPrintingSlip ManualPrintIsTriggered Accounting Information AccountAssignmentCategory CostCenter ControllingArea CostObject GLAccount FunctionalArea ProfitabilitySegment_2 ProfitCenter MasterFixedAsset FixedAsset FundsCenter Fund CommitmentItemShortID GrantID Field ProfitabilitySegment_2 is the successor of field ProfitabilitySegment . Reservation Reservation ReservationItem ReservationIsFinallyIssued DebitCreditCode Amounts TotalGoodsMvtAmtInCCCrcy GoodsMovementStkAmtInCCCrcy GoodsMvtCnsmpnAmtInCCCrcy GdsMvtExtAmtInCoCodeCrcy SlsPrcAmtInclVATInCoCodeCrcy EnteredSlsAmtInCoCodeCrcy Quantities MatlStkChangeQtyInBaseUnit MatlCnsmpnQtyInMatlBaseUnit QuantityInBaseUnit QuantityInEntryUnit GoodsReceiptQtyInOrderUnit

SAP Busines

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessSupply Chain
Application ComponentMM-IM-VDM-SGM
CapabilitiesData Source for Data Extraction
PackageSupply Chain for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view is intended to be used for data extraction of the material document. The view provides all important data of the material document posting. The view is enabled for delta extraction.</p> <p>You may build your own BW content based on the data provided by this view.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>Which material has been posted to which stock type?</p></li> <li><p>Which material has been posted to which special stock type and to which reference object?</p></li> <li><p>How many transfer postings have been done last month?</p></li> <li><p>Between which plants have materials be transferred?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_MaterialDocumentRecord I_MaterialDocumentRecord from

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName IGOODSMVMTDOCDEX view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Material document data extraction view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name MaterialStock view
VDM.viewType #COMPOSITE 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

Fields (140)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocumentKey1 MaterialDocumentKey1 Key field 1
KEY MaterialDocumentKey2 MaterialDocumentKey2 Key field 2
KEY MaterialDocumentKey3 MaterialDocumentKey3 Key field 3
KEY MaterialDocumentKey4 MaterialDocumentKey4 Key field 4
KEY MaterialDocumentKey5 MaterialDocumentKey5 Key field 5
KEY MaterialDocumentKey6 MaterialDocumentKey6 Key field 6
MaterialDocumentYear MaterialDocumentYear Material Document Year
MaterialDocument MaterialDocument Number of Material Document
MaterialDocumentItem MaterialDocumentItem Material Document Item
StockIdentifyingMaterial StockIdentifyingMaterial Material for Stock Mamangement
Plant Plant Valuation Area
StockIdfgStorageLocation StockIdfgStorageLocation Storage Location (Stock Identifier)
StockIdentifyingBatch StockIdentifyingBatch Batch Number (Stock Identifier)
SpecialStockIdfgSupplier SpecialStockIdfgSupplier Supplier for Special Stock
SpecialStockIdfgSalesOrder SpecialStockIdfgSalesOrder Sales Order Number of Valuated Sales Order Stock
SpecialStockIdfgSalesOrderItem SpecialStockIdfgSalesOrderItem Sales Order Item of Valuated Sales Order Stock
SpecialStockIdfgCustomer SpecialStockIdfgCustomer Customer for Special Stock
InventorySpecialStockType InventorySpecialStockType Special Stock Type
InventoryStockType InventoryStockType Stock Type of Goods Movement (Stock Identifier)
SpecialStockIdfgStockOwner SpecialStockIdfgStockOwner Add. Supplier for Special Stock
ResourceID Vehicle ID
CostEstimate CostEstimate Cost Estimate Number - Product Costing
StorageLocation StorageLocation Storage Location
Material Material Material Number
Batch Batch Batch Number
StockOwner StockOwner Additional Supplier for Special Stock
CompanyCode CompanyCode Receiver Company Code
InventorySpecialStockValnType InventorySpecialStockValnType Separate Valuation Type
CompanyCodeCurrency CompanyCodeCurrency Company Code Currency
MaterialBaseUnit MaterialBaseUnit Base Unit of Measure
EntryUnit EntryUnit Unit of Entry
OrderQuantityUnit OrderQuantityUnit Purchase Order Unit of Measure
IsReversalMovementType IsReversalMovementType Has Reversal Movement Type
InventoryTransactionType InventoryTransactionType Transaction/Event Type
ConsumptionPosting ConsumptionPosting Consumption Posting
GoodsReceiptType GoodsReceiptType Receipt Indicator
IssuingOrReceivingPlant IssuingOrReceivingPlant Transfer Plant
IssuingOrReceivingStorageLoc IssuingOrReceivingStorageLoc Receiving/Issuing Storage Location
IssgOrRcvgMaterial IssgOrRcvgMaterial Transfer Material
IssgOrRcvgBatch IssgOrRcvgBatch Transfer Batch
IssgOrRcvgSpclStockInd IssgOrRcvgSpclStockInd Special Stock Indicator
IssuingOrReceivingStockType IssuingOrReceivingStockType Transfer Stock Type
IssuingOrReceivingValType IssuingOrReceivingValType Transfer Batch (Valuation Type)
IssgOrRcvgResourceID Resource Name Compl
GoodsMovementIsCancelled GoodsMovementIsCancelled Item has been Cancelled
ReversedMaterialDocument ReversedMaterialDocument Reversed Material Document
ReversedMaterialDocumentItem ReversedMaterialDocumentItem Reversed Material Document Item
ReversedMaterialDocumentYear ReversedMaterialDocumentYear Reversed Material Document Year
DocumentDate DocumentDate Document Date in Document
AccountingDocumentType AccountingDocumentType Journal Entry Type
CreationDate CreationDate Day On Which Accounting Document Was Entered
CreationTime CreationTime Time of Change
PostingDate PostingDate Posting Date in the Document
FiscalYearVariant FiscalYearVariant Fiscal Year Variant
FiscalYear FiscalYear G/L Fiscal Year
FiscalYearPeriod FiscalYearPeriod Period/Year
YearDay YearDay Year-Day-Combination
YearWeek YearWeek Year and Calendar Week
YearMonth YearMonth Year-Month-Combination
YearQuarter YearQuarter Year-Quarter-Combination
CalendarQuarter CalendarQuarter Calendar Quarter
CalendarMonth CalendarMonth Calendar Month
CalendarWeek CalendarWeek Calendar Week (1 - 53)
CalendarDay CalendarDay Day of Year (1 - 366)
WeekDay WeekDay Day of Week
SalesOrder SalesOrder Sales Order Number
SalesOrderItem SalesOrderItem Sales Order Item
SalesOrderScheduleLine SalesOrderScheduleLine Sales Order Schedule
PurchaseOrder PurchaseOrder Purchase Order Number
PurchaseOrderItem Item Number of Purchasing Document
ProjectNetwork ProjectNetwork Network Number for Account Assignment
DeliveryDocument DeliveryDocument Outbound Delivery
DeliveryDocumentItem Outb. Delivery Item
ManufacturingOrder ManufacturingOrder Manufacturing Order
ManufacturingOrderItem ManufacturingOrderItem Manufacturing Order Item
ReferenceDocument ReferenceDocument Reference Document Number
GoodsIssueOrReceiptSlipNumber GoodsIssueOrReceiptSlipNumber Goods Receipt/Issue Slip Number
ReferenceDocumentFiscalYear ReferenceDocumentFiscalYear Fiscal Year of a Reference Document
InvtryMgmtRefDocumentItem InvtryMgmtRefDocumentItem Item of a Reference Document
InvtryMgmtReferenceDocument InvtryMgmtReferenceDocument Document No. of a Reference Document
GoodsMovementType GoodsMovementType Movement Type (Inventory Management)
InventoryValuationType InventoryValuationType Valuation Type
CreatedByUser CreatedByUser User Name
Supplier Supplier Supplier's Account Number
Customer Customer Account Number of Customer
IsMaterialDocumentHeader IsMaterialDocumentHeader Material Document Counter
MaterialDocumentHeaderText MaterialDocumentHeaderText Document Header Text
MaterialDocumentItemText MaterialDocumentItemText Item Text
IsCompletelyDelivered IsCompletelyDelivered "Delivery Completed" Indicator
GoodsRecipientName GoodsRecipientName Goods Recipient
UnloadingPointName UnloadingPointName Unloading Point Name
GoodsMovementRefDocType GoodsMovementRefDocType Goods Movement Reference Document Type
GoodsMovementReasonCode GoodsMovementReasonCode Reason for Movement
ShelfLifeExpirationDate ShelfLifeExpirationDate Shelf Life Expiration or Best-Before Date
ManufactureDate ManufactureDate Date of Manufacture
SerialNumbersAreCreatedAutomly SerialNumbersAreCreatedAutomly Create Serial Number Automatically
VersionForPrintingSlip VersionForPrintingSlip Version for Printing GR/GI Slip
ManualPrintIsTriggered ManualPrintIsTriggered Print via Output Control
AccountAssignmentCategory AccountAssignmentCategory Account Assignment Category
CostCenter CostCenter Cost Center
ControllingArea ControllingArea Controlling Area
CostObject CostObject Cost Object
GLAccount GLAccount G/L Account Number
FunctionalArea FunctionalArea Sendr Fctl Area
ProfitabilitySegment ProfitabilitySegment Deprecated: Profitability Segment
ProfitabilitySegment_2 ProfitabilitySegment_2 Profitability Segment
ProfitCenter ProfitCenter Profit Center
MasterFixedAsset MasterFixedAsset Main Asset Number
FixedAsset FixedAsset Asset Subnumber
FundsCenter FundsCenter Funds Center
Fund Fund Sender Fund
CommitmentItemShortID CommitmentItemShortID Commitment Item Short ID
GrantID GrantID Sender Grant
Reservation Reservation Number of Reservation/Dependent Requirements
ReservationItem ReservationItem Item Number of Reservation / Dependent Requirements
ReservationIsFinallyIssued ReservationIsFinallyIssued Final Issue for Reservation
DebitCreditCode DebitCreditCode Debit/Credit Indicator
TotalGoodsMvtAmtInCCCrcy TotalGoodsMvtAmtInCCCrcy Amount in Local Currency
GoodsMovementStkAmtInCCCrcy GoodsMovementStkAmtInCCCrcy Amount in Local Currency with Sign of Stock Quantity
GoodsMvtCnsmpnAmtInCCCrcy GoodsMvtCnsmpnAmtInCCCrcy Amount in Local Currency with Sign of Consumption Quantity
GdsMvtExtAmtInCoCodeCrcy GdsMvtExtAmtInCoCodeCrcy Externally Entered Posting Amount in Local Currency
SlsPrcAmtInclVATInCoCodeCrcy SlsPrcAmtInclVATInCoCodeCrcy Sales Value Including Value-Added Tax
EnteredSlsAmtInCoCodeCrcy EnteredSlsAmtInCoCodeCrcy Externally Entered Sales Value in Local Currency
MatlStkChangeQtyInBaseUnit MatlStkChangeQtyInBaseUnit Stock Quantity
MatlCnsmpnQtyInMatlBaseUnit MatlCnsmpnQtyInMatlBaseUnit Consumption Quantity
QuantityInBaseUnit QuantityInBaseUnit Quantity
QuantityInEntryUnit QuantityInEntryUnit Quantity in Unit of Entry
GoodsReceiptQtyInOrderUnit GoodsReceiptQtyInOrderUnit Goods Reciepts Quantity in Order Unit
TransactionCode TransactionCode Transaction Code
IsAutomaticallyCreated IsAutomaticallyCreated Item Automatically Created Indicator
MaterialDocumentLine MaterialDocumentLine Unique Identification of Document Line
MaterialDocumentParentLine MaterialDocumentParentLine Identifier of immediately superior line
HierarchyNodeLevel HierarchyNodeLevel Hierarchy Level of Line in Document
_Supplier _Supplier
_BPStockOwner _BPStockOwner
_Customer _Customer
_SupplierCompanyByPlant _SupplierCompanyByPlant
_CustomerCompanyByPlant _CustomerCompanyByPlant
_StorageLocation _StorageLocation
_IssuingOrReceivingStorageLoc _IssuingOrReceivingStorageLoc

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_GoodsMovementDocumentDEX.
-- 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_GoodsMovementDocumentDEX AS
SELECT
  MaterialDocumentKey1,
  MaterialDocumentKey2,
  MaterialDocumentKey3,
  MaterialDocumentKey4,
  MaterialDocumentKey5,
  MaterialDocumentKey6,
  MaterialDocumentYear,
  MaterialDocument,
  MaterialDocumentItem,
  StockIdentifyingMaterial,
  Plant,
  StockIdfgStorageLocation,
  StockIdentifyingBatch,
  SpecialStockIdfgSupplier,
  SpecialStockIdfgSalesOrder,
  SpecialStockIdfgSalesOrderItem,
  SpecialStockIdfgCustomer,
  InventorySpecialStockType,
  InventoryStockType,
  SpecialStockIdfgStockOwner,
  cast(ResourceID as nsdm_resourcename preserving type ) AS ResourceID,
  CostEstimate,
  StorageLocation,
  Material,
  Batch,
  StockOwner,
  CompanyCode,
  InventorySpecialStockValnType,
  CompanyCodeCurrency,
  MaterialBaseUnit,
  EntryUnit,
  OrderQuantityUnit,
  IsReversalMovementType,
  InventoryTransactionType,
  ConsumptionPosting,
  GoodsReceiptType,
  IssuingOrReceivingPlant,
  IssuingOrReceivingStorageLoc,
  IssgOrRcvgMaterial,
  IssgOrRcvgBatch,
  IssgOrRcvgSpclStockInd,
  IssuingOrReceivingStockType,
  IssuingOrReceivingValType,
  cast(IssgOrRcvgResourceID as nsdm_transfer_resourcename preserving type ) AS IssgOrRcvgResourceID,
  GoodsMovementIsCancelled,
  ReversedMaterialDocument,
  ReversedMaterialDocumentItem,
  ReversedMaterialDocumentYear,
  DocumentDate,
  AccountingDocumentType,
  CreationDate,
  CreationTime,
  PostingDate,
  FiscalYearVariant,
  FiscalYear,
  FiscalYearPeriod,
  YearDay,
  YearWeek,
  YearMonth,
  YearQuarter,
  CalendarQuarter,
  CalendarMonth,
  CalendarWeek,
  CalendarDay,
  WeekDay,
  SalesOrder,
  SalesOrderItem,
  SalesOrderScheduleLine,
  PurchaseOrder,
  cast(PurchaseOrderItem as nsdm_ebelp preserving type) AS PurchaseOrderItem,
  ProjectNetwork,
  DeliveryDocument,
  cast(DeliveryDocumentItem as nsdm_posnr_vl preserving type) AS DeliveryDocumentItem,
  ManufacturingOrder,
  ManufacturingOrderItem,
  ReferenceDocument,
  GoodsIssueOrReceiptSlipNumber,
  ReferenceDocumentFiscalYear,
  InvtryMgmtRefDocumentItem,
  InvtryMgmtReferenceDocument,
  GoodsMovementType,
  InventoryValuationType,
  CreatedByUser,
  Supplier,
  Customer,
  IsMaterialDocumentHeader,
  MaterialDocumentHeaderText,
  MaterialDocumentItemText,
  IsCompletelyDelivered,
  GoodsRecipientName,
  UnloadingPointName,
  GoodsMovementRefDocType,
  GoodsMovementReasonCode,
  ShelfLifeExpirationDate,
  ManufactureDate,
  SerialNumbersAreCreatedAutomly,
  VersionForPrintingSlip,
  ManualPrintIsTriggered,
  AccountAssignmentCategory,
  CostCenter,
  ControllingArea,
  CostObject,
  GLAccount,
  FunctionalArea,
  ProfitabilitySegment,
  ProfitabilitySegment_2,
  ProfitCenter,
  MasterFixedAsset,
  FixedAsset,
  FundsCenter,
  Fund,
  CommitmentItemShortID,
  GrantID,
  Reservation,
  ReservationItem,
  ReservationIsFinallyIssued,
  DebitCreditCode,
  TotalGoodsMvtAmtInCCCrcy,
  GoodsMovementStkAmtInCCCrcy,
  GoodsMvtCnsmpnAmtInCCCrcy,
  GdsMvtExtAmtInCoCodeCrcy,
  SlsPrcAmtInclVATInCoCodeCrcy,
  EnteredSlsAmtInCoCodeCrcy,
  MatlStkChangeQtyInBaseUnit,
  MatlCnsmpnQtyInMatlBaseUnit,
  QuantityInBaseUnit,
  QuantityInEntryUnit,
  GoodsReceiptQtyInOrderUnit,
  TransactionCode,
  IsAutomaticallyCreated,
  MaterialDocumentLine,
  MaterialDocumentParentLine,
  HierarchyNodeLevel
FROM I_MaterialDocumentRecord
;