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

179 tablesERP 6.0 

Payroll :: Singapore :: Public Sector
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PA0486411HR-SG-PS: Master Data (National Service)Public Sector
2ERP EHP76.0PA0487271HR-SG-PS: Security / medical ClearancePublic Sector
3ERP EHP76.0PA0488271HR-SG-PS: Leave schemePublic Sector
4ERP EHP76.0PA0489271HR-SG-PS: Voluntary Service / ECAPublic Sector
5ERP EHP76.0PA0490451HR-PS-SG: Employee Suggestion SchemePublic Sector
6ERP EHP76.0PA0493901HR-SG-PS: Extension of infotype 0022Public Sector
7ERP EHP76.0PA04941131HR-PS-SG: Employee Suggestion Scheme - Evaluation ResultsPublic Sector
8ERP EHP76.0PA04951121HR-PS-SG: Pensions SchemePublic Sector
9ERP EHP76.0PA0502601Letter of appointmentPublic Sector
10ERP EHP76.0PA0742261HR Master Record: Infotype 0742Public Sector
11ERP EHP76.0PA07431011HR master record infotype 0743 (Discipline)Public Sector
12ERP EHP76.0PA0744441HR master record infotype 0744 (Blacklist)Public Sector
13ERP EHP76.0PA0752451HR Master Record: Infotype 0752Public Sector
14ERP EHP76.0PA0753351HR Master Record: Infotype 0753Public Sector
15ERP EHP76.0PA0754331HR Master Record: Infotype 0754Public Sector
16ERP EHP76.0PA0755291HR Master Record: Infotype 0755Public Sector
17ERP EHP76.0PB0488271HR-SG-PS: Leave schemePublic Sector
18ERP EHP76.0PB0493901HR-SG-PS: Extension of infotype 0022Public Sector
19ERP EHP76.0PB0502601Letter of appointmentPublic Sector
20ERP EHP76.0PB0744441HR Master Record: Infotype 0744Public Sector
21ERP EHP76.0T5PBSR1A31Type of National Service and UnitPublic Sector
22ERP EHP76.0T5PBSR1AT51Text For Type of National Service And UnitPublic Sector
23ERP EHP76.0T5PBSR1B21National Service StatusPublic Sector
24ERP EHP76.0T5PBSR1BT41Text For National Service StatusPublic Sector
25ERP EHP76.0T5PBSR1C41RANK at ORD / ReservistPublic Sector
26ERP EHP76.0T5PBSR1CT51Text For Rank at ORD / ReservistPublic Sector
27ERP EHP76.0T5PBSR1D31VocationPublic Sector
28ERP EHP76.0T5PBSR1DT51Text For VocationPublic Sector
29ERP EHP76.0T5PBSR1E21CommendationPublic Sector
30ERP EHP76.0T5PBSR1ET41Text For CommendationPublic Sector
31ERP EHP76.0T5PBSR1F21Performance rating for national servicePublic Sector
32ERP EHP76.0T5PBSR1FT41Text For Performance RatingPublic Sector
33ERP EHP76.0T5PBSR1G21Conduct rating for national servicePublic Sector
34ERP EHP76.0T5PBSR1GT41Text For Conduct RatingPublic Sector
35ERP EHP76.0T5PBSR1H21Mobilisation CodePublic Sector
36ERP EHP76.0T5PBSR1HT41Text For MobilisationPublic Sector
37ERP EHP76.0T5PBSR1J31Level Of ClearancePublic Sector
38ERP EHP76.0T5PBSR1JT51Text For Level Of ClearancePublic Sector
39ERP EHP76.0T5PBSR1K21Status Of ClearancePublic Sector
40ERP EHP76.0T5PBSR1KT41Text For Status Of ClearancePublic Sector
41ERP EHP76.0T5PBSR1L31Types Of Voluntary Services / ECAPublic Sector
42ERP EHP76.0T5PBSR1LT51Text For Voluntary Services / ECAPublic Sector
43ERP EHP76.0T5PBSR1M21Position Held In Voluntary Service / ECAPublic Sector
44ERP EHP76.0T5PBSR1MT41Text For Position Held In Voluntary Service / ECAPublic Sector
45ERP EHP76.0T5PBSR1N21RepresentationPublic Sector
46ERP EHP76.0T5PBSR1NT41Text For RepresentationPublic Sector
47ERP EHP76.0T5PBSR1O31SubjectPublic Sector
48ERP EHP76.0T5PBSR1OT61Text For Subject CodePublic Sector
49ERP EHP76.0T5PBSR1P21Asset TypePublic Sector
50ERP EHP76.0T5PBSR1PT41Text For Asset TypePublic Sector
51ERP EHP76.0T5PBSR1Q31Dialect GroupPublic Sector
52ERP EHP76.0T5PBSR1QT51Text For Dialect GroupPublic Sector
53ERP EHP76.0T5PBSR1T41Link table for absence and NS Type (No longer in use)Public Sector
54ERP EHP76.0T5PBSR2A61Stores the employer MediSave reference numberPublic Sector
55ERP EHP76.0T5PBSR2B281SI contr. table for Govt Pensionable Employees.Public Sector
56ERP EHP76.0T5PBSR2C311PR contr. table for govt. pensionable employees.Public Sector
57ERP EHP76.0T5PBSR2D301SI contr. table for Govt Non-pensionable EmployeesPublic Sector
58ERP EHP76.0T5PBSR2E331PR contr. table for Govt. non-pensionable employees.Public Sector
59ERP EHP76.0T5PBSR2F101Special MSO Calculation RulesPublic Sector
60ERP EHP76.0T5PBSR3A21Leave scheme typesPublic Sector
61ERP EHP76.0T5PBSR3AT41Text table for leave schemesPublic Sector
62ERP EHP76.0T5PBSR3B61Leave entitlementPublic Sector
63ERP EHP76.0T5PBSR3BI21Group identifier for leave entilementPublic Sector
64ERP EHP76.0T5PBSR3BIT41Text for group identifier for leave entilementPublic Sector
65ERP EHP76.0T5PBSR3C51Leave Quota EntitlementPublic Sector
66ERP EHP76.0T5PBSR3CI21Group for leave quotaPublic Sector
67ERP EHP76.0T5PBSR3CIT41Text for group for leave quotaPublic Sector
68ERP EHP76.0T5PBSR3D61Leave allowance and daily rate of make up vac lv - scheme 73Public Sector
69ERP EHP76.0T5PBSR3DI21Group for leave allowancePublic Sector
70ERP EHP76.0T5PBSR3DIT41Text for group for leave allowancePublic Sector
71ERP EHP76.0T5PBSR3G21DivisionPublic Sector
72ERP EHP76.0T5PBSR3GT41Division textPublic Sector
73ERP EHP76.0T5PBSR3H41Salary GroupingPublic Sector
74ERP EHP76.0T5PBSR3I61Define the maximum number of absence days w/o prorationPublic Sector
75ERP EHP76.0T5PBSR3J81Guideline for prorationPublic Sector
76ERP EHP76.0T5PBSR4A21Appointment typePublic Sector
77ERP EHP76.0T5PBSR4AT41Appointment type descriptionPublic Sector
78ERP EHP76.0T5PBSR4B21Tenure of officePublic Sector
79ERP EHP76.0T5PBSR4BT41Tenure of office descriptionPublic Sector
80ERP EHP76.0T5PBSR6A31Scheme of ServicesPublic Sector
81ERP EHP76.0T5PBSR6AT51Text for Scheme of ServicesPublic Sector
82ERP EHP76.0T5PBSR6B31Salary CodePublic Sector
83ERP EHP76.0T5PBSR6BT51Text for Salary CodePublic Sector
84ERP EHP76.0T5PBSR6C41Assignment between Scheme Code and Salary CodePublic Sector
85ERP EHP76.0T5PBSR6D41(Not used, will be deleted in 4.6)Public Sector
86ERP EHP76.0T5PBSR6E91Annual Wage Adjustment for Basic ComponentPublic Sector
87ERP EHP76.0T5PBSR6F111Monthly Salary ScalePublic Sector
88ERP EHP76.0T5PBSR6G81Basic ComponentPublic Sector
89ERP EHP76.0T5PBSR6H101NPVP Increment DetailPublic Sector
90ERP EHP76.0T5PBSR6HI21NPVP Increment Eligibility GroupPublic Sector
91ERP EHP76.0T5PBSR6HIT41Text for Eligibility Group for NPVP AdjustmentPublic Sector
92ERP EHP76.0T5PBSR6I121Guideline for Salary ComponentsPublic Sector
93ERP EHP76.0T5PBSR6J91Annual Wage Adjustment for MVC ComponentPublic Sector
94ERP EHP76.0T5PBSR6M41Assignment between Pay Scale Types and Scheme CodePublic Sector
95ERP EHP76.0T5PBSR6N41Assignment between Pay scale area and divisionPublic Sector
96ERP EHP76.0T5R0P_PS151Plant section/Singapore for PS EmployeesPublic Sector
97ERP EHP76.0T5RCPF_SCH31CPF Scheme types for Public sectorPublic Sector
98ERP EHP76.0T5RCPF_SCHT51CPF Scheme type textsPublic Sector
99ERP EHP76.0T5RPBS10A51Disciplinary ActPublic Sector
100ERP EHP76.0T5RPBS10AT51Text Table for Disciplinary ActPublic Sector
101ERP EHP76.0T5RPBS10B61Offences CodePublic Sector
102ERP EHP76.0T5RPBS10BT111Text table for Offences CodePublic Sector
103ERP EHP76.0T5RPBS10C31Outcome GroupingPublic Sector
104ERP EHP76.0T5RPBS10CT51Text table for Outcome GroupingPublic Sector
105ERP EHP76.0T5RPBS10D61Outcome CodePublic Sector
106ERP EHP76.0T5RPBS10DT51Text Table for Outcome codePublic Sector
107ERP EHP76.0T5RPBS10E51Type of RepresentationPublic Sector
108ERP EHP76.0T5RPBS10ET51Text Table for Type of RepresentationPublic Sector
109ERP EHP76.0T5RPBS10F31Offence GroupingPublic Sector
110ERP EHP76.0T5RPBS10FT51Text table for Offence GroupingPublic Sector
111ERP EHP76.0T5RPBS10G51Interdict/Stop pay typePublic Sector
112ERP EHP76.0T5RPBS10GT51Text Table for Interdiction TypePublic Sector
113ERP EHP76.0T5RPBS10H31Blacklist categoryPublic Sector
114ERP EHP76.0T5RPBS10HT51Text Table for Blacklist CategoryPublic Sector
115ERP EHP76.0T5RPBS10I31Exit ModePublic Sector
116ERP EHP76.0T5RPBS10IT51Text table for Exit modePublic Sector
117ERP EHP76.0T5RPBS10J31Blacklist reasonPublic Sector
118ERP EHP76.0T5RPBS10JT51Text table for Blacklist ReasonPublic Sector
119ERP EHP76.0T5RPBS11A31Type of PropertyPublic Sector
120ERP EHP76.0T5RPBS11AT51Text Table for Type of PropertyPublic Sector
121ERP EHP76.0T5RPBS11B31Type of CompanyPublic Sector
122ERP EHP76.0T5RPBS11BT51Text Table for Type of CompanyPublic Sector
123ERP EHP76.0T5RPBS11C31Type of Business FirmPublic Sector
124ERP EHP76.0T5RPBS11CT51Text Table for Type of Business FirmPublic Sector
125ERP EHP76.0T5RPBS1P31Staff Suggestion CategoryPublic Sector
126ERP EHP76.0T5RPBS1PT51Text Table for Staff Suggestion CategoryPublic Sector
127ERP EHP76.0T5RPBS1Q71Evaluator IdentificationPublic Sector
128ERP EHP76.0T5RPBS1R31Evaluation Criteria For Staff Suggestion SchemePublic Sector
129ERP EHP76.0T5RPBS1RT51Text Table for Evaluation Criteria in SSSPublic Sector
130ERP EHP76.0T5RPBS1T71Weighting of Evaluation CriteriaPublic Sector
131ERP EHP76.0T5RPBS1U31Evaluation Status in Staff Suggestion SchemePublic Sector
132ERP EHP76.0T5RPBS1UT51Text Table for Evaluation Status in SSSPublic Sector
133ERP EHP76.0T5RPBS1W81Evaluation Authority and Weighting Based on EvaluatorPublic Sector
134ERP EHP76.0T5RPBS1X31Staff Suggestion Scheme Ranking TablePublic Sector
135ERP EHP76.0T5RPBS1XT51Text Table for Staff Suggestion Ranking TablePublic Sector
136ERP EHP76.0T5RPBS1Y91Definition of Rank TablePublic Sector
137ERP EHP76.0T5RPBS8A71Define Superannuation SchemePublic Sector
138ERP EHP76.0T5RPBS8AT41Text Table for Superannuation SchemePublic Sector
139ERP EHP76.0T5RPBS8B31Define Superannuation Scheme Payment OptionPublic Sector
140ERP EHP76.0T5RPBS8BT41Text Table for Superannuation Scheme Payment OptionPublic Sector
141ERP EHP76.0T5RPBS8C41OBSOLETE(Pensions Scheme Payment Option Eligibility Crite)Public Sector
142ERP EHP76.0T5RPBS8D41OBSOLETE (Absences not counted as Pensionable Service)Public Sector
143ERP EHP76.0T5RPBS8E101OBSOLETE (SG Public Sector Pensions Scheme Constants Tab)Public Sector
144ERP EHP76.0T5RPBS8ET41OBSOLETE (Text Table for Pensions Scheme Constants Table)Public Sector
145ERP EHP76.0T5RPBS8F51Pay Changes Reasons to be considered for Averaging of APEPublic Sector
146ERP EHP76.0T5RPBS8G81OBSOLETE (Specify Calculation Process for LOS Calculation)Public Sector
147ERP EHP76.0T5RPBS8H91Assign Options, Components, Val. Model to Elig. GroupingPublic Sector
148ERP EHP76.0T5RPBS8I21Define Eligibility Grouping for Superannuation SchemePublic Sector
149ERP EHP76.0T5RPBS8IT41Text Table for Pensions Scheme Eligibility GroupingPublic Sector
150ERP EHP76.0T5RPBS8J81Pensions Scheme Constant Value (TO BE OBSOLETED)Public Sector
151ERP EHP76.0T5RPBS8K21Pensions Scheme Option Component Code (Obsolete)Public Sector
152ERP EHP76.0T5RPBS8KT41Text Table for Pensions Scheme Option Comp. Code(Obsolete)Public Sector
153ERP EHP76.0T5RPBS8L61Pensions Scheme Discount ValuePublic Sector
154ERP EHP76.0T5RPBS8M91Interest RatesPublic Sector
155ERP EHP76.0T5RPBS8N21Pensions Scheme Eligibility GroupingPublic Sector
156ERP EHP76.0T5RPBS8NT41Text Table for Pensions Scheme Eligibility GroupingPublic Sector
157ERP EHP76.0T5RPBS8O21Pensions Scheme Option Component CodePublic Sector
158ERP EHP76.0T5RPBS8OT41Text Table for Pensions Scheme Option Component CodePublic Sector
159ERP EHP76.0T5RPBS8P71Exit Modules for Pension CalculationsPublic Sector
160ERP EHP76.0T5RPBS8Q51Absence type for proration of Past salary for CPF refundPublic Sector
161ERP EHP76.0T5RPBS8R51Maintain Formula Module for Generic APE CalculationPublic Sector
162ERP EHP76.0T5RPBS8S61Maintain Formula Module for Average APE CalculationPublic Sector
163ERP EHP76.0T5RPBS8T41Maintain Pensions ActPublic Sector
164ERP EHP76.0T5RPBS8TT51Text Table for Pensions ActPublic Sector
165ERP EHP76.0T5RPBS8U21Define Superannuation OptionPublic Sector
166ERP EHP76.0T5RPBS8UT41Text Table for Superannuation optionPublic Sector
167ERP EHP76.0T5RPBS8V51Assign Superannuation Option to Superannuation SchemePublic Sector
168ERP EHP76.0T5RPBS8W41Maintain Approval of RetirementPublic Sector
169ERP EHP76.0T5RPBS8WT41Text Table for Approval of RetirementPublic Sector
170ERP EHP76.0T5RPBS9A31Status GroupPublic Sector
171ERP EHP76.0T5RPBS9AT51Text Table for Status GroupPublic Sector
172ERP EHP76.0T5RPBS9B31StatusPublic Sector
173ERP EHP76.0T5RPBS9BT51Text Table for StatusPublic Sector
174ERP EHP76.0T5RPBS9C41Assignment of Status to Status GroupPublic Sector
175ERP EHP76.0T5RPBSE151To define Standard Divisional Ratios for ERA.Public Sector
176ERP EHP76.0T5RPBSE261Priority of ERA DeductionsPublic Sector
177ERP EHP76.0T5RPBSG041GNP Code for GNPPublic Sector
178ERP EHP76.0T5RPBSG1141Salary Conversions for GNPPublic Sector
179ERP EHP76.0T5RPBSG251Golden Number for GNPPublic Sector