	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

TL1 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: Defense Forces and Public Security :: Master Data Distribution
1	ERP EHP7	6.0	/ISDFPS/TL1	221	1	Task List - Operation/Activity	Master Data Distribution

SQL: selectupdate insert create

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

SELECT MANDT, PLNTY, PLNNR, PLNKN, ZAEHL, DATUV, TECHV, AENNR, LOEKZ, PARKZ, ANDAT, ANNAM, AEDAT, AENAM, SUMNR, VORNR, STEUS, ARBID, OBJTY, WERKS, KTSCH, LTXA1, LTXA2, TXTSP, VPLTY, VPLNR, VPLAL, VPLFL, VINTV, MEINH, UMREN, UMREZ, BMSCH, ZMERH, ZEIER, LAR01, VGE01, VGW01, LAR02, VGE02, VGW02, LAR03, VGE03, VGW03, LAR04, VGE04, VGW04, LAR05, VGE05, VGW05, LAR06, VGE06, VGW06, ZERMA, ZGDAT, ZCODE, ZULNR, RSANZ, PDEST, LOANZ, LOART, QUALF, ANZMA, RFGRP, RFSCH, RASCH, AUFAK, LOGRP, UEMUS, UEKAN, FLIES, ZEIMU, ZMINU, MINWE, SPMUS, SPLIM, ZEIMB, ZMINB, ZEILM, ZLMAX, ZEILP, ZLPRO, ZEIWN, ZWNOR, ZEIWM, ZWMIN, ZEITN, ZTNOR, ZEITM, ZTMIN, ABLIPKZ, RSTRA, BZOFFB, OFFSTB, EHOFFB, BZOFFE, OFFSTE, EHOFFE, SORTL, LIFNR, PLIFZ, PREIS, PEINH, SAKTO, WAERS, INFNR, ESOKZ, EKORG, EKGRP, KZLGF, MATKL, DAUNO, DAUNE, DAUMI, DAUME, DDEHN, EINSA, EINSE, ARBEI, ARBEH, ANZZL, PRZNT, VERTL, MLSTN, PPRIO, BUKRS, SLWID, USR00, USR01, USR02, USR03, USR04, USE04, USR05, USE05, USR06, USE06, USR07, USE07, USR08, USR09, USR10, USR11, ANFKO, ANFKOKRS, KAPAR, INDET, LARNT, PRKST, QRASTERMNG, QRASTEREH, ANLZU, ISTRU, ISTTY, ISTNR, ISTKN, ISTPO, IUPOZ, EBORT, KALID, FRSP, VERTN, ZGR01, ZGR02, ZGR03, ZGR04, ZGR05, ZGR06, MDLID, RUZUS, BMEIH, BMVRG, CKSELKZ, KALKZ, NPRIO, PVZKN, PHFLG, PHSEQ, KNOBJ, ERFSICHT, PSPNR, QLOTYPE, QLOBJEKTID, QLKAPAR, QKZPRZEIT, QKZZTMG1, QKZPRMENG, QKZPRFREI, QRASTZEHT, QRASTZFAK, QRASTMENG, QPPKTABS, KRIT1, CLASSID, PACKNO, EBELN, EBELP, CAPOC, FLG_CAPTXT, CN_WEIGHT, QKZTLSBEST, AUFKT, DAFKT, RWFAK, AAUFG, VERDART, UAVO_AUFL, FRDLB, QPART, PRZ01, TAKT, OPRID, NVADD, EVGEW, RFPNT, FLG_TSK_GROUP, ADPSP, SUBPLNAL, SUBPLNNR, SUBPLNTY, XEXCLTL FROM /ISDFPS/TL1

