SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

46 columns | Print definition?ERP 6.0  | QUAN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAP-LIM Logistics Inventory Management Engine
1/LIME/COLL_APSCollection for Planning System64QUANStock Quantitydecimal3114
2/LIME/COLL_BWCollection for Business Warehouse64QUANStock Quantitydecimal3114
3/LIME/COLL_FINCollection for Financial System64QUANStock Quantitydecimal3114
4/LIME/COLL_INVCollection for Inventory System64QUANStock Quantitydecimal3114
5/LIME/COLL_LEGCollection for External System64QUANStock Quantitydecimal3114
6/LIME/COLL_MMIMCollection for R/3 Inventory Management64QUANStock Quantitydecimal3114
7/LIME/COLL_W2IMCollection for WME after ERP-MMIM64QUANStock Quantitydecimal3114
8/LIME/LOG_QUANLog Table for the Stock Changes Made to a Document11QUANStock Quantitydecimal3114
9/LIME/NLOG_QUANLogging of Changes in Table /LIME/NQUAN9QUANStock Quantitydecimal3114
10/LIME/NQUANLIME - Stock Quantities6QUANStock Quantitydecimal3114
11/LIME/PN_ITEM_TB/LIME/DOC Collective Table of Param, Quant, Serial No, ACC11QUANStock Quantitydecimal3114
12/LIME/QUANLIME - Stock Quantities6QUANStock Quantitydecimal3114
TOPClinical System
13N1BDCCIS-H*MED: External Drug Basic Catalog Entries20QUANMedication: Drug - Base Quantitydecimal123
14N1FORMULARYMedication: Drug Formulary46QUANMedication: Drug - Base Quantitydecimal123
TOPComplaints and Returns
15/SPE/INSPECRESPInspection Outcome: Item4QUANInspection Outcome: Inspected Quantitydecimal133
TOPData Collection
16S174Services19QUANPurchase order quantitydecimal153
17S174BIW1S174BIW1 * Activities19QUANPurchase order quantitydecimal153
18S174BIW2S174BIW2 * Activities19QUANPurchase order quantitydecimal153
TOPDownloadUpload
19/DSD/HH_RADELITDSD Route Settlement: Delivery Execution Items9QUANDSD - RA: Quantitydecimal133
TOPGlobal Trade Services
20/SAPSLL/CCMWLAWorklist: Customs Warehouse Collective Completion (Open)8QUANStock Quantitydecimal3114
21/SAPSLL/CCMWLBWorklist: CWH Collective Completion (Completed)8QUANStock Quantitydecimal3114
22/SAPSLL/CWLCCPWorklist of Export Items to Determine IP Closing Portions11QUANStock Quantitydecimal3114
23/SAPSLL/CWLOCPWorklist: Import Items to Determine OP Closing Portions8QUANStock Quantitydecimal3114
24/SAPSLL/CWLPCPWorklist: Installation Statement FC w/PEU14QUANStock Quantitydecimal3114
25/SAPSLL/GPASTOCKShared, Periodic, and Completed Stock9QUANStock Quantitydecimal313
26/SAPSLL/IVMCSL01Individual Stock Item, Special Customs Proced. - Change Log8QUANStock Quantitydecimal3114
27/SAPSLL/IVMCSL02Totals Stock, Special Customs Procedures - Change Log8QUANStock Quantitydecimal3114
28/SAPSLL/IVMCST01Indiv. Stock Item: Special Customs Procedures: Inward Proc.12QUANStock Quantitydecimal3114
29/SAPSLL/IVMCST02Totals Stock: Special Customs Procedure: Inward Processing11QUANStock Quantitydecimal3114
30/SAPSLL/IVMFSL01Change Log for Individual Stock item Free Circulation f. PEU8QUANStock Quantitydecimal3114
31/SAPSLL/IVMFST01Individual Stock Item Free Circulation for Prescribed EndUse8QUANStock Quantitydecimal3114
32/SAPSLL/IVMPSL01Processing Stock: Log of Changes8QUANStock Quantitydecimal3114
33/SAPSLL/IVMPST01Processing Stock10QUANStock Quantitydecimal3114
34/SAPSLL/IVMSSFFrozen Individual Stock Item for Customs Warehouse11QUANStock Quantitydecimal3114
35/SAPSLL/LEGFINGTS Customs Document: Closing Portions Item8QUANStock Quantitydecimal3114
36/SAPSLL/LEGOPRGTS Customs Document: Closing of Outward Processing7QUANStock Quantitydecimal3114
37/SAPSLL/LEGPEUClosing of Free Circulation with Prescribed End Use10QUANStock Quantitydecimal3114
38/SAPSLL/LEGSCPClosings of Special Customs Procedures (IP / PUCC)6QUANStock Quantitydecimal3114
39/SAPSLL/OPREFReferenced Closing Portions - OP6QUANStock Quantitydecimal3114
40/SAPSLL/PRFPMRASLL: Preference: Log: Prod: BOM Calculation Result- Assembly10QUANDimension as Floating Point Fieldfloat1516
TOPProduction Backflush
41PPC_BW_EXTR_CUSTSettings for Transfer to BW4QUANOnly Quantities in the BW Transfernvarchar10
TOPTransaction Manager
42OTC_CONV_FINKOBackup Table for Financial Transaction Conditions87QUANQuantitydecimal133
43OTC_CONV_IFINKOBackup Table for Financial Transaction Underlying Conditions86QUANQuantitydecimal133
44TCORT_CODCODeal: Conditions73QUANQuantitydecimal133
45VTBFINKOTransaction Condition87QUANQuantitydecimal133
46VTIFINKOUnderlying transaction conditions86QUANQuantitydecimal133