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

36 columns | Print definition?ERP 6.0  | PAPH1

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1RA/0SD010MIItems for Class SD01 - Raw Data98PAPH1Prod.hierarchy01-1nvarchar50
2CE1PR22Périm. résultat IDES84PAPH1Hiérarchie de prod. 01-1nvarchar50
3CE2PR22Périm. résultat IDES68PAPH1Hiérarchie de prod. 01-1nvarchar50
4CE4PR22Périm. résultat IDES53PAPH1Hiérarchie de prod. 01-1nvarchar50
5CE4PR22_ACCTPérim. résultat IDES54PAPH1Hiérarchie de prod. 01-1nvarchar50
6CE4PR22_FLAGPérim. résultat IDES50PAPH1Flag : caract. imputée manuellement ou via TKEZUnvarchar10
7CE4PR22_KENCPérim. résultat IDES52PAPH1Hiérarchie de prod. 01-1nvarchar50
TOPProfitability Analysis
8CE1IDEAOp. Concern BR World84PAPH1Prod.hierarchy01-1nvarchar50
9CE1IDESErgebnisbereich IDES84PAPH1Produkthierarchie1nvarchar50
10CE1INT1Ergebnisbereich IDES84PAPH1Produkthierarchie1nvarchar50
11CE1OC01Bike International70PAPH1Prod.hierarchy01-1nvarchar50
12CE1S300Operating Concern IDES59PAPH1Prod.hierarchy01-1nvarchar50
13CE2IDEAOp. Concern BR World68PAPH1Prod.hierarchy01-1nvarchar50
14CE2IDESErgebnisbereich IDES68PAPH1Produkthierarchie1nvarchar50
15CE2INT1Ergebnisbereich IDES68PAPH1Produkthierarchie1nvarchar50
16CE2OC01Bike International54PAPH1Prod.hierarchy01-1nvarchar50
17CE2S300Operating Concern IDES43PAPH1Prod.hierarchy01-1nvarchar50
18CE4IDEAOp. Concern BR World53PAPH1Prod.hierarchy01-1nvarchar50
19CE4IDEA_ACCTOp. Concern BR World54PAPH1Prod.hierarchy01-1nvarchar50
20CE4IDEA_FLAGOp. Concern BR World50PAPH1Flag: Characteristic Assigned Manually or Using TKEZUnvarchar10
21CE4IDEA_KENCOp. Concern BR World52PAPH1Prod.hierarchy01-1nvarchar50
22CE4IDESErgebnisbereich IDES53PAPH1Produkthierarchie1nvarchar50
23CE4IDES_ACCTErgebnisbereich IDES54PAPH1Produkthierarchie1nvarchar50
24CE4IDES_FLAGErgebnisbereich IDES50PAPH1Flag: Merkmal manuell oder über TKEZU kontiertnvarchar10
25CE4IDES_KENCErgebnisbereich IDES52PAPH1Produkthierarchie1nvarchar50
26CE4INT1Ergebnisbereich IDES53PAPH1Produkthierarchie1nvarchar50
27CE4INT1_ACCTErgebnisbereich IDES54PAPH1Produkthierarchie1nvarchar50
28CE4INT1_FLAGErgebnisbereich IDES50PAPH1Flag: Merkmal manuell oder über TKEZU kontiertnvarchar10
29CE4INT1_KENCErgebnisbereich IDES52PAPH1Produkthierarchie1nvarchar50
30CE4OC01Bike International39PAPH1Prod.hierarchy01-1nvarchar50
31CE4OC01_ACCTBike International40PAPH1Prod.hierarchy01-1nvarchar50
32CE4OC01_KENCBike International38PAPH1Prod.hierarchy01-1nvarchar50
33CE4S300Operating Concern IDES28PAPH1Prod.hierarchy01-1nvarchar50
34CE4S300_ACCTOperating Concern IDES29PAPH1Prod.hierarchy01-1nvarchar50
35CE4S300_FLAGErgebnisbereich IDES Serv.Prov25PAPH1Flag: Merkmal manuell oder über TKEZU kontiertnvarchar10
36CE4S300_KENCOperating Concern IDES27PAPH1Prod.hierarchy01-1nvarchar50