SAP ABAP Table FRE_MD_MATLOC_STY (Location Product data incl ISO fields)

Hierarchy

☛

SAP_APPL (Software Component) Logistics and Accounting
⤷

CA (Application Component) Cross-Application Components
⤷

WFRE_PI (Package) Connectivity with F&R

Basic Data

Table Category	INTTAB	Structure
Structure	FRE_MD_MATLOC_STY	Table Relationship Diagram
Short Description	Location Product data incl ISO fields

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE				0	0	Location Produc header data
2	MANDT	MANDT	MANDT	CLNT	3	0	Client	*
3	MATNR	MATNR	MATNR	CHAR	18	0	Material Number	*
4	WERKS	WERKS_D	WERKS	CHAR	4	0	Plant	*
5	LOCTYPE	FRE_LOCTYPE	FRE_LOCTYPE	CHAR	4	0	Location type
6	SEQNB	FRE_BIF_SEQNB	NUMC3	NUMC	3	0	F&R BIF: Sequence number
7	.INCLUDE				0	0	F&R BIF: Process status
8	PSTATUS	FRE_BIF_PSTATUS	FRE_BIF_STATUS	CHAR	1	0	F&R Processing status indicator
9	.INCLUDE				0	0	F&R BIF: Function
10	FUNCTION	FRE_BIF_FUNCTION	FRE_BIF_FUNCTION_CODE	CHAR	1	0	F&R Function code
11	.INCLUDE				0	0	Product Location attributes
12	BESKZ	BESKZ	BESKZ	CHAR	1	0	Procurement Type
13	BESKZ_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
14	BWSCL	BWSCL	BQSCL	CHAR	1	0	Source of Supply	*
15	BWSCL_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
16	MAABC	MAABC	MAABC	CHAR	1	0	ABC indicator	*
17	MAABC_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
18	SELLCLASS	FRE_SELLCLASS	FRE_ELLCLASS	NUMC	1	0	Selling Class
19	SELLCLASS_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
20	DISPO	DISPO	DISPO	CHAR	3	0	MRP controller	*
21	DISPO_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
22	VRBMT	VRBMT	MATNR	CHAR	18	0	Reference material for consumption	*
23	VRBMT_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
24	VRBMT_TYPE	FRE_PROD_TYPE	FRE_PROD_TYPE	CHAR	2	0	F&R Product Type for PRODUCT Interface
25	VRBMT_TYPE_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
26	VRBWK	VRBWK	WERKS	CHAR	4	0	Reference plant for consumption	*
27	VRBWK_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
28	VRBWK_TYPE	FRE_LOCTYPE	FRE_LOCTYPE	CHAR	4	0	Location type
29	VRBWK_TYPE_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
30	VRBFK	VRBFK	DEC2_2	DEC	4	2	Multiplier for reference material for consumption
31	VRBFK_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
32	VRBDT	VRBDT	DATUM	DATS	8	0	To date of the material to be copied for consumption
33	VRBDT_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
34	RPSTATUS	FRE_RPSTATUS	FRE_SCMB_MDL_RPSTATUS	CHAR	2	0	F&R Replenishment type of the Product
35	RPSTATUS_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
36	MEGRU	MEGRU	MEGRU	CHAR	4	0	Unit of Measure Group	*
37	MEGRU_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
38	SALESPRICE	FRE_SALESPRICE	DEC13_3	DEC	13	3	FRE Sales Price
39	SALESPRICE_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
40	CURRENCY	CURRENCY	WAERS	CUKY	5	0	Currency Key	*
41	MABST	MABST	MENG13	QUAN	13	3	Maximum stock level
42	MABST_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
43	EISLO	EISLO	MENG13	QUAN	13	3	Minimum Safety Stock
44	EISLO_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
45	TARGET_STOCK	WRF_FRE_TARGET_STOCK	MENG13	QUAN	13	3	Target Stock
46	TARGET_STOCK_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
47	MINBE	MINBE	MENG13	QUAN	13	3	Reorder point
48	MINBE_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
49	PURTIME	FRE_PURTIME	TSTRDURAG	DEC	11	0	FRE Purchasing Department Processing Time in Hours
50	PURTIME_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
51	RELTIME	FRE_RELTIME	TSTRDURAG	DEC	11	0	FRE Order Release Time
52	RELTIME_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
53	WEBAZ	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
54	WEBAZ_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
55	MHDRZ	MHDRZ	DEC4	DEC	4	0	Minimum Remaining Shelf Life
56	MHDRZ_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
57	SAISO	SAISO	SAISO	CHAR	4	0	Season Category	*
58	SAISO_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
59	LISTINGSTATUS	FRE_LISTINGSTATUS	FRE_LISTINGSTATUS	NUMC	1	0	F&R Listing Status
60	LISTINGSTATUS_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
61	PROPR	PROPR	PROPR	CHAR	4	0	Forecast profile	*
62	PROPR_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
63	PROREPL	FRE_PROREPL	FRE_PROFILE	CHAR	10	0	F&R Replenishment Profile for FRP Module
64	PROREPL_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
65	PROEXP	FRE_PROEXCP	FRE_PROFILE	CHAR	10	0	F&R Exception Profile for FRP Module
66	PROEXP_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
67	PROCL	FRE_PROCL	FRE_PROFILE	CHAR	10	0	F&R Capital Lockup Profile
68	PROCL_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
69	PLIFZ	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
70	PLIFZ_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
71	LEADTIMESHIFT	FRE_LEADTIMESHIFT	NUMC2	NUMC	2	0	F&R Lead Time Shift
72	LEADTIMESHIFT_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
73	STOCKMULTIPLE	FRE_STOCKMULTIPLE	FRE_QUANT	QUAN	19	6	F&R Stock Multiple
74	STOCKMULTIPLE_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
75	FCHOROP	FRE_FCHOROP	NUMC3	NUMC	3	0	Operational Forecast Horizon (in weeks)
76	FCHOROP_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
77	FCOUTDAY	FRE_FCOUTDAY	NUMC3	NUMC	3	0	Output Daily Forecast (in weeks)
78	FCOUTDAY_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
79	FCOUTWEEK	FRE_FCOUTWEEK	NUMC3	NUMC	3	0	Output Weekly Forecast (in weeks)
80	FCOUTWEEK_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
81	PROSL	FRE_PROSL	FRE_PROFILE	CHAR	10	0	Service Level Profile
82	PROSL_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
83	MIN_TROC	FRE_MINTROC	NUMC3	NUMC	3	0	Minimum Target Range of Coverage
84	MIN_TROC_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
85	MAX_TROC	FRE_MAXTROC	NUMC3	NUMC	3	0	Maximum Target Range of Coverage
86	MAX_TROC_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
87	TEMPRPBLOCK	FRE_TEMPRBLOCK	FRE_TEMPRPBLOCK	CHAR	2	0	Temporary replenishment blocking
88	TEMPRPBLOCK_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
89	TEMPRPFROM	FRE_TEMPRPFROM	TZNTSTMPS	DEC	15	0	Starting date of temporary replenishment blocking
90	TEMPRPFROM_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
91	TEMPRPTO	FRE_TEMPRPTO	TZNTSTMPS	DEC	15	0	Ending date of temporary replenishment blocking
92	TEMPRPTO_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
93	INIT_BUY_CHECK	FRE_INIT_BUY_CHECK	FRE_INIT_BUY_CHECK	CHAR	1	0	Initial buy check
94	INIT_BUY_CHECK_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level
95	.INCLUDE				0	0	F&R BIF: Administration data
96	CREDATE	FRE_CRETST	TZNTSTMPS	DEC	15	0	F&R Creation Time Stamp
97	UPDDATE	FRE_CHGTST	TZNTSTMPS	DEC	15	0	F&R Change Time Stamp
98	SENDER	FRE_SYSTEM_R3	LOGSYS	CHAR	10	0	System of R3	*
99	REF_ID	FRE_BIF_ID	FRE_BIF_GUID	CHAR	35	0	Identifier
100	NO_CONS	FRE_NO_CONS	FRE_NO_CONS	CHAR	1	0	No Consumption Data from SAP BI to be loaded
101	NO_CONS_X	FRE_BIF_FIELDUPDATE	BAPIUPDATE	CHAR	1	0	F&R Update indicator on field level