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

135 columns | Print definition?ERP 6.0  | IMPORT_YEAR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPIncentive and Commission Management ICM
1CACS00_ACTCommission Case Activities2IMPORT_YEARYear Commission Case Reportednvarchar40
2CACS00_BDLRebundling Order for Triggering Subobjects2IMPORT_YEARYear Commission Case Reportednvarchar40
3CACS00_B_VAR_ACTVariants for Commission Case Activities6IMPORT_YEARYear Commission Case Reportednvarchar40
4CACS00_B_VAR_BDLVariants for Bundling6IMPORT_YEARYear Commission Case Reportednvarchar40
5CACS00_B_VAR_CASVariants for Commission Case6IMPORT_YEARYear Commission Case Reportednvarchar40
6CACS00_B_VAR_INVVariants for Commission Case Participants6IMPORT_YEARYear Commission Case Reportednvarchar40
7CACS00_B_VAR_LINVariants for Alternative Commission6IMPORT_YEARYear Commission Case Reportednvarchar40
8CACS00_B_VAR_OBJVariants for Commission Case Object Data6IMPORT_YEARYear Commission Case Reportednvarchar40
9CACS00_B_VAR_PARVariants for Commission Case Participant6IMPORT_YEARYear Commission Case Reportednvarchar40
10CACS00_B_VAR_RELVariants for Participant Relations6IMPORT_YEARYear Commission Case Reportednvarchar40
11CACS00_CASCommission Case2IMPORT_YEARYear Commission Case Reportednvarchar40
12CACS00_INVCommission Case Participants2IMPORT_YEARYear Commission Case Reportednvarchar40
13CACS00_LINVariant Commissions2IMPORT_YEARYear Commission Case Reportednvarchar40
14CACS00_OBJCommission Case Object Data2IMPORT_YEARYear Commission Case Reportednvarchar40
15CACS00_OBJHISTChange History of Subobjects That Trigger Commission8IMPORT_YEARYear Commission Case Reportednvarchar40
16CACS00_PARCommission Case Participation2IMPORT_YEARYear Commission Case Reportednvarchar40
17CACS00_RELParticipant Relations in a Commission Participation2IMPORT_YEARYear Commission Case Reportednvarchar40
18CACSCP_RCP_BUFFRCP: Buffer Table for RCP Processing3IMPORT_YEARYear Commission Case Reportednvarchar40
19CACSCP_RCP_CASERCP: Initial Commission Cases2IMPORT_YEARYear Commission Case Reportednvarchar40
20CACSCP_RCP_WLRCP: Worklist4IMPORT_YEARYear Commission Case Reportednvarchar40
21CACS_BUFFLOGCommissions: Log Table of Commission Objects4IMPORT_YEARYear Commission Case Reportednvarchar40
22CACS_COILOGRecording of the Keys of Records Processed with COI4IMPORT_YEARYear Commission Case Reportednvarchar40
23CACS_EDTPROTCommissions: Log for EDT Interface Supply7IMPORT_YEARYear Commission Case Reportednvarchar40
24CACS_TGLOGObsolete (Target Agreements: Log)9IMPORT_YEARYear Commission Case Reportednvarchar40
25CACS_WFCASCommission Case: Workflow Characteristics for Pending Cases3IMPORT_YEARYear Commission Case Reportednvarchar40
26TCACS_CATT01Directory of Commission Cases to be Tested Automatically4IMPORT_YEARYear Commission Case Reportednvarchar40
27TCACS_CATT01TDirectory of Commission Cases to be Tested Automatically5IMPORT_YEARYear Commission Case Reportednvarchar40
28YCRM01_ACTCommission Case Activities2IMPORT_YEARYear Commission Case Reportednvarchar40
29YCRM01_BDLRebundling Order for Triggering Subobjects2IMPORT_YEARYear Commission Case Reportednvarchar40
30YCRM01_B_VAR_ACTVariants for Commission Case Activities7IMPORT_YEARYear Commission Case Reportednvarchar40
31YCRM01_B_VAR_BDLVariants for Bundling6IMPORT_YEARYear Commission Case Reportednvarchar40
32YCRM01_B_VAR_CASVariants for Commission Case14IMPORT_YEARYear Commission Case Reportednvarchar40
33YCRM01_B_VAR_INVVariants for Commission Case Participants6IMPORT_YEARYear Commission Case Reportednvarchar40
34YCRM01_B_VAR_LINVariants for Alternative Commission6IMPORT_YEARYear Commission Case Reportednvarchar40
35YCRM01_B_VAR_OBJVariants for Commission Case Object Data53IMPORT_YEARYear Commission Case Reportednvarchar40
36YCRM01_B_VAR_PARVariants for Commission Case Participant6IMPORT_YEARYear Commission Case Reportednvarchar40
37YCRM01_B_VAR_RELVariants for Participant Relations6IMPORT_YEARYear Commission Case Reportednvarchar40
38YCRM01_CASCommission Case2IMPORT_YEARYear Commission Case Reportednvarchar40
39YCRM01_INVCommission Case Participants2IMPORT_YEARYear Commission Case Reportednvarchar40
40YCRM01_LINVariant Commissions2IMPORT_YEARYear Commission Case Reportednvarchar40
41YCRM01_OBJCommission Case Object Data2IMPORT_YEARYear Commission Case Reportednvarchar40
42YCRM01_OBJHISTChange History of Subobjects That Trigger Commission8IMPORT_YEARYear Commission Case Reportednvarchar40
43YCRM01_PARCommission Case Participation2IMPORT_YEARYear Commission Case Reportednvarchar40
44YCRM01_RELParticipant Relations in a Commission Participation2IMPORT_YEARYear Commission Case Reportednvarchar40
45YHITEC_ACTCommission Case Activities2IMPORT_YEARYear Commission Case Reportednvarchar40
46YHITEC_BDLRebundling Order for Triggering Subobjects2IMPORT_YEARYear Commission Case Reportednvarchar40
47YHITEC_B_VAR_ACTVariants for Commission Case Activities6IMPORT_YEARYear Commission Case Reportednvarchar40
48YHITEC_B_VAR_BDLVariants for Bundling6IMPORT_YEARYear Commission Case Reportednvarchar40
49YHITEC_B_VAR_CASVariants for Commission Case6IMPORT_YEARYear Commission Case Reportednvarchar40
50YHITEC_B_VAR_INVVariants for Commission Case Participants6IMPORT_YEARYear Commission Case Reportednvarchar40
51YHITEC_B_VAR_LINVariants for Alternative Commission6IMPORT_YEARYear Commission Case Reportednvarchar40
52YHITEC_B_VAR_OBJVariants for Commission Case Object Data17IMPORT_YEARYear Commission Case Reportednvarchar40
53YHITEC_B_VAR_PARVariants for Commission Case Participant6IMPORT_YEARYear Commission Case Reportednvarchar40
54YHITEC_B_VAR_RELVariants for Participant Relations6IMPORT_YEARYear Commission Case Reportednvarchar40
55YHITEC_CASCommission Case2IMPORT_YEARYear Commission Case Reportednvarchar40
56YHITEC_INVCommission Case Participants2IMPORT_YEARYear Commission Case Reportednvarchar40
57YHITEC_LINVariant Commissions2IMPORT_YEARYear Commission Case Reportednvarchar40
58YHITEC_OBJCommission Case Object Data2IMPORT_YEARYear Commission Case Reportednvarchar40
59YHITEC_OBJHISTChange History of Subobjects That Trigger Commission8IMPORT_YEARYear Commission Case Reportednvarchar40
60YHITEC_PARCommission Case Participation2IMPORT_YEARYear Commission Case Reportednvarchar40
61YHITEC_RELParticipant Relations in a Commission Participation2IMPORT_YEARYear Commission Case Reportednvarchar40
62YSVMA_ACTCommission Case Activities2IMPORT_YEARYear Commission Case Reportednvarchar40
63YSVMA_BDLRebundling Order for Triggering Subobjects2IMPORT_YEARYear Commission Case Reportednvarchar40
64YSVMA_B_VAR_ACTVariants for Commission Case Activities6IMPORT_YEARYear Commission Case Reportednvarchar40
65YSVMA_B_VAR_BDLVariants for Bundling6IMPORT_YEARYear Commission Case Reportednvarchar40
66YSVMA_B_VAR_CASVariants for Commission Case14IMPORT_YEARYear Commission Case Reportednvarchar40
67YSVMA_B_VAR_INVVariants for Commission Case Participants6IMPORT_YEARYear Commission Case Reportednvarchar40
68YSVMA_B_VAR_LINVariants for Alternative Commission6IMPORT_YEARYear Commission Case Reportednvarchar40
69YSVMA_B_VAR_OBJVariants for Commission Case Object Data21IMPORT_YEARYear Commission Case Reportednvarchar40
70YSVMA_B_VAR_PARVariants for Commission Case Participant6IMPORT_YEARYear Commission Case Reportednvarchar40
71YSVMA_B_VAR_RELVariants for Participant Relations6IMPORT_YEARYear Commission Case Reportednvarchar40
72YSVMA_CASCommission Case2IMPORT_YEARYear Commission Case Reportednvarchar40
73YSVMA_INVCommission Case Participants2IMPORT_YEARYear Commission Case Reportednvarchar40
74YSVMA_LINVariant Commissions2IMPORT_YEARYear Commission Case Reportednvarchar40
75YSVMA_OBJCommission Case Object Data2IMPORT_YEARYear Commission Case Reportednvarchar40
76YSVMA_OBJHISTChange History of Subobjects That Trigger Commission8IMPORT_YEARYear Commission Case Reportednvarchar40
77YSVMA_PARCommission Case Participation2IMPORT_YEARYear Commission Case Reportednvarchar40
78YSVMA_RCP_BUFFRCP: Buffer Table for RCP Processing3IMPORT_YEARYear Commission Case Reportednvarchar40
79YSVMA_RCP_CASERCP: Initial Commission Cases2IMPORT_YEARYear Commission Case Reportednvarchar40
80YSVMA_RCP_WLRCP: Worklist4IMPORT_YEARYear Commission Case Reportednvarchar40
81YSVMA_RELParticipant Relations in a Commission Participation2IMPORT_YEARYear Commission Case Reportednvarchar40
82YTEL01_ACTCommission Case Activities2IMPORT_YEARYear Commission Case Reportednvarchar40
83YTEL01_BDLRebundling Order for Triggering Subobjects2IMPORT_YEARYear Commission Case Reportednvarchar40
84YTEL01_B_VAR_ACTVariants for Commission Case Activities6IMPORT_YEARYear Commission Case Reportednvarchar40
85YTEL01_B_VAR_BDLVariants for Bundling6IMPORT_YEARYear Commission Case Reportednvarchar40
86YTEL01_B_VAR_CASVariants for Commission Case6IMPORT_YEARYear Commission Case Reportednvarchar40
87YTEL01_B_VAR_INVVariants for Commission Case Participants6IMPORT_YEARYear Commission Case Reportednvarchar40
88YTEL01_B_VAR_LINVariants for Alternative Commission6IMPORT_YEARYear Commission Case Reportednvarchar40
89YTEL01_B_VAR_OBJVariants for Commission Case Object Data41IMPORT_YEARYear Commission Case Reportednvarchar40
90YTEL01_B_VAR_PARVariants for Commission Case Participant6IMPORT_YEARYear Commission Case Reportednvarchar40
91YTEL01_B_VAR_RELVariants for Participant Relations6IMPORT_YEARYear Commission Case Reportednvarchar40
92YTEL01_CASCommission Case2IMPORT_YEARYear Commission Case Reportednvarchar40
93YTEL01_INVCommission Case Participants2IMPORT_YEARYear Commission Case Reportednvarchar40
94YTEL01_LINVariant Commissions2IMPORT_YEARYear Commission Case Reportednvarchar40
95YTEL01_OBJCommission Case Object Data2IMPORT_YEARYear Commission Case Reportednvarchar40
96YTEL01_OBJHISTChange History of Subobjects That Trigger Commission8IMPORT_YEARYear Commission Case Reportednvarchar40
97YTEL01_PARCommission Case Participation2IMPORT_YEARYear Commission Case Reportednvarchar40
98YTEL01_RELParticipant Relations in a Commission Participation2IMPORT_YEARYear Commission Case Reportednvarchar40
99YTEL05_ACTCommission Case Activities2IMPORT_YEARYear Commission Case Reportednvarchar40
100YTEL05_BDLRebundling Order for Triggering Subobjects2IMPORT_YEARYear Commission Case Reportednvarchar40
101YTEL05_B_VAR_ACTVariants for Commission Case Activities6IMPORT_YEARYear Commission Case Reportednvarchar40
102YTEL05_B_VAR_BDLVariants for Bundling6IMPORT_YEARYear Commission Case Reportednvarchar40
103YTEL05_B_VAR_CASVariants for Commission Case14IMPORT_YEARYear Commission Case Reportednvarchar40
104YTEL05_B_VAR_INVVariants for Commission Case Participants8IMPORT_YEARYear Commission Case Reportednvarchar40
105YTEL05_B_VAR_LINVariants for Alternative Commission6IMPORT_YEARYear Commission Case Reportednvarchar40
106YTEL05_B_VAR_OBJVariants for Commission Case Object Data39IMPORT_YEARYear Commission Case Reportednvarchar40
107YTEL05_B_VAR_PARVariants for Commission Case Participant6IMPORT_YEARYear Commission Case Reportednvarchar40
108YTEL05_B_VAR_RELVariants for Participant Relations6IMPORT_YEARYear Commission Case Reportednvarchar40
109YTEL05_CASCommission Case2IMPORT_YEARYear Commission Case Reportednvarchar40
110YTEL05_INVCommission Case Participants2IMPORT_YEARYear Commission Case Reportednvarchar40
111YTEL05_LINVariant Commissions2IMPORT_YEARYear Commission Case Reportednvarchar40
112YTEL05_OBJCommission Case Object Data2IMPORT_YEARYear Commission Case Reportednvarchar40
113YTEL05_OBJHISTChange History of Subobjects That Trigger Commission8IMPORT_YEARYear Commission Case Reportednvarchar40
114YTEL05_PARCommission Case Participation2IMPORT_YEARYear Commission Case Reportednvarchar40
115YTEL05_RCP_BUFFRCP: Buffer Table for RCP Processing3IMPORT_YEARYear Commission Case Reportednvarchar40
116YTEL05_RCP_CASERCP: Initial Commission Cases2IMPORT_YEARYear Commission Case Reportednvarchar40
117YTEL05_RCP_WLRCP: Worklist4IMPORT_YEARYear Commission Case Reportednvarchar40
118YTEL05_RELParticipant Relations in a Commission Participation2IMPORT_YEARYear Commission Case Reportednvarchar40
119ZICMAG_ACTCommission Case Activities2IMPORT_YEARYear Commission Case Reportednvarchar40
120ZICMAG_BDLRebundling Order for Triggering Subobjects2IMPORT_YEARYear Commission Case Reportednvarchar40
121ZICMAG_B_VAR_ACTVariants for Commission Case Activities6IMPORT_YEARYear Commission Case Reportednvarchar40
122ZICMAG_B_VAR_BDLVariants for Bundling6IMPORT_YEARYear Commission Case Reportednvarchar40
123ZICMAG_B_VAR_CASVariants for Commission Case6IMPORT_YEARYear Commission Case Reportednvarchar40
124ZICMAG_B_VAR_INVVariants for Commission Case Participants6IMPORT_YEARYear Commission Case Reportednvarchar40
125ZICMAG_B_VAR_LINVariants for Alternative Commission6IMPORT_YEARYear Commission Case Reportednvarchar40
126ZICMAG_B_VAR_OBJVariants for Commission Case Object Data9IMPORT_YEARYear Commission Case Reportednvarchar40
127ZICMAG_B_VAR_PARVariants for Commission Case Participant6IMPORT_YEARYear Commission Case Reportednvarchar40
128ZICMAG_B_VAR_RELVariants for Participant Relations6IMPORT_YEARYear Commission Case Reportednvarchar40
129ZICMAG_CASCommission Case2IMPORT_YEARYear Commission Case Reportednvarchar40
130ZICMAG_INVCommission Case Participants2IMPORT_YEARYear Commission Case Reportednvarchar40
131ZICMAG_LINVariant Commissions2IMPORT_YEARYear Commission Case Reportednvarchar40
132ZICMAG_OBJCommission Case Object Data2IMPORT_YEARYear Commission Case Reportednvarchar40
133ZICMAG_OBJHISTChange History of Subobjects That Trigger Commission8IMPORT_YEARYear Commission Case Reportednvarchar40
134ZICMAG_PARCommission Case Participation2IMPORT_YEARYear Commission Case Reportednvarchar40
135ZICMAG_RELParticipant Relations in a Commission Participation2IMPORT_YEARYear Commission Case Reportednvarchar40