| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAP-LIM Logistics Inventory Management Engine |
1 | /LIME/COLL_APS | Collection for Planning System | 64 | QUAN | Stock Quantity | decimal | 31 | 14 | | |
2 | /LIME/COLL_BW | Collection for Business Warehouse | 64 | QUAN | Stock Quantity | decimal | 31 | 14 | | |
3 | /LIME/COLL_FIN | Collection for Financial System | 64 | QUAN | Stock Quantity | decimal | 31 | 14 | | |
4 | /LIME/COLL_INV | Collection for Inventory System | 64 | QUAN | Stock Quantity | decimal | 31 | 14 | | |
5 | /LIME/COLL_LEG | Collection for External System | 64 | QUAN | Stock Quantity | decimal | 31 | 14 | | |
6 | /LIME/COLL_MMIM | Collection for R/3 Inventory Management | 64 | QUAN | Stock Quantity | decimal | 31 | 14 | | |
7 | /LIME/COLL_W2IM | Collection for WME after ERP-MMIM | 64 | QUAN | Stock Quantity | decimal | 31 | 14 | | |
8 | /LIME/LOG_QUAN | Log Table for the Stock Changes Made to a Document | 11 | QUAN | Stock Quantity | decimal | 31 | 14 | | |
9 | /LIME/NLOG_QUAN | Logging of Changes in Table /LIME/NQUAN | 9 | QUAN | Stock Quantity | decimal | 31 | 14 | | |
10 | /LIME/NQUAN | LIME - Stock Quantities | 6 | QUAN | Stock Quantity | decimal | 31 | 14 | | |
11 | /LIME/PN_ITEM_TB | /LIME/DOC Collective Table of Param, Quant, Serial No, ACC | 11 | QUAN | Stock Quantity | decimal | 31 | 14 | | |
12 | /LIME/QUAN | LIME - Stock Quantities | 6 | QUAN | Stock Quantity | decimal | 31 | 14 | | |
TOPClinical System |
13 | N1BDCC | IS-H*MED: External Drug Basic Catalog Entries | 20 | QUAN | Medication: Drug - Base Quantity | decimal | 12 | 3 | | |
14 | N1FORMULARY | Medication: Drug Formulary | 46 | QUAN | Medication: Drug - Base Quantity | decimal | 12 | 3 | | |
TOPComplaints and Returns |
15 | /SPE/INSPECRESP | Inspection Outcome: Item | 4 | QUAN | Inspection Outcome: Inspected Quantity | decimal | 13 | 3 | | |
TOPData Collection |
16 | S174 | Services | 19 | QUAN | Purchase order quantity | decimal | 15 | 3 | | |
17 | S174BIW1 | S174BIW1 * Activities | 19 | QUAN | Purchase order quantity | decimal | 15 | 3 | | |
18 | S174BIW2 | S174BIW2 * Activities | 19 | QUAN | Purchase order quantity | decimal | 15 | 3 | | |
TOPDownloadUpload |
19 | /DSD/HH_RADELIT | DSD Route Settlement: Delivery Execution Items | 9 | QUAN | DSD - RA: Quantity | decimal | 13 | 3 | | |
TOPGlobal Trade Services |
20 | /SAPSLL/CCMWLA | Worklist: Customs Warehouse Collective Completion (Open) | 8 | QUAN | Stock Quantity | decimal | 31 | 14 | | |
21 | /SAPSLL/CCMWLB | Worklist: CWH Collective Completion (Completed) | 8 | QUAN | Stock Quantity | decimal | 31 | 14 | | |
22 | /SAPSLL/CWLCCP | Worklist of Export Items to Determine IP Closing Portions | 11 | QUAN | Stock Quantity | decimal | 31 | 14 | | |
23 | /SAPSLL/CWLOCP | Worklist: Import Items to Determine OP Closing Portions | 8 | QUAN | Stock Quantity | decimal | 31 | 14 | | |
24 | /SAPSLL/CWLPCP | Worklist: Installation Statement FC w/PEU | 14 | QUAN | Stock Quantity | decimal | 31 | 14 | | |
25 | /SAPSLL/GPASTOCK | Shared, Periodic, and Completed Stock | 9 | QUAN | Stock Quantity | decimal | 31 | 3 | | |
26 | /SAPSLL/IVMCSL01 | Individual Stock Item, Special Customs Proced. - Change Log | 8 | QUAN | Stock Quantity | decimal | 31 | 14 | | |
27 | /SAPSLL/IVMCSL02 | Totals Stock, Special Customs Procedures - Change Log | 8 | QUAN | Stock Quantity | decimal | 31 | 14 | | |
28 | /SAPSLL/IVMCST01 | Indiv. Stock Item: Special Customs Procedures: Inward Proc. | 12 | QUAN | Stock Quantity | decimal | 31 | 14 | | |
29 | /SAPSLL/IVMCST02 | Totals Stock: Special Customs Procedure: Inward Processing | 11 | QUAN | Stock Quantity | decimal | 31 | 14 | | |
30 | /SAPSLL/IVMFSL01 | Change Log for Individual Stock item Free Circulation f. PEU | 8 | QUAN | Stock Quantity | decimal | 31 | 14 | | |
31 | /SAPSLL/IVMFST01 | Individual Stock Item Free Circulation for Prescribed EndUse | 8 | QUAN | Stock Quantity | decimal | 31 | 14 | | |
32 | /SAPSLL/IVMPSL01 | Processing Stock: Log of Changes | 8 | QUAN | Stock Quantity | decimal | 31 | 14 | | |
33 | /SAPSLL/IVMPST01 | Processing Stock | 10 | QUAN | Stock Quantity | decimal | 31 | 14 | | |
34 | /SAPSLL/IVMSSF | Frozen Individual Stock Item for Customs Warehouse | 11 | QUAN | Stock Quantity | decimal | 31 | 14 | | |
35 | /SAPSLL/LEGFIN | GTS Customs Document: Closing Portions Item | 8 | QUAN | Stock Quantity | decimal | 31 | 14 | | |
36 | /SAPSLL/LEGOPR | GTS Customs Document: Closing of Outward Processing | 7 | QUAN | Stock Quantity | decimal | 31 | 14 | | |
37 | /SAPSLL/LEGPEU | Closing of Free Circulation with Prescribed End Use | 10 | QUAN | Stock Quantity | decimal | 31 | 14 | | |
38 | /SAPSLL/LEGSCP | Closings of Special Customs Procedures (IP / PUCC) | 6 | QUAN | Stock Quantity | decimal | 31 | 14 | | |
39 | /SAPSLL/OPREF | Referenced Closing Portions - OP | 6 | QUAN | Stock Quantity | decimal | 31 | 14 | | |
40 | /SAPSLL/PRFPMRA | SLL: Preference: Log: Prod: BOM Calculation Result- Assembly | 10 | QUAN | Dimension as Floating Point Field | float | 15 | 16 | | |
TOPProduction Backflush |
41 | PPC_BW_EXTR_CUST | Settings for Transfer to BW | 4 | QUAN | Only Quantities in the BW Transfer | nvarchar | 1 | 0 | | |
TOPTransaction Manager |
42 | OTC_CONV_FINKO | Backup Table for Financial Transaction Conditions | 87 | QUAN | Quantity | decimal | 13 | 3 | | |
43 | OTC_CONV_IFINKO | Backup Table for Financial Transaction Underlying Conditions | 86 | QUAN | Quantity | decimal | 13 | 3 | | |
44 | TCORT_CODCO | Deal: Conditions | 73 | QUAN | Quantity | decimal | 13 | 3 | | |
45 | VTBFINKO | Transaction Condition | 87 | QUAN | Quantity | decimal | 13 | 3 | | |
46 | VTIFINKO | Underlying transaction conditions | 86 | QUAN | Quantity | decimal | 13 | 3 | | |