SAP FRET Assignment of Procurement to Issue Docs in Mdse Distribution Table data and field list

FRET is a standard SAP Table which is used to store Assignment of Procurement to Issue Docs in Mdse Distribution data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The FRET table consists of various fields, each holding specific information or linking keys about Assignment of Procurement to Issue Docs in Mdse Distribution data available in SAP. These include BTYPB (Procurement document category), BLNRB (Document number, procurement), BPOSB (Document item, procurement), BTYPA (Category of issue document, Merchandise Distribution)... 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. .

FRET table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

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

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the FRET table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	T000		MANDT
BTYPB	Procurement document category	BTYPB	CHAR	1			BELTV
BLNRB	Document number, procurement	BLNRB	CHAR	10		ALPHA	BELNV
BPOSB	Document item, procurement	BPOSB	NUMC	6	Assigned to domain		POSNR
BTYPA	Category of issue document, Merchandise Distribution	BTYPA	CHAR	1			BELTV
BLNRA	Issue document number	BLNRA	CHAR	10		ALPHA	BELNV
BPOSA	Document item, issue	BPOSA	NUMC	6	Assigned to domain		POSNR
GABLV	Business process	GABLV	CHAR	2			GABLV
MATNR	Material Number	MATNR	CHAR	18	MARA	MATN1	MATNR	MAT	S_MAT1
PMENB	Planned quantity for procurement	PMENB	QUAN	13(3)			MENG13
PEINB	Unit of measure, planned quantity for procurement	PEINB	UNIT	3	T006	CUNIT	MEINS
IMNGB	Actual quantity, procurement	IMNGB	QUAN	13(3)			MENG13
IEINB	Unit of measure, actual quantity, procurement	IEINB	UNIT	3	T006	CUNIT	MEINS
PMENA	Planned qty for issue	PMENA	QUAN	13(3)			MENG13
PEINA	Unit of measure for planned quantity, issue	PEINA	UNIT	3	T006	CUNIT	MEINS
IMNGA	Act. qty issue	IMNGA	QUAN	13(3)			MENG13
IEINA	Unit of measure for actual quantity issued	IEINA	UNIT	3	T006	CUNIT	MEINS
BARTV	Processing method for distribution	BARTV	CHAR	1			BARTV
MNGCD	Quantity for cross-docking	MNGCD	QUAN	13(3)			MENG13
EINCD	Unit of measure for cross-docking quantity	EINCD	UNIT	3	T006	CUNIT	MEINS
MNGFT	Quantity for flow-through	MNGFT	QUAN	13(3)			MENG13
EINFT	Unit of measure for flow-through quantity	EINFT	UNIT	3	T006	CUNIT	MEINS
VERVF	Distribution method for distribution	VERVF	CHAR	1			VERVF
MNGVT	Distributed quantity	MNGVT	QUAN	13(3)			MENG13
EINVT	Unif of measure for distributed quantity	EINVT	UNIT	3	T006	CUNIT	MEINS
MNGPA	Quantity for putaway	MNGPA	QUAN	13(3)			MENG13
EINPA	Unit of measure for putaway quantity	EINPA	UNIT	3	T006	CUNIT	MEINS
WERKA	Issuing plant	WERAB	CHAR	4	T001W		WERKS
ABNTP	Recipient category	ABNTP	CHAR	2			ABNTP
ABNNR	Number of recipient	NRABN	CHAR	10		ALPHA	ABNNR
KZFSA	Indicates record containing errors	KZFSA	CHAR	1			CHAR1_X
KZVST	Indicates that distribution is complete	KZVST	CHAR	1			CHAR1_X
STSVE	General status	STSVE	CHAR	1			STSVE
STMAN	Indicates processing status	STMAN	CHAR	1			STMAN
STBES	Procurement status	STBES	CHAR	1			STBES
ERFDAT	Created on	ERFDA	DATS	8			DATUM
ERFUSR	Name of Person who Created the Object	ERNAM	CHAR	12			USNAM
ERFZT	Entry time	ERZET	TIMS	6			UZEIT
LGORT	Storage Location	LGORT_D	CHAR	4	Assigned to domain		LGORT	LAG
LGNUM	Warehouse Number / Warehouse Complex	LGNUM	CHAR	3	T300		LGNUM	LGN
MD_ADJUST_EXEC	Sytems of Adjustment and Execution of Merchandise Distributn	DE_WMD_ADJUST_EXECUTE	CHAR	1			DO_WMD_ADJUST_EXECUTE
KZVAS	Indicates relevant SLS with sub-items	FRM_VAS_REL	CHAR	1			CHAR1_X
IND_UC_SPLIT	Only one End Customer per Item	DE_WMD_UC_SPLIT	CHAR	1			BOOLE
UEBPO	Higher-Level Item in Purchasing Documents	UEBPO	NUMC	5	Assigned to domain		EBELP
MD_PROCESS_METH	Process Method for Merchandise Distribution	DE_WMD_PROCESS_METHOD	CHAR	3			DO_WMD_PROCESS_METHOD
MD_PROCESS_ID	Cross-Docking Process Number	/SPE/CD_PROCESS	CHAR	10	Assigned to domain	ALPHA	VBELN		/SPE/CD_DOCFLOW

Key field

Non-key field

< FREF - Reference function modules in programs FRETB - Reference Table for Multiple Procurement >

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

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

SELECT SINGLE *
FROM FRET
INTO CORRESPONDING FIELDS OF WA_FRET
WHERE...

How to access SAP table FRET

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

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