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	BSEG	345	Accounting Document Segment
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	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

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