/LIME/IDOC_COLL_ITEM SAP (LIME - Item Data for LIME Collector - Deep Structure) Structure details
Description: LIME - Item Data for LIME Collector - Deep Structure
Related tables to /LIME/IDOC_COLL_ITEM
Access table /LIME/IDOC_COLL_ITEM
Structure field list including key, data, relationships and ABAP select examples
/LIME/IDOC_COLL_ITEM is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "LIME - Item Data for LIME Collector - Deep Structure" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_/LIME/IDOC_COLL_ITEM TYPE /LIME/IDOC_COLL_ITEM.
The /LIME/IDOC_COLL_ITEM table consists of various fields, each holding specific information or linking keys about LIME - Item Data for LIME Collector - Deep Structure data available in SAP. These include ID (Item), ID_PARENT (Reference to Higher-Level Item), ID_GROUP (Item Group), DIRECTION (Direction of Movement (In/Out/Transfer)).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)
SAP /LIME/IDOC_COLL_ITEM structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
DATA | 0 | ||||||||
ID | Item | /LIME/LINE_ITEM_ID | NUMC | 6 | |||||
ID_PARENT | Reference to Higher-Level Item | /LIME/LINE_ITEM_ID_PARENT | NUMC | 6 | |||||
ID_GROUP | Item Group | /LIME/LINE_ITEM_GROUP | NUMC | 6 | |||||
DIRECTION | Direction of Movement (In/Out/Transfer) | /LIME/DIRECTION | CHAR | 1 | /LIME/DIRECTION | ||||
REVERSE_MODE | Reversal Indicator | /LIME/REVERSE_MODE | CHAR | 1 | XFELD | ||||
ISSUE_ALL | Move Total Stock | /LIME/ISSUE_ALL | CHAR | 1 | XFELD | ||||
TIMESTAMP | UTC Time Stamp (YYYYMMDDhhmmss,mmmuuun) | /LIME/TIMESTAMP_EXT | DEC | 21(7) | TZNTSTMPL | ||||
TIMESTAMP_END | UTC Time Stamp (YYYYMMDDhhmmss,mmmuuun) End of Operation | /LIME/TIMESTAMP_EXT_END | DEC | 21(7) | TZNTSTMPL | ||||
NOTE | Notes | /LIME/NOTE | CHAR | 50 | |||||
REASON | Reason for Movement | /LIME/REASON | CHAR | 4 | /LIME/REASON | ||||
EXT_VALUE | External Value | /LIME/EXT_VALUE | CURR | 13(2) | |||||
EXT_VALUE_CURR | Currency Key | WAERS | CUKY | 5 | WAERS | FWS | |||
VSI | Virtual Stock Indicator | /LIME/VSI | CHAR | 1 | /LIME/VSI | ||||
IC_DESCRIP | Description of Stock Change | /LIME/IC_DESCRIP | CHAR | 10 | |||||
EEW_DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
ACTION_TYPE | LIME-Line Category (Internal) | /LIME/ACTION_TYPE | CHAR | 2 | /LIME/ACTION_TYPE | ||||
LOC | 0 | ||||||||
IDX_LOC | Current Nummer of Key Table | /LIME/KEY_INDEX | CHAR | 3 | |||||
GUID_LOC | Location GUID | /LIME/GUID_LOC | RAW | 16 | |||||
WERKS | Plant | WERKS_D | CHAR | 4 | WERKS | WRK | H_T001W_C | ||
LGORT | Storage Location | LGORT_D | CHAR | 4 | LGORT | LAG | |||
GLN | Global Location Number | /LIME/GLN | NUMC | 13 | |||||
DUNS4 | D-U-N-S+4 Number | /LIME/DUNS4 | NUMC | 13 | |||||
LOCID | GUID for Location | /LIME/MDL_LOCID | RAW | 16 | SYSUUID | ||||
APO_LOCNO | APO Location | /LIME/APO_LOCNO | CHAR | 20 | |||||
PARTNER | Partner | /LIME/PARTNER | CHAR | 10 | ALPHA | BU_PARTNER | |||
PARTNER_ROLE | Partner Role | /LIME/PARTNER_ROLE | CHAR | 2 | /LIME/PARTNER_ROLE | ||||
MOTID | Means of Transport Identifier | /LIME/MDL_MOTID | CHAR | 35 | |||||
MOTSCODE | Standard Code Means of Transport Acc.To UN/EDIFACT 8179 | /LIME/MDL_MOTSCODE | CHAR | 4 | |||||
.INCLU--AP | 0 | ||||||||
/SAPSLL/ECPID | Customs ID for Customs Procedure with Economic Significance | /SAPSLL/ECPID_SPI | CHAR | 10 | /SAPSLL/ECPID_SPI | /SAPSLL/ECPID | |||
STOCK | 0 | ||||||||
IDX_STOCK | Current Nummer of Key Table | /LIME/KEY_INDEX | CHAR | 3 | |||||
GUID_STOCK | GUID Stock Item | /LIME/GUID_STOCK | RAW | 16 | |||||
MATNR | Material Number | MATNR | CHAR | 18 | MATN1 | MATNR | MAT | S_MAT1 | |
CHARG | Batch Number | CHARG_D | CHAR | 10 | CHARG | CHA | |||
OWNER | Owner | /LIME/OWNER | CHAR | 10 | ALPHA | BU_PARTNER | |||
OWNER_ROLE | Partner Role of Owner | /LIME/OWNER_ROLE | CHAR | 2 | /LIME/PARTNER_ROLE | ||||
GTIN | Global Trade Item Number (GTIN) | /LIME/GTIN | NUMC | 14 | |||||
GTIN_VARIANT | Global Trade Item Number (GTIN) Variant | /LIME/GTIN_VARIANT | NUMC | 2 | |||||
CAT | Stock Type | /LIME/STOCK_CATEGORY | CHAR | 2 | /LIME/STOCK_CATEGORY | ||||
STOCK_USAGE | Stock Usage | /LIME/STOCK_USAGE | CHAR | 1 | /LIME/STOCK_USAGE | ||||
SALES_ORD_STOCK | Sales Order for Stock | /LIME/SALES_ORD_STOCK | CHAR | 10 | ALPHA | VBELN | |||
S_ORD_ITEM_STOCK | Sales Order Item for Stock | /LIME/S_ORD_ITEM_STOCK | NUMC | 6 | NUM06 | ||||
WBS_STOCK | WBS Element for Stock | /LIME/WBS_STOCK | CHAR | 24 | ABPSN | PS_POSID | |||
VRSIOID | GUID for Planning Version | /LIME/MDL_VRSIOID | RAW | 16 | SYSUUID | ||||
PRDID | GUID for Product | /LIME/MDL_PRDID | RAW | 16 | SYSUUID | ||||
APO_MATNR | APO Material Number | /LIME/APO_MATNR | CHAR | 40 | |||||
.INCLU--AP | 0 | ||||||||
/SAPSLL/LOGSYS | Logical system | LOGSYS | CHAR | 10 | ALPHA | LOGSYS | |||
/SAPSLL/GUID_PR | Product GUID im 'RAW' Format | /SAPSLL/IVM_GUID_PRODUCT | RAW | 16 | SYSUUID | ||||
/SAPSLL/COO | Product's Country of Origin | /SAPSLL/IVM_COO | CHAR | 3 | LAND1 | ||||
/SAPSLL/IDGDS | Additional ID for Stock Separation in CWH, IP, PUCC | /SAPSLL/IDGDS | CHAR | 20 | /SAPSLL/IDGDS | ||||
/SAPSLL/LOCID | Location ID | /SAPSLL/IVM_LOCID | CHAR | 3 | ALPHA | /SAPSLL/IVM_LOCID | |||
/SAPSLL/GUID_ITM | Item GUID in 'RAW' Format | /SAPSLL/IVM_GUID_DOC_ITEM | RAW | 16 | SYSUUID | ||||
/SAPSLL/FIFO | Date of Release for FIFO | /SAPSLL/IVM_FIFO_DATE | DATS | 8 | DATUM | ||||
HU | 0 | ||||||||
IDX_HU | Current Nummer of Key Table | /LIME/KEY_INDEX | CHAR | 3 | |||||
GUID_HU | GUID Handling Unit | /LIME/GUID_HU | RAW | 16 | |||||
SSCC | Serial Shipping Container Code (NVE, Number Package) | /LIME/SSCC | NUMC | 18 | |||||
T_PARAM | 0 | ||||||||
T_QCI_QUAN | 0 | ||||||||
T_USID | 0 | ||||||||
PARENT_TYPE | Type of Parents in Tree | /LIME/TREE_PARENT_TYPE | CHAR | 1 | /LIME/TREE_PARENT_TYPE | ||||
T_PARENT | 0 | ||||||||
LOC_TARGET | 0 | ||||||||
IDX_LOC | Current Nummer of Key Table | /LIME/KEY_INDEX | CHAR | 3 | |||||
GUID_LOC | Location GUID | /LIME/GUID_LOC | RAW | 16 | |||||
WERKS | Plant | WERKS_D | CHAR | 4 | WERKS | WRK | H_T001W_C | ||
LGORT | Storage Location | LGORT_D | CHAR | 4 | LGORT | LAG | |||
GLN | Global Location Number | /LIME/GLN | NUMC | 13 | |||||
DUNS4 | D-U-N-S+4 Number | /LIME/DUNS4 | NUMC | 13 | |||||
LOCID | GUID for Location | /LIME/MDL_LOCID | RAW | 16 | SYSUUID | ||||
APO_LOCNO | APO Location | /LIME/APO_LOCNO | CHAR | 20 | |||||
PARTNER | Partner | /LIME/PARTNER | CHAR | 10 | ALPHA | BU_PARTNER | |||
PARTNER_ROLE | Partner Role | /LIME/PARTNER_ROLE | CHAR | 2 | /LIME/PARTNER_ROLE | ||||
MOTID | Means of Transport Identifier | /LIME/MDL_MOTID | CHAR | 35 | |||||
MOTSCODE | Standard Code Means of Transport Acc.To UN/EDIFACT 8179 | /LIME/MDL_MOTSCODE | CHAR | 4 | |||||
.INCLU--AP | 0 | ||||||||
/SAPSLL/ECPID | Customs ID for Customs Procedure with Economic Significance | /SAPSLL/ECPID_SPI | CHAR | 10 | /SAPSLL/ECPID_SPI | /SAPSLL/ECPID | |||
STOCK_TARGET | 0 | ||||||||
IDX_STOCK | Current Nummer of Key Table | /LIME/KEY_INDEX | CHAR | 3 | |||||
GUID_STOCK | GUID Stock Item | /LIME/GUID_STOCK | RAW | 16 | |||||
MATNR | Material Number | MATNR | CHAR | 18 | MATN1 | MATNR | MAT | S_MAT1 | |
CHARG | Batch Number | CHARG_D | CHAR | 10 | CHARG | CHA | |||
OWNER | Owner | /LIME/OWNER | CHAR | 10 | ALPHA | BU_PARTNER | |||
OWNER_ROLE | Partner Role of Owner | /LIME/OWNER_ROLE | CHAR | 2 | /LIME/PARTNER_ROLE | ||||
GTIN | Global Trade Item Number (GTIN) | /LIME/GTIN | NUMC | 14 | |||||
GTIN_VARIANT | Global Trade Item Number (GTIN) Variant | /LIME/GTIN_VARIANT | NUMC | 2 | |||||
CAT | Stock Type | /LIME/STOCK_CATEGORY | CHAR | 2 | /LIME/STOCK_CATEGORY | ||||
STOCK_USAGE | Stock Usage | /LIME/STOCK_USAGE | CHAR | 1 | /LIME/STOCK_USAGE | ||||
SALES_ORD_STOCK | Sales Order for Stock | /LIME/SALES_ORD_STOCK | CHAR | 10 | ALPHA | VBELN | |||
S_ORD_ITEM_STOCK | Sales Order Item for Stock | /LIME/S_ORD_ITEM_STOCK | NUMC | 6 | NUM06 | ||||
WBS_STOCK | WBS Element for Stock | /LIME/WBS_STOCK | CHAR | 24 | ABPSN | PS_POSID | |||
VRSIOID | GUID for Planning Version | /LIME/MDL_VRSIOID | RAW | 16 | SYSUUID | ||||
PRDID | GUID for Product | /LIME/MDL_PRDID | RAW | 16 | SYSUUID | ||||
APO_MATNR | APO Material Number | /LIME/APO_MATNR | CHAR | 40 | |||||
.INCLU--AP | 0 | ||||||||
/SAPSLL/LOGSYS | Logical system | LOGSYS | CHAR | 10 | ALPHA | LOGSYS | |||
/SAPSLL/GUID_PR | Product GUID im 'RAW' Format | /SAPSLL/IVM_GUID_PRODUCT | RAW | 16 | SYSUUID | ||||
/SAPSLL/COO | Product's Country of Origin | /SAPSLL/IVM_COO | CHAR | 3 | LAND1 | ||||
/SAPSLL/IDGDS | Additional ID for Stock Separation in CWH, IP, PUCC | /SAPSLL/IDGDS | CHAR | 20 | /SAPSLL/IDGDS | ||||
/SAPSLL/LOCID | Location ID | /SAPSLL/IVM_LOCID | CHAR | 3 | ALPHA | /SAPSLL/IVM_LOCID | |||
/SAPSLL/GUID_ITM | Item GUID in 'RAW' Format | /SAPSLL/IVM_GUID_DOC_ITEM | RAW | 16 | SYSUUID | ||||
/SAPSLL/FIFO | Date of Release for FIFO | /SAPSLL/IVM_FIFO_DATE | DATS | 8 | DATUM | ||||
HU_TARGET | 0 | ||||||||
IDX_HU | Current Nummer of Key Table | /LIME/KEY_INDEX | CHAR | 3 | |||||
GUID_HU | GUID Handling Unit | /LIME/GUID_HU | RAW | 16 | |||||
SSCC | Serial Shipping Container Code (NVE, Number Package) | /LIME/SSCC | NUMC | 18 | |||||
T_PARAM_TARGET | 0 | ||||||||
T_QCI_QUAN_TARGET | 0 | ||||||||
T_USID_TARGET | 0 | ||||||||
PARENT_TYPE_TARGET | Type of Parents in Tree | /LIME/TREE_PARENT_TYPE | CHAR | 1 | /LIME/TREE_PARENT_TYPE | ||||
T_PARENT_TARGET | 0 | ||||||||
T_REFERENCE | 0 | ||||||||
T_ACC | 0 | ||||||||
TOP_LEVEL | Location at Highest Hierarchy Level | /LIME/TOP_LEVEL | CHAR | 1 | XFELD | ||||
LOC_MOVE_DATA | 0 | ||||||||
OWNER | Owner | /LIME/OWNER | CHAR | 10 | ALPHA | BU_PARTNER | |||
OWNER_ROLE | Partner Role of Owner | /LIME/OWNER_ROLE | CHAR | 2 | /LIME/PARTNER_ROLE | ||||
VSI | Virtual Stock Indicator | /LIME/VSI | CHAR | 1 | /LIME/VSI | ||||
XOWNER | Indicator: Change Owner and Owner Role | /LIME/XOWNER | CHAR | 1 | XFELD | ||||
XVSI | Indicator: Change VSI | /LIME/XVSI | CHAR | 1 | XFELD | ||||
HU_MOVE_DATA | 0 | ||||||||
OWNER | Owner | /LIME/OWNER | CHAR | 10 | ALPHA | BU_PARTNER | |||
OWNER_ROLE | Partner Role of Owner | /LIME/OWNER_ROLE | CHAR | 2 | /LIME/PARTNER_ROLE | ||||
VSI | Virtual Stock Indicator | /LIME/VSI | CHAR | 1 | /LIME/VSI | ||||
XOWNER | Indicator: Change Owner and Owner Role | /LIME/XOWNER | CHAR | 1 | XFELD | ||||
XVSI | Indicator: Change VSI | /LIME/XVSI | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP structure /LIME/IDOC_COLL_ITEM using ABAP code?
As /LIME/IDOC_COLL_ITEM is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on /LIME/IDOC_COLL_ITEM as there is no data to select.How to access SAP table /LIME/IDOC_COLL_ITEM
Within an ECC or HANA version of SAP you can also view further information about /LIME/IDOC_COLL_ITEM and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects