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

68 tablesERP 6.0 

Payroll :: Canada
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PA0066521HR Master data infotype 0066 - Canadian garnishment: orderCanada
2ERP EHP76.0PA0067521HR master data infotype 0067 - Canadian garnishment: debtCanada
3ERP EHP76.0PA0068301HR master data infotype 0068 - Canadian garnishment: adjustCanada
4ERP EHP76.0PA02211771HR Master Record: Infotype 0221 (Manual Checks)Canada
5ERP EHP76.0PCERE101Activities per Payroll ResultCanada
6ERP EHP76.0PCERH111History of Payroll Posting RunsCanada
7ERP EHP76.0PCERT71Payroll Posting RunsCanada
8ERP EHP76.0PCERV81Attributes for Posting RunsCanada
9ERP EHP76.0T5K0C131Absence BreakdownCanada
10ERP EHP76.0T5K0S51Sickness grouping for absence typesCanada
11ERP EHP76.0T5K6I81Year-end amendment wage-type selectionCanada
12ERP EHP76.0T5K8C111Transfer ext. payroll results into Canadian specific tablesCanada
13ERP EHP76.0T5K8D51Tax key data for transfer of old payroll resultsCanada
14ERP EHP76.0T5K8E131HR-CA: Transfer additional external payroll resultsCanada
15ERP EHP76.0T5KB061Definition of Registration Number, CanadaCanada
16ERP EHP76.0T5KB171Definition of Business Number, CanadaCanada
17ERP EHP76.0T5KB281Canadian tax reporting unitsCanada
18ERP EHP76.0T5KB371Registration Number Organizational assignment, CanadaCanada
19ERP EHP76.0T5KB481Account Number Organizational assignment, CanadaCanada
20ERP EHP76.0T5KB531Definition of Registration/Account Grouping, CanadaCanada
21ERP EHP76.0T5KB651Registration/Account Grouping texts, CanadaCanada
22ERP EHP76.0T5KBN51Business mapping for CPP & EI computationCanada
23ERP EHP76.0T5KG061Gross/net model characteristicsCanada
24ERP EHP76.0T5KG1101Special ruleCanada
25ERP EHP76.0T5KG241Description of special ruleCanada
26ERP EHP76.0T5KG391Special rule calculation schemeCanada
27ERP EHP76.0T5KG4131Non-exempt amount model characteristicsCanada
28ERP EHP76.0T5KG561Relationship to other debts model characteristicsCanada
29ERP EHP76.0T5KG631Default valuesCanada
30ERP EHP76.0T5KG9101Garnishee feeCanada
31ERP EHP76.0T5KLUP61Fields for tax information on magnetic mediaCanada
32ERP EHP76.0T5KQT31Tax claim codes QC - textsCanada
33ERP EHP76.0T5KR0172Record of Employment (ROE) HistoryCanada
34ERP EHP76.0T5KR121ROE serial number reference tableCanada
35ERP EHP76.0T5KR221ROE other money codesCanada
36ERP EHP76.0T5KR341ROE other money textsCanada
37ERP EHP76.0T5KRC71Link HR tax payees to wage types via tax attributesCanada
38ERP EHP76.0T5KSP141Short/long term disability planCanada
39ERP EHP76.0T5KT3111Fields of a tax formCanada
40ERP EHP76.0T5KTC91Wage Type Tax Classifications (Canada)Canada
41ERP EHP76.0T5KTE11Tax types for employeeCanada
42ERP EHP76.0T5KTR11Tax types EmployerCanada
43ERP EHP76.0T5KTS31Tax types descriptionCanada
44ERP EHP76.0T5KTT11Tax types CanadaCanada
45ERP EHP76.0T5KV1221Vacation pay: Accrual and PayoutCanada
46ERP EHP76.0T5KV271Vacation pay: Wage Types for Special EventsCanada
47ERP EHP76.0T5KV351Vacation pay: Accrual YearsCanada
48ERP EHP76.0T5KV451Vacation pay: Absence types without corresp. entitlementsCanada
49ERP EHP76.0T5KV551Vacation pay: Automatic PayoutsCanada
50ERP EHP76.0T5KVE201Include/exclude indicator for wage type processingCanada
51ERP EHP76.0T5KWA91Workers' Compensation accounts tableCanada
52ERP EHP76.0T5KWB71Classification groups assignment for WCBCanada
53ERP EHP76.0T5KWC21Classification groups for WCBCanada
54ERP EHP76.0T5KWR61Employee Grouping for workers compensationCanada
55ERP EHP76.0T5KWT41Classification groups for WCB - Text tableCanada
56ERP EHP76.0T5KYA61Year end reporting history tableCanada
57ERP EHP76.0T5KYH161Year end reporting History tableCanada
58ERP EHP76.0T5KYS141No longer usedCanada
59ERP EHP76.0T5U8C111Transfer external payroll results (USA)Canada
60ERP EHP76.0T5UBX_GTL_AWART81Processing group for absence typesCanada
61ERP EHP76.0T5UBX_GTL_SUBTY71Processing group definition for BeneficiariesCanada
62ERP EHP76.0T5UNC31North American Industry Classification System(NAICS) CodesCanada
63ERP EHP76.0T5UNT51North American Industry Classification System(NAICS) TextsCanada
64ERP EHP76.0T5URA71HR payee derived from wage types via ZIP codeCanada
65ERP EHP76.0T5URB81HR payee derived from wage types via org. assignmentCanada
66ERP EHP76.0T5URC71HR payee for taxes derived from wage types via tax attr.Canada
67ERP EHP76.0T5UTL81Tax CompanyCanada
Payroll :: Canada :: Reporting
ProductVersionTableColumnsIndexesDescriptionModule
68ERP EHP76.0T5KR4171Record of Employment (ROE) History for Concurrent EmploymentReporting