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

93 columns | Print definition?ERP 6.0  | LED_CURR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPIncentive and Commission Management ICM
1CACS00_B_VAR_CASVariants for Commission Case34LED_CURRCurrency Key for the Transactionnvarchar50
2CACS00_B_VAR_OBJVariants for Commission Case Object Data20LED_CURRCurrency Key of Transaction in Object Areanvarchar50
3CACS00_CASCommission Case30LED_CURRCurrency Key for the Transactionnvarchar50
4CACS00_DOCHDCommission Document Header28LED_CURRCurrency Keynvarchar50
5CACS00_DOCOBJCommission Document: Object Data12LED_CURRCurrency Keynvarchar50
6CACS00_DOCRECommission Document, Remuneration and Liability36LED_CURRCurrency Keynvarchar50
7CACS00_DOCSECommission Document, Settlement20LED_CURRCurrency Keynvarchar50
8CACS00_DOCVACommission Document, Valuation21LED_CURRCurrency Keynvarchar50
9CACS00_OBJCommission Case Object Data16LED_CURRCurrency Key of Transaction in Object Areanvarchar50
10CACS00_SUMRETotals Table for Remuneration7LED_CURRCurrency Keynvarchar50
11CACS00_SUMSETotals Table for Settlement7LED_CURRCurrency Keynvarchar50
12CACS00_SUMVATotals Table for Valuation7LED_CURRCurrency Keynvarchar50
13CACS25_SESITSettlement Schedule Item16LED_CURRCurrency Keynvarchar50
14CACS_DOCREExpected Commission (Remuneration)13LED_CURRCurrency Keynvarchar50
15TCACS_GLOBGlobal Settings of Application for Each Client4LED_CURRCurrency Keynvarchar50
16TCACS_OTC03_ODOTC 03 (Liability), Object-Specific Parameters8LED_CURRCurrency Keynvarchar50
17YCRM01_B_VAR_CASVariants for Commission Case42LED_CURRCurrency Key for the Transactionnvarchar50
18YCRM01_B_VAR_OBJVariants for Commission Case Object Data67LED_CURRCurrency Key of Transaction in Object Areanvarchar50
19YCRM01_CASCommission Case30LED_CURRCurrency Key for the Transactionnvarchar50
20YCRM01_DOCHDCommission Document Header28LED_CURRCurrency Keynvarchar50
21YCRM01_DOCOBJCommission Document: Object Data12LED_CURRCurrency Keynvarchar50
22YCRM01_DOCRECommission Document, Remuneration and Liability63LED_CURRCurrency Keynvarchar50
23YCRM01_DOCSECommission Document: Due Dates20LED_CURRCurrency Keynvarchar50
24YCRM01_DOCVACommission Document, Valuation49LED_CURRCurrency Keynvarchar50
25YCRM01_OBJCommission Case Object Data63LED_CURRCurrency Key of Transaction in Object Areanvarchar50
26YCRM01_SESITSettlement Schedule Item16LED_CURRCurrency Keynvarchar50
27YCRM01_SUMRERemuneration Totals for Contract Account Display7LED_CURRCurrency Keynvarchar50
28YCRM01_SUMSEDue Date Totals for Contract Account Display7LED_CURRCurrency Keynvarchar50
29YCRM01_SUMVAValuation Totals for Contract Account Display7LED_CURRCurrency Keynvarchar50
30YCRM01_SUMVA91Commissions: Reference Totals Table for Valuation4LED_CURRCurrency Keynvarchar50
31YHITEC_B_VAR_CASVariants for Commission Case27LED_CURRCurrency Key for the Transactionnvarchar50
32YHITEC_CASCommission Case23LED_CURRCurrency Key for the Transactionnvarchar50
33YHITEC_DOCHDCommission Document Header29LED_CURRCurrency Keynvarchar50
34YHITEC_DOCRECommission Document, Remuneration and Liability46LED_CURRCurrency Keynvarchar50
35YHITEC_DOCSECommission Document: Due Dates20LED_CURRCurrency Keynvarchar50
36YHITEC_DOCVACommission Document, Valuation30LED_CURRCurrency Keynvarchar50
37YHITEC_SUMRERemuneration Totals for Contract Account Display7LED_CURRCurrency Keynvarchar50
38YHITEC_SUMSEDue Date Totals for Contract Account Display7LED_CURRCurrency Keynvarchar50
39YHITEC_SUMVAValuation Totals for Contract Account Display7LED_CURRCurrency Keynvarchar50
40YSVMA_B_VAR_CASVariants for Commission Case42LED_CURRCurrency Key for the Transactionnvarchar50
41YSVMA_B_VAR_OBJVariants for Commission Case Object Data35LED_CURRCurrency Key of Transaction in Object Areanvarchar50
42YSVMA_CASCommission Case38LED_CURRCurrency Key for the Transactionnvarchar50
43YSVMA_DOCHDCommission Document Header36LED_CURRCurrency Keynvarchar50
44YSVMA_DOCOBJCommission Document: Object Data24LED_CURRCurrency Keynvarchar50
45YSVMA_DOCRECommission Document, Remuneration and Liability40LED_CURRCurrency Keynvarchar50
46YSVMA_DOCSECommission Document: Due Dates20LED_CURRCurrency Keynvarchar50
47YSVMA_DOCVACommission Document, Valuation26LED_CURRCurrency Keynvarchar50
48YSVMA_OBJCommission Case Object Data27LED_CURRCurrency Key of Transaction in Object Areanvarchar50
49YSVMA_SESITSettlement Schedule Item16LED_CURRCurrency Keynvarchar50
50YSVMA_SUMRERemuneration Totals for Contract Account Display7LED_CURRCurrency Keynvarchar50
51YSVMA_SUMRE01Commissions: Reference Totals Table for Compensation6LED_CURRCurrency Keynvarchar50
52YSVMA_SUMSEDue Date Totals for Contract Account Display7LED_CURRCurrency Keynvarchar50
53YSVMA_SUMVAValuation Totals for Contract Account Display7LED_CURRCurrency Keynvarchar50
54YTEL01_B_VAR_CASVariants for Commission Case27LED_CURRCurrency Key for the Transactionnvarchar50
55YTEL01_CASCommission Case23LED_CURRCurrency Key for the Transactionnvarchar50
56YTEL01_DOCHDCommission Document Header29LED_CURRCurrency Keynvarchar50
57YTEL01_DOCRECommission Document, Remuneration and Liability60LED_CURRCurrency Keynvarchar50
58YTEL01_DOCSECommission Document: Due Dates37LED_CURRCurrency Keynvarchar50
59YTEL01_DOCVACommission Document, Valuation52LED_CURRCurrency Keynvarchar50
60YTEL01_SUMRERemuneration Totals for Contract Account Display7LED_CURRCurrency Keynvarchar50
61YTEL01_SUMRE04Commissions: Totals Table for Compensation (Scale Base)8LED_CURRCurrency Keynvarchar50
62YTEL01_SUMSEDue Date Totals for Contract Account Display7LED_CURRCurrency Keynvarchar50
63YTEL01_SUMVAValuation Totals for Contract Account Display7LED_CURRCurrency Keynvarchar50
64YTEL01_SUMVA02Reference Totals Table for Valuation (TELUS)8LED_CURRCurrency Keynvarchar50
65YTEL01_SUMVA03Reference Totals Table for Valuation (TELUS)5LED_CURRCurrency Keynvarchar50
66YTEL05_B_VAR_CASVariants for Commission Case42LED_CURRCurrency Key for the Transactionnvarchar50
67YTEL05_B_VAR_OBJVariants for Commission Case Object Data53LED_CURRCurrency Key of Transaction in Object Areanvarchar50
68YTEL05_CASCommission Case38LED_CURRCurrency Key for the Transactionnvarchar50
69YTEL05_DOCHDCommission Document Header36LED_CURRCurrency Keynvarchar50
70YTEL05_DOCOBJCommission Document: Object Data12LED_CURRCurrency Keynvarchar50
71YTEL05_DOCRECommission Document, Remuneration and Liability54LED_CURRCurrency Keynvarchar50
72YTEL05_DOCSECommission Document: Due Dates26LED_CURRCurrency Keynvarchar50
73YTEL05_DOCVACommission Document, Valuation36LED_CURRCurrency Keynvarchar50
74YTEL05_OBJCommission Case Object Data46LED_CURRCurrency Key of Transaction in Object Areanvarchar50
75YTEL05_SESITSettlement Schedule Item16LED_CURRCurrency Keynvarchar50
76YTEL05_SUMRERemuneration Totals for Contract Account Display7LED_CURRCurrency Keynvarchar50
77YTEL05_SUMRE01Commissions: Reference Totals Table for Compensation2LED_CURRCurrency Keynvarchar50
78YTEL05_SUMRE91Commissions: Reference Totals Table for Compensation2LED_CURRCurrency Keynvarchar50
79YTEL05_SUMSEDue Date Totals for Contract Account Display7LED_CURRCurrency Keynvarchar50
80YTEL05_SUMSE01Commissions: Reference Totals Table for Settlement2LED_CURRCurrency Keynvarchar50
81YTEL05_SUMSE91Commissions: Reference Totals Table for Settlement2LED_CURRCurrency Keynvarchar50
82YTEL05_SUMVAValuation Totals for Contract Account Display7LED_CURRCurrency Keynvarchar50
83YTEL05_SUMVA01Commissions: Reference Totals Table for Valuation2LED_CURRCurrency Keynvarchar50
84YTEL05_SUMVA91Commissions: Reference Totals Table for Valuation2LED_CURRCurrency Keynvarchar50
85ZICMAG_B_VAR_CASVariants for Commission Case27LED_CURRCurrency Key for the Transactionnvarchar50
86ZICMAG_CASCommission Case23LED_CURRCurrency Key for the Transactionnvarchar50
87ZICMAG_DOCHDCommission Document Header29LED_CURRCurrency Keynvarchar50
88ZICMAG_DOCRECommission Document, Remuneration and Liability38LED_CURRCurrency Keynvarchar50
89ZICMAG_DOCSECommission Document: Due Dates20LED_CURRCurrency Keynvarchar50
90ZICMAG_DOCVACommission Document, Valuation23LED_CURRCurrency Keynvarchar50
91ZICMAG_SUMRERemuneration Totals for Contract Account Display7LED_CURRCurrency Keynvarchar50
92ZICMAG_SUMSEDue Date Totals for Contract Account Display7LED_CURRCurrency Keynvarchar50
93ZICMAG_SUMVAValuation Totals for Contract Account Display7LED_CURRCurrency Keynvarchar50