SAP ABAP Table /LIME/QUERY_LOG_ITEM (Results Structure of Query Log)

Hierarchy

☛ SAP_AP (Software Component) SAP Application Platform
   ⤷ AP-LIM (Application Component) AP-LIM Logistics Inventory Management Engine
     ⤷ /LIME/PLT_CORE (Package) Platform - Core

Basic Data

Table Category	INTTAB	Structure
Structure	/LIME/QUERY_LOG_ITEM	Table Relationship Diagram
Short Description	Results Structure of Query Log

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	GUID_PN	☐	/LIME/GUID_PN		RAW	16	0	LIME GUID for Prima Nota
2	ID	☐	/LIME/LINE_ITEM_ID		NUMC	6	0	Item
3	DIRECTION	☐	/LIME/DIRECTION	/LIME/DIRECTION	CHAR	1	0	Direction of Movement (In/Out/Transfer)
4	NOTE	☐	/LIME/NOTE		CHAR	50	0	Notes
5	REASON	☐	/LIME/REASON	/LIME/REASON	CHAR	4	0	Reason for Movement
6	TIMESTAMP	☐	/LIME/TIMESTAMP_EXT	TZNTSTMPL	DEC	21	7	UTC Time Stamp (YYYYMMDDhhmmss,mmmuuun)
7	TIMESTAMP_END	☐	/LIME/TIMESTAMP_EXT_END	TZNTSTMPL	DEC	21	7	UTC Time Stamp (YYYYMMDDhhmmss,mmmuuun) End of Operation
8	IC_DESCRIP	☐	/LIME/IC_DESCRIP		CHAR	10	0	Description of Stock Change
9	.INCLUDE	☐				0	0	Business Keys for Locations
10	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
11	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location
12	GLN	☐	/LIME/GLN		NUMC	13	0	Global Location Number
13	DUNS4	☐	/LIME/DUNS4		NUMC	13	0	D-U-N-S+4 Number
14	LOCID	☐	/LIME/MDL_LOCID	SYSUUID	RAW	16	0	GUID for Location
15	APO_LOCNO	☐	/LIME/APO_LOCNO		CHAR	20	0	APO Location
16	PARTNER	☐	/LIME/PARTNER	BU_PARTNER	CHAR	10	0	Partner	*
17	PARTNER_ROLE	☐	/LIME/PARTNER_ROLE	/LIME/PARTNER_ROLE	CHAR	2	0	Partner Role
18	MOTID	☐	/LIME/MDL_MOTID		CHAR	35	0	Means of Transport Identifier
19	MOTSCODE	☐	/LIME/MDL_MOTSCODE		CHAR	4	0	Standard Code Means of Transport Acc.To UN/EDIFACT 8179
20	.INCLUDE	☐				0	0	Handling Unit Business Keys
21	SSCC	☐	/LIME/SSCC		NUMC	18	0	Serial Shipping Container Code (NVE, Number Package)
22	.INCLUDE	☐				0	0	Business Keys of Stock Item
23	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number
24	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number
25	OWNER	☐	/LIME/OWNER	BU_PARTNER	CHAR	10	0	Owner	*
26	OWNER_ROLE	☐	/LIME/OWNER_ROLE	/LIME/PARTNER_ROLE	CHAR	2	0	Partner Role of Owner
27	GTIN	☐	/LIME/GTIN		NUMC	14	0	Global Trade Item Number (GTIN)
28	GTIN_VARIANT	☐	/LIME/GTIN_VARIANT		NUMC	2	0	Global Trade Item Number (GTIN) Variant
29	CAT	☐	/LIME/STOCK_CATEGORY	/LIME/STOCK_CATEGORY	CHAR	2	0	Stock Type
30	STOCK_USAGE	☐	/LIME/STOCK_USAGE	/LIME/STOCK_USAGE	CHAR	1	0	Stock Usage
31	SALES_ORD_STOCK	☐	/LIME/SALES_ORD_STOCK	VBELN	CHAR	10	0	Sales Order for Stock
32	S_ORD_ITEM_STOCK	☐	/LIME/S_ORD_ITEM_STOCK	NUM06	NUMC	6	0	Sales Order Item for Stock
33	WBS_STOCK	☐	/LIME/WBS_STOCK	PS_POSID	CHAR	24	0	WBS Element for Stock
34	VRSIOID	☐	/LIME/MDL_VRSIOID	SYSUUID	RAW	16	0	GUID for Planning Version
35	PRDID	☐	/LIME/MDL_PRDID	SYSUUID	RAW	16	0	GUID for Product
36	APO_MATNR	☐	/LIME/APO_MATNR		CHAR	40	0	APO Material Number

History

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