SAP Table FRE_OP_ITEM_IN

F&R CON R/3 - Order Proposal Inbound Item Buffer

FRE_OP_ITEM_IN (F&R CON R/3 - Order Proposal Inbound Item Buffer) 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 FRE_OP_ITEM_IN to other SAP tables.

FRE_OP_ITEM_IN table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
EBELN Purchasing Document Number EBELN CHAR 10 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
MATNR Material Number MATNR CHAR 18 0
LTSNR Vendor Subrange LTSNR CHAR 6 0
MATKL Material Group MATKL CHAR 9 0
WERKS Plant EWERK CHAR 4 0
LIFNR Vendor Account Number ELIFN CHAR 10 0
MENGE Purchase Order Quantity BSTMG QUAN 13 3
MEINS Purchase Order Unit of Measure BSTME UNIT 3 0
WAERS Currency Key WAERS CUKY 5 0
EINDT Item Delivery Date EINDT DATS 8 0
BEDAT Order date of schedule line ETBDT DATS 8 0
STATVAL Order Proposal Status FRE_OP_STATUS CHAR 2 0
RETPO Returns Item RETPO CHAR 1 0
X Yes
NULL No
UNIT_ISO ISO code for unit of measurement ISOCD_UNIT CHAR 3 0
PRSTATUS Processing Status OPSTATUS CHAR 2 0
00 Not Processed
01 In Processing
05 Error
ITMCURR_ISO ISO currency code ISOCD CHAR 3 0
EKORG Purchasing Organization EKORG CHAR 4 0
EKGRP Purchasing Group BKGRP CHAR 3 0
AUREL Relevant to Allocation Table AUREL CHAR 1 0
NULL Non-allocation-table-relevant
1 Allocation-table-relevant: placement in storage
2 Allocation-table-relevant: cross-docking
3 Allocation-table-relevant: flow through
4 Allocation-table-relevant: cross docking/flow through
5 Alloc.-table-relevant: cross docking/placement in storage
CONS_ORDER Purchase Order for Consignment FRE_CONS_PROCG_IF CHAR 1 0
NULL Procurement for Own Stock
0 Procurement for Own Stock
1 Procurement for Consignment Stock
LOCNOTOTYPE Location Type of the Target Location FRE_LOCNOTOTYPE CHAR 4 0
1002 Distribution Center
1040 Stores
LOCNOFRTYPE Location Type of a Source Location FRE_LOCNOFRTYPE CHAR 4 0
1002 Distribution Center
1011 Supplier
1040 Store