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	BSEG	345	Accounting Document Segment
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
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	OPCH	386	A/P Invoice
7	INV1	265	A/R Invoice - Rows
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	ORCT	154	Incoming Payment
2	OITM	249	Items
3	OINM	101	Whse Journal
4	OINV	268	A/R Invoice
5	OIVL	77	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

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: SAP Media :: Master Data
1	ERP EHP7	6.0	JGTSADR	112	10	IS-M: Extended Address Management	Master Data

Column	Field	Description	SQL Type	Length	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	ADRNR	IS-M: Address Number	nvarchar	10	CHAR	(N' ')	No		JADRNR	Allow NULL?
3	UVADR_ST	IS-M: Coding Status of Address	char	1	CHAR	(N' ')	Yes		UVADR_AD	Allow NULL?
4	UVADR_PF	IS-M: Coding Status of Address	char	1	CHAR	(N' ')	Yes		UVADR_AD	Allow NULL?
5	UVADR_GK	IS-M: Coding Status of Address	char	1	CHAR	(N' ')	Yes		UVADR_AD	Allow NULL?
6	HERK	IS-M: Use of Address	char	1	CHAR	(N' ')	Yes		HERK	Allow NULL?
7	XADRLOE	IS-M: Deletion Flag for Address	char	1	CHAR	(N' ')	Yes		XLOES	Allow NULL?
8	ERFUSER	Created By	nvarchar	12	CHAR	(N' ')	Yes		ERFUSER	Allow NULL?
9	ERFDATE	Created On	nvarchar	8	DATS	(N'00000000')	Yes		ERFDATE	Allow NULL?
10	ERFTIME	Time Created	nvarchar	6	TIMS	(N'000000')	Yes		ERFTIME	Allow NULL?
11	AENUSER	Last Changed By	nvarchar	12	CHAR	(N' ')	Yes		AENUSER	Allow NULL?
12	AENDATE	Date of Last Change	nvarchar	8	DATS	(N'00000000')	Yes		AENDATE	Allow NULL?
13	AENTIME	Time of Last Change	nvarchar	6	TIMS	(N'000000')	Yes		AENTIME	Allow NULL?
14	ANRED	Form of Address Key	nvarchar	2	CHAR	(N' ')	Yes	TJG43	JANRED	Allow NULL?
15	NAME1	IS-M: Business Partner Name	nvarchar	35	CHAR	(N' ')	Yes		NAME1_ISP	Allow NULL?
16	NAME2	IS-M: First Name of Business Partner	nvarchar	35	CHAR	(N' ')	Yes		NAME2_ISP	Allow NULL?
17	NAME3	IS-M: Further Name Field for Business Partner	nvarchar	35	CHAR	(N' ')	Yes		NAME3_ISP	Allow NULL?
18	NAME4	IS-M: Further Name Field for Business Partner	nvarchar	35	CHAR	(N' ')	Yes		NAME4_ISP	Allow NULL?
19	TITEL	IS-M: Title	nvarchar	15	CHAR	(N' ')	Yes	T535N	TITEL_ISP	Allow NULL?
20	NAMZU	IS-M: Name Affix	nvarchar	15	CHAR	(N' ')	Yes	T535N	NAMZU_ISP	Allow NULL?
21	VORSW	IS-M: Name Prefix	nvarchar	15	CHAR	(N' ')	Yes	T535N	VORSW_ISP	Allow NULL?
22	PSTLZ	IS-M: Postal Code	nvarchar	10	CHAR	(N' ')	Yes		PLZ_ISP	Allow NULL?
23	PSTLZ_ADDON	IS-M: Extension to 5-Character ZIP Code	nvarchar	4	CHAR	(N' ')	Yes		PSTLZ_ADDON	Allow NULL?
24	ORT01	IS-M: City	nvarchar	35	CHAR	(N' ')	Yes		ORT01_ISP	Allow NULL?
25	ORT02	IS-M: City District	nvarchar	35	CHAR	(N' ')	Yes		ORT02_ISP	Allow NULL?
26	PSTL2	IS-M: Postal Code for PO Box	nvarchar	10	CHAR	(N' ')	Yes		PLZPF	Allow NULL?
27	PSTL2_ADDON	IS-M: Extension to 5-Character ZIP Code (PO Box)	nvarchar	4	CHAR	(N' ')	Yes		PSTL2_ADDON	Allow NULL?
28	PSTL3	IS-M: Company Postal Code	nvarchar	10	CHAR	(N' ')	Yes		PSTL3	Allow NULL?
29	PSTL3_ADDON	IS-M: Extension to 5-Character ZIP Code (Company)	nvarchar	4	CHAR	(N' ')	Yes		PSTL3_ADDON	Allow NULL?
30	PFACH	IS-M: Post Office Box	nvarchar	10	CHAR	(N' ')	Yes		PFACH_ISP	Allow NULL?
31	ORTPF	IS-M: City for PO Box	nvarchar	35	CHAR	(N' ')	Yes		ORTPF	Allow NULL?
32	STRAS	Street Name	nvarchar	35	CHAR	(N' ')	Yes		STRAS_ISP	Allow NULL?
33	HAUSN	IS-M: House Number	nvarchar	10	CHAR	(N' ')	Yes		HSNMR1	Allow NULL?
34	HSNMR2	IS-M: House Number Affix	nvarchar	8	CHAR	(N' ')	Yes		HSNMR2	Allow NULL?
35	ADRZUS2	Classification Using a Further Address Affix	nvarchar	6	CHAR	(N' ')	Yes		ADRZUS2	Allow NULL?
36	STOCK	Floor	nvarchar	6	CHAR	(N' ')	Yes		STOCK	Allow NULL?
37	LAND1	Country Key	nvarchar	3	CHAR	(N' ')	Yes	T005	LAND1	Allow NULL?
38	PREDIRECTIONAL	Directional for Street Name	nvarchar	10	CHAR	(N' ')	No	TJS41	DIRECTIONAL	Allow NULL?
39	POSTDIRECTIONAL	Directional for Street Name	nvarchar	10	CHAR	(N' ')	No	TJS41	DIRECTIONAL	Allow NULL?
40	ADDRSECABBREV	IS-M: Secondary Address Text	nvarchar	4	CHAR	(N' ')	No	TJS43	ADDRSECABBREV	Allow NULL?
41	ADDRSECNUMBER	IS-M: Secondary Address Number	nvarchar	8	CHAR	(N' ')	No		ADDRSECNUMBER	Allow NULL?
42	STREET2	IS-M: Second street line	nvarchar	35	CHAR	(N' ')	No		STREET2_ISM	Allow NULL?
43	ALIASNAME	IS-M: Alias Text (Street Name + Suffix)	nvarchar	50	CHAR	(N' ')	No		ALIASNAME	Allow NULL?
44	ALIASPREDIRECTN	Directional for Street Name	nvarchar	10	CHAR	(N' ')	No	*	DIRECTIONAL	Allow NULL?
45	ALIASPOSTDIRECTN	Directional for Street Name	nvarchar	10	CHAR	(N' ')	No	*	DIRECTIONAL	Allow NULL?
46	ALIASDELADDRLOW	IS-M: Primary House Number (Lower Limit)	nvarchar	10	CHAR	(N' ')	No		ADDRPRIMLOW	Allow NULL?
47	ALIASDELADDRHIGH	IS-M: Primary House Number (Upper Limit)	nvarchar	10	CHAR	(N' ')	No		ADDRPRIMHIGH	Allow NULL?
48	ALIASDELODDEVEN	IS-M: Indicator - Even/Odd/All	char	1	CHAR	(N' ')	No		ODDEVENCODE	Allow NULL?
49	SUCHFELDALIAS	Search field for accessing postal structures w/o matchcode	nvarchar	40	CHAR	(N' ')	No		SUCHFELD	Allow NULL?
50	POSTEINORT	IS-M: City Number (Unique)	nvarchar	8	CHAR	(N' ')	Yes	JSTORTPRO	JALORT	Allow NULL?
51	ERSTADR	IS-M: Address Proposal for Alternatives	char	1	CHAR	(N' ')	Yes		ERSTADR	Allow NULL?
52	POSTEINSTR	IS-M: Street Number	nvarchar	10	CHAR	(N' ')	Yes	JSTSTRPRO	STRASSENNR	Allow NULL?
53	PEINORTPF	IS-M: Postal Unit of City for PO Box	nvarchar	8	CHAR	(N' ')	Yes	JSTORTPRO	ALORT2	Allow NULL?
54	LOCCO	City Coordinates	nvarchar	10	CHAR	(N' ')	Yes		LOCCO	Allow NULL?
55	NIELS	Nielsen ID	nvarchar	2	CHAR	(N' ')	Yes	TNLS	NIELS	Allow NULL?
56	COUNC	County Code	nvarchar	3	CHAR	(N' ')	Yes	T005E	COUNC	Allow NULL?
57	CITYC	City Code	nvarchar	4	CHAR	(N' ')	Yes	T005G	CITYC	Allow NULL?
58	RPMKR	Regional Market	nvarchar	5	CHAR	(N' ')	Yes		RPMKR	Allow NULL?
59	SORTL	Sort field	nvarchar	10	CHAR	(N' ')	Yes		SORTL	Allow NULL?
60	SORT2	IS-M: Sort Field 2 (for Internal Use)	nvarchar	20	CHAR	(N' ')	Yes		SORTL2	Allow NULL?
61	SORT3	IS-M: Sort field 3 (internal)	nvarchar	30	CHAR	(N' ')	Yes		SORTL3	Allow NULL?
62	BU_SORT1	Search term 1 for business partner	nvarchar	20	CHAR	(N' ')	Yes		BU_SORT1	Allow NULL?
63	SPRAS	Language Key	char	1	LANG	(N' ')	Yes	T002	SPRAS	Allow NULL?
64	REGIO	Region (State, Province, County)	nvarchar	3	CHAR	(N' ')	Yes	T005S	REGIO	Allow NULL?
65	TELFP	IS-M: Home Phone Number	nvarchar	16	CHAR	(N' ')	Yes		TELFP	Allow NULL?
66	TELFD	IS-M: Telephone Number at Work	nvarchar	16	CHAR	(N' ')	Yes		TELFD	Allow NULL?
67	TELW1	IS-M: Additional Telephone Number	nvarchar	16	CHAR	(N' ')	Yes		TELWT	Allow NULL?
68	TELW2	IS-M: Additional Telephone Number	nvarchar	16	CHAR	(N' ')	Yes		TELWT	Allow NULL?
69	TELW3	IS-M: Additional Telephone Number	nvarchar	16	CHAR	(N' ')	Yes		TELWT	Allow NULL?
70	TELW4	IS-M: Mobile Phone Number	nvarchar	20	CHAR	(N' ')	Yes		TELWF	Allow NULL?
71	TELW5	IS-M: Mobile Phone Number	nvarchar	20	CHAR	(N' ')	Yes		TELWF	Allow NULL?
72	TELFX	Fax Number	nvarchar	31	CHAR	(N' ')	Yes		TELFX	Allow NULL?
73	TELF1	IS-M: Additional Fax Number	nvarchar	16	CHAR	(N' ')	Yes		TELFT	Allow NULL?
74	TELF2	IS-M: Additional Fax Number	nvarchar	16	CHAR	(N' ')	Yes		TELFT	Allow NULL?
75	TELF3	IS-M: Additional Fax Number	nvarchar	16	CHAR	(N' ')	Yes		TELFT	Allow NULL?
76	TELTX	Teletex number	nvarchar	30	CHAR	(N' ')	Yes		TELTX	Allow NULL?
77	TELX1	Telex number	nvarchar	30	CHAR	(N' ')	Yes		TELX1	Allow NULL?
78	TELBX	Telebox number	nvarchar	15	CHAR	(N' ')	Yes		TELBX	Allow NULL?
79	DATLT	Data communication line no.	nvarchar	14	CHAR	(N' ')	Yes		DATLT	Allow NULL?
80	STDKO	Default communications service	char	1	CHAR	(N' ')	Yes		STDKO_D	Allow NULL?
81	GPHERK	IS-M: Business Partner Origin	nvarchar	2	CHAR	(N' ')	Yes	TJG41	GPHERK	Allow NULL?
82	GP_REF	IS-M: Business Partner Key	nvarchar	10	CHAR	(N' ')	Yes	JGTGPNR	GPNR	Allow NULL?
83	VBELN_REF	IS-M/SD: Publishing Sales Order	nvarchar	10	CHAR	(N' ')	Yes	JKAK	AVNR	Allow NULL?
84	POSNR_REF	Sales Order Item	nvarchar	6	NUMC	(N'000000')	Yes	JKAP	APNR	Allow NULL?
85	JPARVW_REF	IS-M: Business Partner Role	nvarchar	2	CHAR	(N' ')	Yes	TJG39	JPARVW	Allow NULL?
86	BEABLS_REF	IS-M: Unloading Point	nvarchar	10	CHAR	(N' ')	Yes	JRTBEABST	BEABLST	Allow NULL?
87	TELFP_COD	IS-M: Home Phone Number	nvarchar	16	CHAR	(N' ')	Yes		TELFP	Allow NULL?
88	TELFD_COD	IS-M: Telephone Number at Work	nvarchar	16	CHAR	(N' ')	Yes		TELFD	Allow NULL?
89	NAME1_MACO	IS-M: Business Partner Name (Upper Case for Matchcode)	nvarchar	35	CHAR	(N' ')	Yes		NAME1_ISPM	Allow NULL?
90	NAME2_MACO	IS-M: Bus.Partner's First Name (Upper Case for Matchcode)	nvarchar	35	CHAR	(N' ')	Yes		NAME2_ISPM	Allow NULL?
91	STRAS_MACO	IS-M: Street Name	nvarchar	35	CHAR	(N' ')	Yes		STRAS_ISPM	Allow NULL?
92	ORT01_MACO	IS-M/SD: City Name (Upper Case for Matchcode)	nvarchar	35	CHAR	(N' ')	Yes		ORT01_ISPM	Allow NULL?
93	ISPTELVWP	IS-M: Area Code (Home)	nvarchar	10	CHAR	(N' ')	Yes		ISPTELVWP	Allow NULL?
94	ISPTELP	IS-M: Telephone Number	nvarchar	20	CHAR	(N' ')	Yes		ISPTELP	Allow NULL?
95	ISPTELVWD	IS-M: Area Code - Work	nvarchar	10	CHAR	(N' ')	Yes		ISPTELVWD	Allow NULL?
96	ISPTELD	IS-M: Telephone Number	nvarchar	20	CHAR	(N' ')	Yes		ISPTELD	Allow NULL?
97	ISPHANDY	IS-M: Mobile Phone Number	nvarchar	30	CHAR	(N' ')	Yes		ISPHANDY	Allow NULL?
98	ISPEMAIL	IS-M: E-Mail Address	nvarchar	50	CHAR	(N' ')	Yes		ISPEMAIL	Allow NULL?
99	ISPADRBSND	IS-M/SD: Note for Home Delivery to Ship-to Party	nvarchar	50	CHAR	(N' ')	Yes		ISPADRBSND	Allow NULL?
100	TECHNUMZUG	IS-M: Technical Relocation Due to Postal Data Change	char	1	CHAR	(N' ')	Yes		TECHNUMZUG	Allow NULL?
101	XNOMESS	IS-M: Indicator - Do Not Perform Output Determination	char	1	CHAR	(N' ')	Yes		XNOMESS	Allow NULL?
102	ALIASLFDNR	IS-M: Sequence Number for Alias Table (Key)	nvarchar	10	NUMC	(N'0000000000')	No	JSTALIAS	ALIASLFDNR	Allow NULL?
103	XNOCARPERMESS	IS-M: No Change of Carrier When Address Changes	char	1	CHAR	(N' ')	No		XNOCARPERMESS	Allow NULL?
104	TXJCD	Tax Jurisdiction	nvarchar	15	CHAR	(N' ')	No	TTXJ	TXJCD	Allow NULL?
105	ANI_TELNRP	Telephone number for determining caller	nvarchar	30	CHAR	(N' ')	Yes		AD_TELNRCL	Allow NULL?
106	ANI_TELNRD	Telephone number for determining caller	nvarchar	30	CHAR	(N' ')	Yes		AD_TELNRCL	Allow NULL?
107	ANI_ISPHANDY	Telephone number for determining caller	nvarchar	30	CHAR	(N' ')	Yes		AD_TELNRCL	Allow NULL?
108	HH_REF	IS-M: Business Partner Number of Household	nvarchar	10	CHAR	(N' ')	Yes	JGTHH	GPNR_HH	Allow NULL?
109	HH_EXCLUDE	IS-M: Indicator: Exclude Household Assignment	char	1	CHAR	(N' ')	Yes		HH_EXCLUDE	Allow NULL?
110	PRIVACY_STATUS	IS-M: Status of Address As Regards Data Protection	char	1	CHAR	(N' ')	Yes		ADDRESS_PRIVACY_STATUS	Allow NULL?
111	ADDRNUMBER	Address number	nvarchar	10	CHAR	(N' ')	Yes	*	AD_ADDRNUM	Allow NULL?
112	PERSNUMBER	Person number	nvarchar	10	CHAR	(N' ')	Yes	*	AD_PERSNUM	Allow NULL?

