ERP 6.0: Top 10 requests

	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	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

	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	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

	Product	Version	Table	Columns	Indexes	Description	Module
Cross-Application Components
1	ERP EHP7	6.0	FRE_SEND_OPTION	102	1	Maintain Basic Settings for Data Transfer	Cross-Application Components

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	FRE_ACTIVE	F&R is active and Connection exists	char	1	Allow NULL?
3	FRE_RELEASE	Release of connected F&R System	nvarchar	2	Allow NULL?
4	FRE_RFC	Send Data to F&R by Asynchronous RFC	char	1	Allow NULL?
5	SEND_ONCE	Transmission to F&R once a day	char	1	Allow NULL?
6	SEND_INTVL	Transmission to F&R several times a day (Interval)	char	1	Allow NULL?
7	SEND_INB_DIR	Transmission of Inbound Changes Immediately	char	1	Allow NULL?
8	SEND_DEST	Logical Destination (Specified in Function Call)	nvarchar	32	Allow NULL?
9	NUM_O_REC	Number of Records per Package	decimal	9
10	FILESYST	Syntax group for file and path names	nvarchar	10	Allow NULL?
11	LOGICAL_PATH_OUT	Logical path name	nvarchar	60	Allow NULL?
12	LOGICAL_PATH_TS	Logical path name	nvarchar	60	Allow NULL?
13	LOGICAL_PATH_MD	Logical path name	nvarchar	60	Allow NULL?
14	SAVE_FILES	No. of Days to store Files	decimal	3
15	SERVERGROUP	Logon/Server Group Name	nvarchar	20	Allow NULL?
16	MAX_PARA_JOBS	Maximum number of parallel tasks	int	10	Allow NULL?
17	TS_PER_INIT	Number of Periods for Consumption initial load	nvarchar	3	Allow NULL?
18	TS_PER_NORM	Number of Periods for Consumption Normal Load	nvarchar	3	Allow NULL?
19	WERKS_FILTER	High level filtering over customized sites	char	1	Allow NULL?
20	DB_SELECT_PKG	Number of Records per Package	decimal	9
21	LG_PKG_SIZE	Number of Records per Package	decimal	9
22	WAIT_SECONDS	Time Interval (Seconds) to Wait	nvarchar	2	Allow NULL?
23	CPOCAL_DC	Central order calendar for DCs	nvarchar	2	Allow NULL?
24	CPOCAL_STORE	Central order calendar for stores	nvarchar	2	Allow NULL?
25	PAST_LISTING	number of days with listing information in the past	nvarchar	4	Allow NULL?
26	DIF_ACT	Transfer Demand Influencing Factors to F&R	char	1	Allow NULL?
27	MCH_ACT	Transfer Merchandize Categ. Hierarchies to F&R	char	1	Allow NULL?
28	ARH_ACT	Transfer Article Hierarchies to F&R	char	1	Allow NULL?
29	SGT_ACT	Transfer Site Grouping Data to F&R	char	1	Allow NULL?
30	PROCYC_ACT	Transfer procurement cycles to F&R	char	1	Allow NULL?
31	RPR_ACT	Activate Transmission of Rounding Profiles to F&R	char	1	Allow NULL?
32	UOM_ACT	Activate Transmission of Unit of Measure Groups to F&R	char	1	Allow NULL?
33	PRM_ACT	Transfer Processing Methods to F&R	char	1	Allow NULL?
34	CONT_ACT	Transfer Contract Data to F&R	char	1	Allow NULL?
35	EKORG_ACT	Activate Transmission of Pur. Org. & Assignment to F&R	char	1	Allow NULL?
36	ADD_ATTEMPTS	Additional accessing attempts	nvarchar	2	Allow NULL?
37	WAIT_TIME	Waiting time before next attempt	nvarchar	3	Allow NULL?
38	DIF_NUM_REC	Number of Records per Package	decimal	9
39	DIF_FILTER	Filter type for DIF occurrence (when saving promotions)	char	1	Allow NULL?
40	DIF_PAST_PERIODS	Period in weeks that must be taken into account	nvarchar	3	Allow NULL?
41	REF_PSIZE_HEAD	Package Size for reference module assignment	decimal	9
42	REF_PSIZE_MODULE	Package Size for reference modules	decimal	9
43	SEND_RELPRO	Send release profiles and assigments to SAP F&R	char	1	Allow NULL?
44	INIT_DC	Initial data transfer for distribution centers	char	1	Allow NULL?
45	DELTA_DC	Delta data transfer for distribution centers	char	1	Allow NULL?
46	INIT_ST	Initial data transfer for stores	char	1	Allow NULL?
47	DELTA_ST	Delta data transfer for stores	char	1	Allow NULL?
48	MESS_CTRL	Message control for data transfer	char	1	Allow NULL?
49	DOCSYNC_STATUS	Document Synchronisation active -deactive	char	1	Allow NULL?
50	SEND_LAYMOD	Send layout modules to SAP F&R	char	1	Allow NULL?
51	SEND_STRUCT_ART	Send structured articles to SAP F&R	nvarchar	2	Allow NULL?
52	NO_UNAMB_CHECK	do not check for unique numbers	char	1	Allow NULL?
53	SUPPORT_LEVEL	Support Level - SAP Internal	nvarchar	2	Allow NULL?
54	FILE_OUT	Save Order Proposal Outbound Data in File	char	1	Allow NULL?
55	FILE_IN	Save Order Proposal Inbound Data in File	char	1	Allow NULL?
56	FILE_MD1	Save MD Location Data in File	char	1	Allow NULL?
57	FILE_MD2	Save MD Location Product Data in File	char	1	Allow NULL?
58	FILE_MD3	Save MD Supply Network Data in File	char	1	Allow NULL?
59	FILE_MD4	Save MD Merchandise Category Data in File	char	1	Allow NULL?
60	FILE_MD5	Save MD Location Group Data in File	char	1	Allow NULL?
61	FILE_MD6	Save MD DIF Occurrence Data in File	char	1	Allow NULL?
62	FILE_MD7	Save MD Article Hierarchy Data in File	char	1	Allow NULL?
63	FILE_MD8	Save MD Procurement Cycle Data in File	char	1	Allow NULL?
64	FILE_MD9	Save MD Release Profile Data in File	char	1	Allow NULL?
65	FILE_MDL	Save MD Layout Module Data in File	char	1	Allow NULL?
66	FILE_CO	create recovery files for transmitted contracts	char	1	Allow NULL?
67	FILE_SU1	Save Substitution Assignment Information in File	char	1	Allow NULL?
68	FILE_SU2	Save Substitution Switchover Information to File	char	1	Allow NULL?
69	FILE_TS	Save Time Series Data to File	char	1	Allow NULL?
70	FILE_EKORG	Save P.Org. Assignment in File	char	1	Allow NULL?
71	DIF_ACT_NO_SITES	Transfer DIF Occurrences for Number of Supplied Sites to F&R	char	1	Allow NULL?
72	DIF_NUM_REC2	Number of Data Records in a Package	decimal	9
73	DIF_ID_NO_SITES	DIF identifier	nvarchar	3	Allow NULL?
74	DIF_PAST_PERIOD2	Period in Weeks for Number of Supplied Plants	nvarchar	3	Allow NULL?
75	DIF_REPL_REL	Only Count Matl-Plant Combs Relevant for F&R Matls Planning	char	1	Allow NULL?
76	DIF_DEV_PERC	Maximum Variation to Ignore (in Percent)	nvarchar	3	Allow NULL?
77	DIF_EORD_USE	Use Purchasing Source List	char	1	Allow NULL?
78	SU1_ACT	Substitution Interface Assigment Information Active	char	1	Allow NULL?
79	SU2_ACT	Substitution - Interface Switchover Information Active	char	1	Allow NULL?
80	STOCK_TD_ACT	Transfer TD Min-Max Stock Levels for Promotions to F&R	char	1	Allow NULL?
81	PROCYC_TD_ACT	Transfer TD Procurement Cycles for Promotions to F&R	char	1	Allow NULL?
82	FILE_TDL	Save Time-Dependent Min/Max Stock for Promotions to File	char	1	Allow NULL?
83	PROCYC_TD_ASSIGN	Assignment of Time-Dependent Procurement Cycles	char	1	Allow NULL?
84	SU1_PACKAGE_SIZE	Number of Records per Package	decimal	9
85	SU2_PACKAGE_SIZE	Number of Records per Package	decimal	9
86	FRE_NEW_LANES	Activate new lanes model	char	1	Allow NULL?
87	FRE_NO_PRICES	No Purchase Price Determination for Lanes	char	1	Allow NULL?
88	FRE_INFREC_PRICE	For Pricing use only Purchase Inforecord NetPrice	char	1	Allow NULL?
89	FRE_STAND_PRICE	Perform Standard Purchasing Price Determination	char	1	Allow NULL?
90	LAST_CHANGED_BY	User Name	nvarchar	12	Allow NULL?
91	LAST_CHANGED_AT	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	decimal	15
92	FRE_NEW_LP	Activate new location product	char	1	Allow NULL?
93	FRE_STOCK_ACT	Transfer Stock Data to F&R	char	1	Allow NULL?
94	FRE_CONS_ACT	Transfer Consumption Data to F&R	char	1	Allow NULL?
95	TS_PER_MERGE	Merge Overlapping Consumption Periods (Initial Load)	char	1	Allow NULL?
96	FRE_SOURCE_LIST	Transfer Source List Data as Lanes to F&R	char	1	Allow NULL?
97	PLIFZ_TD_ACT	Transfer TD Planned Delivery Time for Promotions to F&R	char	1	Allow NULL?
98	PLIFZ_TD_ASSIGN	Assignment of Time-Dependent Planned Delivery Time	char	1	Allow NULL?
99	FRE_PO_NOT_REL_R	Transmission of POs for F&R-Relevant Supplying Plants	char	1	Allow NULL?
100	SO_ACT	Transfer Sales Order to F&R	char	1	Allow NULL?
101	SO_PAST_PERIOD	Past Time Horizon for Completed Sales Orders in Days	nvarchar	3	Allow NULL?
102	FILE_SO	Create Recovery Files for Transmitted Sales Order Data	char	1	Allow NULL?

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

102 COLUMNS | 1 INDEXES | ERP 6.0 | FRE_SEND_OPTION TABLE

TOP ERP 6.0 | FRE_SEND_OPTION COLUMNS

TOP ERP 6.0 | FRE_SEND_OPTION 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

102 COLUMNS | 1 INDEXES | ERP 6.0 | FRE_SEND_OPTION TABLE

TOPERP 6.0 | FRE_SEND_OPTION COLUMNS

TOPERP 6.0 | FRE_SEND_OPTION INDEXES

TOP ERP 6.0 | FRE_SEND_OPTION COLUMNS

TOP ERP 6.0 | FRE_SEND_OPTION INDEXES