/LIME/COLL_BW SAP (Collection for Business Warehouse) Table details
Dictionary Type: Table
Description: Collection for Business Warehouse
Description: Collection for Business Warehouse
ABAP Code to SELECT data from /LIME/COLL_BW
Related tables to /LIME/COLL_BW
Access table /LIME/COLL_BW
Related tables to /LIME/COLL_BW
Access table /LIME/COLL_BW
Table field list including key, data, relationships and ABAP select examples
/LIME/COLL_BW is a standard SAP Table which is used to store Collection for Business Warehouse data and is available within R/3 SAP systems depending on the version and release level.
The /LIME/COLL_BW table consists of various fields, each holding specific information or linking keys about Collection for Business Warehouse data available in SAP. These include GUID_COLL (GUID LIME Collection), GUID_DISPATCH (GUID LIME Dispatcher Run), DISPATCH_TIME (Dispatcher Record Processed (Time Stamp)), GUID_PN (LIME GUID for Prima Nota).. 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: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP /LIME/COLL_BW table 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 |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
GUID_COLL | GUID LIME Collection | /LIME/GUID_COLL | RAW | 16 | |||||
GUID_DISPATCH | GUID LIME Dispatcher Run | /LIME/GUID_DISPATCH | RAW | 16 | |||||
DISPATCH_TIME | Dispatcher Record Processed (Time Stamp) | /LIME/DISPATCH_TIME | DEC | 21(7) | TZNTSTMPL | ||||
GUID_PN | LIME GUID for Prima Nota | /LIME/GUID_PN | RAW | 16 | |||||
EXT_DOC | Number of LIME Document | /LIME/EXT_DOC | CHAR | 35 | |||||
PROCESS_TYPE | Application | /LIME/PROCESS_TYPE | CHAR | 4 | /LIME/PROCESS_TYPE | ||||
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 | Assigned to domain | 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 | ||||
TARGET | Describes Whether It Is Source or Target Data Record | /LIME/TARGET | CHAR | 1 | /LIME/TARGET | ||||
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 | Assigned to domain | WERKS | WRK | H_T001W_C | |
LGORT | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | 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 | Assigned to domain | 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 | Assigned to domain | /SAPSLL/ECPID_SPI | /SAPSLL/ECPID | ||
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 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
CHARG | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
OWNER | Owner | /LIME/OWNER | CHAR | 10 | Assigned to domain | 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 | Assigned to domain | 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 | Assigned to domain | 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 | Assigned to domain | 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 | ||||
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 | |||||
QUAN | Stock Quantity | /LIME/QUANTITY | QUAN | 31(14) | /LIME/QUANTITY | ||||
QUAN_PREV | Stock Quantity | /LIME/QUANTITY | QUAN | 31(14) | /LIME/QUANTITY | ||||
PREV_IND | Check Previous Stock Quantity if = 'X' | /LIME/PREV_IND | CHAR | 1 | XFELD | ||||
UNIT | Stock Unit of Measure | /LIME/UNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
STOCKUNIT | Indicator for Inventory-Managed Quantities | /LIME/STOCKUNIT | CHAR | 1 | XFELD | ||||
NOCALC | Indicator to Control Quantity Calculation | /LIME/NOCALC | CHAR | 1 | /LIME/NOCALC | ||||
SERIALUNIT | Serial-Number-Relevant Unit of Measure | /LIME/SERIALUNIT | CHAR | 1 | XFELD | ||||
VALUATIONUNIT | Unit is Relevant for Valuation | /LIME/VALUATIONUNIT | CHAR | 1 | XFELD | ||||
PO_NUMBER | Purchasing Document Number | EBELN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | BES | MEKK_C |
PO_ITEM | Item Number of Purchasing Document | EBELP | NUMC | 5 | Assigned to domain | EBELP | BSP | ||
PO_COMPLETE | Obsolete With SCM4.1 | /LIME/OBSOLET_PO_COMPLETE | CHAR | 1 | XFELD | ||||
ORDER_NUMBER | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
ORDER_ITEM | Order Item Number | CO_POSNR | NUMC | 4 | CO_POSNR | ||||
ORDER_COMPLETE | Obsolete With SCM4.1 | /LIME/OBSOLET_ORDER_COMPLETE | CHAR | 1 | XFELD | ||||
DELIVERY | Sales and Distribution Document Number | VBELN | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
DELIVERY_ITEM | Item number of the SD document | POSNR | NUMC | 6 | Assigned to domain | POSNR | |||
DELIV_COMPLETE | Obsolete With SCM4.1 | /LIME/OBSOLET_DELIV_COMPLETE | CHAR | 1 | XFELD | ||||
MAT_DOC | R/3 Material Document | /LIME/MAT_DOC | CHAR | 10 | ALPHA | BELNR | |||
MAT_DOC_YEAR | Material Document Year | /LIME/MAT_DOC_YEAR | NUMC | 4 | GJAHR | GJAHR | |||
MAT_DOC_ITEM | Item in Material Document | /LIME/MAT_DOC_ITEM | NUMC | 4 | |||||
RESERV_NO | Number of Reservation/Dependent Requirement | RSNUM | NUMC | 10 | Assigned to domain | RSNUM | RES | ||
RES_ITEM | Item Number of Reservation/Dependent Requirement | RSPOS | NUMC | 4 | RSPOS | RPO | |||
RES_TYPE | Record type | RSART | CHAR | 1 | RSART | ||||
RES_COMPLETE | Obsolete With SCM4.1 | /LIME/OBSOLET_KZEAR | CHAR | 1 | XFELD | ||||
TOP_LEVEL | Location at Highest Hierarchy Level | /LIME/TOP_LEVEL | CHAR | 1 | XFELD | ||||
GUID_COLL_GROUP | GUID for Collection Grouping | /LIME/GUID_COLL_GROUP | RAW | 16 | |||||
COSTCENTER | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
ORDERID | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
ORDER_ITNO | Order Item Number | CO_POSNR | NUMC | 4 | CO_POSNR | ||||
WBS_ELEMENT | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR | 24 | PROJN | PS_POSID | PRO | ||
NETWORK | Network Number for Account Assignment | NPLNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | NET | |
SALES_ORD | Sales Order Number | KDAUF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
SCHED_LINE | Delivery Schedule for Sales Order | KDEIN | NUMC | 4 | NUM04 | ||||
S_ORD_ITEM | Item Number in Sales Order | KDPOS | NUMC | 6 | NUM06 | KPO | |||
ACTIVITY | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
CMMT_ITEM | Commitment Item | FIPOS | CHAR | 14 | Assigned to domain | FIPOS | FIP | ||
ASSETMAINNO | Main Asset Number | BF_ANLN1 | CHAR | 12 | ALPHA | BF_ANLN1 | AN1 | ||
ASSETSUBNO | Asset Subnumber | BF_ANLN2 | CHAR | 4 | ALPHA | BF_ANLN2 | AN2 | ||
FUNDS_CTR | Funds Center | FISTL | CHAR | 16 | Assigned to domain | FISTL | FIS | ||
GEBER | Fund | BP_GEBER | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
FUNC_AREA | Functional Area | FKBER_SHORT | CHAR | 4 | FKBER_SHORT | FBE | |||
ACTTYPE | Activity Type | LSTAR | CHAR | 6 | Assigned to domain | LSTAR | LAR | LART_EMPTY | |
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
DATUM | Date | DATUM | DATS | 8 | DATUM |
Key field | Non-key field |
How do I retrieve data from SAP table /LIME/COLL_BW using ABAP code
The following ABAP code Example will allow you to do a basic selection on /LIME/COLL_BW to SELECT all data from the tableDATA: WA_/LIME/COLL_BW TYPE /LIME/COLL_BW.
SELECT SINGLE *
FROM /LIME/COLL_BW
INTO CORRESPONDING FIELDS OF WA_/LIME/COLL_BW
WHERE...
How to access SAP table /LIME/COLL_BW
Within an ECC or HANA version of SAP you can also view further information about /LIME/COLL_BW 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