	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	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	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

179 COLUMNS | 2 INDEXES | ERP 6.0 | LIKP TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Logistics Execution :: Shipping
1	ERP EHP7	6.0	LIKP	179	2	SD Document: Delivery Header Data	Shipping

SQL: selectupdate insert create

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

SELECT MANDT, VBELN, ERNAM, ERZET, ERDAT, BZIRK, VSTEL, VKORG, LFART, AUTLF, KZAZU, WADAT, LDDAT, TDDAT, LFDAT, KODAT, ABLAD, INCO1, INCO2, EXPKZ, ROUTE, FAKSK, LIFSK, VBTYP, KNFAK, TPQUA, TPGRP, LPRIO, VSBED, KUNNR, KUNAG, KDGRP, STZKL, STZZU, BTGEW, NTGEW, GEWEI, VOLUM, VOLEH, ANZPK, BEROT, LFUHR, GRULG, LSTEL, TRAGR, FKARV, FKDAT, PERFK, ROUTA, STAFO, KALSM, KNUMV, WAERK, VKBUR, VBEAK, ZUKRL, VERUR, COMMN, STWAE, STCUR, EXNUM, AENAM, AEDAT, LGNUM, LISPL, VKOIV, VTWIV, SPAIV, FKAIV, PIOIV, FKDIV, KUNIV, KKBER, KNKLI, GRUPP, SBGRP, CTLPC, CMWAE, AMTBL, BOLNR, LIFNR, TRATY, TRAID, CMFRE, CMNGV, XABLN, BLDAT, WADAT_IST, TRSPG, TPSID, LIFEX, TERNR, KALSM_CH, KLIEF, KALSP, KNUMP, NETWR, AULWE, WERKS, LCNUM, ABSSC, KOUHR, TDUHR, LDUHR, WAUHR, LGTOR, LGBZO, AKWAE, AKKUR, AKPRZ, PROLI, XBLNR, HANDLE, TSEGFL, TSEGTP, TZONIS, TZONRC, CONT_DG, VERURSYS, KZWAB, VLSTK, TCODE, VSART, TRMTYP, SDABW, VBUND, XWOFF, DIRTA, PRVBE, FOLAR, PODAT, POTIM, VGANZ, IMWRK, SPE_LOEKZ, SPE_LOC_SEQ, SPE_ACC_APP_STS, SPE_SHP_INF_STS, SPE_RET_CANC, SPE_WAUHR_IST, SPE_WAZONE_IST, SPE_REV_VLSTK, SPE_LE_SCENARIO, SPE_ORIG_SYS, SPE_CHNG_SYS, SPE_GEOROUTE, SPE_GEOROUTEIND, SPE_CARRIER_IND, SPE_GTS_REL, SPE_GTS_RT_CDE, SPE_REL_TMSTMP, SPE_UNIT_SYSTEM, SPE_INV_BFR_GI, SPE_QI_STATUS, SPE_RED_IND, SAKES, SPE_LIFEX_TYPE, SPE_TTYPE, SPE_PRO_NUMBER, LOC_GUID, SPE_BILLING_IND, PRINTER_PROFILE, MSR_ACTIVE, PRTNR, STGE_LOC_CHANGE, TM_CTRL_KEY, DLV_SPLIT_INITIA, DLV_VERSION, HANDOVERLOC, HANDOVERDATE, HANDOVERTIME, HANDOVERTZONE, /BEV1/LULEINH, /BEV1/RPFAESS, /BEV1/RPKIST, /BEV1/RPCONT, /BEV1/RPSONST, /BEV1/RPFLGNR, BORGR_GRP FROM LIKP

