	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

PRF_EXT TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Supply Chain Management :: SCM Basis
1	ERP EHP7	6.0	/SAPAPO/PRF_EXT	176	1	Profile Extension for Base Profile /SAPAPO/DP440P	SCM Basis

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, PRF_EXTENSION, Y_TRACK_PERIODS, X_TRACK_SIGNALS, TRACK_ACTUAL_VAL, TRACK_ACTUAL_PER, TRACK_FCST_COMP, SMTH_TRACKING, THRESHOLD_TRACK, TRACK_OCCUR, TRACK_LAST_RUN, NEG_TRIP_EN, NEG_TRIP_PC, NEG_TRIP_PP, POS_TRIP_EN, POS_TRIP_PC, POS_TRIP_PP, TRIP_CNTRL_PC, TRIP_CNTRL_PP, TRIP_PC_ACTUAL, TRIP_PP_ACTUAL, TRIP_EN_ACTUAL, TRIP_PC_LENGTH, TRIP_PP_LENGTH, TRIP_EN_LENGTH, TRIP_OCCUR_PC, TRIP_OCCUR_PP, TRIP_OCCUR_EN, TRIP_LAST_RUN, TRIP_INITDATE_PC, TRIP_INITDATE_PP, TRIP_INITDATE_EN, FOES_USED_PERIOD, FOES_DEV_CALC, FOES_STAB_PERIOD, SOES_USED_PERIOD, SOES_DEV_CALC, SOES_STAB_PERIOD, TS_DEV_CALC, TS_STAB_PERIOD, TREND_MAX_INCR, CP_SIGLVL_6, CP_SIGLVL_13, CP_SIGLVL_26, CP_SIGLVL_13_PP, CP_SIGLVL_26_PP, CP_SIGLVL_6N, CP_SIGLVL_13N, CP_SIGLVL_26N, CP_SIGLVL_13_PPN, CP_SIGLVL_26_PPN, CP_MIN_ENT_OUTL, CP_MIN_FCST_ENT, CP_INCR_FCST_ENT, CP_MIN_ENT_HIST, CP_MIN_REQ_EN_13, CP_MIN_REQ_EN_26, CP_PP_CHECK_L1, CP_PP_CHECK_L2, CP_PC_MAD_SMTH, CP_MIN_FCST_ENTT, CP_MIN_FCST_PP, CP_MIN_ENT_STAB, CP_MIN_PP_STAB, CP_MIN_ENT_YEAR, CP_MIN_ENT_STABY, CP_MIN_PP_DEV, CP_MIN_PP_DEV_ST, CP_RETEST_LEN, CP_MIN_PP_RETEST, CP_MIN_PPD_RTEST, CP_DEV_CALC, CP_STAB_PERIOD, CP_OUTL_VAL_EN, CP_OUTL_VAL_PP, CP_USE_OLD_DEVPC, CP_USE_OLD_DEVPP, CP_USE_OLD_DEVEN, S_MIN_NO_PC, S_MAX_INCREASE, S_MIN_DECREASE, SEASON_TRENDFAC, SEASON_COST_THLD, S_SIG_LEVEL_PEAK, S_SLOPE_PEAK, S_SIGLVL_AUTCORR, S_SIGLVL_AUTO_ST, S_MIN_TEST_WINDO, S_TTEST_RECENT, S_TTEST_BEFORE, S_TTEST_REC_STAB, S_TTEST_BEF_STAB, S_DEV_CALC, S_STAB_PERIOD, TREND_EXT_LEN, T_PAST_PERIODS, TREND_LIN_LENGTH, T_TEST_12, T_TEST_24, T_TEST_12_STAB, T_TEST_24_STAB, T_DEV_CALC, T_STAB_PERIOD, MA_PAST_PERIODS, MA_MIN_LENGTH, MA_MAX_LENGTH, MA_DEV_CALC, MA_STAB_PERIOD, DGR_PAST_PERIODS, DGR_PC_MLTPL_FAC, DGR_MIN_DCL_RATE, DGR_FCST_LIMIT, DGR_LOW_COST, DGR_MEDIUM_COST, DGR_HIGH_COST, DGR_DEV_CALC, DGR_DCL_RATE, DGR_STAB_PERIOD, INTMIT_MIN_ZERO, INTMIT_DEV_FACTO, INTMIT_OUTL_MIN, INTMIT_TIME_SMTH, INTMIT_MAD_SMTH, INTMIT_AVGNZHIST, INTMIT_AVGNZDIST, INTMIT_PASTPERIO, INTMIT_STAB_PER, INTMIT_DEV_CALC, MIN_NON_ZERO, MODEL_SIM_PERIOD, MAD_INIT_MAX, MAD_INIT_MIN, BASIC_VAL_LB_PC, BASIC_VAL_LB_PP, BASIC_VAL_LB_EN, BASIC_VAL_UB_PC, BASIC_VAL_UB_PP, BASIC_VAL_UB_EN, BASIC_VAL_CLF_PC, BASIC_VAL_CLF_PP, BASIC_VAL_CLF_EN, BASIC_VAL_CUF_PC, BASIC_VAL_CUF_PP, BASIC_VAL_CUF_EN, OUTL_CNTRL_PC, OUTL_CNTRL_PP, OUTL_CNTRL_EN, SEASON_GROUP_PRF, SMTH_PARAM_SET, BVALUE_PC, BVALUE_EN, BVALUE_PP, MAD_PC, MAD_EN, MAD_PP, PHASEIN_PRF_TYPE, PHASEIN_ACT_TYPE, PHASEIN_GRP, MAXDEV_APPROVAL, NOT_USE_DISAG, MODEL_CHANGE_DAT, FREEZE_LIMIT_UP, FREEZE_LIMIT_DOW, FREEZE_IN_DATE, FREEZE_OUT_DATE, FREEZE_TYPE, PHASEOUT_GRP, FCST_FROM_DATE, DGR_FCSTLIMIT, LI_KEYF_GROUP, LI_KEYF, LI_VALUES, COEFF_VALUES, COEFF_CONST_VAL, FFDP_ID, MODSEL_PRF_ID FROM /SAPAPO/PRF_EXT

