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

90 columns | Print definition?ERP 6.0  | BETPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2AR_ARCIMPTax results10BETPEPayroll: Amount per unitdecimal152
2P2BG_BG_CUXDifference table of payroll results14BETPEPayroll: Amount per unitdecimal152
3P2BG_BG_DIFDifference table of payroll results14BETPEPayroll: Amount per unitdecimal152
4P2BR_BRAVERAGEFrozen averages9BETPEPayroll: Amount per unitdecimal152
5P2CN_CNREIPayroll result: structure for retro difference details21BETPEPayroll: Amount per unitdecimal152
6P2CN_CNREOPayroll result: structure for retro difference details21BETPEPayroll: Amount per unitdecimal152
7P2CO_COAVAPC2CO_AVA35BETPEPayroll: Amount per unitdecimal152
8P2FI_SCRTTax result table for Finland, cumulated wage type level8BETPEPayroll: Amount per unitdecimal152
9P2FI_SIRTSI result table for Finland, cumulated wage type level8BETPEPayroll: Amount per unitdecimal152
10P2HK_RETIPayroll structure for retroactive accounting23BETPEPayroll: Amount per unitdecimal152
11P2HK_RETOPayroll structure for retroactive accounting23BETPEPayroll: Amount per unitdecimal152
12P2HR_CUFStructure of difference table Croatia8BETPEPayroll: Amount per unitdecimal152
13P2HR_CUPStructure of difference table Croatia8BETPEPayroll: Amount per unitdecimal152
14P2HR_DTFStructure of difference table Croatia8BETPEPayroll: Amount per unitdecimal152
15P2HR_DTPStructure of difference table Croatia8BETPEPayroll: Amount per unitdecimal152
16P2HR_HR_CUXStructure of difference table for tax calculation7BETPEPayroll: Amount per unitdecimal152
17P2HR_HR_DPAStructure of difference table for tax calculation7BETPEPayroll: Amount per unitdecimal152
18P2IS_RETIPayroll structure for retroactive accounting23BETPEPayroll: Amount per unitdecimal152
19P2IS_RETOPayroll structure for retroactive accounting23BETPEPayroll: Amount per unitdecimal152
20P2KZ_FUPStructure for Table FUP - Future Periods18BETPEPayroll: Amount per unitdecimal152
21P2KZ_KZAVCumulations for Calculation of Averages14BETPEPayroll: Amount per unitdecimal152
22P2NZ_SALSACSalary Sacrifice Details20BETPEPayroll: Amount per unitdecimal152
23P2RA_DFRTPayroll Result for Other Payroll Periods21BETPEPayroll: Amount per unitdecimal152
24P2RB_DAYDETDaydetails for payroll outsourcing (B)11BETPEPayroll: Amount per unitdecimal152
25P2RC_WHTPPC2CH0210BETPEPayroll: Amount per unitdecimal152
26P2RD_XITPayroll Results: Extended IT17BETPEPayroll: Amount per unitdecimal152
27P2RH_HU_HKIFP21PB18BETPEPayroll: Amount per unitdecimal152
28P2RI_IPCUMRI cluster structure for cumulations (IPCUM)18BETPEPayroll: Amount per unitdecimal152
29P2RI_ITIOTRI cluster structure for retroactive accounting20BETPEPayroll: Amount per unitdecimal152
30P2RJ_HEITPayroll Results: Hei Ran Results Table7BETPEPayroll: Amount per unitdecimal152
31P2RK_WTDTPayroll Results - Wage type processing information9BETPEPayroll: Amount per unitdecimal152
32P2RO_RO_CUXDifference table of payroll results14BETPEPayroll: Amount per unitdecimal152
33P2RO_RO_DIFDifference table of payroll results14BETPEPayroll: Amount per unitdecimal152
34P2RP_MFHR-PT: Payroll Results: Membership fees13BETPEPayroll: Amount per unitdecimal152
35P2RQ_HTPayroll Results: Results Table18BETPEPayroll: Amount per unitdecimal152
36P2RQ_NTPayroll Results: Results Table18BETPEPayroll: Amount per unitdecimal152
37P2RQ_SMTHSMTH and SQTR for Superannuation (Australia)18BETPEPayroll: Amount per unitdecimal152
38P2RQ_SQTRSMTH and SQTR for Superannuation (Australia)18BETPEPayroll: Amount per unitdecimal152
39P2RR_CAWPayroll Results: Table for CPF on AW/SG9BETPEPayroll: Amount per unitdecimal152
40P2RR_SRTPayroll Results: Results Table18BETPEPayroll: Amount per unitdecimal152
41P2RX_AVERAGEFrozen Average Values in Payroll Result8BETPEPayroll: Amount per unitdecimal152
42P2RX_DFTPayroll Results: Differences for Gross/Net Payroll9BETPEPayroll: Amount per unitdecimal152
43P2RX_GRTPayroll Results: Results Table18BETPEPayroll: Amount per unitdecimal152
44P2RX_LSPayroll Results: Subsequent Time Tickets13BETPEPayroll: Amount per unitdecimal152
45P2RX_RTPayroll Results: Results Table18BETPEPayroll: Amount per unitdecimal152
46P2RX_RT_GPPayroll Result: Payroll for Global Employees9BETPEPayroll: Amount per unitdecimal152
47P2RX_RT_PERSONResults Table (Person)22BETPEPayroll: Amount per unitdecimal152
48P2SI_CUFDifference table of payroll results8BETPEPayroll: Amount per unitdecimal152
49P2SI_CUPDifference table of payroll results8BETPEPayroll: Amount per unitdecimal152
50P2SI_DTFDifference table of payroll results8BETPEPayroll: Amount per unitdecimal152
51P2SI_DTPDifference table of payroll results8BETPEPayroll: Amount per unitdecimal152
52P2TN_TWOTPayroll Results: Results Table18BETPEPayroll: Amount per unitdecimal152
53P2UA_FUPtable FUP - future periods18BETPEPayroll: Amount per unitdecimal152
54P2UA_UAAVHR-PAY: Cumulations for calculation of averages12BETPEPayroll: Amount per unitdecimal152
55P2UA_UAILLstruc.UAILL - information about sick-list compensation calc.14BETPEPayroll: Amount per unitdecimal152
56P2UA_UARFStructure for Ukrainian social insurance(PF) calculation21BETPEPayroll: Amount per unitdecimal152
57P2UA_UARTPayroll Results: Results Table18BETPEPayroll: Amount per unitdecimal152
58P2UA_UATIStructure for Ukrainian social insurance(PF) calculation22BETPEPayroll: Amount per unitdecimal152
59P2UA_UATRStructure for Ukrainian social insurance(PF) calculation22BETPEPayroll: Amount per unitdecimal152
60P2UA_UATSStructure for Ukrainian social insurance(PF) calculation22BETPEPayroll: Amount per unitdecimal152
61P2UN_HTPayroll Results: Results Table18BETPEPayroll: Amount per unitdecimal152
62P2UN_NTPayroll Results: Results Table18BETPEPayroll: Amount per unitdecimal152
63P2UR_FUPtable FUP - future periods18BETPEPayroll: Amount per unitdecimal152
64P2UR_RUAVECumulations for calculation of averages12BETPEPayroll: Amount per unitdecimal152
65P2UR_RURTPayroll Results: Results Table18BETPEPayroll: Amount per unitdecimal152
66T5H85Bérszámfejtés elozmények7BETPEBérszámfejtés: egységenkénti összegdecimal152
TOPAustria
67HRPAYAT_PAYRSRESSaves Wage Types from Simulated Payroll Results19BETPEPayroll: Amount per unitdecimal152
TOPBelgium
68PA3207Personal-Stammsatz Infotyp 320735BETPERate for external datadecimal152
TOPCanada
69T5K8CTransfer ext. payroll results into Canadian specific tables9BETPEPayroll: Amount per unitdecimal152
70T5U8CTransfer external payroll results (USA)9BETPEPayroll: Amount per unitdecimal152
TOPChina
71T7CNSTCN: Last Result of Simulate Termination Payment for Labor WB5BETPEPayroll: Amount per unitdecimal152
TOPDenmark
72T5M58SAP-PBS Interface: Transfer Payroll Account (DK)11BETPEPayroll: Amount per unitdecimal152
73T5M58_OLD!!Do Not Use (Copy of T5M58)8BETPEPayroll: Amount per unitdecimal152
74T5M8PSAP-PBS interface: Transfer year-end values7BETPEPayroll: Amount per unitdecimal152
75T5M9ASAP-PBS Interface: Transfer of New Year Values7BETPEPayroll: Amount per unitdecimal152
76T5M9BSAP-PBS: Year End Values (Revision)8BETPEPayroll: Amount per unitdecimal152
77T5M9CSAP-PBS Interface: New Year Values (Revision)8BETPEPayroll: Amount per unitdecimal152
TOPPayroll
78T7ROA3Insurance result table - Person 1:1 with RGDIR5BETPEPayroll: Amount per unitdecimal152
79T7SKA4Pomocná tabulka HRSK6BETPEZúctov.miezd a platov: Ciastka na jednotkudecimal152
TOPPayroll General Parts
80T558AOld Payroll Account Transfer7BETPEPayroll: Amount per unitdecimal152
81T558CPayroll Account Transfer: Old Wage Types7BETPEPayroll: Amount per unitdecimal152
82T558DTransfer Wage Types with Split Indicator18BETPEPayroll: Amount per unitdecimal152
TOPPersonnel Administration
83T7COT8Payroll external results transfer: COAVA35BETPEPayroll: Amount per unitdecimal152
TOPPersonnel Management
84/BKC/S21_EVSol21: Vergleich von Abrechnungsergebnissen7BETPEPersonalabrechnung: Betrag pro Einheitdecimal152
85/BKC/S21_EV1Sol21: Vergleich von Abrechnungsergebnissen - ohne PERNR.6BETPEPersonalabrechnung: Betrag pro Einheitdecimal152
86/BKC/S21_RTC&T! - Table RT for the payroll comparison programs8BETPEPayroll: Amount per unitdecimal152
87/BKC/S21_RT_NEUC&T! - Table RT for the payroll comparison programs10BETPEPayroll: Amount per unitdecimal152
88/BKC/S21_RT_NOPNC&T! - Table RT for the payroll comparison programs7BETPEPayroll: Amount per unitdecimal152
TOPTools
89PA0579HR Master Record Infotype 0579 (Ext. Wage Components)30BETPEPayroll: Amount per unitdecimal152
90T532BHR: Connection to Third-Party Payroll: Choice of Wage Types19BETPEComponent 709: Entry field for field selection in PC207nvarchar10