/LIME/COLL_FIN SAP (Collection for Financial System) Table details

Dictionary Type: Table
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




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
MANDTClient MANDTCLNT3Assigned to domainMANDT
GUID_COLLGUID LIME Collection /LIME/GUID_COLLRAW16
GUID_DISPATCHGUID LIME Dispatcher Run /LIME/GUID_DISPATCHRAW16
DISPATCH_TIMEDispatcher Record Processed (Time Stamp) /LIME/DISPATCH_TIMEDEC21(7) TZNTSTMPL
GUID_PNLIME GUID for Prima Nota /LIME/GUID_PNRAW16
EXT_DOCNumber of LIME Document /LIME/EXT_DOCCHAR35
PROCESS_TYPEApplication /LIME/PROCESS_TYPECHAR4/LIME/PROCESS_TYPE
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 WAERSCUKY5Assigned to domainWAERSFWS
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
TARGETDescribes Whether It Is Source or Target Data Record /LIME/TARGETCHAR1/LIME/TARGET
IDX_LOCCurrent Nummer of Key Table /LIME/KEY_INDEXCHAR3
GUID_LOCLocation GUID /LIME/GUID_LOCRAW16
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
LGORTStorage Location LGORT_DCHAR4Assigned to domainLGORTLAG
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/PARTNERCHAR10Assigned to domainALPHABU_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_SPICHAR10Assigned to domain/SAPSLL/ECPID_SPI/SAPSLL/ECPID
IDX_STOCKCurrent Nummer of Key Table /LIME/KEY_INDEXCHAR3
GUID_STOCKGUID Stock Item /LIME/GUID_STOCKRAW16
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
CHARGBatch Number CHARG_DCHAR10Assigned to domainCHARGCHA
OWNEROwner /LIME/OWNERCHAR10Assigned to domainALPHABU_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_STOCKCHAR10Assigned to domainALPHAVBELN
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 LOGSYSCHAR10Assigned to domainALPHALOGSYS
/SAPSLL/GUID_PRProduct GUID im 'RAW' Format /SAPSLL/IVM_GUID_PRODUCTRAW16SYSUUID
/SAPSLL/COOProduct's Country of Origin /SAPSLL/IVM_COOCHAR3Assigned to domainLAND1
/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
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
QUANStock Quantity /LIME/QUANTITYQUAN31(14) /LIME/QUANTITY
QUAN_PREVStock Quantity /LIME/QUANTITYQUAN31(14) /LIME/QUANTITY
PREV_INDCheck Previous Stock Quantity if = 'X' /LIME/PREV_INDCHAR1XFELD
UNITStock Unit of Measure /LIME/UNITUNIT3Assigned to domainCUNITMEINS
STOCKUNITIndicator for Inventory-Managed Quantities /LIME/STOCKUNITCHAR1XFELD
NOCALCIndicator to Control Quantity Calculation /LIME/NOCALCCHAR1/LIME/NOCALC
SERIALUNITSerial-Number-Relevant Unit of Measure /LIME/SERIALUNITCHAR1XFELD
MAT_DOC_ITEMItem in Material Document /LIME/MAT_DOC_ITEMNUMC4
VALUATIONUNITUnit is Relevant for Valuation /LIME/VALUATIONUNITCHAR1XFELD
PO_NUMBERPurchasing Document Number EBELNCHAR10Assigned to domainALPHAEBELNBESMEKK_C
PO_ITEMItem Number of Purchasing Document EBELPNUMC5Assigned to domainEBELPBSP
PO_COMPLETEObsolete With SCM4.1 /LIME/OBSOLET_PO_COMPLETECHAR1XFELD
ORDER_NUMBEROrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
ORDER_ITEMOrder Item Number CO_POSNRNUMC4CO_POSNR
ORDER_COMPLETEObsolete With SCM4.1 /LIME/OBSOLET_ORDER_COMPLETECHAR1XFELD
DELIVERYSales and Distribution Document Number VBELNCHAR10Assigned to domainALPHAVBELNAUN
DELIVERY_ITEMItem number of the SD document POSNRNUMC6Assigned to domainPOSNR
DELIV_COMPLETEObsolete With SCM4.1 /LIME/OBSOLET_DELIV_COMPLETECHAR1XFELD
MAT_DOCR/3 Material Document /LIME/MAT_DOCCHAR10ALPHABELNR
MAT_DOC_YEARMaterial Document Year /LIME/MAT_DOC_YEARNUMC4GJAHRGJAHR
MAT_DOC_ITEMItem in Material Document /LIME/MAT_DOC_ITEMNUMC4
RESERV_NONumber of Reservation/Dependent Requirement RSNUMNUMC10Assigned to domainRSNUMRES
RES_ITEMItem Number of Reservation/Dependent Requirement RSPOSNUMC4RSPOSRPO
RES_TYPERecord type RSARTCHAR1RSART
RES_COMPLETEObsolete With SCM4.1 /LIME/OBSOLET_KZEARCHAR1XFELD
TOP_LEVELLocation at Highest Hierarchy Level /LIME/TOP_LEVELCHAR1XFELD
GUID_COLL_GROUPGUID for Collection Grouping /LIME/GUID_COLL_GROUPRAW16
COSTCENTERCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
ORDERIDOrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
ORDER_ITNOOrder Item Number CO_POSNRNUMC4CO_POSNR
WBS_ELEMENTWork Breakdown Structure Element (WBS Element) PS_POSIDCHAR24PROJNPS_POSIDPRO
NETWORKNetwork Number for Account Assignment NPLNRCHAR12Assigned to domainALPHAAUFNRNET
SALES_ORDSales Order Number KDAUFCHAR10Assigned to domainALPHAVBELNAUN
SCHED_LINEDelivery Schedule for Sales Order KDEINNUMC4NUM04
S_ORD_ITEMItem Number in Sales Order KDPOSNUMC6NUM06KPO
ACTIVITYOperation/Activity Number VORNRCHAR4NUMCVVORNRVGN
CMMT_ITEMCommitment Item FIPOSCHAR14Assigned to domainFIPOSFIP
ASSETMAINNOMain Asset Number BF_ANLN1CHAR12ALPHABF_ANLN1AN1
ASSETSUBNOAsset Subnumber BF_ANLN2CHAR4ALPHABF_ANLN2AN2
FUNDS_CTRFunds Center FISTLCHAR16Assigned to domainFISTLFIS
GEBERFund BP_GEBERCHAR10Assigned to domainBP_GEBERFIC
FUNC_AREAFunctional Area FKBER_SHORTCHAR4FKBER_SHORTFBE
ACTTYPEActivity Type LSTARCHAR6Assigned to domainLSTARLARLART_EMPTY
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
APO_MATNR_TAPO Material Number /LIME/APO_MATNRCHAR40
OWNER_TOwner /LIME/OWNERCHAR10Assigned to domainALPHABU_PARTNER
OWNER_ROLE_TPartner Role of Owner /LIME/OWNER_ROLECHAR2/LIME/PARTNER_ROLE
CAT_TStock Type /LIME/STOCK_CATEGORYCHAR2/LIME/STOCK_CATEGORY
APO_LOCNO_TAPO Location /LIME/APO_LOCNOCHAR20
BUS_TRANS_TYPENot More Closely Defined Area, Possibly Used for Patchlevels CHAR4CHAR4CHAR4
DOC_ID_1Document ID of Reference Document /LIME/REF_DOC_IDCHAR70/LIME/REF_DOC_ID
DOC_TYPE_1Document Type of Reference Document /LIME/REF_DOC_TYPECHAR10/LIME/REF_DOC_TYPE
DOC_LOGSYS_1Logical system LOGSYSCHAR10Assigned to domainALPHALOGSYS
DOC_ID_2Document ID of Reference Document /LIME/REF_DOC_IDCHAR70/LIME/REF_DOC_ID
DOC_TYPE_2Document Type of Reference Document /LIME/REF_DOC_TYPECHAR10/LIME/REF_DOC_TYPE
DOC_LOGSYS_2Logical system LOGSYSCHAR10Assigned to domainALPHALOGSYS

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 table
DATA: 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 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!