TOP ERP 6.0 | /ISDFPS/TL1 COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	PLNTY	Task List Type	char	1	0	CHAR	(N' ')	No	TCA01	PLNTY	Allow NULL?
3	PLNNR	Key for Task List Group	nvarchar	8	0	CHAR	(N' ')	No		PLNNR	Allow NULL?
4	PLNKN	Number of the task list node	nvarchar	8	0	NUMC	(N'00000000')	No		PLNKN	Allow NULL?
5	ZAEHL	Internal counter	nvarchar	8	0	NUMC	(N'00000000')	No		CIM_COUNT	Allow NULL?
6	DATUV	Valid-From Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUV	Allow NULL?
7	TECHV	Technical status from	nvarchar	12	0	CHAR	(N' ')	Yes		TECHV	Allow NULL?
8	AENNR	Change Number	nvarchar	12	0	CHAR	(N' ')	Yes	AENR	AENNR	Allow NULL?
9	LOEKZ	Deletion Indicator	char	1	0	CHAR	(N' ')	Yes		LKENZ	Allow NULL?
10	PARKZ	Indicator: inactive changes	char	1	0	CHAR	(N' ')	Yes		PARKZ	Allow NULL?
11	ANDAT	Date record created on	nvarchar	8	0	DATS	(N'00000000')	Yes		ANDAT	Allow NULL?
12	ANNAM	User who created record	nvarchar	12	0	CHAR	(N' ')	Yes		ANNAM	Allow NULL?
13	AEDAT	Changed On	nvarchar	8	0	DATS	(N'00000000')	Yes		AEDAT	Allow NULL?
14	AENAM	Name of Person Who Changed Object	nvarchar	12	0	CHAR	(N' ')	Yes		AENAM	Allow NULL?
15	SUMNR	Node number of the superior operation	nvarchar	8	0	NUMC	(N'00000000')	Yes		SUMKNTNR	Allow NULL?
16	VORNR	Operation/Activity Number	nvarchar	4	0	CHAR	(N' ')	Yes		VORNR	Allow NULL?
17	STEUS	Control key	nvarchar	4	0	CHAR	(N' ')	Yes	T430	STEUS	Allow NULL?
18	ARBID	Object ID	nvarchar	8	0	NUMC	(N'00000000')	Yes		OBJEKTID	Allow NULL?
19	OBJTY	Object types of the CIM resource	nvarchar	2	0	CHAR	(N' ')	Yes		CR_OBJTY	Allow NULL?
20	WERKS	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	WERKS_D	Allow NULL?
21	KTSCH	Standard text key	nvarchar	7	0	CHAR	(N' ')	Yes	T435	KTSCH	Allow NULL?
22	LTXA1	Operation short text	nvarchar	40	0	CHAR	(N' ')	Yes		LTXA1	Allow NULL?
23	LTXA2	Second line of the description	nvarchar	40	0	CHAR	(N' ')	Yes		LTXA2	Allow NULL?
24	TXTSP	Language Key	char	1	0	LANG	(N' ')	Yes	T002	SPRAS	Allow NULL?
25	VPLTY	Type of the referenced task list	char	1	0	CHAR	(N' ')	Yes	*	VPLNTY	Allow NULL?
26	VPLNR	Group of the referenced task list	nvarchar	8	0	CHAR	(N' ')	Yes		VPLNNR	Allow NULL?
27	VPLAL	Group counter of the referenced task list	nvarchar	2	0	CHAR	(N' ')	Yes		VPLNAL	Allow NULL?
28	VPLFL	Referenced sequence in routing	nvarchar	6	0	CHAR	(N' ')	Yes		VPLBFL	Allow NULL?
29	VINTV	Increment between referenced operations	decimal	3	0	DEC	((0))	Yes		VINTV
30	MEINH	Unit of Measure for Activity/Operation	nvarchar	3	0	UNIT	(N' ')	Yes	T006	VORME	Allow NULL?
31	UMREN	Denominator for converting rtg and op units of measure	decimal	5	0	DEC	((0))	Yes		CP_UMREN
32	UMREZ	Numerator for converting task list and oper. un. of measure	decimal	5	0	DEC	((0))	Yes		CP_UMREZ
33	BMSCH	Base Quantity	decimal	13	3	QUAN	((0))	Yes		BMSCH
34	ZMERH	Break	decimal	9	3	QUAN	((0))	Yes		DZMERH
35	ZEIER	Unit for the break time	nvarchar	3	0	UNIT	(N' ')	Yes	T006	DZEIER	Allow NULL?
36	LAR01	Activity Type	nvarchar	6	0	CHAR	(N' ')	Yes	CSLA	LSTAR	Allow NULL?
37	VGE01	Unit of measure for the standard value	nvarchar	3	0	UNIT	(N' ')	Yes	T006	VGWRTEH	Allow NULL?
38	VGW01	Standard Value	decimal	9	3	QUAN	((0))	Yes		VGWRT
39	LAR02	Activity Type	nvarchar	6	0	CHAR	(N' ')	Yes	CSLA	LSTAR	Allow NULL?
40	VGE02	Unit of measure for the standard value	nvarchar	3	0	UNIT	(N' ')	Yes	T006	VGWRTEH	Allow NULL?
41	VGW02	Standard Value	decimal	9	3	QUAN	((0))	Yes		VGWRT
42	LAR03	Activity Type	nvarchar	6	0	CHAR	(N' ')	Yes	CSLA	LSTAR	Allow NULL?
43	VGE03	Unit of measure for the standard value	nvarchar	3	0	UNIT	(N' ')	Yes	T006	VGWRTEH	Allow NULL?
44	VGW03	Standard Value	decimal	9	3	QUAN	((0))	Yes		VGWRT
45	LAR04	Activity Type	nvarchar	6	0	CHAR	(N' ')	Yes	CSLA	LSTAR	Allow NULL?
46	VGE04	Unit of measure for the standard value	nvarchar	3	0	UNIT	(N' ')	Yes	T006	VGWRTEH	Allow NULL?
47	VGW04	Standard Value	decimal	9	3	QUAN	((0))	Yes		VGWRT
48	LAR05	Activity Type	nvarchar	6	0	CHAR	(N' ')	Yes	CSLA	LSTAR	Allow NULL?
49	VGE05	Unit of measure for the standard value	nvarchar	3	0	UNIT	(N' ')	Yes	T006	VGWRTEH	Allow NULL?
50	VGW05	Standard Value	decimal	9	3	QUAN	((0))	Yes		VGWRT
51	LAR06	Activity Type	nvarchar	6	0	CHAR	(N' ')	Yes	CSLA	LSTAR	Allow NULL?
52	VGE06	Unit of measure for the standard value	nvarchar	3	0	UNIT	(N' ')	Yes	T006	VGWRTEH	Allow NULL?
53	VGW06	Standard Value	decimal	9	3	QUAN	((0))	Yes		VGWRT
54	ZERMA	Type of standard value calculation	nvarchar	5	0	CHAR	(N' ')	Yes	T429	DZERMA	Allow NULL?
55	ZGDAT	Date when the standard value was calculated	nvarchar	4	0	CHAR	(N' ')	Yes		DZGDAT	Allow NULL?
56	ZCODE	Reference number for standard value code	nvarchar	6	0	CHAR	(N' ')	Yes		DZCODE	Allow NULL?
57	ZULNR	Basis for standard value calculation	nvarchar	5	0	CHAR	(N' ')	Yes		DZULNR	Allow NULL?
58	RSANZ	Number of confirmation slips	nvarchar	3	0	NUMC	(N'000')	Yes		CR_RS_ANZ	Allow NULL?
59	PDEST	Printer for shop papers	nvarchar	4	0	CHAR	(N' ')	Yes	TSP03	CR_PDEST	Allow NULL?
60	LOANZ	Number of Time Tickets	decimal	3	0	DEC	((0))	Yes		LOHNANZ
61	LOART	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes		LOHNART	Allow NULL?
62	QUALF	Suitability	nvarchar	2	0	CHAR	(N' ')	Yes	T423	QUALF	Allow NULL?
63	ANZMA	Number of employees	decimal	5	2	DEC	((0))	Yes		ANZMS
64	RFGRP	Setup group category	nvarchar	10	0	CHAR	(N' ')	Yes	T426	RUEFAGRP	Allow NULL?
65	RFSCH	Setup group key	nvarchar	10	0	CHAR	(N' ')	Yes	T425	RUEFASCHLU	Allow NULL?
66	RASCH	Setup Type Key	nvarchar	2	0	CHAR	(N' ')	Yes	T428	RUEARSCHLU	Allow NULL?
67	AUFAK	Scrap factor	decimal	5	3	DEC	((0))	Yes		AUSCHUFAK
68	LOGRP	Wage group	nvarchar	3	0	CHAR	(N' ')	Yes	T421	LOHNGRP	Allow NULL?
69	UEMUS	Required overlapping	char	1	0	CHAR	(N' ')	Yes		UEMUSKZ	Allow NULL?
70	UEKAN	Optional overlapping	char	1	0	CHAR	(N' ')	Yes		UEKANKZ	Allow NULL?
71	FLIES	Indicator: continuous flow production	char	1	0	CHAR	(N' ')	Yes		FLIESSKZ	Allow NULL?
72	ZEIMU	Unit for the minimum overlap time	nvarchar	3	0	UNIT	(N' ')	Yes	T006	DZEIMU	Allow NULL?
73	ZMINU	Minimum overlap time	decimal	9	3	QUAN	((0))	Yes		DZMINU
74	MINWE	Minimum Send-Ahead Quantity	decimal	13	3	QUAN	((0))	Yes		MINWEI
75	SPMUS	Required splitting	char	1	0	CHAR	(N' ')	Yes		SPLITTUNG	Allow NULL?
76	SPLIM	Maximum number of splits	decimal	3	0	DEC	((0))	Yes		SPLITTANZ
77	ZEIMB	Unit for the minimum processing time	nvarchar	3	0	UNIT	(N' ')	Yes	T006	DZEIMB	Allow NULL?
78	ZMINB	Minimum processing time	decimal	9	3	QUAN	((0))	Yes		DZMINB
79	ZEILM	Unit for the maximum wait time	nvarchar	3	0	UNIT	(N' ')	Yes	T006	DZEILM	Allow NULL?
80	ZLMAX	Maximum wait time	decimal	9	3	QUAN	((0))	Yes		DZLMAX
81	ZEILP	Unit for the required wait time	nvarchar	3	0	UNIT	(N' ')	Yes	T006	DZEILP	Allow NULL?
82	ZLPRO	Minimum wait time	decimal	9	3	QUAN	((0))	Yes		DZLPRO
83	ZEIWN	Unit for the standard queue time	nvarchar	3	0	UNIT	(N' ')	Yes	T006	DZEIWN	Allow NULL?
84	ZWNOR	Standard queue time	decimal	9	3	QUAN	((0))	Yes		DZWNOR
85	ZEIWM	Unit for the minumum queue time	nvarchar	3	0	UNIT	(N' ')	Yes	T006	DZEIWM	Allow NULL?
86	ZWMIN	Minimum queue time	decimal	9	3	QUAN	((0))	Yes		DZWMIN
87	ZEITN	Unit for the standard move time	nvarchar	3	0	UNIT	(N' ')	Yes	T006	DZEITN	Allow NULL?
88	ZTNOR	Standard move time	decimal	9	3	QUAN	((0))	Yes		DZTNOR
89	ZEITM	Unit for the minimum move time	nvarchar	3	0	UNIT	(N' ')	Yes	T006	DZEITM	Allow NULL?
90	ZTMIN	Minimum move time	decimal	9	3	QUAN	((0))	Yes		DZTMIN
91	ABLIPKZ	Indicator: simultaneous teardown and wait	char	1	0	CHAR	(N' ')	Yes		ABLIPKZ	Allow NULL?
92	RSTRA	Reduction strategy per operation/activity	nvarchar	2	0	CHAR	(N' ')	Yes	T499Q	RSTRA	Allow NULL?
93	BZOFFB	Reference date for start of sub-operation	nvarchar	2	0	CHAR	(N' ')	Yes	TCA54	CP_OBZOFFB	Allow NULL?
94	OFFSTB	Offset to sub-operation start	decimal	5	0	QUAN	((0))	Yes		CP_OOFFSTB
95	EHOFFB	Unit for offset to start	nvarchar	3	0	UNIT	(N' ')	Yes	T006	CP_OEHOFFB	Allow NULL?
96	BZOFFE	Reference date for finish of sub-operation	nvarchar	2	0	CHAR	(N' ')	Yes	TCA54	CP_OBZOFFE	Allow NULL?
97	OFFSTE	Offset to sub-operation finish	decimal	5	0	QUAN	((0))	Yes		CP_OOFFSTE
98	EHOFFE	Unit for offset to finish	nvarchar	3	0	UNIT	(N' ')	Yes	T006	CP_OEHOFFE	Allow NULL?
99	SORTL	Sort Term for Non-Stock Info Records	nvarchar	10	0	CHAR	(N' ')	Yes		SORTI	Allow NULL?
100	LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	CHAR	(N' ')	Yes	LFA1	LIFNR	Allow NULL?
101	PLIFZ	Planned Delivery Time in Days	decimal	3	0	DEC	((0))	Yes		PLIFZ
102	PREIS	Net Price in Purchasing Info Record	decimal	11	2	CURR	((0))	Yes		IPREI
103	PEINH	Price Unit	decimal	5	0	DEC	((0))	Yes		EPEIN
104	SAKTO	Cost Element	nvarchar	10	0	CHAR	(N' ')	Yes	CSKA	KSTAR	Allow NULL?
105	WAERS	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
106	INFNR	Number of Purchasing Info Record	nvarchar	10	0	CHAR	(N' ')	Yes	EINA	INFNR	Allow NULL?
107	ESOKZ	Purchasing info record category	char	1	0	CHAR	(N' ')	Yes		ESOKZ	Allow NULL?
108	EKORG	Purchasing Organization	nvarchar	4	0	CHAR	(N' ')	Yes	T024E	EKORG	Allow NULL?
109	EKGRP	Purchasing group for external processing	nvarchar	3	0	CHAR	(N' ')	Yes	T024	VG_EKGRP	Allow NULL?
110	KZLGF	Indicator: fixed lot external processing	char	1	0	CHAR	(N' ')	Yes		KZLGF	Allow NULL?
111	MATKL	Material Group	nvarchar	9	0	CHAR	(N' ')	Yes	T023	MATKL	Allow NULL?
112	DAUNO	Normal duration of the activity	decimal	5	1	QUAN	((0))	Yes		DAUNOR
113	DAUNE	Normal duration/unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	DAUNORE	Allow NULL?
114	DAUMI	Minimum activity duration	decimal	5	1	QUAN	((0))	Yes		DAUMIN
115	DAUME	Unit for the minimum duration	nvarchar	3	0	UNIT	(N' ')	Yes	T006	DAUMINE	Allow NULL?
116	DDEHN	Indicator: flexible duration	char	1	0	CHAR	(N' ')	Yes		DAUDEHN	Allow NULL?
117	EINSA	Constraint on the basic start date for the activity	char	1	0	CHAR	(N' ')	Yes		EINSCHRA	Allow NULL?
118	EINSE	Constraint on the finish date of the activity	char	1	0	CHAR	(N' ')	Yes		EINSCHRE	Allow NULL?
119	ARBEI	Work involved in the activity	decimal	7	1	QUAN	((0))	Yes		ARBEIT
120	ARBEH	Unit for work	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ARBEITE	Allow NULL?
121	ANZZL	Number of capacities required	tinyint	3	0	INT1	((0))	Yes		ANZKAP
122	PRZNT	Work percentage	tinyint	3	0	INT1	((0))	Yes		APROZENT
123	VERTL	Distribution function for capacity requirements	nvarchar	2	0	CHAR	(N' ')	Yes	T498	VERTEILUNG	Allow NULL?
124	MLSTN	Usage	nvarchar	5	0	CHAR	(N' ')	Yes	T433	MILESTONE	Allow NULL?
125	PPRIO	Priority	nvarchar	2	0	CHAR	(N' ')	Yes		PRIORITAET	Allow NULL?
126	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	Yes	T001	BUKRS	Allow NULL?
127	SLWID	Key word ID for user-defined fields	nvarchar	7	0	CHAR	(N' ')	Yes	TCN00	SLWID	Allow NULL?
128	USR00	User field with 20 characters	nvarchar	20	0	CHAR	(N' ')	Yes		USRCHAR20	Allow NULL?
129	USR01	User field with 20 characters	nvarchar	20	0	CHAR	(N' ')	Yes		USRCHAR20	Allow NULL?
130	USR02	User field with 10 characters	nvarchar	10	0	CHAR	(N' ')	Yes		USRCHAR10	Allow NULL?
131	USR03	User field with 10 characters	nvarchar	10	0	CHAR	(N' ')	Yes		USRCHAR10	Allow NULL?
132	USR04	User field for quantity (length 10.3)	decimal	13	3	QUAN	((0))	Yes		USRQUAN13
133	USE04	User field: Unit for quantity fields	nvarchar	3	0	UNIT	(N' ')	Yes	T006	USRUNIT	Allow NULL?
134	USR05	User field for quantity (length 10.3)	decimal	13	3	QUAN	((0))	Yes		USRQUAN13
135	USE05	User field: Unit for quantity fields	nvarchar	3	0	UNIT	(N' ')	Yes	T006	USRUNIT	Allow NULL?
136	USR06	User-defined field for values (length 10,3)	decimal	13	3	CURR	((0))	Yes		USRCURR13
137	USE06	User field: Unit for value fields	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	USRCUKY	Allow NULL?
138	USR07	User-defined field for values (length 10,3)	decimal	13	3	CURR	((0))	Yes		USRCURR13
139	USE07	User field: Unit for value fields	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	USRCUKY	Allow NULL?
140	USR08	User field for date	nvarchar	8	0	DATS	(N'00000000')	Yes		USRDATE	Allow NULL?
141	USR09	User field for date	nvarchar	8	0	DATS	(N'00000000')	Yes		USRDATE	Allow NULL?
142	USR10	User-defined field: Indicator for reports	char	1	0	CHAR	(N' ')	Yes		USRFLAG	Allow NULL?
143	USR11	User-defined field: Indicator for reports	char	1	0	CHAR	(N' ')	Yes		USRFLAG	Allow NULL?
144	ANFKO	Requesting cost center	nvarchar	10	0	CHAR	(N' ')	Yes	CSKS	ANFKO	Allow NULL?
145	ANFKOKRS	Controlling area of the requesting cost center	nvarchar	4	0	CHAR	(N' ')	Yes	TKA01	ANFKOKRS	Allow NULL?
146	KAPAR	Capacity category	nvarchar	3	0	CHAR	(N' ')	Yes	TC26	KAPART	Allow NULL?
147	INDET	Key for calculation	char	1	0	CHAR	(N' ')	Yes		INDET	Allow NULL?
148	LARNT	Activity Type	nvarchar	6	0	CHAR	(N' ')	Yes	CSLA	LSTAR	Allow NULL?
149	PRKST	Costs in the activity	decimal	11	2	CURR	((0))	Yes		PRKST
150	QRASTERMNG	Quantity for Grid Point Definition	decimal	5	2	DEC	((0))	Yes		QRASTERMNG
151	QRASTEREH	Grid Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	QRASTEREH	Allow NULL?
152	ANLZU	Syst.Condition	char	1	0	CHAR	(N' ')	Yes	T357M	ANLZU	Allow NULL?
153	ISTRU	Assembly	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	ISTRU	Allow NULL?
154	ISTTY	BOM category	char	1	0	CHAR	(N' ')	Yes		STLTY	Allow NULL?
155	ISTNR	Bill of material	nvarchar	8	0	CHAR	(N' ')	Yes		STNUM	Allow NULL?
156	ISTKN	BOM item node number	nvarchar	8	0	NUMC	(N'00000000')	Yes		STLKN	Allow NULL?
157	ISTPO	Internal counter	nvarchar	8	0	NUMC	(N'00000000')	Yes		CIM_COUNT	Allow NULL?
158	IUPOZ	Subitem Number	nvarchar	4	0	CHAR	(N' ')	Yes		UPOSZ	Allow NULL?
159	EBORT	Installation Point for Subitem	nvarchar	20	0	CHAR	(N' ')	Yes		EBORT	Allow NULL?
160	KALID	Factory Calendar	nvarchar	2	0	CHAR	(N' ')	Yes	TFACD	WFCID	Allow NULL?
161	FRSP	Earliest possible activity / Latest possible activity	char	1	0	CHAR	(N' ')	Yes		FRSP	Allow NULL?
162	VERTN	Distr.cap.reqmts (plant maint.,process order, network)	nvarchar	8	0	CHAR	(N' ')	Yes	TC29	CR_VERTN	Allow NULL?
163	ZGR01	Key for performance efficiency rate	nvarchar	3	0	CHAR	(N' ')	Yes	TC31	IDZEITGRAD	Allow NULL?
164	ZGR02	Key for performance efficiency rate	nvarchar	3	0	CHAR	(N' ')	Yes	TC31	IDZEITGRAD	Allow NULL?
165	ZGR03	Key for performance efficiency rate	nvarchar	3	0	CHAR	(N' ')	Yes	TC31	IDZEITGRAD	Allow NULL?
166	ZGR04	Key for performance efficiency rate	nvarchar	3	0	CHAR	(N' ')	Yes	TC31	IDZEITGRAD	Allow NULL?
167	ZGR05	Key for performance efficiency rate	nvarchar	3	0	CHAR	(N' ')	Yes	TC31	IDZEITGRAD	Allow NULL?
168	ZGR06	Key for performance efficiency rate	nvarchar	3	0	CHAR	(N' ')	Yes	TC31	IDZEITGRAD	Allow NULL?
169	MDLID	Model ID for charge calculation	nvarchar	4	0	CHAR	(N' ')	Yes		MDLID	Allow NULL?
170	RUZUS	Key: rounding and additional values	nvarchar	4	0	CHAR	(N' ')	Yes	TCERS	RUZUS	Allow NULL?
171	BMEIH	Operation order quantity unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	BMEIH	Allow NULL?
172	BMVRG	Purchase order quantity operation	decimal	13	3	QUAN	((0))	Yes		BMVRG
173	CKSELKZ	Indicator for Relevancy to Costing	char	1	0	CHAR	(N' ')	Yes	TCK08	CK_SELKZ	Allow NULL?
174	KALKZ	Cost	char	1	0	CHAR	(N' ')	Yes		CK_KALKZ	Allow NULL?
175	NPRIO	Priority	char	1	0	CHAR	(N' ')	Yes	TCN07	NW_PRIO	Allow NULL?
176	PVZKN	Number of the task list node	nvarchar	8	0	NUMC	(N'00000000')	Yes		PLNKN	Allow NULL?
177	PHFLG	Indicator: Phase	char	1	0	CHAR	(N' ')	Yes		PHFLG	Allow NULL?
178	PHSEQ	Control Recipe Destination	nvarchar	2	0	CHAR	(N' ')	Yes	TC52	PHSEQ	Allow NULL?
179	KNOBJ	Number of Object with Assigned Dependencies	nvarchar	18	0	NUMC	(N'000000000000000000')	Yes		KNOBJ	Allow NULL?
180	ERFSICHT	Recording View	nvarchar	2	0	CHAR	(N' ')	Yes		QERFSICHT	Allow NULL?
181	PSPNR	Standard WBS element	nvarchar	8	0	NUMC	(N'00000000')	Yes	PRPSS	PS_SPS_ELE	Allow NULL?
182	QLOTYPE	Object Type	nvarchar	2	0	CHAR	(N' ')	Yes	T778O	OTYPE	Allow NULL?
183	QLOBJEKTID	Object ID	nvarchar	8	0	NUMC	(N'00000000')	Yes		OBJEKTID	Allow NULL?
184	QLKAPAR	Capacity category	nvarchar	3	0	CHAR	(N' ')	Yes	TC26	KAPART	Allow NULL?
185	QKZPRZEIT	Interval = Time (Time-Related)	char	1	0	CHAR	(N' ')	Yes		QKZPRZEIT	Allow NULL?
186	QKZZTMG1	Quantity Confirmation for Each Partial Lot	char	1	0	CHAR	(N' ')	Yes		QKZZTMG1	Allow NULL?
187	QKZPRMENG	Creation Cycle = Quantity (Quantity-Reference)	char	1	0	CHAR	(N' ')	Yes		QKZPRMENG	Allow NULL?
188	QKZPRFREI	Interval Without Reference to Time or Quantity	char	1	0	CHAR	(N' ')	Yes		QKZPRFREI	Allow NULL?
189	QRASTZEHT	Time Unit	nvarchar	3	0	UNIT	(N' ')	Yes	*	QRASTZEHT	Allow NULL?
190	QRASTZFAK	Time Factor	decimal	5	2	DEC	((0))	Yes		QRASTZFAK
191	QRASTMENG	Quantity Between Two Inspections	decimal	13	3	QUAN	((0))	Yes		QRASTMENG
192	QPPKTABS	Flow Variants for Inspection Point Completion	char	1	0	CHAR	(N' ')	Yes		QPPKTABS	Allow NULL?
193	KRIT1	Planning object	nvarchar	18	0	CHAR	(N' ')	Yes		PLOBJ	Allow NULL?
194	CLASSID	Internal Class Number	nvarchar	10	0	NUMC	(N'0000000000')	Yes	*	CLINT	Allow NULL?
195	PACKNO	Package number	nvarchar	10	0	NUMC	(N'0000000000')	Yes	*	PACKNO	Allow NULL?
196	EBELN	Purchasing Document Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	EBELN	Allow NULL?
197	EBELP	Item Number of Purchasing Document	nvarchar	5	0	NUMC	(N'00000')	Yes	EKPO	EBELP	Allow NULL?
198	CAPOC	Type of CAPP calculation at order creation	char	1	0	NUMC	(N'0')	Yes		CAPOC	Allow NULL?
199	FLG_CAPTXT	Ind: CAPP text exists	char	1	0	CHAR	(N' ')	Yes		FLG_CAPTXT	Allow NULL?
200	CN_WEIGHT	Aggregation weight for POC (PS progress)	decimal	8	0	DEC	((0))	Yes		EV_WEIGHTD
201	QKZTLSBEST	Operation with Stock-Related Partial Lot Assignment	char	1	0	CHAR	(N' ')	Yes		QKZTLSBEST	Allow NULL?
202	AUFKT	Execution Factor	decimal	3	0	DEC	((0))	Yes		AFAKT
203	DAFKT	Average execution factor	decimal	5	2	DEC	((0))	Yes		DFAKT
204	RWFAK	Rework factor (is not used yet)	decimal	5	3	DEC	((0))	Yes		RWFAK
205	AAUFG	Indicator: Work center operation set	char	1	0	CHAR	(N' ')	Yes		AAUFG	Allow NULL?
206	VERDART	Grouping Category	char	1	0	CHAR	(N' ')	Yes		VERDART	Allow NULL?
207	UAVO_AUFL	Suboper. do not apply to order	char	1	0	CHAR	(N' ')	Yes		UAVO_AUFL	Allow NULL?
208	FRDLB	Indicator: Externally processed op. with subcontracting	char	1	0	CHAR	(N' ')	Yes		CO_FRDLB	Allow NULL?
209	QPART	Inspection Type	nvarchar	8	0	CHAR	(N' ')	Yes	*	QPART	Allow NULL?
210	PRZ01	Business Process	nvarchar	12	0	CHAR	(N' ')	Yes	*	CO_PRZNR	Allow NULL?
211	TAKT	takt within a line segment	nvarchar	4	0	NUMC	(N'0000')	Yes		LD_TAKT	Allow NULL?
212	OPRID	External operation ID	nvarchar	8	0	CHAR	(N' ')	Yes		CP_OPRID	Allow NULL?
213	NVADD	Indicator for non-value-added operations	char	1	0	CHAR	(N' ')	Yes		LD_NVADD	Allow NULL?
214	EVGEW	Aggregation weight for POC (PS progress)	decimal	8	0	DEC	((0))	Yes		EV_WEIGHTD
215	RFPNT	Reference point for BOM transfer	nvarchar	20	0	CHAR	(N' ')	Yes	TCNRFP	CN_RFPNT	Allow NULL?
216	FLG_TSK_GROUP	Group operation	char	1	0	CHAR	(N' ')	Yes		FLG_TSK_GROUP_TYPE	Allow NULL?
217	ADPSP	Reference Element PM/PS	nvarchar	40	0	CHAR	(N' ')	Yes	*	ADDCOMPARE_CORE	Allow NULL?
218	SUBPLNAL	Subordinate Task List Group Counter	nvarchar	2	0	CHAR	(N' ')	No		SUBPLNAL	Allow NULL?
219	SUBPLNNR	Key for Subordinate Task List Group	nvarchar	8	0	CHAR	(N' ')	No		SUBPLNNR	Allow NULL?
220	SUBPLNTY	Task List Type: Subordinate Task List	char	1	0	CHAR	(N' ')	No	*	SUBPLNTY	Allow NULL?
221	XEXCLTL	Sign: Exclude Subordinate Task List (and in All Tree)	char	1	0	CHAR	(N' ')	No		XEXCLTL	Allow NULL?

TOP ERP 6.0 | /ISDFPS/TL1 INDEXES

Name	Primary	Unique	Type	Columns
/ISDFPS/TL1~0	Yes	Yes	CLUSTERED	ZAEHL, PLNKN, PLNNR, PLNTY, 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

221 COLUMNS | 1 INDEXES | ERP 6.0 | /ISDFPS/TL1 TABLE

TOP ERP 6.0 | /ISDFPS/TL1 COLUMNS

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

221 COLUMNS | 1 INDEXES | ERP 6.0 | /ISDFPS/TL1 TABLE

TOPERP 6.0 | /ISDFPS/TL1 COLUMNS

TOPERP 6.0 | /ISDFPS/TL1 INDEXES

TOP ERP 6.0 | /ISDFPS/TL1 COLUMNS

TOP ERP 6.0 | /ISDFPS/TL1 INDEXES