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
9OVTG52Tax Definition
10OPOR386Purchase Order

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

35 columns | Print definition?ERP 6.0  | POST_MONTH

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPIncentive and Commission Management ICM
1CACS00_DOCHDCommission Document Header9POST_MONTHPeriod in Posting Yearnvarchar20
2CACS00_DOCVACommission Document, Valuation8POST_MONTHPeriod in Posting Yearnvarchar20
3CACS00_SUMRETotals Table for Remuneration5POST_MONTHPeriod in Posting Yearnvarchar20
4CACS00_SUMVATotals Table for Valuation6POST_MONTHPeriod in Posting Yearnvarchar20
5YCRM01_DOCHDCommission Document Header9POST_MONTHPeriod in Posting Yearnvarchar20
6YCRM01_DOCVACommission Document, Valuation36POST_MONTHPeriod in Posting Yearnvarchar20
7YCRM01_SUMRERemuneration Totals for Contract Account Display5POST_MONTHPeriod in Posting Yearnvarchar20
8YCRM01_SUMRE02Commissions: Reference Totals Table for Compensation5POST_MONTHPeriod in Posting Yearnvarchar20
9YCRM01_SUMRE92Commissions: Total Commission Basis4POST_MONTHPeriod in Posting Yearnvarchar20
10YCRM01_SUMVAValuation Totals for Contract Account Display6POST_MONTHPeriod in Posting Yearnvarchar20
11YCRM01_SUMVA91Commissions: Reference Totals Table for Valuation3POST_MONTHPeriod in Posting Yearnvarchar20
12YHITEC_DOCHDCommission Document Header7POST_MONTHPeriod in Posting Yearnvarchar20
13YHITEC_DOCVACommission Document, Valuation17POST_MONTHPeriod in Posting Yearnvarchar20
14YHITEC_SUMRERemuneration Totals for Contract Account Display5POST_MONTHPeriod in Posting Yearnvarchar20
15YHITEC_SUMVAValuation Totals for Contract Account Display6POST_MONTHPeriod in Posting Yearnvarchar20
16YSVMA_DOCHDCommission Document Header17POST_MONTHPeriod in Posting Yearnvarchar20
17YSVMA_DOCVACommission Document, Valuation13POST_MONTHPeriod in Posting Yearnvarchar20
18YSVMA_SUMRERemuneration Totals for Contract Account Display5POST_MONTHPeriod in Posting Yearnvarchar20
19YSVMA_SUMRE01Commissions: Reference Totals Table for Compensation5POST_MONTHPeriod in Posting Yearnvarchar20
20YSVMA_SUMVAValuation Totals for Contract Account Display6POST_MONTHPeriod in Posting Yearnvarchar20
21YTEL01_DOCHDCommission Document Header7POST_MONTHPeriod in Posting Yearnvarchar20
22YTEL01_DOCVACommission Document, Valuation39POST_MONTHPeriod in Posting Yearnvarchar20
23YTEL01_SUMRERemuneration Totals for Contract Account Display5POST_MONTHPeriod in Posting Yearnvarchar20
24YTEL01_SUMRE04Commissions: Totals Table for Compensation (Scale Base)7POST_MONTHPeriod in Posting Yearnvarchar20
25YTEL01_SUMVAValuation Totals for Contract Account Display6POST_MONTHPeriod in Posting Yearnvarchar20
26YTEL01_SUMVA02Reference Totals Table for Valuation (TELUS)4POST_MONTHPeriod in Posting Yearnvarchar20
27YTEL01_SUMVA03Reference Totals Table for Valuation (TELUS)4POST_MONTHPeriod in Posting Yearnvarchar20
28YTEL05_DOCHDCommission Document Header17POST_MONTHPeriod in Posting Yearnvarchar20
29YTEL05_DOCVACommission Document, Valuation23POST_MONTHPeriod in Posting Yearnvarchar20
30YTEL05_SUMRERemuneration Totals for Contract Account Display5POST_MONTHPeriod in Posting Yearnvarchar20
31YTEL05_SUMVAValuation Totals for Contract Account Display6POST_MONTHPeriod in Posting Yearnvarchar20
32ZICMAG_DOCHDCommission Document Header7POST_MONTHPeriod in Posting Yearnvarchar20
33ZICMAG_DOCVACommission Document, Valuation10POST_MONTHPeriod in Posting Yearnvarchar20
34ZICMAG_SUMRERemuneration Totals for Contract Account Display5POST_MONTHPeriod in Posting Yearnvarchar20
35ZICMAG_SUMVAValuation Totals for Contract Account Display6POST_MONTHPeriod in Posting Yearnvarchar20