SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema: Module: Table: Column: Search^beta

SAP TABLESv1

JDETables.com - the webs number one JD Edwards Table Definition reference

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

19 COLUMNS | 3 INDEXES | ERP 6.0 | S219E TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Logistics - General :: Merchandise and Assortment Planning
1	ERP EHP7	6.0	S219E	19	3	S219 - Strukturinformationen	Merchandise and Assortment Planning

TOP ERP 6.0 | S219E COLUMNS

	Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
	1	MANDT	Mandant	nvarchar	3	0	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
	2	SSOUR	Statistiekherkomst	nvarchar	4	0	CHAR	(N' ')	No		SSOUR	Allow NULL?
	3	HIER_ID	Hiërarchie-ID	nvarchar	2	0	CHAR	(N' ')	No		HIER_CNT	Allow NULL?
	4	CDT1	Categorie	nvarchar	18	0	CHAR	(N' ')	No	CMMD_CDT1	CM_CDT1	Allow NULL?
	5	CDT2	Subcategorie	nvarchar	18	0	CHAR	(N' ')	No	CMMD_CDT2	CM_CDT2	Allow NULL?
	6	CDT3	Segment	nvarchar	18	0	CHAR	(N' ')	No	CMMD_CDT3	CM_CDT3	Allow NULL?
	7	CDT4	Subsegment	nvarchar	18	0	CHAR	(N' ')	No	CMMD_CDT4	CM_CDT4	Allow NULL?
	8	MATNR	Artikelnummer	nvarchar	18	0	CHAR	(N' ')	No	MARA	MATNR	Allow NULL?
	9	CM_LAND1	Landcode	nvarchar	3	0	CHAR	(N' ')	No	T005	LAND1	Allow NULL?
	10	REGIO	Regio (staat, deelstaat, provincie, county)	nvarchar	3	0	CHAR	(N' ')	No	T005S	REGIO	Allow NULL?
	11	PSWAE	Geheugenvaluta van plangegevens van een planningsscenario	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WISP_PSWAE	Allow NULL?
	12	BASME	Basishoeveelheidseenheid	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
	13	UPSWAE	Omrekenfactor hoeveelheden	float	15	16	FLTP	((0))	Yes		UMREFF
	14	UBASME	Omrekenfactor hoeveelheden	float	15	16	FLTP	((0))	Yes		UMREFF
	15	PLOBJ	Planningsobject	nvarchar	18	0	CHAR	(N' ')	Yes		PLOBJ	Allow NULL?
	16	PERKZ	Periodeteken	char	1	0	CHAR	(N' ')	Yes		PERVR	Allow NULL?
	17	PERIV	Boekjaarvariant	nvarchar	2	0	CHAR	(N' ')	Yes	T009	PERIV	Allow NULL?
	18	PLTKZ	Teken: element neemt aan de planning deel	char	1	0	CHAR	(N' ')	Yes		PLTKZ	Allow NULL?
	19	ANTEI	Proportionele factor (%) voor disaggregatie productgroep	float	15	16	FLTP	((0))	Yes		DANTEF

TOP ERP 6.0 | S219E INDEXES

Name	Primary	Unique	Type	Columns
S219E~0	Yes	Yes	CLUSTERED	REGIO, CM_LAND1, MATNR, CDT4, CDT3, CDT2, CDT1, HIER_ID, SSOUR, MANDT
S219E~1	No	Yes	NONCLUSTERED	PLOBJ, MANDT
S219E~VAB	No	No	NONCLUSTERED	MATNR, MANDT