	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	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
10	FMARCPAR	4	Parallelization of FMARC_BATCH

	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

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

MATSPPLN TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: Defense Forces and Public Security :: Organizational Flexibility :: Structures Workbench
1	ERP EHP7	6.0	/ISDFPS/MATSPPLN	73	11	Materials Planned for Force Element	Structures Workbench

SQL: selectupdate insert create

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

SELECT CLIENT, PLANNING_GUID, RECTYPE, FORCE_REC_ID, FORCE_REC_CNT, PLANT_REC, STORAGE_LOC_REC, HU_LOC_REC, FORCE_PROV_ID, FORCE_PROV_CNT, PLANT_PROV, STORAGE_LOC_PROV, HU_LOC_PROV, MATNR, SERNR, BATCH, PSPNR, HU_EXID, VEPOS, PACK_MAT, QUPLN, DELIVERY_DATE, RSNUM, COMNT, REF_GUID, REF_TYPE, REF_GUID2, REF_TYPE2, PREQ_NO, PREQ_ITEM, FLAG_LOAN, RETURN_DATE, FLAG_LOAN_RET, RECORD_INVISIBLE, RELOC_ID, RELOC_SEQ_ID, PNGUID, FORCEM_CNT, DGUID, FLAG_EV, FORCE_ASGN_ID, FORCE_ASGN_CNT, MEINS, MBDAT, DAT_SP, BSART, LFART, ROUTE, APPLOBJ_TYPE, FBSTA, PNAME, FLAG_PROV, LOCATION_S_GUID, LOCATION_D_GUID, CREATED_ON, CREATED_BY, CHANGED_ON, CHANGED_BY, FLAG_HISTORY, FLAG_MAINTENANCE, VBELN, FLAG_COMPLETED, FLAG_FORWARDED, FLAG_DERIVED, VSBED, FLAG_WB, FLAG_SUBITEM, FLAG_RETURN, RSPOS, FLAG_RES_FWD, SERNR_PREQ, FLAG_SERNR_PREQ, RELSEQ_TYPE FROM /ISDFPS/MATSPPLN

TOP ERP 6.0 | /ISDFPS/MATSPPLN COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	CLIENT	Client	nvarchar	3	0	Allow NULL?
2	PLANNING_GUID	Planning GUID	nvarchar	32	0	Allow NULL?
3	RECTYPE	Record Type Planning	nvarchar	3	0	Allow NULL?
4	FORCE_REC_ID	Internal Key for Force Element	nvarchar	32	0	Allow NULL?
5	FORCE_REC_CNT	Internal (Version) Counter	nvarchar	6	0	Allow NULL?
6	PLANT_REC	Plant	nvarchar	4	0	Allow NULL?
7	STORAGE_LOC_REC	Storage Location	nvarchar	4	0	Allow NULL?
8	HU_LOC_REC	HU Storage Location	nvarchar	4	0	Allow NULL?
9	FORCE_PROV_ID	Internal Key for Force Element	nvarchar	32	0	Allow NULL?
10	FORCE_PROV_CNT	Internal (Version) Counter	nvarchar	6	0	Allow NULL?
11	PLANT_PROV	Plant	nvarchar	4	0	Allow NULL?
12	STORAGE_LOC_PROV	Storage Location	nvarchar	4	0	Allow NULL?
13	HU_LOC_PROV	HU Storage Location	nvarchar	4	0	Allow NULL?
14	MATNR	Material Number	nvarchar	18	0	Allow NULL?
15	SERNR	Serial Number	nvarchar	18	0	Allow NULL?
16	BATCH	Batch Number	nvarchar	10	0	Allow NULL?
17	PSPNR	WBS Element	nvarchar	8	0	Allow NULL?
18	HU_EXID	External Handling Unit Identification	nvarchar	20	0	Allow NULL?
19	VEPOS	Handling Unit Item	nvarchar	6	0	Allow NULL?
20	PACK_MAT	Packaging Materials	nvarchar	18	0	Allow NULL?
21	QUPLN	Planned Quantity	decimal	13	3
22	DELIVERY_DATE	Delivery Date	nvarchar	8	0	Allow NULL?
23	RSNUM	Number of Reservation/Dependent Requirement	nvarchar	10	0	Allow NULL?
24	COMNT	Planning Comment	nvarchar	40	0	Allow NULL?
25	REF_GUID	Planning GUID	nvarchar	32	0	Allow NULL?
26	REF_TYPE	Type of Reference Relationship	nvarchar	2	0	Allow NULL?
27	REF_GUID2	Planning GUID	nvarchar	32	0	Allow NULL?
28	REF_TYPE2	Type of Reference Relationship	nvarchar	2	0	Allow NULL?
29	PREQ_NO	Purchase Requisition Number	nvarchar	10	0	Allow NULL?
30	PREQ_ITEM	Item Number of Purchase Requisition	nvarchar	5	0	Allow NULL?
31	FLAG_LOAN	Loan	char	1	0	Allow NULL?
32	RETURN_DATE	Return Date for Loan	nvarchar	8	0	Allow NULL?
33	FLAG_LOAN_RET	Loan Return	char	1	0	Allow NULL?
34	RECORD_INVISIBLE	Single-Character Indicator	char	1	0	Allow NULL?
35	RELOC_ID	Relocation ID	nvarchar	10	0	Allow NULL?
36	RELOC_SEQ_ID	Relocation Step ID	nvarchar	4	0	Allow NULL?
37	PNGUID	Internal Identification for PVS Objects	varbinary	16	0
38	FORCEM_CNT	Internal (Version) Counter	nvarchar	6	0	Allow NULL?
39	DGUID	Distribution Assignment ID	nvarchar	32	0	Allow NULL?
40	FLAG_EV	Relocation: Initial Supply	char	1	0	Allow NULL?
41	FORCE_ASGN_ID	Internal Key for Force Element	nvarchar	32	0	Allow NULL?
42	FORCE_ASGN_CNT	Internal (Version) Counter	nvarchar	6	0	Allow NULL?
43	MEINS	Base Unit of Measure	nvarchar	3	0	Allow NULL?
44	MBDAT	Material Staging/Availability Date	nvarchar	8	0	Allow NULL?
45	DAT_SP	Collectn Pt Date	nvarchar	8	0	Allow NULL?
46	BSART	Order Type (Purchasing)	nvarchar	4	0	Allow NULL?
47	LFART	Delivery Type	nvarchar	4	0	Allow NULL?
48	ROUTE	Route	nvarchar	6	0	Allow NULL?
49	APPLOBJ_TYPE	Application Object Type for iPPE	nvarchar	4	0	Allow NULL?
50	FBSTA	Relocation: Follow-On Document Status	char	1	0	Allow NULL?
51	PNAME	iPPE Node Description	nvarchar	40	0	Allow NULL?
52	FLAG_PROV	Provisions	char	1	0	Allow NULL?
53	LOCATION_S_GUID	ISDFPS: Location ID (GUID)	nvarchar	32	0	Allow NULL?
54	LOCATION_D_GUID	ISDFPS: Location ID (GUID)	nvarchar	32	0	Allow NULL?
55	CREATED_ON	Date record created on	nvarchar	8	0	Allow NULL?
56	CREATED_BY	User who created record	nvarchar	12	0	Allow NULL?
57	CHANGED_ON	Changed On	nvarchar	8	0	Allow NULL?
58	CHANGED_BY	Name of Person Who Changed Object	nvarchar	12	0	Allow NULL?
59	FLAG_HISTORY	Record Is Historical	char	1	0	Allow NULL?
60	FLAG_MAINTENANCE	Change of Ownership	char	1	0	Allow NULL?
61	VBELN	Delivery	nvarchar	10	0	Allow NULL?
62	FLAG_COMPLETED	Completely Processed	char	1	0	Allow NULL?
63	FLAG_FORWARDED	Purchase Requisition Forwarded	char	1	0	Allow NULL?
64	FLAG_DERIVED	PReq Is Derived (Forwarding)	char	1	0	Allow NULL?
65	VSBED	Shipping Conditions	nvarchar	2	0	Allow NULL?
66	FLAG_WB	Planned Record Created in Workbench	char	1	0	Allow NULL?
67	FLAG_SUBITEM	Subitem	char	1	0	Allow NULL?
68	FLAG_RETURN	Return Delivery	char	1	0	Allow NULL?
69	RSPOS	Item Number of Reservation/Dependent Requirement	nvarchar	4	0	Allow NULL?
70	FLAG_RES_FWD	Forwarded Reservation	char	1	0	Allow NULL?
71	SERNR_PREQ	Serial Number	nvarchar	18	0	Allow NULL?
72	FLAG_SERNR_PREQ	Serial Number PReq	char	1	0	Allow NULL?
73	RELSEQ_TYPE	Relocation Step Type	char	1	0	Allow NULL?

