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

35 columns | Print definition?ERP 6.0  | BETR2

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1RA/0SD010COItems for Class SD01 - Raw Data15BETR2Amount in Second Parallel Local Currencydecimal232
2/1RA/0SD012COItems for Class SD01 - Processable15BETR2Amount in Second Parallel Local Currencydecimal232
3/1RA/0SD014COItems for Class SD01 - Processed15BETR2Amount in Second Parallel Local Currencydecimal232
4/1RA/0SD020COItems for Class SD02 - Raw Data15BETR2Amount in Second Parallel Local Currencydecimal232
5/1RA/0SD022COItems for Class SD02 - Processable15BETR2Amount in Second Parallel Local Currencydecimal232
6/1RA/0SD024COItems for Class SD02 - Processed15BETR2Amount in Second Parallel Local Currencydecimal232
7/1RA/0SD030COItems for Class SD03 - Raw Data15BETR2Amount in Second Parallel Local Currencydecimal232
8/1RA/0SD032COItems for Class SD03 - Processable15BETR2Amount in Second Parallel Local Currencydecimal232
9/1RA/0SD034COItems for Class SD03 - Processed15BETR2Amount in Second Parallel Local Currencydecimal232
10DFKKEPRTLog for Inconsistent FI-CA Documents25BETR2Amount in second parallel currency with +/- signdecimal132
11FARR_D_INVOICEInvoice Entries14BETR2Amount in Second Parallel Local Currencydecimal232
12FARR_D_POSTINGPosting table14BETR2Amount in Second Parallel Local Currencydecimal232
13P2RK_WTDTPayroll Results - Wage type processing information13BETR2HR Payroll: Amountdecimal152
14P2RR_ADDFPayresult: Additional Funds/SG22BETR2Amountdecimal92
TOPAustria
15PA0751HR Master Record: Infotype 0751 (Company Pension Plan AT)48BETR2Partial Amount for Payrolldecimal92
TOPCompany Pension Scheme Germany
16PA0263HR Master Record for Infotype 026334BETR2Minimum Grossdecimal92
17T5DVPDefinition of Identifiers for Default Values13BETR2Minimum Grossdecimal92
TOPContract Accounts Receivable and Payable
18DFKKDEFREV_POSLine Item Table (Event-Based Deferred Revenues)12BETR2Amount in second parallel currency with +/- signdecimal132
19DFKKMOPItems in contract account document43BETR2Amount in second parallel currency with +/- signdecimal132
20DFKKMOPKItems in contract account document22BETR2Amount in second parallel currency with +/- signdecimal132
21DFKKOPItems in contract account document43BETR2Amount in second parallel currency with +/- signdecimal132
22DFKKOPAADistribution Items with Account Assignment7BETR2Amount in second parallel currency with +/- signdecimal132
23DFKKOPKItems in contract account document22BETR2Amount in second parallel currency with +/- signdecimal132
24DFKKOP_REPOpen Items from FPO447BETR2Amount in second parallel currency with +/- signdecimal132
25DFKKRP3Returns: Manual Posting Specifications19BETR2Amount in second parallel currency with +/- signdecimal132
26DFKKRP3HReturns: History for Manual Posting Items15BETR2Amount in second parallel currency with +/- signdecimal132
27DFKKSUMPosting totals from FI-CA49BETR2Amount in second parallel currency with +/- signdecimal132
28DFKKZARepayment Request8BETR2Amount in second parallel currency with +/- signdecimal132
29FKKDEFREVTrigger Table for Deferred Revenue Postings9BETR2Amount in second parallel currency with +/- signdecimal132
TOPInvoicing
30DEABPSCustomer change table: Logical view of BB amounts38BETR2Amount in second parallel currency with +/- signdecimal132
31EABPS_CORRSub Budget Billing Plan for Correspondence Print27BETR2Amount in second parallel currency with +/- signdecimal132
TOPPatient Accounting
32TN22KIS-H: Copayment Amount per Ins. Provider/Ins. Provider Type9BETR2IS-H: Copayment Amountdecimal132
TOPPersonnel Administration
33PA0830HR master record for infotypes 083086BETR2Amountdecimal152
TOPSingapore
34PA0181HR Master Record: Infotype 0181 [Add. Funds] (SG)36BETR2Amountdecimal92
TOPSwitzerland
35T5C1MFamily-Related Bonuses8BETR2Appropriation 2 of bonusdecimal72