- Home
- Resources
- SAP Tables
- MMREQ_HISTORY - Flat Structure for Purchase Requisition Document Flow
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.
Source: MMREQ_HISTORY (Flat Structure for Purchase Requisition Document Flow)
MMREQ_HISTORY table fields
Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
BSTYP |
Purchasing Document Category |
BSTYP |
|
CHAR |
|
1 |
0 |
Possible values
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 |
Possible values
|
EREKZ |
Final Invoice Indicator |
EREKZ |
|
CHAR |
|
1 |
0 |
Possible values
|
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 |
Possible values
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 |
|