/LIME/COLL_FIN SAP (Collection for Financial System) Table details
Dictionary Type: Table
Description: Collection for Financial System
Description: Collection for Financial System
ABAP Code to SELECT data from /LIME/COLL_FIN
Related tables to /LIME/COLL_FIN
Access table /LIME/COLL_FIN
Related tables to /LIME/COLL_FIN
Access table /LIME/COLL_FIN
Table field list including key, data, relationships and ABAP select examples
/LIME/COLL_FIN is a standard SAP Table which is used to store Collection for Financial System data and is available within R/3 SAP systems depending on the version and release level.
The /LIME/COLL_FIN table consists of various fields, each holding specific information or linking keys about Collection for Financial System 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_FIN 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 | ||||
MAT_DOC_ITEM | Item in Material Document | /LIME/MAT_DOC_ITEM | NUMC | 4 | |||||
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 | |
APO_MATNR_T | APO Material Number | /LIME/APO_MATNR | CHAR | 40 | |||||
OWNER_T | Owner | /LIME/OWNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | ||
OWNER_ROLE_T | Partner Role of Owner | /LIME/OWNER_ROLE | CHAR | 2 | /LIME/PARTNER_ROLE | ||||
CAT_T | Stock Type | /LIME/STOCK_CATEGORY | CHAR | 2 | /LIME/STOCK_CATEGORY | ||||
APO_LOCNO_T | APO Location | /LIME/APO_LOCNO | CHAR | 20 | |||||
BUS_TRANS_TYPE | Not More Closely Defined Area, Possibly Used for Patchlevels | CHAR4 | CHAR | 4 | CHAR4 | ||||
DOC_ID_1 | Document ID of Reference Document | /LIME/REF_DOC_ID | CHAR | 70 | /LIME/REF_DOC_ID | ||||
DOC_TYPE_1 | Document Type of Reference Document | /LIME/REF_DOC_TYPE | CHAR | 10 | /LIME/REF_DOC_TYPE | ||||
DOC_LOGSYS_1 | Logical system | LOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
DOC_ID_2 | Document ID of Reference Document | /LIME/REF_DOC_ID | CHAR | 70 | /LIME/REF_DOC_ID | ||||
DOC_TYPE_2 | Document Type of Reference Document | /LIME/REF_DOC_TYPE | CHAR | 10 | /LIME/REF_DOC_TYPE | ||||
DOC_LOGSYS_2 | Logical system | LOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS |
Key field | Non-key field |
How do I retrieve data from SAP table /LIME/COLL_FIN using ABAP code
The following ABAP code Example will allow you to do a basic selection on /LIME/COLL_FIN to SELECT all data from the tableDATA: WA_/LIME/COLL_FIN TYPE /LIME/COLL_FIN.
SELECT SINGLE *
FROM /LIME/COLL_FIN
INTO CORRESPONDING FIELDS OF WA_/LIME/COLL_FIN
WHERE...
How to access SAP table /LIME/COLL_FIN
Within an ECC or HANA version of SAP you can also view further information about /LIME/COLL_FIN 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