	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	OVPM	154	Outgoing Payments
6	OINM	101	Whse Journal
7	OPCH	268	A/P Invoice
8	JDT1	110	Journal Entry - Rows
9	OOCR	9	Loading Factors
10	OSRN	20	Serial Numbers Master Data

198 COLUMNS | 1 INDEXES | ERP 6.0 | TJHCUSTENV TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: SAP Media :: Advertising Management
1	ERP EHP7	6.0	TJHCUSTENV	198	1	IS-M: Cluster Builder Parameter for Business Partner Envrnmt	Advertising Management

SQL: selectupdate insert create

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

SELECT MANDT, TYPE, PROFILE, STRUC, AMORDER, AMORDER_MAXNUM, AMORDER_MAXDAYS, AMORDER_VKORG, AMORDER_VTWEG, AMORDER_SPART, AMORDERITEM, PRODUCTBP, PRODUCTBP_MAXNUM, CONTACTPERSON, CONTPERS_MAXNUM, CONTRACTS, CONTRACT, CONTRACT_MAXDAYS, VKORGCON, VTWEGCON, SPARTCON, CTR_ALLRL, CTR_ALLRL_MAXD, CTR_ALLRL_VKORG, CTR_ALLRL_VTWEG, CTR_ALLRL_SPART, CTRARL_INVB, CTRARL_INVB_MAXN, CTRARL_INVB_MAXD, CTRARL_INVB_VKO, CTRARL_INVBIT, CTR_GROUP, CTR_GROUP_MAXD, CTR_GROUP_VKORG, CTR_GROUP_VTWEG, CTR_GROUP_SPART, CTRGRP_INVB, CTRGRP_INVB_MAXN, CTRGRP_INVB_MAXD, CTRGRP_INVB_VKO, CTRGRP_INVBIT, MMCONTRACT, MMCON_MAXDAYS, AMINVA, AMINVA_MAXNUM, AMINVA_MAXDAYS, AMINVA_VKORG, AMINVB, AMINVB_MAXNUM, AMINVB_MAXDAYS, AMINVB_VKORG, AMINVF, AMINVF_MAXNUM, AMINVF_MAXDAYS, AMINVF_VKORG, AMAGENT, AMORDBID, AMORDBID_MAXNUM, AMORDBID_MAXDAYS, AMINVAIT, AMINVBIT, AMINVFIT, CONTACT, CONTACT_MAXNUM, CONTACT_MAXDAYS, PRODUCTCP, PRODUCTCP_MAXNUM, AMORDERSL, AMORDERCOMPLAINT, AMAGENCY, AMAGENCY_MAXNUM, AMAGENCY_MAXDAYS, MSDORDER, MSDORDER_TYPES, MSDORDER_MAXNUM, MSDORDER_MAXDAYS, MSDOIT, MSDOIT_MAXNUM, MSDOIT_MAXDAYS, MSDOITC, MSDOITC_MAXNUM, MSDOITC_MAXDAYS, MSDOITS, MSDOITS_MAXNUM, MSDOITS_MAXDAYS, MSDOITSC, MSDOITSC_MAXNUM, MSDOITSC_MAXDAYS, MSDCMP, MSDCMP_MAXNUM, MSDCMP_MAXDAYS, MSDCMPC, MSDCMPC_MAXNUM, MSDCMPC_MAXDAYS, MSDCMPS, MSDCMPS_MAXNUM, MSDCMPS_MAXDAYS, MSDCMPSC, MSDCMPSC_MAXNUM, MSDCMPSC_MAXDAYS, MSDBILL, MSDBILL_MAXNUM, MSDBILL_MAXDAYS, MSDOFFER, MSDOFFER_TYPES, MSDOFFER_MAXNUM, MSDOFFER_MAXDAYS, AMORDADSPECITEM, PARTNERSALESAREA, PARTNSLS_GROUP, BANKDETAILS, PAYMENTCARD, AMORDADSPECSL, CONTACTPERSONAG, AMADVERT, AMADVERT_MAXNUM, AMADVERT_MAXDAYS, CRMACTIV, CRMACTIV_MAXNUM, CRMACTIV_MAXDAYS, CRMACTIV_PARTNFU, CASCONT, CASCONT_MAXNUM, CASCONT_MAXDAYS, MSDBILLI, MSDBILLI_MAXNUM, MSDBILLI_MAXDAYS, MSDBKRT, MSDBKRT_MAXNUM, MSDBKRT_MAXDAYS, MSDBKRTI, MSDBKRTI_MAXNUM, MSDBKRTI_MAXDAYS, MSDCOMPL, MSDCOMPL_MAXNUM, MSDCOMPL_MAXDAYS, MSDRESOI, MSDRESOI_MAXNUM, MSDRESOI_MAXDAYS, MSDSHOI, MSDSHOI_MAXNUM, MSDSHOI_MAXDAYS, MSDSHOIC, MSDSHOIC_MAXNUM, MSDSHOIC_MAXDAYS, MSDEXOIT, MSDEXOIT_MAXNUM, MSDEXOIT_MAXDAYS, AROPITMS, AROPITMS_MAXNUM, AROPITMS_MAXDAYS, AROPITMS_BUKRS, CAMP_BP, CAMP_BP_MAXNUM, CAMP_BP_MAXDAYS, CAMP_BP_IN_R3, CAMP_BP_MAM, CAMP_BP_MSD, CAMP_BP_F, CAMPGNS, CAMPGNS_MAXNUM, CAMPGNS_MAXDAYS, CAMPGNS_MAM, CAMPGNS_MSD, CAMPGNS_F, CONTRACC, CONTRACC_MAXNUM, CONTRACCO, CONTRACCO_MAXNUM, SDORDER, SDORDER_TYPES, SDORDER_TYPES_F, SDORDER_MAXNUM, SDORDER_MAXDAYS, SDOITEM, SDOITEM_MAXNUM, SDOITEM_MAXDAYS, SDCNTRCT, SDCNTRCT_TYPES, SDCNTRCT_TYPES_F, SDCNTRCT_MAXNUM, SDCNTRCT_MAXDAYS, SDCITEM, SDCITEM_MAXNUM, SDCITEM_MAXDAYS, SDBILL, SDBILL_MAXNUM, SDBILL_MAXDAYS, SDBDLST, SDBDLST_MAXNUM, SDBDLST_MAXDAYS, SDMESS, SDMESS_MAXNUM, SDMESS_MAXDAYS, SDMESS_XCURRENT, MANDATE, MANDATE_MAXNUM, MANDATE_MAXDAYS FROM TJHCUSTENV

