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

60 columns | Print definition?ERP 6.0  | KONST

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T5AGRProjection Rules (Income Report)9KONSTPayroll Parameter for Factor Determinationnvarchar50
2T5D1TSI Assessment Threshold7KONSTConstant Namenvarchar50
3T5FDSNCOTISDSN: contributions parameter setting21KONSTTarget valuenvarchar500
4T5FDSNCOTIS2DSN: contributions parameter setting26KONSTTarget valuenvarchar500
5T5NRERetirement Age (AOW Age)2KONSTPayroll constantnvarchar50
6T5W2VSouth Africa - Form Names3KONSTForm constantnvarchar50
7T703AIncentive Wages: Replaced by T703H7KONSTPayroll constantnvarchar50
TOPAustralia
8T5QLKLeave Liability Constants5KONSTPayroll constantnvarchar50
TOPB2A Business to Administration
9T50BKHR-B2A: Constant Table5KONSTHR-B2A: Constantnvarchar50
10T50BKTHR-B2A: Text to Constant Table6KONSTHR-B2A: Constantnvarchar50
11T50BSHR-B2A: Client-independent constants table4KONSTHR-B2A: Constantnvarchar50
TOPBasic Functions
12T060KFI constants2KONSTName of FI constantnvarchar100
13T060LFI constant name3KONSTName of FI constantnvarchar100
14T060MFI constant values6KONSTName of FI constantnvarchar100
TOPBrazil
15T7BRAIInflation adjustment3KONSTPayroll parameter for amountsnvarchar50
TOPCanada
16T5KB1Definition of Business Number, Canada7KONSTPayroll constantnvarchar50
17T5KYSNo longer used13KONSTPayroll constantnvarchar50
TOPClinical System
18N2DGAISTISH*MED : Steuerung Schnittstelle Datenexport10KONSTIS-H*MED: Sabit degernvarchar200
TOPCompany Pension Scheme Germany
19T5DC1Constants for Company Pension Scheme3KONSTConstant for Company Pension Schemenvarchar50
20T5DC2Texts for Constants for Company Pension Schemes4KONSTConstant for Company Pension Schemenvarchar50
21T5DCZImputation Rules for Company Pension Scheme10KONSTConstant for Imputationnvarchar50
TOPConstruction Industry
22T5DBJTexts for Construction Pay Constants3KONSTConstruction Pay Constantnvarchar50
23T5DBKConstruction Pay Constants2KONSTConstruction Pay Constantnvarchar50
24T5DBPData for Year-End Bonus (Construction Industry)14KONSTConstant for Year-End Bonusnvarchar50
TOPDenmark
25T5M8XInterface: PBS Constants as T511K Constants5KONSTPayroll constantnvarchar50
26T5MFBFA Statistics: Values for Validation1KONSTCharacter Field Length = 10nvarchar100
TOPFrance
27T5F1HChange contribution calculation base14KONSTConstant from table T511Knvarchar50
28T5F1KCalc. bases for exempt. of costs for spec. contracts (FR)11KONSTPayroll constantnvarchar50
TOPIndia
29T7INR3Constants related to HRA code3KONSTPayroll constantnvarchar50
30T7INR5Text for statutory constants related to housing2KONSTPayroll constantnvarchar50
TOPNon Profit Organizations
31T7UNPAD_DSLCDuty Station Home Leave Cycle4KONSTPayroll constantnvarchar50
32T7UNPAD_EG05NPO: EG Settings for Country4KONSTCountry Keynvarchar30
33T7UNPAD_EGAMTNPO: EG Entitlements4KONSTCountry Keynvarchar30
TOPPayroll
34T5H1VBérszámfejtési konstansok vállalatonként3KONSTBérszámfejtési konstansnvarchar50
35T5H1VTBérszámfejtési állandók megnevezése vállalatonként4KONSTBérszámfejtési konstansnvarchar50
36T5H2BYear-end (tax) certificates elements11KONSTConstant namenvarchar50
TOPPayroll General Parts
37T510HPayroll Parameters for Time Unit3KONSTPayroll parameter related to time unitnvarchar50
38T511KPayroll Parameters3KONSTPayroll constantnvarchar50
39T511PInternational Payroll Constants3KONSTPayroll parameter for amountsnvarchar50
40T511TDesignation of Payroll Constant Amounts4KONSTPayroll parameter for amountsnvarchar50
41T512KText for Payroll Constants Regarding Time Units4KONSTPayroll parameter related to time unitnvarchar50
42T512LPayroll Constant Designations4KONSTPayroll constantnvarchar50
TOPPersonnel Administration
43T510BAppraisal Constants8KONSTValuation constantdecimal52
TOPPublic Sector
44T5D7QModels for Control of Contribution10KONSTPayroll constantnvarchar50
45T5D7RModels for Controlling Vacation Bonus8KONSTPayroll constantnvarchar50
46T5DPBS07Special and Non-Recurring Payments: Constants3KONSTConstant for Special and Non-Recurring Paymentsnvarchar100
47T5DPBS08Spec. and Non-Rec. Payts, Fixed Amts for Each Pay Scale Grp4KONSTConstant for Special and Non-Recurring Paymentsnvarchar100
48T5DPBS0ESpec. and Non-Rec. Payments: Pay Scale-Dependent Percentages4KONSTConstant for Special and Non-Recurring Paymentsnvarchar100
TOPReporting
49P05_TTFMMapping: Tax Table - Function Module6KONSTPayroll constantnvarchar50
TOPReuse Services for Country Development
50T5DF4Control Statement Wage Types8KONSTPayroll constantnvarchar50
TOPSouth Africa
51T5W1KPension Funds and Medical Aid Schemes (RSA)23KONSTGap Insurance Constantnvarchar50
52T5W1NSocial insurance schemes10KONSTGap Insurance Constantnvarchar50
TOPSpain
53T5E92Deduction groups for garnishments7KONSTPayroll parameter for amountsnvarchar50
54T5EI3Employment tax control constants3KONSTControl constantnvarchar60
55T5EI4Employment tax amount constants3KONSTAmount constantnvarchar60
56T5EIIEmployment tax control constant texts4KONSTControl constantnvarchar60
57T5EIJTexts of unemployment tax amount constants4KONSTAmount constantnvarchar60
TOPTime Tickets
58T703HIncentive Wages: Parameters for Premium Formulas7KONSTPayroll constantnvarchar50
TOPTravel Expenses
59T706_CONSTPA parameters: Travel Management3KONSTPayroll Constantnvarchar50
60T706_CONSTTEXTNames of Accounting Constants for Travel Expenses4KONSTPayroll Constantnvarchar50