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:
The Main SAP Good Movement tables are:
Table of Contents
The Sap Goods Movement Table MKPF is the SAP standard Table for Material document header information.
The keys for MKPF are:
Here the list of MKPF Table Fields which is the main table for sap goods movement tables:
MKPF Field | Sap Goods Movement Table MKPF |
---|---|
MANDT | Client |
MBLNR | Number of Material Document |
MJAHR | Material Document Year |
VGART | Transaction/Event Type |
BLART | Document Type |
BLAUM | Document type of revaluation document |
BLDAT | Document Date in Document |
BUDAT | Posting Date in the Document |
CPUDT | Day On Which Accounting Document Was Entered |
CPUTM | Time of Entry |
AEDAT | Changed On |
USNAM | User name |
TCODE | Not More Closely Defined Area, Possibly Used for Patchlevels |
XBLNR | Reference Document Number |
BKTXT | Document Header Text |
FRATH | Unplanned delivery costs |
FRBNR | Number of Bill of Lading at Time of Goods Receipt |
WEVER | Version for Printing GR/GI Slip |
XABLN | Goods Receipt/Issue Slip Number |
AWSYS | Logical System |
BLA2D | Doc. type for additional doc. in purchase account management |
TCODE2 | Transaction Code |
BFWMS | Control posting for external WMS |
EXNUM | Number of foreign trade data in MM and SD documents |
SPE_BUDAT_UHR | Time of Goods Issue (Local, Relating to a Plant) |
SPE_BUDAT_ZONE | Time Zone |
LE_VBELN | Delivery |
SPE_LOGSYS | Logical System of EWM Material Document |
SPE_MDNUM_EWM | Number of Material Document in EWM |
GTS_CUSREF_NO | Customs Reference Number for Scrapping |
FLS_RSTO | Store Return with Inbound and Outbound Delivery |
MSR_ACTIVE | Advanced Returns Management Active |
KNUMV | Number of the document condition |
LFSNR | Number of External Delivery Note |
OIB_BLTIME | Posting time in the document |
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:
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:
Check more posts on SAP MM
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.
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.
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.
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.
SAP ISU Tables for Technical master data, for Billing Master Data, Billing and invoicing Tables?…
SAP Fiori 3 UX and Design of SAP Fiori Apps for SAP S/4HANA, SAP TechEd…
Dunning is the business practice of informing a customer of past due payment. Dunning letters…
SAP AP Tcodes & SAP AR Tcodes: House Banks Tcodes, Advance Payments or Down Payments,…
What are the main SAP Payment Terms Tables ? What are the related Tables in…
Work center consists of master data related to routing of products. It contains data related…