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

145 tablesERP 6.0 

Personnel Management :: Compensation Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0HRP1005332DB Table for Infotype 1005 (Planned Compensation)Compensation Management
2ERP EHP76.0HRP1050202DB Table for Infotype 1050 (Job Evaluation Results)Compensation Management
3ERP EHP76.0HRP1051232DB Table for Infotype 1051 (Survey Results)Compensation Management
4ERP EHP76.0PA0380821HR Master Data Record Infotype 0380 (Comp. Adjustment)Compensation Management
5ERP EHP76.0PA0381261HR Master Record Infotype 0381 (Comp. Plan Eligibility)Compensation Management
6ERP EHP76.0PA0382551HR Master Data Record Infotype 0382 (Award)Compensation Management
7ERP EHP76.0PA0383261HR Master Data Record Infotype 0383 (Compensation Package)Compensation Management
8ERP EHP76.0PA0384251HR Master Data Record Infotype 0384Compensation Management
9ERP EHP76.0PA0395321HR Master Record: Infotype 0395 (External Org.Assignment)Compensation Management
10ERP EHP76.0PA0396281HR Master Record: Infotype 0396 (Expatriate Attributes)Compensation Management
11ERP EHP76.0PB0396281HR Master Record: Infotype 0396 (Expatriate Attributes)Compensation Management
12ERP EHP76.0T504S101To be deleted - no longer used!Compensation Management
13ERP EHP76.0T504T81To be deleted - no longer used!Compensation Management
14ERP EHP76.0T504U91To be deleted - no longer used!Compensation Management
15ERP EHP76.0T504V91To be deleted - no longer used!Compensation Management
16ERP EHP76.0T504W91To be deleted - no longer used!Compensation Management
17ERP EHP76.0T504X81To be deleted - no longer used!Compensation Management
18ERP EHP76.0T504Y81To be deleted - no longer used!Compensation Management
19ERP EHP76.0T504Z81To be deleted - no longer used!Compensation Management
20ERP EHP76.0T50X171Type of ExpatriateCompensation Management
21ERP EHP76.0T50X251Type of Expatriate TextCompensation Management
22ERP EHP76.0T510D181Dynamic Standard Pay IncreaseCompensation Management
23ERP EHP76.0T510R161Pay Scale ReclassificationCompensation Management
24ERP EHP76.0T510_PSRCL181Pay scale reclassificationCompensation Management
25ERP EHP76.0T510_PSRCL_FV11Table of Filter Values for the BAdI for Pay Scale Reclass.Compensation Management
26ERP EHP76.0T5EMUPROT121Log table for currency translation EMUCompensation Management
27ERP EHP76.0T710111Pay Grade LevelsCompensation Management
28ERP EHP76.0T710A171Pay GradeCompensation Management
29ERP EHP76.0T710F21Units of TimeCompensation Management
30ERP EHP76.0T710FT41Texts for Units of TimeCompensation Management
31ERP EHP76.0T710G31Evaluation GroupCompensation Management
32ERP EHP76.0T710GT51Valuation Type TextCompensation Management
33ERP EHP76.0T710S101Survey DataCompensation Management
34ERP EHP76.0T710ST51Survey TextsCompensation Management
35ERP EHP76.0T71BUS11Data Source for Budget DeterminationCompensation Management
36ERP EHP76.0T71BUST31Data Source for Budget Determination: TextCompensation Management
37ERP EHP76.0T71C031Compensation ComponentCompensation Management
38ERP EHP76.0T71C0171Fixed Compensation ComponentsCompensation Management
39ERP EHP76.0T71C0281Variable Compensation ComponentsCompensation Management
40ERP EHP76.0T71C0391Stock ComponentsCompensation Management
41ERP EHP76.0T71C0T41Compensation Component Type TextsCompensation Management
42ERP EHP76.0T71C121Compensation GroupCompensation Management
43ERP EHP76.0T71C1T41Compensation Group TextsCompensation Management
44ERP EHP76.0T71C231Compensation PackageCompensation Management
45ERP EHP76.0T71C331Compensation AreaCompensation Management
46ERP EHP76.0T71C3T41Compensation Area TextsCompensation Management
47ERP EHP76.0T71C471Planning PeriodCompensation Management
48ERP EHP76.0T71C5271Eligibility Rule for CompensationCompensation Management
49ERP EHP76.0T71C5R21Compensation Eligibility Rule VariantCompensation Management
50ERP EHP76.0T71C5T41Compensation Eligibility Rule TextsCompensation Management
51ERP EHP76.0T71C621Compensation Eligibility GroupCompensation Management
52ERP EHP76.0T71C6T41Compensation Eligibility Group TextsCompensation Management
53ERP EHP76.0T71C751Compensation Adjustment DetailsCompensation Management
54ERP EHP76.0T71C831Compensation Adjustment ReasonCompensation Management
55ERP EHP76.0T71C8T41Compensation Adjustment Reason TextCompensation Management
56ERP EHP76.0T71C951To be deleted - no longer used!Compensation Management
57ERP EHP76.0T71CA61Compensation Adjustment TypeCompensation Management
58ERP EHP76.0T71CAT41Compensation Adjustment Type TextsCompensation Management
59ERP EHP76.0T71CB191Compensation AdjustmentCompensation Management
60ERP EHP76.0T71CC181To be deleted - no longer used!Compensation Management
61ERP EHP76.0T71CD151To be deleted - no longer used!Compensation Management
62ERP EHP76.0T71D1101Pay Grade RuleCompensation Management
63ERP EHP76.0T71D1R21Pay Grade Rule VariantCompensation Management
64ERP EHP76.0T71D1T41Pay Grade Rule Variant TextsCompensation Management
65ERP EHP76.0T71D2111Pay Scale Group RuleCompensation Management
66ERP EHP76.0T71D2R21Pay Scale Group Rule VariantCompensation Management
67ERP EHP76.0T71D2T41Pay Scale Group Rule Variants TextsCompensation Management
68ERP EHP76.0T71D351Job RuleCompensation Management
69ERP EHP76.0T71D3R21Job Rule VariantCompensation Management
70ERP EHP76.0T71D3T41Job Rule Variant TextsCompensation Management
71ERP EHP76.0T71D451Salary RuleCompensation Management
72ERP EHP76.0T71D4R21Salary Rule VariantCompensation Management
73ERP EHP76.0T71D4T41Salary Rule Variant TextsCompensation Management
74ERP EHP76.0T71D551Employee Appraisal RuleCompensation Management
75ERP EHP76.0T71D5R121Employee Appraisal Rule VariantCompensation Management
76ERP EHP76.0T71D5T41Employee Appraisal Rule Variant TextsCompensation Management
77ERP EHP76.0T71D651User-Defined RuleCompensation Management
78ERP EHP76.0T71D6R21User-Defined Rule VariantCompensation Management
79ERP EHP76.0T71D6T41User-Defined Rule Variant TextsCompensation Management
80ERP EHP76.0T71E0131GuidelinesCompensation Management
81ERP EHP76.0T71E0R31Guideline VariantsCompensation Management
82ERP EHP76.0T71E0T51Guideline Variant TextsCompensation Management
83ERP EHP76.0T71E121Guideline GroupCompensation Management
84ERP EHP76.0T71E1T41Guideline Group TextsCompensation Management
85ERP EHP76.0T71F0101Wage Types for Compensation AdjustmentsCompensation Management
86ERP EHP76.0T71F131Wage Type Model for Compensation AdjustmentsCompensation Management
87ERP EHP76.0T71G0261Compensation MatrixCompensation Management
88ERP EHP76.0T71G0T61Text Table for Compensation MatricesCompensation Management
89ERP EHP76.0T71GD101Dimension TableCompensation Management
90ERP EHP76.0T71GDT51Text Table for DimensionsCompensation Management
91ERP EHP76.0T71GM31Methods for Matrix DimensionsCompensation Management
92ERP EHP76.0T71GMT51Text Table for Dimension MethodCompensation Management
93ERP EHP76.0T71GS91Segment Table for DimensionsCompensation Management
94ERP EHP76.0T71GST101Text Table for Dimension SegmentsCompensation Management
95ERP EHP76.0T71GT21Calculation Variants for Compensation MatrixCompensation Management
96ERP EHP76.0T71GTT41Text Table for Calculation VariantsCompensation Management
97ERP EHP76.0T71GV171Value Table for Compensation MatrixCompensation Management
98ERP EHP76.0T71LA111Award type (check table)Compensation Management
99ERP EHP76.0T71LA1T31Text table for award typeCompensation Management
100ERP EHP76.0T71LA231Award typeCompensation Management
101ERP EHP76.0T71LB1271AwardCompensation Management
102ERP EHP76.0T71LB281Country-dependent award attributesCompensation Management
103ERP EHP76.0T71LB381Pricing information for awardsCompensation Management
104ERP EHP76.0T71LC121Change eventCompensation Management
105ERP EHP76.0T71LC1T41Text table for change eventsCompensation Management
106ERP EHP76.0T71LE131Exercise methodsCompensation Management
107ERP EHP76.0T71LE1T41Text tables for exercise methodsCompensation Management
108ERP EHP76.0T71LE231Exercise methods allowedCompensation Management
109ERP EHP76.0T71LEW051Exercise PeriodCompensation Management
110ERP EHP76.0T71LEW0R21Exercise Window RuleCompensation Management
111ERP EHP76.0T71LEW0T41Exercise Window Rule: TextsCompensation Management
112ERP EHP76.0T71LEW121Exercise GroupsCompensation Management
113ERP EHP76.0T71LEW1T41Exercise Groups: TextsCompensation Management
114ERP EHP76.0T71LL121Life event types (check table)Compensation Management
115ERP EHP76.0T71LL1T41Text table for life event typeCompensation Management
116ERP EHP76.0T71LL231Life event typeCompensation Management
117ERP EHP76.0T71LP171Long-term incentive plansCompensation Management
118ERP EHP76.0T71LP231Long-Term Incentive Plans: Distributed StockCompensation Management
119ERP EHP76.0T71LS151Stock SplitsCompensation Management
120ERP EHP76.0T71LS271Stock SplitsCompensation Management
121ERP EHP76.0T71LV121Vesting rule (check table)Compensation Management
122ERP EHP76.0T71LV1T41Text table for vesting ruleCompensation Management
123ERP EHP76.0T71LV251Vesting RuleCompensation Management
124ERP EHP76.0T71LV3111Life event vestingCompensation Management
125ERP EHP76.0T71LW51Assignment of Workflow Event -> Life EventCompensation Management
126ERP EHP76.0T71LY111Amount Types for Payroll of Exercised AwardsCompensation Management
127ERP EHP76.0T71LY1T31Texts: Amount Types for Payroll of AwardsCompensation Management
128ERP EHP76.0T71LY281Wage Types for Awards PayrollCompensation Management
129ERP EHP76.0T71SS131Web control survey dataCompensation Management
130ERP EHP76.0T71TCS121TCS categoryCompensation Management
131ERP EHP76.0T71TCS1A51TCS category attributeCompensation Management
132ERP EHP76.0T71TCS1T41TCS category textCompensation Management
133ERP EHP76.0T71TCS231TCS subcategoriesCompensation Management
134ERP EHP76.0T71TCS2A71TCS subcategory attributesCompensation Management
135ERP EHP76.0T71TCS2T51TCS subcategory textCompensation Management
136ERP EHP76.0T71TCS371Assignment of TCS subcategory - wage typesCompensation Management
137ERP EHP76.0T71WL141Web linksCompensation Management
138ERP EHP76.0T71WL1T51Web links textCompensation Management
139ERP EHP76.0T71WL271Parameter for link structureCompensation Management
Personnel Management :: Compensation Management :: Personnel Cost Planning
ProductVersionTableColumnsIndexesDescriptionModule
140ERP EHP76.0HRP1015592Infotype 1015 DB tablePersonnel Cost Planning
141ERP EHP76.0PCL5101HR/RP Cluster 5; HR Planning UsagePersonnel Cost Planning
142ERP EHP76.0T77KD111Admin.of Cost Planning Scenarios in Personnel Cost PlanningPersonnel Cost Planning
143ERP EHP76.0T77KE101Assignment of Cost Planning Scenarios to CO Plan VersionsPersonnel Cost Planning
144ERP EHP76.0T77KL111Wage Elements in Personnel Cost PlanningPersonnel Cost Planning
145ERP EHP76.0T77KT51Plan Scenario Texts for Personnel Cost PlanningPersonnel Cost Planning