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	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

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	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

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	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	CLIENT	Client	nvarchar	3	0	CLNT	(N'000')	No	*	EC_CLIENT	Allow NULL?
2	GUID	Globally Unique identifier	varbinary	16	0	RAW		No		BBP_GUID
3	SET_GUID	Set GUID	varbinary	16	0	RAW		Yes		BBP_SETGUID
4	DISTR_PERC	Distribution Percentage in the Case of Multiple Acct Assgt	decimal	5	2	DEC	((0))	Yes		BBP_VPROZ
5	ACC_NO	Sequential Account Assignment No. in EBP Purchase Document	nvarchar	4	0	NUMC	(N'0000')	Yes		BBP_ACC_NO	Allow NULL?
6	ACC_CAT	Account Assignment Category in SRM	nvarchar	5	0	CHAR	(N' ')	Yes	BBP_C_ACC	BBP_ACC_CAT	Allow NULL?
7	DEL_IND	Deletion Indicator SRM Purchasing Document	char	1	0	CHAR	(N' ')	Yes		BBP_DEL_IND	Allow NULL?
8	SRC_GUID	Account Assignment Reference GUID	varbinary	16	0	RAW		Yes		BBP_REF_A_GUID
9	G_L_ACCT	G/L Account Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	SAKNR	Allow NULL?
10	GL_ACC_ORIGIN	Original Account (determination/manual entry)	char	1	0	CHAR	(N' ')	Yes		BBP_GLACC_ORIGIN	Allow NULL?
11	BUS_AREA	Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	*	GSBER	Allow NULL?
12	COST_CTR	Cost Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	KOSTL	Allow NULL?
13	SD_DOC	Sales and Distribution Document Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	BBP_VBELN	Allow NULL?
14	SDOC_ITEM	Sales Document Item	nvarchar	6	0	NUMC	(N'000000')	Yes	*	BBP_POSNR_VA	Allow NULL?
15	SCHED_LINE	Schedule Line Number	nvarchar	4	0	NUMC	(N'0000')	Yes	*	BBP_ETENR	Allow NULL?
16	ASSET_NO	Main Asset Number	nvarchar	12	0	CHAR	(N' ')	Yes	*	ANLN1	Allow NULL?
17	SUB_NUMBER	Asset Subnumber	nvarchar	4	0	CHAR	(N' ')	Yes	*	ANLN2	Allow NULL?
18	ORDER_NO	Order Number	nvarchar	12	0	CHAR	(N' ')	Yes	*	AUFNR	Allow NULL?
19	CO_AREA	Controlling Area	nvarchar	4	0	CHAR	(N' ')	Yes	*	KOKRS	Allow NULL?
20	PROF_SEGM	Profitability Segment Number (CO-PA)	nvarchar	10	0	NUMC	(N'0000000000')	Yes		BBP_RKEOBJNR	Allow NULL?
21	PROFIT_CTR	Profit Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	PRCTR	Allow NULL?
22	WBS_ELEM_E	Work Breakdown Structure Element (WBS element)	nvarchar	24	0	CHAR	(N' ')	Yes		BBP_WBS_ELEM	Allow NULL?
23	NETWORK	Network Number for Account Assignment	nvarchar	12	0	CHAR	(N' ')	Yes	*	NPLNR	Allow NULL?
24	ACTIVITY	Operation/Activity Number	nvarchar	4	0	CHAR	(N' ')	Yes		VORNR	Allow NULL?
25	ROUTING_NO	Plan number for operations in the order	nvarchar	10	0	NUMC	(N'0000000000')	Yes		BBP_CO_AUFPL	Allow NULL?
26	RL_EST_KEY	Internal Key for Real Estate Object	nvarchar	8	0	CHAR	(N' ')	Yes		IMKEY	Allow NULL?
27	COUNTER	Internal counter	nvarchar	8	0	NUMC	(N'00000000')	Yes		CIM_COUNT	Allow NULL?
28	REC_IND	Recovery Indicator	nvarchar	2	0	CHAR	(N' ')	Yes	*	JV_RECIND	Allow NULL?
29	PART_ACCT	Partner account number	nvarchar	10	0	CHAR	(N' ')	Yes	*	JV_PART	Allow NULL?
30	CMMT_ITEM	Commitment Item	nvarchar	24	0	CHAR	(N' ')	Yes	*	FM_FIPEX	Allow NULL?
31	FUNDS_CTR	Funds Center	nvarchar	16	0	CHAR	(N' ')	Yes	*	FISTL	Allow NULL?
32	FUND	Fund	nvarchar	10	0	CHAR	(N' ')	Yes	*	BP_GEBER	Allow NULL?
33	FUNC_AREA	Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	*	FKBER	Allow NULL?
34	REF_DATE	Reference Date for Settlement	nvarchar	8	0	DATS	(N'00000000')	Yes		DABRBEZ	Allow NULL?
35	COST_OBJ	Cost Object	nvarchar	12	0	CHAR	(N' ')	Yes	*	BBP_KSTRG	Allow NULL?
36	ACC_STR	Generic Account Assignment	nvarchar	64	0	CHAR	(N' ')	Yes		BBP_ACC_GENERIC	Allow NULL?
37	ZZNFAL		nvarchar	10	0		(N' ')	Yes			Allow NULL?
38	GRANT_NBR	Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_NBR	Allow NULL?
39	DIST_QUAN	Quantity in Order Unit	decimal	13	3	QUAN	((0))	Yes		BBP_MNG
40	DIST_VALUE	Net Value	decimal	15	2	CURR	((0))	Yes		BBP_VALUE
41	DIST_IND	Distribution Indicator	char	1	0	CHAR	(N' ')	Yes		BBP_DIST_IND	Allow NULL?
42	COPY_OF_GUID	GUID Object is a Copy of	varbinary	16	0	RAW		Yes		BBP_COPY_OF_GUID
43	FUNDS_RES	Document number for earmarked funds	nvarchar	10	0	CHAR	(N' ')	Yes	*	BBP_KBLNR	Allow NULL?
44	RES_ITEM	Earmarked Funds: Document Item	nvarchar	3	0	NUMC	(N'000')	Yes	*	KBLPOS	Allow NULL?
45	DUMMY_EEW_PDASF	Dummy function in length 1	char	1	0	CHAR	(N' ')	Yes		DUMMY	Allow NULL?
46	PS_ACC_EXLIN	Configurable Line Item Number	nvarchar	40	0	CHAR	(N' ')	Yes		/SAPSRM/EXLIN	Allow NULL?
47	PS_SPLIT_BATCH	Batch to group results from an PSM assignment distribution	nvarchar	3	0	NUMC	(N'000')	Yes		/SAPPSSRM/FMSP_SPLIT_BATCH	Allow NULL?
48	TP_SUBLEVL	Sub Level Prefix (SP)	nvarchar	2	0	CHAR	(N' ')	Yes		/SAPPSSRM/_GTAS_TP_SUBLEVEL	Allow NULL?
49	TP_AGENCID	Agency ID (AID)	nvarchar	3	0	CHAR	(N' ')	Yes		/SAPPSSRM/_GTAS_TP_AGENCID	Allow NULL?
50	TP_ALTRAID	Allocation Transfer Agency ID (ATA)	nvarchar	3	0	CHAR	(N' ')	Yes		/SAPPSSRM/_GTAS_TP_ALTRAID	Allow NULL?
51	TP_BEGPER	Beginning Period of Availability (BPOA)	nvarchar	4	0	NUMC	(N'0000')	Yes		/SAPPSSRM/_GTAS_TP_BEGPER	Allow NULL?
52	TP_ENDPER	Ending Period of Availability (EPOA)	nvarchar	4	0	NUMC	(N'0000')	Yes		/SAPPSSRM/_GTAS_TP_ENDPER	Allow NULL?
53	TP_AVTYPE	Availability Type Code (ATC)	char	1	0	CHAR	(N' ')	Yes		/SAPPSSRM/_GTAS_TP_AVTYPE	Allow NULL?
54	TP_MAIN_ACCT	Main Account Code (MAIN)	nvarchar	4	0	CHAR	(N' ')	Yes		/SAPPSSRM/_GTAS_TP_MAIN_ACCT	Allow NULL?
55	TP_SUB_ACCT	Sub Account Code (SUB)	nvarchar	3	0	CHAR	(N' ')	Yes		/SAPPSSRM/_GTAS_TP_SUB_ACCT	Allow NULL?
56	TP_BETC	BETC	nvarchar	10	0	CHAR	(N' ')	Yes		/SAPPSSRM/_GTAS_TP_BETC	Allow NULL?
57	PS_UNFUNDED	Unfunded Accounting Line	char	1	0	CHAR	(N' ')	Yes		/SAPPSSRM/_UNFUNDED	Allow NULL?
58	PS_ATH_NOT_REL	Threshold not Relevant	char	1	0	CHAR	(N' ')	Yes		/SAPPSSRM/_TH_NOT_RELEVANT	Allow NULL?
59	PS_ATH_TYPE	Threshold Type	nvarchar	10	0	CHAR	(N' ')	Yes	*	/SAPPSSRM/_TH_TYPE	Allow NULL?
60	PS_ATH_NUMBER	Threshold Number	nvarchar	10	0	NUMC	(N'0000000000')	Yes		/SAPPSSRM/_TH_NUM	Allow NULL?
61	PS_ATH_AVAIL_AMT	Remaining Threshold Amount	decimal	20	2	CURR	((0))	Yes		/SAPPSSRM/_TH_RM_AMNT
62	PS_ATH_CURRENCY	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	*	WAERS	Allow NULL?
63	DUMMY_EEW_PDACF	Dummy function in length 1	char	1	0	CHAR	(N' ')	Yes		DUMMY	Allow NULL?
64	BUDGET_PERIOD	FM: Budget Period	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_BUDGET_PERIOD	Allow NULL?

Name	Primary	Unique	Type	Columns
BBP_PDACC~0	Yes	Yes	CLUSTERED	GUID, CLIENT
BBP_PDACC~A	No	No	NONCLUSTERED	ASSET_NO, CLIENT
BBP_PDACC~C	No	No	NONCLUSTERED	COST_CTR, CLIENT
BBP_PDACC~N	No	No	NONCLUSTERED	NETWORK, CLIENT
BBP_PDACC~O	No	No	NONCLUSTERED	ORDER_NO, CLIENT
BBP_PDACC~SET	No	No	NONCLUSTERED	SET_GUID, CLIENT
BBP_PDACC~W	No	No	NONCLUSTERED	WBS_ELEM_E, CLIENT

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

64 COLUMNS | 7 INDEXES | ERP 6.0 | BBP_PDACC TABLE

TOP ERP 6.0 | BBP_PDACC COLUMNS

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

64 COLUMNS | 7 INDEXES | ERP 6.0 | BBP_PDACC TABLE

TOPERP 6.0 | BBP_PDACC COLUMNS

TOPERP 6.0 | BBP_PDACC INDEXES

TOP ERP 6.0 | BBP_PDACC COLUMNS

TOP ERP 6.0 | BBP_PDACC INDEXES