SAP table FRE_BIF_OPI_IN (Inbound Interface Table Order Proposal Item)
SAP table FRE_BIF_OPI_IN has 3 primary key fields being MANDT,ORDNO,ITMNO.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
MANDT
Client
CLNT
3
0
*
MANDT
ORDNO
Order Proposal Document Number
CHAR
10
0
FRE_BIF_ORDNO
ITMNO
Order Proposal Item Number
CHAR
10
0
FRE_BIF_ITMNO
PSTATUS
F&R Processing status indicator
CHAR
1
0
FRE_BIF_PSTATUS
OPHREFNR
Order Proposal Header Identifier
CHAR
35
0
FRE_OPHREFNR
ITMREFNR
Order Proposal Item Identifier
CHAR
35
0
FRE_ITMREFNR
SCHEDREFNR
Order Proposal Schedule Line Identifier
CHAR
35
0
FRE_SCHEDREFNR
MATNR
Article / Material Number in F&R
CHAR
40
0
FRE_MATNR
SUBRANGE
F&R Supplier Subrange
CHAR
9
0
FRE_LTSNR
MATKL
Material Group
CHAR
9
0
*
MATKL
LOCNOTO
F&R Location
CHAR
20
0
FRE_LOCATION
LOCNOTOTYPE
Location Type of the Target Location
CHAR
4
0
FRE_LOCNOTOTYPE
1002
Distribution Center
1040
Stores
LOCNOFR
F&R Location
CHAR
20
0
FRE_LOCATION
LOCNOFRTYPE
Location Type of a Source Location
CHAR
4
0
FRE_LOCNOFRTYPE
1002
Distribution Center
1011
Supplier
1040
Store
QUANTITY
F&R Order Proposal Quantity
QUAN
19
6
FRE_OPQUAN
UNIT
Purchase Order Unit of Measure
UNIT
3
0
*
BSTME
NETQUAN
F&R Order Proposal Quantity
QUAN
19
6
FRE_OPQUAN
NETUNIT
Unit
UNIT
3
0
UNIT
DELIVQUAN
F&R Order Proposal Quantity
QUAN
19
6
FRE_OPQUAN
DELIVUNIT
Unit
UNIT
3
0
UNIT
ORDERTST
Order Time Period
DEC
15
0
FRE_ORDERTST
DELIVTST
Delivery Time Period
DEC
15
0
FRE_DELIVTST
TSTTO
Goods Receipts Time Period
DEC
15
0
FRE_TSTTO
TSTFR
Goods Issues Time Period
DEC
15
0
FRE_TSTFR
ITMPVAL
Order Proposal Item Value
DEC
23
3
FRE_ITMVAL
ITMCURR
Currency Key
CUKY
5
0
*
WAERS
RELIND
Replenishment Relevance
CHAR
1
0
FRE_RPREL
0
Not Relevant
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
STATVAL
Order Proposal Status
CHAR
2
0
FRE_OP_STATUS
RETURNID
Returns Item
CHAR
1
0
RETPO
ACCOMPLISH
End of Package Indicator Flag
CHAR
1
0
FRE_EOP
PURCHASE_GRP
Purchasing Group
CHAR
3
0
*
BKGRP
PURCHASE_ORG
Purchasing organization
CHAR
4
0
*
EKORG
PROCESSING_METH
Relevant to Allocation Table
CHAR
1
0
AUREL
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
CHAR
1
0
FRE_CONS_PROCG_IF
Procurement for Own Stock
0
Procurement for Own Stock
1
Procurement for Consignment Stock
TU
TLO Transport Unit
INT4
10
0
FRE_TRANSPORT_UNIT
CONTRACT_HDR
Contract Header ID for F&R Interface
CHAR
35
0
FRE_CONTRACT_H
CONTRACT_ITM
Contract Item ID for F&R Interface
NUMC
10
0
FRE_CONTRACT_I
MATNO
Article / Material Number in F&R
CHAR
40
0
FRE_MATNR
UNIT_ISO
ISO code for unit of measurement
CHAR
3
0
*
ISOCD_UNIT
NETUNIT_ISO
ISO code for unit of measurement
CHAR
3
0
*
ISOCD_UNIT
DELIVUNIT_ISO
ISO code for unit of measurement
CHAR
3
0
*
ISOCD_UNIT
ITMCURR_ISO
ISO currency code
CHAR
3
0
ISOCD
FUNCTION
Function Code
CHAR
1
0
FRE_OP_FUNCTION
SENDER
Logical System
CHAR
10
0
*
LOGSYSTEM
REF_ID
Package Identifier
CHAR
35
0
FRE_PACKAGE_ID
KEY_TST
UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)