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

38 columns | Print definition?ERP 6.0  | BEKNZ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TKABELanguage-Dependent Values for Debit/Credit Indicator2BEKNZDebit/credit indicatornvarchar10
TOPAccounting Interface
2GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)222BEKNZDebit/credit indicatornvarchar10
3GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)222BEKNZDebit/credit indicatornvarchar10
TOPAlternative Valuation Run
4CKMLAVRDOCITLines for Cumulation Posting Document31BEKNZDebit/credit indicatornvarchar10
TOPCost Center Accounting
5COSPRCO Objekt: Enhancement to COSP for Dependency Planning12BEKNZDebit/credit indicatornvarchar10
TOPCost Object
6COEPBCO Object: Line Items Variance/Period-Based Results Analysis25BEKNZDebit/credit indicatornvarchar10
7COSBCO Object: Total Variances/Results Analyses12BEKNZDebit/credit indicatornvarchar10
TOPCosting
8COERSales Order Value Revenue21BEKNZDebit/credit indicatornvarchar10
TOPData Retention Tool
9TXW_S_COEPRetrieve COEP from archive16BEKNZDebit/credit indicatornvarchar10
TOPInformation System, iViews
10COOI_PIBW CO-OM: Commitment Management: Deleted Line Items22BEKNZDebit/credit indicatornvarchar10
TOPLocal Currency Changeover
11EWUCOKException table for TWAER conversion15BEKNZDebit/credit indicatornvarchar10
TOPLocalization
12VIXCFRBUDGETBudget Seasonality Data12BEKNZDebit/credit indicatornvarchar10
TOPOrders for Projects
13COSPPTransfer of the Order in the COSP Table to the Project13BEKNZDebit/credit indicatornvarchar10
14COSSPTransfer of the Order COSS Table to the Project13BEKNZDebit/credit indicatornvarchar10
TOPOverhead Cost Controlling
15COEJCO Object: Line Items (by Fiscal Year)179BEKNZDebit/credit indicatornvarchar10
16COEPCO Object: Line Items (by Period)29BEKNZDebit/credit indicatornvarchar10
17COKPCO Object: Control Data for Primary Planning12BEKNZDebit/credit indicatornvarchar10
18COKSCO Object: Control Data for Secondary Planning12BEKNZDebit/credit indicatornvarchar10
19COSPCO Object: Cost Totals for External Postings12BEKNZDebit/credit indicatornvarchar10
20COSSCO Object: Cost Totals for Internal Postings12BEKNZDebit/credit indicatornvarchar10
21COVP_DELTA_LOGLog of COVP Delta Queue for Error Analysis31BEKNZDebit/credit indicatornvarchar10
TOPOverhead Cost Orders
22COOICommitments Management: Line Items22BEKNZDebit/credit indicatornvarchar10
23COSBDCO Object: Total of variances/accruals, of which settled12BEKNZDebit/credit indicatornvarchar10
24COSPDCO Object: Settled Primary Cost Totals12BEKNZDebit/credit indicatornvarchar10
25COSSDCO Object: Settled Secondary Cost Totals12BEKNZDebit/credit indicatornvarchar10
TOPPegging, Grouping, and Distribution
26DIS_TOBJSDistribution: cost objects posted to per group13BEKNZDebit/credit indicatornvarchar10
27DIS_TOBJS_COSPDistribution: Objects distributed to per Group WBS (Cost)11BEKNZDebit/credit indicatornvarchar10
28DIS_TOBJS_COSSDistribution: Objects distributed to per Group WBS (Cost)11BEKNZDebit/credit indicatornvarchar10
TOPProfitability Analysis
29CECOEJCO-PA Account Based Line Items181BEKNZDebit/credit indicatornvarchar10
30CECOEPCO-PA Account Based Line Items31BEKNZDebit/credit indicatornvarchar10
TOPProfitability Analysis Basic Functions
31K840001Summarization level KT: 800 KK 01 KKROBJ 0000016BEKNZDebit/Credit Indicatornvarchar10
32K840003Summarization level KT: 800 KK 01 KKROBJ 0000024BEKNZDebit/Credit Indicatornvarchar10
33K840005Summarization level KT: 800 KK 01 KKROBJ 0000036BEKNZDebit/Credit Indicatornvarchar10
34K840007Summarization level KT: 800 KK 01 KKROBJ 0000044BEKNZDebit/Credit Indicatornvarchar10
35K840009Summarization level KT: 800 KK 01 KKROBJ 0000056BEKNZDebit/Credit Indicatornvarchar10
36K840011Summarization level KT: 800 KK 01 KKROBJ 0000064BEKNZDebit/Credit Indicatornvarchar10
TOPReal Estate Management
37IVBPLine Item (Settlement: Service Charge Collector) (Obsolete)8BEKNZDebit/credit indicatornvarchar10
TOPReuse Services for Country Development
38PA0652HR Master Record Infotype 065227BEKNZProcessing Indicatornvarchar120