TOP ERP 6.0 | TJHCUSTENV COLUMNS

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	*	MANDT	Allow NULL?
2	TYPE	Customer Overview Profile Category	nvarchar	2	CHAR	(N' ')	No		EWCUSTENV_TYPE	Allow NULL?
3	PROFILE	Profile of Customer Information Cluster Builder	nvarchar	10	CHAR	(N' ')	No	*	EWCUSTENV_PROFILE	Allow NULL?
4	STRUC	IS-M: Structure Selection for Business Partner Environment	char	1	CHAR	(N' ')	Yes	TJHCUSTENVSTRUC	ISM_CUSTENV_STRUC	Allow NULL?
5	AMORDER	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
6	AMORDER_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
7	AMORDER_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
8	AMORDER_VKORG	Sales Organization	nvarchar	4	CHAR	(N' ')	Yes	TVKO	VKORG	Allow NULL?
9	AMORDER_VTWEG	Distribution Channel	nvarchar	2	CHAR	(N' ')	Yes	TVTW	VTWEG	Allow NULL?
10	AMORDER_SPART	Division	nvarchar	2	CHAR	(N' ')	Yes	TSPA	SPART	Allow NULL?
11	AMORDERITEM	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
12	PRODUCTBP	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
13	PRODUCTBP_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
14	CONTACTPERSON	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
15	CONTPERS_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
16	CONTRACTS	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
17	CONTRACT	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
18	CONTRACT_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
19	VKORGCON	Sales Organization	nvarchar	4	CHAR	(N' ')	Yes	TVKO	VKORG	Allow NULL?
20	VTWEGCON	Distribution Channel	nvarchar	2	CHAR	(N' ')	Yes	TVTW	VTWEG	Allow NULL?
21	SPARTCON	Division	nvarchar	2	CHAR	(N' ')	Yes	TSPA	SPART	Allow NULL?
22	CTR_ALLRL	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
23	CTR_ALLRL_MAXD	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
24	CTR_ALLRL_VKORG	Sales Organization	nvarchar	4	CHAR	(N' ')	Yes	*	VKORG	Allow NULL?
25	CTR_ALLRL_VTWEG	Distribution Channel	nvarchar	2	CHAR	(N' ')	Yes	*	VTWEG	Allow NULL?
26	CTR_ALLRL_SPART	Division	nvarchar	2	CHAR	(N' ')	Yes	*	SPART	Allow NULL?
27	CTRARL_INVB	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
28	CTRARL_INVB_MAXN	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
29	CTRARL_INVB_MAXD	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
30	CTRARL_INVB_VKO	Sales Organization	nvarchar	4	CHAR	(N' ')	Yes	*	VKORG	Allow NULL?
31	CTRARL_INVBIT	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
32	CTR_GROUP	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
33	CTR_GROUP_MAXD	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
34	CTR_GROUP_VKORG	Sales Organization	nvarchar	4	CHAR	(N' ')	Yes	*	VKORG	Allow NULL?
35	CTR_GROUP_VTWEG	Distribution Channel	nvarchar	2	CHAR	(N' ')	Yes	*	VTWEG	Allow NULL?
36	CTR_GROUP_SPART	Division	nvarchar	2	CHAR	(N' ')	Yes	*	SPART	Allow NULL?
37	CTRGRP_INVB	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
38	CTRGRP_INVB_MAXN	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
39	CTRGRP_INVB_MAXD	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
40	CTRGRP_INVB_VKO	Sales Organization	nvarchar	4	CHAR	(N' ')	Yes	*	VKORG	Allow NULL?
41	CTRGRP_INVBIT	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
42	MMCONTRACT	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	No		EWCUST_OBJOPT	Allow NULL?
43	MMCON_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	No		EWCUST_MAXDAYS	Allow NULL?
44	AMINVA	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
45	AMINVA_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
46	AMINVA_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
47	AMINVA_VKORG	Sales Organization	nvarchar	4	CHAR	(N' ')	Yes	*	VKORG	Allow NULL?
48	AMINVB	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
49	AMINVB_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
50	AMINVB_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
51	AMINVB_VKORG	Sales Organization	nvarchar	4	CHAR	(N' ')	Yes	*	VKORG	Allow NULL?
52	AMINVF	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
53	AMINVF_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
54	AMINVF_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
55	AMINVF_VKORG	Sales Organization	nvarchar	4	CHAR	(N' ')	Yes	*	VKORG	Allow NULL?
56	AMAGENT	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
57	AMORDBID	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
58	AMORDBID_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
59	AMORDBID_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
60	AMINVAIT	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
61	AMINVBIT	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
62	AMINVFIT	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
63	CONTACT	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
64	CONTACT_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
65	CONTACT_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
66	PRODUCTCP	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
67	PRODUCTCP_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
68	AMORDERSL	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
69	AMORDERCOMPLAINT	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
70	AMAGENCY	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
71	AMAGENCY_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
72	AMAGENCY_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
73	MSDORDER	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
74	MSDORDER_TYPES	IS-M/SD: Order Types	nvarchar	255	CHAR	(N' ')	Yes		ISM_MSDORDERTYPE_SEL	Allow NULL?
75	MSDORDER_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
76	MSDORDER_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
77	MSDOIT	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
78	MSDOIT_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
79	MSDOIT_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
80	MSDOITC	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
81	MSDOITC_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
82	MSDOITC_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
83	MSDOITS	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
84	MSDOITS_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
85	MSDOITS_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
86	MSDOITSC	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
87	MSDOITSC_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
88	MSDOITSC_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
89	MSDCMP	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
90	MSDCMP_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
91	MSDCMP_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
92	MSDCMPC	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
93	MSDCMPC_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
94	MSDCMPC_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
95	MSDCMPS	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
96	MSDCMPS_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
97	MSDCMPS_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
98	MSDCMPSC	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
99	MSDCMPSC_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
100	MSDCMPSC_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
101	MSDBILL	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
102	MSDBILL_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
103	MSDBILL_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
104	MSDOFFER	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
105	MSDOFFER_TYPES	IS-M/SD: Order Types	nvarchar	255	CHAR	(N' ')	Yes		ISM_MSDORDERTYPE_SEL	Allow NULL?
106	MSDOFFER_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
107	MSDOFFER_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
108	AMORDADSPECITEM	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
109	PARTNERSALESAREA	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
110	PARTNSLS_GROUP	IS-M: Sales Area Group for Business Partner Selection	nvarchar	4	CHAR	(N' ')	Yes	TJH_GR_SALESAREA	GROUP_SALESAREA	Allow NULL?
111	BANKDETAILS	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
112	PAYMENTCARD	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
113	AMORDADSPECSL	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
114	CONTACTPERSONAG	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
115	AMADVERT	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
116	AMADVERT_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
117	AMADVERT_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
118	CRMACTIV	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	No		EWCUST_OBJOPT	Allow NULL?
119	CRMACTIV_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	No		EWCUST_MAXNUM	Allow NULL?
120	CRMACTIV_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	No		EWCUST_MAXDAYS	Allow NULL?
121	CRMACTIV_PARTNFU	IS-M: Partner Function in CRM	nvarchar	8	CHAR	(N' ')	No		ISM_CRMT_PARTNER_FCT	Allow NULL?
122	CASCONT	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
123	CASCONT_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
124	CASCONT_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
125	MSDBILLI	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	No		EWCUST_OBJOPT	Allow NULL?
126	MSDBILLI_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	No		EWCUST_MAXNUM	Allow NULL?
127	MSDBILLI_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	No		EWCUST_MAXDAYS	Allow NULL?
128	MSDBKRT	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	No		EWCUST_OBJOPT	Allow NULL?
129	MSDBKRT_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	No		EWCUST_MAXNUM	Allow NULL?
130	MSDBKRT_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	No		EWCUST_MAXDAYS	Allow NULL?
131	MSDBKRTI	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
132	MSDBKRTI_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
133	MSDBKRTI_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
134	MSDCOMPL	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	No		EWCUST_OBJOPT	Allow NULL?
135	MSDCOMPL_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	No		EWCUST_MAXNUM	Allow NULL?
136	MSDCOMPL_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	No		EWCUST_MAXDAYS	Allow NULL?
137	MSDRESOI	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	No		EWCUST_OBJOPT	Allow NULL?
138	MSDRESOI_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	No		EWCUST_MAXNUM	Allow NULL?
139	MSDRESOI_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	No		EWCUST_MAXDAYS	Allow NULL?
140	MSDSHOI	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	No		EWCUST_OBJOPT	Allow NULL?
141	MSDSHOI_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	No		EWCUST_MAXNUM	Allow NULL?
142	MSDSHOI_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	No		EWCUST_MAXDAYS	Allow NULL?
143	MSDSHOIC	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	No		EWCUST_OBJOPT	Allow NULL?
144	MSDSHOIC_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	No		EWCUST_MAXNUM	Allow NULL?
145	MSDSHOIC_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	No		EWCUST_MAXDAYS	Allow NULL?
146	MSDEXOIT	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	No		EWCUST_OBJOPT	Allow NULL?
147	MSDEXOIT_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	No		EWCUST_MAXNUM	Allow NULL?
148	MSDEXOIT_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
149	AROPITMS	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
150	AROPITMS_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
151	AROPITMS_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
152	AROPITMS_BUKRS	Company Code	nvarchar	4	CHAR	(N' ')	Yes	*	BUKRS	Allow NULL?
153	CAMP_BP	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
154	CAMP_BP_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
155	CAMP_BP_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
156	CAMP_BP_IN_R3	Campaign Exists in SAP Media Indicator	char	1	CHAR	(N' ')	Yes		ISM_CAMP_BP_IN_R3	Allow NULL?
157	CAMP_BP_MAM	IS-M: Campaign Usage in IS-M Advertising Mgmt Comp.(M/AM)	char	1	CHAR	(N' ')	Yes		ISM_CAMP_USE_IN_MAM	Allow NULL?
158	CAMP_BP_MSD	IS-M: Campaign Usage in IS-M Media Sales & Dist.(M/SD) Comp.	char	1	CHAR	(N' ')	Yes		ISM_CAMP_USE_IN_MSD	Allow NULL?
159	CAMP_BP_F	Checkbox	char	1	CHAR	(N' ')	Yes		XFELD	Allow NULL?
160	CAMPGNS	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
161	CAMPGNS_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
162	CAMPGNS_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
163	CAMPGNS_MAM	IS-M: Campaign Usage in IS-M Advertising Mgmt Comp.(M/AM)	char	1	CHAR	(N' ')	Yes		ISM_CAMP_USE_IN_MAM	Allow NULL?
164	CAMPGNS_MSD	IS-M: Campaign Usage in IS-M Media Sales & Dist.(M/SD) Comp.	char	1	CHAR	(N' ')	Yes		ISM_CAMP_USE_IN_MSD	Allow NULL?
165	CAMPGNS_F	Checkbox	char	1	CHAR	(N' ')	Yes		XFELD	Allow NULL?
166	CONTRACC	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
167	CONTRACC_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
168	CONTRACCO	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
169	CONTRACCO_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
170	SDORDER	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
171	SDORDER_TYPES	IS-M: SD Order Types	nvarchar	255	CHAR	(N' ')	Yes		ISM_SDORDERTYPE_SEL	Allow NULL?
172	SDORDER_TYPES_F	Checkbox	char	1	CHAR	(N' ')	Yes		XFELD	Allow NULL?
173	SDORDER_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
174	SDORDER_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
175	SDOITEM	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
176	SDOITEM_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
177	SDOITEM_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
178	SDCNTRCT	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
179	SDCNTRCT_TYPES	IS-M: SD Order Types	nvarchar	255	CHAR	(N' ')	Yes		ISM_SDORDERTYPE_SEL	Allow NULL?
180	SDCNTRCT_TYPES_F	Checkbox	char	1	CHAR	(N' ')	Yes		XFELD	Allow NULL?
181	SDCNTRCT_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
182	SDCNTRCT_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
183	SDCITEM	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
184	SDCITEM_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
185	SDCITEM_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
186	SDBILL	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
187	SDBILL_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
188	SDBILL_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
189	SDBDLST	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
190	SDBDLST_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
191	SDBDLST_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
192	SDMESS	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
193	SDMESS_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
194	SDMESS_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?
195	SDMESS_XCURRENT	Only Display Objects Valid on Current Date	char	1	CHAR	(N' ')	Yes		ISM_XCURRENTDAY	Allow NULL?
196	MANDATE	Display Type for Cluster Builder Object Level	char	1	CHAR	(N' ')	Yes		EWCUST_OBJOPT	Allow NULL?
197	MANDATE_MAXNUM	Maximum Number of Objects for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXNUM	Allow NULL?
198	MANDATE_MAXDAYS	Maximum Age in Days of Object for Display (0 = all)	nvarchar	3	NUMC	(N'000')	Yes		EWCUST_MAXDAYS	Allow NULL?

TOP ERP 6.0 | TJHCUSTENV INDEXES

Name	Primary	Unique	Type	Columns
TJHCUSTENV~0	Yes	Yes	CLUSTERED	MANDT, TYPE, PROFILE

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

198 COLUMNS | 1 INDEXES | ERP 6.0 | TJHCUSTENV TABLE

TOP ERP 6.0 | TJHCUSTENV COLUMNS

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

198 COLUMNS | 1 INDEXES | ERP 6.0 | TJHCUSTENV TABLE

TOPERP 6.0 | TJHCUSTENV COLUMNS

TOPERP 6.0 | TJHCUSTENV INDEXES

TOP ERP 6.0 | TJHCUSTENV COLUMNS

TOP ERP 6.0 | TJHCUSTENV INDEXES