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

50 columns | Print definition?ERP 6.0  | PLIKZ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CE1PR22Périm. résultat IDES41PLIKZCode budget/réelnvarchar10
2CE3PR22Périm. résultat IDES5PLIKZCode budget/réelnvarchar10
3CNVTDMS_05_CE3Collected Header Object Numbers for TDMS_Time-CE Tables6PLIKZPLIKZnvarchar10
4CNVTDMS_05_CE3XCollected Header Object Numbers for TDMS_Time-CE Tables5PLIKZPLIKZnvarchar10
5T258ADetermining the costing sheet for condition access3PLIKZPlan/Actual Indicatornvarchar10
6T258FCO-PA access control for Product Costing3PLIKZPlan/Actual Indicatornvarchar10
TOPBusiness Accounting
7URBWLRealigner: DataSources11PLIKZnvarchar10
TOPProfitability Analysis
8CE1850041PLIKZPlan/Actual Indicatornvarchar10
9CE1BGISErgebnisbereich für41PLIKZPlan-/Istkennzeichennvarchar10
10CE1E_B1Model Bank41PLIKZPlan/Actual Indicatornvarchar10
11CE1IDEAOp. Concern BR World41PLIKZPlan/Actual Indicatornvarchar10
12CE1IDEBErgebnisbereich IDES41PLIKZPlan-/Istkennzeichennvarchar10
13CE1IDESErgebnisbereich IDES41PLIKZPlan-/Istkennzeichennvarchar10
14CE1INT1Ergebnisbereich IDES41PLIKZPlan-/Istkennzeichennvarchar10
15CE1OC01Bike International41PLIKZPlan/Actual Indicatornvarchar10
16CE1R300Operating Concern IDES41PLIKZPlan/Actual Indicatornvarchar10
17CE1S001Sample operating concern41PLIKZPlan/Actual Indicatornvarchar10
18CE1S300Operating Concern IDES41PLIKZPlan/Actual Indicatornvarchar10
19CE1S_ALAirline Route Profit41PLIKZPlan/Actual Indicatornvarchar10
20CE1S_CPTemplate for Consumer Goods Industry41PLIKZPlan/Actual Indicatornvarchar10
21CE1S_GOQuickstart Template41PLIKZPlan/Actual Indicatornvarchar10
22CE385005PLIKZPlan/Actual Indicatornvarchar10
23CE3BGISErgebnisbereich für5PLIKZPlan-/Istkennzeichennvarchar10
24CE3E_B1Model Bank5PLIKZPlan/Actual Indicatornvarchar10
25CE3IDEAOp. Concern BR World5PLIKZPlan/Actual Indicatornvarchar10
26CE3IDEBErgebnisbereich IDES5PLIKZPlan-/Istkennzeichennvarchar10
27CE3IDESErgebnisbereich IDES5PLIKZPlan-/Istkennzeichennvarchar10
28CE3INT1Ergebnisbereich IDES5PLIKZPlan-/Istkennzeichennvarchar10
29CE3OC01Bike International5PLIKZPlan/Actual Indicatornvarchar10
30CE3R300Operating Concern IDES5PLIKZPlan/Actual Indicatornvarchar10
31CE3S001Segment level (CO-PA)5PLIKZPlan/Actual Indicatornvarchar10
32CE3S300Operating Concern IDES5PLIKZPlan/Actual Indicatornvarchar10
33CE3S_ALAirline Route Profit5PLIKZPlan/Actual Indicatornvarchar10
34CE3S_CPTemplate for Consumer Goods Industry5PLIKZPlan/Actual Indicatornvarchar10
35CE3S_GOQuickstart Template5PLIKZPlan/Actual Indicatornvarchar10
36CEALE01CO-PA Distribution: Line Item Reference for Distribution6PLIKZPlan/Actual Indicatornvarchar10
37RKE_POST_LOGLog: Post Directly to CO-PA7PLIKZPlan/Actual Indicatornvarchar10
38TKEBWLCO-PA Connection to SAP BW: InfoSources11PLIKZnvarchar10
39TKEPPLMEPARDPlanning Parameters - Reference Data12PLIKZPlan/Actual Indicatornvarchar10
40TKEVVR1Roll-up to summarization operating concerns3PLIKZPlan/Actual Indicatornvarchar10
41TKE_DIST_EXECDocument Numbers in CO-PA Distribution15PLIKZPlan/Actual Indicatornvarchar10
TOPProfitability Analysis Basic Functions
42K810001Verdichtungsebene KT: 800 KE 01 CE1IDEA 0003106PLIKZPlan-/Istkennzeichennvarchar10
43K810003Verdichtungsebene KT: 800 KE 01 CE1IDEA 00031110PLIKZPlan-/Istkennzeichennvarchar10
44K810005Verdichtungsebene KT: 800 KE 01 CE1IDEA 0003138PLIKZPlan-/Istkennzeichennvarchar10
45K810007Verdichtungsebene KT: 800 KE 01 CE1IDEA 0003149PLIKZPlan-/Istkennzeichennvarchar10
TOPSales Plan
46LISAKTBackground Planning Activities15PLIKZPlan/Actual Indicatornvarchar10
47LISCOPAKKey Figures Allocation Flexible Planning - CO-PA4PLIKZPlan/Actual Indicatornvarchar10
48LISCOPAZAssignment of info structure to operating concern3PLIKZPlan/Actual Indicatornvarchar10
TOPTools
49TKEBWLREQuery Data Transfer: Administration10PLIKZPlan/Actual Indicatornvarchar10
TOPTransaction Data Pool
50JBDVTLD_POSVariable Transaction: Ledger Item10PLIKZPlan/Actual Indicatornvarchar10