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

33 columns | Print definition?ERP 6.0  | P_CACSAPPL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPConditions
1A600IDES_Global Agreement for Valuation, depend on the Catagory4P_CACSAPPLCommission Application (ICM)nvarchar60
2A610Valuation for Campaign4P_CACSAPPLCommission Application (ICM)nvarchar60
3A611Sun.Vine Commission Rates4P_CACSAPPLCommission Application (ICM)nvarchar60
4A612Sun.Vine - Contingency Rate4P_CACSAPPLCommission Application (ICM)nvarchar60
5A631Appl./Version/Status4P_CACSAPPLCommission Application (ICM)nvarchar60
6A802Appl./AgreemntNo/Version/Status4P_CACSAPPLCommission Application (ICM)nvarchar60
7A803Appl./AgreemntNo/Busi. Type/Segment/Version/Status4P_CACSAPPLCommission Application (ICM)nvarchar60
8A840Appl./AgreemntNo/Branch/Module/Version/Status4P_CACSAPPLCommission Application (ICM)nvarchar60
9A841Appl./AgreemntNo/Branch/AgreeCat/Version/Status4P_CACSAPPLCommission Application (ICM)nvarchar60
10A844Appl./AgreemntNo/Version/Status4P_CACSAPPLCommission Application (ICM)nvarchar60
11A845Rateplan Traffic Voice and Data Usage - YTEL054P_CACSAPPLCommission Application (ICM)nvarchar60
12A846Traffic Type Traffic Voice and Data Usage - YTEL054P_CACSAPPLCommission Application (ICM)nvarchar60
13A850Branch dependent valuation4P_CACSAPPLCommission Application (ICM)nvarchar60
14A851Branch and Agreement category dependent valuation4P_CACSAPPLCommission Application (ICM)nvarchar60
15A860Appl./Class/Version/Status4P_CACSAPPLCommission Application (ICM)nvarchar60
16A870Appl./AgreemntNo/Std.Con.No/Version/Status4P_CACSAPPLCommission Application (ICM)nvarchar60
17A871Monthly Incentive Target4P_CACSAPPLCommission Application (ICM)nvarchar60
18A872Monthly Transaction Target4P_CACSAPPLCommission Application (ICM)nvarchar60
19A873YTD Accelerator4P_CACSAPPLCommission Application (ICM)nvarchar60
20A880Appl./Rate Plan/Version/Status4P_CACSAPPLCommission Application (ICM)nvarchar60
21A881YTEL01 - Product Multiplier4P_CACSAPPLCommission Application (ICM)nvarchar60
22A882YTEL01 - Term Multiplier4P_CACSAPPLCommission Application (ICM)nvarchar60
23A883YTEL01 - Discount Multiplier4P_CACSAPPLCommission Application (ICM)nvarchar60
24A884YTEL01 - Listprice Multiplier4P_CACSAPPLCommission Application (ICM)nvarchar60
25A885YTEL01 - Margin Multiplier4P_CACSAPPLCommission Application (ICM)nvarchar60
26A896Complex Target4P_CACSAPPLCommission Application (ICM)nvarchar60
27A904Appl./AgreemntNo/Divis./Contr. no./RemBusTrCt/Version/Status4P_CACSAPPLCommission Application (ICM)nvarchar60
28A905Appl./AgreemntNo/Contr. no./RemBusTrCt/Version/Status4P_CACSAPPLCommission Application (ICM)nvarchar60
TOPIncentive and Commission Management ICM
29A194A1944P_CACSAPPLAplicación de comisión (ICM)nvarchar60
30A195A1954P_CACSAPPLAplicación de comisión (ICM)nvarchar60
31A196A1964P_CACSAPPLAplicación de comisión (ICM)nvarchar60
32A197A1974P_CACSAPPLAplicación de comisión (ICM)nvarchar60
33A198A1984P_CACSAPPLAplicación de comisión (ICM)nvarchar60