SAP Table MAM_30_GOODSMOVEMENT_DETAIL

Material Consumption Document Data

MAM_30_GOODSMOVEMENT_DETAIL (Material Consumption Document Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MAM_30_GOODSMOVEMENT_DETAIL to other SAP tables.

MAM_30_GOODSMOVEMENT_DETAIL table fields

Field Data element Checktable Datatype Length Decimals
MATERIAL Material Number MATNR MARA CHAR 18 0
SERIALNO Serial Number GERNR CHAR 18 0
ORDERID Order Number AUFNR AUFK CHAR 12 0
ORDER_ITNO Order Item Number CO_POSNR NUMC 4 0
ACTIVITY Operation/Activity Number VORNR CHAR 4 0
MAT_DOC Number of Material Document MBLNR CHAR 10 0
DOC_YEAR Document Date in Document BLDAT DATS 8 0
PSTNG_DATE Posting Date in the Document BUDAT DATS 8 0
DOC_DATE Material Document Year MJAHR NUMC 4 0
REF_DOC_NO Reference Document Number XBLNR CHAR 16 0
BILL_OF_LADING Number of bill of lading at time of goods receipt FRBNR CHAR 16 0
GR_GI_SLIP_NO Goods Receipt/Issue Slip Number XABLN CHAR 10 0
PR_UNAME User Name UNAME CHAR 12 0
HEADER_TXT Document Header Text BKTXT CHAR 25 0
VER_GR_GI_SLIP Version for Printing GR/GI Slip WEVER CHAR 1 0
1 Individual Slip
2 Individual Slip with Inspection Text
3 Collective Slip
VER_GR_GI_SLIPX Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
EXT_WMS Control posting for external WMS BFWMS CHAR 1 0
2 Execute stock change in ERP
1 Create delivery and transmit to WM
PLANT Plant WERKS_D T001W CHAR 4 0
STGE_LOC Storage Location LGORT_D T001L CHAR 4 0
BATCH Batch Number CHARG_D MCHA CHAR 10 0
MOVE_TYPE Movement Type (Inventory Management) BWART T156 CHAR 3 0
STCK_TYPE Stock Type MB_INSMK CHAR 1 0
X Quality inspection
S Blocked
2 Quality inspection
3 Blocked
NULL Unrestricted-use
F Unrestricted-use
SPEC_STOCK Special Stock Indicator SOBKZ T148 CHAR 1 0
VENDOR Vendor Account Number ELIFN LFA1 CHAR 10 0
CUSTOMER Account Number of Customer EKUNN KNA1 CHAR 10 0
SALES_ORD Sales Order Number KDAUF VBUK CHAR 10 0
S_ORD_ITEM Item Number in Sales Order KDPOS NUMC 6 0
SCHED_LINE Delivery Schedule for Sales Order KDEIN NUMC 4 0
VAL_TYPE Valuation Type BWTAR_D T149D CHAR 10 0
ENTRY_QNT Quantity in Unit of Entry ERFMG QUAN 13 3
ENTRY_UOM Unit of Entry ERFME T006 UNIT 3 0
ENTRY_UOM_ISO ISO code for unit of measurement ISOCD_UNIT T006I CHAR 3 0
PO_PR_QNT Quantity in Purchase Order Price Unit BPMNG QUAN 13 3
ORDERPR_UN Order Price Unit (Purchasing) BBPRM T006 UNIT 3 0
ORDERPR_UN_ISO ISO code for unit of measurement ISOCD_UNIT T006I CHAR 3 0
PO_NUMBER Purchase Order Number BSTNR EKKO CHAR 10 0
PO_ITEM Item Number of Purchasing Document EBELP EKPO NUMC 5 0
SHIPPING Shipping Instructions EVERS T027A CHAR 2 0
COMP_SHIP Compliance with Shipping Instructions EVERE T027C CHAR 2 0
NO_MORE_GR "Delivery Completed" Indicator ELIKZ CHAR 1 0
X Yes
NULL No
ITEM_TEXT Item Text SGTXT CHAR 50 0
GR_RCPT Goods Recipient/Ship-To Party WEMPF CHAR 12 0
UNLOAD_PT Unloading Point ABLAD CHAR 25 0
COSTCENTER Cost Center KOSTL CHAR 10 0
CALC_MOTIVE Accounting Indicator BEMOT TBMOT CHAR 2 0
ASSET_NO Main Asset Number ANLN1 ANLH CHAR 12 0
SUB_NUMBER Asset Subnumber ANLN2 ANLA CHAR 4 0
RESERV_NO Number of Reservation/Dependent Requirement RSNUM RESB NUMC 10 0
RES_ITEM Item Number of Reservation/Dependent Requirement RSPOS NUMC 4 0
RES_TYPE Record type RSART CHAR 1 0
WITHDRAWN Final Issue for This Reservation KZEAR CHAR 1 0
X Yes
NULL No
CREATED General Flag FLAG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
ENHANCEMENT_FLAG Enhancement for This Object Active ALM_ME_ENHANCEMENT_FLAG CHAR 1 0
MATERIAL_DISPLAY Material Number MATNR CHAR 18 0
SERIALNO_DISPLAY Serial Number GERNR CHAR 18 0

MAM_30_GOODSMOVEMENT_DETAIL foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MAM_30_GOODSMOVEMENT_DETAIL ASSET_NO SY MANDT ANLH Main asset number MANDT
MAM_30_GOODSMOVEMENT_DETAIL ASSET_NO * ANLH Main asset number BUKRS
MAM_30_GOODSMOVEMENT_DETAIL ASSET_NO MAM_30_GOODSMOVEMENT_DETAIL ASSET_NO ANLH Main asset number ANLN1
MAM_30_GOODSMOVEMENT_DETAIL BATCH SY MANDT MCHA Batches MANDT
MAM_30_GOODSMOVEMENT_DETAIL BATCH MAM_30_GOODSMOVEMENT_DETAIL MATERIAL MCHA Batches MATNR
MAM_30_GOODSMOVEMENT_DETAIL BATCH MAM_30_GOODSMOVEMENT_DETAIL PLANT MCHA Batches WERKS
MAM_30_GOODSMOVEMENT_DETAIL BATCH MAM_30_GOODSMOVEMENT_DETAIL BATCH MCHA Batches CHARG
MAM_30_GOODSMOVEMENT_DETAIL CALC_MOTIVE SY MANDT TBMOT Accounting indicators MANDT
MAM_30_GOODSMOVEMENT_DETAIL CALC_MOTIVE MAM_30_GOODSMOVEMENT_DETAIL CALC_MOTIVE TBMOT Accounting indicators BEMOT
MAM_30_GOODSMOVEMENT_DETAIL COMP_SHIP SY MANDT T027C Codes for Compliance with Shipping Instructions MANDT
MAM_30_GOODSMOVEMENT_DETAIL COMP_SHIP MAM_30_GOODSMOVEMENT_DETAIL SHIPPING T027C Codes for Compliance with Shipping Instructions EVERS
MAM_30_GOODSMOVEMENT_DETAIL COMP_SHIP MAM_30_GOODSMOVEMENT_DETAIL COMP_SHIP T027C Codes for Compliance with Shipping Instructions EVERE
MAM_30_GOODSMOVEMENT_DETAIL CUSTOMER SY MANDT KNA1 General Data in Customer Master MANDT
MAM_30_GOODSMOVEMENT_DETAIL CUSTOMER MAM_30_GOODSMOVEMENT_DETAIL CUSTOMER KNA1 General Data in Customer Master KUNNR
MAM_30_GOODSMOVEMENT_DETAIL ENTRY_UOM SY MANDT T006 Units of Measurement MANDT
MAM_30_GOODSMOVEMENT_DETAIL ENTRY_UOM MAM_30_GOODSMOVEMENT_DETAIL ENTRY_UOM T006 Units of Measurement MSEHI
MAM_30_GOODSMOVEMENT_DETAIL ENTRY_UOM_ISO SY MANDT T006I ISO codes for units of measurement CLIENT
MAM_30_GOODSMOVEMENT_DETAIL ENTRY_UOM_ISO MAM_30_GOODSMOVEMENT_DETAIL ENTRY_UOM_ISO T006I ISO codes for units of measurement ISOCODE
MAM_30_GOODSMOVEMENT_DETAIL MATERIAL MAM_30_GOODSMOVEMENT_DETAIL MATERIAL MARA General Material Data MATNR
MAM_30_GOODSMOVEMENT_DETAIL MATERIAL SY MANDT MARA General Material Data MANDT
MAM_30_GOODSMOVEMENT_DETAIL MOVE_TYPE MAM_30_GOODSMOVEMENT_DETAIL MOVE_TYPE T156 Movement Type BWART
MAM_30_GOODSMOVEMENT_DETAIL MOVE_TYPE SY MANDT T156 Movement Type MANDT
MAM_30_GOODSMOVEMENT_DETAIL ORDERID MAM_30_GOODSMOVEMENT_DETAIL ORDERID AUFK Order master data AUFNR
MAM_30_GOODSMOVEMENT_DETAIL ORDERID SY MANDT AUFK Order master data MANDT
MAM_30_GOODSMOVEMENT_DETAIL ORDERPR_UN SY MANDT T006 Units of Measurement MANDT
MAM_30_GOODSMOVEMENT_DETAIL ORDERPR_UN MAM_30_GOODSMOVEMENT_DETAIL ORDERPR_UN T006 Units of Measurement MSEHI
MAM_30_GOODSMOVEMENT_DETAIL ORDERPR_UN_ISO MAM_30_GOODSMOVEMENT_DETAIL ORDERPR_UN_ISO T006I ISO codes for units of measurement ISOCODE
MAM_30_GOODSMOVEMENT_DETAIL ORDERPR_UN_ISO SY MANDT T006I ISO codes for units of measurement CLIENT
MAM_30_GOODSMOVEMENT_DETAIL PLANT SY MANDT T001W Plants/Branches MANDT
MAM_30_GOODSMOVEMENT_DETAIL PLANT MAM_30_GOODSMOVEMENT_DETAIL PLANT T001W Plants/Branches WERKS
MAM_30_GOODSMOVEMENT_DETAIL PO_ITEM SY MANDT EKPO Purchasing Document Item MANDT
MAM_30_GOODSMOVEMENT_DETAIL PO_ITEM MAM_30_GOODSMOVEMENT_DETAIL PO_NUMBER EKPO Purchasing Document Item EBELN
MAM_30_GOODSMOVEMENT_DETAIL PO_ITEM MAM_30_GOODSMOVEMENT_DETAIL PO_ITEM EKPO Purchasing Document Item EBELP
MAM_30_GOODSMOVEMENT_DETAIL PO_NUMBER SY MANDT EKKO Purchasing Document Header MANDT
MAM_30_GOODSMOVEMENT_DETAIL PO_NUMBER MAM_30_GOODSMOVEMENT_DETAIL PO_NUMBER EKKO Purchasing Document Header EBELN
MAM_30_GOODSMOVEMENT_DETAIL RESERV_NO SY MANDT RESB Reservation/dependent requirements MANDT
MAM_30_GOODSMOVEMENT_DETAIL RESERV_NO MAM_30_GOODSMOVEMENT_DETAIL RESERV_NO RESB Reservation/dependent requirements RSNUM
MAM_30_GOODSMOVEMENT_DETAIL RESERV_NO MAM_30_GOODSMOVEMENT_DETAIL RES_ITEM RESB Reservation/dependent requirements RSPOS
MAM_30_GOODSMOVEMENT_DETAIL RESERV_NO MAM_30_GOODSMOVEMENT_DETAIL RES_TYPE RESB Reservation/dependent requirements RSART
MAM_30_GOODSMOVEMENT_DETAIL SALES_ORD SY MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
MAM_30_GOODSMOVEMENT_DETAIL SALES_ORD MAM_30_GOODSMOVEMENT_DETAIL SALES_ORD VBUK Sales Document: Header Status and Administrative Data VBELN
MAM_30_GOODSMOVEMENT_DETAIL SHIPPING SY MANDT T027A Shipping Instructions, Purchasing MANDT
MAM_30_GOODSMOVEMENT_DETAIL SHIPPING MAM_30_GOODSMOVEMENT_DETAIL SHIPPING T027A Shipping Instructions, Purchasing EVERS
MAM_30_GOODSMOVEMENT_DETAIL SPEC_STOCK SY MANDT T148 Special Stock Indicator MANDT
MAM_30_GOODSMOVEMENT_DETAIL SPEC_STOCK MAM_30_GOODSMOVEMENT_DETAIL SPEC_STOCK T148 Special Stock Indicator SOBKZ
MAM_30_GOODSMOVEMENT_DETAIL STGE_LOC MAM_30_GOODSMOVEMENT_DETAIL STGE_LOC T001L Storage Locations LGORT
MAM_30_GOODSMOVEMENT_DETAIL STGE_LOC SY MANDT T001L Storage Locations MANDT
MAM_30_GOODSMOVEMENT_DETAIL STGE_LOC MAM_30_GOODSMOVEMENT_DETAIL PLANT T001L Storage Locations WERKS
MAM_30_GOODSMOVEMENT_DETAIL SUB_NUMBER MAM_30_GOODSMOVEMENT_DETAIL SUB_NUMBER ANLA Asset Master Record Segment ANLN2
MAM_30_GOODSMOVEMENT_DETAIL SUB_NUMBER SY MANDT ANLA Asset Master Record Segment MANDT
MAM_30_GOODSMOVEMENT_DETAIL SUB_NUMBER * ANLA Asset Master Record Segment BUKRS
MAM_30_GOODSMOVEMENT_DETAIL SUB_NUMBER MAM_30_GOODSMOVEMENT_DETAIL ASSET_NO ANLA Asset Master Record Segment ANLN1
MAM_30_GOODSMOVEMENT_DETAIL VAL_TYPE SY MANDT T149D Global Valuation Types MANDT
MAM_30_GOODSMOVEMENT_DETAIL VAL_TYPE MAM_30_GOODSMOVEMENT_DETAIL VAL_TYPE T149D Global Valuation Types BWTAR
MAM_30_GOODSMOVEMENT_DETAIL VENDOR SY MANDT LFA1 Vendor Master (General Section) MANDT
MAM_30_GOODSMOVEMENT_DETAIL VENDOR MAM_30_GOODSMOVEMENT_DETAIL VENDOR LFA1 Vendor Master (General Section) LIFNR