SAP ABAP Table FRET (Assignment of Procurement to Issue Docs in Mdse Distribution)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ LO-MDS (Application Component) Merchandise Distribution
     ⤷ WFRM (Package) ISR: Cross-Docking and Floor-Ready Merchandise

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	FRET	Table Relationship Diagram
Short Description	Assignment of Procurement to Issue Docs in Mdse Distribution

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	BTYPB	☑	BTYPB	BELTV	CHAR	1	0	Procurement document category
3	BLNRB	☑	BLNRB	BELNV	CHAR	10	0	Document number, procurement
4	BPOSB	☑	BPOSB	POSNR	NUMC	6	0	Document item, procurement	*
5	BTYPA	☑	BTYPA	BELTV	CHAR	1	0	Category of issue document, Merchandise Distribution
6	BLNRA	☑	BLNRA	BELNV	CHAR	10	0	Issue document number
7	BPOSA	☑	BPOSA	POSNR	NUMC	6	0	Document item, issue	*
8	GABLV	☐	GABLV	GABLV	CHAR	2	0	Business process
9	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
10	PMENB	☐	PMENB	MENG13	QUAN	13	3	Planned quantity for procurement
11	PEINB	☐	PEINB	MEINS	UNIT	3	0	Unit of measure, planned quantity for procurement	T006
12	IMNGB	☐	IMNGB	MENG13	QUAN	13	3	Actual quantity, procurement
13	IEINB	☐	IEINB	MEINS	UNIT	3	0	Unit of measure, actual quantity, procurement	T006
14	PMENA	☐	PMENA	MENG13	QUAN	13	3	Planned qty for issue
15	PEINA	☐	PEINA	MEINS	UNIT	3	0	Unit of measure for planned quantity, issue	T006
16	IMNGA	☐	IMNGA	MENG13	QUAN	13	3	Act. qty issue
17	IEINA	☐	IEINA	MEINS	UNIT	3	0	Unit of measure for actual quantity issued	T006
18	BARTV	☐	BARTV	BARTV	CHAR	1	0	Processing method for distribution
19	MNGCD	☐	MNGCD	MENG13	QUAN	13	3	Quantity for cross-docking
20	EINCD	☐	EINCD	MEINS	UNIT	3	0	Unit of measure for cross-docking quantity	T006
21	MNGFT	☐	MNGFT	MENG13	QUAN	13	3	Quantity for flow-through
22	EINFT	☐	EINFT	MEINS	UNIT	3	0	Unit of measure for flow-through quantity	T006
23	VERVF	☐	VERVF	VERVF	CHAR	1	0	Distribution method for distribution
24	MNGVT	☐	MNGVT	MENG13	QUAN	13	3	Distributed quantity
25	EINVT	☐	EINVT	MEINS	UNIT	3	0	Unif of measure for distributed quantity	T006
26	MNGPA	☐	MNGPA	MENG13	QUAN	13	3	Quantity for putaway
27	EINPA	☐	EINPA	MEINS	UNIT	3	0	Unit of measure for putaway quantity	T006
28	WERKA	☐	WERAB	WERKS	CHAR	4	0	Issuing plant	T001W
29	ABNTP	☐	ABNTP	ABNTP	CHAR	2	0	Recipient category
30	ABNNR	☐	NRABN	ABNNR	CHAR	10	0	Number of recipient
31	KZFSA	☐	KZFSA	CHAR1_X	CHAR	1	0	Indicates record containing errors
32	KZVST	☐	KZVST	CHAR1_X	CHAR	1	0	Indicates that distribution is complete
33	STSVE	☐	STSVE	STSVE	CHAR	1	0	General status
34	STMAN	☐	STMAN	STMAN	CHAR	1	0	Indicates processing status
35	STBES	☐	STBES	STBES	CHAR	1	0	Procurement status
36	ERFDAT	☐	ERFDA	DATUM	DATS	8	0	Created on
37	ERFUSR	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
38	ERFZT	☐	ERZET	UZEIT	TIMS	6	0	Entry time
39	.INCLUDE	☐				0	0	Merchandise Distr.: Addnl Data for Execution in External WM
40	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
41	LGNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	T300
42	MD_ADJUST_EXEC	☐	DE_WMD_ADJUST_EXECUTE	DO_WMD_ADJUST_EXECUTE	CHAR	1	0	Sytems of Adjustment and Execution of Merchandise Distributn
43	KZVAS	☐	FRM_VAS_REL	CHAR1_X	CHAR	1	0	Indicates relevant SLS with sub-items
44	IND_UC_SPLIT	☐	DE_WMD_UC_SPLIT	BOOLE	CHAR	1	0	Only one End Customer per Item
45	UEBPO	☐	UEBPO	EBELP	NUMC	5	0	Higher-Level Item in Purchasing Documents	*
46	MD_PROCESS_METH	☐	DE_WMD_PROCESS_METHOD	DO_WMD_PROCESS_METHOD	CHAR	3	0	Process Method for Merchandise Distribution
47	MD_PROCESS_ID	☐	/SPE/CD_PROCESS	VBELN	CHAR	10	0	Cross-Docking Process Number	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FRET	EINCD	T006	MSEHI	REF	1	CN
2	FRET	EINFT	T006	MSEHI	REF	1	CN
3	FRET	EINPA	T006	MSEHI	REF	1	CN
4	FRET	EINVT	T006	MSEHI	REF	1	CN
5	FRET	IEINA	T006	MSEHI	REF	1	CN
6	FRET	IEINB	T006	MSEHI	REF	1	CN
7	FRET	LGNUM	T300	LGNUM
8	FRET	MANDT	T000	MANDT	KEY	1	CN
9	FRET	MATNR	MARA	MATNR	REF	1	CN
10	FRET	PEINA	T006	MSEHI	REF	1	CN
11	FRET	PEINB	T006	MSEHI	REF	1	CN
12	FRET	WERKA	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20100310
SAP Release Created in