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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

64 columns | Print definition?ERP 6.0  | UPD_TIMESTAMP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1EHPRCD_EXIMDSAvailable Search Criteria10UPD_TIMESTAMPChanged Ondecimal150
TOPEnvironment, Health and Safety
2/TDAG/CPT_EXIMDSAvailable Search Criteria10UPD_TIMESTAMPChanged Ondecimal150
TOPIncentive and Commission Management ICM
3CACS00_DOCACTCommission Document: Activities9UPD_TIMESTAMPLast Change of Objectsnvarchar140
4CACS00_DOCDTComn: Detail Items for Remuneration Rows22UPD_TIMESTAMPLast Change of Objectsnvarchar140
5CACS00_DOCFI_HData Transfer: FI Documents (Header Data)13UPD_TIMESTAMPLast Change of Objectsnvarchar140
6CACS00_DOCFI_PData Transfer: FI Documents (Items)20UPD_TIMESTAMPLast Change of Objectsnvarchar140
7CACS00_DOCHDCommission Document Header56UPD_TIMESTAMPLast Change of Objectsnvarchar140
8CACS00_DOCINVParticipant in Commission Document13UPD_TIMESTAMPLast Change of Objectsnvarchar140
9CACS00_DOCOBJCommission Document: Object Data13UPD_TIMESTAMPLast Change of Objectsnvarchar140
10CACS00_DOCPARParticipation of Commission Document8UPD_TIMESTAMPLast Change of Objectsnvarchar140
11CACS00_DOCRECommission Document, Remuneration and Liability61UPD_TIMESTAMPLast Change of Objectsnvarchar140
12CACS00_DOCRELCommission Document: Relationships Between Participants13UPD_TIMESTAMPLast Change of Objectsnvarchar140
13CACS00_DOCSECommission Document, Settlement31UPD_TIMESTAMPLast Change of Objectsnvarchar140
14CACS00_DOCSEDTLine Item Detail Line12UPD_TIMESTAMPLast Change of Objectsnvarchar140
15CACS00_DOCVACommission Document, Valuation25UPD_TIMESTAMPLast Change of Objectsnvarchar140
16CACS42_DOCSHACommission Document: Complex Distribution Ratios11UPD_TIMESTAMPLast Change of Objectsnvarchar140
17CACSCD_DOCCD_HDSettlement to FS-CD: Reference Document Header7UPD_TIMESTAMPLast Change of Objectsnvarchar140
18CACSFA_DOCFA_HDSettlement to FI-CA: Reference Document Header7UPD_TIMESTAMPLast Change of Objectsnvarchar140
19CACSFI_DOCFI_HDSettlement to FI: Reference Document Header15UPD_TIMESTAMPLast Change of Objectsnvarchar140
20CACSHR_DOCHR_HDSettlement to PY: Reference Document Header8UPD_TIMESTAMPLast Change of Objectsnvarchar140
21CACS_CPD_REFData Reference for Same FS-ICM Reference Key7UPD_TIMESTAMPLast Change of Objectsnvarchar140
22CACS_STL_REF_HSettlement Document Reference - Header8UPD_TIMESTAMPLast Change of Objectsnvarchar140
23YCRM01_DOCACTCommission Document: Activities9UPD_TIMESTAMPLast Change of Objectsnvarchar140
24YCRM01_DOCDTComn: Detail Items for Remuneration Rows22UPD_TIMESTAMPLast Change of Objectsnvarchar140
25YCRM01_DOCFI_HData Transfer: FI Documents Header Data15UPD_TIMESTAMPLast Change of Objectsnvarchar140
26YCRM01_DOCFI_PData Transfer: FI Documents Item22UPD_TIMESTAMPLast Change of Objectsnvarchar140
27YCRM01_DOCHDCommission Document Header56UPD_TIMESTAMPLast Change of Objectsnvarchar140
28YCRM01_DOCINVParticipant in Commission Document13UPD_TIMESTAMPLast Change of Objectsnvarchar140
29YCRM01_DOCOBJCommission Document: Object Data13UPD_TIMESTAMPLast Change of Objectsnvarchar140
30YCRM01_DOCPARParticipation of Commission Document8UPD_TIMESTAMPLast Change of Objectsnvarchar140
31YCRM01_DOCRECommission Document, Remuneration and Liability99UPD_TIMESTAMPLast Change of Objectsnvarchar140
32YCRM01_DOCRELCommission Document: Relationships Between Participants13UPD_TIMESTAMPLast Change of Objectsnvarchar140
33YCRM01_DOCSECommission Document: Due Dates31UPD_TIMESTAMPLast Change of Objectsnvarchar140
34YCRM01_DOCSEDTDue Date Details12UPD_TIMESTAMPLast Change of Objectsnvarchar140
35YCRM01_DOCVACommission Document, Valuation53UPD_TIMESTAMPLast Change of Objectsnvarchar140
36YSVMA_DOCACTCommission Document: Activities9UPD_TIMESTAMPLast Change of Objectsnvarchar140
37YSVMA_DOCDTComn: Detail Items for Remuneration Rows22UPD_TIMESTAMPLast Change of Objectsnvarchar140
38YSVMA_DOCFI_HData Transfer: FI Documents (Header Data)13UPD_TIMESTAMPLast Change of Objectsnvarchar140
39YSVMA_DOCFI_PData Transfer: FI Documents (Items)20UPD_TIMESTAMPLast Change of Objectsnvarchar140
40YSVMA_DOCHDCommission Document Header64UPD_TIMESTAMPLast Change of Objectsnvarchar140
41YSVMA_DOCINVParticipant in Commission Document13UPD_TIMESTAMPLast Change of Objectsnvarchar140
42YSVMA_DOCOBJCommission Document: Object Data25UPD_TIMESTAMPLast Change of Objectsnvarchar140
43YSVMA_DOCPARParticipation of Commission Document8UPD_TIMESTAMPLast Change of Objectsnvarchar140
44YSVMA_DOCRECommission Document, Remuneration and Liability76UPD_TIMESTAMPLast Change of Objectsnvarchar140
45YSVMA_DOCRELCommission Document: Relationships Between Participants13UPD_TIMESTAMPLast Change of Objectsnvarchar140
46YSVMA_DOCSECommission Document: Due Dates31UPD_TIMESTAMPLast Change of Objectsnvarchar140
47YSVMA_DOCSEDTDue Date Details12UPD_TIMESTAMPLast Change of Objectsnvarchar140
48YSVMA_DOCVACommission Document, Valuation30UPD_TIMESTAMPLast Change of Objectsnvarchar140
49YTEL05_DOCACTCommission Document: Activities9UPD_TIMESTAMPLast Change of Objectsnvarchar140
50YTEL05_DOCDTComn: Detail Items for Remuneration Rows22UPD_TIMESTAMPLast Change of Objectsnvarchar140
51YTEL05_DOCFI_HData Transfer: FI Documents (Header Data)13UPD_TIMESTAMPLast Change of Objectsnvarchar140
52YTEL05_DOCFI_PData Transfer: FI Documents (Items)20UPD_TIMESTAMPLast Change of Objectsnvarchar140
53YTEL05_DOCHDCommission Document Header64UPD_TIMESTAMPLast Change of Objectsnvarchar140
54YTEL05_DOCINVParticipant in Commission Document15UPD_TIMESTAMPLast Change of Objectsnvarchar140
55YTEL05_DOCOBJCommission Document: Object Data13UPD_TIMESTAMPLast Change of Objectsnvarchar140
56YTEL05_DOCPARParticipation of Commission Document8UPD_TIMESTAMPLast Change of Objectsnvarchar140
57YTEL05_DOCRECommission Document, Remuneration and Liability90UPD_TIMESTAMPLast Change of Objectsnvarchar140
58YTEL05_DOCRELCommission Document: Relationships Between Participants13UPD_TIMESTAMPLast Change of Objectsnvarchar140
59YTEL05_DOCSECommission Document: Due Dates37UPD_TIMESTAMPLast Change of Objectsnvarchar140
60YTEL05_DOCSEDTDue Date Details12UPD_TIMESTAMPLast Change of Objectsnvarchar140
61YTEL05_DOCSHACommission Document: Complex Distribution Ratios11UPD_TIMESTAMPLast Change of Objectsnvarchar140
62YTEL05_DOCVACommission Document, Valuation40UPD_TIMESTAMPLast Change of Objectsnvarchar140
TOPNetWeaver Enterprise Search
63ESH_QL_ST_EXCLSearchterm Exclusions Table7UPD_TIMESTAMPTimestamp (Last Update)decimal217
64ESH_QL_ST_STATSearchterm Statistics Table for Indexing of Statistics Data11UPD_TIMESTAMPTimestamp (Last Update)decimal217