	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

	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

	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

161 COLUMNS | 3 INDEXES | ERP 6.0 | LTAP TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Logistics Execution :: Warehouse Management
1	ERP EHP7	6.0	LTAP	161	3	Transfer order item	Warehouse Management

SQL: selectupdate insert create

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

SELECT MANDT, LGNUM, TANUM, TAPOS, TBPOS, POSNR, MATNR, WERKS, CHARG, BESTQ, SOBKZ, SONUM, STOFF, MEINS, ALTME, UMREZ, UMREN, LETYP, KZFEH, LANUM, KZQUI, KZNKO, NULKO, KZINV, IVNUM, PQUIT, QDATU, QZEIT, QNAME, BRGEW, GEWEI, MBPOS, WEMPF, ABLAD, WDATU, WENUM, WEPOS, ZEUGN, LDEST, VORGA, VLTYP, VLBER, VLPLA, VKDYN, VPPOS, VANZL, VANBR, VSOLM, VISTM, VDIFM, VSOLA, VISTA, VDIFA, VLQNR, VAPPC, NLTYP, NLBER, NLPLA, NKDYN, NPPOS, NANZL, NANBR, NSOLM, NISTM, NDIFM, NSOLA, NISTA, NDIFA, NLQNR, NAPPC, RLTYP, RLBER, RLPLA, RPPOS, RSOLM, RISTM, RDIFM, RSOLA, RISTA, RDIFA, RLQNR, RAPPC, DLTYP, DLPLA, DLQNR, DMENG, DMENA, KZDIF, MAKTX, DRUCK, VLENR, NLENR, DLENR, VLEST, NLEST, LELAS, HOMVE, POSTY, ORPOS, VSUMM, VBLCH, NSUMM, NBLCH, RSPOS, VFDAT, VKAPV, VKAPA, NKAPA, RKAPA, KZSUB, QPLOS, QPLOA, KZSTI, RSART, KZECH, KOBER, LGORT, SOLPO, ZEIEI, L2SKR, VOLUM, VOLEH, KZBEF, IMREL, NWIRM, WIRME, NPLEI, KBNKZ, STOAN, KGVNQ, PVQUI, EDATU, EZEIT, ENAME, KZFME, QUSUB, FHUTA, VNEST, VHILM, VDUMM, NDUMM, VSERI, HUPIK, NXIDV, NOLIS, NPIPO, PIPAR, PCKPF, KZTRM, PASSD, VBELN, KZXDK, KZVAS, FROM_INSP_GUID, TO_INSP_GUID, DIFF_INSP_GUID, RETURN_INSP_GUID, DCNUM, ZRSTG, TOVAS, SGT_SCAT FROM LTAP