Name	Primary	Unique	Type	Columns
JGTSADR~0	Yes	Yes	CLUSTERED	ADRNR, MANDT
JGTSADR~009	No	No	NONCLUSTERED	PEINORTPF
JGTSADR~1	No	No	NONCLUSTERED	POSTEINORT, LAND1
JGTSADR~2	No	No	NONCLUSTERED	POSTEINSTR, LAND1
JGTSADR~3	No	No	NONCLUSTERED	PSTLZ, LAND1
JGTSADR~5	No	No	NONCLUSTERED	GP_REF
JGTSADR~6	No	No	NONCLUSTERED	ISPTELP, ISPTELVWP
JGTSADR~7	No	No	NONCLUSTERED	ISPTELD, ISPTELVWD
JGTSADR~8	No	No	NONCLUSTERED	SORT2, MANDT
JGTSADR~F	No	No	NONCLUSTERED	ORT01_MACO, NAME1_MACO, 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

112 COLUMNS | 10 INDEXES | ERP 6.0 | JGTSADR TABLE

TOP ERP 6.0 | JGTSADR COLUMNS

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

112 COLUMNS | 10 INDEXES | ERP 6.0 | JGTSADR TABLE

TOPERP 6.0 | JGTSADR COLUMNS

TOPERP 6.0 | JGTSADR INDEXES

TOP ERP 6.0 | JGTSADR COLUMNS

TOP ERP 6.0 | JGTSADR INDEXES