FRE_IF_ITEM SAP (F&R Order Outbound IF: internal Item Table) Table details

Dictionary Type: Table
Description: F&R Order Outbound IF: internal Item Table




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




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

FRE_IF_ITEM is a standard SAP Table which is used to store F&R Order Outbound IF: internal Item Table data and is available within R/3 SAP systems depending on the version and release level.

The FRE_IF_ITEM table consists of various fields, each holding specific information or linking keys about F&R Order Outbound IF: internal Item Table data available in SAP. These include OPHNR (Document Number), ITMNR (Item Number), SCHEDNR (Delivery Schedule Line Counter), PROCFLAG_IF (Processing Flag).. 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_IF_ITEM 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
OPHNRDocument Number FRE_OPHNRCHAR10CHAR10
ITMNRItem Number FRE_ITMNRNUMC5NUMC5
SCHEDNRDelivery Schedule Line Counter FRE_SCHEDNRNUMC4NUMC4
PROCFLAG_IFProcessing Flag FRE_PROCFLAGNUMC2NUMC2
ORDNOOrder Proposal Document Number FRE_OP_DOCNUMNUMC10NUMC10
ITMNOOrder Proposal Item Number FRE_OP_ITMNONUMC10NUMC10
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
SUBRANGEVendor Subrange LTSNRCHAR6Assigned to domainLTSNR
MATKLMaterial Group MATKLCHAR9Assigned to domainMATKLMKLS_WBWG
LOCNOTOF&R Location FRE_LOCATIONCHAR20CHAR20
LOCNOFRF&R Location FRE_LOCATIONCHAR20CHAR20
QUANTITYPurchase Order Quantity FRE_ORD_QUANQUAN13(3) MENGE
UNITUnit UNITUNIT3CUNITEINHEIT
NETQUANPlanned Quantity FRE_NET_QUANQUAN13(3) MENGE
NETUNITUnit UNITUNIT3CUNITEINHEIT
DELIVQUANQuantity Delivered FRE_DELIV_QUANQUAN13(3) MENGE
DELIVUNITUnit UNITUNIT3CUNITEINHEIT
ORDERTSTOrder Time Period FRE_ORDERTSTDEC15TZNTSTMPS
DELIVTSTDelivery Time Period FRE_DELIVTSTDEC15TZNTSTMPS
TSTTOGoods Receipts Time Period FRE_TSTTODEC15TZNTSTMPS
TSTFRGoods Issues Time Period FRE_TSTFRDEC15TZNTSTMPS
ITMPVALNet Value in Document Currency NETWRCURR15(2) WERTV8
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
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
PURCHASE_ORGPurchasing Organization EKORGCHAR4Assigned to domainEKORGEKO
PURCHASE_GRPPurchasing Group BKGRPCHAR3Assigned to domainEKGRPEKG
PROCESSING_METHRelevant to Allocation Table AURELCHAR1AUREL
CONSIGNMENTPurchase Order for Consignment FRE_CONS_PROCG_IFCHAR1FRE_CONS_PROCG_IF
LOCNOTOTYPELocation type FRE_LOCTYPECHAR4FRE_LOCTYPE
LOCNOFRTYPELocation type FRE_LOCTYPECHAR4FRE_LOCTYPE
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
GI_QUANTITYF&R Goods Issue Quantity FRE_GI_QUANQUAN19(6) QUAN_19
GI_QUANT_UNITUnit UNITUNIT3CUNITEINHEIT
GI_QUAN_UNIT_ISOISO code for unit of measurement ISOCD_UNITCHAR3Assigned to domainISOCD_UNIT
GI_COMPLETED'Outward Delivery Completed' Indicator EGLKZCHAR1XFELD
MD_INCOMPLETEMaster Data for Material/Receiving Plant Is Not Complete FRE_MD_INCOMPLETECHAR1XFELD

Key field Non-key field



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

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

SELECT SINGLE *
FROM FRE_IF_ITEM
INTO CORRESPONDING FIELDS OF WA_FRE_IF_ITEM
WHERE...

How to access SAP table FRE_IF_ITEM

Within an ECC or HANA version of SAP you can also view further information about FRE_IF_ITEM 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!