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

95 columns | Print definition?ERP 6.0  | CAREA

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T7AEPBS14Salary Components3CAREACompensation areanvarchar20
2T7AEPBS14TSalary Component Text3CAREACompensation areanvarchar20
3T7AEPBS16Eligibility of Salary Components3CAREACompensation areanvarchar20
4T7QAW7ASalary Components2CAREACompensation areanvarchar20
5T7QAW7ATSalary Component Text3CAREACompensation areanvarchar20
6T7QAW7CEligibility of Salary Components2CAREACompensation areanvarchar20
7T7SAPBS14Salary Components2CAREACompensation areanvarchar20
8T7SAPBS14TSalary Component Text3CAREACompensation areanvarchar20
9T7SAPBS16Eligibility of Salary Components2CAREACompensation areanvarchar20
TOPArgentina
10T7ARM2(Dependents) additional data12CAREATelephone area codenvarchar40
TOPCompensation Administration
11PA0758HR Master Record: Infotype 0758 (Compensation Program)24CAREACompensation Areanvarchar20
12PA0759HR Master Record: Infotype 0759 (Compensation Process)24CAREACompensation Areanvarchar20
13PA0760HR Master Record: Infotype 0760 (Comp. Eligibility Override)24CAREACompensation Areanvarchar20
14T71ADM01Compensation Area2CAREACompensation Areanvarchar20
15T71ADM01TCompensation Area Text3CAREACompensation Areanvarchar20
16T71ADM03Compensation Plan Attributes2CAREACompensation Areanvarchar20
17T71ADM04Compensation Plan Payroll Data2CAREACompensation Areanvarchar20
18T71ADM05First Compensation Program Grouping2CAREACompensation Areanvarchar20
19T71ADM05TFirst Compensation Program Grouping Text3CAREACompensation Areanvarchar20
20T71ADM06Second Compensation Program Grouping2CAREACompensation Areanvarchar20
21T71ADM06TSecond Compensation Program Grouping Text3CAREACompensation Areanvarchar20
22T71ADM07Compensation Program2CAREACompensation Areanvarchar20
23T71ADM10Compensation Review Item Attributes2CAREACompensation Areanvarchar20
24T71ADM11Compensation Eligibility Rule Variant2CAREACompensation Areanvarchar20
25T71ADM11TCompensation Eligibility Rule Variant Text3CAREACompensation Areanvarchar20
26T71ADM12Compensation Eligibility Grouping2CAREACompensation Areanvarchar20
27T71ADM12TCompensation Eligibility Grouping Text3CAREACompensation Areanvarchar20
28T71ADM13Compensation Eligibility Rule2CAREACompensation Areanvarchar20
29T71ADM14Compensation Appraisal Rule2CAREACompensation Areanvarchar20
30T71ADM14TCompensation Appraisal Rule Text3CAREACompensation Areanvarchar20
31T71ADM15Compensation Guideline Variant2CAREACompensation Areanvarchar20
32T71ADM15TCompensation Guideline Variant Text3CAREACompensation Areanvarchar20
33T71ADM16Compensation Guideline Grouping2CAREACompensation Areanvarchar20
34T71ADM16TCompensation Guideline Grouping Text3CAREACompensation Areanvarchar20
35T71ADM17Compensation Guideline2CAREACompensation Areanvarchar20
36T71ADM18Compensation Guideline Proration Rule2CAREACompensation Areanvarchar20
37T71ADM18TCompensation Guideline Proration Rule Text3CAREACompensation Areanvarchar20
38T71ADM19Compensation Guideline Matrix2CAREACompensation Areanvarchar20
39T71ADM19TCompensation Guideline Matrix Text3CAREACompensation Areanvarchar20
40T71ADM20Compensation Matrix Dimension2CAREACompensation Areanvarchar20
41T71ADM20TCompensation Matrix Dimension Text3CAREACompensation Areanvarchar20
42T71ADM22Compensation Matrix Dimension Segment2CAREACompensation Areanvarchar20
43T71ADM22TCompensation Matrix Dimension Segment Text3CAREACompensation Areanvarchar20
44T71ADM23Compensation Matrix Values2CAREACompensation Areanvarchar20
TOPCompensation Management
45PA0380HR Master Data Record Infotype 0380 (Comp. Adjustment)24CAREACompensation areanvarchar20
46PA0381HR Master Record Infotype 0381 (Comp. Plan Eligibility)25CAREACompensation areanvarchar20
47PA0382HR Master Data Record Infotype 0382 (Award)25CAREACompensation areanvarchar20
48PA0383HR Master Data Record Infotype 0383 (Compensation Package)26CAREACompensation areanvarchar20
49PA0384HR Master Data Record Infotype 038425CAREACompensation areanvarchar20
50T71C01Fixed Compensation Components3CAREACompensation areanvarchar20
51T71C02Variable Compensation Components3CAREACompensation areanvarchar20
52T71C03Stock Components3CAREACompensation areanvarchar20
53T71C3Compensation Area2CAREACompensation areanvarchar20
54T71C3TCompensation Area Texts3CAREACompensation areanvarchar20
55T71C9To be deleted - no longer used!4CAREACompensation areanvarchar20
56T71CBCompensation Adjustment3CAREACompensation areanvarchar20
57T71CCTo be deleted - no longer used!3CAREACompensation areanvarchar20
58T71CDTo be deleted - no longer used!3CAREACompensation areanvarchar20
59T71E0Guidelines2CAREACompensation areanvarchar20
60T71E0RGuideline Variants2CAREACompensation areanvarchar20
61T71E0TGuideline Variant Texts3CAREACompensation areanvarchar20
62T71F0Wage Types for Compensation Adjustments2CAREACompensation areanvarchar20
63T71F1Wage Type Model for Compensation Adjustments2CAREACompensation areanvarchar20
64T71G0Compensation Matrix2CAREACompensation areanvarchar20
65T71G0TText Table for Compensation Matrices3CAREACompensation areanvarchar20
66T71GSSegment Table for Dimensions2CAREACompensation areanvarchar20
67T71GSTText Table for Dimension Segments3CAREACompensation areanvarchar20
68T71GVValue Table for Compensation Matrix2CAREACompensation areanvarchar20
69T71LB2Country-dependent award attributes2CAREACompensation areanvarchar20
70T71LV3Life event vesting2CAREACompensation areanvarchar20
TOPEnterprise Compensation Management
71T71ADM_EE_HISTCompensation Tracking for Employees13CAREACompensation Areanvarchar20
72T71ADM_PROC_ELIGCompensation Tracking: Eligibility Information5CAREACompensation Areanvarchar20
73T71ADM_SPENT_AMTCompensation Planning: Spent Amounts6CAREACompensation Areanvarchar20
TOPPayroll
74T7UA1656Infotype 1656 Fields: Legal properties (Ukraine)14CAREAArea Codenvarchar20
TOPPersonnel Administration
75T7GR01PGrouping for Personnel Area-Subarea4CAREAPersonnel Area-Subarea Grouping for Gross Payrollnvarchar20
76T7GR1APD1Customizing table for KAD and EMPLOYER DEPARTMENT2CAREAPersonnel Area-Subarea Grouping for Gross Payrollnvarchar20
77T7GR1APD2Customizing Table for SPECIALTY IKA3CAREAPersonnel Area-Subarea Grouping for Gross Payrollnvarchar20
78T7GR1APD3Customizing Table for ALL_DAYS and FULL_SCHD2CAREAPersonnel Area-Subarea Grouping for Gross Payrollnvarchar20
79T7GR1INSSocial Insurance Fund Agreement2CAREAPersonnel Area-Subarea Grouping for Gross Payrollnvarchar20
80T7GR2AVEHIncrement Collecting Time Period3CAREAPersonnel Area-Subarea Grouping for Gross Payrollnvarchar20
81T7GR2C1Personnel Area-Subarea Grouping for Gross Payroll2CAREAPersonnel Area-Subarea Grouping for Gross Payrollnvarchar20
82T7GR2C1TPersonnel Area-Subarea Grouping for Gross Payroll(Texts)3CAREAPersonnel Area-Subarea Grouping for Gross Payrollnvarchar20
83T7GR2OCStandard Payroll Elements for Off Cycles2CAREAPersonnel Area-Subarea Grouping for Gross Payrollnvarchar20
84T7GR2QUOQuota Elements2CAREAPersonnel Area-Subarea Grouping for Gross Payrollnvarchar20
85T7GR2STDPayroll Groupings & Standard Elements2CAREAPersonnel Area-Subarea Grouping for Gross Payrollnvarchar20
86T7GR4SUBCompany Subscribers2CAREAPersonnel Area-Subarea Grouping for Gross Payrollnvarchar20
87T7GR4SUBTCompany Subscribers (Text)3CAREAPersonnel Area-Subarea Grouping for Gross Payrollnvarchar20
TOPSouth Africa
88T5W7ASalary components2CAREACompensation areanvarchar20
89T5W7ATSalary component text3CAREACompensation areanvarchar20
90T5W7CEligibility of salary components2CAREACompensation areanvarchar20
91T5W7ESalary packaging categories2CAREACompensation areanvarchar20
92T5W7ETSalary packaging Categories2CAREACompensation areanvarchar20
93T5W7HSalary packaging: Categories of salary components2CAREACompensation areanvarchar20
94T5W7HTSalary packaging: Text table Categories3CAREACompensation areanvarchar20
95T5WITA88ITA88 Transaction Table23CAREAITA88 Cancellation Reasonnvarchar900