TOP ERP 6.0 | LIKP 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	VBELN	Delivery	nvarchar	10	0	CHAR	(N' ')	No	VBUK	VBELN_VL	Allow NULL?
3	ERNAM	Name of Person who Created the Object	nvarchar	12	0	CHAR	(N' ')	Yes		ERNAM	Allow NULL?
4	ERZET	Entry time	nvarchar	6	0	TIMS	(N'000000')	Yes		ERZET	Allow NULL?
5	ERDAT	Date on Which Record Was Created	nvarchar	8	0	DATS	(N'00000000')	Yes		ERDAT	Allow NULL?
6	BZIRK	Sales district	nvarchar	6	0	CHAR	(N' ')	Yes	T171	BZIRK	Allow NULL?
7	VSTEL	Shipping Point/Receiving Point	nvarchar	4	0	CHAR	(N' ')	Yes	TVST	VSTEL	Allow NULL?
8	VKORG	Sales Organization	nvarchar	4	0	CHAR	(N' ')	Yes	TVKO	VKORG	Allow NULL?
9	LFART	Delivery Type	nvarchar	4	0	CHAR	(N' ')	Yes	TVLK	LFART	Allow NULL?
10	AUTLF	Complete delivery defined for each sales order?	char	1	0	CHAR	(N' ')	Yes		AUTLF	Allow NULL?
11	KZAZU	Order Combination Indicator	char	1	0	CHAR	(N' ')	Yes		KZAZU_D	Allow NULL?
12	WADAT	Planned goods movement date	nvarchar	8	0	DATS	(N'00000000')	Yes		WADAK	Allow NULL?
13	LDDAT	Loading Date	nvarchar	8	0	DATS	(N'00000000')	Yes		LDDAT	Allow NULL?
14	TDDAT	Transportation Planning Date	nvarchar	8	0	DATS	(N'00000000')	Yes		TDDAT_D	Allow NULL?
15	LFDAT	Delivery Date	nvarchar	8	0	DATS	(N'00000000')	Yes		LFDAT_V	Allow NULL?
16	KODAT	Picking Date	nvarchar	8	0	DATS	(N'00000000')	Yes		KODAT	Allow NULL?
17	ABLAD	Unloading Point	nvarchar	25	0	CHAR	(N' ')	Yes		ABLAD	Allow NULL?
18	INCO1	Incoterms (Part 1)	nvarchar	3	0	CHAR	(N' ')	Yes	TINC	INCO1	Allow NULL?
19	INCO2	Incoterms (Part 2)	nvarchar	28	0	CHAR	(N' ')	Yes		INCO2	Allow NULL?
20	EXPKZ	Export indicator	char	1	0	CHAR	(N' ')	Yes		EXPKZ	Allow NULL?
21	ROUTE	Route	nvarchar	6	0	CHAR	(N' ')	Yes	TVRO	ROUTE	Allow NULL?
22	FAKSK	Billing block in SD document	nvarchar	2	0	CHAR	(N' ')	Yes	TVFS	FAKSK	Allow NULL?
23	LIFSK	Delivery block (document header)	nvarchar	2	0	CHAR	(N' ')	Yes	TVLS	LIFSK	Allow NULL?
24	VBTYP	SD document category	char	1	0	CHAR	(N' ')	Yes		VBTYP	Allow NULL?
25	KNFAK	Customer factory calendar	nvarchar	2	0	CHAR	(N' ')	Yes	TFACD	KNFAK	Allow NULL?
26	TPQUA	not currently in use	char	1	0	CHAR	(N' ')	Yes		TPQUA	Allow NULL?
27	TPGRP	not currently in use	nvarchar	2	0	CHAR	(N' ')	Yes		TPGRP	Allow NULL?
28	LPRIO	Delivery Priority	nvarchar	2	0	NUMC	(N'00')	Yes	TPRIO	LPRIO	Allow NULL?
29	VSBED	Shipping Conditions	nvarchar	2	0	CHAR	(N' ')	Yes	TVSB	VSBED	Allow NULL?
30	KUNNR	Ship-to party	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	KUNWE	Allow NULL?
31	KUNAG	Sold-to party	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	KUNAG	Allow NULL?
32	KDGRP	Customer group	nvarchar	2	0	CHAR	(N' ')	Yes	T151	KDGRP	Allow NULL?
33	STZKL	Not Currently in Use	decimal	3	2	DEC	((0))	Yes		STZKL
34	STZZU	not currently in use	decimal	3	0	DEC	((0))	Yes		STZZU
35	BTGEW	Total Weight	decimal	15	3	QUAN	((0))	Yes		GSGEW
36	NTGEW	Net weight	decimal	15	3	QUAN	((0))	Yes		NTGEW_15
37	GEWEI	Weight Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	GEWEI	Allow NULL?
38	VOLUM	Volume	decimal	15	3	QUAN	((0))	Yes		VOLUM_15
39	VOLEH	Volume unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	VOLEH	Allow NULL?
40	ANZPK	Total number of packages in delivery	nvarchar	5	0	NUMC	(N'00000')	Yes		ANZPK	Allow NULL?
41	BEROT	Picked items location	nvarchar	20	0	CHAR	(N' ')	Yes		BEROT	Allow NULL?
42	LFUHR	Time of delivery	nvarchar	6	0	TIMS	(N'000000')	Yes		LFUHR	Allow NULL?
43	GRULG	Weight group for delivery (To group)	nvarchar	4	0	CHAR	(N' ')	Yes	TVLG	GRULG	Allow NULL?
44	LSTEL	Loading Point	nvarchar	2	0	CHAR	(N' ')	Yes	TVLA	LSTEL	Allow NULL?
45	TRAGR	Transportation Group	nvarchar	4	0	CHAR	(N' ')	Yes	TTGR	TRAGR	Allow NULL?
46	FKARV	Proposed billing type for a delivery-related billing doc.	nvarchar	4	0	CHAR	(N' ')	Yes	TVFK	FKARV	Allow NULL?
47	FKDAT	Billing date for billing index and printout	nvarchar	8	0	DATS	(N'00000000')	Yes		FKDAT	Allow NULL?
48	PERFK	Invoice dates (calendar identification)	nvarchar	2	0	CHAR	(N' ')	Yes	TFACD	PERFK	Allow NULL?
49	ROUTA	Route	nvarchar	6	0	CHAR	(N' ')	Yes	TVRO	ROUTE	Allow NULL?
50	STAFO	Update group for statistics update	nvarchar	6	0	CHAR	(N' ')	Yes	*	STAFO	Allow NULL?
51	KALSM	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	nvarchar	6	0	CHAR	(N' ')	Yes	T683	KALSM_D	Allow NULL?
52	KNUMV	Number of the document condition	nvarchar	10	0	CHAR	(N' ')	Yes		KNUMV	Allow NULL?
53	WAERK	SD Document Currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERK	Allow NULL?
54	VKBUR	Sales Office	nvarchar	4	0	CHAR	(N' ')	Yes	TVBUR	VKBUR	Allow NULL?
55	VBEAK	Shipping processing time for the entire document	decimal	6	2	DEC	((0))	Yes		VBEAK
56	ZUKRL	Combination criteria for delivery	nvarchar	40	0	CHAR	(N' ')	Yes		DZUKRL	Allow NULL?
57	VERUR	Distribution delivery	nvarchar	35	0	CHAR	(N' ')	Yes		VERUR_VL	Allow NULL?
58	COMMN	Communication number for Q-API interface	nvarchar	5	0	CHAR	(N' ')	Yes	TQCOM	COMMN	Allow NULL?
59	STWAE	Statistics currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	STWAE	Allow NULL?
60	STCUR	Exchange rate for statistics	decimal	9	5	DEC	((0))	Yes		STCUR
61	EXNUM	Number of foreign trade data in MM and SD documents	nvarchar	10	0	CHAR	(N' ')	Yes	EIKP	EXNUM	Allow NULL?
62	AENAM	Name of Person Who Changed Object	nvarchar	12	0	CHAR	(N' ')	Yes		AENAM	Allow NULL?
63	AEDAT	Changed On	nvarchar	8	0	DATS	(N'00000000')	Yes		AEDAT	Allow NULL?
64	LGNUM	Warehouse Number / Warehouse Complex	nvarchar	3	0	CHAR	(N' ')	Yes	T300	LGNUM	Allow NULL?
65	LISPL	Delivery within one warehouse	char	1	0	CHAR	(N' ')	Yes		LNSPL_LIKP	Allow NULL?
66	VKOIV	Sales organization for intercompany billing	nvarchar	4	0	CHAR	(N' ')	Yes	TVKO	VKOIV	Allow NULL?
67	VTWIV	Distribution channel for intercompany billing	nvarchar	2	0	CHAR	(N' ')	Yes	TVTW	VTWIV	Allow NULL?
68	SPAIV	Division for intercompany billing	nvarchar	2	0	CHAR	(N' ')	Yes	TSPA	SPAIV	Allow NULL?
69	FKAIV	Billing type for intercompany billing	nvarchar	4	0	CHAR	(N' ')	Yes	TVFK	FKAIV	Allow NULL?
70	PIOIV	Date for intercompany billing	nvarchar	2	0	CHAR	(N' ')	Yes	TFACD	PIOIV	Allow NULL?
71	FKDIV	Billing date for intercompany billing	nvarchar	8	0	DATS	(N'00000000')	Yes		FKDIV	Allow NULL?
72	KUNIV	Customer number for intercompany billing	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	KUNIV	Allow NULL?
73	KKBER	Credit control area	nvarchar	4	0	CHAR	(N' ')	Yes	T014	KKBER	Allow NULL?
74	KNKLI	Customer's account number with credit limit reference	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	KNKLI	Allow NULL?
75	GRUPP	Customer Credit Group	nvarchar	4	0	CHAR	(N' ')	Yes	*	GRUPP_CM	Allow NULL?
76	SBGRP	Credit representative group for credit management	nvarchar	3	0	CHAR	(N' ')	Yes	T024B	SBGRP_CM	Allow NULL?
77	CTLPC	Credit management: Risk category	nvarchar	3	0	CHAR	(N' ')	Yes	T691A	CTLPC_CM	Allow NULL?
78	CMWAE	Currency key of credit control area	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS_CM	Allow NULL?
79	AMTBL	Released credit value of the document	decimal	15	2	CURR	((0))	Yes		AMTBL_CM
80	BOLNR	Bill of lading	nvarchar	35	0	CHAR	(N' ')	Yes		BOLNR	Allow NULL?
81	LIFNR	Vendor Account Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	ELIFN	Allow NULL?
82	TRATY	Means-of-Transport Type	nvarchar	4	0	CHAR	(N' ')	Yes	TVTY	TRATY	Allow NULL?
83	TRAID	Means of Transport ID	nvarchar	20	0	CHAR	(N' ')	Yes		TRAID	Allow NULL?
84	CMFRE	Release date of the document determined by credit management	nvarchar	8	0	DATS	(N'00000000')	Yes		CMFRE	Allow NULL?
85	CMNGV	Next date	nvarchar	8	0	DATS	(N'00000000')	Yes		CMNGV	Allow NULL?
86	XABLN	Goods Receipt/Issue Slip Number	nvarchar	10	0	CHAR	(N' ')	Yes		XABLN	Allow NULL?
87	BLDAT	Document Date in Document	nvarchar	8	0	DATS	(N'00000000')	Yes		BLDAT	Allow NULL?
88	WADAT_IST	Actual Goods Movement Date	nvarchar	8	0	DATS	(N'00000000')	Yes		WADAT_IST	Allow NULL?
89	TRSPG	Shipment Blocking Reason	nvarchar	2	0	CHAR	(N' ')	Yes	TTSG	TRSPG	Allow NULL?
90	TPSID	ID for external transport system	nvarchar	5	0	CHAR	(N' ')	Yes	TQCOM	TPSID	Allow NULL?
91	LIFEX	External Identification of Delivery Note	nvarchar	35	0	CHAR	(N' ')	Yes		LIFEX	Allow NULL?
92	TERNR	Order Number	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	AUFNR	Allow NULL?
93	KALSM_CH	Search procedure for batch determination	nvarchar	6	0	CHAR	(N' ')	Yes	T683	KALSMA_CH	Allow NULL?
94	KLIEF	Correction delivery	char	1	0	CHAR	(N' ')	Yes		KLIEF	Allow NULL?
95	KALSP	Shipping: Pricing procedure	nvarchar	6	0	CHAR	(N' ')	Yes	T683	KALSP	Allow NULL?
96	KNUMP	Number of document condition - pricing	nvarchar	10	0	CHAR	(N' ')	Yes		KNUMP	Allow NULL?
97	NETWR	Net Value of the Sales Order in Document Currency	decimal	15	2	CURR	((0))	Yes		NETWR_AK
98	AULWE	Route Schedule	nvarchar	10	0	CHAR	(N' ')	Yes	VALW	AULWE	Allow NULL?
99	WERKS	Receiving plant for deliveries	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	EMPFW	Allow NULL?
100	LCNUM	Financial doc. processing: Internal financial doc. number	nvarchar	10	0	CHAR	(N' ')	Yes	AKKP	LCNUM	Allow NULL?
101	ABSSC	Payment guarantee procedure	nvarchar	6	0	CHAR	(N' ')	Yes	T691M	ABSSCHE_CM	Allow NULL?
102	KOUHR	Picking time (local time, with reference to a plant)	nvarchar	6	0	TIMS	(N'000000')	Yes		KOUHR	Allow NULL?
103	TDUHR	Transp. Planning Time (Local, Relating to a Shipping Point)	nvarchar	6	0	TIMS	(N'000000')	Yes		TDUHR	Allow NULL?
104	LDUHR	Loading Time (Local Time Relating to a Shipping Point)	nvarchar	6	0	TIMS	(N'000000')	Yes		LDUHR	Allow NULL?
105	WAUHR	Time of Goods Issue (Local, Relating to a Plant)	nvarchar	6	0	TIMS	(N'000000')	Yes		WAUHR	Allow NULL?
106	LGTOR	Door for Warehouse Number	nvarchar	3	0	CHAR	(N' ')	Yes	T30B	LGTOR	Allow NULL?
107	LGBZO	Staging Area for Warehouse Complex	nvarchar	10	0	CHAR	(N' ')	Yes	T30C	LGBZO	Allow NULL?
108	AKWAE	Currency key for letter-of-credit procg in foreign trade	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	AKWAE	Allow NULL?
109	AKKUR	Exchange rate for letter-of-credit procg in foreign trade	decimal	9	5	DEC	((0))	Yes		AKKUR
110	AKPRZ	Depreciation percentage for financial document processing	decimal	5	2	DEC	((0))	Yes		AKPRZ
111	PROLI	Dangerous Goods Management Profile in SD Documents	nvarchar	3	0	CHAR	(N' ')	Yes	TDGC5	ADGE_PROLI	Allow NULL?
112	XBLNR	Reference Document Number	nvarchar	25	0	CHAR	(N' ')	Yes		XBLNR_LIKP	Allow NULL?
113	HANDLE	Worldwide unique key for LIKP-VBELN	nvarchar	22	0	CHAR	(N' ')	Yes		TSEGGUID_LIKP	Allow NULL?
114	TSEGFL	Time segment exists	char	1	0	CHAR	(N' ')	Yes		TSEGEXISTS	Allow NULL?
115	TSEGTP	Event group time segment delivery header	nvarchar	10	0	CHAR	(N' ')	Yes	*	TSEGTPLLIK	Allow NULL?
116	TZONIS	Time zone of delivering location	nvarchar	6	0	CHAR	(N' ')	Yes	*	TSEGZONISS	Allow NULL?
117	TZONRC	Time zone of recipient location	nvarchar	6	0	CHAR	(N' ')	Yes	*	TSEGZONREC	Allow NULL?
118	CONT_DG	Indicator: Document contains dangerous goods	char	1	0	CHAR	(N' ')	Yes		ADGE_NCDG	Allow NULL?
119	VERURSYS	Distribution delivery: Original system	nvarchar	10	0	CHAR	(N' ')	Yes	*	VERURSYS	Allow NULL?
120	KZWAB	Indicator for controlling goods movement	char	1	0	CHAR	(N' ')	Yes		KZWAB	Allow NULL?
121	VLSTK	Distribution Status (Decentralized Warehouse Processing)	char	1	0	CHAR	(N' ')	Yes		VLSTK	Allow NULL?
122	TCODE	Transaction Code	nvarchar	20	0	CHAR	(N' ')	Yes	*	TCODE	Allow NULL?
123	VSART	Shipping type	nvarchar	2	0	CHAR	(N' ')	Yes	T173	VSARTTR	Allow NULL?
124	TRMTYP	Means of Transport	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	TRMTYP	Allow NULL?
125	SDABW	Special processing indicator	nvarchar	4	0	CHAR	(N' ')	Yes	TVSAK	SDABW	Allow NULL?
126	VBUND	Company ID	nvarchar	6	0	CHAR	(N' ')	Yes	*	VBUND	Allow NULL?
127	XWOFF	Calculation of val. open	char	1	0	CHAR	(N' ')	Yes		XWOFF	Allow NULL?
128	DIRTA	Automatic TO Creation Immediately After TR Generation	char	1	0	CHAR	(N' ')	Yes		LVS_DIRTA	Allow NULL?
129	PRVBE	Production Supply Area	nvarchar	10	0	CHAR	(N' ')	Yes	*	PRVBE	Allow NULL?
130	FOLAR	Delivery Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	LFART	Allow NULL?
131	PODAT	Date (proof of delivery)	nvarchar	8	0	DATS	(N'00000000')	Yes		PODAT	Allow NULL?
132	POTIM	Confirmation time	nvarchar	6	0	TIMS	(N'000000')	Yes		POTIM	Allow NULL?
133	VGANZ	Number of Delivery Items with Precedessor in Other System	int	10	0	INT4	((0))	Yes		SHP_VGANZ	Allow NULL?
134	IMWRK	Delivery has Status 'In Plant'	char	1	0	CHAR	(N' ')	Yes		IMWRK	Allow NULL?
135	SPE_LOEKZ	Document deletion indicator	char	1	0	CHAR	(N' ')	Yes		LOEKZ_BK	Allow NULL?
136	SPE_LOC_SEQ	Sequence of Intermediate Locations in Returns Process	nvarchar	3	0	CHAR	(N' ')	Yes		/SPE/RET_LOC_SEQ_D	Allow NULL?
137	SPE_ACC_APP_STS	Delivery Confirmation Status	char	1	0	CHAR	(N' ')	Yes		/SPE/RET_ACC_APP_STS	Allow NULL?
138	SPE_SHP_INF_STS	Shipment Information Status	char	1	0	CHAR	(N' ')	Yes		/SPE/RET_SHP_INF_STS	Allow NULL?
139	SPE_RET_CANC	Returns: Flag showing that an ASN is cancelled	char	1	0	CHAR	(N' ')	Yes		/SPE/RET_CANC	Allow NULL?
140	SPE_WAUHR_IST	Time of Goods Issue (Local, Relating to a Plant)	nvarchar	6	0	TIMS	(N'000000')	Yes		WAUHR	Allow NULL?
141	SPE_WAZONE_IST	Time Zone	nvarchar	6	0	CHAR	(N' ')	Yes	*	TZNZONE	Allow NULL?
142	SPE_REV_VLSTK	Distribution Status (Decentralized Warehouse Processing)	char	1	0	CHAR	(N' ')	Yes		VLSTK	Allow NULL?
143	SPE_LE_SCENARIO	Scenario Logistic Execution	char	1	0	CHAR	(N' ')	Yes		/SPE/LE_SCENARIO	Allow NULL?
144	SPE_ORIG_SYS	Original System Type	char	1	0	CHAR	(N' ')	Yes		/SPE/INB_ORIGIN_SYS	Allow NULL?
145	SPE_CHNG_SYS	Last Changer's System Type	char	1	0	CHAR	(N' ')	Yes		/SPE/INB_CHNG_SYS	Allow NULL?
146	SPE_GEOROUTE	Description of a Geographical Route	nvarchar	10	0	CHAR	(N' ')	Yes		/SPE/DE_ROUTE_ID	Allow NULL?
147	SPE_GEOROUTEIND	Change Indicator for the Route	char	1	0	CHAR	(N' ')	Yes		/SPE/DE_ROUTE_IND	Allow NULL?
148	SPE_CARRIER_IND	Change Indicator for the Carrier	char	1	0	CHAR	(N' ')	Yes		/SPE/DE_CARRIER_IND	Allow NULL?
149	SPE_GTS_REL	Goods Traffic Type	nvarchar	2	0	CHAR	(N' ')	Yes		/SPE/DE_LEG_GTS_CODE	Allow NULL?
150	SPE_GTS_RT_CDE	Route Code for SAP Global Trade Services	nvarchar	10	0	CHAR	(N' ')	Yes		/SPE/DE_ROUTE_GTS_CODE	Allow NULL?
151	SPE_REL_TMSTMP	Release Time Stamp	decimal	15	0	DEC	((0))	Yes		/SPE/DE_RELEASE_TMSTMP
152	SPE_UNIT_SYSTEM	Measurement Unit System	nvarchar	10	0	CHAR	(N' ')	Yes		/SPE/DE_UNIT_SYSTEM	Allow NULL?
153	SPE_INV_BFR_GI	Invoice Creation Before Goods Issue	char	1	0	CHAR	(N' ')	Yes		/SPE/INV_BFR_GI	Allow NULL?
154	SPE_QI_STATUS	Status of Quality Inspection for Returns Deliveries	char	1	0	CHAR	(N' ')	Yes		/SPE/RET_QI_STATUS	Allow NULL?
155	SPE_RED_IND	SPE indicator if redirecting has occured	char	1	0	CHAR	(N' ')	Yes		/SPE/RED_IND	Allow NULL?
156	SAKES	SAP Global Trade Services: Storage Status of Delivery	char	1	0	CHAR	(N' ')	Yes		GTS_SAKES	Allow NULL?
157	SPE_LIFEX_TYPE	Type of External Identification	char	1	0	CHAR	(N' ')	Yes		/SPE/DE_LIFEX_TYPE	Allow NULL?
158	SPE_TTYPE	Means of Transport	nvarchar	10	0	CHAR	(N' ')	Yes		/SPE/TTYPE	Allow NULL?
159	SPE_PRO_NUMBER	Partner Identification : Progressive Identification Number	nvarchar	35	0	CHAR	(N' ')	Yes		/SPE/PRO_NUMBER	Allow NULL?
160	LOC_GUID	Akkreditiv (GUID)	varbinary	16	0	RAW		Yes		LOC_GUID16
161	SPE_BILLING_IND	EWM Billing Indicator	char	1	0	CHAR	(N' ')	Yes		/SPE/DE_BILLING_IND	Allow NULL?
162	PRINTER_PROFILE	Description of print profile	nvarchar	10	0	CHAR	(N' ')	Yes		DRUCK_PROFIL_ID	Allow NULL?
163	MSR_ACTIVE	Advanced Returns Management Active	char	1	0	CHAR	(N' ')	Yes		MSR_ACTIVE	Allow NULL?
164	PRTNR	Confirmation number	nvarchar	10	0	NUMC	(N'0000000000')	Yes	*	PRTNR	Allow NULL?
165	STGE_LOC_CHANGE	Temporary Change of Storage Locations in Delivery	char	1	0	CHAR	(N' ')	Yes		SHP_STGE_LOC_CHANGE	Allow NULL?
166	TM_CTRL_KEY	Control Key for Document Transfer to TM	nvarchar	4	0	CHAR	(N' ')	Yes		TM_CTRL_KEY	Allow NULL?
167	DLV_SPLIT_INITIA	Delivery Split Initiator	char	1	0	CHAR	(N' ')	Yes		DLV_SPLIT_INITIATOR	Allow NULL?
168	DLV_VERSION	Delivery Version	nvarchar	4	0	NUMC	(N'0000')	Yes		DLV_VERSION	Allow NULL?
169	HANDOVERLOC	Location for a physical handover of goods	nvarchar	10	0	CHAR	(N' ')	Yes		HANDOVER_LOC	Allow NULL?
170	HANDOVERDATE	Handover Date at the Handover Location	nvarchar	8	0	DATS	(N'00000000')	Yes		HANDOVER_DATE	Allow NULL?
171	HANDOVERTIME	Handover time at the handover location	nvarchar	6	0	TIMS	(N'000000')	Yes		HANDOVER_TIME	Allow NULL?
172	HANDOVERTZONE	Time Zone of Handover Location	nvarchar	6	0	CHAR	(N' ')	Yes	*	HANDOVER_TIMEZONE	Allow NULL?
173	/BEV1/LULEINH	Loading Units	nvarchar	8	0	NUMC	(N'00000000')	Yes		/BEV1/LULEINH	Allow NULL?
174	/BEV1/RPFAESS	Number Category 1	decimal	7	0	DEC	((0))	Yes		/BEV1/RPFAESSER
175	/BEV1/RPKIST	Number Category 2	decimal	7	0	DEC	((0))	Yes		/BEV1/RPKISTEN
176	/BEV1/RPCONT	Number Category 3	decimal	7	0	DEC	((0))	Yes		/BEV1/RPONTAIN
177	/BEV1/RPSONST	Number Category 4	decimal	7	0	DEC	((0))	Yes		/BEV1/RPSONST
178	/BEV1/RPFLGNR	Loading Sequence Number in the Tour	nvarchar	5	0	NUMC	(N'00000')	Yes		/DSD/RP_SEQUENCENR	Allow NULL?
179	BORGR_GRP	Inbound Dely Group: Multi-Level Goods Receipt Automotive	nvarchar	35	0	CHAR	(N' ')	Yes		BORGR_GRP	Allow NULL?

TOP ERP 6.0 | LIKP INDEXES

Name	Primary	Unique	Type	Columns
LIKP~0	Yes	Yes	CLUSTERED	VBELN, MANDT
LIKP~HAN	No	No	NONCLUSTERED	HANDLE, 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

179 COLUMNS | 2 INDEXES | ERP 6.0 | LIKP TABLE

TOP ERP 6.0 | LIKP COLUMNS

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

179 COLUMNS | 2 INDEXES | ERP 6.0 | LIKP TABLE

TOPERP 6.0 | LIKP COLUMNS

TOPERP 6.0 | LIKP INDEXES

TOP ERP 6.0 | LIKP COLUMNS

TOP ERP 6.0 | LIKP INDEXES