SAP ABAP Table BORGR_LIPS (Automotive: Inbound Delivery Item)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-SPM-INB (Application Component) Goods Receipt Process
     ⤷ LE_BOR (Package) Goods Receipt Processing for Inbound Delivery

Basic Data

Table Category	INTTAB	Structure
Structure	BORGR_LIPS	Table Relationship Diagram
Short Description	Automotive: Inbound Delivery Item

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
2	VBELN	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	VBUK
3	POSNR	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	VBUP
4	LIFEXPOS	☐	LIFEXPOS	POSNR	NUMC	6	0	External item number	*
5	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
6	ARKTX	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
7	LFIMG	☐	LFIMG	MENG13	QUAN	13	3	Actual quantity delivered (in sales units)
8	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
9	PIKMG	☐	PIKMG	MENG13	QUAN	13	3	Pick/stock quantity in sales units
10	VRKMP	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
11	LGMNG	☐	LGMNG	MENG13	QUAN	13	3	Actual quantity delivered in stockkeeping units
12	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
13	EBUMG	☐	EBUMG	MENG13	QUAN	13	3	Quantity to Book In in SUn (Sales Unit)
14	VBUMGX	☐	VBUMG	MENG13	QUAN	13	3	GR-Posted Quantity in SUn
15	ORMNG	☐	ORMNG_VL	MENG13	QUAN	13	3	Original Quantity of Delivery Item
16	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
17	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
18	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
19	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
20	KDMAT	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
21	LICHN	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number
22	NTGEW	☐	NTGEW_15	MENG15	QUAN	15	3	Net weight
23	BRGEW	☐	BRGEW_15	MENG15	QUAN	15	3	Gross weight
24	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
25	VOLUM	☐	VOLUM_15	MENG15	QUAN	15	3	Volume
26	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	*
27	VGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	*
28	VGPOS	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	*
29	PSTYV	☐	PSTYV_VL	PSTYV	CHAR	4	0	Delivery item category	TVPT
30	POSAR	☐	POSAR	POSAR	CHAR	1	0	Item type
31	UEPOS	☐	UEPOS	POSNR	NUMC	6	0	Higher-level item in bill of material structures	*
32	UECHA	☐	UECHA	POSNR	NUMC	6	0	Higher-Level Item of Batch Split Item	*
33	XCHPF	☐	XCHPF	XFELD	CHAR	1	0	Batch management requirement indicator
34	LGNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	T300
35	LGTOR	☐	UNLZONE	LGTOR	CHAR	3	0	Unloading Zone	T30B
36	LGBZO	☐	LGBZO	LGBZO	CHAR	10	0	Staging Area for Warehouse Complex	T30C
37	LGPBE	☐	LGPBE	CHAR10	CHAR	10	0	Storage Bin
38	PROFL	☐	ADGE_PROFL	ADGD_PROFL	CHAR	3	0	Dangerous goods indicator profile	TDG41
39	TRAGR	☐	TRAGR	TRAGR	CHAR	4	0	Transportation Group	TTGR
40	LADGR	☐	LADGR	LADGR	CHAR	4	0	Loading Group	TLGR
41	MFRGR	☐	MFRGR	MFRGR	CHAR	8	0	Material freight group	TMFG
42	HSDAT	☐	HSDAT	DATUM	DATS	8	0	Date of Manufacture
43	VFDAT	☐	VFDAT	DATUM	DATS	8	0	Shelf Life Expiration or Best-Before Date
44	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
45	PCKPF	☐	PCKPF	PCKPF	CHAR	1	0	Packing control
46	UMVKZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
47	UMVKN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
48	UEBTO	☐	UEBTO	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
49	UNTTO	☐	UNTTO	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
50	UEBTK	☐	UEBTK	XFELD	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
51	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	T156
52	INSMK	☐	INSMK	INSMK	CHAR	1	0	Stock Type
53	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
54	ABRVW	☐	ABRVW	ABRVW	CHAR	3	0	Usage Indicator	TVLV
55	NOWAB	☐	NOWAB	NOWAB	CHAR	1	0	Indicator: Item Not Relevant for Goods Movements
56	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
57	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
58	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
59	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
60	PABNUM	☐	PABNUM	PABNUM	CHAR	10	0	JIT Call Number	*
61	PABPOS	☐	PABPOS	PABPOS	NUMC	4	0	JIT call item
62	XPACK	☐	BORGR_XPACK	XFELD	CHAR	1	0	Bordero: Packing Item Indicator
63	XUPOS	☐	BORGR_XUPOS	XFELD	CHAR	1	0	Bordero: Subitem Indicator
64	ICON_MSG	☐	CHAR50	TEXT50	CHAR	50	0	Comment
65	ICON_POD	☐	BORGR_LIPS_ICON_D	SYCHAR132	CHAR	132	0	Icon for Item Text
66	ICON_TEXT	☐	BORGR_LIPS_ICON_D	SYCHAR132	CHAR	132	0	Icon for Item Text
67	ICON_PAB	☐	ICON_D	ICON	CHAR	4	0	Icon in text fields (substitute display, alias)	*
68	REFBEL	☐	BORREF_REFBEL	CHAR35	CHAR	35	0	Number of Reference Document for Inbound Delivery Item
69	REFPOS	☐	BORREF_REFPOS	NUMC6	NUMC	6	0	Item of Reference Document for Inbound Delivery Item
70	SPE_LIFEXPOS2	☐	/SPE/DE_EXT_IDENT	CHAR35	CHAR	35	0	External item identifier
71	VBUMG	☐	VBUMG	MENG13	QUAN	13	3	GR-Posted Quantity in SUn
72	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
73	POSNR_PP	☐	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BORGR_LIPS	ABRVW	TVLV	ABRVW
2	BORGR_LIPS	BWART	T156	BWART
3	BORGR_LIPS	BWTAR	T149D	BWTAR
4	BORGR_LIPS	CHARG	MCH1	CHARG
5	BORGR_LIPS	LADGR	TLGR	LADGR
6	BORGR_LIPS	LGBZO	T30C	LGBZO
7	BORGR_LIPS	LGNUM	T300	LGNUM
8	BORGR_LIPS	LGORT	T001L	LGORT
9	BORGR_LIPS	LGTOR	T30B	LGTOR
10	BORGR_LIPS	MANDT	T000	MANDT
11	BORGR_LIPS	MATNR	MARA	MATNR
12	BORGR_LIPS	MFRGR	TMFG	MFRGR
13	BORGR_LIPS	POSNR	VBUP	POSNR
14	BORGR_LIPS	PROFL	TDG41	PROFL
15	BORGR_LIPS	PSTYV	TVPT	PSTYV
16	BORGR_LIPS	SOBKZ	T148	SOBKZ
17	BORGR_LIPS	TRAGR	TTGR	TRAGR
18	BORGR_LIPS	VBELN	VBUK	VBELN
19	BORGR_LIPS	VRKME	T006	MSEHI
20	BORGR_LIPS	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in