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

123 columns | Print definition?ERP 6.0  | PERSK

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000281000PSA for 0EMPLOYEE_ATTR T90CLNT090 Employee13PERSKnvarchar20
2/BIC/B0000283000PSA for 0EMPLOYEE_2_ATTR T90CLNT090 Employee12PERSKnvarchar20
3CNVLTHCM_APLNOApplication Number Organisational data (Before Conversion)9PERSKEmployee Subgroupnvarchar20
4CNVLTHCM_PERNRPersonnel Number Organisational data (Before Conversion)9PERSKEmployee Subgroupnvarchar20
5P2B2_WPBPHCM Declustering B2 - Payroll Results Work Center/Basic Pay21PERSKEmployee Subgroupnvarchar20
6P2RA_SPPayroll Results: Special Payments15PERSKEmployee Subgroupnvarchar20
7P2RB_SPPayroll Results: Special Payments15PERSKEmployee Subgroupnvarchar20
8P2RB_STTax payroll Belgium15PERSKEmployee Subgroupnvarchar20
9P2RB_SVSocial Insurance payroll Belgium15PERSKEmployee Subgroupnvarchar20
10P2RD_SPPayroll Results: Special Payments15PERSKEmployee Subgroupnvarchar20
11P2RE_SPPayroll Results: Special Payments15PERSKEmployee Subgroupnvarchar20
12P2RI_SPPayroll Results: Special Payments15PERSKEmployee Subgroupnvarchar20
13P2RN_SPPayroll Results: Special Payments15PERSKEmployee Subgroupnvarchar20
14P2RQ_QHDAHR-AU-PS: Payroll structure for Higher Duty Allowance23PERSKEmployee subgroup of the higher duty positionnvarchar20
15P2RR_SPPayroll Results: Special Payments15PERSKEmployee Subgroupnvarchar20
16P2RV_VAPVAP Structure Norway11PERSKEmployee Subgroupnvarchar20
17P2RX_WPBPPayroll Results: Work Center/Basic Pay19PERSKEmployee Subgroupnvarchar20
18P2UN_QHDAHR-UN: Payroll structure for Higher Duty Allowance23PERSKEmployee subgroup of the higher duty positionnvarchar20
19T503_DELIMITValidity Period of Employee Subgroup3PERSKEmployee Subgroupnvarchar20
20T5B9GEmployee Groups/Subgroups (B)3PERSKEmployee Subgroupnvarchar20
21T5F03Employee groups/subgroups - special features (France)3PERSKEmployee Subgroupnvarchar20
22T5F2MSickness compensation period4PERSKEmployee Subgroupnvarchar20
23T5F2PContinued pay in case of sickness4PERSKEmployee Subgroupnvarchar20
24T5FPBS03Catégorie et statut de personnes: particularité PSF3PERSKStatut de salariésnvarchar20
25T5M03Employee Groups/Subgroups (Denmark)3PERSKEmployee Subgroupnvarchar20
26T5PPBS9BPortugal Public Sector - Scenarios2PERSKEmployee Subgroupnvarchar20
27T5REGEmployee Information Log for Destruction of Data11PERSKEmployee Subgroupnvarchar20
28T5RPDPersonnel Data Deletion Log21PERSKEmployee Subgroupnvarchar20
29T5TL6Work schedules to generate leave entitlements6PERSKEmployee Subgroupnvarchar20
30T5UEFFR_EMPPARTCUS Effort Rep : Participating Employee3PERSKEmployee Subgroupnvarchar20
31T7INPEW6P2E: Agent Determination For Team Groups6PERSKEmployee Subgroupnvarchar20
32T7NZCTEmployee Categories - NZ3PERSKEmployee Subgroupnvarchar20
33T7RU53Employee Group/Subgroup Russia attributes3PERSKEmployee Subgroupnvarchar20
34T7TRK04Account definitions for severance load entegration7PERSKEmployee Subgroupnvarchar20
35T7TRK07IFRS-TFRS severance provision3PERSKEmployee Subgroupnvarchar20
TOPArgentina
36T7AR31Social Insurance employee subgroups: Allocations3PERSKEmployee Subgroupnvarchar20
TOPAustria
37T5A03Employee Groups/Employee Subgroups3PERSKEmployee Subgroupnvarchar20
TOPBrazil
38T7BRCSContract salaries2PERSKEmployee Subgroupnvarchar20
TOPCanada
39T5URBHR payee derived from wage types via org. assignment5PERSKEmployee Subgroupnvarchar20
TOPCompany Pension Scheme Germany
40P01CVHActuarial CPS Header Records36PERSKEmployee Subgroupnvarchar20
TOPCross-Application Objects in HR
41HRP5581DB Table for Infotype 558126PERSKEmployee Subgroupnvarchar20
TOPFinland
42T7FI503HR-FI: Grouping for vacation factor3PERSKEmployee Subgroupnvarchar20
TOPGermany
43T5D03Employee Group/Subgroup3PERSKEmployee Subgroupnvarchar20
TOPGreat Britain
44T5G0AEmployee Group/Subgroup3PERSKEmployee Subgroupnvarchar20
TOPHong Kong
45T7HK0PExtension of T001P5PERSKEmployee Subgroupnvarchar20
TOPItaly
46PA3214HR Master Record: Infotype 3214269PERSKEmployee Subgroupnvarchar20
47T5ITMECurrent Yr Mun Surch Payment Exc Table (Fin Law 2007)4PERSKEmployee Subgroupnvarchar20
48T5ITQ8Cont.&coord. services codes for employee status/type3PERSKEmployee Subgroupnvarchar20
TOPJapan
49T5J03Person Group/Subgroup JP3PERSKEmployee Subgroupnvarchar20
TOPKorea
50T7KRR0Seniority allowance2PERSKEmployee Subgroupnvarchar20
TOPMaintenance Processing
51/MRSS/C_PREMKDummy table for creating Org. Assgnmnt Search Help (No Data)5PERSKEmployee Subgroupnvarchar20
TOPMalaysia
52T5L03Employee Subgroup grouping for Malaysia3PERSKEmployee Subgroupnvarchar20
TOPMexico
53T7MX03Assignment tax table to employee group/subgroup3PERSKEmployee Subgroupnvarchar20
TOPNon Profit Organizations
54T7UNPAD03Employee Group/Subgroup3PERSKEmployee Subgroupnvarchar20
55T7UNPAD_EG03NPO: Employee Group/Subgroup Eligibility3PERSKEmployee Subgroupnvarchar20
56T7UNPF_CATMCategory Code Mapping3PERSKEmployee Subgroupnvarchar20
TOPNorway
57T5V03Employee group/subgrouping for employment contracts (NO)3PERSKEmployee Subgroupnvarchar20
58T5V3AVacation allowance calculation5PERSKEmployee Subgroupnvarchar20
TOPPayroll
59PA0729Personál.kmen.záznam Infotyp 072928PERSKOkruh pracovníkunvarchar20
60PB0729Personál.kmen.záznam Infotyp 072928PERSKOkruh pracovníkunvarchar20
61T5H84Payroll log15PERSKEmployee Subgroupnvarchar20
62T5HPBS79Grouping of employee subgroups3PERSKEmployee Subgroupnvarchar20
63T5T03Personal groups/subgroups - extension3PERSKEmployee Subgroupnvarchar20
64T5TA1External transfers16PERSKEmployee Subgroupnvarchar20
65T5TA2Medium for health insurance19PERSKEmployee Subgroupnvarchar20
66T5TPSMKINDIdentifikace druhu zamestnaneckého pomeru & resortu5PERSKOkruh pracovníkunvarchar20
67T5TPSTXT01Formuláre infotypu 0729 - doplnku opatrení7PERSKOkruh pracovníkunvarchar20
68T5TPSTXT03Dynamické texty na formulári T5TPSTXT01 - pro infotyp 07294PERSKOkruh pracovníkunvarchar20
69T5TPSTXT05Názvy prímých doplnkových textu formuláru infotypu 07297PERSKOkruh pracovníkunvarchar20
70T7BG03EE Group/subgroup Groupings for Bulgaria3PERSKEmployee Subgroupnvarchar20
71T7RO03Employee group/subgrou Groupings Romania3PERSKEmployee Subgroupnvarchar20
72T7SK03Person group/person areas - enhancement3PERSKEmployee Subgroupnvarchar20
73T7SKA1External transfers16PERSKEmployee Subgroupnvarchar20
74T7TRG03Personel alani ve -altalani bazinda kidem grubu3PERSKÇalisan alt grubunvarchar20
75T7TRK03Wage and pay increase for higher duty5PERSKEmployee Subgroupnvarchar20
TOPPayroll General Parts
76HRPY_WPBPHR-PAY: Transparent Table WPBP17PERSKEmployee Subgroupnvarchar20
77PYORGSCREENPNP900 Selection Screen: Fields for Organizational Selection3PERSKEmployee Subgroupnvarchar20
TOPPension fund Netherlands
78T5NBGBerekeningsmethode (FAS/ALM interface)4PERSKMedewerkerssubgroepnvarchar20
TOPPersonnel Administration
79PA0001HR Master Record: Infotype 0001 (Org. Assignment)27PERSKEmployee Subgroupnvarchar20
80PA0016HR Master Record: Infotype 0016 (Contract Elements)42PERSKEmployee Subgroupnvarchar20
81T503Employee Group/Subgroup3PERSKEmployee Subgroupnvarchar20
82T503KEmployee subgroup2PERSKEmployee Subgroupnvarchar20
83T503TEmployee Subgroup Names3PERSKEmployee Subgroupnvarchar20
84T503ZCountry Assignment for Employee Group/Subgroup4PERSKEmployee Subgroupnvarchar20
85T529APersonnel Action Types6PERSKReserved Field/Unused Field of Length 2nvarchar20
86T7GR503Grouping for Employee Group-Subgroup3PERSKEmployee Subgroupnvarchar20
87T7SI03Skupina/podskupina zaposlenih SI3PERSKPodskupina zaposlenihnvarchar20
TOPPersonnel Management
88T7HR03Employee Group/Subgroup HR3PERSKEmployee Subgroupnvarchar20
TOPPortugal
89T5P03HR-PT: Employee Groups / Subgroups - Classification3PERSKEmployee Subgroupnvarchar20
TOPPosition Budgeting and Control
90HRFPM_BPREP_DATAPreprocesses Data for BPREP Data Extraction15PERSKEmployee Subgroupnvarchar20
TOPPreconfigured Systems
91ZHRBPJPT_SIIID6PERSK????nvarchar20
TOPProcess Controls -Automated Controls
92GRPCRTA_HRDA0011HR Master Record: Infotype 0011 (Ext.Bank Transfers)8PERSKEmployee Subgroupnvarchar20
93GRPCRTA_HRDA0045PC HR control data for infotype 0045 - Loan8PERSKEmployee Subgroupnvarchar20
94GRPCRTA_HRDA0078PC HR control data for infotype 0078 - Loan Payments8PERSKEmployee Subgroupnvarchar20
95GRPCRTA_HRDA0267PC HR control data for infotype 02678PERSKEmployee Subgroupnvarchar20
96GRPCRTA_HRDAT1PC HR control data for infotype 0014 and 00158PERSKEmployee Subgroupnvarchar20
97GRPCRTA_HRDAT2PC HR control data for infotype 0014 and 00158PERSKEmployee Subgroupnvarchar20
TOPPublic Sector
98PA0509HR-AU-PS: Master Data (Higher Duty Allowance)40PERSKEmployee subgroup of the higher duty positionnvarchar20
99PDPBSDNEUG_UEBCarried Over to DNeuG: General HR Master Record4PERSKEmployee Subgroupnvarchar20
100PDPBSTVOED_UEBTransfer to TVoeD: Personnel Master Record Before Transfer4PERSKEmployee Subgroupnvarchar20
101T5DPBS3CTransfer to TVoeD: Assignment EEGrp/Subgrp Old/New3PERSKEmployee Subgroupnvarchar20
102T5VPPS_TMATemporary Agreement codes4PERSKEmployee Subgroupnvarchar20
TOPRecruitment
103PB0001HR Master Record: Infotype 0001 (Org. Assignment)27PERSKEmployee Subgroupnvarchar20
104PB0016Applicant Master Record Infotype 0016 (Contract Elements)42PERSKEmployee Subgroupnvarchar20
TOPSingapore
105T5R1PRate for lump payment and CPF in case of semimonthly payroll5PERSKEmployee Subgroupnvarchar20
106T5R2CRate for CPF deduction by festival advance payment5PERSKEmployee Subgroupnvarchar20
TOPSouth Africa
107T5WRFNZA Tax and UIF reference number table5PERSKEmployee Subgroupnvarchar20
TOPStaffing
108HRP1013Infotype 1013 DB Table19PERSKEmployee Subgroupnvarchar20
109T77WSPerson Group/Subgroup per Work Schedule Group4PERSKEmployee Subgroupnvarchar20
110T77WTEmployee Group/Subgroup Assignment to Work Schedule Groups3PERSKEmployee Subgroupnvarchar20
TOPSweden
111T5S03Employee Group/Subgroup (SE)3PERSKEmployee Subgroupnvarchar20
112T5S7AAbsence Exception Rule - SE2PERSKEmployee Subgroupnvarchar20
113T5S7BAbsence exception rule text - SE3PERSKEmployee Subgroupnvarchar20
TOPSwitzerland
114T5C03Employee Group/Subgroup3PERSKEmployee Subgroupnvarchar20
115T5C3HHR-CH: Control of End of Year Bonus (13th Wage)3PERSKGrouping for year-end bonusnvarchar20
TOPTaiwan
116T7TW2IReported data of Tax withdrawal report10PERSKEmployee Subgroupnvarchar20
TOPThailand
117T7TH03Employee Group/Subgrouping for PF THAILAND3PERSKEmployee Subgroupnvarchar20
TOPWorkforce Management Application
118WFAEM_ESG_MAPMapping of HCM EmployeeSubgroup to WFM Default Setting Group4PERSKEmployee Subgroupnvarchar20
119WFAEM_PAY_MAPPay rate mapping table (HCM -> WFM)4PERSKEmployee Subgroupnvarchar20
120WFAEM_V503K_TEmployee Subgroup text table2PERSKEmployee Subgroupnvarchar20
121WFAEM_VAL503KEmployee Subgroup2PERSKEmployee Subgroupnvarchar20
TOPWorkforce Management Core
122WFMEM_V503K_TEmployee Subgroup text table2PERSKEmployee Subgroupnvarchar20
123WFMEM_VAL503KEmployee Subgroup2PERSKEmployee Subgroupnvarchar20