/LIME/IDOC_COLL_ITEM SAP (LIME - Item Data for LIME Collector - Deep Structure) Structure details

Dictionary Type: Structure
Description: LIME - Item Data for LIME Collector - Deep Structure




ABAP Code to SELECT data from /LIME/IDOC_COLL_ITEM
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
IDItem /LIME/LINE_ITEM_IDNUMC6
ID_PARENTReference to Higher-Level Item /LIME/LINE_ITEM_ID_PARENTNUMC6
ID_GROUPItem Group /LIME/LINE_ITEM_GROUPNUMC6
DIRECTIONDirection of Movement (In/Out/Transfer) /LIME/DIRECTIONCHAR1/LIME/DIRECTION
REVERSE_MODEReversal Indicator /LIME/REVERSE_MODECHAR1XFELD
ISSUE_ALLMove Total Stock /LIME/ISSUE_ALLCHAR1XFELD
TIMESTAMPUTC Time Stamp (YYYYMMDDhhmmss,mmmuuun) /LIME/TIMESTAMP_EXTDEC21(7) TZNTSTMPL
TIMESTAMP_ENDUTC Time Stamp (YYYYMMDDhhmmss,mmmuuun) End of Operation /LIME/TIMESTAMP_EXT_ENDDEC21(7) TZNTSTMPL
NOTENotes /LIME/NOTECHAR50
REASONReason for Movement /LIME/REASONCHAR4/LIME/REASON
EXT_VALUEExternal Value /LIME/EXT_VALUECURR13(2)
EXT_VALUE_CURRCurrency Key WAERSCUKY5WAERSFWS
VSIVirtual Stock Indicator /LIME/VSICHAR1/LIME/VSI
IC_DESCRIPDescription of Stock Change /LIME/IC_DESCRIPCHAR10
EEW_DUMMYDummy function in length 1 DUMMYCHAR1DUMMY
ACTION_TYPELIME-Line Category (Internal) /LIME/ACTION_TYPECHAR2/LIME/ACTION_TYPE
LOC 0
IDX_LOCCurrent Nummer of Key Table /LIME/KEY_INDEXCHAR3
GUID_LOCLocation GUID /LIME/GUID_LOCRAW16
WERKSPlant WERKS_DCHAR4WERKSWRKH_T001W_C
LGORTStorage Location LGORT_DCHAR4LGORTLAG
GLNGlobal Location Number /LIME/GLNNUMC13
DUNS4D-U-N-S+4 Number /LIME/DUNS4NUMC13
LOCIDGUID for Location /LIME/MDL_LOCIDRAW16SYSUUID
APO_LOCNOAPO Location /LIME/APO_LOCNOCHAR20
PARTNERPartner /LIME/PARTNERCHAR10ALPHABU_PARTNER
PARTNER_ROLEPartner Role /LIME/PARTNER_ROLECHAR2/LIME/PARTNER_ROLE
MOTIDMeans of Transport Identifier /LIME/MDL_MOTIDCHAR35
MOTSCODEStandard Code Means of Transport Acc.To UN/EDIFACT 8179 /LIME/MDL_MOTSCODECHAR4
.INCLU--AP 0
/SAPSLL/ECPIDCustoms ID for Customs Procedure with Economic Significance /SAPSLL/ECPID_SPICHAR10/SAPSLL/ECPID_SPI/SAPSLL/ECPID
STOCK 0
IDX_STOCKCurrent Nummer of Key Table /LIME/KEY_INDEXCHAR3
GUID_STOCKGUID Stock Item /LIME/GUID_STOCKRAW16
MATNRMaterial Number MATNRCHAR18MATN1MATNRMATS_MAT1
CHARGBatch Number CHARG_DCHAR10CHARGCHA
OWNEROwner /LIME/OWNERCHAR10ALPHABU_PARTNER
OWNER_ROLEPartner Role of Owner /LIME/OWNER_ROLECHAR2/LIME/PARTNER_ROLE
GTINGlobal Trade Item Number (GTIN) /LIME/GTINNUMC14
GTIN_VARIANTGlobal Trade Item Number (GTIN) Variant /LIME/GTIN_VARIANTNUMC2
CATStock Type /LIME/STOCK_CATEGORYCHAR2/LIME/STOCK_CATEGORY
STOCK_USAGEStock Usage /LIME/STOCK_USAGECHAR1/LIME/STOCK_USAGE
SALES_ORD_STOCKSales Order for Stock /LIME/SALES_ORD_STOCKCHAR10ALPHAVBELN
S_ORD_ITEM_STOCKSales Order Item for Stock /LIME/S_ORD_ITEM_STOCKNUMC6NUM06
WBS_STOCKWBS Element for Stock /LIME/WBS_STOCKCHAR24ABPSNPS_POSID
VRSIOIDGUID for Planning Version /LIME/MDL_VRSIOIDRAW16SYSUUID
PRDIDGUID for Product /LIME/MDL_PRDIDRAW16SYSUUID
APO_MATNRAPO Material Number /LIME/APO_MATNRCHAR40
.INCLU--AP 0
/SAPSLL/LOGSYSLogical system LOGSYSCHAR10ALPHALOGSYS
/SAPSLL/GUID_PRProduct GUID im 'RAW' Format /SAPSLL/IVM_GUID_PRODUCTRAW16SYSUUID
/SAPSLL/COOProduct's Country of Origin /SAPSLL/IVM_COOCHAR3LAND1
/SAPSLL/IDGDSAdditional ID for Stock Separation in CWH, IP, PUCC /SAPSLL/IDGDSCHAR20/SAPSLL/IDGDS
/SAPSLL/LOCIDLocation ID /SAPSLL/IVM_LOCIDCHAR3ALPHA/SAPSLL/IVM_LOCID
/SAPSLL/GUID_ITMItem GUID in 'RAW' Format /SAPSLL/IVM_GUID_DOC_ITEMRAW16SYSUUID
/SAPSLL/FIFODate of Release for FIFO /SAPSLL/IVM_FIFO_DATEDATS8DATUM
HU 0
IDX_HUCurrent Nummer of Key Table /LIME/KEY_INDEXCHAR3
GUID_HUGUID Handling Unit /LIME/GUID_HURAW16
SSCCSerial Shipping Container Code (NVE, Number Package) /LIME/SSCCNUMC18
T_PARAM 0
T_QCI_QUAN 0
T_USID 0
PARENT_TYPEType of Parents in Tree /LIME/TREE_PARENT_TYPECHAR1/LIME/TREE_PARENT_TYPE
T_PARENT 0
LOC_TARGET 0
IDX_LOCCurrent Nummer of Key Table /LIME/KEY_INDEXCHAR3
GUID_LOCLocation GUID /LIME/GUID_LOCRAW16
WERKSPlant WERKS_DCHAR4WERKSWRKH_T001W_C
LGORTStorage Location LGORT_DCHAR4LGORTLAG
GLNGlobal Location Number /LIME/GLNNUMC13
DUNS4D-U-N-S+4 Number /LIME/DUNS4NUMC13
LOCIDGUID for Location /LIME/MDL_LOCIDRAW16SYSUUID
APO_LOCNOAPO Location /LIME/APO_LOCNOCHAR20
PARTNERPartner /LIME/PARTNERCHAR10ALPHABU_PARTNER
PARTNER_ROLEPartner Role /LIME/PARTNER_ROLECHAR2/LIME/PARTNER_ROLE
MOTIDMeans of Transport Identifier /LIME/MDL_MOTIDCHAR35
MOTSCODEStandard Code Means of Transport Acc.To UN/EDIFACT 8179 /LIME/MDL_MOTSCODECHAR4
.INCLU--AP 0
/SAPSLL/ECPIDCustoms ID for Customs Procedure with Economic Significance /SAPSLL/ECPID_SPICHAR10/SAPSLL/ECPID_SPI/SAPSLL/ECPID
STOCK_TARGET 0
IDX_STOCKCurrent Nummer of Key Table /LIME/KEY_INDEXCHAR3
GUID_STOCKGUID Stock Item /LIME/GUID_STOCKRAW16
MATNRMaterial Number MATNRCHAR18MATN1MATNRMATS_MAT1
CHARGBatch Number CHARG_DCHAR10CHARGCHA
OWNEROwner /LIME/OWNERCHAR10ALPHABU_PARTNER
OWNER_ROLEPartner Role of Owner /LIME/OWNER_ROLECHAR2/LIME/PARTNER_ROLE
GTINGlobal Trade Item Number (GTIN) /LIME/GTINNUMC14
GTIN_VARIANTGlobal Trade Item Number (GTIN) Variant /LIME/GTIN_VARIANTNUMC2
CATStock Type /LIME/STOCK_CATEGORYCHAR2/LIME/STOCK_CATEGORY
STOCK_USAGEStock Usage /LIME/STOCK_USAGECHAR1/LIME/STOCK_USAGE
SALES_ORD_STOCKSales Order for Stock /LIME/SALES_ORD_STOCKCHAR10ALPHAVBELN
S_ORD_ITEM_STOCKSales Order Item for Stock /LIME/S_ORD_ITEM_STOCKNUMC6NUM06
WBS_STOCKWBS Element for Stock /LIME/WBS_STOCKCHAR24ABPSNPS_POSID
VRSIOIDGUID for Planning Version /LIME/MDL_VRSIOIDRAW16SYSUUID
PRDIDGUID for Product /LIME/MDL_PRDIDRAW16SYSUUID
APO_MATNRAPO Material Number /LIME/APO_MATNRCHAR40
.INCLU--AP 0
/SAPSLL/LOGSYSLogical system LOGSYSCHAR10ALPHALOGSYS
/SAPSLL/GUID_PRProduct GUID im 'RAW' Format /SAPSLL/IVM_GUID_PRODUCTRAW16SYSUUID
/SAPSLL/COOProduct's Country of Origin /SAPSLL/IVM_COOCHAR3LAND1
/SAPSLL/IDGDSAdditional ID for Stock Separation in CWH, IP, PUCC /SAPSLL/IDGDSCHAR20/SAPSLL/IDGDS
/SAPSLL/LOCIDLocation ID /SAPSLL/IVM_LOCIDCHAR3ALPHA/SAPSLL/IVM_LOCID
/SAPSLL/GUID_ITMItem GUID in 'RAW' Format /SAPSLL/IVM_GUID_DOC_ITEMRAW16SYSUUID
/SAPSLL/FIFODate of Release for FIFO /SAPSLL/IVM_FIFO_DATEDATS8DATUM
HU_TARGET 0
IDX_HUCurrent Nummer of Key Table /LIME/KEY_INDEXCHAR3
GUID_HUGUID Handling Unit /LIME/GUID_HURAW16
SSCCSerial Shipping Container Code (NVE, Number Package) /LIME/SSCCNUMC18
T_PARAM_TARGET 0
T_QCI_QUAN_TARGET 0
T_USID_TARGET 0
PARENT_TYPE_TARGETType of Parents in Tree /LIME/TREE_PARENT_TYPECHAR1/LIME/TREE_PARENT_TYPE
T_PARENT_TARGET 0
T_REFERENCE 0
T_ACC 0
TOP_LEVELLocation at Highest Hierarchy Level /LIME/TOP_LEVELCHAR1XFELD
LOC_MOVE_DATA 0
OWNEROwner /LIME/OWNERCHAR10ALPHABU_PARTNER
OWNER_ROLEPartner Role of Owner /LIME/OWNER_ROLECHAR2/LIME/PARTNER_ROLE
VSIVirtual Stock Indicator /LIME/VSICHAR1/LIME/VSI
XOWNERIndicator: Change Owner and Owner Role /LIME/XOWNERCHAR1XFELD
XVSIIndicator: Change VSI /LIME/XVSICHAR1XFELD
HU_MOVE_DATA 0
OWNEROwner /LIME/OWNERCHAR10ALPHABU_PARTNER
OWNER_ROLEPartner Role of Owner /LIME/OWNER_ROLECHAR2/LIME/PARTNER_ROLE
VSIVirtual Stock Indicator /LIME/VSICHAR1/LIME/VSI
XOWNERIndicator: Change Owner and Owner Role /LIME/XOWNERCHAR1XFELD
XVSIIndicator: Change VSI /LIME/XVSICHAR1XFELD

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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!