FRE_BIF_OPI_IN SAP (Inbound Interface Table Order Proposal Item) Table details

Dictionary Type: Table
Description: Inbound Interface Table Order Proposal Item




ABAP Code to SELECT data from FRE_BIF_OPI_IN
Related tables to FRE_BIF_OPI_IN
Access table FRE_BIF_OPI_IN




Table field list including key, data, relationships and ABAP select examples

FRE_BIF_OPI_IN is a standard SAP Table which is used to store Inbound Interface Table Order Proposal Item data and is available within R/3 SAP systems depending on the version and release level.

The FRE_BIF_OPI_IN table consists of various fields, each holding specific information or linking keys about Inbound Interface Table Order Proposal Item data available in SAP. These include ORDNO (Order Proposal Document Number), ITMNO (Order Proposal Item Number), PSTATUS (F&R Processing status indicator), OPHREFNR (Order Proposal Header Identifier).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP FRE_BIF_OPI_IN table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
ORDNOOrder Proposal Document Number FRE_BIF_ORDNOCHAR10ALPHAFRE_BIF_ORDNO
ITMNOOrder Proposal Item Number FRE_BIF_ITMNOCHAR10ALPHAFRE_BIF_ITMNO
PSTATUSF&R Processing status indicator FRE_BIF_PSTATUSCHAR1FRE_BIF_STATUS
OPHREFNROrder Proposal Header Identifier FRE_OPHREFNRCHAR35CHAR35
ITMREFNROrder Proposal Item Identifier FRE_ITMREFNRCHAR35CHAR35
SCHEDREFNROrder Proposal Schedule Line Identifier FRE_SCHEDREFNRCHAR35CHAR35
MATNRArticle / Material Number in F&R FRE_MATNRCHAR40CHAR40
SUBRANGEF&R Vendor Subrange FRE_LTSNRCHAR9CHAR9
MATKLMaterial Group MATKLCHAR9Assigned to domainMATKLMKLS_WBWG
LOCNOTOF&R Location FRE_LOCATIONCHAR20CHAR20
LOCNOTOTYPELocation Type of the Target Location FRE_LOCNOTOTYPECHAR4FRE_LOCNOTOTYPE
LOCNOFRF&R Location FRE_LOCATIONCHAR20CHAR20
LOCNOFRTYPELocation Type of a Source Location FRE_LOCNOFRTYPECHAR4FRE_LOCNOFRTYPE
QUANTITYF&R Order Proposal Quantity FRE_OPQUANQUAN19(6) QUAN_19
UNITPurchase Order Unit of Measure BSTMEUNIT3Assigned to domainCUNITMEINS
NETQUANF&R Order Proposal Quantity FRE_OPQUANQUAN19(6) QUAN_19
NETUNITUnit UNITUNIT3CUNITEINHEIT
DELIVQUANF&R Order Proposal Quantity FRE_OPQUANQUAN19(6) QUAN_19
DELIVUNITUnit UNITUNIT3CUNITEINHEIT
ORDERTSTOrder Time Period FRE_ORDERTSTDEC15TZNTSTMPS
DELIVTSTDelivery Time Period FRE_DELIVTSTDEC15TZNTSTMPS
TSTTOGoods Receipts Time Period FRE_TSTTODEC15TZNTSTMPS
TSTFRGoods Issues Time Period FRE_TSTFRDEC15TZNTSTMPS
ITMPVALOrder Proposal Item Value FRE_ITMVALDEC23(3) FRE_ITMVAL
ITMCURRCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
RELINDReplenishment Relevance FRE_RPRELCHAR1FRE_RPREL
STATVALOrder Proposal Status FRE_OP_STATUSCHAR2CHAR2
RETURNIDReturns Item RETPOCHAR1XFELD
ACCOMPLISHEnd of Package Indicator Flag FRE_EOPCHAR1CHAR1
PURCHASE_GRPPurchasing Group BKGRPCHAR3Assigned to domainEKGRPEKG
PURCHASE_ORGPurchasing Organization EKORGCHAR4Assigned to domainEKORGEKO
PROCESSING_METHRelevant to Allocation Table AURELCHAR1AUREL
CONSIGNMENTPurchase Order for Consignment FRE_CONS_PROCG_IFCHAR1FRE_CONS_PROCG_IF
TUTLO Transport Unit FRE_TRANSPORT_UNITINT410FRE_TRANSPORT_UNIT
CONTRACT_HDRContract Header ID for F&R Interface FRE_CONTRACT_HCHAR35CHAR35
CONTRACT_ITMContract Item ID for F&R Interface FRE_CONTRACT_INUMC10NUMC10
MATNOArticle / Material Number in F&R FRE_MATNRCHAR40CHAR40
UNIT_ISOISO code for unit of measurement ISOCD_UNITCHAR3Assigned to domainISOCD_UNIT
NETUNIT_ISOISO code for unit of measurement ISOCD_UNITCHAR3Assigned to domainISOCD_UNIT
DELIVUNIT_ISOISO code for unit of measurement ISOCD_UNITCHAR3Assigned to domainISOCD_UNIT
ITMCURR_ISOISO currency code ISOCDCHAR3ISOCD
FUNCTIONFunction Code FRE_OP_FUNCTIONCHAR1FRE_FUNC_1
SENDERLogical System LOGSYSTEMCHAR10Assigned to domainALPHALOGSYS
REF_IDPackage Identifier FRE_PACKAGE_IDCHAR35CHAR35
KEY_TSTUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) FRE_TST_LONGDEC21(7) TZNTSTMPL

Key field Non-key field



How do I retrieve data from SAP table FRE_BIF_OPI_IN using ABAP code

The following ABAP code Example will allow you to do a basic selection on FRE_BIF_OPI_IN to SELECT all data from the table
DATA: WA_FRE_BIF_OPI_IN TYPE FRE_BIF_OPI_IN.

SELECT SINGLE *
FROM FRE_BIF_OPI_IN
INTO CORRESPONDING FIELDS OF WA_FRE_BIF_OPI_IN
WHERE...

How to access SAP table FRE_BIF_OPI_IN

Within an ECC or HANA version of SAP you can also view further information about FRE_BIF_OPI_IN and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!