SAP ABAP Table /LIME/COLL_LEG (Collection for External System)

Hierarchy

☛ SAP_AP (Software Component) SAP Application Platform
   ⤷ AP-LIM (Application Component) AP-LIM Logistics Inventory Management Engine
     ⤷ /LIME/RFC_CORE (Package) Core Package of the RFC Interface

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	/LIME/COLL_LEG	Table Relationship Diagram
Short Description	Collection for External System

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	*
2	GUID_COLL	☑	/LIME/GUID_COLL		RAW	16	0	GUID LIME Collection
3	.INCLUDE	☐				0	0	Technical Data for Dispatcher in Collection
4	GUID_DISPATCH	☐	/LIME/GUID_DISPATCH		RAW	16	0	GUID LIME Dispatcher Run
5	DISPATCH_TIME	☐	/LIME/DISPATCH_TIME	TZNTSTMPL	DEC	21	7	Dispatcher Record Processed (Time Stamp)
6	.INCLUDE	☐				0	0	Flat Work Document for LIME Collector
7	.INCLUDE	☐				0	0	Flat Work Document for LIME Collector (No Account Assignmt)
8	GUID_PN	☐	/LIME/GUID_PN		RAW	16	0	LIME GUID for Prima Nota
9	.INCLUDE	☐				0	0	Header Data not Copied in Document Items
10	EXT_DOC	☐	/LIME/EXT_DOC		CHAR	35	0	Number of LIME Document
11	PROCESS_TYPE	☐	/LIME/PROCESS_TYPE	/LIME/PROCESS_TYPE	CHAR	4	0	Application
12	.INCLUDE	☐				0	0	LIME - Item Data
13	.INCLUDE	☐				0	0	LIME - Technical Item Data
14	ID	☐	/LIME/LINE_ITEM_ID		NUMC	6	0	Item
15	ID_PARENT	☐	/LIME/LINE_ITEM_ID_PARENT		NUMC	6	0	Reference to Higher-Level Item
16	ID_GROUP	☐	/LIME/LINE_ITEM_GROUP		NUMC	6	0	Item Group
17	DIRECTION	☐	/LIME/DIRECTION	/LIME/DIRECTION	CHAR	1	0	Direction of Movement (In/Out/Transfer)
18	REVERSE_MODE	☐	/LIME/REVERSE_MODE	XFELD	CHAR	1	0	Reversal Indicator
19	ISSUE_ALL	☐	/LIME/ISSUE_ALL	XFELD	CHAR	1	0	Move Total Stock
20	.INCLUDE	☐				0	0	LIME - Application Data of Item
21	TIMESTAMP	☐	/LIME/TIMESTAMP_EXT	TZNTSTMPL	DEC	21	7	UTC Time Stamp (YYYYMMDDhhmmss,mmmuuun)
22	TIMESTAMP_END	☐	/LIME/TIMESTAMP_EXT_END	TZNTSTMPL	DEC	21	7	UTC Time Stamp (YYYYMMDDhhmmss,mmmuuun) End of Operation
23	NOTE	☐	/LIME/NOTE		CHAR	50	0	Notes
24	REASON	☐	/LIME/REASON	/LIME/REASON	CHAR	4	0	Reason for Movement
25	EXT_VALUE	☐	/LIME/EXT_VALUE		CURR	13	2	External Value
26	EXT_VALUE_CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
27	VSI	☐	/LIME/VSI	/LIME/VSI	CHAR	1	0	Virtual Stock Indicator
28	IC_DESCRIP	☐	/LIME/IC_DESCRIP		CHAR	10	0	Description of Stock Change
29	.INCLUDE	☐				0	0	LIME - Customer Enhancements for Item Data
30	EEW_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
31	ACTION_TYPE	☐	/LIME/ACTION_TYPE	/LIME/ACTION_TYPE	CHAR	2	0	LIME-Line Category (Internal)
32	TARGET	☐	/LIME/TARGET	/LIME/TARGET	CHAR	1	0	Describes Whether It Is Source or Target Data Record
33	.INCLUDE	☐				0	0	Location
34	IDX_LOC	☐	/LIME/KEY_INDEX		CHAR	3	0	Current Nummer of Key Table
35	GUID_LOC	☐	/LIME/GUID_LOC		RAW	16	0	Location GUID
36	.INCLUDE	☐				0	0	Business Keys for Locations
37	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
38	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location
39	GLN	☐	/LIME/GLN		NUMC	13	0	Global Location Number
40	DUNS4	☐	/LIME/DUNS4		NUMC	13	0	D-U-N-S+4 Number
41	LOCID	☐	/LIME/MDL_LOCID	SYSUUID	RAW	16	0	GUID for Location
42	APO_LOCNO	☐	/LIME/APO_LOCNO		CHAR	20	0	APO Location
43	PARTNER	☐	/LIME/PARTNER	BU_PARTNER	CHAR	10	0	Partner	*
44	PARTNER_ROLE	☐	/LIME/PARTNER_ROLE	/LIME/PARTNER_ROLE	CHAR	2	0	Partner Role
45	MOTID	☐	/LIME/MDL_MOTID		CHAR	35	0	Means of Transport Identifier
46	MOTSCODE	☐	/LIME/MDL_MOTSCODE		CHAR	4	0	Standard Code Means of Transport Acc.To UN/EDIFACT 8179
47	.INCLUDE	☐				0	0	Stock Key
48	IDX_STOCK	☐	/LIME/KEY_INDEX		CHAR	3	0	Current Nummer of Key Table
49	GUID_STOCK	☐	/LIME/GUID_STOCK		RAW	16	0	GUID Stock Item
50	.INCLUDE	☐				0	0	Business Keys of Stock Item
51	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number
52	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number
53	OWNER	☐	/LIME/OWNER	BU_PARTNER	CHAR	10	0	Owner	*
54	OWNER_ROLE	☐	/LIME/OWNER_ROLE	/LIME/PARTNER_ROLE	CHAR	2	0	Partner Role of Owner
55	GTIN	☐	/LIME/GTIN		NUMC	14	0	Global Trade Item Number (GTIN)
56	GTIN_VARIANT	☐	/LIME/GTIN_VARIANT		NUMC	2	0	Global Trade Item Number (GTIN) Variant
57	CAT	☐	/LIME/STOCK_CATEGORY	/LIME/STOCK_CATEGORY	CHAR	2	0	Stock Type
58	STOCK_USAGE	☐	/LIME/STOCK_USAGE	/LIME/STOCK_USAGE	CHAR	1	0	Stock Usage
59	SALES_ORD_STOCK	☐	/LIME/SALES_ORD_STOCK	VBELN	CHAR	10	0	Sales Order for Stock
60	S_ORD_ITEM_STOCK	☐	/LIME/S_ORD_ITEM_STOCK	NUM06	NUMC	6	0	Sales Order Item for Stock
61	WBS_STOCK	☐	/LIME/WBS_STOCK	PS_POSID	CHAR	24	0	WBS Element for Stock
62	VRSIOID	☐	/LIME/MDL_VRSIOID	SYSUUID	RAW	16	0	GUID for Planning Version
63	PRDID	☐	/LIME/MDL_PRDID	SYSUUID	RAW	16	0	GUID for Product
64	APO_MATNR	☐	/LIME/APO_MATNR		CHAR	40	0	APO Material Number
65	.INCLUDE	☐				0	0	Handling Unit
66	IDX_HU	☐	/LIME/KEY_INDEX		CHAR	3	0	Current Nummer of Key Table
67	GUID_HU	☐	/LIME/GUID_HU		RAW	16	0	GUID Handling Unit
68	.INCLUDE	☐				0	0	Handling Unit Business Keys
69	SSCC	☐	/LIME/SSCC		NUMC	18	0	Serial Shipping Container Code (NVE, Number Package)
70	.INCLUDE	☐				0	0	LIME - Quantities for Conversion Machines
71	QUAN	☐	/LIME/QUANTITY	/LIME/QUANTITY	QUAN	31	14	Stock Quantity
72	QUAN_PREV	☐	/LIME/QUANTITY	/LIME/QUANTITY	QUAN	31	14	Stock Quantity
73	PREV_IND	☐	/LIME/PREV_IND	XFELD	CHAR	1	0	Check Previous Stock Quantity if = 'X'
74	.INCLUDE	☐				0	0	Units of Measure and Indicators for Calculation and Posting
75	UNIT	☐	/LIME/UNIT	MEINS	UNIT	3	0	Stock Unit of Measure	*
76	.INCLUDE	☐				0	0	IDs for LIME Units of Measure
77	STOCKUNIT	☐	/LIME/STOCKUNIT	XFELD	CHAR	1	0	Indicator for Inventory-Managed Quantities
78	NOCALC	☐	/LIME/NOCALC	/LIME/NOCALC	CHAR	1	0	Indicator to Control Quantity Calculation
79	SERIALUNIT	☐	/LIME/SERIALUNIT	XFELD	CHAR	1	0	Serial-Number-Relevant Unit of Measure
80	VALUATIONUNIT	☐	/LIME/VALUATIONUNIT	XFELD	CHAR	1	0	Unit is Relevant for Valuation
81	.INCLUDE	☐				0	0	Reference Document
82	PO_NUMBER	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
83	PO_ITEM	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
84	PO_COMPLETE	☐	/LIME/OBSOLET_PO_COMPLETE	XFELD	CHAR	1	0	Obsolete With SCM4.1
85	ORDER_NUMBER	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
86	ORDER_ITEM	☐	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
87	ORDER_COMPLETE	☐	/LIME/OBSOLET_ORDER_COMPLETE	XFELD	CHAR	1	0	Obsolete With SCM4.1
88	DELIVERY	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number
89	DELIVERY_ITEM	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document
90	DELIV_COMPLETE	☐	/LIME/OBSOLET_DELIV_COMPLETE	XFELD	CHAR	1	0	Obsolete With SCM4.1
91	MAT_DOC	☐	/LIME/MAT_DOC	BELNR	CHAR	10	0	R/3 Material Document
92	MAT_DOC_YEAR	☐	/LIME/MAT_DOC_YEAR	GJAHR	NUMC	4	0	Material Document Year
93	MAT_DOC_ITEM	☐	/LIME/MAT_DOC_ITEM		NUMC	4	0	Item in Material Document
94	RESERV_NO	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
95	RES_ITEM	☐	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
96	RES_TYPE	☐	RSART	RSART	CHAR	1	0	Record type
97	RES_COMPLETE	☐	/LIME/OBSOLET_KZEAR	XFELD	CHAR	1	0	Obsolete With SCM4.1
98	TOP_LEVEL	☐	/LIME/TOP_LEVEL	XFELD	CHAR	1	0	Location at Highest Hierarchy Level
99	GUID_COLL_GROUP	☐	/LIME/GUID_COLL_GROUP		RAW	16	0	GUID for Collection Grouping
100	.INCLUDE	☐				0	0	Account Assgt Fields for LIME (for Collector)
101	COSTCENTER	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
102	ORDERID	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
103	ORDER_ITNO	☐	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
104	WBS_ELEMENT	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
105	NETWORK	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
106	SALES_ORD	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number
107	SCHED_LINE	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
108	S_ORD_ITEM	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
109	ACTIVITY	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
110	CMMT_ITEM	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
111	ASSETMAINNO	☐	BF_ANLN1	BF_ANLN1	CHAR	12	0	Main Asset Number
112	ASSETSUBNO	☐	BF_ANLN2	BF_ANLN2	CHAR	4	0	Asset Subnumber
113	FUNDS_CTR	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
114	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
115	FUNC_AREA	☐	FKBER_SHORT	FKBER_SHORT	CHAR	4	0	Functional Area
116	ACTTYPE	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
117	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
118	.INCLUDE	☐				0	0	BAdI Structure for Legacy Collection
119	BADI_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

History

Last changed by/on	SAP	20110908
SAP Release Created in	401