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

77 columns | Print definition?ERP 6.0  | PERBL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CE2PR22Périm. résultat IDES8PERBLExercice/bloc de périodesnvarchar70
2CE3PR22Périm. résultat IDES7PERBLExercice/bloc de périodesnvarchar70
3CNVTDMS_05_CECollected Header Object Numbers for TDMS_Time-CE Tables5PERBLPERBL für TDTIMnvarchar70
4CNVTDMS_05_CE1Collected Header Object Numbers for TDMS_Time-CE Tables6PERBLPERBL für TDTIMnvarchar70
5CNVTDMS_05_CE3Collected Header Object Numbers for TDMS_Time-CE Tables8PERBLPERBL für TDTIMnvarchar70
6CNVTDMS_05_CE3XCollected Header Object Numbers for TDMS_Time-CE Tables7PERBLPERBL für TDTIMnvarchar70
7CNVTDMS_05_CE_3Collected Header Object Numbers for TDMS_Time-CE Tables5PERBLPERBL für TDTIMnvarchar70
TOPAccounting
8RPSCOProject info database: Costs, revenues, finances13PERBLPeriod blocknvarchar30
9RPSQTProject info database: quantities12PERBLPeriod blocknvarchar30
TOPCost Center Accounting
10COSPRCO Objekt: Enhancement to COSP for Dependency Planning14PERBLPeriod blocknvarchar30
TOPCost Object
11COSBCO Object: Total Variances/Results Analyses15PERBLPeriod blocknvarchar30
12PZPPProduction Measuring Points: Period Values6PERBLPeriod blocknvarchar30
TOPCosting
13COERSales Order Value Revenue11PERBLPeriod blocknvarchar30
TOPFunds Management
14BPDPPeriod Values Entry Document12PERBLPeriod blocknvarchar30
15BPEPLine Item Period Values Controlling Obj.4PERBLPeriod blocknvarchar30
16BPPETotals Record for Period Values Controlling Obj.15PERBLPeriod blocknvarchar30
17FMBEFI-FM Cash Levels5PERBLPeriod blocknvarchar30
18FMCOPICO-FM: Plan Data Transfer - Annual/Overall Values16PERBLPeriod blocknvarchar30
19FMSUFI-FM Totals Records5PERBLPeriod blocknvarchar30
TOPLocal Currency Changeover
20EWUCOSUMBalances for settled CO objects5PERBLPeriod blocknvarchar30
TOPLocalization
21VIXCFRBUDGETBudget Seasonality Data14PERBLPeriod blocknvarchar30
TOPMaintenance History
22/OLC/PMCO_OPOLC: PMCO for operations9PERBLPeriod blocknvarchar30
23PMCOCost structure of maintenance order9PERBLPeriod blocknvarchar30
24PMCO_OPCost structure of maintenance order9PERBLPeriod blocknvarchar30
TOPMaintenance Orders
25PMCOQTQuantity structure for the maintenance order9PERBLPeriod blocknvarchar30
26PMCOQT_OPQuantity structure for the maintenance order9PERBLPeriod blocknvarchar30
TOPOrders for Projects
27COSPPTransfer of the Order in the COSP Table to the Project15PERBLPeriod blocknvarchar30
28COSSPTransfer of the Order COSS Table to the Project15PERBLPeriod blocknvarchar30
29FMSPCopy FMSU table order to project5PERBLPeriod blocknvarchar30
TOPOverhead Cost Controlling
30COEJCO Object: Line Items (by Fiscal Year)5PERBLPeriod blocknvarchar30
31COEJLCO Object: Line Items for Activity Types (by Fiscal Year)5PERBLPeriod blocknvarchar30
32COEJRCO Object: Line Items for Stat. Key Figures (by Fiscal Year)5PERBLPeriod blocknvarchar30
33COEJTCO Object: Line Items for Prices (by Fiscal Year)5PERBLPeriod blocknvarchar30
34COSLCO Object: Activity Type Totals8PERBLPeriod blocknvarchar30
35COSPCO Object: Cost Totals for External Postings14PERBLPeriod blocknvarchar30
36COSRCO Object: Statistical Key Figure Totals10PERBLPeriod blocknvarchar30
37COSSCO Object: Cost Totals for Internal Postings14PERBLPeriod blocknvarchar30
38COSTCO Object: Price Totals8PERBLPeriod blocknvarchar30
39KAPSCO Period Locks6PERBLPeriod blocknvarchar30
TOPOverhead Cost Orders
40COSLDCO Object: Activity Type Totals - of Which Settled8PERBLPeriod blocknvarchar30
TOPPegging, Grouping, and Distribution
41DIS_TOBJS_COSPDistribution: Objects distributed to per Group WBS (Cost)13PERBLPeriod blocknvarchar30
42DIS_TOBJS_COSSDistribution: Objects distributed to per Group WBS (Cost)13PERBLPeriod blocknvarchar30
43DIS_TOBJS_FMSUDistribution: Objects distributed to per Group WBS (Cash)7PERBLPeriod blocknvarchar30
TOPPlant Maintenance
44MCB_BUDMCB Retraction data for Budget check7PERBLPeriod blocknvarchar30
TOPProduct Cost Planning
45CKIPUnit Costing: Period Costs Line Item11PERBLPeriod blocknvarchar30
TOPProfitability Analysis
46CE285008PERBLFiscal year/period blocknvarchar70
47CE2BGISErgebnisbereich für8PERBLGeschäftsjahr/Periodenblocknvarchar70
48CE2E_B1Model Bank8PERBLFiscal year/period blocknvarchar70
49CE2IDEAOp. Concern BR World8PERBLFiscal year/period blocknvarchar70
50CE2IDEBErgebnisbereich IDES8PERBLGeschäftsjahr/Periodenblocknvarchar70
51CE2IDESErgebnisbereich IDES8PERBLGeschäftsjahr/Periodenblocknvarchar70
52CE2INT1Ergebnisbereich IDES8PERBLGeschäftsjahr/Periodenblocknvarchar70
53CE2OC01Bike International8PERBLFiscal year/period blocknvarchar70
54CE2R300Operating Concern IDES8PERBLFiscal year/period blocknvarchar70
55CE2S001Sample operating concern8PERBLFiscal year/period blocknvarchar70
56CE2S300Operating Concern IDES8PERBLFiscal year/period blocknvarchar70
57CE2S_ALAirline Route Profit8PERBLFiscal year/period blocknvarchar70
58CE2S_CPTemplate for Consumer Goods Industry8PERBLFiscal year/period blocknvarchar70
59CE2S_GOQuickstart Template8PERBLFiscal year/period blocknvarchar70
60CE385007PERBLFiscal year/period blocknvarchar70
61CE3BGISErgebnisbereich für7PERBLGeschäftsjahr/Periodenblocknvarchar70
62CE3E_B1Model Bank7PERBLFiscal year/period blocknvarchar70
63CE3IDEAOp. Concern BR World7PERBLFiscal year/period blocknvarchar70
64CE3IDEBErgebnisbereich IDES7PERBLGeschäftsjahr/Periodenblocknvarchar70
65CE3IDESErgebnisbereich IDES7PERBLGeschäftsjahr/Periodenblocknvarchar70
66CE3INT1Ergebnisbereich IDES7PERBLGeschäftsjahr/Periodenblocknvarchar70
67CE3OC01Bike International7PERBLFiscal year/period blocknvarchar70
68CE3R300Operating Concern IDES7PERBLFiscal year/period blocknvarchar70
69CE3S001Segment level (CO-PA)7PERBLFiscal year/period blocknvarchar70
70CE3S300Operating Concern IDES7PERBLFiscal year/period blocknvarchar70
71CE3S_ALAirline Route Profit7PERBLFiscal year/period blocknvarchar70
72CE3S_CPTemplate for Consumer Goods Industry7PERBLFiscal year/period blocknvarchar70
73CE3S_GOQuickstart Template7PERBLFiscal year/period blocknvarchar70
74CECOEJCO-PA Account Based Line Items5PERBLPeriod blocknvarchar30
75TKEHDB_CE2_ERRHANA CO-PA Integration: CE2 Error with HANA Replication9PERBLFiscal year/period blocknvarchar70
TOPSimulation
76VSRPSCO_CNVersion: Cumulation table for project reporting14PERBLPeriod blocknvarchar30
TOPSingle Transaction Costing
77JBFTPDOCNSAP Banking: document management table for FTP4PERBLFiscal year/period blocknvarchar70