TOP ERP 6.0 | /SAPAPO/PRF_EXT COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	*	/SAPAPO/MANDT	Allow NULL?
2	PRF_EXTENSION	Master Forecast Profile	nvarchar	22	0	CHAR	(N' ')	No	*	/SAPAPO/PRPFL	Allow NULL?
3	Y_TRACK_PERIODS	Tracking Horizon	int	10	0	INT4	((0))	Yes		/SAPAPO/Y_TRACKING_PERIODS	Allow NULL?
4	X_TRACK_SIGNALS	Tracking Signals in Horizon	int	10	0	INT4	((0))	Yes		/SAPAPO/X_TRACKING_SIGNALS	Allow NULL?
5	TRACK_ACTUAL_VAL	Tracking Signal Counter	int	10	0	INT4	((0))	Yes		/SAPAPO/TRACKING_ACTUAL	Allow NULL?
6	TRACK_ACTUAL_PER	Tracking Period Counter	int	10	0	INT4	((0))	Yes		/SAPAPO/TRACKING_ACTUAL_PERIOD	Allow NULL?
7	TRACK_FCST_COMP	Offset Forecast Creation	decimal	3	0	DEC	((0))	Yes		/SAPAPO/TRACK_FCST_COMP
8	SMTH_TRACKING	Smoothing Factor for Tracking	decimal	3	2	DEC	((0))	Yes		/SAPAPO/SMTH_PARAM_TRACKING
9	THRESHOLD_TRACK	Tracking Threshold	decimal	5	3	DEC	((0))	Yes		/SAPAPO/THRESHLD_VAL_TRACKING
10	TRACK_OCCUR	Tracking Threshold: Date Exceeded	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPAPO/TRACK_OCCUR	Allow NULL?
11	TRACK_LAST_RUN	Last Tracking Run	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPAPO/TRACK_LAST_RUN	Allow NULL?
12	NEG_TRIP_EN	Tripping: Lower Limit for Item	int	10	0	INT4	((0))	Yes		/SAPAPO/TRIP_THRESHOLD_NEG_ENT	Allow NULL?
13	NEG_TRIP_PC	Tripping: Lower Limit for Demand	int	10	0	INT4	((0))	Yes		/SAPAPO/TRIP_THRESHOLD_NEG_PC	Allow NULL?
14	NEG_TRIP_PP	Tripping: Lower Limit for Demand/Item	int	10	0	INT4	((0))	Yes		/SAPAPO/TRIP_THRESHOLD_NEG_PP	Allow NULL?
15	POS_TRIP_EN	Tripping: Upper Limit for Item	int	10	0	INT4	((0))	Yes		/SAPAPO/TRIP_THRESHOLD_POS_ENT	Allow NULL?
16	POS_TRIP_PC	Tripping: Upper Limit for Demand	int	10	0	INT4	((0))	Yes		/SAPAPO/TRIP_THRESHOLD_POS_PC	Allow NULL?
17	POS_TRIP_PP	Tripping: Upper Limit for Demand/Item	int	10	0	INT4	((0))	Yes		/SAPAPO/TRIP_THRESHOLD_POS_PP	Allow NULL?
18	TRIP_CNTRL_PC	Trip Limit - Parameter for Demand	decimal	4	3	DEC	((0))	Yes		/SAPAPO/TRIP_CNTRL_PC
19	TRIP_CNTRL_PP	Trip Limit - Parameter for Demand/Item	decimal	4	3	DEC	((0))	Yes		/SAPAPO/TRIP_CNTRL_PP
20	TRIP_PC_ACTUAL	Trip Counter for Current Demand	int	10	0	INT4	((0))	Yes		/SAPAPO/TRIP_PC_ACTUAL	Allow NULL?
21	TRIP_PP_ACTUAL	Trip Counter for Current Demand/Item	int	10	0	INT4	((0))	Yes		/SAPAPO/TRIP_PP_ACTUAL	Allow NULL?
22	TRIP_EN_ACTUAL	Trip Counter for Current Item	int	10	0	INT4	((0))	Yes		/SAPAPO/TRIP_EN_ACTUAL	Allow NULL?
23	TRIP_PC_LENGTH	Current trip length for demand	int	10	0	INT4	((0))	Yes		/SAPAPO/TRIP_PC_LENGTH	Allow NULL?
24	TRIP_PP_LENGTH	Current trip lenght for demand/item	int	10	0	INT4	((0))	Yes		/SAPAPO/TRIP_PP_LENGTH	Allow NULL?
25	TRIP_EN_LENGTH	Current trip length for item	int	10	0	INT4	((0))	Yes		/SAPAPO/TRIP_EN_LENGTH	Allow NULL?
26	TRIP_OCCUR_PC	Trip Limit for Demand: Date Exceeded	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPAPO/TRIP_OCCUR_PC	Allow NULL?
27	TRIP_OCCUR_PP	Trip-Limit for Demand/Item: Date Exceeded	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPAPO/TRIP_OCCUR_PP	Allow NULL?
28	TRIP_OCCUR_EN	Trip Limit for Item: Date Exceeded	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPAPO/TRIP_OCCUR_EN	Allow NULL?
29	TRIP_LAST_RUN	Last Tripping Run	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPAPO/TRIP_LAST_RUN	Allow NULL?
30	TRIP_INITDATE_PC	Initialization Date for Demand	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPAPO/TRIP_INITDATE_PC	Allow NULL?
31	TRIP_INITDATE_PP	Initialization Date for Demand per Order Item	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPAPO/TRIP_INITDATE_PP	Allow NULL?
32	TRIP_INITDATE_EN	Initialization Date for Order Item	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPAPO/TRIP_INITDATE_EN	Allow NULL?
33	FOES_USED_PERIOD	Periods for First-Order Exponential Smoothing	decimal	3	0	DEC	((0))	Yes		/SAPAPO/FOES_USED_PERIOD
34	FOES_DEV_CALC	Number of Periods for Std Dev. FOES	decimal	3	0	DEC	((0))	Yes		/SAPAPO/FOES_DEV_CALC
35	FOES_STAB_PERIOD	Stability Periods for FOES	decimal	3	0	DEC	((0))	Yes		/SAPAPO/FOES_STAB_PERIOD
36	SOES_USED_PERIOD	Periods for SOES	decimal	3	0	DEC	((0))	Yes		/SAPAPO/SOES_USED_PERIOD
37	SOES_DEV_CALC	Number of Periods Std Dev. for SOES	decimal	3	0	DEC	((0))	Yes		/SAPAPO/SOES_DEV_CALC
38	SOES_STAB_PERIOD	Stability Periods for SOES	decimal	3	0	DEC	((0))	Yes		/SAPAPO/SOES_STAB_PERIOD
39	TS_DEV_CALC	Number of Periods Standard Deviation in Seasonal Trend Model	decimal	3	0	DEC	((0))	Yes		/SAPAPO/TS_DEV_CALC
40	TS_STAB_PERIOD	Minimum Number of Periods for Seasonal Trend Model	decimal	3	0	DEC	((0))	Yes		/SAPAPO/TS_STAB_PERIOD
41	TREND_MAX_INCR	Forecast Trend Delimiter (Percentage)	decimal	12	3	DEC	((0))	Yes		/SAPAPO/TREND_MAX_INCREASE
42	CP_SIGLVL_6	Significance Level T-Test 6:7 for Item in DMA Model	decimal	4	3	DEC	((0))	Yes		/SAPAPO/CP_SIGLVL_6
43	CP_SIGLVL_13	Significance Level T-Test 13:13 for Item in DMA Model	decimal	4	3	DEC	((0))	Yes		/SAPAPO/CP_SIGLVL_13
44	CP_SIGLVL_26	Significance Level T-Test 26:26 for Item in DMA Model	decimal	4	3	DEC	((0))	Yes		/SAPAPO/CP_SIGLVL_26
45	CP_SIGLVL_13_PP	Significance Level T-Test 13:13 for Demand/Item in DMA Model	decimal	4	3	DEC	((0))	Yes		/SAPAPO/CP_SIGLVL_13_PP
46	CP_SIGLVL_26_PP	Significance Level T-Test 26:26 for Demand/Item in DMA Model	decimal	4	3	DEC	((0))	Yes		/SAPAPO/CP_SIGLVL_26_PP
47	CP_SIGLVL_6N	Neg. Significance Level T-Test 6:7 for Item in DMA Model	decimal	4	3	DEC	((0))	Yes		/SAPAPO/CP_SIGLVL_6_NEG
48	CP_SIGLVL_13N	Neg. Significance Level T-Test 13:13 for Item in DMA Model	decimal	4	3	DEC	((0))	Yes		/SAPAPO/CP_SIGLVL_13_NEG
49	CP_SIGLVL_26N	Neg. Significance Level T-Test 26:26 for Item in DMA Model	decimal	4	3	DEC	((0))	Yes		/SAPAPO/CP_SIGLVL_26_NEG
50	CP_SIGLVL_13_PPN	Neg. Sig. Level T-Test 13:13 for Demand/Item in DMA Model	decimal	4	3	DEC	((0))	Yes		/SAPAPO/CP_SIGLVL_13_PP_NEG
51	CP_SIGLVL_26_PPN	Neg. Sig. Level T-Test 26:26 for Demand/Item in DMA Model	decimal	4	3	DEC	((0))	Yes		/SAPAPO/CP_SIGLVL_26_PP_NEG
52	CP_MIN_ENT_OUTL	Outlier Correction Parameter for Item in DMA Model	decimal	12	3	DEC	((0))	Yes		/SAPAPO/CP_MIN_ENT_OUTL
53	CP_MIN_FCST_ENT	Parameter1: Relevant Periods for Demand/Item in DMA Model	decimal	12	3	DEC	((0))	Yes		/SAPAPO/CP_MIN_FCST_ENTRY
54	CP_INCR_FCST_ENT	Param2: Relevant Periods for Demand/Item in DMA Model	decimal	12	3	DEC	((0))	Yes		/SAPAPO/CP_INCR_FCST_ENT
55	CP_MIN_ENT_HIST	Param3: Relevant Periods for Demand/Item in DMA Model	decimal	12	3	DEC	((0))	Yes		/SAPAPO/CP_MIN_ENT_HIST
56	CP_MIN_REQ_EN_13	Parameter4: Relevant Period for Demand/Item in DMA Model	decimal	12	3	DEC	((0))	Yes		/SAPAPO/CP_MIN_REQ_EN_13
57	CP_MIN_REQ_EN_26	Parameter5: Relevant Period for Demand/Item in DMA Model	decimal	12	3	DEC	((0))	Yes		/SAPAPO/CP_MIN_REQ_EN_26
58	CP_PP_CHECK_L1	Parameter1: Outlier Correction Demand/Item in DMA Model	decimal	12	3	DEC	((0))	Yes		/SAPAPO/CP_PP_CHECK_LIMIT1
59	CP_PP_CHECK_L2	Parameter2: Outlier Correction for Demand/Item in DMA Model	decimal	12	3	DEC	((0))	Yes		/SAPAPO/CP_PP_CHECK_LIMIT2
60	CP_PC_MAD_SMTH	MAD Smoothing Factor for Demand in DMA Model	decimal	3	2	DEC	((0))	Yes		/SAPAPO/CP_PC_MAD_SMTHFACTOR
61	CP_MIN_FCST_ENTT	Threshold for Item in Sporadic Test	decimal	12	3	DEC	((0))	Yes		/SAPAPO/CP_MIN_FCST_ENT
62	CP_MIN_FCST_PP	Threshold for Demand/Item in Sporadic Test	decimal	12	3	DEC	((0))	Yes		/SAPAPO/CP_MIN_FCST_PP
63	CP_MIN_ENT_STAB	Stability Threshold Value for Item in Sporadic Test	decimal	12	3	DEC	((0))	Yes		/SAPAPO/CP_MIN_FCST_ENT_STAB
64	CP_MIN_PP_STAB	Stability Threshold Value for Demand/Item in Sporadic Test	decimal	12	3	DEC	((0))	Yes		/SAPAPO/CP_MIN_FCST_PP_STAB
65	CP_MIN_ENT_YEAR	Threshold for Item Annual History in Sporadic Test	decimal	12	3	DEC	((0))	Yes		/SAPAPO/CP_MIN_ENT_YEAR
66	CP_MIN_ENT_STABY	Stab. Threshold Val.for Item History in Sporadic Test	decimal	12	3	DEC	((0))	Yes		/SAPAPO/CP_MIN_ENT_YEAR_STAB
67	CP_MIN_PP_DEV	Threshold Value for Std Dev. Demand/Item in Sporadic Test	decimal	12	3	DEC	((0))	Yes		/SAPAPO/CP_MIN_PP_DEV
68	CP_MIN_PP_DEV_ST	Stability Theshold for Std Dev. Demand/Item in Sporadic Test	decimal	12	3	DEC	((0))	Yes		/SAPAPO/CP_MIN_PP_DEV_STAB
69	CP_RETEST_LEN	Re-Test for Period Length in Sporadic Test	decimal	3	0	DEC	((0))	Yes		/SAPAPO/CP_RETEST_HIST_LENGTH
70	CP_MIN_PP_RETEST	Re-Test of Forecast Threshold for Demand/Item in Spor. Test	decimal	12	3	DEC	((0))	Yes		/SAPAPO/CP_MIN_PP_RETEST
71	CP_MIN_PPD_RTEST	Re-test Std Dev. Threshold for Demand/Item in Sporadic Test	decimal	12	3	DEC	((0))	Yes		/SAPAPO/CP_MIN_PP_DEV_RETEST
72	CP_DEV_CALC	Number of Periods Std Dev. for Dynamic Moving Average Model	decimal	3	0	DEC	((0))	Yes		/SAPAPO/CP_DEV_CALC
73	CP_STAB_PERIOD	Minimum Number of Periods for DMA Model	decimal	3	0	DEC	((0))	Yes		/SAPAPO/CP_STAB_PERIOD
74	CP_OUTL_VAL_EN	Outlier Correction Value for Item in DMA Model	decimal	12	3	DEC	((0))	Yes		/SAPAPO/CP_OUTL_VAL_EN
75	CP_OUTL_VAL_PP	Outlier Correction Value for Demand/Item in DMA Model	decimal	12	3	DEC	((0))	Yes		/SAPAPO/CP_OUTL_VAL_PP
76	CP_USE_OLD_DEVPC	General Flag	char	1	0	CHAR	(N' ')	Yes		FLAG	Allow NULL?
77	CP_USE_OLD_DEVPP	General Flag	char	1	0	CHAR	(N' ')	Yes		FLAG	Allow NULL?
78	CP_USE_OLD_DEVEN	General Flag	char	1	0	CHAR	(N' ')	Yes		FLAG	Allow NULL?
79	S_MIN_NO_PC	Minimum Annual Demand for Seasonal Test	decimal	12	3	DEC	((0))	Yes		/SAPAPO/S_MIN_NO_PIECES
80	S_MAX_INCREASE	Upper Trend Delimiter for Seasonal Test	decimal	12	3	DEC	((0))	Yes		/SAPAPO/S_MAX_INCREASE_FACTOR
81	S_MIN_DECREASE	Lower Trend Delimiter for Seasonal Test	decimal	12	3	DEC	((0))	Yes		/SAPAPO/S_MIN_DECREASE_FACTOR
82	SEASON_TRENDFAC	Annual Weighting Factor for Seasonal Trend Model with FPG	decimal	4	3	DEC	((0))	Yes		/SAPAPO/SEASON_TRENDFACTOR
83	SEASON_COST_THLD	Cost Limit for Demand in Seasonal Trend Model with FPG	decimal	12	2	DEC	((0))	Yes		/SAPAPO/SEASON_COST_THRESHOLD
84	S_SIG_LEVEL_PEAK	Significance Level for Peak Test in Seasonal Test	decimal	4	3	DEC	((0))	Yes		/SAPAPO/SEAS_SIGLVL_PEAK_TEST
85	S_SLOPE_PEAK	Gradient Threshold for Peak Test in Seasonal Test	decimal	4	3	DEC	((0))	Yes		/SAPAPO/SEAS_SLOPE_PEAK
86	S_SIGLVL_AUTCORR	Significance Level for Autocorrelation Test in Seasonal Test	decimal	4	3	DEC	((0))	Yes		/SAPAPO/SEAS_SIGLVL_AUTOCORREL
87	S_SIGLVL_AUTO_ST	Stability Significance Level for Autocorr. Test in Seas. Tst	decimal	4	3	DEC	((0))	Yes		/SAPAPO/SEAS_SIGLVL_AUTO_STAB
88	S_MIN_TEST_WINDO	Minimum Window Size for T-Test Run in Seasonal Test	decimal	3	0	DEC	((0))	Yes		/SAPAPO/SEAS_MIN_TEST_WINDOW
89	S_TTEST_RECENT	Sig. Level T-Test Run for Current Year in Seasonal Test	decimal	4	3	DEC	((0))	Yes		/SAPAPO/SEAS_TTEST_RECENT
90	S_TTEST_BEFORE	Sig. Level for T-Test Run for Previous Year in Seasonal Test	decimal	4	3	DEC	((0))	Yes		/SAPAPO/SEAS_TTEST_BEFORE
91	S_TTEST_REC_STAB	Stab.Sig. Level T-Test Run for Current Year in Seasonal Test	decimal	4	3	DEC	((0))	Yes		/SAPAPO/SEAS_TTEST_RECENT_STAB
92	S_TTEST_BEF_STAB	Stab. Sig. Level for T-Test Run of Prvious Year Season. Test	decimal	4	3	DEC	((0))	Yes		/SAPAPO/SEAS_TTEST_BEFORE_STAB
93	S_DEV_CALC	No. Periods for Stand. Deviation Seasonal Trend Model w/ FPG	decimal	3	0	DEC	((0))	Yes		/SAPAPO/S_DEV_CALC
94	S_STAB_PERIOD	Stbility Periods for Seasonal Trend Model with FPG	decimal	3	0	DEC	((0))	Yes		/SAPAPO/S_STAB_PERIOD
95	TREND_EXT_LEN	Forecast Trend Delimiter (Temporal)	decimal	3	0	DEC	((0))	Yes		/SAPAPO/TREND_EXT_LEN
96	T_PAST_PERIODS	Number of Periods for Trend Line in LR Model	decimal	3	0	DEC	((0))	Yes		/SAPAPO/TREND_PAST_PERIODS
97	TREND_LIN_LENGTH	Number of Periods for Parameter Determination in LR Model	decimal	3	0	DEC	((0))	Yes		/SAPAPO/TREND_LINE_LENGTH
98	T_TEST_12	Threshold for 12 Periods in Trend Test	decimal	4	3	DEC	((0))	Yes		/SAPAPO/T_TEST_MIN_RATIO_12
99	T_TEST_24	Threshold for 24 Periods in Trend Test	decimal	4	3	DEC	((0))	Yes		/SAPAPO/T_TEST_MIN_RATIO_24
100	T_TEST_12_STAB	Stability Threshold Value for 12 Periods in Trend Test	decimal	4	3	DEC	((0))	Yes		/SAPAPO/T_TEST_MIN_RAT_12_STAB
101	T_TEST_24_STAB	Stability Threshold Value for 24 Periods in Trend Test	decimal	4	3	DEC	((0))	Yes		/SAPAPO/T_TEST_MIN_RAT_24_STAB
102	T_DEV_CALC	Number of Periods for Standard Deviation in LR Model	decimal	3	0	DEC	((0))	Yes		/SAPAPO/T_DEV_CALC
103	T_STAB_PERIOD	Stability Periods in LR Model	decimal	3	0	DEC	((0))	Yes		/SAPAPO/T_STAB_PERIOD
104	MA_PAST_PERIODS	Number of Periods in Moving Average Model	decimal	3	0	DEC	((0))	Yes		/SAPAPO/MA_PAST_PERIODS
105	MA_MIN_LENGTH	Min. Window Length in Moving Average Model	decimal	3	0	DEC	((0))	Yes		/SAPAPO/MA_MIN_LENGTH
106	MA_MAX_LENGTH	Max. Window Length in Moving Average Model	decimal	3	0	DEC	((0))	Yes		/SAPAPO/MA_MAX_LENGTH
107	MA_DEV_CALC	Periods for Std Dev. of Moving Average Model	decimal	3	0	DEC	((0))	Yes		/SAPAPO/MA_DEV_CALC
108	MA_STAB_PERIOD	Stability Periods in Moving Average Model	decimal	3	0	DEC	((0))	Yes		/SAPAPO/MA_STAB_PERIOD
109	DGR_PAST_PERIODS	Periods in Declining Demand Forecast Model	decimal	3	0	DEC	((0))	Yes		/SAPAPO/DGR_PAST_PERIODS
110	DGR_PC_MLTPL_FAC	Demand Multiplier in DDF Model	decimal	4	3	DEC	((0))	Yes		/SAPAPO/DGR_PC_MLTPL_FACTOR
111	DGR_MIN_DCL_RATE	Lower Limit of Decline Factor in DDF Model	decimal	4	3	DEC	((0))	Yes		/SAPAPO/DGR_MIN_DCL_RATE
112	DGR_FCST_LIMIT	Forecast Delimiter Switch in DDF Model	decimal	12	3	DEC	((0))	Yes		/SAPAPO/DGR_FCST_LIMIT
113	DGR_LOW_COST	Lower Cost Limit for Demand in DDF Model	decimal	12	2	DEC	((0))	Yes		/SAPAPO/DGR_LOW_COST_BOUND
114	DGR_MEDIUM_COST	Middle Cost Limit for Demand in DDF Model	decimal	12	2	DEC	((0))	Yes		/SAPAPO/DGR_MEDIUM_COST_BOUND
115	DGR_HIGH_COST	Upper Cost Limit for Demand in DDF Model	decimal	12	2	DEC	((0))	Yes		/SAPAPO/DGR_HIGH_COST_BOUND
116	DGR_DEV_CALC	Number of Periods for Standard Deviation in DDF Model	decimal	3	0	DEC	((0))	Yes		/SAPAPO/DGR_DEV_CALC
117	DGR_DCL_RATE	Declining Growth Rate in DDF Model	decimal	4	3	DEC	((0))	Yes		/SAPAPO/DGR_DCL_RATE
118	DGR_STAB_PERIOD	Stability Periods in DDF Model	decimal	3	0	DEC	((0))	Yes		/SAPAPO/DGR_STAB_PERIOD
119	INTMIT_MIN_ZERO	Number of Zero-Demand Periods in Intermittent Forecast Model	decimal	3	0	DEC	((0))	Yes		/SAPAPO/INTMIT_MIN_ZERO
120	INTMIT_DEV_FACTO	Parameter1 for Outlier Correction in Intermittent Fcst Model	decimal	4	3	DEC	((0))	Yes		/SAPAPO/INTMIT_DEV_FACTOR
121	INTMIT_OUTL_MIN	Parameter2 for Outlier Correction in Intermittent Fcst Model	decimal	12	3	DEC	((0))	Yes		/SAPAPO/INTMIT_OUTL_MIN
122	INTMIT_TIME_SMTH	Smoothing Factor for Time in Intermittent Forecast Model	decimal	3	2	DEC	((0))	Yes		/SAPAPO/INTMIT_TIME_SMTH
123	INTMIT_MAD_SMTH	MAD Smoothing Factor in Intermittent Forecast Model	decimal	3	2	DEC	((0))	Yes		/SAPAPO/INTERMITTENT_MAD_SMTH
124	INTMIT_AVGNZHIST	Average Demand in Intermittent Forecast Model	decimal	12	3	DEC	((0))	Yes		/SAPAPO/AVERAGE_NZHIST
125	INTMIT_AVGNZDIST	Average Time Between Demands in Intermittent Forecast Model	decimal	12	3	DEC	((0))	Yes		/SAPAPO/AVERAGE_NZDIST
126	INTMIT_PASTPERIO	Number of Initialization Periods for Intermittent Fcst Model	decimal	3	0	DEC	((0))	Yes		/SAPAPO/INTMIT_PAST_PERIODS
127	INTMIT_STAB_PER	Minimum Number of Periods for Intermittent Forecast Model	decimal	3	0	DEC	((0))	Yes		/SAPAPO/INTMIT_STAB_PER
128	INTMIT_DEV_CALC	Number of Periods for Std Dev. in Intermittent Fcst Model	decimal	3	0	DEC	((0))	Yes		/SAPAPO/INTMIT_DEV_CALC
129	MIN_NON_ZERO	No. Non-Zero-Dem. Per. for Phase-In to Forecast Mod. Switch	decimal	3	0	DEC	((0))	Yes		/SAPAPO/MIN_NON_ZERO_MODL_SEL
130	MODEL_SIM_PERIOD	Number of Simulation Periods	decimal	3	0	DEC	((0))	Yes		/SAPAPO/MODEL_SIM_PERIOD
131	MAD_INIT_MAX	Parameter for Determination of MAD Upper Limit	decimal	12	3	DEC	((0))	Yes		/SAPAPO/MAD_INIT_MAX
132	MAD_INIT_MIN	Parameter for Determination of MAD Lower Limit	decimal	12	3	DEC	((0))	Yes		/SAPAPO/MAD_INIT_MIN
133	BASIC_VAL_LB_PC	Lower Limit for Calculation of Demand Base Value	decimal	12	3	DEC	((0))	Yes		/SAPAPO/BASIC_VAL_LOWBOUND_PC
134	BASIC_VAL_LB_PP	Upper limit for calculation of demand/item base value	decimal	12	3	DEC	((0))	Yes		/SAPAPO/BASIC_VAL_LOWBOUND_PP
135	BASIC_VAL_LB_EN	Lower Limit for Calculation of Item Base Value	decimal	12	3	DEC	((0))	Yes		/SAPAPO/BASIC_VAL_LOWBOUND_EN
136	BASIC_VAL_UB_PC	Upper Limit for Calculation of Demand Base Value	decimal	12	3	DEC	((0))	Yes		/SAPAPO/BASIC_VAL_UPBOUND_PC
137	BASIC_VAL_UB_PP	Upper Limit for Calculation of Demand/Item Base Value	decimal	12	3	DEC	((0))	Yes		/SAPAPO/BASIC_VAL_UPBOUND_PP
138	BASIC_VAL_UB_EN	Upper Limit for Calculation of Item Base Value	decimal	12	3	DEC	((0))	Yes		/SAPAPO/BASIC_VAL_UPBOUND_EN
139	BASIC_VAL_CLF_PC	Factor for Determination of Demand Base Value (Lower)	decimal	4	3	DEC	((0))	Yes		/SAPAPO/VAL_CALC_LOW_FACTOR_PC
140	BASIC_VAL_CLF_PP	Factor for Determination of Demand/Item Base Value (Lower)	decimal	4	3	DEC	((0))	Yes		/SAPAPO/VAL_CALC_LOW_FACTOR_PP
141	BASIC_VAL_CLF_EN	Factor for Determination of Item Base Value (Lower)	decimal	4	3	DEC	((0))	Yes		/SAPAPO/VAL_CALC_LOW_FACTOR_EN
142	BASIC_VAL_CUF_PC	Factor for Determination of Demand Base Value (Upper)	decimal	4	3	DEC	((0))	Yes		/SAPAPO/VAL_CALC_UP_FACTOR_PC
143	BASIC_VAL_CUF_PP	Factor for Determination of Demand/Item Base Value (Upper)	decimal	4	3	DEC	((0))	Yes		/SAPAPO/VAL_CALC_UP_FACTOR_PP
144	BASIC_VAL_CUF_EN	Factor for Determination of Item Base Value (Upper)	decimal	4	3	DEC	((0))	Yes		/SAPAPO/VAL_CALC_UP_FACTOR_EN
145	OUTL_CNTRL_PC	Parameters Outlier Correction for Demand	decimal	4	3	DEC	((0))	Yes		/SAPAPO/OUTLIER_CNTRL_PC
146	OUTL_CNTRL_PP	Parameters Outlier Correction for Demand/Item	decimal	4	3	DEC	((0))	Yes		/SAPAPO/OUTLIER_CNTRL_PP
147	OUTL_CNTRL_EN	Parameters Outlier Correction for Item	decimal	4	3	DEC	((0))	Yes		/SAPAPO/OUTLIER_CNTRL_EN
148	SEASON_GROUP_PRF	Season Indices: Profile Name	nvarchar	16	0	CHAR	(N' ')	Yes		/SAPAPO/SEASON_GROUP_PROFILE	Allow NULL?
149	SMTH_PARAM_SET	Smoothing Factors: Profile Name	nvarchar	16	0	CHAR	(N' ')	Yes		/SAPAPO/SMTH_PARAMETER_SET	Allow NULL?
150	BVALUE_PC	Base Value for Demand	decimal	12	3	DEC	((0))	Yes		/SAPAPO/BASIC_VALUE_PIECES
151	BVALUE_EN	Base Value for Order Item	decimal	12	3	DEC	((0))	Yes		/SAPAPO/BASIC_VALUE_ENTRIES
152	BVALUE_PP	Base Value for Demand/Item	decimal	12	3	DEC	((0))	Yes		/SAPAPO/BASIC_VALUE_PIECES_PER
153	MAD_PC	MAD for Demand	decimal	12	2	DEC	((0))	Yes		/SAPAPO/MAD_PC
154	MAD_EN	MAD for Order Item	decimal	12	2	DEC	((0))	Yes		/SAPAPO/MAD_EN
155	MAD_PP	MAD for Demand/Item	decimal	12	2	DEC	((0))	Yes		/SAPAPO/MAD_PP
156	PHASEIN_PRF_TYPE	Type of Phase-In Profile	char	1	0	CHAR	(N' ')	Yes		/SAPAPO/PHIN_TYPE	Allow NULL?
157	PHASEIN_ACT_TYPE	Activity Type for Phase-In	char	1	0	CHAR	(N' ')	Yes		/SAPAPO/PHASIN_ACT_TYP	Allow NULL?
158	PHASEIN_GRP	Phase-In Group	nvarchar	10	0	CHAR	(N' ')	Yes		/SAPAPO/PHINGRP	Allow NULL?
159	MAXDEV_APPROVAL	Approval: Maximum Deviation	decimal	5	2	DEC	((0))	Yes		/SAPAPO/MAXDEV_APPROVAL
160	NOT_USE_DISAG	Do Not Use Disaggregated Forecast	char	1	0	CHAR	(N' ')	Yes		/SAPAPO/NOT_USE_DISAG	Allow NULL?
161	MODEL_CHANGE_DAT	Forecast Model: Dae Changed	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPAPO/MODEL_CHANGE_DATE	Allow NULL?
162	FREEZE_LIMIT_UP	Upper Limit for Restricted Forecast Change	decimal	12	3	DEC	((0))	Yes		/SAPAPO/FREEZE_LIMIT_UP
163	FREEZE_LIMIT_DOW	Lower Limit for Restricted Forecast Change	decimal	12	3	DEC	((0))	Yes		/SAPAPO/FREEZE_LIMIT_DOW
164	FREEZE_IN_DATE	Start Date for Restricted Forecast Change	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPAPO/FREEZE_IN_DATE	Allow NULL?
165	FREEZE_OUT_DATE	End Date for Restricted Forecast Change	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPAPO/FREEZE_OUT_DATE	Allow NULL?
166	FREEZE_TYPE	Type of Restricted Forecast Change	char	1	0	CHAR	(N' ')	Yes		/SAPAPO/FREEZE_TYPE	Allow NULL?
167	PHASEOUT_GRP	Phase-Out Group	nvarchar	10	0	CHAR	(N' ')	Yes		/SAPAPO/PHOUTGRP	Allow NULL?
168	FCST_FROM_DATE	Field of type DATS	nvarchar	8	0	DATS	(N'00000000')	Yes		DATS	Allow NULL?
169	DGR_FCSTLIMIT	Forecast Delimiter Switch in DDF Model	char	1	0	CHAR	(N' ')	Yes		/SAPAPO/DGR_FCSTLIMIT	Allow NULL?
170	LI_KEYF_GROUP	Key Figure Group for Leading Indicator	nvarchar	10	0	CHAR	(N' ')	Yes		/SAPAPO/LI_KEYF_GROUP	Allow NULL?
171	LI_KEYF	Leading Indicator Key Figure	nvarchar	30	0	CHAR	(N' ')	Yes		/SAPAPO/LI_KEYF	Allow NULL?
172	LI_VALUES	Leading Indicator Values	char	1	0	CHAR	(N' ')	Yes		/SAPAPO/LI_VALUES	Allow NULL?
173	COEFF_VALUES	Values of Coefficient	char	1	0	CHAR	(N' ')	Yes		/SAPAPO/COEFF_VALUES	Allow NULL?
174	COEFF_CONST_VAL	Constant Value of Coefficient	decimal	10	2	DEC	((0))	Yes		/SAPAPO/COEFF_CONST_VAL
175	FFDP_ID	Profile ID for Final Forecast Determination	nvarchar	10	0	CHAR	(N' ')	Yes		/SAPAPO/FFDPID	Allow NULL?
176	MODSEL_PRF_ID	Profile ID for Automatic Model Selection	nvarchar	10	0	CHAR	(N' ')	Yes		/SAPAPO/MODSEL_PRF_ID	Allow NULL?

TOP ERP 6.0 | /SAPAPO/PRF_EXT INDEXES

Name	Primary	Unique	Type	Columns
/SAPAPO/PRF_EXT~0	Yes	Yes	CLUSTERED	PRF_EXTENSION, MANDT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

176 COLUMNS | 1 INDEXES | ERP 6.0 | /SAPAPO/PRF_EXT TABLE

TOP ERP 6.0 | /SAPAPO/PRF_EXT COLUMNS

TOP ERP 6.0 | /SAPAPO/PRF_EXT INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

176 COLUMNS | 1 INDEXES | ERP 6.0 | /SAPAPO/PRF_EXT TABLE

TOPERP 6.0 | /SAPAPO/PRF_EXT COLUMNS

TOPERP 6.0 | /SAPAPO/PRF_EXT INDEXES

TOP ERP 6.0 | /SAPAPO/PRF_EXT COLUMNS

TOP ERP 6.0 | /SAPAPO/PRF_EXT INDEXES