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

30 columns | Print definition?ERP 6.0  | PAPH2

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1RA/0SD010MIItems for Class SD01 - Raw Data99PAPH2Prod.hierarchy01-2nvarchar100
2CE1PR22Périm. résultat IDES85PAPH2Hiérarchie de produits 01-2nvarchar100
3CE2PR22Périm. résultat IDES69PAPH2Hiérarchie de produits 01-2nvarchar100
4CE4PR22Périm. résultat IDES54PAPH2Hiérarchie de produits 01-2nvarchar100
5CE4PR22_ACCTPérim. résultat IDES55PAPH2Hiérarchie de produits 01-2nvarchar100
6CE4PR22_FLAGPérim. résultat IDES51PAPH2Flag : caract. imputée manuellement ou via TKEZUnvarchar10
7CE4PR22_KENCPérim. résultat IDES53PAPH2Hiérarchie de produits 01-2nvarchar100
TOPProfitability Analysis
8CE1IDEAOp. Concern BR World85PAPH2Prod.hierarchy01-2nvarchar100
9CE1IDESErgebnisbereich IDES85PAPH2Produkthierarchie2nvarchar100
10CE1INT1Ergebnisbereich IDES85PAPH2Produkthierarchie2nvarchar100
11CE1OC01Bike International71PAPH2Prod.hierarchy01-2nvarchar100
12CE2IDEAOp. Concern BR World69PAPH2Prod.hierarchy01-2nvarchar100
13CE2IDESErgebnisbereich IDES69PAPH2Produkthierarchie2nvarchar100
14CE2INT1Ergebnisbereich IDES69PAPH2Produkthierarchie2nvarchar100
15CE2OC01Bike International55PAPH2Prod.hierarchy01-2nvarchar100
16CE4IDEAOp. Concern BR World54PAPH2Prod.hierarchy01-2nvarchar100
17CE4IDEA_ACCTOp. Concern BR World55PAPH2Prod.hierarchy01-2nvarchar100
18CE4IDEA_FLAGOp. Concern BR World51PAPH2Flag: Characteristic Assigned Manually or Using TKEZUnvarchar10
19CE4IDEA_KENCOp. Concern BR World53PAPH2Prod.hierarchy01-2nvarchar100
20CE4IDESErgebnisbereich IDES54PAPH2Produkthierarchie2nvarchar100
21CE4IDES_ACCTErgebnisbereich IDES55PAPH2Produkthierarchie2nvarchar100
22CE4IDES_FLAGErgebnisbereich IDES51PAPH2Flag: Merkmal manuell oder über TKEZU kontiertnvarchar10
23CE4IDES_KENCErgebnisbereich IDES53PAPH2Produkthierarchie2nvarchar100
24CE4INT1Ergebnisbereich IDES54PAPH2Produkthierarchie2nvarchar100
25CE4INT1_ACCTErgebnisbereich IDES55PAPH2Produkthierarchie2nvarchar100
26CE4INT1_FLAGErgebnisbereich IDES51PAPH2Flag: Merkmal manuell oder über TKEZU kontiertnvarchar10
27CE4INT1_KENCErgebnisbereich IDES53PAPH2Produkthierarchie2nvarchar100
28CE4OC01Bike International40PAPH2Prod.hierarchy01-2nvarchar100
29CE4OC01_ACCTBike International41PAPH2Prod.hierarchy01-2nvarchar100
30CE4OC01_KENCBike International39PAPH2Prod.hierarchy01-2nvarchar100