/LIME/COLL_INV - Collection for Inventory System
Collection for Inventory System information is stored in SAP table /LIME/COLL_INV.
It is part of development package /LIME/RFC_CORE in software component AP-LIM. This development package consists of objects that can be grouped under "Core Package of the RFC Interface".
It is part of development package /LIME/RFC_CORE in software component AP-LIM. This development package consists of objects that can be grouped under "Core Package of the RFC Interface".
Fields for table /LIME/COLL_INV
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| GUID_COLL | GUID LIME Collection | X | /LIME/GUID_COLL | RAW | 16 | |
| .INCLUDE | /LIME/DISPATCH_TECH | 0 | ||||
| GUID_DISPATCH | GUID LIME Dispatcher Run | /LIME/GUID_DISPATCH | RAW | 16 | ||
| DISPATCH_TIME | Dispatcher Record Processed (Time Stamp) | /LIME/DISPATCH_TIME | DEC | 11 | ||
| .INCLUDE | /LIME/FDOC_COLL | 0 | ||||
| .INCLUDE | /LIME/FDOC_COLL_NOACC | 0 | ||||
| GUID_PN | LIME GUID for Prima Nota | /LIME/GUID_PN | RAW | 16 | ||
| .INCLUDE | /LIME/HEAD_ONLY | 0 | ||||
| EXT_DOC | Number of LIME Document | /LIME/EXT_DOC | CHAR | 70 | ||
| PROCESS_TYPE | Application | /LIME/PROCESS_TYPE | CHAR | 8 | ||
| .INCLUDE | /LIME/ITEM_DATA | 0 | ||||
| .INCLUDE | /LIME/ITEM_DATA_TECH | 0 | ||||
| ID | Item | /LIME/LINE_ITEM_ID | NUMC | 12 | ||
| ID_PARENT | Reference to Higher-Level Item | /LIME/LINE_ITEM_ID_PARENT | NUMC | 12 | ||
| ID_GROUP | Item Group | /LIME/LINE_ITEM_GROUP | NUMC | 12 | ||
| DIRECTION | Direction of Movement (In/Out/Transfer) | /LIME/DIRECTION | CHAR | 2 | ||
| REVERSE_MODE | Reversal Indicator | /LIME/REVERSE_MODE | CHAR | 2 | ||
| ISSUE_ALL | Move Total Stock | /LIME/ISSUE_ALL | CHAR | 2 | ||
| .INCLUDE | /LIME/ITEM_DATA_BIZ | 0 | ||||
| TIMESTAMP | UTC Time Stamp (YYYYMMDDhhmmss,mmmuuun) | /LIME/TIMESTAMP_EXT | DEC | 11 | ||
| TIMESTAMP_END | UTC Time Stamp (YYYYMMDDhhmmss,mmmuuun) End of Operation | /LIME/TIMESTAMP_EXT_END | DEC | 11 | ||
| NOTE | Notes | /LIME/NOTE | CHAR | 100 | ||
| REASON | Reason for Movement | /LIME/REASON | CHAR | 8 | ||
| EXT_VALUE | External Value | /LIME/EXT_VALUE | CURR | 7 | ||
| EXT_VALUE_CURR | Currency Key | WAERS | CUKY | 10 | * | |
| VSI | Virtual Stock Indicator | /LIME/VSI | CHAR | 2 | ||
| IC_DESCRIP | Description of Stock Change | /LIME/IC_DESCRIP | CHAR | 20 | ||
| .INCLUDE | /LIME/INCL_EEW_ITEM_DATA | 0 | ||||
| EEW_DUMMY | Dummy function in length 1 | DUMMY | CHAR | 2 | ||
| ACTION_TYPE | LIME-Line Category (Internal) | /LIME/ACTION_TYPE | CHAR | 4 | ||
| TARGET | Describes Whether It Is Source or Target Data Record | /LIME/TARGET | CHAR | 2 | ||
| .INCLUDE | /LIME/LOC_KEY | 0 | ||||
| IDX_LOC | Current Nummer of Key Table | /LIME/KEY_INDEX | CHAR | 6 | ||
| GUID_LOC | Location GUID | /LIME/GUID_LOC | RAW | 16 | ||
| .INCLUDE | /LIME/LOC_BIZ | 0 | ||||
| WERKS | Plant | WERKS_D | CHAR | 8 | ||
| LGORT | Storage location | LGORT_D | CHAR | 8 | * | |
| GLN | Global Location Number | /LIME/GLN | NUMC | 26 | ||
| DUNS4 | D-U-N-S+4 Number | /LIME/DUNS4 | NUMC | 26 | ||
| LOCID | GUID for Location | /LIME/MDL_LOCID | RAW | 16 | ||
| APO_LOCNO | APO Location | /LIME/APO_LOCNO | CHAR | 40 | ||
| PARTNER | Partner | /LIME/PARTNER | CHAR | 20 | * | |
| PARTNER_ROLE | Partner Role | /LIME/PARTNER_ROLE | CHAR | 4 | ||
| MOTID | Means of Transport Identifier | /LIME/MDL_MOTID | CHAR | 70 | ||
| MOTSCODE | Standard Code Means of Transport Acc.To UN/EDIFACT 8179 | /LIME/MDL_MOTSCODE | CHAR | 8 | ||
| .INCLU--AP | /SCWM/LOC_BIZ_AS | 0 | ||||
| LGNUM | Warehouse Number/Warehouse Complex | /SCWM/LGNUM | CHAR | 8 | ||
| LGTYP | Storage Type | /SCWM/LGTYP | CHAR | 8 | ||
| LGPLA | Storage Bin | /SCWM/LGPLA | CHAR | 36 | * | |
| RSRC | Resource (Means of Transportation or User) | /SCWM/DE_RSRC | CHAR | 36 | ||
| TU_NUM | Internal Number of Transportation Unit | /SCWM/DE_TU_NUM | CHAR | 36 | ||
| LGNUM_VIEW | Warehouse Number View for Global Stocks | /SCWM/DE_LGNUM_VIEW | CHAR | 2 | ||
| .INCLUDE | /LIME/STOCK_KEY | 0 | ||||
| IDX_STOCK | Current Nummer of Key Table | /LIME/KEY_INDEX | CHAR | 6 | ||
| GUID_STOCK | GUID Stock Item | /LIME/GUID_STOCK | RAW | 16 | ||
| .INCLUDE | /LIME/STOCK_BIZ | 0 | ||||
| MATNR | Material Number | MATNR | CHAR | 80 | ||
| CHARG | Batch Number | CHARG_D | CHAR | 20 | * | |
| OWNER | Owner | /LIME/OWNER | CHAR | 20 | * | |
| OWNER_ROLE | Partner Role of Owner | /LIME/OWNER_ROLE | CHAR | 4 | ||
| GTIN | Global Trade Item Number (GTIN) | /LIME/GTIN | NUMC | 28 | ||
| GTIN_VARIANT | Global Trade Item Number (GTIN) Variant | /LIME/GTIN_VARIANT | NUMC | 4 | ||
| CAT | Stock Type | /LIME/STOCK_CATEGORY | CHAR | 4 | ||
| STOCK_USAGE | Stock Usage | /LIME/STOCK_USAGE | CHAR | 2 | ||
| SALES_ORD_STOCK | Sales Order for Stock | /LIME/SALES_ORD_STOCK | CHAR | 20 | ||
| S_ORD_ITEM_STOCK | Sales Order Item for Stock | /LIME/S_ORD_ITEM_STOCK | NUMC | 12 | ||
| WBS_STOCK | WBS Element for Stock | /LIME/WBS_STOCK | CHAR | 48 | ||
| VRSIOID | GUID for Planning Version | /LIME/MDL_VRSIOID | RAW | 16 | ||
| PRDID | GUID for Product | /LIME/MDL_PRDID | RAW | 16 | ||
| APO_MATNR | APO Material Number | /LIME/APO_MATNR | CHAR | 80 | ||
| .INCLU--AP | /SCWM/STOCK_BIZ_AS | 0 | ||||
| LGNUM_STOCK | Warehouse Number/Warehouse Complex | /SCWM/LGNUM | CHAR | 8 | ||
| MATID | Product | /SCWM/DE_MATID | RAW | 16 | ||
| BATCHID | Batch | /SCWM/DE_BATCHID | RAW | 16 | ||
| STOCK_DOCCAT | Type: Sales Order Stock or Project Stock | /SCWM/DE_STOCK_DOCCAT | CHAR | 6 | ||
| STOCK_DOCNO | Number of the Sales Order or Project for Special Stock | /SCWM/DE_STOCK_DOCNO | CHAR | 70 | ||
| STOCK_ITMNO | Sales Order Item for Sales Order Stock | /SCWM/DE_STOCK_ITMNO | NUMC | 20 | ||
| DOCCAT | Doc. Category for Doc. Reference and Doc.-Related Stock | /SCWM/DE_DOCCAT | CHAR | 6 | ||
| ENTITLED | Party Entitled to Dispose | /SCWM/DE_ENTITLED | CHAR | 20 | * | |
| ENTITLED_ROLE | Partner Role of Party Entitled to Dispose | /SCWM/DE_ENTITLED_ROLE | CHAR | 4 | ||
| STOCK_CNT | Counter for Stock Separation | /SCWM/DE_STOCK_CNT | NUMC | 12 | ||
| .INCLUDE | /LIME/HU_KEY | 0 | ||||
| IDX_HU | Current Nummer of Key Table | /LIME/KEY_INDEX | CHAR | 6 | ||
| GUID_HU | GUID Handling Unit | /LIME/GUID_HU | RAW | 16 | ||
| .INCLUDE | /LIME/HU_BIZ | 0 | ||||
| SSCC | Serial Shipping Container Code (NVE, Number Package) | /LIME/SSCC | NUMC | 36 | ||
| .INCLU--AP | /SCWM/HU_BIZ_AS | 0 | ||||
| LGNUM_HU | Warehouse Number/Warehouse Complex | /SCWM/LGNUM | CHAR | 8 | ||
| HUIDENT | Handling Unit Identification | /SCWM/DE_HUIDENT | CHAR | 40 | ||
| VHI | Virtual Handling Unit | /SCWM/VHI | CHAR | 2 | ||
| .INCLUDE | /LIME/QCI_QUAN | 0 | ||||
| QUAN | Stock Quantity | /LIME/QUANTITY | QUAN | 16 | ||
| QUAN_PREV | Stock Quantity | /LIME/QUANTITY | QUAN | 16 | ||
| PREV_IND | Check Previous Stock Quantity if = 'X' | /LIME/PREV_IND | CHAR | 2 | ||
| .INCLUDE | /LIME/QCI_UNITS | 0 | ||||
| UNIT | Stock Unit of Measure | /LIME/UNIT | UNIT | 6 | * | |
| .INCLUDE | /LIME/QCI_UNIT_FLAGS | 0 | ||||
| STOCKUNIT | Indicator for Inventory-Managed Quantities | /LIME/STOCKUNIT | CHAR | 2 | ||
| NOCALC | Indicator to Control Quantity Calculation | /LIME/NOCALC | CHAR | 2 | ||
| SERIALUNIT | Serial-Number-Relevant Unit of Measure | /LIME/SERIALUNIT | CHAR | 2 | ||
| VALUATIONUNIT | Unit is Relevant for Valuation | /LIME/VALUATIONUNIT | CHAR | 2 | ||
| .INCLUDE | /LIME/REF_DOC | 0 | ||||
| PO_NUMBER | Purchasing Document Number | EBELN | CHAR | 20 | ||
| PO_ITEM | Item Number of Purchasing Document | EBELP | NUMC | 10 | * | |
| PO_COMPLETE | Obsolete With SCM4.1 | /LIME/OBSOLET_PO_COMPLETE | CHAR | 2 | ||
| ORDER_NUMBER | Order Number | AUFNR | CHAR | 24 | * | |
| ORDER_ITEM | Order item number | CO_POSNR | NUMC | 8 | ||
| ORDER_COMPLETE | Obsolete With SCM4.1 | /LIME/OBSOLET_ORDER_COMPLETE | CHAR | 2 | ||
| DELIVERY | Sales and Distribution Document Number | VBELN | CHAR | 20 | ||
| DELIVERY_ITEM | Item number of the SD document | POSNR | NUMC | 12 | ||
| DELIV_COMPLETE | Obsolete With SCM4.1 | /LIME/OBSOLET_DELIV_COMPLETE | CHAR | 2 | ||
| MAT_DOC | R/3 Material Document | /LIME/MAT_DOC | CHAR | 20 | ||
| MAT_DOC_YEAR | Material Document Year | /LIME/MAT_DOC_YEAR | NUMC | 8 | ||
| MAT_DOC_ITEM | Item in Material Document | /LIME/MAT_DOC_ITEM | NUMC | 8 | ||
| RESERV_NO | Number of reservation/dependent requirements | RSNUM | NUMC | 20 | * | |
| RES_ITEM | Item Number of Reservation / Dependent Requirements | RSPOS | NUMC | 8 | ||
| RES_TYPE | Record type | RSART | CHAR | 2 | ||
| RES_COMPLETE | Obsolete With SCM4.1 | /LIME/OBSOLET_KZEAR | CHAR | 2 | ||
| TOP_LEVEL | Location at Highest Hierarchy Level | /LIME/TOP_LEVEL | CHAR | 2 | ||
| GUID_COLL_GROUP | GUID for Collection Grouping | /LIME/GUID_COLL_GROUP | RAW | 16 | ||
| .INCLUDE | /LIME/ACC_FIELDS | 0 | ||||
| COSTCENTER | Cost Center | KOSTL | CHAR | 20 | * | |
| ORDERID | Order Number | AUFNR | CHAR | 24 | * | |
| ORDER_ITNO | Order item number | CO_POSNR | NUMC | 8 | ||
| WBS_ELEMENT | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR | 48 | ||
| NETWORK | Network Number for Account Assignment | NPLNR | CHAR | 24 | * | |
| SALES_ORD | Sales Order Number | KDAUF | CHAR | 20 | ||
| SCHED_LINE | Delivery schedule for sales order | KDEIN | NUMC | 8 | ||
| S_ORD_ITEM | Item number in Sales Order | KDPOS | NUMC | 12 | ||
| ACTIVITY | Operation/Activity Number | VORNR | CHAR | 8 | ||
| CMMT_ITEM | Commitment Item | FIPOS | CHAR | 28 | * | |
| ASSETMAINNO | Main Asset Number | BF_ANLN1 | CHAR | 24 | ||
| ASSETSUBNO | Asset Subnumber | BF_ANLN2 | CHAR | 8 | ||
| FUNDS_CTR | Funds Center | FISTL | CHAR | 32 | * | |
| GEBER | Fund | BP_GEBER | CHAR | 20 | * | |
| FUNC_AREA | Functional Area | FKBER_SHORT | CHAR | 8 | ||
| ACTTYPE | Activity Type | LSTAR | CHAR | 12 | ||
| GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 40 | ||
| .INCLUDE | /LIME/BADI_COLL_INV | 0 | ||||
| BADI_DUMMY | Dummy function in length 1 | DUMMY | CHAR | 2 |