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

70 columns | Print definition?ERP 6.0  | TRI_OBJ_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPIncentive and Commission Management ICM
1CACS00_ACTCommission Case Activities11TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
2CACS00_B_VAR_ACTVariants for Commission Case Activities15TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
3CACS00_B_VAR_LINVariants for Alternative Commission16TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
4CACS00_B_VAR_OBJVariants for Commission Case Object Data11TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
5CACS00_DOCOBJCommission Document: Object Data6TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
6CACS00_DOCVACommission Document, Valuation13TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
7CACS00_LINVariant Commissions12TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
8CACS00_OBJCommission Case Object Data7TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
9CACS00_OBJHISTChange History of Subobjects That Trigger Commission2TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
10CACS00_SUMVATotals Table for Valuation3TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
11YCRM01_ACTCommission Case Activities11TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
12YCRM01_B_VAR_ACTVariants for Commission Case Activities16TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
13YCRM01_B_VAR_LINVariants for Alternative Commission16TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
14YCRM01_B_VAR_OBJVariants for Commission Case Object Data58TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
15YCRM01_DOCOBJCommission Document: Object Data6TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
16YCRM01_DOCVACommission Document, Valuation41TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
17YCRM01_LINVariant Commissions12TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
18YCRM01_OBJCommission Case Object Data54TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
19YCRM01_OBJHISTChange History of Subobjects That Trigger Commission2TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
20YCRM01_SUMVAValuation Totals for Contract Account Display3TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
21YHITEC_ACTCommission Case Activities11TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
22YHITEC_B_VAR_ACTVariants for Commission Case Activities15TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
23YHITEC_B_VAR_LINVariants for Alternative Commission16TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
24YHITEC_B_VAR_OBJVariants for Commission Case Object Data22TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
25YHITEC_DOCOBJCommission Document: Object Data6TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
26YHITEC_DOCVACommission Document, Valuation22TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
27YHITEC_LINVariant Commissions12TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
28YHITEC_OBJCommission Case Object Data18TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
29YHITEC_OBJHISTChange History of Subobjects That Trigger Commission2TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
30YHITEC_SUMVAValuation Totals for Contract Account Display3TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
31YSVMA_ACTCommission Case Activities11TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
32YSVMA_B_VAR_ACTVariants for Commission Case Activities15TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
33YSVMA_B_VAR_LINVariants for Alternative Commission16TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
34YSVMA_B_VAR_OBJVariants for Commission Case Object Data26TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
35YSVMA_DOCOBJCommission Document: Object Data18TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
36YSVMA_DOCVACommission Document, Valuation18TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
37YSVMA_LINVariant Commissions12TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
38YSVMA_OBJCommission Case Object Data18TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
39YSVMA_OBJHISTChange History of Subobjects That Trigger Commission2TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
40YSVMA_SUMVAValuation Totals for Contract Account Display3TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
41YTEL01_ACTCommission Case Activities11TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
42YTEL01_B_VAR_ACTVariants for Commission Case Activities15TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
43YTEL01_B_VAR_LINVariants for Alternative Commission16TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
44YTEL01_B_VAR_OBJVariants for Commission Case Object Data46TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
45YTEL01_DOCOBJCommission Document: Object Data6TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
46YTEL01_DOCVACommission Document, Valuation44TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
47YTEL01_LINVariant Commissions12TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
48YTEL01_OBJCommission Case Object Data42TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
49YTEL01_OBJHISTChange History of Subobjects That Trigger Commission2TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
50YTEL01_SUMVAValuation Totals for Contract Account Display3TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
51YTEL05_ACTCommission Case Activities11TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
52YTEL05_B_VAR_ACTVariants for Commission Case Activities15TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
53YTEL05_B_VAR_LINVariants for Alternative Commission16TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
54YTEL05_B_VAR_OBJVariants for Commission Case Object Data44TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
55YTEL05_DOCOBJCommission Document: Object Data6TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
56YTEL05_DOCVACommission Document, Valuation28TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
57YTEL05_LINVariant Commissions12TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
58YTEL05_OBJCommission Case Object Data37TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
59YTEL05_OBJHISTChange History of Subobjects That Trigger Commission2TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
60YTEL05_SUMVAValuation Totals for Contract Account Display3TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
61ZICMAG_ACTCommission Case Activities11TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
62ZICMAG_B_VAR_ACTVariants for Commission Case Activities15TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
63ZICMAG_B_VAR_LINVariants for Alternative Commission16TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
64ZICMAG_B_VAR_OBJVariants for Commission Case Object Data14TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
65ZICMAG_DOCOBJCommission Document: Object Data6TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
66ZICMAG_DOCVACommission Document, Valuation15TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
67ZICMAG_LINVariant Commissions12TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
68ZICMAG_OBJCommission Case Object Data10TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
69ZICMAG_OBJHISTChange History of Subobjects That Trigger Commission2TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120
70ZICMAG_SUMVAValuation Totals for Contract Account Display3TRI_OBJ_IDIdentification of Triggering Subobjectnvarchar120