	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	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
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

287 COLUMNS | 1 INDEXES | ERP 6.0 | ZEIM_LIPS TABLE

ERP EHP7

6.0

287

SD document: Delivery: Item data

SQL: selectupdate insert create

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

SELECT MANDT, VBELN, POSNR, PSTYV, ERNAM, ERZET, ERDAT, MATNR, MATWA, MATKL, WERKS, LGORT, CHARG, LICHN, KDMAT, PRODH, LFIMG, MEINS, VRKME, UMVKZ, UMVKN, NTGEW, BRGEW, GEWEI, VOLUM, VOLEH, KZTLF, UEBTK, UEBTO, UNTTO, CHSPL, FAKSP, MBDAT, LGMNG, ARKTX, LGPBE, VBELV, POSNV, VBTYV, VGSYS, VGBEL, VGPOS, UPFLU, UEPOS, FKREL, LADGR, TRAGR, KOMKZ, LGNUM, LISPL, LGTYP, LGPLA, BWTEX, BWART, BWLVS, KZDLG, BDART, PLART, MTART, XCHPF, XCHAR, VGREF, POSAR, BWTAR, SUMBD, MTVFP, EANNR, GSBER, VKBUR, VKGRP, VTWEG, SPART, GRKOR, FMENG, ANTLF, VBEAF, VBEAV, STAFO, WAVWR, KZWI1, KZWI2, KZWI3, KZWI4, KZWI5, KZWI6, SOBKZ, AEDAT, EAN11, KVGR1, KVGR2, KVGR3, KVGR4, KVGR5, MVGR1, MVGR2, MVGR3, MVGR4, MVGR5, VPZUO, VGTYP, RFVGTYP, KOSTL, KOKRS, PAOBJNR, PRCTR, PS_PSP_PNR, AUFNR, POSNR_PP, KDAUF, KDPOS, VPMAT, VPWRK, PRBME, UMREF, KNTTP, KZVBR, FIPOS, FISTL, GEBER, PCKPF, BEDAR_LF, CMPNT, KCMENG, KCBRGEW, KCNTGEW, KCVOLUM, UECHA, CUOBJ, CUOBJ_CH, ANZSN, SERAIL, KCGEWEI, KCVOLEH, SERNR, ABRLI, ABART, ABRVW, QPLOS, QTLOS, NACHL, MAGRV, OBJKO, OBJPO, AESKD, SHKZG, PROSA, UEPVW, EMPST, ABTNR, KOQUI, STADAT, AKTNR, KNUMH_CH, PREFE, EXART, CLINT, CHMVS, ABELN, ABELP, LFIMG_FLO, LGMNG_FLO, KCMENG_FLO, KZUMW, KMPMG, AUREL, KPEIN, KMEIN, NETPR, NETWR, KOWRR, KZBEW, MFRGR, CHHPV, ABFOR, ABGES, MBUHR, WKTNR, WKTPS, J_1BCFOP, J_1BTAXLW1, J_1BTAXLW2, J_1BTXSDC, SITUA, RSNUM, RSPOS, RSART, KANNR, KZFME, PROFL, KCMENGVME, KCMENGVMEF, KZBWS, PSPNR, EPRIO, RULES, KZBEF, MPROF, EMATN, LGBZO, HANDLE, VERURPOS, LIFEXPOS, NOATP, NOPCK, RBLVS, BERID, BESTQ, UMBSQ, UMMAT, UMWRK, UMLGO, UMCHA, UMBAR, UMSOK, SONUM, USONU, AKKUR, AKMNG, VKGRU, SHKZG_UM, INSMK, KZECH, FLGWM, BERKZ, HUPOS, NOWAB, KONTO, KZEAR, HSDAT, VFDAT, LFGJA, LFBNR, LFPOS, GRUND, FOBWA, DLVTP, EXBWR, BPMNG, EXVKW, CMPRE_FLT, KZPOD, LFDEZ, UMREV, PODREL, KZUML, FKBER, GRANT_NBR, KZWSO, GMCONTROL, POSTING_CHANGE, UM_PS_PSP_PNR, PRE_VL_ETENS, SPE_GEN_ELIKZ, SPE_SCRAP_IND, SPE_AUTH_NUMBER, SPE_INSPOUT_GUID, SPE_FOLLOW_UP, SPE_EXP_DATE_EXT, SPE_EXP_DATE_INT, SPE_AUTH_COMPLET, ORMNG, SPE_ATP_TMSTMP, SPE_ORIG_SYS, SPE_LIEFFZ, SPE_IMWRK, SPE_LIFEXPOS2, SPE_EXCEPT_CODE, SPE_KEEP_QTY, SPE_ALTERNATE, SPE_MAT_SUBST, SPE_STRUC, SPE_APO_QNTYFAC, SPE_APO_QNTYDIV, SPE_HERKL, SPE_BXP_DATE_EXT, SPE_VERSION, SPE_COMPL_MVT, J_1BTAXLW4, J_1BTAXLW5, J_1BTAXLW3, BUDGET_PD, KBNKZ, FARR_RELTYPE, SITKZ, SGT_RCAT, SGT_SCAT, CONS_ORDER FROM ZEIM_LIPS

