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

115 columns | Print definition?ERP 6.0  | MASSG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2B2_WPBPHCM Declustering B2 - Payroll Results Work Center/Basic Pay11MASSGReason for Actionnvarchar20
2P2RA_SPPayroll Results: Special Payments18MASSGReason for Actionnvarchar20
3P2RB_SPPayroll Results: Special Payments18MASSGReason for Actionnvarchar20
4P2RD_SPPayroll Results: Special Payments18MASSGReason for Actionnvarchar20
5P2RE_SPPayroll Results: Special Payments18MASSGReason for Actionnvarchar20
6P2RI_SPPayroll Results: Special Payments18MASSGReason for Actionnvarchar20
7P2RN_SPPayroll Results: Special Payments18MASSGReason for Actionnvarchar20
8P2RQ_QDDCONAustralia Public Sector: Payroll7MASSGReason for Actionnvarchar20
9P2RR_SPPayroll Results: Special Payments18MASSGReason for Actionnvarchar20
10P2RX_WPBPPayroll Results: Work Center/Basic Pay9MASSGReason for Actionnvarchar20
11P2UN_QDDCONAustralia Public Sector: Payroll7MASSGReason for Actionnvarchar20
12T5A2MDamaging Actions/Reasons4MASSGReason for Actionnvarchar20
13T5A9F_MDefinition of Full/Half Severance Pay Using Action + Reason3MASSGReason for Actionnvarchar20
14T5ASRFSCNPAACTNAction5MASSGReason for Actionnvarchar20
15T5C16HR-CH: Exception Events for Reduced Hours3MASSGReason for Actionnvarchar20
16T5FPBSD1Décision - Sous-écran9MASSGMotif de la mesurenvarchar20
17T5PPBSRMHR-PT-PS: Reasons for actions (Public Sector)3MASSGReason for Actionnvarchar20
18T5R4AAction Category Action Type4MASSGReason for Actionnvarchar20
19T5REGEmployee Information Log for Destruction of Data4MASSGReason for Actionnvarchar20
20T5RPDPersonnel Data Deletion Log14MASSGReason for Actionnvarchar20
21T5T530Reasons for Actions3MASSGReason for Actionnvarchar20
22T77PADKZ_ACEVTAssign Personnel Action type and reason for Action to Groups5MASSGReason for Actionnvarchar20
23T77WWW_EADRNDetailed Reasons3MASSGReason for Actionnvarchar20
24T77WWW_EADRNTDetailed Reason Text4MASSGReason for Actionnvarchar20
25T77WWW_EADRPDetailed Reason Properties5MASSGReason for Actionnvarchar20
26T7AEPBS18Eligibility UAE PBS: Actions eligible for Allowances4MASSGReason for Actionnvarchar20
27T7AEPBS22Service Duration Deduction8MASSGReason for Actionnvarchar20
28T7AEPBS23Service Duration Deductions / Additions8MASSGReason for Actionnvarchar20
29T7AEPBS66Absence Type Limit Condition10MASSGReason for Actionnvarchar20
30T7INPEC1P2E: Closure action configuration table11MASSGReason for Actionnvarchar20
31T7INPEC3P2E: Policy Closure Action Transactional Data12MASSGReason for Actionnvarchar20
32T7INPEV1P2E: Validation Attribute Configuration Table11MASSGReason for Actionnvarchar20
33T7KW43Action Category Action Type4MASSGReason for Actionnvarchar20
34T7KW45Settlement Configuration Table4MASSGReason for Actionnvarchar20
35T7OM27Action Category Action Type4MASSGReason for Actionnvarchar20
36T7OM30Settlement Configuration Table4MASSGReason for Actionnvarchar20
37T7QAPBS06Assign Action Type and Reason to Action Category4MASSGReason for Actionnvarchar20
38T7RU530Reasons for Actions3MASSGReason for Actionnvarchar20
39T7RUF0Obsolete3MASSGReason for Actionnvarchar20
40T7RUR0_TRVHRUUTRV0 Print after action in batch mode5MASSGReason for Actionnvarchar20
41T7SA38Mapping Action Reason3MASSGReason for Actionnvarchar20
42T7SAMS02Service Duration Deduction8MASSGReason for Actionnvarchar20
43T7SAPBS43Action Category Action Type4MASSGReason for Actionnvarchar20
44T7SAPBS44Lock Period for Rehire3MASSGReason for Actionnvarchar20
45T7SAPBS58Action Sequence(KSA PBS)3MASSGReason for Actionnvarchar20
46T7SAPBS76Map Mutually Exclusive Actions for Processes and Forms3MASSGReason for Actionnvarchar20
47T7SAPBS77Required Working Durations for Specific Actions3MASSGReason for Actionnvarchar20
48T7UNPF_HR_SEPMSeparation Mapping Table3MASSGReason for Actionnvarchar20
TOPArgentina
49T7AR87Reasons for action additional information3MASSGReason for Actionnvarchar20
TOPAustralia
50PA0701HR Terminations Data Container : Infotype 070125MASSGReason for Actionnvarchar20
51T5Q30Termination Reasons for Actions3MASSGReason for Actionnvarchar20
TOPAustria
52T5A7LPayslip: Actions/Action Reasons for Payslip Creation3MASSGReason for Actionnvarchar20
53T5A9FDefinition of Full/Half Severance Pay Using Leaving Reasons2MASSGReason for Actionnvarchar20
TOPBelgium
54T5BO1Mapping Table Event Type - Reason of Event3MASSGReason for Actionnvarchar20
TOPBenefits
55T5UDECOBRA events / personnel action assignment3MASSGReason for Actionnvarchar20
TOPBrazil
56T7BRT0Legal rights associated with employee situation3MASSGReason for Actionnvarchar20
TOPCanada
57T5K1EEvent reason relevant to ROE (Canada)3MASSGReason for Actionnvarchar20
TOPChile
58T7CL25Personnel Action Code Master4MASSGReason for Actionnvarchar20
TOPCompany Pension Scheme Germany
59P01CVHActuarial CPS Header Records17MASSGReason for Actionnvarchar20
TOPDenmark
60T5MF9Default Value for DA/DS Statistics DK IT (204) is Hiring/Lea3MASSGReason for Actionnvarchar20
TOPFrance
61T5F30Classification of actions and reasons3MASSGReason for Actionnvarchar20
TOPHong Kong
62T7HK3GVesting Schedule and multiplier4MASSGReason for Actionnvarchar20
63T7HK4AEvents & reasons for LSP/Severance payments3MASSGReason for Actionnvarchar20
TOPItaly
64T5I30Events and Reasons for Italy3MASSGReason for Actionnvarchar20
65T5IT30Events and reasons4MASSGReason for Actionnvarchar20
66T5IT33Events and reasons6MASSGReason for Actionnvarchar20
67T5IT34Events and reasons6MASSGReason for Actionnvarchar20
68T5ITCO2Italy: Transferring wage types - Processing5MASSGReason for Actionnvarchar20
TOPJapan
69T5J72HR Supplements to Reason for Events JP3MASSGReason for Actionnvarchar20
TOPMexico
70T7MX02Mexican reasons for personnel actions3MASSGReason for Actionnvarchar20
TOPNetherlands
71T5N9HAssign Events to Pers. Actions and Reasons f. Pers. Actions4MASSGReason for Actionnvarchar20
TOPNon Profit Organizations
72T7UNAAP_CLUSTPaap Cluster7MASSGReason for Actionnvarchar20
TOPPayroll
73PA0729Personál.kmen.záznam Infotyp 072926MASSGDuvod opatrenínvarchar20
74PA0731Personál.kmen.záznam Infotyp 073139MASSGDuvod opatrenínvarchar20
75PB0729Personál.kmen.záznam Infotyp 072926MASSGDuvod opatrenínvarchar20
76PB0731Data uchazece infotyp 0731 (predloha)39MASSGDuvod opatrenínvarchar20
77T5T05Personal events for reports3MASSGReason for Actionnvarchar20
78T5TPS0731Doplnková data infotypu 073119MASSGDuvod opatrenínvarchar20
79T5TPSTXT01Formuláre infotypu 0729 - doplnku opatrení5MASSGDuvod opatrenínvarchar20
80T5TPSTXT05Názvy prímých doplnkových textu formuláru infotypu 07295MASSGDuvod opatrenínvarchar20
81T7RO530RO Legal Reasons for Actions for ER Register3MASSGReason for Actionnvarchar20
82T7TRS06Isten Ayrilma Sebepleri4MASSGIslemler dizisi nedeninvarchar20
83T7UAE1Asign Personnel Action Type and Reason for Action to Groups5MASSGReason for Actionnvarchar20
84T7UAR1Details About Reasons for Actions5MASSGReason for Actionnvarchar20
TOPPayroll General Parts
85HRPY_WPBPHR-PAY: Transparent Table WPBP7MASSGReason for Actionnvarchar20
86T530BPayment Condition (Special Payments)5MASSGReason for Actionnvarchar20
TOPPension fund Netherlands
87T5NDJHR-NL: Mapping van gebeurtenissen5MASSGReden procedurenvarchar20
TOPPersonnel Administration
88PA0000HR Master Record: Infotype 0000 (Actions)25MASSGReason for Actionnvarchar20
89PA0302HR Master Record: Infotype 0302 (Additional Actions)25MASSGReason for Actionnvarchar20
90T530Reasons for Actions3MASSGReason for Actionnvarchar20
91T530TReason for Action Texts4MASSGReason for Actionnvarchar20
92T7GR2530Actual Reasons3MASSGReason for Actionnvarchar20
93T7PL08Conversion table for leave codes2MASSGReason for Actionnvarchar20
94T7PLT0Conversion table for leave codes fot tempolary workers2MASSGReason for Actionnvarchar20
95T7PLT1Conversion table for leave codes fot tempolary workers2MASSGReason for Actionnvarchar20
TOPPortugal
96T5PRMHR-PT: Reasons for actions - Mapping for legal reasons3MASSGReason for Actionnvarchar20
TOPPreconfigured Systems
97ZHRBPJPT_SIIID3MASSG???????nvarchar20
TOPPublic Sector
98PA0567HR AU PS:Master Data Data Container24MASSGReason for Actionnvarchar20
99T5QPBS6DMapping SAP events to APSC movement codes3MASSGReason for Actionnvarchar20
TOPReuse Services for Country Development
100T799L04Event Relation Table4MASSGReason for Actionnvarchar20
TOPRussia
101PA0298HR Master Record: Infotype 029825MASSGReason for Actionnvarchar20
102T7RUR0HR RU Forms5MASSGReason for Actionnvarchar20
103T7RURSDetails About Reasons for Actions3MASSGReason for Actionnvarchar20
104T7RURSTSpecification for Reasons of Action Texts4MASSGReason for Actionnvarchar20
TOPSouth Africa
105T5W30Termination categories3MASSGReason for Actionnvarchar20
106T5W31Termination Categories4MASSGReason for Actionnvarchar20
TOPSpain
107T5E30Adjust Social Insurance reasons and actions3MASSGReason for Actionnvarchar20
108T5E61Contract transformations allowed14MASSGReason for Actionnvarchar20
109T5EA6Actions and reasons affecting seniority3MASSGReason for Actionnvarchar20
TOPStaffing
110T77INTFlagged for Master Data Integration6MASSGReason for Actionnvarchar20
TOPVenezuela
111T7VEEVVenezuelan events3MASSGReason for Actionnvarchar20
TOPWorkforce Management Application
112WFAEM_VAL530Reason code3MASSGReason Codenvarchar20
113WFAEM_VAL530_TText table for reason code3MASSGReason Codenvarchar20
TOPWorkforce Management Core
114WFMEM_VAL530Reason code3MASSGReason Codenvarchar20
115WFMEM_VAL530_TText table for reason code3MASSGReason Codenvarchar20