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

107 columns | Print definition?ERP 6.0  | PART_POS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPIncentive and Commission Management ICM
1CACS00_ACTCommission Case Activities14PART_POSReference to a Participation in a Commission Casenvarchar40
2CACS00_B_VAR_ACTVariants for Commission Case Activities18PART_POSReference to a Participation in a Commission Casenvarchar40
3CACS00_B_VAR_INVVariants for Commission Case Participants9PART_POSPosition of Participation in a Commission Casenvarchar40
4CACS00_B_VAR_LINVariants for Alternative Commission29PART_POSParticipation Item in a Commission Case (Special Commission)nvarchar40
5CACS00_B_VAR_PARVariants for Commission Case Participant9PART_POSPosition of Participation in a Commission Casenvarchar40
6CACS00_B_VAR_RELVariants for Participant Relations9PART_POSPosition of Participation in a Commission Casenvarchar40
7CACS00_DOCACTCommission Document: Activities8PART_POSReference to a Participation in a Commission Casenvarchar40
8CACS00_DOCINVParticipant in Commission Document4PART_POSPosition of Participation in a Commission Casenvarchar40
9CACS00_DOCPARParticipation of Commission Document4PART_POSPosition of Participation in a Commission Casenvarchar40
10CACS00_DOCRECommission Document, Remuneration and Liability9PART_POSPosition of Participation in a Commission Casenvarchar40
11CACS00_DOCRELCommission Document: Relationships Between Participants4PART_POSPosition of Participation in a Commission Casenvarchar40
12CACS00_INVCommission Case Participants5PART_POSPosition of Participation in a Commission Casenvarchar40
13CACS00_LINVariant Commissions25PART_POSParticipation Item in a Commission Case (Special Commission)nvarchar40
14CACS00_PARCommission Case Participation5PART_POSPosition of Participation in a Commission Casenvarchar40
15CACS00_RELParticipant Relations in a Commission Participation5PART_POSPosition of Participation in a Commission Casenvarchar40
16CACS42_DOCSHACommission Document: Complex Distribution Ratios9PART_POSPosition of Participation in a Commission Casenvarchar40
17YCRM01_ACTCommission Case Activities14PART_POSReference to a Participation in a Commission Casenvarchar40
18YCRM01_B_VAR_ACTVariants for Commission Case Activities19PART_POSReference to a Participation in a Commission Casenvarchar40
19YCRM01_B_VAR_INVVariants for Commission Case Participants9PART_POSPosition of Participation in a Commission Casenvarchar40
20YCRM01_B_VAR_LINVariants for Alternative Commission29PART_POSParticipation Item in a Commission Case (Special Commission)nvarchar40
21YCRM01_B_VAR_PARVariants for Commission Case Participant9PART_POSPosition of Participation in a Commission Casenvarchar40
22YCRM01_B_VAR_RELVariants for Participant Relations9PART_POSPosition of Participation in a Commission Casenvarchar40
23YCRM01_DOCACTCommission Document: Activities8PART_POSReference to a Participation in a Commission Casenvarchar40
24YCRM01_DOCINVParticipant in Commission Document4PART_POSPosition of Participation in a Commission Casenvarchar40
25YCRM01_DOCPARParticipation of Commission Document4PART_POSPosition of Participation in a Commission Casenvarchar40
26YCRM01_DOCRECommission Document, Remuneration and Liability36PART_POSPosition of Participation in a Commission Casenvarchar40
27YCRM01_DOCRELCommission Document: Relationships Between Participants4PART_POSPosition of Participation in a Commission Casenvarchar40
28YCRM01_INVCommission Case Participants5PART_POSPosition of Participation in a Commission Casenvarchar40
29YCRM01_LINVariant Commissions25PART_POSParticipation Item in a Commission Case (Special Commission)nvarchar40
30YCRM01_PARCommission Case Participation5PART_POSPosition of Participation in a Commission Casenvarchar40
31YCRM01_RELParticipant Relations in a Commission Participation5PART_POSPosition of Participation in a Commission Casenvarchar40
32YHITEC_ACTCommission Case Activities14PART_POSReference to a Participation in a Commission Casenvarchar40
33YHITEC_B_VAR_ACTVariants for Commission Case Activities18PART_POSReference to a Participation in a Commission Casenvarchar40
34YHITEC_B_VAR_INVVariants for Commission Case Participants9PART_POSPosition of Participation in a Commission Casenvarchar40
35YHITEC_B_VAR_LINVariants for Alternative Commission29PART_POSParticipation Item in a Commission Case (Special Commission)nvarchar40
36YHITEC_B_VAR_PARVariants for Commission Case Participant9PART_POSPosition of Participation in a Commission Casenvarchar40
37YHITEC_B_VAR_RELVariants for Participant Relations9PART_POSPosition of Participation in a Commission Casenvarchar40
38YHITEC_DOCACTCommission Document: Activities8PART_POSReference to a Participation in a Commission Casenvarchar40
39YHITEC_DOCINVParticipant in Commission Document4PART_POSPosition of Participation in a Commission Casenvarchar40
40YHITEC_DOCPARParticipation of Commission Document4PART_POSPosition of Participation in a Commission Casenvarchar40
41YHITEC_DOCRECommission Document, Remuneration and Liability19PART_POSPosition of Participation in a Commission Casenvarchar40
42YHITEC_DOCRELCommission Document: Relationships Between Participants4PART_POSPosition of Participation in a Commission Casenvarchar40
43YHITEC_INVCommission Case Participants5PART_POSPosition of Participation in a Commission Casenvarchar40
44YHITEC_LINVariant Commissions25PART_POSParticipation Item in a Commission Case (Special Commission)nvarchar40
45YHITEC_PARCommission Case Participation5PART_POSPosition of Participation in a Commission Casenvarchar40
46YHITEC_RELParticipant Relations in a Commission Participation5PART_POSPosition of Participation in a Commission Casenvarchar40
47YSVMA_ACTCommission Case Activities14PART_POSReference to a Participation in a Commission Casenvarchar40
48YSVMA_B_VAR_ACTVariants for Commission Case Activities18PART_POSReference to a Participation in a Commission Casenvarchar40
49YSVMA_B_VAR_INVVariants for Commission Case Participants9PART_POSPosition of Participation in a Commission Casenvarchar40
50YSVMA_B_VAR_LINVariants for Alternative Commission29PART_POSParticipation Item in a Commission Case (Special Commission)nvarchar40
51YSVMA_B_VAR_PARVariants for Commission Case Participant9PART_POSPosition of Participation in a Commission Casenvarchar40
52YSVMA_B_VAR_RELVariants for Participant Relations9PART_POSPosition of Participation in a Commission Casenvarchar40
53YSVMA_DOCACTCommission Document: Activities8PART_POSReference to a Participation in a Commission Casenvarchar40
54YSVMA_DOCINVParticipant in Commission Document4PART_POSPosition of Participation in a Commission Casenvarchar40
55YSVMA_DOCPARParticipation of Commission Document4PART_POSPosition of Participation in a Commission Casenvarchar40
56YSVMA_DOCRECommission Document, Remuneration and Liability13PART_POSPosition of Participation in a Commission Casenvarchar40
57YSVMA_DOCRELCommission Document: Relationships Between Participants4PART_POSPosition of Participation in a Commission Casenvarchar40
58YSVMA_INVCommission Case Participants5PART_POSPosition of Participation in a Commission Casenvarchar40
59YSVMA_LINVariant Commissions25PART_POSParticipation Item in a Commission Case (Special Commission)nvarchar40
60YSVMA_PARCommission Case Participation5PART_POSPosition of Participation in a Commission Casenvarchar40
61YSVMA_RELParticipant Relations in a Commission Participation5PART_POSPosition of Participation in a Commission Casenvarchar40
62YTEL01_ACTCommission Case Activities14PART_POSReference to a Participation in a Commission Casenvarchar40
63YTEL01_B_VAR_ACTVariants for Commission Case Activities18PART_POSReference to a Participation in a Commission Casenvarchar40
64YTEL01_B_VAR_INVVariants for Commission Case Participants9PART_POSPosition of Participation in a Commission Casenvarchar40
65YTEL01_B_VAR_LINVariants for Alternative Commission29PART_POSParticipation Item in a Commission Case (Special Commission)nvarchar40
66YTEL01_B_VAR_PARVariants for Commission Case Participant9PART_POSPosition of Participation in a Commission Casenvarchar40
67YTEL01_B_VAR_RELVariants for Participant Relations9PART_POSPosition of Participation in a Commission Casenvarchar40
68YTEL01_DOCACTCommission Document: Activities8PART_POSReference to a Participation in a Commission Casenvarchar40
69YTEL01_DOCINVParticipant in Commission Document4PART_POSPosition of Participation in a Commission Casenvarchar40
70YTEL01_DOCPARParticipation of Commission Document4PART_POSPosition of Participation in a Commission Casenvarchar40
71YTEL01_DOCRECommission Document, Remuneration and Liability33PART_POSPosition of Participation in a Commission Casenvarchar40
72YTEL01_DOCRELCommission Document: Relationships Between Participants4PART_POSPosition of Participation in a Commission Casenvarchar40
73YTEL01_INVCommission Case Participants5PART_POSPosition of Participation in a Commission Casenvarchar40
74YTEL01_LINVariant Commissions25PART_POSParticipation Item in a Commission Case (Special Commission)nvarchar40
75YTEL01_PARCommission Case Participation5PART_POSPosition of Participation in a Commission Casenvarchar40
76YTEL01_RELParticipant Relations in a Commission Participation5PART_POSPosition of Participation in a Commission Casenvarchar40
77YTEL05_ACTCommission Case Activities14PART_POSReference to a Participation in a Commission Casenvarchar40
78YTEL05_B_VAR_ACTVariants for Commission Case Activities18PART_POSReference to a Participation in a Commission Casenvarchar40
79YTEL05_B_VAR_INVVariants for Commission Case Participants11PART_POSPosition of Participation in a Commission Casenvarchar40
80YTEL05_B_VAR_LINVariants for Alternative Commission29PART_POSParticipation Item in a Commission Case (Special Commission)nvarchar40
81YTEL05_B_VAR_PARVariants for Commission Case Participant9PART_POSPosition of Participation in a Commission Casenvarchar40
82YTEL05_B_VAR_RELVariants for Participant Relations9PART_POSPosition of Participation in a Commission Casenvarchar40
83YTEL05_DOCACTCommission Document: Activities8PART_POSReference to a Participation in a Commission Casenvarchar40
84YTEL05_DOCINVParticipant in Commission Document4PART_POSPosition of Participation in a Commission Casenvarchar40
85YTEL05_DOCPARParticipation of Commission Document4PART_POSPosition of Participation in a Commission Casenvarchar40
86YTEL05_DOCRECommission Document, Remuneration and Liability27PART_POSPosition of Participation in a Commission Casenvarchar40
87YTEL05_DOCRELCommission Document: Relationships Between Participants4PART_POSPosition of Participation in a Commission Casenvarchar40
88YTEL05_DOCSHACommission Document: Complex Distribution Ratios9PART_POSPosition of Participation in a Commission Casenvarchar40
89YTEL05_INVCommission Case Participants5PART_POSPosition of Participation in a Commission Casenvarchar40
90YTEL05_LINVariant Commissions25PART_POSParticipation Item in a Commission Case (Special Commission)nvarchar40
91YTEL05_PARCommission Case Participation5PART_POSPosition of Participation in a Commission Casenvarchar40
92YTEL05_RELParticipant Relations in a Commission Participation5PART_POSPosition of Participation in a Commission Casenvarchar40
93ZICMAG_ACTCommission Case Activities14PART_POSReference to a Participation in a Commission Casenvarchar40
94ZICMAG_B_VAR_ACTVariants for Commission Case Activities18PART_POSReference to a Participation in a Commission Casenvarchar40
95ZICMAG_B_VAR_INVVariants for Commission Case Participants9PART_POSPosition of Participation in a Commission Casenvarchar40
96ZICMAG_B_VAR_LINVariants for Alternative Commission29PART_POSParticipation Item in a Commission Case (Special Commission)nvarchar40
97ZICMAG_B_VAR_PARVariants for Commission Case Participant9PART_POSPosition of Participation in a Commission Casenvarchar40
98ZICMAG_B_VAR_RELVariants for Participant Relations9PART_POSPosition of Participation in a Commission Casenvarchar40
99ZICMAG_DOCACTCommission Document: Activities8PART_POSReference to a Participation in a Commission Casenvarchar40
100ZICMAG_DOCINVParticipant in Commission Document4PART_POSPosition of Participation in a Commission Casenvarchar40
101ZICMAG_DOCPARParticipation of Commission Document4PART_POSPosition of Participation in a Commission Casenvarchar40
102ZICMAG_DOCRECommission Document, Remuneration and Liability11PART_POSPosition of Participation in a Commission Casenvarchar40
103ZICMAG_DOCRELCommission Document: Relationships Between Participants4PART_POSPosition of Participation in a Commission Casenvarchar40
104ZICMAG_INVCommission Case Participants5PART_POSPosition of Participation in a Commission Casenvarchar40
105ZICMAG_LINVariant Commissions25PART_POSParticipation Item in a Commission Case (Special Commission)nvarchar40
106ZICMAG_PARCommission Case Participation5PART_POSPosition of Participation in a Commission Casenvarchar40
107ZICMAG_RELParticipant Relations in a Commission Participation5PART_POSPosition of Participation in a Commission Casenvarchar40