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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

145 columns | Print definition?ERP 6.0  | FPPER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVHCM_COMPARLOGTDMS4HCM: Protocoll information for payroll compare5FPPERTDMS4HCM: For-period for payrollnvarchar60
2HRBW_REC_DTPY-XX-RECON : Country specific reports detailed results7FPPERFor-period for payrollnvarchar60
3HRBW_REC_DT_NEWPY-XX-RECON : Country specific reports detailed results8FPPERFor-period for payrollnvarchar60
4HRDCT_TPY_RGDIRDeclustering - Directory for Test Payroll Results7FPPERFor-period for payrollnvarchar60
5HRPADDE_D_DN_CIDest. Rep. Data: Const. "Business Complete" Information4FPPERFor-Period for Evaluation for Social Fund Procedurenvarchar60
6P01PF_PFBB_DIRPO Rebuild: Transfer Garnishable Amount Directly5FPPERFor-period for garnishmentnvarchar60
7P2CN_CNREIPayroll result: structure for retro difference details5FPPERFor-period for payrollnvarchar60
8P2CN_CNREOPayroll result: structure for retro difference details5FPPERFor-period for payrollnvarchar60
9P2CO_COAVAPC2CO_AVA10FPPERFor-period for payrollnvarchar60
10P2CO_COBTRPC2CO_BTR20FPPERFor-period for payrollnvarchar60
11P2CO_COGARPC2CO_GAR18FPPERFor-period for garnishmentnvarchar60
12P2CO_COSSAPC2CO_SSA11FPPERFor-period for payrollnvarchar60
13P2NZ_EMSPayroll Result: Employer Monthly Schedule - NZ9FPPERFor-period for payrollnvarchar60
14P2PL_ZLABASEResults of PLZLA operation6FPPERFor-period for garnishmentnvarchar60
15P2RA_DFRTPayroll Result for Other Payroll Periods5FPPERFor-period for payrollnvarchar60
16P2RG_NIPAYNiable Pay5FPPERFor-period for payrollnvarchar60
17P2RG_WEARNNI: payment history of affected wagetype6FPPERFor-period for payrollnvarchar60
18P2RH_HU_NRBEIrregular incomes from infotype 32346FPPERFor-period for payrollnvarchar60
19P2RN_NARGPayroll Results: Add. Terms of Employment15FPPERFuture Payment Periodnvarchar60
20P2RU_BALPayroll Results: Tax Retro Differences -(USA)12FPPERFor-period for payrollnvarchar60
21P2RU_CLMOverpayments Processing structure7FPPERFor-period for payrollnvarchar60
22P2RU_CLM_PERSONOverpayments Processing structure9FPPERFor-period for payrollnvarchar60
23P2RU_DFRTPayroll Results: Retroaccounting Differences -DFRT- (USA)6FPPERFor-period for payrollnvarchar60
24P2RU_DNRCTPayroll Results: Retro Differences 1042S -DNRCT- (USA)8FPPERFor-period for payrollnvarchar60
25P2RU_UNBPayroll Results: Tax Retro Differences -(USA)12FPPERFor-period for payrollnvarchar60
26P2RU_XDFRTPayroll Results: Tax Retro Differences -(USA)12FPPERFor-period for payrollnvarchar60
27P2RX_EVAL_PERIODIndex for Payroll Results Periods11FPPERFor-period for garnishmentnvarchar60
28P2RX_VERSCPayroll Status Information24FPPERFor-period for payrollnvarchar60
29PA9220HR Master Record: Infotype 922028FPPERFor-period for payrollnvarchar60
30PA9390Personal-Stammsatz Infotyp 939028FPPERFürperiode der Abrechnungnvarchar60
31PA9429Registro maestro de personal Infotipo 942928FPPERPeríodo para de la nóminanvarchar60
32PA9640Personal-Stammsatz Infotyp 964028FPPERFürperiode der Abrechnungnvarchar60
33PA9701Personal-Stammsatz Infotyp 970128FPPERFürperiode der Abrechnungnvarchar60
34PA9725HR Master Record: Infotype 972528FPPERFor-period for payrollnvarchar60
35PA9741HR Master Record: Infotype 974128FPPERFor-period for payrollnvarchar60
36PA9742HR Master Record: Infotype 974228FPPERFor-period for payrollnvarchar60
37PA9825HR Master Record: Infotype 982528FPPERFor-period for payrollnvarchar60
38PA9990HR Master Record: Infotype 999028FPPERFor-period for payrollnvarchar60
39PA9991HR Master Record: Infotype 999128FPPERFor-period for payrollnvarchar60
40PA9992HR Master Record: Infotype 999228FPPERFor-period for payrollnvarchar60
41PA9993HR Master Record: Infotype 999328FPPERFor-period for payrollnvarchar60
42PA9995HR Master Record: Infotype 999528FPPERFor-period for payrollnvarchar60
43PA9996HR Master Record: Infotype 999628FPPERFor-period for payrollnvarchar60
44PA9997HR Master Record: Infotype 999728FPPERFor-period for payrollnvarchar60
45PA9998HR Master Record: Infotype 999828FPPERFor-period for payrollnvarchar60
46T5FDSNAB_FRTemp table for PAYFR_RESULT-AB_FR3FPPERFor-period for payrollnvarchar60
47T5FDSNACTITemp table for PAYFR_RESULT-ACTI3FPPERPériode recalculée de la paienvarchar60
48T5FDSNCTTemp table for PAYFR_RESULT-CT3FPPERPériode recalculée de la paienvarchar60
49T5FDSNFPERSTemp table for PAYFR_RESULT-FPERS3FPPERFor-period for payrollnvarchar60
50T5FDSNPAYMTemp table for PAYFR_RESULT-PAYM3FPPERPériode recalculée de la paienvarchar60
51T5FDSNREMTemp table for PAYFR_RESULT-REM3FPPERPériode recalculée de la paienvarchar60
52T5FDSNSUSPENSIONTemp table for PAYFR_RESULT-SUSPENSION3FPPERFor-period for payrollnvarchar60
53T5Q_SUPERSTREAMSuper Stream Master Table9FPPERFor-period for garnishmentnvarchar60
54T5TPENSAVData for pension savings4FPPERReported for periodnvarchar60
55T5TPENSAV_YSPension savings - annual reporting4FPPERReported for periodnvarchar60
56T77PAYKZBTBank Transfer Table Image (BTKZ)9FPPERFor-period for payrollnvarchar60
57T7CNREW_APRPARSPayroll result master table4FPPERFor-period for payrollnvarchar60
58T7ROA8Contr. G - Deducted Amount5FPPERFor-period for payrollnvarchar60
TOPArgentina
59T7AR28Assignment of SIJP periods to settled payrolls10FPPERFor-period for payrollnvarchar60
TOPAustria
60HRPAYAT_PAYRSRESSaves Wage Types from Simulated Payroll Results6FPPERFor-period for payrollnvarchar60
61PA3233HR Master Record: Infotype 323350FPPERFor-Period for Lists (PP.YYYY)nvarchar70
TOPBenefit Integration
62PA0496Payroll Infotype: US Benefits Data - Per Pay Period28FPPERFor-period for payrollnvarchar60
63PA0497Payroll Infotype: US Benefits Data - MTD28FPPERFor-period for payrollnvarchar60
64PA0498Payroll Infotype: US Benefits Data - QTD28FPPERFor-period for payrollnvarchar60
65PA0499Payroll Infotype: US Benefits Data - YTD28FPPERFor-period for payrollnvarchar60
66PA0500Payroll Infotype: US Benefits Data in Arrears (ARRRS)28FPPERFor-period for payrollnvarchar60
67PA0501Payroll Infotype: US Benefits Data in Ded Not Taken (DDNTK)28FPPERFor-period for payrollnvarchar60
TOPChina
68T7CN3FReported Tax Data6FPPERFor-period for payrollnvarchar60
TOPConstruction Industry
69PDBKADCI: Social Fund Procedure: Records Management4FPPERFor-Period for Evaluation for Social Fund Procedurenvarchar60
70PDBKANConstruction Industry Social Fund Proced: ANMEL Data Records4FPPERFor-Period for Evaluation for Social Fund Procedurenvarchar60
71PDBKAUConstruction Industry Social Fund Proced: AUMEL Data Records4FPPERFor-Period for Evaluation for Social Fund Procedurenvarchar60
72PDBKBEConstr. Ind. Social Fund Procedure: BEMEL (PerNo) Records4FPPERFor-Period for Evaluation for Social Fund Procedurenvarchar60
73PDBKBESUMConstr. Ind. Social Fund Procedure: BEMEL Records (Total)4FPPERFor-Period for Evaluation for Social Fund Procedurenvarchar60
74PDBKLOConstruction Industry Social Fund Proced: LOMEL Data Records4FPPERFor-Period for Evaluation for Social Fund Procedurenvarchar60
75PDBKNEConstruction Industry Social Fund Proced: NEMEL Data Records4FPPERFor-Period for Evaluation for Social Fund Procedurenvarchar60
76PDBKNWConstruction Industry Social Fund Proced: Employee Statement4FPPERFor-Period for Evaluation for Social Fund Procedurenvarchar60
77PDBKRAConstruction Industry Social Fund Proced: RAMEL Data Records4FPPERFor-Period for Evaluation for Social Fund Procedurenvarchar60
78PDBKURConstruction Industry Social Fund Proced: URMEL Data Records4FPPERFor-Period for Evaluation for Social Fund Procedurenvarchar60
TOPGarnishmentCession
79P01PF_RT_EPGarnishment Pr. of Origin: Results of Garnishment Calc.4FPPERFor-period for garnishmentnvarchar60
TOPGreat Britain
80T5BUKTPersonnel numbers for AHP process model4FPPERFor-period for payrollnvarchar60
TOPIndia
81T7INTEForm 24Q - TAN number lock3FPPERFor-period for payrollnvarchar60
TOPItaly
82T5ITPOS_AHeader table for traceability4FPPERFor-period for payrollnvarchar60
TOPJapan
83PA3239HR Master Record: Infotype 323928FPPERFor-period for payrollnvarchar60
TOPNew Zealand
84HNZLVPAYTable for modified LVPAY cluster table records3FPPERFor-period for payrollnvarchar60
TOPNorway
85T5V3AVacation allowance calculation7FPPERPeriod for payment of holiday allowancenvarchar20
86T5V3EHoliday allowance: Payment5FPPERPeriod for payment of holiday allowancenvarchar20
TOPPayroll
87T5HNRHU_NREN payroll table data of the "current month"4FPPERFor-period for payrollnvarchar60
88T5HS1HR-H: Havi bevallás - bevallási adatok5FPPERBérszámfejtés vonatkoztatási periódusanvarchar60
89T5HS4HR-H: Havi bevallás - Élesben futtatott hónapok (bárkód)4FPPERBérszámfejtés vonatkoztatási periódusanvarchar60
90T5HS7HR-H: Havi bevallás - bevallási adatok - adózónként4FPPERBérszámfejtés vonatkoztatási periódusanvarchar60
91T5HS8HR-H: Havi bevallás - adózót terhelo egyéb kötelezettségek4FPPERBérszámfejtés vonatkoztatási periódusanvarchar60
92T5HSE12. lap Önellenorzés4FPPERBérszámfejtés vonatkoztatási periódusanvarchar60
93T5HSHHR-H: Havi bevallás - Kijelölés helyesbítésre4FPPERBérszámfejtés vonatkoztatási periódusanvarchar60
94T5HSJHavi bevallás - bevallási adatok - munkavállalónként5FPPERBérszámfejtés vonatkoztatási periódusanvarchar60
95T5HSKHavi bevallás - külso bevallási adatok - adózónként4FPPERBérszámfejtés vonatkoztatási periódusanvarchar60
96T5HSMHavi bevallás - külso bevallási adatok magánszemély (I.né)5FPPERBérszámfejtés vonatkoztatási periódusanvarchar60
97T5HSNHavi bevallás - külso bevallási adatok - adózó (I.né)4FPPERBérszámfejtés vonatkoztatási periódusanvarchar60
98T5HSRHR-H: Havi bevallás - nemnegatív járulékbérelemek4FPPERBérszámfejtés vonatkoztatási periódusanvarchar60
99T5HSSHavi bevallás - külso-belso adatok összesítve - adózó4FPPERBérszámfejtés vonatkoztatási periódusanvarchar60
100T5HSTHavi bevallás- külso-belso adatok összesítve - személy5FPPERBérszámfejtés vonatkoztatási periódusanvarchar60
101T5HSVHR-H: Havi bevallás - bevallási adatok (negyedéves)5FPPERBérszámfejtés vonatkoztatási periódusanvarchar60
102T5HSWHR-H: Havi bevallás - bevallási adatok - adózó (n.éves)4FPPERBérszámfejtés vonatkoztatási periódusanvarchar60
103T5HSXHavi bevallás - külso-belso adatok összesítve adózó I. né4FPPERBérszámfejtés vonatkoztatási periódusanvarchar60
104T5HSYHavi bevallás- külso-belso adatok összesítve személy I.né5FPPERBérszámfejtés vonatkoztatási periódusanvarchar60
105T5HV4Élesben futtatott hónapok (BAR-kód) (havi adóbevallás)4FPPERBérszámfejtés vonatkoztatási periódusanvarchar60
106T5HV7Bevallási adatok adózónként (havi adóbevallás)4FPPERBérszámfejtés vonatkoztatási periódusanvarchar60
107T5HV8Vállalati összesíto egyéb adatok (havi bevallás)4FPPERBérszámfejtés vonatkoztatási periódusanvarchar60
108T5HVHKijelölés helyesbítésre (havi bevallás)4FPPERBérszámfejtés vonatkoztatási periódusanvarchar60
109T5HVKKülso bevallási adatok adózónként (havi bevallás)4FPPERBérszámfejtés vonatkoztatási periódusanvarchar60
110T5HVRNemnegatív járulékbérelemek (havi bevallás)4FPPERBérszámfejtés vonatkoztatási periódusanvarchar60
111T7ROA3Insurance result table - Person 1:1 with RGDIR9FPPERFor-period for payrollnvarchar60
112T7ROA6Contr. H - received/deducted amount from the authorities2FPPERFor-period for payrollnvarchar60
113T7SIREK11AState for REK field 011a3FPPERZa obdobje - za placonvarchar60
TOPPayroll General Parts
114HRPY_RGDIRDirectory for Payroll Results5FPPERFor-period for payrollnvarchar60
115HRPY_RGDIR_TEMPInternal TEMPORARY Directory for Payroll Results5FPPERFor-period for payrollnvarchar60
116PYNOSCREENSelection Screen Fields (Only as Interface)3FPPERFor-period for garnishmentnvarchar60
TOPPersonnel Administration
117PA0402HR Master Data Infotype 040228FPPERFor-period for payrollnvarchar60
118PA0403HR Master Record for Infotype 040328FPPERFor-period for payrollnvarchar60
119T7COT2Payroll external results transfer: COSSA11FPPERFor-period for payrollnvarchar60
120T7COT5Payroll external results transfer: COBTR20FPPERFor-period for payrollnvarchar60
121T7COT6Payroll external results transfer: COGAR18FPPERFor-period for garnishmentnvarchar60
122T7COT8Payroll external results transfer: COAVA10FPPERFor-period for payrollnvarchar60
TOPPersonnel Management
123/BKC/S21_EVSol21: Vergleich von Abrechnungsergebnissen3FPPERFürperiode der Abrechnungnvarchar60
124/BKC/S21_EV1Sol21: Vergleich von Abrechnungsergebnissen - ohne PERNR.2FPPERFürperiode der Abrechnungnvarchar60
125/BKC/S21_RTC&T! - Table RT for the payroll comparison programs3FPPERFor-period for payrollnvarchar60
126/BKC/S21_RT_NEUC&T! - Table RT for the payroll comparison programs3FPPERFor-period for payrollnvarchar60
127/BKC/S21_RT_NOPNC&T! - Table RT for the payroll comparison programs2FPPERFor-period for payrollnvarchar60
TOPPublic Sector
128PDPBSZVADMAdministration Table for ZVE-PBS Notification Procedure10FPPERFor-Period for Payrollnvarchar60
TOPSweden
129T5SVTPayroll Account Transfer for Capacity utilization level8FPPERFor-period for payrollnvarchar60
TOPUSA
130PA044628FPPERnvarchar60
131PA0447US Federal Tax MTD28FPPERFor-period for payrollnvarchar60
132PA0448US Federal Tax QTD28FPPERFor-period for payrollnvarchar60
133PA0449HR Master Record: Infotype 044928FPPERFor-period for payrollnvarchar60
134PA0450HR Master Record: Infotype 045028FPPERFor-period for payrollnvarchar60
135PA0451HR Master Record: Infotype 045128FPPERFor-period for payrollnvarchar60
136PA0452HR Master Record: Infotype 045228FPPERFor-period for payrollnvarchar60
137PA0453HR Master Record: Infotype 045328FPPERFor-period for payrollnvarchar60
138PA0454HR Master Record: Infotype 045428FPPERFor-period for payrollnvarchar60
139PA0455HR Master Record: Infotype 045528FPPERFor-period for payrollnvarchar60
140PA0456HR Master Record: Infotype 045628FPPERFor-period for payrollnvarchar60
141PA0457HR Master Record: Infotype 045728FPPERFor-period for payrollnvarchar60
142PA0458HR Master Record for Infotype 045828FPPERFor-period for payrollnvarchar60
143PA0459HR Master Record for Infotype 045928FPPERFor-period for payrollnvarchar60
144PA0460HR Master Record for Infotype 046028FPPERFor-period for payrollnvarchar60
145PA0909HR Master Record: Infotype 090928FPPERFor-period for payrollnvarchar60