I_GOODSMOVEMENTDOCUMENT

CDS View
45 Fields 20 CDS Views

Goods Movements

I_GOODSMOVEMENTDOCUMENT is a CDS View in S/4HANA. Goods Movements. It contains 45 fields. 20 CDS views read from this table.

CDS Views using this table (20)

ViewTypeJoinVDMDescription
A_MaterialDocumentHeader view from BASIC Document Header
A_MaterialDocumentItem view from COMPOSITE Document Items
C_BSOrdItmProcFlwGoodsReceipt view from CONSUMPTION Goods Receipt Item Attrib BSOrdPrgrs
C_BSOrdProcFlwGoodsReceipt view from CONSUMPTION Goods Receipt Attrib for BSOrd Prgrs
C_BSQPMGoodsIssueItem view_entity from CONSUMPTION BSQPM Goods Issue Item Attribute
C_BSQPMGoodsReceiptItem view_entity from CONSUMPTION BSQPM Goods Receipt Item Attribute
C_GRIRMaterialDocumentItem view from CONSUMPTION GR/IR Material Document Item
C_SSPGoodsMovementDocument view from CONSUMPTION SSP PR Goods Movement
CIC_INVNTRY_SNAP_GOODS_MOV_DOC view_entity from Invntry Snapshot Goods Movement Document
I_AugmentedGoodsMovement view from COMPOSITE Augmented view of Goods Movement
I_InspLotMatlDocItmGdsMvt view inner COMPOSITE Insp Lot Mat Doc Item with Goods Mvt
I_MatlAvgDailyUsge1 view from COMPOSITE Material Average Daily Usage
P_GdsIssQtyAggrgn view from COMPOSITE
P_GoodsIssueData view from TRANSACTIONAL
P_GoodsMvtStk view from CONSUMPTION Goods Movement Stock for Subctrg
P_GoodsReceiptData view from COMPOSITE
P_NL_SAFTGoodsMovDoc view from COMPOSITE
P_StandardPurchaseOrders view from COMPOSITE
P_StockTransportOrders view from COMPOSITE
P_StockTransportOrders view inner COMPOSITE

Fields (45)

KeyField CDS FieldsUsed in Views
KEY Material Material 6
KEY MaterialDocument MaterialDocument 3
KEY MaterialDocumentItem MaterialDocumentItem 2
KEY MaterialDocumentYear MaterialDocumentYear 2
KEY Plant Plant 7
KEY PurchaseOrder PurchaseOrder 1
KEY PurchaseOrderItem PurchaseOrderItem 1
_CompanyCode _CompanyCode 1
_Material _Material 1
_Plant _Plant 2
_PurchaseOrder _PurchaseOrder 1
_PurchaseOrderItem _PurchaseOrderItem 1
_StorageLocation _StorageLocation 2
AccountingDocumentType AccountingDocumentType 1
CompanyCode CompanyCode 1
CreatedByUser CreatedByUser 2
CreationDate CreationDate 1
CreationTime CreationTime 1
CtrlPostgForExtWhseMgmtSyst CtrlPostgForExtWhseMgmtSyst 1
Customer Customer 1
DebitCreditCode DebitCreditCode 1
DocumentDate DocumentDate 2
EntryUnit InspLotMatlDocItmQtyUnit 1
GoodsMovementIsCancelled GoodsReceiptIsCanceled 1
GoodsMovementType GoodsMovementType 2
InventorySpecialStockType InventorySpecialStockType 1
InventoryTransactionType InventoryTransactionType 2
IsEffectiveGoodsMovement IsEffectiveGoodsMovement 1
IsReversalMovementType IsReversalMovementType 1
IssgOrRcvgBatch InspLotBatchTransferredTo 1
IssgOrRcvgMaterial InspLotMaterialPostedTo 1
IssuingOrReceivingPlant IssuingOrReceivingPlant,SourceOfSupply 2
IssuingOrReceivingStorageLoc IssuingOrReceivingStorageLoc 1
ManualPrintIsTriggered ManualPrintIsTriggered 1
MaterialDocumentHeaderText MaterialDocumentHeaderText 2
MaterialDocumentItemText MaterialDocumentItemText 1
MatlStkChangeQtyInBaseUnit MatlStkChangeQtyInBaseUnit 1
PostingDate GoodsReceiptPostingDate,PostingDate 4
QuantityInEntryUnit InspLotQtyPosted 1
ReferenceDocument ReferenceDocument 2
ReversedMaterialDocument GRReveralMaterialDocument 1
StorageLocation StorageLocation 4
Supplier Supplier 2
TotalGoodsMvtAmtInCCCrcy AmountInCompanyCodeCurrency 1
VersionForPrintingSlip VersionForPrintingSlip 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Goods Movements
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_GOODSMOVEMENTDOCUMENT (
    MATERIAL,
    MATERIALDOCUMENT,
    MATERIALDOCUMENTITEM,
    MATERIALDOCUMENTYEAR,
    PLANT,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    _COMPANYCODE,
    _MATERIAL,
    _PLANT,
    _PURCHASEORDER,
    _PURCHASEORDERITEM,
    _STORAGELOCATION,
    ACCOUNTINGDOCUMENTTYPE,
    COMPANYCODE,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    CTRLPOSTGFOREXTWHSEMGMTSYST,
    CUSTOMER,
    DEBITCREDITCODE,
    DOCUMENTDATE,
    ENTRYUNIT,
    GOODSMOVEMENTISCANCELLED,
    GOODSMOVEMENTTYPE,
    INVENTORYSPECIALSTOCKTYPE,
    INVENTORYTRANSACTIONTYPE,
    ISEFFECTIVEGOODSMOVEMENT,
    ISREVERSALMOVEMENTTYPE,
    ISSGORRCVGBATCH,
    ISSGORRCVGMATERIAL,
    ISSUINGORRECEIVINGPLANT,
    ISSUINGORRECEIVINGSTORAGELOC,
    MANUALPRINTISTRIGGERED,
    MATERIALDOCUMENTHEADERTEXT,
    MATERIALDOCUMENTITEMTEXT,
    MATLSTKCHANGEQTYINBASEUNIT,
    POSTINGDATE,
    QUANTITYINENTRYUNIT,
    REFERENCEDOCUMENT,
    REVERSEDMATERIALDOCUMENT,
    STORAGELOCATION,
    SUPPLIER,
    TOTALGOODSMVTAMTINCCCRCY,
    VERSIONFORPRINTINGSLIP,
    PRIMARY KEY (MATERIAL, MATERIALDOCUMENT, MATERIALDOCUMENTITEM, MATERIALDOCUMENTYEAR, PLANT, PURCHASEORDER, PURCHASEORDERITEM)
);

Learn More