1. Home
  2. Resources
  3. SAP Tables
  4. FRE_BIF_OPI_IN - Inbound Interface Table Order Proposal Item

SAP Table FRE_BIF_OPI_IN

Inbound Interface Table Order Proposal Item

FRE_BIF_OPI_IN (Inbound Interface Table Order Proposal Item) 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_BIF_OPI_IN to other SAP tables.

Source: FRE_BIF_OPI_IN (Inbound Interface Table Order Proposal Item)

FRE_BIF_OPI_IN table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
ORDNO Order Proposal Document Number FRE_BIF_ORDNO CHAR 10 0
ITMNO Order Proposal Item Number FRE_BIF_ITMNO CHAR 10 0
PSTATUS F&R Processing status indicator FRE_BIF_PSTATUS CHAR 1 0
E error
N not processed
P in process
C not processed (see report settings for complete document)
OPHREFNR Order Proposal Header Identifier FRE_OPHREFNR CHAR 35 0
ITMREFNR Order Proposal Item Identifier FRE_ITMREFNR CHAR 35 0
SCHEDREFNR Order Proposal Schedule Line Identifier FRE_SCHEDREFNR CHAR 35 0
MATNR Article / Material Number in F&R FRE_MATNR CHAR 40 0
SUBRANGE F&R Vendor Subrange FRE_LTSNR CHAR 9 0
MATKL Material Group MATKL CHAR 9 0
LOCNOTO F&R Location FRE_LOCATION CHAR 20 0
LOCNOTOTYPE Location Type of the Target Location FRE_LOCNOTOTYPE CHAR 4 0
1002 Distribution Center
1040 Stores
LOCNOFR F&R Location FRE_LOCATION CHAR 20 0
LOCNOFRTYPE Location Type of a Source Location FRE_LOCNOFRTYPE CHAR 4 0
1002 Distribution Center
1011 Supplier
1040 Store
QUANTITY F&R Order Proposal Quantity FRE_OPQUAN QUAN 19 6
UNIT Purchase Order Unit of Measure BSTME UNIT 3 0
NETQUAN F&R Order Proposal Quantity FRE_OPQUAN QUAN 19 6
NETUNIT Unit UNIT UNIT 3 0
DELIVQUAN F&R Order Proposal Quantity FRE_OPQUAN QUAN 19 6
DELIVUNIT Unit UNIT UNIT 3 0
ORDERTST Order Time Period FRE_ORDERTST DEC 15 0
DELIVTST Delivery Time Period FRE_DELIVTST DEC 15 0
TSTTO Goods Receipts Time Period FRE_TSTTO DEC 15 0
TSTFR Goods Issues Time Period FRE_TSTFR DEC 15 0
ITMPVAL Order Proposal Item Value FRE_ITMVAL DEC 23 3
ITMCURR Currency Key WAERS CUKY 5 0
RELIND Replenishment Relevance FRE_RPREL CHAR 1 0
1 F&R-Relevant for Receiving Plant (as Goods Receipt)
2 F&R-Relevant for Supplying Plant (as Goods Issue)
3 F&R-Relevant for Supplying and Receiving Plant
0 Not Relevant
STATVAL Order Proposal Status FRE_OP_STATUS CHAR 2 0
RETURNID Returns Item RETPO CHAR 1 0
X Yes
NULL No
ACCOMPLISH End of Package Indicator Flag FRE_EOP CHAR 1 0
PURCHASE_GRP Purchasing Group BKGRP CHAR 3 0
PURCHASE_ORG Purchasing Organization EKORG CHAR 4 0
PROCESSING_METH 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
CONSIGNMENT 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
TU TLO Transport Unit FRE_TRANSPORT_UNIT INT4 10 0
CONTRACT_HDR Contract Header ID for F&R Interface FRE_CONTRACT_H CHAR 35 0
CONTRACT_ITM Contract Item ID for F&R Interface FRE_CONTRACT_I NUMC 10 0
MATNO Article / Material Number in F&R FRE_MATNR CHAR 40 0
UNIT_ISO ISO code for unit of measurement ISOCD_UNIT CHAR 3 0
NETUNIT_ISO ISO code for unit of measurement ISOCD_UNIT CHAR 3 0
DELIVUNIT_ISO ISO code for unit of measurement ISOCD_UNIT CHAR 3 0
ITMCURR_ISO ISO currency code ISOCD CHAR 3 0
FUNCTION Function Code FRE_OP_FUNCTION CHAR 1 0
I Insert
D Delete
U Update
SENDER Logical System LOGSYSTEM CHAR 10 0
REF_ID Package Identifier FRE_PACKAGE_ID CHAR 35 0
KEY_TST UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) FRE_TST_LONG DEC 21 7