TOP ERP 6.0 | LTAP 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	*	MANDT	Allow NULL?
2	LGNUM	Warehouse Number / Warehouse Complex	nvarchar	3	0	CHAR	(N' ')	No	T300	LGNUM	Allow NULL?
3	TANUM	Transfer Order Number	nvarchar	10	0	NUMC	(N'0000000000')	No		TANUM	Allow NULL?
4	TAPOS	Transfer order item	nvarchar	4	0	NUMC	(N'0000')	No		TAPOS	Allow NULL?
5	TBPOS	Transfer Requirement Item	nvarchar	4	0	NUMC	(N'0000')	Yes		TBPOS	Allow NULL?
6	POSNR	Item number of the SD document	nvarchar	6	0	NUMC	(N'000000')	Yes	*	POSNR	Allow NULL?
7	MATNR	Material Number	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	MATNR	Allow NULL?
8	WERKS	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	WERKS_D	Allow NULL?
9	CHARG	Batch Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	CHARG_D	Allow NULL?
10	BESTQ	Stock Category in the Warehouse Management System	char	1	0	CHAR	(N' ')	Yes		BESTQ	Allow NULL?
11	SOBKZ	Special Stock Indicator	char	1	0	CHAR	(N' ')	Yes	T148	SOBKZ	Allow NULL?
12	SONUM	Special Stock Number	nvarchar	16	0	CHAR	(N' ')	Yes		LVS_SONUM	Allow NULL?
13	STOFF	Hazardous material number	nvarchar	18	0	CHAR	(N' ')	Yes	*	STOFF	Allow NULL?
14	MEINS	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
15	ALTME	Alternative Unit of Measure for Stockkeeping Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	LRMEI	Allow NULL?
16	UMREZ	Numerator for Conversion to Base Units of Measure	decimal	5	0	DEC	((0))	Yes		UMREZ
17	UMREN	Denominator for conversion to base units of measure	decimal	5	0	DEC	((0))	Yes		UMREN
18	LETYP	Storage Unit Type	nvarchar	3	0	CHAR	(N' ')	Yes	T307	LVS_LETYP	Allow NULL?
19	KZFEH	Indicator: pre-allocated stock	char	1	0	CHAR	(N' ')	Yes		LTAP_KZFEH	Allow NULL?
20	LANUM	Sequence number	nvarchar	3	0	NUMC	(N'000')	Yes		T310_LANUM	Allow NULL?
21	KZQUI	Indicator: confirmation required	char	1	0	CHAR	(N' ')	Yes		LTAP_KZQUI	Allow NULL?
22	KZNKO	Indicator: Execute Zero Stock Check	char	1	0	CHAR	(N' ')	Yes		LVS_KZNKO	Allow NULL?
23	NULKO	Status of zero stock check in transfer order item	char	1	0	NUMC	(N'0')	Yes		LTAP_NULKO	Allow NULL?
24	KZINV	Inventory indicators	nvarchar	2	0	CHAR	(N' ')	Yes		LTAP_KZINV	Allow NULL?
25	IVNUM	Number of system inventory record	nvarchar	10	0	CHAR	(N' ')	Yes		LVS_IVNUM	Allow NULL?
26	PQUIT	Indicator: confirmation complete	char	1	0	CHAR	(N' ')	Yes		LTAP_PQUIT	Allow NULL?
27	QDATU	Date of confirmation	nvarchar	8	0	DATS	(N'00000000')	Yes		LTAP_QDATU	Allow NULL?
28	QZEIT	Time of confirmation	nvarchar	6	0	TIMS	(N'000000')	Yes		LTAP_QZEIT	Allow NULL?
29	QNAME	User name	nvarchar	12	0	CHAR	(N' ')	Yes		LTAP_QNAME	Allow NULL?
30	BRGEW	Gross weight of transfer order item	decimal	11	3	DEC	((0))	Yes		LTAP_BRGEW
31	GEWEI	Weight Unit	nvarchar	3	0	UNIT	(N' ')	Yes	*	GEWEI	Allow NULL?
32	MBPOS	Item in Material Document	nvarchar	4	0	NUMC	(N'0000')	Yes		MBLPO	Allow NULL?
33	WEMPF	Goods Recipient/Ship-To Party	nvarchar	12	0	CHAR	(N' ')	Yes		WEMPF	Allow NULL?
34	ABLAD	Unloading Point	nvarchar	25	0	CHAR	(N' ')	Yes		ABLAD	Allow NULL?
35	WDATU	Date of Goods Receipt	nvarchar	8	0	DATS	(N'00000000')	Yes		LVS_WDATU	Allow NULL?
36	WENUM	Goods Receipt Number	nvarchar	10	0	CHAR	(N' ')	Yes		LVS_WENUM	Allow NULL?
37	WEPOS	Goods receipt item	nvarchar	4	0	NUMC	(N'0000')	Yes		LVS_WEPOS	Allow NULL?
38	ZEUGN	Certificate Number	nvarchar	10	0	CHAR	(N' ')	Yes		LVS_ZEUGN	Allow NULL?
39	LDEST	Name of printer	nvarchar	4	0	CHAR	(N' ')	Yes	TSP03	LVS_LDEST	Allow NULL?
40	VORGA	Transfer procedure	nvarchar	2	0	CHAR	(N' ')	Yes		LTAP_VORGA	Allow NULL?
41	VLTYP	Source Storage Type	nvarchar	3	0	CHAR	(N' ')	Yes	T301	LTAP_VLTYP	Allow NULL?
42	VLBER	Source storage section	nvarchar	3	0	CHAR	(N' ')	Yes	T302	LTAP_VLBER	Allow NULL?
43	VLPLA	Source Storage Bin	nvarchar	10	0	CHAR	(N' ')	Yes	*	LTAP_VLPLA	Allow NULL?
44	VKDYN	Indicator: dynamic storage bin	char	1	0	CHAR	(N' ')	Yes		LVS_KZDYN	Allow NULL?
45	VPPOS	Position in source storage bin	nvarchar	2	0	CHAR	(N' ')	Yes		LTAP_VPPOS	Allow NULL?
46	VANZL	Number of storage units to be transferred from bulk storage	decimal	9	3	DEC	((0))	Yes		LTAP_VANZL
47	VANBR	Indicator: partial pallet quantity exists	char	1	0	CHAR	(N' ')	Yes		LTAP_VANBR	Allow NULL?
48	VSOLM	Source target quantity in stockkeeping unit	decimal	13	3	QUAN	((0))	Yes		LTAP_VSOLM
49	VISTM	Source actual quantity in stockkeeping unit	decimal	13	3	QUAN	((0))	Yes		LTAP_VISTM
50	VDIFM	Difference in source storage bin in stockkeeping unit	decimal	13	3	QUAN	((0))	Yes		LTAP_VDIFM
51	VSOLA	Source target quantity in alternate unit	decimal	13	3	QUAN	((0))	Yes		LTAP_VSOLA
52	VISTA	Source actual quantity in alternative unit of measure	decimal	13	3	QUAN	((0))	Yes		LTAP_VISTA
53	VDIFA	Difference in source storage bin in alternative unit	decimal	13	3	QUAN	((0))	Yes		LTAP_VDIFA
54	VLQNR	Quant	nvarchar	10	0	NUMC	(N'0000000000')	Yes		LVS_LQNUM	Allow NULL?
55	VAPPC	Ind.: Pass on source item to APPC interface	char	1	0	CHAR	(N' ')	Yes		LTAP_VAPPC	Allow NULL?
56	NLTYP	Destination Storage Type	nvarchar	3	0	CHAR	(N' ')	Yes	T301	LTAP_NLTYP	Allow NULL?
57	NLBER	Destination storage section	nvarchar	3	0	CHAR	(N' ')	Yes	T302	LTAP_NLBER	Allow NULL?
58	NLPLA	Destination Storage Bin	nvarchar	10	0	CHAR	(N' ')	Yes	*	LTAP_NLPLA	Allow NULL?
59	NKDYN	Indicator: dynamic storage bin	char	1	0	CHAR	(N' ')	Yes		LVS_KZDYN	Allow NULL?
60	NPPOS	Position in destination storage bin	nvarchar	2	0	CHAR	(N' ')	Yes		LTAP_NPPOS	Allow NULL?
61	NANZL	Number of storage units to be transferred to bulk storage	decimal	9	3	DEC	((0))	Yes		LTAP_NANZL
62	NANBR	Indicator: partial pallet quantity exists	char	1	0	CHAR	(N' ')	Yes		LTAP_NANBR	Allow NULL?
63	NSOLM	Destination target quantity in stockkeeping unit	decimal	13	3	QUAN	((0))	Yes		LTAP_NSOLM
64	NISTM	Destination actual quantity in stockkeeping unit	decimal	13	3	QUAN	((0))	Yes		LTAP_NISTM
65	NDIFM	Destination difference quantity in stockkeeping unit	decimal	13	3	QUAN	((0))	Yes		LTAP_NDIFM
66	NSOLA	Destination target quantity in alternative unit	decimal	13	3	QUAN	((0))	Yes		LTAP_NSOLA
67	NISTA	Actual destination quantity in alternative unit	decimal	13	3	QUAN	((0))	Yes		LTAP_NISTA
68	NDIFA	Destination difference qty. in alternative unit	decimal	13	3	QUAN	((0))	Yes		LTAP_NDIFA
69	NLQNR	Quant	nvarchar	10	0	NUMC	(N'0000000000')	Yes		LVS_LQNUM	Allow NULL?
70	NAPPC	Indicator: pass on destination item to APPC interface	char	1	0	CHAR	(N' ')	Yes		LTAP_NAPPC	Allow NULL?
71	RLTYP	Return storage type	nvarchar	3	0	CHAR	(N' ')	Yes	T301	LTAP_RLTYP	Allow NULL?
72	RLBER	Return storage area	nvarchar	3	0	CHAR	(N' ')	Yes	T302	LTAP_RLBER	Allow NULL?
73	RLPLA	Return storage bin	nvarchar	10	0	CHAR	(N' ')	Yes	*	LTAP_RLPLA	Allow NULL?
74	RPPOS	Position in return storage bin	nvarchar	2	0	CHAR	(N' ')	Yes		LTAP_RPPOS	Allow NULL?
75	RSOLM	Return target quantity in stockkeeping unit	decimal	13	3	QUAN	((0))	Yes		LTAP_RSOLM
76	RISTM	Actual returned quantity in stockkeeping unit	decimal	13	3	QUAN	((0))	Yes		LTAP_RISTM
77	RDIFM	Return difference quantity in stockkeeping unit	decimal	13	3	QUAN	((0))	Yes		LTAP_RDIFM
78	RSOLA	Return target quantity in alternative unit	decimal	13	3	QUAN	((0))	Yes		LTAP_RSOLA
79	RISTA	Actual return quantity in alternate unit of measure	decimal	13	3	QUAN	((0))	Yes		LTAP_RISTA
80	RDIFA	Return difference quantity in alternative unit	decimal	13	3	QUAN	((0))	Yes		LTAP_RDIFA
81	RLQNR	Quant	nvarchar	10	0	NUMC	(N'0000000000')	Yes		LVS_LQNUM	Allow NULL?
82	RAPPC	Indicator: pass on return item to APPC interface	char	1	0	CHAR	(N' ')	Yes		LTAP_RAPPC	Allow NULL?
83	DLTYP	Difference storage type	nvarchar	3	0	CHAR	(N' ')	Yes	*	LTAP_DLTYP	Allow NULL?
84	DLPLA	Difference storage bin	nvarchar	10	0	CHAR	(N' ')	Yes	*	LTAP_DLPLA	Allow NULL?
85	DLQNR	Difference quant	nvarchar	10	0	NUMC	(N'0000000000')	Yes		LTAP_DLQNR	Allow NULL?
86	DMENG	Quantity of difference posting in stockkeeping unit	decimal	13	3	QUAN	((0))	Yes		LTAP_DMENG
87	DMENA	Difference quantity in alternate unit of measure	decimal	13	3	QUAN	((0))	Yes		LTAP_DMENA
88	KZDIF	Difference indicator	char	1	0	CHAR	(N' ')	Yes	T336	LVS_KZDIF	Allow NULL?
89	MAKTX	Material Description (Short Text)	nvarchar	40	0	CHAR	(N' ')	Yes		MAKTX	Allow NULL?
90	DRUCK	Indicator: transfer order item is printed	char	1	0	CHAR	(N' ')	Yes		LVS_DRUCK	Allow NULL?
91	VLENR	Source storage unit number	nvarchar	20	0	CHAR	(N' ')	Yes	LEIN	LTAP_VLENR	Allow NULL?
92	NLENR	Destination storage unit number	nvarchar	20	0	CHAR	(N' ')	Yes	LEIN	LTAP_NLENR	Allow NULL?
93	DLENR	Number of storage unit for difference quantities	nvarchar	20	0	CHAR	(N' ')	Yes	LEIN	LTAP_DLENR	Allow NULL?
94	VLEST	Status of source storage unit	char	1	0	CHAR	(N' ')	Yes		LTAP_VLEST	Allow NULL?
95	NLEST	Status of destination storage unit	char	1	0	CHAR	(N' ')	Yes		LTAP_NLEST	Allow NULL?
96	LELAS	Indicator: print storage unit contents	char	1	0	CHAR	(N' ')	Yes		LTAP_LELAS	Allow NULL?
97	HOMVE	Indicator: stock removal of a total, homogenous storage unit	char	1	0	CHAR	(N' ')	Yes		LTAP_HOMVE	Allow NULL?
98	POSTY	Type of transfer order item	char	1	0	CHAR	(N' ')	Yes		LTAP_POSTY	Allow NULL?
99	ORPOS	TO item from which current TO item was generated	nvarchar	4	0	NUMC	(N'0000')	Yes		LTAP_ORPOS	Allow NULL?
100	VSUMM	Level of totals information SOURCE	char	1	0	CHAR	(N' ')	Yes		LTAP_VSUMM	Allow NULL?
101	VBLCH	Blocks with mixed batches SOURCE	char	1	0	CHAR	(N' ')	Yes		LTAP_VBLCH	Allow NULL?
102	NSUMM	Level of totals information DEST.	char	1	0	CHAR	(N' ')	Yes		LTAP_NSUMM	Allow NULL?
103	NBLCH	Blocks with mixed batches DEST	char	1	0	CHAR	(N' ')	Yes		LTAP_NBLCH	Allow NULL?
104	RSPOS	Item Number of Reservation/Dependent Requirement	nvarchar	4	0	NUMC	(N'0000')	Yes		RSPOS	Allow NULL?
105	VFDAT	Shelf Life Expiration or Best-Before Date	nvarchar	8	0	DATS	(N'00000000')	Yes		VFDAT	Allow NULL?
106	VKAPV	Capacity usage of transferred material	decimal	11	3	DEC	((0))	Yes		LTAP_VKAPV
107	VKAPA	Capacity check for source storage type	char	1	0	CHAR	(N' ')	Yes		LTAP_VKAPA	Allow NULL?
108	NKAPA	Capacity check for destination storage type	char	1	0	CHAR	(N' ')	Yes		LTAP_NKAPA	Allow NULL?
109	RKAPA	Capacity check return storage type	char	1	0	CHAR	(N' ')	Yes		LTAP_RKAPA	Allow NULL?
110	KZSUB	Indicator: pass on TO item to subsystem	char	1	0	CHAR	(N' ')	Yes		LTAP_KZSUB	Allow NULL?
111	QPLOS	Inspection Lot Number	nvarchar	12	0	NUMC	(N'000000000000')	Yes	*	QPLOS	Allow NULL?
112	QPLOA	Inspection Lot on Which the Usage Decision is Based	nvarchar	12	0	NUMC	(N'000000000000')	Yes	*	QPLOA	Allow NULL?
113	KZSTI	Indicator: transfer of insp.sample	char	1	0	CHAR	(N' ')	Yes		LTAP_KZSTI	Allow NULL?
114	RSART	Record type	char	1	0	CHAR	(N' ')	Yes		RSART	Allow NULL?
115	KZECH	Indicator: Confirm Batch to PP	char	1	0	CHAR	(N' ')	Yes		LVS_KZECH	Allow NULL?
116	KOBER	Picking Area	nvarchar	3	0	CHAR	(N' ')	Yes	*	KOBER	Allow NULL?
117	LGORT	Storage Location	nvarchar	4	0	CHAR	(N' ')	Yes	T001L	LGORT_D	Allow NULL?
118	SOLPO	Planned proc.time in transfer order item	decimal	13	3	QUAN	((0))	Yes		LTAP_SOLPO
119	ZEIEI	Time unit for performance data	nvarchar	3	0	UNIT	(N' ')	Yes	T006	LVS_ZEIEI	Allow NULL?
120	L2SKR	Relevance for 2-step picking	char	1	0	CHAR	(N' ')	Yes		LVS_2SKREL	Allow NULL?
121	VOLUM	Volume	decimal	13	3	QUAN	((0))	Yes		VOLUM
122	VOLEH	Volume unit	nvarchar	3	0	UNIT	(N' ')	Yes	*	VOLEH	Allow NULL?
123	KZBEF	Indicator Inventory Management active	char	1	0	CHAR	(N' ')	Yes		LVS_KZBEF	Allow NULL?
124	IMREL	Trigger posting in Inventory Management	char	1	0	CHAR	(N' ')	Yes		LVS_IMREL	Allow NULL?
125	NWIRM	Transferred ingredient qty	decimal	13	3	QUAN	((0))	Yes		LTAP_NWIRM
126	WIRME	Active ingredient unit of measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	LTAP_WIRME	Allow NULL?
127	NPLEI	Dest.stor.bin changeable during confirmation	char	1	0	CHAR	(N' ')	Yes		LVS_NPLEI	Allow NULL?
128	KBNKZ	Kanban Indicator	char	1	0	CHAR	(N' ')	Yes		KBNKZ	Allow NULL?
129	STOAN	Cancellation req. for TO item (currently only from Kanban)	char	1	0	CHAR	(N' ')	Yes		LVS_STOAN	Allow NULL?
130	KGVNQ	Indicator: Separate confirmation possible	char	1	0	CHAR	(N' ')	Yes		LVS_KGVNQ	Allow NULL?
131	PVQUI	Indicator: Material pick has been confirmed	char	1	0	CHAR	(N' ')	Yes		LTAP_PVQUI	Allow NULL?
132	EDATU	Date of Pick Confirmation (First Step)	nvarchar	8	0	DATS	(N'00000000')	Yes		LTAP_EDATU	Allow NULL?
133	EZEIT	Time of Pick Confirmation (First Step)	nvarchar	6	0	TIMS	(N'000000')	Yes		LTAP_EZEIT	Allow NULL?
134	ENAME	User Name in Pick Confirmation (First Step)	nvarchar	12	0	CHAR	(N' ')	Yes		LTAP_ENAME	Allow NULL?
135	KZFME	ID: Leading unit of measure for completing a transaction	char	1	0	CHAR	(N' ')	Yes		KZFME	Allow NULL?
136	QUSUB	Confirmation ind.: Two-step confirmation for external system	char	1	0	CHAR	(N' ')	Yes		LTAP_QUSUB	Allow NULL?
137	FHUTA	Flag: Transfer order item is HU TO item	char	1	0	CHAR	(N' ')	Yes		LTAP_FHUTA	Allow NULL?
138	VNEST	Indicates whether the source storage unit is a nested HU	char	1	0	CHAR	(N' ')	Yes		VLEIN_NEST	Allow NULL?
139	VHILM	Packaging Materials	nvarchar	18	0	CHAR	(N' ')	Yes	*	VHILM	Allow NULL?
140	VDUMM	Indicator: Source SU is pseudo SU (only HUs)	char	1	0	CHAR	(N' ')	Yes		LTAP_VDUMM	Allow NULL?
141	NDUMM	Indicator: Destination SU is pseudo SU (only HUs)	char	1	0	CHAR	(N' ')	Yes		LTAP_NDUMM	Allow NULL?
142	VSERI	Indicator: Source SU is a HU with serial numbers	char	1	0	CHAR	(N' ')	Yes		LTAP_VSERI	Allow NULL?
143	HUPIK	Indicator: source HU suggested as pick HU at confirmation	char	1	0	CHAR	(N' ')	Yes		LTAP_HUPIK	Allow NULL?
144	NXIDV	External Handling Unit Identification	nvarchar	20	0	CHAR	(N' ')	Yes		EXIDV	Allow NULL?
145	NOLIS	Flag: Do not update whse controlling during TO creation	char	1	0	CHAR	(N' ')	Yes		LTAP_NOLIS	Allow NULL?
146	NPIPO	Flag: Do not transfer SU to pick point (for SU block stor.)	char	1	0	CHAR	(N' ')	Yes		LTAP_NPIPO	Allow NULL?
147	PIPAR	Assignment of TO item to handling unit is required	char	1	0	CHAR	(N' ')	Yes		LTAP_PIPAR	Allow NULL?
148	PCKPF	Packing control	char	1	0	CHAR	(N' ')	Yes		PCKPF	Allow NULL?
149	KZTRM	TRM Interface Active	char	1	0	CHAR	(N' ')	Yes		LTAP_KZTRM	Allow NULL?
150	PASSD	Confirmation Data Transferred To Delivery	char	1	0	CHAR	(N' ')	Yes		LTAP_PASSD	Allow NULL?
151	VBELN	Delivery	nvarchar	10	0	CHAR	(N' ')	Yes	*	VBELN_VL	Allow NULL?
152	KZXDK	Cross dock interface	char	1	0	CHAR	(N' ')	Yes		LTAP_KZXDK	Allow NULL?
153	KZVAS	Value added service interface	char	1	0	CHAR	(N' ')	Yes		LTAP_KZVAS	Allow NULL?
154	FROM_INSP_GUID	Inspection GUID	varbinary	16	0	RAW		Yes		MSR_INSP_GUID
155	TO_INSP_GUID	Inspection GUID	varbinary	16	0	RAW		Yes		MSR_INSP_GUID
156	DIFF_INSP_GUID	Inspection GUID	varbinary	16	0	RAW		Yes		MSR_INSP_GUID
157	RETURN_INSP_GUID	Inspection GUID	varbinary	16	0	RAW		Yes		MSR_INSP_GUID
158	DCNUM	Cross-Docking Decision Number	nvarchar	14	0	NUMC	(N'00000000000000')	Yes		LXDCK_DCNUM	Allow NULL?
159	ZRSTG	General Flag	char	1	0	CHAR	(N' ')	Yes		FLAG	Allow NULL?
160	TOVAS	General Flag	char	1	0	CHAR	(N' ')	Yes		FLAG	Allow NULL?
161	SGT_SCAT	Stock Segment	nvarchar	16	0	CHAR	(N' ')	Yes		SGT_SCAT	Allow NULL?

TOP ERP 6.0 | LTAP INDEXES

Name	Primary	Unique	Type	Columns
LTAP~0	Yes	Yes	CLUSTERED	TAPOS, TANUM, LGNUM, MANDT
LTAP~M	No	No	NONCLUSTERED	MATNR, PQUIT, LGNUM, MANDT
LTAP~V	No	No	NONCLUSTERED	VLPLA, VLTYP, PQUIT, LGNUM, 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

161 COLUMNS | 3 INDEXES | ERP 6.0 | LTAP TABLE

TOP ERP 6.0 | LTAP COLUMNS

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

161 COLUMNS | 3 INDEXES | ERP 6.0 | LTAP TABLE

TOPERP 6.0 | LTAP COLUMNS

TOPERP 6.0 | LTAP INDEXES

TOP ERP 6.0 | LTAP COLUMNS

TOP ERP 6.0 | LTAP INDEXES