TOP ERP 6.0 | ZEIM_LIPS 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	POSNR	Delivery Item	nvarchar	6	0	NUMC	(N'000000')	No	VBUP	POSNR_VL	Allow NULL?
4	PSTYV	Delivery item category	nvarchar	4	0	CHAR	(N' ')	Yes	TVPT	PSTYV_VL	Allow NULL?
5	ERNAM	Name of Person who Created the Object	nvarchar	12	0	CHAR	(N' ')	Yes		ERNAM	Allow NULL?
6	ERZET	Entry time	nvarchar	6	0	TIMS	(N'000000')	Yes		ERZET	Allow NULL?
7	ERDAT	Date on Which Record Was Created	nvarchar	8	0	DATS	(N'00000000')	Yes		ERDAT	Allow NULL?
8	MATNR	Material Number	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	MATNR	Allow NULL?
9	MATWA	Material entered	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	MATWA	Allow NULL?
10	MATKL	Material Group	nvarchar	9	0	CHAR	(N' ')	Yes	T023	MATKL	Allow NULL?
11	WERKS	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	WERKS_D	Allow NULL?
12	LGORT	Storage Location	nvarchar	4	0	CHAR	(N' ')	Yes	T001L	LGORT_D	Allow NULL?
13	CHARG	Batch Number	nvarchar	10	0	CHAR	(N' ')	Yes	MCHA	CHARG_D	Allow NULL?
14	LICHN	Vendor Batch Number	nvarchar	15	0	CHAR	(N' ')	Yes		LICHN	Allow NULL?
15	KDMAT	Material belonging to the customer	nvarchar	35	0	CHAR	(N' ')	Yes		KDMAT	Allow NULL?
16	PRODH	Product hierarchy	nvarchar	18	0	CHAR	(N' ')	Yes	T179	PRODH_D	Allow NULL?
17	LFIMG	Actual quantity delivered (in sales units)	decimal	13	3	QUAN	((0))	Yes		LFIMG
18	MEINS	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
19	VRKME	Sales unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	VRKME	Allow NULL?
20	UMVKZ	Numerator (factor) for conversion of sales quantity into SKU	decimal	5	0	DEC	((0))	Yes		UMVKZ
21	UMVKN	Denominator (Divisor) for Conversion of Sales Qty into SKU	decimal	5	0	DEC	((0))	Yes		UMVKN
22	NTGEW	Net weight	decimal	15	3	QUAN	((0))	Yes		NTGEW_15
23	BRGEW	Gross weight	decimal	15	3	QUAN	((0))	Yes		BRGEW_15
24	GEWEI	Weight Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	GEWEI	Allow NULL?
25	VOLUM	Volume	decimal	15	3	QUAN	((0))	Yes		VOLUM_15
26	VOLEH	Volume unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	VOLEH	Allow NULL?
27	KZTLF	Partial delivery at item level	char	1	0	CHAR	(N' ')	Yes		KZTLF	Allow NULL?
28	UEBTK	Indicator: Unlimited Overdelivery Allowed	char	1	0	CHAR	(N' ')	Yes		UEBTK	Allow NULL?
29	UEBTO	Overdelivery Tolerance Limit	decimal	3	1	DEC	((0))	Yes		UEBTO
30	UNTTO	Underdelivery Tolerance Limit	decimal	3	1	DEC	((0))	Yes		UNTTO
31	CHSPL	Batch split allowed	char	1	0	CHAR	(N' ')	Yes		CHSPL	Allow NULL?
32	FAKSP	Block	nvarchar	2	0	CHAR	(N' ')	Yes	TVFS	FAKSP	Allow NULL?
33	MBDAT	Material Staging/Availability Date	nvarchar	8	0	DATS	(N'00000000')	Yes		MBDAT	Allow NULL?
34	LGMNG	Actual quantity delivered in stockkeeping units	decimal	13	3	QUAN	((0))	Yes		LGMNG
35	ARKTX	Short text for sales order item	nvarchar	40	0	CHAR	(N' ')	Yes		ARKTX	Allow NULL?
36	LGPBE	Storage Bin	nvarchar	10	0	CHAR	(N' ')	Yes		LGPBE	Allow NULL?
37	VBELV	Originating document	nvarchar	10	0	CHAR	(N' ')	Yes	VBUK	VBELV	Allow NULL?
38	POSNV	Originating item	nvarchar	6	0	NUMC	(N'000000')	Yes	VBUP	POSNV	Allow NULL?
39	VBTYV	SD document category	char	1	0	CHAR	(N' ')	Yes		VBTYP	Allow NULL?
40	VGSYS	Logical System in the Preceding Document	nvarchar	10	0	CHAR	(N' ')	Yes	TBDLS	VGLOGSYS	Allow NULL?
41	VGBEL	Document number of the reference document	nvarchar	10	0	CHAR	(N' ')	Yes	VBUK	VGBEL	Allow NULL?
42	VGPOS	Item number of the reference item	nvarchar	6	0	NUMC	(N'000000')	Yes	VBUP	VGPOS	Allow NULL?
43	UPFLU	Update indicator for delivery document flow	char	1	0	CHAR	(N' ')	Yes		UPFLL	Allow NULL?
44	UEPOS	Higher-level item in bill of material structures	nvarchar	6	0	NUMC	(N'000000')	Yes	VBUP	UEPOS	Allow NULL?
45	FKREL	Relevant for Billing	char	1	0	CHAR	(N' ')	Yes		FKREL	Allow NULL?
46	LADGR	Loading Group	nvarchar	4	0	CHAR	(N' ')	Yes	TLGR	LADGR	Allow NULL?
47	TRAGR	Transportation Group	nvarchar	4	0	CHAR	(N' ')	Yes	TTGR	TRAGR	Allow NULL?
48	KOMKZ	Indicator for picking control	char	1	0	CHAR	(N' ')	Yes		KOMKZ	Allow NULL?
49	LGNUM	Warehouse Number / Warehouse Complex	nvarchar	3	0	CHAR	(N' ')	Yes	T300	LGNUM	Allow NULL?
50	LISPL	Split to warehouse number required	char	1	0	CHAR	(N' ')	Yes		LNSPL_LIPS	Allow NULL?
51	LGTYP	Storage Type	nvarchar	3	0	CHAR	(N' ')	Yes	T301	LGTYP	Allow NULL?
52	LGPLA	Storage Bin	nvarchar	10	0	CHAR	(N' ')	Yes	LAGP	LGPLA	Allow NULL?
53	BWTEX	Indicator: Separate valuation	char	1	0	CHAR	(N' ')	Yes		BWTEX	Allow NULL?
54	BWART	Movement Type (Inventory Management)	nvarchar	3	0	CHAR	(N' ')	Yes	T156	BWART	Allow NULL?
55	BWLVS	Movement Type for Warehouse Management	nvarchar	3	0	NUMC	(N'000')	Yes	T333	BWLVS	Allow NULL?
56	KZDLG	Indicator: dynamic storage bin in warehouse management	char	1	0	CHAR	(N' ')	Yes		LVS_KZDLG	Allow NULL?
57	BDART	Requirement type	nvarchar	2	0	CHAR	(N' ')	Yes		BDART	Allow NULL?
58	PLART	Planning type	char	1	0	CHAR	(N' ')	Yes	*	PLART	Allow NULL?
59	MTART	Material Type	nvarchar	4	0	CHAR	(N' ')	Yes	T134	MTART	Allow NULL?
60	XCHPF	Batch management requirement indicator	char	1	0	CHAR	(N' ')	Yes		XCHPF	Allow NULL?
61	XCHAR	Batch management indicator (internal)	char	1	0	CHAR	(N' ')	Yes		XCHAR	Allow NULL?
62	VGREF	Preceding document has resulted from reference	char	1	0	CHAR	(N' ')	Yes		VGREF	Allow NULL?
63	POSAR	Item type	char	1	0	CHAR	(N' ')	Yes		POSAR	Allow NULL?
64	BWTAR	Valuation Type	nvarchar	10	0	CHAR	(N' ')	Yes	T149D	BWTAR_D	Allow NULL?
65	SUMBD	Summing up of requirements	char	1	0	CHAR	(N' ')	Yes		SUMBD	Allow NULL?
66	MTVFP	Checking Group for Availability Check	nvarchar	2	0	CHAR	(N' ')	Yes	TMVF	MTVFP	Allow NULL?
67	EANNR	European Article Number (EAN) - obsolete!!!!!	nvarchar	13	0	CHAR	(N' ')	Yes		EANNR	Allow NULL?
68	GSBER	Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	TGSB	GSBER	Allow NULL?
69	VKBUR	Sales Office	nvarchar	4	0	CHAR	(N' ')	Yes	TVBUR	VKBUR	Allow NULL?
70	VKGRP	Sales Group	nvarchar	3	0	CHAR	(N' ')	Yes	TVKGR	VKGRP	Allow NULL?
71	VTWEG	Distribution Channel	nvarchar	2	0	CHAR	(N' ')	Yes	TVTW	VTWEG	Allow NULL?
72	SPART	Division	nvarchar	2	0	CHAR	(N' ')	Yes	TSPA	SPART	Allow NULL?
73	GRKOR	Delivery group (items are delivered together)	nvarchar	3	0	NUMC	(N'000')	Yes		GRKOR	Allow NULL?
74	FMENG	Quantity is Fixed	char	1	0	CHAR	(N' ')	Yes		FMENG	Allow NULL?
75	ANTLF	Maximum Number of Partial Deliveries Allowed Per Item	decimal	1	0	DEC	((0))	Yes		ANTLF
76	VBEAF	Fixed shipping processing time in days (= setup time)	decimal	5	2	DEC	((0))	Yes		VBEAF
77	VBEAV	Variable shipping processing time in days	decimal	5	2	DEC	((0))	Yes		VBEAV
78	STAFO	Update group for statistics update	nvarchar	6	0	CHAR	(N' ')	Yes	*	STAFO	Allow NULL?
79	WAVWR	Cost in document currency	decimal	13	2	CURR	((0))	Yes		WAVWR
80	KZWI1	Subtotal 1 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI1
81	KZWI2	Subtotal 2 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI2
82	KZWI3	Subtotal 3 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI3
83	KZWI4	Subtotal 4 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI4
84	KZWI5	Subtotal 5 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI5
85	KZWI6	Subtotal 6 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI6
86	SOBKZ	Special Stock Indicator	char	1	0	CHAR	(N' ')	Yes	T148	SOBKZ	Allow NULL?
87	AEDAT	Changed On	nvarchar	8	0	DATS	(N'00000000')	Yes		AEDAT	Allow NULL?
88	EAN11	International Article Number (EAN/UPC)	nvarchar	18	0	CHAR	(N' ')	Yes		EAN11	Allow NULL?
89	KVGR1	Customer group 1	nvarchar	3	0	CHAR	(N' ')	Yes	TVV1	KVGR1	Allow NULL?
90	KVGR2	Customer group 2	nvarchar	3	0	CHAR	(N' ')	Yes	TVV2	KVGR2	Allow NULL?
91	KVGR3	Customer group 3	nvarchar	3	0	CHAR	(N' ')	Yes	TVV3	KVGR3	Allow NULL?
92	KVGR4	Customer group 4	nvarchar	3	0	CHAR	(N' ')	Yes	TVV4	KVGR4	Allow NULL?
93	KVGR5	Customer group 5	nvarchar	3	0	CHAR	(N' ')	Yes	TVV5	KVGR5	Allow NULL?
94	MVGR1	Material group 1	nvarchar	3	0	CHAR	(N' ')	Yes	TVM1	MVGR1	Allow NULL?
95	MVGR2	Material group 2	nvarchar	3	0	CHAR	(N' ')	Yes	TVM2	MVGR2	Allow NULL?
96	MVGR3	Material group 3	nvarchar	3	0	CHAR	(N' ')	Yes	TVM3	MVGR3	Allow NULL?
97	MVGR4	Material group 4	nvarchar	3	0	CHAR	(N' ')	Yes	TVM4	MVGR4	Allow NULL?
98	MVGR5	Material group 5	nvarchar	3	0	CHAR	(N' ')	Yes	TVM5	MVGR5	Allow NULL?
99	VPZUO	Allocation Indicator	char	1	0	CHAR	(N' ')	Yes		VPZUO	Allow NULL?
100	VGTYP	SD document category	char	1	0	CHAR	(N' ')	Yes		VBTYP	Allow NULL?
101	RFVGTYP	Type of preceding document in central system	char	1	0	CHAR	(N' ')	Yes		RFVGTYP	Allow NULL?
102	KOSTL	Cost Center	nvarchar	10	0	CHAR	(N' ')	Yes	CSKS	KOSTL	Allow NULL?
103	KOKRS	Controlling Area	nvarchar	4	0	CHAR	(N' ')	Yes	TKA01	KOKRS	Allow NULL?
104	PAOBJNR	Profitability Segment Number (CO-PA)	nvarchar	10	0	NUMC	(N'0000000000')	Yes		RKEOBJNR	Allow NULL?
105	PRCTR	Profit Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	PRCTR	Allow NULL?
106	PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	PS_PSP_PNR	Allow NULL?
107	AUFNR	Order Number	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	AUFNR	Allow NULL?
108	POSNR_PP	Order Item Number	nvarchar	4	0	NUMC	(N'0000')	Yes		CO_POSNR	Allow NULL?
109	KDAUF	Sales Order Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	KDAUF	Allow NULL?
110	KDPOS	Item Number in Sales Order	nvarchar	6	0	NUMC	(N'000000')	Yes		KDPOS	Allow NULL?
111	VPMAT	Planning material	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	VPMAT	Allow NULL?
112	VPWRK	Planning plant	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	VPWRK	Allow NULL?
113	PRBME	Base unit of measure for product group	nvarchar	3	0	UNIT	(N' ')	Yes	T006	PRBME	Allow NULL?
114	UMREF	Conversion factor: quantities	float	15	16	FLTP	((0))	Yes		UMREFF
115	KNTTP	Account Assignment Category	char	1	0	CHAR	(N' ')	Yes	T163K	KNTTP	Allow NULL?
116	KZVBR	Consumption Posting	char	1	0	CHAR	(N' ')	Yes		KZVBR	Allow NULL?
117	FIPOS	Commitment Item	nvarchar	14	0	CHAR	(N' ')	Yes	*	FIPOS	Allow NULL?
118	FISTL	Funds Center	nvarchar	16	0	CHAR	(N' ')	Yes	*	FISTL	Allow NULL?
119	GEBER	Fund	nvarchar	10	0	CHAR	(N' ')	Yes	*	BP_GEBER	Allow NULL?
120	PCKPF	Packing control	char	1	0	CHAR	(N' ')	Yes		PCKPF	Allow NULL?
121	BEDAR_LF	Requirements class	nvarchar	3	0	CHAR	(N' ')	Yes	T459K	BEDAR	Allow NULL?
122	CMPNT	ID: Item with active credit function / relevant for credit	char	1	0	CHAR	(N' ')	Yes		CMPNT	Allow NULL?
123	KCMENG	Cumulative batch quantity of all split items (in StckUnit)	decimal	15	3	QUAN	((0))	Yes		KCMENG
124	KCBRGEW	Cumulative gross weight of all batch split items	decimal	15	3	QUAN	((0))	Yes		KCBRGEW
125	KCNTGEW	Cumulative net weight of all batch split items	decimal	15	3	QUAN	((0))	Yes		KCNTGEW
126	KCVOLUM	Cumulative volume of all batch split items	decimal	15	3	QUAN	((0))	Yes		KCVOLUM
127	UECHA	Higher-Level Item of Batch Split Item	nvarchar	6	0	NUMC	(N'000000')	Yes	LIPS	UECHA	Allow NULL?
128	CUOBJ	Configuration	nvarchar	18	0	NUMC	(N'000000000000000000')	Yes		CUOBJ_VA	Allow NULL?
129	CUOBJ_CH	Internal object number of the batch classification	nvarchar	18	0	NUMC	(N'000000000000000000')	Yes		CUOBJ_CH	Allow NULL?
130	ANZSN	Number of serial numbers	int	10	0	INT4	((0))	Yes		ANZSN	Allow NULL?
131	SERAIL	Serial Number Profile	nvarchar	4	0	CHAR	(N' ')	Yes	T377P	SERAIL	Allow NULL?
132	KCGEWEI	Weight Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	GEWEI	Allow NULL?
133	KCVOLEH	Volume unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	VOLEH	Allow NULL?
134	SERNR	BOM explosion number	nvarchar	8	0	CHAR	(N' ')	Yes	SNUM	SERNR	Allow NULL?
135	ABRLI	Internal delivery schedule number	nvarchar	4	0	NUMC	(N'0000')	Yes	VBLB	ABRLI	Allow NULL?
136	ABART	Release type	char	1	0	CHAR	(N' ')	Yes		ABART	Allow NULL?
137	ABRVW	Usage Indicator	nvarchar	3	0	CHAR	(N' ')	Yes	TVLV	ABRVW	Allow NULL?
138	QPLOS	Inspection Lot Number	nvarchar	12	0	NUMC	(N'000000000000')	Yes	QALS	QPLOS	Allow NULL?
139	QTLOS	Partial lot number	nvarchar	6	0	NUMC	(N'000000')	Yes	*	QTLOS	Allow NULL?
140	NACHL	Customer has not posted goods receipt	char	1	0	CHAR	(N' ')	Yes		NACHL	Allow NULL?
141	MAGRV	Material Group: Packaging Materials	nvarchar	4	0	CHAR	(N' ')	Yes	TVEGR	MAGRV	Allow NULL?
142	OBJKO	Object number at header level	nvarchar	22	0	CHAR	(N' ')	Yes	*	OBJKO	Allow NULL?
143	OBJPO	Object number at item level	nvarchar	22	0	CHAR	(N' ')	Yes	*	OBJPO	Allow NULL?
144	AESKD	Customer Engineering Change Status	nvarchar	17	0	CHAR	(N' ')	Yes		AESKD	Allow NULL?
145	SHKZG	Returns Item	char	1	0	CHAR	(N' ')	Yes		SHKZG_VA	Allow NULL?
146	PROSA	ID for material determination	char	1	0	CHAR	(N' ')	Yes		PROSA	Allow NULL?
147	UEPVW	ID for higher-level item usage	char	1	0	CHAR	(N' ')	Yes		UEPVW	Allow NULL?
148	EMPST	Receiving point	nvarchar	25	0	CHAR	(N' ')	Yes		EMPST	Allow NULL?
149	ABTNR	Department number	nvarchar	4	0	CHAR	(N' ')	Yes	TSAB	ABTNR	Allow NULL?
150	KOQUI	Picking is subject to confirmation	char	1	0	CHAR	(N' ')	Yes		KOQUI	Allow NULL?
151	STADAT	Statistics date	nvarchar	8	0	DATS	(N'00000000')	Yes		STADAT	Allow NULL?
152	AKTNR	Promotion	nvarchar	10	0	CHAR	(N' ')	Yes	WAKH	WAKTION	Allow NULL?
153	KNUMH_CH	Number of condition record from batch determination	nvarchar	10	0	CHAR	(N' ')	Yes		KNUMH_CH	Allow NULL?
154	PREFE	Preference indicator in export/import	char	1	0	CHAR	(N' ')	Yes		PREFE	Allow NULL?
155	EXART	Business Transaction Type for Foreign Trade	nvarchar	2	0	CHAR	(N' ')	Yes	*	EXART	Allow NULL?
156	CLINT	Internal Class Number	nvarchar	10	0	NUMC	(N'0000000000')	Yes	KLAH	CLINT	Allow NULL?
157	CHMVS	Batches: Exit to quantity proposal	nvarchar	3	0	NUMC	(N'000')	Yes		CHMVS	Allow NULL?
158	ABELN	Allocation Table Number	nvarchar	10	0	CHAR	(N' ')	Yes	AUKO	ABELN	Allow NULL?
159	ABELP	Item number of allocation table	nvarchar	5	0	NUMC	(N'00000')	Yes	AUPO	ABELP	Allow NULL?
160	LFIMG_FLO	Internal field/ Do not use / LFIMG in float / MUM	float	15	16	FLTP	((0))	Yes		LFIMG_FLO
161	LGMNG_FLO	Internal field/ Do not use / LGMNG in float / MUM	float	15	16	FLTP	((0))	Yes		LGMNG_FLO
162	KCMENG_FLO	Internal field/ Do not use / KCMENG in float / MUM	float	15	16	FLTP	((0))	Yes		KCMENG_FLO
163	KZUMW	Environmentally Relevant	char	1	0	CHAR	(N' ')	Yes		KZUMW	Allow NULL?
164	KMPMG	Component quantity	decimal	13	3	QUAN	((0))	Yes		KMPMG
165	AUREL	Relevant to Allocation Table	char	1	0	CHAR	(N' ')	Yes		AUREL	Allow NULL?
166	KPEIN	Condition pricing unit	decimal	5	0	DEC	((0))	Yes		KPEIN
167	KMEIN	Condition unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	KMEIN	Allow NULL?
168	NETPR	Net price	decimal	11	2	CURR	((0))	Yes		NETPR
169	NETWR	Net Value in Document Currency	decimal	15	2	CURR	((0))	Yes		NETWR
170	KOWRR	Statistical values	char	1	0	CHAR	(N' ')	Yes		KOWRR	Allow NULL?
171	KZBEW	Movement Indicator	char	1	0	CHAR	(N' ')	Yes		KZBEW	Allow NULL?
172	MFRGR	Material freight group	nvarchar	8	0	CHAR	(N' ')	Yes	TMFG	MFRGR	Allow NULL?
173	CHHPV	Pack accumulated batches / movement type item	char	1	0	CHAR	(N' ')	Yes		CHHPV	Allow NULL?
174	ABFOR	Form of payment guarantee	nvarchar	2	0	CHAR	(N' ')	Yes	T691K	ABSFORM_CM	Allow NULL?
175	ABGES	Guaranteed (factor between 0 and 1)	float	15	16	FLTP	((0))	Yes		ABGES_CM
176	MBUHR	Material Staging Time (Local, Relating to a Plant)	nvarchar	6	0	TIMS	(N'000000')	Yes		MBUHR	Allow NULL?
177	WKTNR	Value contract no.	nvarchar	10	0	CHAR	(N' ')	Yes	VBUK	WKTNR	Allow NULL?
178	WKTPS	Value contract item	nvarchar	6	0	NUMC	(N'000000')	Yes	VBUP	WKTPS	Allow NULL?
179	J_1BCFOP	CFOP Code and Extension	nvarchar	10	0	CHAR	(N' ')	Yes	J_1BAG	J_1BCFOP	Allow NULL?
180	J_1BTAXLW1	Tax law: ICMS	nvarchar	3	0	CHAR	(N' ')	Yes	J_1BATL1	J_1BTAXLW1	Allow NULL?
181	J_1BTAXLW2	Tax law: IPI	nvarchar	3	0	CHAR	(N' ')	Yes	J_1BATL2	J_1BTAXLW2	Allow NULL?
182	J_1BTXSDC	SD tax code	nvarchar	2	0	CHAR	(N' ')	Yes	J_1BTXSDC	J_1BTXSDC_	Allow NULL?
183	SITUA	Indicator for situation	nvarchar	2	0	CHAR	(N' ')	Yes	*	SITUA	Allow NULL?
184	RSNUM	Number of Reservation/Dependent Requirement	nvarchar	10	0	NUMC	(N'0000000000')	Yes	*	RSNUM	Allow NULL?
185	RSPOS	Item Number of Reservation/Dependent Requirement	nvarchar	4	0	NUMC	(N'0000')	Yes		RSPOS	Allow NULL?
186	RSART	Record type	char	1	0	CHAR	(N' ')	Yes		RSART	Allow NULL?
187	KANNR	KANBAN/sequence number	nvarchar	35	0	CHAR	(N' ')	Yes		KANNR	Allow NULL?
188	KZFME	ID: Leading unit of measure for completing a transaction	char	1	0	CHAR	(N' ')	Yes		KZFME	Allow NULL?
189	PROFL	Dangerous Goods Indicator Profile	nvarchar	3	0	CHAR	(N' ')	Yes	TDG41	ADGE_PROFL	Allow NULL?
190	KCMENGVME	Cumulative batch quantity of all split items in sales units	decimal	15	3	QUAN	((0))	Yes		KCMENG_VME
191	KCMENGVMEF	Cumulated batch split quantity in VRKME and float	float	15	16	FLTP	((0))	Yes		KCMENGVMEF
192	KZBWS	Valuation of Special Stock	char	1	0	CHAR	(N' ')	Yes		KZBWS	Allow NULL?
193	PSPNR	Project definition (internal)	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	PS_INTNR	Allow NULL?
194	EPRIO	Withdrawal sequence group for stocks	nvarchar	4	0	CHAR	(N' ')	Yes	*	EPRIO	Allow NULL?
195	RULES	Stock determination rule	nvarchar	4	0	CHAR	(N' ')	Yes	T434R	BF_RULES	Allow NULL?
196	KZBEF	Indicator Inventory Management active	char	1	0	CHAR	(N' ')	Yes		LVS_KZBEF	Allow NULL?
197	MPROF	Manufacturer Part Profile	nvarchar	4	0	CHAR	(N' ')	Yes	*	MPROF	Allow NULL?
198	EMATN	Material Number Corresponding to Manufacturer Part Number	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	EMATN	Allow NULL?
199	LGBZO	Staging Area for Warehouse Complex	nvarchar	10	0	CHAR	(N' ')	Yes	T30C	LGBZO	Allow NULL?
200	HANDLE	Worldwide unique key for LIPS-VBELN & LIPS_POSNR	nvarchar	22	0	CHAR	(N' ')	Yes		TSEGGUID_LIPS	Allow NULL?
201	VERURPOS	Distribution delivery: Original item	nvarchar	6	0	NUMC	(N'000000')	Yes	*	VERURPOS	Allow NULL?
202	LIFEXPOS	External item number	nvarchar	6	0	NUMC	(N'000000')	Yes	*	LIFEXPOS	Allow NULL?
203	NOATP	Indicator: deactivate availability check	char	1	0	CHAR	(N' ')	Yes		NO_ATP_CHECK	Allow NULL?
204	NOPCK	Indicator: not relevant for picking	char	1	0	CHAR	(N' ')	Yes		NO_PICKING	Allow NULL?
205	RBLVS	Reference movement type for WM from material movements	nvarchar	3	0	NUMC	(N'000')	Yes		RBLVS	Allow NULL?
206	BERID	MRP Area	nvarchar	10	0	CHAR	(N' ')	Yes	MDLV	BERID	Allow NULL?
207	BESTQ	Stock Category in the Warehouse Management System	char	1	0	CHAR	(N' ')	Yes		BESTQ	Allow NULL?
208	UMBSQ	Stock Category in the Warehouse Management System	char	1	0	CHAR	(N' ')	Yes		BESTQ	Allow NULL?
209	UMMAT	Receiving/Issuing Material	nvarchar	18	0	CHAR	(N' ')	Yes	*	UMMAT	Allow NULL?
210	UMWRK	Receiving/Issuing Plant	nvarchar	4	0	CHAR	(N' ')	Yes	*	UMWRK	Allow NULL?
211	UMLGO	Receiving/Issuing Storage Location	nvarchar	4	0	CHAR	(N' ')	Yes	*	UMLGO	Allow NULL?
212	UMCHA	Receiving/Issuing Batch	nvarchar	10	0	CHAR	(N' ')	Yes	*	UMCHA	Allow NULL?
213	UMBAR	Valuation Type of Transfer Batch	nvarchar	10	0	CHAR	(N' ')	Yes	*	UMBAR	Allow NULL?
214	UMSOK	Special Stock Indicator for Physical Stock Transfer	char	1	0	CHAR	(N' ')	Yes	*	UMSOK	Allow NULL?
215	SONUM	Special Stock Number	nvarchar	16	0	CHAR	(N' ')	Yes		LVS_SONUM	Allow NULL?
216	USONU	Special Stock Number	nvarchar	16	0	CHAR	(N' ')	Yes		LVS_SONUM	Allow NULL?
217	AKKUR	Exchange rate for letter-of-credit procg in foreign trade	decimal	9	5	DEC	((0))	Yes		AKKUR
218	AKMNG	Current Qty Field for Arithmetic Operations in Doc.Process.	char	1	0	CHAR	(N' ')	Yes		AKMNG	Allow NULL?
219	VKGRU	Repair Processing: Classification of Items	nvarchar	3	0	CHAR	(N' ')	Yes	*	VKGRU	Allow NULL?
220	SHKZG_UM	Indicator: UNMAT in main posting	char	1	0	CHAR	(N' ')	Yes		SHKZG_UM	Allow NULL?
221	INSMK	Stock Type	char	1	0	CHAR	(N' ')	Yes		MB_INSMK	Allow NULL?
222	KZECH	Determination of batch entry in the production/process order	char	1	0	CHAR	(N' ')	Yes		KZECH	Allow NULL?
223	FLGWM	Indicator: Copy dest. storage data from preceding document	char	1	0	CHAR	(N' ')	Yes		FLGWM	Allow NULL?
224	BERKZ	Material Staging Indicator for Production Supply	char	1	0	CHAR	(N' ')	Yes		BERKZ	Allow NULL?
225	HUPOS	Indicator: Delivery item is a HU item	char	1	0	CHAR	(N' ')	Yes		HUPOS	Allow NULL?
226	NOWAB	Indicator: Item Not Relevant for Goods Movements	char	1	0	CHAR	(N' ')	Yes		NOWAB	Allow NULL?
227	KONTO	G/L Account Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	SAKNR	Allow NULL?
228	KZEAR	Final Issue for This Reservation	char	1	0	CHAR	(N' ')	Yes		KZEAR	Allow NULL?
229	HSDAT	Date of Manufacture	nvarchar	8	0	DATS	(N'00000000')	Yes		HSDAT	Allow NULL?
230	VFDAT	Shelf Life Expiration or Best-Before Date	nvarchar	8	0	DATS	(N'00000000')	Yes		VFDAT	Allow NULL?
231	LFGJA	Fiscal Year of Current Period	nvarchar	4	0	NUMC	(N'0000')	Yes		LFGJA	Allow NULL?
232	LFBNR	Document No. of a Reference Document	nvarchar	10	0	CHAR	(N' ')	Yes		LFBNR	Allow NULL?
233	LFPOS	Item of a Reference Document	nvarchar	4	0	NUMC	(N'0000')	Yes		LFPOS	Allow NULL?
234	GRUND	Reason for goods movment	nvarchar	4	0	NUMC	(N'0000')	Yes		MB_GRUND	Allow NULL?
235	FOBWA	Subsequent movement type	nvarchar	3	0	CHAR	(N' ')	Yes	*	FOBWA	Allow NULL?
236	DLVTP	Delivery Category	nvarchar	2	0	CHAR	(N' ')	Yes		DLVTP	Allow NULL?
237	EXBWR	Externally Entered Posting Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		EXBWR
238	BPMNG	Quantity in Purchase Order Price Unit	decimal	13	3	QUAN	((0))	Yes		BPMNG
239	EXVKW	Externally Entered Sales Value in Local Currency	decimal	13	2	CURR	((0))	Yes		EXVKW
240	CMPRE_FLT	Item credit price	float	15	16	FLTP	((0))	Yes		CMPRE_FLT
241	KZPOD	POD indicator (relevance, verification, confirmation)	char	1	0	CHAR	(N' ')	Yes		KZPOD	Allow NULL?
242	LFDEZ	Not relevant for distribution for WMS	char	1	0	CHAR	(N' ')	Yes		LFDEZ	Allow NULL?
243	UMREV	Conversion Factor of Delivery Quantity VRKME for MEINS	float	15	16	FLTP	((0))	Yes		LE_UMREV
244	PODREL	POD Control (Proof of Delivery)	char	1	0	CHAR	(N' ')	Yes		PODREL	Allow NULL?
245	KZUML	Stock transfer/transfer posting	char	1	0	CHAR	(N' ')	Yes		KZUML	Allow NULL?
246	FKBER	Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	*	FKBER	Allow NULL?
247	GRANT_NBR	Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_NBR	Allow NULL?
248	KZWSO	Units of measure usage	char	1	0	CHAR	(N' ')	Yes		KZWSO	Allow NULL?
249	GMCONTROL	Goods Movement Control	char	1	0	CHAR	(N' ')	Yes		GMCONTROL	Allow NULL?
250	POSTING_CHANGE	Goods Movement Control: HU	char	1	0	CHAR	(N' ')	Yes		POSTING_CHANGE	Allow NULL?
251	UM_PS_PSP_PNR	Receiving/Issuing (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	UM_PS_PSP_PNR	Allow NULL?
252	PRE_VL_ETENS	Sequential Number of Vendor Confirmation	nvarchar	4	0	NUMC	(N'0000')	Yes		ETENS	Allow NULL?
253	SPE_GEN_ELIKZ	"Delivery Completed" Indicator	char	1	0	CHAR	(N' ')	Yes		ELIKZ	Allow NULL?
254	SPE_SCRAP_IND	Scrap Indicator for EWM Processing	char	1	0	CHAR	(N' ')	Yes		/SPE/DELIVERY_SCRAP_IND	Allow NULL?
255	SPE_AUTH_NUMBER	Return Material Authorization Number	nvarchar	20	0	CHAR	(N' ')	Yes		/SPE/RET_RMA	Allow NULL?
256	SPE_INSPOUT_GUID	Inspections: Inspection outcome GUID set by EWM	varbinary	16	0	RAW		Yes		/SPE/INSP_OUT_GUID_16
257	SPE_FOLLOW_UP	Default Follow-Up Activity Code	nvarchar	4	0	CHAR	(N' ')	Yes		/SPE/RET_FOLLOW_UP	Allow NULL?
258	SPE_EXP_DATE_EXT	End date of validity period of returns delivery	decimal	15	0	DEC	((0))	Yes		/SPE/RET_EXPIRY_DATE_EXT
259	SPE_EXP_DATE_INT	End date of internal validity period of returns delivery	decimal	15	0	DEC	((0))	Yes		/SPE/RET_EXPIRY_DATE_INT
260	SPE_AUTH_COMPLET	RMA completion indicator	char	1	0	CHAR	(N' ')	Yes		/SPE/RET_RMA_COMPLETED	Allow NULL?
261	ORMNG	Original Quantity of Delivery Item	decimal	13	3	QUAN	((0))	Yes		ORMNG_VL
262	SPE_ATP_TMSTMP	ATP Time Stamp	decimal	15	0	DEC	((0))	Yes		/SPE/DE_ATP_TIMESTAMP
263	SPE_ORIG_SYS	Original System Type	char	1	0	CHAR	(N' ')	Yes		/SPE/INB_ORIGIN_SYS	Allow NULL?
264	SPE_LIEFFZ	Cumulative Qty for SchedAgr - Vendor's Point of View	decimal	15	3	QUAN	((0))	Yes		/SPE/LIEFFZ
265	SPE_IMWRK	Inbound Delivery item has Status 'In Plant'	char	1	0	CHAR	(N' ')	Yes		/SPE/IMWRK_ITEM	Allow NULL?
266	SPE_LIFEXPOS2	External item identifier	nvarchar	35	0	CHAR	(N' ')	Yes		/SPE/DE_EXT_IDENT	Allow NULL?
267	SPE_EXCEPT_CODE	Exception Code Warehouse for Quantity Difference	nvarchar	4	0	CHAR	(N' ')	Yes		/SPE/INB_EXCEPT_CODE_WM	Allow NULL?
268	SPE_KEEP_QTY	Retention Quantity for Scrap. Process in EWM	decimal	13	3	QUAN	((0))	Yes		/SPE/KEEP_QUANTITY
269	SPE_ALTERNATE	Alternate Product Number	nvarchar	40	0	CHAR	(N' ')	Yes		/SPE/DE_ALTERNATE_PART_NR	Allow NULL?
270	SPE_MAT_SUBST	Reason for material substitution	char	1	0	CHAR	(N' ')	Yes		/SPE/MAT_SUBST	Allow NULL?
271	SPE_STRUC	Structure of Items That Are Delivered Together	nvarchar	3	0	NUMC	(N'000')	Yes		/SPE/STRUC	Allow NULL?
272	SPE_APO_QNTYFAC	Numerator of Quotient for Unit of Measure Conversion	decimal	5	0	DEC	((0))	Yes		APOQUANFACTOR
273	SPE_APO_QNTYDIV	Denominator of Quotient for Unit of Measure Conversion	decimal	5	0	DEC	((0))	Yes		APOQUANDIVISOR
274	SPE_HERKL	Country of origin of the material	nvarchar	3	0	CHAR	(N' ')	Yes	*	HERKL	Allow NULL?
275	SPE_BXP_DATE_EXT	Begin date of validity period of returns delivery	decimal	15	0	DEC	((0))	Yes		/SPE/RET_EXPIRY_DATE_EXT_B
276	SPE_VERSION	Delivery Version at Confirmation	nvarchar	4	0	NUMC	(N'0000')	Yes		/SPE/DE_DLV_VERSION	Allow NULL?
277	SPE_COMPL_MVT	Completion of Goods Movements after Difference Postings	char	1	0	CHAR	(N' ')	Yes		/SPE/COMPL_MVT	Allow NULL?
278	J_1BTAXLW4	COFINS Tax Law	nvarchar	3	0	CHAR	(N' ')	Yes	J_1BATL4A	J_1BTAXLW4	Allow NULL?
279	J_1BTAXLW5	PIS Tax Law	nvarchar	3	0	CHAR	(N' ')	Yes	J_1BATL5	J_1BTAXLW5	Allow NULL?
280	J_1BTAXLW3	ISS Tax Law	nvarchar	3	0	CHAR	(N' ')	Yes	J_1BATL3	J_1BTAXLW3	Allow NULL?
281	BUDGET_PD	FM: Budget Period	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_BUDGET_PERIOD	Allow NULL?
282	KBNKZ	Kanban Indicator	char	1	0	CHAR	(N' ')	Yes		KBNKZ	Allow NULL?
283	FARR_RELTYPE	Revenue Accounting Type	nvarchar	10	0	CHAR	(N' ')	Yes		FARR_RELTYPE	Allow NULL?
284	SITKZ	Specification for Issuing Valuated Stock in Transit	char	1	0	CHAR	(N' ')	Yes		SITKZ	Allow NULL?
285	SGT_RCAT	Requirement Segment	nvarchar	16	0	CHAR	(N' ')	Yes		SGT_RCAT	Allow NULL?
286	SGT_SCAT	Stock Segment	nvarchar	16	0	CHAR	(N' ')	Yes		SGT_SCAT	Allow NULL?
287	CONS_ORDER	Purchase Order for Consignment	char	1	0	CHAR	(N' ')	Yes		WRF_CONS_ORDER	Allow NULL?

TOP ERP 6.0 | ZEIM_LIPS INDEXES

Name	Primary	Unique	Type	Columns
ZEIM_LIPS~0	Yes	Yes	CLUSTERED	MANDT, VBELN, POSNR

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

287 COLUMNS | 1 INDEXES | ERP 6.0 | ZEIM_LIPS TABLE

TOP ERP 6.0 | ZEIM_LIPS COLUMNS

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

287 COLUMNS | 1 INDEXES | ERP 6.0 | ZEIM_LIPS TABLE

TOPERP 6.0 | ZEIM_LIPS COLUMNS

TOPERP 6.0 | ZEIM_LIPS INDEXES

TOP ERP 6.0 | ZEIM_LIPS COLUMNS

TOP ERP 6.0 | ZEIM_LIPS INDEXES