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

137 columns | Print definition?ERP 6.0  | MASSN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1HRSFI_D_ONB_IMPSuccessFactors: Staging Area for Onboarding Applicants8MASSNAction Typenvarchar20
2HRSFI_D_RCT_LOGSuccessFactors: Staging Area for Recruiting Import9MASSNAction Typenvarchar20
3P2B2_WPBPHCM Declustering B2 - Payroll Results Work Center/Basic Pay10MASSNAction Typenvarchar20
4P2RA_SPPayroll Results: Special Payments17MASSNAction Typenvarchar20
5P2RB_SPPayroll Results: Special Payments17MASSNAction Typenvarchar20
6P2RD_SPPayroll Results: Special Payments17MASSNAction Typenvarchar20
7P2RE_SPPayroll Results: Special Payments17MASSNAction Typenvarchar20
8P2RI_SPPayroll Results: Special Payments17MASSNAction Typenvarchar20
9P2RN_SPPayroll Results: Special Payments17MASSNAction Typenvarchar20
10P2RR_SPPayroll Results: Special Payments17MASSNAction Typenvarchar20
11P2RX_WPBPPayroll Results: Work Center/Basic Pay8MASSNAction Typenvarchar20
12T588BInfotype Menus7MASSNPersonnel/Applicant action typenvarchar20
13T5A2MDamaging Actions/Reasons3MASSNAction Typenvarchar20
14T5A9F_MDefinition of Full/Half Severance Pay Using Action + Reason2MASSNAction Typenvarchar20
15T5ASRFSCNPAACTNAction4MASSNAction Typenvarchar20
16T5C16HR-CH: Exception Events for Reduced Hours2MASSNAction Typenvarchar20
17T5FPBSD1Décision - Sous-écran8MASSNCatégorie de mesurenvarchar20
18T5PPBSRMHR-PT-PS: Reasons for actions (Public Sector)2MASSNAction Typenvarchar20
19T5R4AAction Category Action Type3MASSNAction Typenvarchar20
20T5REGEmployee Information Log for Destruction of Data3MASSNAction Typenvarchar20
21T5RPDPersonnel Data Deletion Log13MASSNAction Typenvarchar20
22T5T530Reasons for Actions2MASSNAction Typenvarchar20
23T77PADKZ_ACEVTAssign Personnel Action type and reason for Action to Groups4MASSNAction Typenvarchar20
24T77WWW_EADRNDetailed Reasons2MASSNAction Typenvarchar20
25T77WWW_EADRNTDetailed Reason Text3MASSNAction Typenvarchar20
26T77WWW_EADRPDetailed Reason Properties4MASSNAction Typenvarchar20
27T7AEPBS18Eligibility UAE PBS: Actions eligible for Allowances3MASSNAction Typenvarchar20
28T7AEPBS22Service Duration Deduction7MASSNAction Typenvarchar20
29T7AEPBS23Service Duration Deductions / Additions7MASSNAction Typenvarchar20
30T7AEPBS66Absence Type Limit Condition9MASSNAction Typenvarchar20
31T7CNRM_CHNGCNTNTDetail of Change Management5MASSNAction Typenvarchar20
32T7CNRM_RPTSTAStatistical Dimension Definition29MASSNAction Typenvarchar20
33T7INPEC1P2E: Closure action configuration table10MASSNAction Typenvarchar20
34T7INPEC3P2E: Policy Closure Action Transactional Data11MASSNAction Typenvarchar20
35T7INPEV1P2E: Validation Attribute Configuration Table10MASSNAction Typenvarchar20
36T7KW43Action Category Action Type3MASSNAction Typenvarchar20
37T7KW45Settlement Configuration Table3MASSNAction Typenvarchar20
38T7OM27Action Category Action Type3MASSNAction Typenvarchar20
39T7OM30Settlement Configuration Table3MASSNAction Typenvarchar20
40T7QAPBS06Assign Action Type and Reason to Action Category3MASSNAction Typenvarchar20
41T7RU530Reasons for Actions2MASSNAction Typenvarchar20
42T7RUF0Obsolete2MASSNAction Typenvarchar20
43T7RUR0_TRVHRUUTRV0 Print after action in batch mode4MASSNAction Typenvarchar20
44T7SA38Mapping Action Reason2MASSNAction Typenvarchar20
45T7SAMS02Service Duration Deduction7MASSNAction Typenvarchar20
46T7SAPBS43Action Category Action Type3MASSNAction Typenvarchar20
47T7SAPBS44Lock Period for Rehire2MASSNAction Typenvarchar20
48T7SAPBS58Action Sequence(KSA PBS)2MASSNAction Typenvarchar20
49T7SAPBS76Map Mutually Exclusive Actions for Processes and Forms2MASSNAction Typenvarchar20
50T7SAPBS77Required Working Durations for Specific Actions2MASSNAction Typenvarchar20
51T7UNPF_HR_SEPMSeparation Mapping Table2MASSNAction Typenvarchar20
TOPArgentina
52T7AR87Reasons for action additional information2MASSNAction Typenvarchar20
TOPAustralia
53T5Q30Termination Reasons for Actions2MASSNAction Typenvarchar20
TOPAustria
54T5A7LPayslip: Actions/Action Reasons for Payslip Creation2MASSNAction Typenvarchar20
TOPBelgium
55T5BO1Mapping Table Event Type - Reason of Event2MASSNAction Typenvarchar20
TOPBenefits
56T5UDECOBRA events / personnel action assignment2MASSNAction Typenvarchar20
TOPBrazil
57T7BRT0Legal rights associated with employee situation2MASSNAction Typenvarchar20
TOPBusiness Package for Manager Self-Service HR
58TWPC_PCR_GENERALGeneral PCR Settings6MASSNAction Typenvarchar20
TOPCanada
59T5K1EEvent reason relevant to ROE (Canada)2MASSNAction Typenvarchar20
TOPChile
60T7CL25Personnel Action Code Master3MASSNAction Typenvarchar20
TOPCompany Pension Scheme Germany
61P01CVHActuarial CPS Header Records16MASSNAction Typenvarchar20
TOPDenmark
62T5MF9Default Value for DA/DS Statistics DK IT (204) is Hiring/Lea2MASSNAction Typenvarchar20
TOPFrance
63T5F30Classification of actions and reasons2MASSNAction Typenvarchar20
TOPHong Kong
64T7HK3GVesting Schedule and multiplier3MASSNAction Typenvarchar20
65T7HK4AEvents & reasons for LSP/Severance payments2MASSNAction Typenvarchar20
TOPHR Administrative Services
66T5ASRFAVORITESInfotype Browser Favorites7MASSNAction Typenvarchar20
TOPItaly
67T5I30Events and Reasons for Italy2MASSNAction Typenvarchar20
68T5IT30Events and reasons3MASSNAction Typenvarchar20
69T5IT33Events and reasons5MASSNAction Typenvarchar20
70T5IT34Events and reasons5MASSNAction Typenvarchar20
71T5ITCO2Italy: Transferring wage types - Processing4MASSNAction Typenvarchar20
TOPJapan
72T5J72HR Supplements to Reason for Events JP2MASSNAction Typenvarchar20
73T5JRHAction types for Leaving-Reentry2MASSNAction Typenvarchar20
TOPMexico
74T7MX02Mexican reasons for personnel actions2MASSNAction Typenvarchar20
TOPNetherlands
75T5N9HAssign Events to Pers. Actions and Reasons f. Pers. Actions3MASSNAction Typenvarchar20
TOPNon Profit Organizations
76T7UNAAP_CLUSTPaap Cluster6MASSNAction Typenvarchar20
77T7UNAAP_T529APAAP Actiontype2MASSNAction Typenvarchar20
78T7UNPAD_ACTIONSCustomizing: Additional Functions for Actions2MASSNAction Typenvarchar20
TOPOrganizational Management
79T777MDefinition of Actions2MASSNType of Actionnvarchar40
80T778MActions2MASSNType of Actionnvarchar40
81T77MBAction Texts3MASSNActionnvarchar40
TOPPayroll
82PA0729Personál.kmen.záznam Infotyp 072925MASSNDruh opatrenínvarchar20
83PA0731Personál.kmen.záznam Infotyp 073138MASSNDruh opatrenínvarchar20
84PB0729Personál.kmen.záznam Infotyp 072925MASSNDruh opatrenínvarchar20
85PB0731Data uchazece infotyp 0731 (predloha)38MASSNDruh opatrenínvarchar20
86T5T05Personal events for reports2MASSNAction Typenvarchar20
87T5TPS0731Doplnková data infotypu 073118MASSNDruh opatrenínvarchar20
88T5TPSTXT01Formuláre infotypu 0729 - doplnku opatrení4MASSNDruh opatrenínvarchar20
89T5TPSTXT05Názvy prímých doplnkových textu formuláru infotypu 07294MASSNDruh opatrenínvarchar20
90T7RO530RO Legal Reasons for Actions for ER Register2MASSNAction Typenvarchar20
91T7TRS06Isten Ayrilma Sebepleri3MASSNIslemler dizisi türünvarchar20
92T7UAE1Asign Personnel Action Type and Reason for Action to Groups4MASSNAction Typenvarchar20
93T7UAR1Details About Reasons for Actions4MASSNAction Typenvarchar20
TOPPayroll General Parts
94HRPY_WPBPHR-PAY: Transparent Table WPBP6MASSNAction Typenvarchar20
95T530BPayment Condition (Special Payments)4MASSNAction Typenvarchar20
TOPPension fund Netherlands
96T5ND3HR-CH: Pension fund postings5MASSNAction Typenvarchar20
97T5NDJHR-NL: Mapping van gebeurtenissen4MASSNSoort procedurenvarchar20
TOPPersonnel Administration
98PA0000HR Master Record: Infotype 0000 (Actions)24MASSNAction Typenvarchar20
99PA0302HR Master Record: Infotype 0302 (Additional Actions)24MASSNAction Typenvarchar20
100T529APersonnel Action Types2MASSNAction Typenvarchar20
101T529A_ESSEXESS: Deactivation of Personnel Action Types2MASSNAction Typenvarchar20
102T529FFast Data Entry for Actions3MASSNPersonnel/Applicant action typenvarchar20
103T529TPersonnel Action Texts3MASSNAction Typenvarchar20
104T530Reasons for Actions2MASSNAction Typenvarchar20
105T530TReason for Action Texts3MASSNAction Typenvarchar20
106T588YSAdditional Info on Screens Generated from TMYPA423MASSNAction Typenvarchar20
107T7CO11Concepts to be initialized in table CRT acc. to pers. action2MASSNAction Typenvarchar20
108T7CO32Conditions change for social insurance and retention4MASSNAction Typenvarchar20
109T7GR2530Actual Reasons2MASSNAction Typenvarchar20
TOPPortugal
110T5PRMHR-PT: Reasons for actions - Mapping for legal reasons2MASSNAction Typenvarchar20
TOPPreconfigured Systems
111ZHRBPJPT_SIIID2MASSN????????nvarchar20
TOPPublic Sector
112T5D7JControl of BDA and COLA Relevance (Basic Pay)6MASSNAction Typenvarchar20
113T5QPBS6DMapping SAP events to APSC movement codes2MASSNAction Typenvarchar20
TOPRecruitment
114PB4000Infotype 4000: Applicant Events27MASSNApplicant action typenvarchar20
115T751EApplicant Action Type2MASSNApplicant action typenvarchar20
116T751FText for applicant event type3MASSNApplicant action typenvarchar20
TOPReuse Services for Country Development
117T799L04Event Relation Table3MASSNAction Typenvarchar20
TOPRussia
118PA0298HR Master Record: Infotype 029824MASSNAction Typenvarchar20
119T7RUR0HR RU Forms4MASSNAction Typenvarchar20
120T7RURSDetails About Reasons for Actions2MASSNAction Typenvarchar20
121T7RURSTSpecification for Reasons of Action Texts3MASSNAction Typenvarchar20
TOPSouth Africa
122T5W30Termination categories2MASSNAction Typenvarchar20
123T5W31Termination Categories3MASSNAction Typenvarchar20
TOPSpain
124T5E30Adjust Social Insurance reasons and actions2MASSNAction Typenvarchar20
125T5E61Contract transformations allowed13MASSNAction Typenvarchar20
126T5EA6Actions and reasons affecting seniority2MASSNAction Typenvarchar20
TOPStaffing
127T77INTFlagged for Master Data Integration5MASSNAction Typenvarchar20
TOPTraining Management
128LSOTFORMP_CDelivery Method Attributes13MASSNAction for Course Typenvarchar40
TOPVenezuela
129T7VEEVVenezuelan events2MASSNAction Typenvarchar20
TOPWorkforce Management Application
130WFAEM_ACTION_MAPMapping table for action types4MASSNAction Typenvarchar20
131WFAEM_VAL530Reason code2MASSNWFD Action typenvarchar20
132WFAEM_VAL530_TText table for reason code2MASSNWFD Action typenvarchar20
133WFAEM_VALIDPAIRSMaintain key and value pairs for field level validation4MASSNWFD Action typenvarchar20
TOPWorkforce Management Core
134WFMEM_ACTION_MAPMapping table for action types4MASSNAction Typenvarchar20
135WFMEM_VAL530Reason code2MASSNWFD Action typenvarchar20
136WFMEM_VAL530_TText table for reason code2MASSNWFD Action typenvarchar20
137WFMEM_VALIDPAIRSMaintain key and value pairs for field level validation4MASSNWFD Action typenvarchar20