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

105 columns | Print definition?ERP 6.0  | TRI_OBJ_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPIncentive and Commission Management ICM
1CACS00_ACTCommission Case Activities10TRI_OBJ_TYPETriggering Subobject Typenvarchar50
2CACS00_BDLRebundling Order for Triggering Subobjects6TRI_OBJ_TYPETriggering Subobject Typenvarchar50
3CACS00_B_VAR_ACTVariants for Commission Case Activities14TRI_OBJ_TYPETriggering Subobject Typenvarchar50
4CACS00_B_VAR_BDLVariants for Bundling10TRI_OBJ_TYPETriggering Subobject Typenvarchar50
5CACS00_B_VAR_LINVariants for Alternative Commission14TRI_OBJ_TYPETriggering Subobject Typenvarchar50
6CACS00_B_VAR_OBJVariants for Commission Case Object Data9TRI_OBJ_TYPETriggering Subobject Typenvarchar50
7CACS00_DOCOBJCommission Document: Object Data4TRI_OBJ_TYPETriggering Subobject Typenvarchar50
8CACS00_DOCVACommission Document, Valuation12TRI_OBJ_TYPETriggering Subobject Typenvarchar50
9CACS00_LINVariant Commissions10TRI_OBJ_TYPETriggering Subobject Typenvarchar50
10CACS00_OBJCommission Case Object Data5TRI_OBJ_TYPETriggering Subobject Typenvarchar50
11CACS00_OBJHISTChange History of Subobjects That Trigger Commission4TRI_OBJ_TYPETriggering Subobject Typenvarchar50
12CACS00_SUMVATotals Table for Valuation2TRI_OBJ_TYPETriggering Subobject Typenvarchar50
13CACS_FFLTITFulfillment Level Item14TRI_OBJ_TYPETriggering Subobject Typenvarchar50
14TCACS_ACT_CHARComn.: Activity Type Characteristic3TRI_OBJ_TYPETriggering Subobject Typenvarchar50
15TCACS_PCACTParticipation Construction: Activities Template4TRI_OBJ_TYPETriggering Subobject Typenvarchar50
16TCACS_TRMETriggering Method (incl. Assignment to Activity Types)3TRI_OBJ_TYPETriggering Subobject Typenvarchar50
17TCACS_TRME_TNames of Triggering Methods4TRI_OBJ_TYPETriggering Subobject Typenvarchar50
18TCACS_VALComn.: Valuation Types5TRI_OBJ_TYPETriggering Subobject Typenvarchar50
19YCRM01_ACTCommission Case Activities10TRI_OBJ_TYPETriggering Subobject Typenvarchar50
20YCRM01_BDLRebundling Order for Triggering Subobjects6TRI_OBJ_TYPETriggering Subobject Typenvarchar50
21YCRM01_B_VAR_ACTVariants for Commission Case Activities15TRI_OBJ_TYPETriggering Subobject Typenvarchar50
22YCRM01_B_VAR_BDLVariants for Bundling10TRI_OBJ_TYPETriggering Subobject Typenvarchar50
23YCRM01_B_VAR_LINVariants for Alternative Commission14TRI_OBJ_TYPETriggering Subobject Typenvarchar50
24YCRM01_B_VAR_OBJVariants for Commission Case Object Data56TRI_OBJ_TYPETriggering Subobject Typenvarchar50
25YCRM01_DOCOBJCommission Document: Object Data4TRI_OBJ_TYPETriggering Subobject Typenvarchar50
26YCRM01_DOCVACommission Document, Valuation40TRI_OBJ_TYPETriggering Subobject Typenvarchar50
27YCRM01_LINVariant Commissions10TRI_OBJ_TYPETriggering Subobject Typenvarchar50
28YCRM01_OBJCommission Case Object Data5TRI_OBJ_TYPETriggering Subobject Typenvarchar50
29YCRM01_OBJHISTChange History of Subobjects That Trigger Commission4TRI_OBJ_TYPETriggering Subobject Typenvarchar50
30YCRM01_SELTAB90YCRM01_SELTAB902TRI_OBJ_TYPETriggering Subobject Typenvarchar50
31YCRM01_SELTAB98YCRM01_SELTAB98 Role3TRI_OBJ_TYPETriggering Subobject Typenvarchar50
32YCRM01_SELTABC0YCRM01_SELTAB902TRI_OBJ_TYPETriggering Subobject Typenvarchar50
33YCRM01_SELTABC8YCRM01_SELTAB98 Role3TRI_OBJ_TYPETriggering Subobject Typenvarchar50
34YCRM01_SUMVAValuation Totals for Contract Account Display2TRI_OBJ_TYPETriggering Subobject Typenvarchar50
35YHITEC_ACTCommission Case Activities10TRI_OBJ_TYPETriggering Subobject Typenvarchar50
36YHITEC_BDLRebundling Order for Triggering Subobjects6TRI_OBJ_TYPETriggering Subobject Typenvarchar50
37YHITEC_B_VAR_ACTVariants for Commission Case Activities14TRI_OBJ_TYPETriggering Subobject Typenvarchar50
38YHITEC_B_VAR_BDLVariants for Bundling10TRI_OBJ_TYPETriggering Subobject Typenvarchar50
39YHITEC_B_VAR_LINVariants for Alternative Commission14TRI_OBJ_TYPETriggering Subobject Typenvarchar50
40YHITEC_B_VAR_OBJVariants for Commission Case Object Data20TRI_OBJ_TYPETriggering Subobject Typenvarchar50
41YHITEC_DOCOBJCommission Document: Object Data4TRI_OBJ_TYPETriggering Subobject Typenvarchar50
42YHITEC_DOCVACommission Document, Valuation21TRI_OBJ_TYPETriggering Subobject Typenvarchar50
43YHITEC_LINVariant Commissions10TRI_OBJ_TYPETriggering Subobject Typenvarchar50
44YHITEC_OBJCommission Case Object Data5TRI_OBJ_TYPETriggering Subobject Typenvarchar50
45YHITEC_OBJHISTChange History of Subobjects That Trigger Commission4TRI_OBJ_TYPETriggering Subobject Typenvarchar50
46YHITEC_SELTAB90YCRM01_SELTAB902TRI_OBJ_TYPETriggering Subobject Typenvarchar50
47YHITEC_SELTAB98YCRM01_SELTAB98 Role3TRI_OBJ_TYPETriggering Subobject Typenvarchar50
48YHITEC_SUMVAValuation Totals for Contract Account Display2TRI_OBJ_TYPETriggering Subobject Typenvarchar50
49YSVMA_ACTCommission Case Activities10TRI_OBJ_TYPETriggering Subobject Typenvarchar50
50YSVMA_BDLRebundling Order for Triggering Subobjects6TRI_OBJ_TYPETriggering Subobject Typenvarchar50
51YSVMA_B_VAR_ACTVariants for Commission Case Activities14TRI_OBJ_TYPETriggering Subobject Typenvarchar50
52YSVMA_B_VAR_BDLVariants for Bundling10TRI_OBJ_TYPETriggering Subobject Typenvarchar50
53YSVMA_B_VAR_LINVariants for Alternative Commission14TRI_OBJ_TYPETriggering Subobject Typenvarchar50
54YSVMA_B_VAR_OBJVariants for Commission Case Object Data24TRI_OBJ_TYPETriggering Subobject Typenvarchar50
55YSVMA_DOCOBJCommission Document: Object Data4TRI_OBJ_TYPETriggering Subobject Typenvarchar50
56YSVMA_DOCVACommission Document, Valuation17TRI_OBJ_TYPETriggering Subobject Typenvarchar50
57YSVMA_LINVariant Commissions10TRI_OBJ_TYPETriggering Subobject Typenvarchar50
58YSVMA_OBJCommission Case Object Data5TRI_OBJ_TYPETriggering Subobject Typenvarchar50
59YSVMA_OBJHISTChange History of Subobjects That Trigger Commission4TRI_OBJ_TYPETriggering Subobject Typenvarchar50
60YSVMA_SELTAB01Selection Table CACS00_SELTAB013TRI_OBJ_TYPETriggering Subobject Typenvarchar50
61YSVMA_SUMVAValuation Totals for Contract Account Display2TRI_OBJ_TYPETriggering Subobject Typenvarchar50
62YTEL01_ACTCommission Case Activities10TRI_OBJ_TYPETriggering Subobject Typenvarchar50
63YTEL01_BDLRebundling Order for Triggering Subobjects6TRI_OBJ_TYPETriggering Subobject Typenvarchar50
64YTEL01_B_VAR_ACTVariants for Commission Case Activities14TRI_OBJ_TYPETriggering Subobject Typenvarchar50
65YTEL01_B_VAR_BDLVariants for Bundling10TRI_OBJ_TYPETriggering Subobject Typenvarchar50
66YTEL01_B_VAR_LINVariants for Alternative Commission14TRI_OBJ_TYPETriggering Subobject Typenvarchar50
67YTEL01_B_VAR_OBJVariants for Commission Case Object Data44TRI_OBJ_TYPETriggering Subobject Typenvarchar50
68YTEL01_DOCOBJCommission Document: Object Data4TRI_OBJ_TYPETriggering Subobject Typenvarchar50
69YTEL01_DOCVACommission Document, Valuation43TRI_OBJ_TYPETriggering Subobject Typenvarchar50
70YTEL01_LINVariant Commissions10TRI_OBJ_TYPETriggering Subobject Typenvarchar50
71YTEL01_OBJCommission Case Object Data5TRI_OBJ_TYPETriggering Subobject Typenvarchar50
72YTEL01_OBJHISTChange History of Subobjects That Trigger Commission4TRI_OBJ_TYPETriggering Subobject Typenvarchar50
73YTEL01_SUMVAValuation Totals for Contract Account Display2TRI_OBJ_TYPETriggering Subobject Typenvarchar50
74YTEL01_SUMVA02Reference Totals Table for Valuation (TELUS)3TRI_OBJ_TYPETriggering Subobject Typenvarchar50
75YTEL01_SUMVA03Reference Totals Table for Valuation (TELUS)2TRI_OBJ_TYPETriggering Subobject Typenvarchar50
76YTEL05_ACTCommission Case Activities10TRI_OBJ_TYPETriggering Subobject Typenvarchar50
77YTEL05_BDLRebundling Order for Triggering Subobjects6TRI_OBJ_TYPETriggering Subobject Typenvarchar50
78YTEL05_B_VAR_ACTVariants for Commission Case Activities14TRI_OBJ_TYPETriggering Subobject Typenvarchar50
79YTEL05_B_VAR_BDLVariants for Bundling10TRI_OBJ_TYPETriggering Subobject Typenvarchar50
80YTEL05_B_VAR_LINVariants for Alternative Commission14TRI_OBJ_TYPETriggering Subobject Typenvarchar50
81YTEL05_B_VAR_OBJVariants for Commission Case Object Data42TRI_OBJ_TYPETriggering Subobject Typenvarchar50
82YTEL05_DOCOBJCommission Document: Object Data4TRI_OBJ_TYPETriggering Subobject Typenvarchar50
83YTEL05_DOCVACommission Document, Valuation27TRI_OBJ_TYPETriggering Subobject Typenvarchar50
84YTEL05_LINVariant Commissions10TRI_OBJ_TYPETriggering Subobject Typenvarchar50
85YTEL05_OBJCommission Case Object Data5TRI_OBJ_TYPETriggering Subobject Typenvarchar50
86YTEL05_OBJHISTChange History of Subobjects That Trigger Commission4TRI_OBJ_TYPETriggering Subobject Typenvarchar50
87YTEL05_SELTAB01Selection Table CACS00_SELTAB012TRI_OBJ_TYPETriggering Subobject Typenvarchar50
88YTEL05_SELTAB90YCRM01_SELTAB902TRI_OBJ_TYPETriggering Subobject Typenvarchar50
89YTEL05_SELTAB98YCRM01_SELTAB98 Role3TRI_OBJ_TYPETriggering Subobject Typenvarchar50
90YTEL05_SELTABC0YCRM01_SELTAB902TRI_OBJ_TYPETriggering Subobject Typenvarchar50
91YTEL05_SELTABC8YCRM01_SELTAB98 Role3TRI_OBJ_TYPETriggering Subobject Typenvarchar50
92YTEL05_SUMVAValuation Totals for Contract Account Display2TRI_OBJ_TYPETriggering Subobject Typenvarchar50
93ZICMAG_ACTCommission Case Activities10TRI_OBJ_TYPETriggering Subobject Typenvarchar50
94ZICMAG_BDLRebundling Order for Triggering Subobjects6TRI_OBJ_TYPETriggering Subobject Typenvarchar50
95ZICMAG_B_VAR_ACTVariants for Commission Case Activities14TRI_OBJ_TYPETriggering Subobject Typenvarchar50
96ZICMAG_B_VAR_BDLVariants for Bundling10TRI_OBJ_TYPETriggering Subobject Typenvarchar50
97ZICMAG_B_VAR_LINVariants for Alternative Commission14TRI_OBJ_TYPETriggering Subobject Typenvarchar50
98ZICMAG_B_VAR_OBJVariants for Commission Case Object Data12TRI_OBJ_TYPETriggering Subobject Typenvarchar50
99ZICMAG_DOCOBJCommission Document: Object Data4TRI_OBJ_TYPETriggering Subobject Typenvarchar50
100ZICMAG_DOCVACommission Document, Valuation14TRI_OBJ_TYPETriggering Subobject Typenvarchar50
101ZICMAG_LINVariant Commissions10TRI_OBJ_TYPETriggering Subobject Typenvarchar50
102ZICMAG_OBJCommission Case Object Data5TRI_OBJ_TYPETriggering Subobject Typenvarchar50
103ZICMAG_OBJHISTChange History of Subobjects That Trigger Commission4TRI_OBJ_TYPETriggering Subobject Typenvarchar50
104ZICMAG_SELTAB01Selektionstab. CACS00_SELTAB013TRI_OBJ_TYPETriggering Subobject Typenvarchar50
105ZICMAG_SUMVAValuation Totals for Contract Account Display2TRI_OBJ_TYPETriggering Subobject Typenvarchar50