SAP Table MMREQ_HISTORY

Flat Structure for Purchase Requisition Document Flow

MMREQ_HISTORY (Flat Structure for Purchase Requisition Document Flow) 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 MMREQ_HISTORY to other SAP tables.

MMREQ_HISTORY table fields

Field Data element Checktable Datatype Length Decimals
BSTYP Purchasing Document Category BSTYP CHAR 1 0
A Request for quotation
B Purchase requisition
F Purchase order
I Info record
K Contract
L Scheduling agreement
Q Service entry sheet
W Source list
BSTYP_TEXT Long text for document category BSYTP_TEXT CHAR 30 0
EBELN Purchasing Document Number EBELN CHAR 10 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
LOEKZ Deletion Indicator in Purchasing Document ELOEK CHAR 1 0
KDATB Start of Validity Period KDATB DATS 8 0
KDATE End of Validity Period KDATE DATS 8 0
BWBDT Closing Date for Applications BWBDT DATS 8 0
ANGDT Quotation Validity Date ANGDT DATS 8 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
MATNR Material Number MATNR CHAR 18 0
BUKRS Company Code BUKRS CHAR 4 0
WERKS Plant WERKS_D CHAR 4 0
LGORT Storage Location LGORT_D CHAR 4 0
BEDNR Requirement Tracking Number BEDNR CHAR 10 0
MATKL Material Group MATKL CHAR 9 0
ELIKZ "Delivery Completed" Indicator ELIKZ CHAR 1 0
X Yes
NULL No
EREKZ Final Invoice Indicator EREKZ CHAR 1 0
X Yes
NULL No
KONNR Number of Principal Purchase Agreement KONNR CHAR 10 0
KTPNR Item Number of Principal Purchase Agreement KTPNR NUMC 5 0
VGABETEXT Short Text for Fixed Values VAL_TEXT CHAR 60 0
BEWTP PO history category BEWTP CHAR 1 0
BEWTK Short Text for Purchase Order History Category BEWTK CHAR 4 0
BWART Movement Type (Inventory Management) BWART CHAR 3 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
MENGE Quantity MENGE_D QUAN 13 3
MEINS Purchase Order Unit of Measure BSTME UNIT 3 0
VGABE Transaction/event type, purchase order history VGABE CHAR 1 0
1 Goods Receipt
2 Invoice Receipt
3 Subseq. Debit/Credit
4 Down Payment
5 Payment
6 Goods Issue for Stock Transfer
7 Consumption (Subcontracting)
8 Delivery (Stock Transfer)
9 Service Entry Sheet
A Down Payment Request
C Down Payment Clearing
Q Comparison for Internally Posted Material (Only IS-OIL)
R Return Delivery via Delivery Note
P Invoice Parking
V Down Payment Request Clearing
H Invoice On Hold
M Posted Subsequent Debit with Reference to a Contract
K Posted Invoice with Reference to a Contract
L Parked Invoice with Reference to a Contract
N Posted Subsequent Debit for Contract in Blanket PO
O Posted Invoice for Contract in Blanket Purchase Order
G Parked Invoice for Contract in Blanket Purchase Order
ETENR Delivery Schedule Line Number ETENR NUMC 4 0
EINDT Item Delivery Date EINDT DATS 8 0
STATUSICON Status icon STATUSICON30 CHAR 30 0
LONGNUM Smart Number /SAPPSPRO/LONGNUM CHAR 40 0