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

124 columns | Print definition?ERP 6.0  | PERSG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000281000PSA for 0EMPLOYEE_ATTR T90CLNT090 Employee12PERSGnvarchar10
2/BIC/B0000283000PSA for 0EMPLOYEE_2_ATTR T90CLNT090 Employee11PERSGnvarchar10
3CNVLTHCM_APLNOApplication Number Organisational data (Before Conversion)8PERSGEmployee Groupnvarchar10
4CNVLTHCM_PERNRPersonnel Number Organisational data (Before Conversion)8PERSGEmployee Groupnvarchar10
5P2B2_WPBPHCM Declustering B2 - Payroll Results Work Center/Basic Pay20PERSGEmployee Groupnvarchar10
6P2RA_SPPayroll Results: Special Payments14PERSGEmployee Groupnvarchar10
7P2RB_SPPayroll Results: Special Payments14PERSGEmployee Groupnvarchar10
8P2RB_STTax payroll Belgium14PERSGEmployee Groupnvarchar10
9P2RB_SVSocial Insurance payroll Belgium14PERSGEmployee Groupnvarchar10
10P2RD_SPPayroll Results: Special Payments14PERSGEmployee Groupnvarchar10
11P2RE_SPPayroll Results: Special Payments14PERSGEmployee Groupnvarchar10
12P2RI_SPPayroll Results: Special Payments14PERSGEmployee Groupnvarchar10
13P2RN_SPPayroll Results: Special Payments14PERSGEmployee Groupnvarchar10
14P2RQ_QHDAHR-AU-PS: Payroll structure for Higher Duty Allowance22PERSGEmployee group of the higher duty positionnvarchar10
15P2RR_SPPayroll Results: Special Payments14PERSGEmployee Groupnvarchar10
16P2RV_VAPVAP Structure Norway10PERSGEmployee Groupnvarchar10
17P2RX_WPBPPayroll Results: Work Center/Basic Pay18PERSGEmployee Groupnvarchar10
18P2UN_QHDAHR-UN: Payroll structure for Higher Duty Allowance22PERSGEmployee group of the higher duty positionnvarchar10
19T501_DELIMITValidity Period of Employee Group2PERSGEmployee Groupnvarchar10
20T503_DELIMITValidity Period of Employee Subgroup2PERSGEmployee Groupnvarchar10
21T5B9GEmployee Groups/Subgroups (B)2PERSGEmployee Groupnvarchar10
22T5F03Employee groups/subgroups - special features (France)2PERSGEmployee Groupnvarchar10
23T5F2MSickness compensation period3PERSGEmployee Groupnvarchar10
24T5F2PContinued pay in case of sickness3PERSGEmployee Groupnvarchar10
25T5FPBS03Catégorie et statut de personnes: particularité PSF2PERSGCatégorie salariésnvarchar10
26T5M03Employee Groups/Subgroups (Denmark)2PERSGEmployee Groupnvarchar10
27T5REGEmployee Information Log for Destruction of Data10PERSGEmployee Groupnvarchar10
28T5RPDPersonnel Data Deletion Log20PERSGEmployee Groupnvarchar10
29T5TL6Work schedules to generate leave entitlements5PERSGEmployee Groupnvarchar10
30T5UEFFR_EMPPARTCUS Effort Rep : Participating Employee2PERSGEmployee Groupnvarchar10
31T7INPEW6P2E: Agent Determination For Team Groups5PERSGEmployee Groupnvarchar10
32T7NZCTEmployee Categories - NZ2PERSGEmployee Groupnvarchar10
33T7RU53Employee Group/Subgroup Russia attributes2PERSGEmployee Groupnvarchar10
34T7TRK04Account definitions for severance load entegration6PERSGEmployee Groupnvarchar10
35T7TRK07IFRS-TFRS severance provision4PERSGEmployee Groupnvarchar10
36T7UNCMTC_TRFGBCustomizing table for Personnel SubArea and Employee Group4PERSGEmployee Groupnvarchar10
TOPArgentina
37T7AR31Social Insurance employee subgroups: Allocations2PERSGEmployee Groupnvarchar10
TOPAustria
38T5A03Employee Groups/Employee Subgroups2PERSGEmployee Groupnvarchar10
TOPBrazil
39T7BRCSContract salaries3PERSGEmployee Groupnvarchar10
TOPCanada
40T5URBHR payee derived from wage types via org. assignment6PERSGEmployee Groupnvarchar10
TOPCompany Pension Scheme Germany
41P01CVHActuarial CPS Header Records35PERSGEmployee Groupnvarchar10
TOPCross-Application Objects in HR
42HRP5581DB Table for Infotype 558125PERSGEmployee Groupnvarchar10
TOPFinland
43T7FI503HR-FI: Grouping for vacation factor2PERSGEmployee Groupnvarchar10
TOPGermany
44T5D03Employee Group/Subgroup2PERSGEmployee Groupnvarchar10
TOPGreat Britain
45T5G0AEmployee Group/Subgroup2PERSGEmployee Groupnvarchar10
TOPHong Kong
46T7HK0PExtension of T001P4PERSGEmployee Groupnvarchar10
TOPItaly
47PA3214HR Master Record: Infotype 3214268PERSGEmployee Groupnvarchar10
48T5ITMECurrent Yr Mun Surch Payment Exc Table (Fin Law 2007)3PERSGEmployee Groupnvarchar10
49T5ITQ8Cont.&coord. services codes for employee status/type2PERSGEmployee Groupnvarchar10
TOPJapan
50T5J03Person Group/Subgroup JP2PERSGEmployee Groupnvarchar10
TOPLean Staffing
51TSAWE_PERSGEmployee Group2PERSGStaff Assignment Employee Groupnvarchar10
TOPMaintenance Processing
52/MRSS/C_PREMKDummy table for creating Org. Assgnmnt Search Help (No Data)4PERSGEmployee Groupnvarchar10
TOPMalaysia
53T5L03Employee Subgroup grouping for Malaysia2PERSGEmployee Groupnvarchar10
TOPMexico
54T7MX03Assignment tax table to employee group/subgroup2PERSGEmployee Groupnvarchar10
TOPNon Profit Organizations
55T7UNPAD03Employee Group/Subgroup2PERSGEmployee Groupnvarchar10
56T7UNPAD_DPDSDependency Allowance: Lowest Entry Level Determinatio5PERSGEmployee Groupnvarchar10
57T7UNPAD_EG03NPO: Employee Group/Subgroup Eligibility2PERSGEmployee Groupnvarchar10
58T7UNPF_CATMCategory Code Mapping2PERSGEmployee Groupnvarchar10
TOPNorway
59T5V03Employee group/subgrouping for employment contracts (NO)2PERSGEmployee Groupnvarchar10
TOPPayroll
60PA0729Personál.kmen.záznam Infotyp 072927PERSGSkupina pracovníkunvarchar10
61PB0729Personál.kmen.záznam Infotyp 072927PERSGSkupina pracovníkunvarchar10
62T5H84Payroll log14PERSGEmployee Groupnvarchar10
63T5HPBS79Grouping of employee subgroups2PERSGEmployee Groupnvarchar10
64T5T03Personal groups/subgroups - extension2PERSGEmployee Groupnvarchar10
65T5TA1External transfers15PERSGEmployee Groupnvarchar10
66T5TA2Medium for health insurance18PERSGEmployee Groupnvarchar10
67T5TPSMKINDIdentifikace druhu zamestnaneckého pomeru & resortu4PERSGSkupina pracovníkunvarchar10
68T5TPSTXT01Formuláre infotypu 0729 - doplnku opatrení6PERSGSkupina pracovníkunvarchar10
69T5TPSTXT03Dynamické texty na formulári T5TPSTXT01 - pro infotyp 07293PERSGSkupina pracovníkunvarchar10
70T5TPSTXT05Názvy prímých doplnkových textu formuláru infotypu 07296PERSGSkupina pracovníkunvarchar10
71T7BG03EE Group/subgroup Groupings for Bulgaria2PERSGEmployee Groupnvarchar10
72T7RO03Employee group/subgrou Groupings Romania2PERSGEmployee Groupnvarchar10
73T7SK03Person group/person areas - enhancement2PERSGEmployee Groupnvarchar10
74T7SK1LBank accounts of authorities (tax,insurance)8PERSGEmployee Groupnvarchar10
75T7SKA1External transfers15PERSGEmployee Groupnvarchar10
76T7SKVDPAux table for HSKLVDP06PERSGEmployee Groupnvarchar10
77T7TRG03Personel alani ve -altalani bazinda kidem grubu2PERSGÇalisan grubunvarchar10
78T7TRK03Wage and pay increase for higher duty4PERSGEmployee Groupnvarchar10
TOPPayroll General Parts
79HRPY_WPBPHR-PAY: Transparent Table WPBP16PERSGEmployee Groupnvarchar10
80PYORGSCREENPNP900 Selection Screen: Fields for Organizational Selection4PERSGEmployee Groupnvarchar10
TOPPension fund Netherlands
81T5NBGBerekeningsmethode (FAS/ALM interface)3PERSGMedewerkersgroepnvarchar10
TOPPersonnel Administration
82PA0001HR Master Record: Infotype 0001 (Org. Assignment)26PERSGEmployee Groupnvarchar10
83PA0016HR Master Record: Infotype 0016 (Contract Elements)41PERSGEmployee Groupnvarchar10
84T501Employee Group2PERSGEmployee Groupnvarchar10
85T501TEmployee Group Names3PERSGEmployee Groupnvarchar10
86T503Employee Group/Subgroup2PERSGEmployee Groupnvarchar10
87T503ZCountry Assignment for Employee Group/Subgroup3PERSGEmployee Groupnvarchar10
88T529APersonnel Action Types5PERSGAction versionnvarchar10
89T7GR503Grouping for Employee Group-Subgroup2PERSGEmployee Groupnvarchar10
90T7SI03Skupina/podskupina zaposlenih SI2PERSGSkupina zaposlenihnvarchar10
TOPPersonnel Management
91T7HR03Employee Group/Subgroup HR2PERSGEmployee Groupnvarchar10
TOPPortugal
92T5P03HR-PT: Employee Groups / Subgroups - Classification2PERSGEmployee Groupnvarchar10
TOPPosition Budgeting and Control
93HRFPM_BPREP_DATAPreprocesses Data for BPREP Data Extraction14PERSGEmployee Groupnvarchar10
TOPPreconfigured Systems
94ZHRBPJPT_SIIID5PERSG?????nvarchar10
TOPProcess Controls -Automated Controls
95GRPCRTA_HRDA0011HR Master Record: Infotype 0011 (Ext.Bank Transfers)6PERSGEmployee Groupnvarchar10
96GRPCRTA_HRDA0045PC HR control data for infotype 0045 - Loan6PERSGEmployee Groupnvarchar10
97GRPCRTA_HRDA0078PC HR control data for infotype 0078 - Loan Payments6PERSGEmployee Groupnvarchar10
98GRPCRTA_HRDA0267PC HR control data for infotype 02676PERSGEmployee Groupnvarchar10
99GRPCRTA_HRDAT1PC HR control data for infotype 0014 and 00156PERSGEmployee Groupnvarchar10
100GRPCRTA_HRDAT2PC HR control data for infotype 0014 and 00156PERSGEmployee Groupnvarchar10
TOPPublic Sector
101PA0509HR-AU-PS: Master Data (Higher Duty Allowance)39PERSGEmployee group of the higher duty positionnvarchar10
102PDPBSDNEUG_UEBCarried Over to DNeuG: General HR Master Record3PERSGEmployee Groupnvarchar10
103PDPBSTVOED_UEBTransfer to TVoeD: Personnel Master Record Before Transfer3PERSGEmployee Groupnvarchar10
104T5DPBS3CTransfer to TVoeD: Assignment EEGrp/Subgrp Old/New2PERSGEmployee Groupnvarchar10
105T5VPPS_TMATemporary Agreement codes3PERSGEmployee Groupnvarchar10
TOPRecruitment
106PB0001HR Master Record: Infotype 0001 (Org. Assignment)26PERSGEmployee Groupnvarchar10
107PB0016Applicant Master Record Infotype 0016 (Contract Elements)41PERSGEmployee Groupnvarchar10
TOPSingapore
108T5R1PRate for lump payment and CPF in case of semimonthly payroll4PERSGEmployee Groupnvarchar10
109T5R2CRate for CPF deduction by festival advance payment4PERSGEmployee Groupnvarchar10
TOPSouth Africa
110T5WRFNZA Tax and UIF reference number table4PERSGEmployee Groupnvarchar10
TOPSpain
111T5E51Seniority bonuses2PERSGEmployee Groupnvarchar10
TOPStaffing
112HRP1013Infotype 1013 DB Table18PERSGEmployee Groupnvarchar10
113T77WSPerson Group/Subgroup per Work Schedule Group3PERSGEmployee Groupnvarchar10
114T77WTEmployee Group/Subgroup Assignment to Work Schedule Groups2PERSGEmployee Groupnvarchar10
TOPSweden
115T5S03Employee Group/Subgroup (SE)2PERSGEmployee Groupnvarchar10
TOPSwitzerland
116T5C03Employee Group/Subgroup2PERSGEmployee Groupnvarchar10
TOPTaiwan
117T7TW2IReported data of Tax withdrawal report9PERSGEmployee Groupnvarchar10
TOPThailand
118T7TH03Employee Group/Subgrouping for PF THAILAND2PERSGEmployee Groupnvarchar10
TOPWorkforce Management Application
119WFAEM_ESG_MAPMapping of HCM EmployeeSubgroup to WFM Default Setting Group3PERSGEmployee Groupnvarchar10
120WFAEM_PAY_MAPPay rate mapping table (HCM -> WFM)3PERSGEmployee Groupnvarchar10
121WFAEM_V500P_TEmployee group text table2PERSGEmployee Groupnvarchar10
122WFAEM_VAL500PEmployee Group2PERSGEmployee Groupnvarchar10
TOPWorkforce Management Core
123WFMEM_V500P_TEmployee group text table2PERSGEmployee Groupnvarchar10
124WFMEM_VAL500PEmployee Group2PERSGEmployee Groupnvarchar10