SAP Goods Movement Tables

The two important SAP Good Movement Tables in SAP MM are detailed in this article.

Through this article, I will detail the Main SAP Goods Movement Tables for Material Documents ( Master Data,Transaction and customizing). For a SAP Good Movement, a Material Document are issued.

You can check also:

• SAP Goods Movement Tcodes
• SAP Good Movement Types – Full list of SAP Movement Types
• List of important SAP Good Movement BAPI (Create,Cancel & Getdetails)

The Main SAP Good Movement tables are:

• MSEG : Document Segment: Material
• MKPF : Material document header information

SAP Goods Movement Tables

MKPF – Material Document Header

The Sap Goods Movement Table MKPF is the SAP standard Table for Material document header information.

The keys for MKPF are:

• MBLNR – Number of Material Document
• MJAHR – Material Document Year

MKPF Table Fields

Here the list of MKPF Table Fields which is the main table for sap goods movement tables:

MSEG – Material Document Transaction

MSEG is the standard SAP Goods movement Table for Material Document storing Transactions Details (2nd sap goods movement tables)n

For example, if the Good Movement is related to a SAP Sales Order, MSEG stores the information about the items posting ( MSEG-KDAUF for Sales Order Number and MSEG-KDPOS for Item in the SAP Sales Order )

An other example, the SAP Good Movement is related to a Purchase Order, MSEG-EBELN refers to the Purchase Order Number and MSEG-EBELP for items of Purchase Order.

The key for MSEG Table are:

• MBLNR for Number of Material Document
• MJAHR for Material Document Year
• ZEILE for Item in Material Document

The MSEG Table stores the data for Good Movement details by Materail number and the type of SAP Good Movement.
You can find as information:

• BWART – Movement Type (Inventory Management)
• MATNR – Material Number
• WERKS – Plant
• LGORT – Storage Location
• MENGE – Quantity
• KSTRG – Cost Object
• PRCTR – Profit Center

Check more posts on SAP MM

• SAP Goods Movement Tcodes
• SAP Material Master Tables

SAP Good Movement Tables for Customizing

T158V – Transaction/Event Types

The Check Table for MPKF-VGART is T158V.
T158V stored the allowed value for Transaction/Event Types in Inventory Management.

The Transaction/Event Types is the field T158V-VGART.
For the description, check the related Text table T158W.

T003 – Document Types

In order to identify the document origin for Good Movement MSEG-BLART.
The reference Table for Document Types is T003.

The Text Table is T003T.

T156 – Movement Type

Movement Type is 3 digital identifying the Type of SAP Good Movement.

The Movement Type is very important. Actually it controls the adjustement of inventories, the GL related account and even the screen layout for MIGO transaction.

For a Material Document, the type of Movement type is set on MSEG-BWART.
The reference Table for Movement Type is T156.

For the full list of SAP Good Movement Type check this link SAP Good Movement Types.

T158G – Transaction Code

The Transaction Code is required when using Good Movement BAPI in order to identify the king of Good mvt.
For the full list of Transaction Code and signification check this post.