TOP ERP 6.0 | /ISDFPS/MATSPPLN INDEXES

Name	Primary	Unique	Type	Columns
/ISDFPS/MATSPPLNDV	No	No	NONCLUSTERED	VBELN, CLIENT
/ISDFPS/MATSPPLNFI	No	No	NONCLUSTERED	STORAGE_LOC_REC, PLANT_REC, CLIENT
/ISDFPS/MATSPPLNFO	No	No	NONCLUSTERED	FORCE_REC_CNT, FORCE_REC_ID, CLIENT
/ISDFPS/MATSPPLNHI	No	No	NONCLUSTERED	FLAG_HISTORY, CLIENT
/ISDFPS/MATSPPLNMA	No	No	NONCLUSTERED	MATNR, CLIENT
/ISDFPS/MATSPPLNPI	No	No	NONCLUSTERED	STORAGE_LOC_PROV, PLANT_PROV, CLIENT
/ISDFPS/MATSPPLNPR	No	No	NONCLUSTERED	PREQ_NO, CLIENT
/ISDFPS/MATSPPLNRE	No	No	NONCLUSTERED	REF_GUID2, CLIENT
/ISDFPS/MATSPPLNRG	No	No	NONCLUSTERED	REF_GUID, CLIENT
/ISDFPS/MATSPPLNRS	No	No	NONCLUSTERED	RSNUM, CLIENT
/ISDFPS/MATSPPLN~0	Yes	Yes	CLUSTERED	PLANNING_GUID, 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

73 COLUMNS | 11 INDEXES | ERP 6.0 | /ISDFPS/MATSPPLN TABLE

TOP ERP 6.0 | /ISDFPS/MATSPPLN COLUMNS

TOP ERP 6.0 | /ISDFPS/MATSPPLN 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

73 COLUMNS | 11 INDEXES | ERP 6.0 | /ISDFPS/MATSPPLN TABLE

TOPERP 6.0 | /ISDFPS/MATSPPLN COLUMNS

TOPERP 6.0 | /ISDFPS/MATSPPLN INDEXES

TOP ERP 6.0 | /ISDFPS/MATSPPLN COLUMNS

TOP ERP 6.0 | /ISDFPS/MATSPPLN INDEXES