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

123 columns | Print definition?ERP 6.0  | CASE_VERS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPIncentive and Commission Management ICM
1CACS00_ACTCommission Case Activities4CASE_VERSCommission Case Versionnvarchar60
2CACS00_BDLRebundling Order for Triggering Subobjects4CASE_VERSCommission Case Versionnvarchar60
3CACS00_B_VAR_ACTVariants for Commission Case Activities8CASE_VERSCommission Case Versionnvarchar60
4CACS00_B_VAR_BDLVariants for Bundling8CASE_VERSCommission Case Versionnvarchar60
5CACS00_B_VAR_CASVariants for Commission Case8CASE_VERSCommission Case Versionnvarchar60
6CACS00_B_VAR_INVVariants for Commission Case Participants8CASE_VERSCommission Case Versionnvarchar60
7CACS00_B_VAR_LINVariants for Alternative Commission8CASE_VERSCommission Case Versionnvarchar60
8CACS00_B_VAR_OBJVariants for Commission Case Object Data8CASE_VERSCommission Case Versionnvarchar60
9CACS00_B_VAR_PARVariants for Commission Case Participant8CASE_VERSCommission Case Versionnvarchar60
10CACS00_B_VAR_RELVariants for Participant Relations8CASE_VERSCommission Case Versionnvarchar60
11CACS00_CASCommission Case4CASE_VERSCommission Case Versionnvarchar60
12CACS00_INVCommission Case Participants4CASE_VERSCommission Case Versionnvarchar60
13CACS00_LINVariant Commissions4CASE_VERSCommission Case Versionnvarchar60
14CACS00_OBJCommission Case Object Data4CASE_VERSCommission Case Versionnvarchar60
15CACS00_PARCommission Case Participation4CASE_VERSCommission Case Versionnvarchar60
16CACS00_RELParticipant Relations in a Commission Participation4CASE_VERSCommission Case Versionnvarchar60
17CACSCP_RCP_BUFFRCP: Buffer Table for RCP Processing5CASE_VERSCommission Case Versionnvarchar60
18CACSCP_RCP_WLRCP: Worklist6CASE_VERSCommission Case Versionnvarchar60
19CACS_COILOGRecording of the Keys of Records Processed with COI6CASE_VERSCommission Case Versionnvarchar60
20CACS_TGLOGObsolete (Target Agreements: Log)11CASE_VERSCommission Case Versionnvarchar60
21CACS_WFCASCommission Case: Workflow Characteristics for Pending Cases5CASE_VERSCommission Case Versionnvarchar60
22TCACS_CATT01Directory of Commission Cases to be Tested Automatically6CASE_VERSCommission Case Versionnvarchar60
23TCACS_CATT01TDirectory of Commission Cases to be Tested Automatically7CASE_VERSCommission Case Versionnvarchar60
24YCRM01_ACTCommission Case Activities4CASE_VERSCommission Case Versionnvarchar60
25YCRM01_BDLRebundling Order for Triggering Subobjects4CASE_VERSCommission Case Versionnvarchar60
26YCRM01_B_VAR_ACTVariants for Commission Case Activities9CASE_VERSCommission Case Versionnvarchar60
27YCRM01_B_VAR_BDLVariants for Bundling8CASE_VERSCommission Case Versionnvarchar60
28YCRM01_B_VAR_CASVariants for Commission Case16CASE_VERSCommission Case Versionnvarchar60
29YCRM01_B_VAR_INVVariants for Commission Case Participants8CASE_VERSCommission Case Versionnvarchar60
30YCRM01_B_VAR_LINVariants for Alternative Commission8CASE_VERSCommission Case Versionnvarchar60
31YCRM01_B_VAR_OBJVariants for Commission Case Object Data55CASE_VERSCommission Case Versionnvarchar60
32YCRM01_B_VAR_PARVariants for Commission Case Participant8CASE_VERSCommission Case Versionnvarchar60
33YCRM01_B_VAR_RELVariants for Participant Relations8CASE_VERSCommission Case Versionnvarchar60
34YCRM01_CASCommission Case4CASE_VERSCommission Case Versionnvarchar60
35YCRM01_INVCommission Case Participants4CASE_VERSCommission Case Versionnvarchar60
36YCRM01_LINVariant Commissions4CASE_VERSCommission Case Versionnvarchar60
37YCRM01_OBJCommission Case Object Data4CASE_VERSCommission Case Versionnvarchar60
38YCRM01_PARCommission Case Participation4CASE_VERSCommission Case Versionnvarchar60
39YCRM01_RELParticipant Relations in a Commission Participation4CASE_VERSCommission Case Versionnvarchar60
40YHITEC_ACTCommission Case Activities4CASE_VERSCommission Case Versionnvarchar60
41YHITEC_BDLRebundling Order for Triggering Subobjects4CASE_VERSCommission Case Versionnvarchar60
42YHITEC_B_VAR_ACTVariants for Commission Case Activities8CASE_VERSCommission Case Versionnvarchar60
43YHITEC_B_VAR_BDLVariants for Bundling8CASE_VERSCommission Case Versionnvarchar60
44YHITEC_B_VAR_CASVariants for Commission Case8CASE_VERSCommission Case Versionnvarchar60
45YHITEC_B_VAR_INVVariants for Commission Case Participants8CASE_VERSCommission Case Versionnvarchar60
46YHITEC_B_VAR_LINVariants for Alternative Commission8CASE_VERSCommission Case Versionnvarchar60
47YHITEC_B_VAR_OBJVariants for Commission Case Object Data19CASE_VERSCommission Case Versionnvarchar60
48YHITEC_B_VAR_PARVariants for Commission Case Participant8CASE_VERSCommission Case Versionnvarchar60
49YHITEC_B_VAR_RELVariants for Participant Relations8CASE_VERSCommission Case Versionnvarchar60
50YHITEC_CASCommission Case4CASE_VERSCommission Case Versionnvarchar60
51YHITEC_INVCommission Case Participants4CASE_VERSCommission Case Versionnvarchar60
52YHITEC_LINVariant Commissions4CASE_VERSCommission Case Versionnvarchar60
53YHITEC_OBJCommission Case Object Data4CASE_VERSCommission Case Versionnvarchar60
54YHITEC_PARCommission Case Participation4CASE_VERSCommission Case Versionnvarchar60
55YHITEC_RELParticipant Relations in a Commission Participation4CASE_VERSCommission Case Versionnvarchar60
56YSVMA_ACTCommission Case Activities4CASE_VERSCommission Case Versionnvarchar60
57YSVMA_BDLRebundling Order for Triggering Subobjects4CASE_VERSCommission Case Versionnvarchar60
58YSVMA_B_VAR_ACTVariants for Commission Case Activities8CASE_VERSCommission Case Versionnvarchar60
59YSVMA_B_VAR_BDLVariants for Bundling8CASE_VERSCommission Case Versionnvarchar60
60YSVMA_B_VAR_CASVariants for Commission Case16CASE_VERSCommission Case Versionnvarchar60
61YSVMA_B_VAR_INVVariants for Commission Case Participants8CASE_VERSCommission Case Versionnvarchar60
62YSVMA_B_VAR_LINVariants for Alternative Commission8CASE_VERSCommission Case Versionnvarchar60
63YSVMA_B_VAR_OBJVariants for Commission Case Object Data23CASE_VERSCommission Case Versionnvarchar60
64YSVMA_B_VAR_PARVariants for Commission Case Participant8CASE_VERSCommission Case Versionnvarchar60
65YSVMA_B_VAR_RELVariants for Participant Relations8CASE_VERSCommission Case Versionnvarchar60
66YSVMA_CASCommission Case4CASE_VERSCommission Case Versionnvarchar60
67YSVMA_INVCommission Case Participants4CASE_VERSCommission Case Versionnvarchar60
68YSVMA_LINVariant Commissions4CASE_VERSCommission Case Versionnvarchar60
69YSVMA_OBJCommission Case Object Data4CASE_VERSCommission Case Versionnvarchar60
70YSVMA_PARCommission Case Participation4CASE_VERSCommission Case Versionnvarchar60
71YSVMA_RCP_BUFFRCP: Buffer Table for RCP Processing5CASE_VERSCommission Case Versionnvarchar60
72YSVMA_RCP_WLRCP: Worklist6CASE_VERSCommission Case Versionnvarchar60
73YSVMA_RELParticipant Relations in a Commission Participation4CASE_VERSCommission Case Versionnvarchar60
74YTEL01_ACTCommission Case Activities4CASE_VERSCommission Case Versionnvarchar60
75YTEL01_BDLRebundling Order for Triggering Subobjects4CASE_VERSCommission Case Versionnvarchar60
76YTEL01_B_VAR_ACTVariants for Commission Case Activities8CASE_VERSCommission Case Versionnvarchar60
77YTEL01_B_VAR_BDLVariants for Bundling8CASE_VERSCommission Case Versionnvarchar60
78YTEL01_B_VAR_CASVariants for Commission Case8CASE_VERSCommission Case Versionnvarchar60
79YTEL01_B_VAR_INVVariants for Commission Case Participants8CASE_VERSCommission Case Versionnvarchar60
80YTEL01_B_VAR_LINVariants for Alternative Commission8CASE_VERSCommission Case Versionnvarchar60
81YTEL01_B_VAR_OBJVariants for Commission Case Object Data43CASE_VERSCommission Case Versionnvarchar60
82YTEL01_B_VAR_PARVariants for Commission Case Participant8CASE_VERSCommission Case Versionnvarchar60
83YTEL01_B_VAR_RELVariants for Participant Relations8CASE_VERSCommission Case Versionnvarchar60
84YTEL01_CASCommission Case4CASE_VERSCommission Case Versionnvarchar60
85YTEL01_INVCommission Case Participants4CASE_VERSCommission Case Versionnvarchar60
86YTEL01_LINVariant Commissions4CASE_VERSCommission Case Versionnvarchar60
87YTEL01_OBJCommission Case Object Data4CASE_VERSCommission Case Versionnvarchar60
88YTEL01_PARCommission Case Participation4CASE_VERSCommission Case Versionnvarchar60
89YTEL01_RELParticipant Relations in a Commission Participation4CASE_VERSCommission Case Versionnvarchar60
90YTEL05_ACTCommission Case Activities4CASE_VERSCommission Case Versionnvarchar60
91YTEL05_BDLRebundling Order for Triggering Subobjects4CASE_VERSCommission Case Versionnvarchar60
92YTEL05_B_VAR_ACTVariants for Commission Case Activities8CASE_VERSCommission Case Versionnvarchar60
93YTEL05_B_VAR_BDLVariants for Bundling8CASE_VERSCommission Case Versionnvarchar60
94YTEL05_B_VAR_CASVariants for Commission Case16CASE_VERSCommission Case Versionnvarchar60
95YTEL05_B_VAR_INVVariants for Commission Case Participants10CASE_VERSCommission Case Versionnvarchar60
96YTEL05_B_VAR_LINVariants for Alternative Commission8CASE_VERSCommission Case Versionnvarchar60
97YTEL05_B_VAR_OBJVariants for Commission Case Object Data41CASE_VERSCommission Case Versionnvarchar60
98YTEL05_B_VAR_PARVariants for Commission Case Participant8CASE_VERSCommission Case Versionnvarchar60
99YTEL05_B_VAR_RELVariants for Participant Relations8CASE_VERSCommission Case Versionnvarchar60
100YTEL05_CASCommission Case4CASE_VERSCommission Case Versionnvarchar60
101YTEL05_INVCommission Case Participants4CASE_VERSCommission Case Versionnvarchar60
102YTEL05_LINVariant Commissions4CASE_VERSCommission Case Versionnvarchar60
103YTEL05_OBJCommission Case Object Data4CASE_VERSCommission Case Versionnvarchar60
104YTEL05_PARCommission Case Participation4CASE_VERSCommission Case Versionnvarchar60
105YTEL05_RCP_BUFFRCP: Buffer Table for RCP Processing5CASE_VERSCommission Case Versionnvarchar60
106YTEL05_RCP_WLRCP: Worklist6CASE_VERSCommission Case Versionnvarchar60
107YTEL05_RELParticipant Relations in a Commission Participation4CASE_VERSCommission Case Versionnvarchar60
108ZICMAG_ACTCommission Case Activities4CASE_VERSCommission Case Versionnvarchar60
109ZICMAG_BDLRebundling Order for Triggering Subobjects4CASE_VERSCommission Case Versionnvarchar60
110ZICMAG_B_VAR_ACTVariants for Commission Case Activities8CASE_VERSCommission Case Versionnvarchar60
111ZICMAG_B_VAR_BDLVariants for Bundling8CASE_VERSCommission Case Versionnvarchar60
112ZICMAG_B_VAR_CASVariants for Commission Case8CASE_VERSCommission Case Versionnvarchar60
113ZICMAG_B_VAR_INVVariants for Commission Case Participants8CASE_VERSCommission Case Versionnvarchar60
114ZICMAG_B_VAR_LINVariants for Alternative Commission8CASE_VERSCommission Case Versionnvarchar60
115ZICMAG_B_VAR_OBJVariants for Commission Case Object Data11CASE_VERSCommission Case Versionnvarchar60
116ZICMAG_B_VAR_PARVariants for Commission Case Participant8CASE_VERSCommission Case Versionnvarchar60
117ZICMAG_B_VAR_RELVariants for Participant Relations8CASE_VERSCommission Case Versionnvarchar60
118ZICMAG_CASCommission Case4CASE_VERSCommission Case Versionnvarchar60
119ZICMAG_INVCommission Case Participants4CASE_VERSCommission Case Versionnvarchar60
120ZICMAG_LINVariant Commissions4CASE_VERSCommission Case Versionnvarchar60
121ZICMAG_OBJCommission Case Object Data4CASE_VERSCommission Case Versionnvarchar60
122ZICMAG_PARCommission Case Participation4CASE_VERSCommission Case Versionnvarchar60
123ZICMAG_RELParticipant Relations in a Commission Participation4CASE_VERSCommission Case Versionnvarchar60