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

51 columns | Print definition?ERP 6.0  | ALZNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2B2_ABHCM Declustering B2 - Absences40ALZNRAssignment for alternative paymentvarbinary10
2P2B2_ALPHCM Declustering B2 - Alternative Payment Table ALP7ALZNRAssignment for alternative paymentvarbinary10
3P2B2_ZLHCM Declustering B2 - Time Wage Types (Table ZL)10ALZNRAssignment for alternative paymentvarbinary10
4P2BR_BRZLTime events in planned period6ALZNRAssignment for alternative paymentvarbinary10
5P2CN_CNREIPayroll result: structure for retro difference details14ALZNRAssignment for alternative paymentvarbinary10
6P2CN_CNREOPayroll result: structure for retro difference details14ALZNRAssignment for alternative paymentvarbinary10
7P2CO_COAVAPC2CO_AVA28ALZNRAssignment for alternative paymentvarbinary10
8P2HK_RETIPayroll structure for retroactive accounting16ALZNRAssignment for alternative paymentvarbinary10
9P2HK_RETOPayroll structure for retroactive accounting16ALZNRAssignment for alternative paymentvarbinary10
10P2IS_RETIPayroll structure for retroactive accounting16ALZNRAssignment for alternative paymentvarbinary10
11P2IS_RETOPayroll structure for retroactive accounting16ALZNRAssignment for alternative paymentvarbinary10
12P2NZ_SALSACSalary Sacrifice Details13ALZNRAssignment for alternative paymentvarbinary10
13P2RA_DFRTPayroll Result for Other Payroll Periods14ALZNRAssignment for alternative paymentvarbinary10
14P2RB_BEEVLPayroll Results: Belgium table for Evaluation12ALZNRAssignment for alternative paymentvarbinary10
15P2RD_XITPayroll Results: Extended IT8ALZNRAssignment for alternative paymentvarbinary10
16P2RF_ZLPTime Wage Types (Table ZL)8ALZNRAssignment for alternative paymentvarbinary10
17P2RH_HU_HKIFP21PB11ALZNRAssignment for alternative paymentvarbinary10
18P2RI_IPCUMRI cluster structure for cumulations (IPCUM)11ALZNRAssignment for alternative paymentvarbinary10
19P2RI_ITIOTRI cluster structure for retroactive accounting13ALZNRAssignment for alternative paymentvarbinary10
20P2RP_OVTime Wage Types (Table ZL)8ALZNRAssignment for alternative paymentvarbinary10
21P2RQ_HTPayroll Results: Results Table11ALZNRAssignment for alternative paymentvarbinary10
22P2RQ_NTPayroll Results: Results Table11ALZNRAssignment for alternative paymentvarbinary10
23P2RQ_SMTHSMTH and SQTR for Superannuation (Australia)11ALZNRAssignment for alternative paymentvarbinary10
24P2RQ_SQTRSMTH and SQTR for Superannuation (Australia)11ALZNRAssignment for alternative paymentvarbinary10
25P2RR_RMPayroll Results: Table for Master data (SG)64ALZNRAssignment for alternative paymentvarbinary10
26P2RR_SRTPayroll Results: Results Table11ALZNRAssignment for alternative paymentvarbinary10
27P2RU_TAXPRAuthorities tax prorates17ALZNRAssignment for alternative paymentvarbinary10
28P2RX_ABCluster RD/B2: Table AB38ALZNRAssignment for alternative paymentvarbinary10
29P2RX_ALPAlternative Payment Table ALP5ALZNRAssignment for alternative paymentvarbinary10
30P2RX_CODISTDistribution opf Liabilities13ALZNRAssignment for alternative paymentvarbinary10
31P2RX_GRTPayroll Results: Results Table11ALZNRAssignment for alternative paymentvarbinary10
32P2RX_RTPayroll Results: Results Table11ALZNRAssignment for alternative paymentvarbinary10
33P2RX_RT_PERSONResults Table (Person)15ALZNRAssignment for alternative paymentvarbinary10
34P2TN_TWOTPayroll Results: Results Table11ALZNRAssignment for alternative paymentvarbinary10
35P2UA_UARFStructure for Ukrainian social insurance(PF) calculation14ALZNRAssignment for alternative paymentvarbinary10
36P2UA_UARTPayroll Results: Results Table11ALZNRAssignment for alternative paymentvarbinary10
37P2UA_UATIStructure for Ukrainian social insurance(PF) calculation15ALZNRAssignment for alternative paymentvarbinary10
38P2UA_UATRStructure for Ukrainian social insurance(PF) calculation15ALZNRAssignment for alternative paymentvarbinary10
39P2UA_UATSStructure for Ukrainian social insurance(PF) calculation15ALZNRAssignment for alternative paymentvarbinary10
40P2UN_HTPayroll Results: Results Table11ALZNRAssignment for alternative paymentvarbinary10
41P2UN_NTPayroll Results: Results Table11ALZNRAssignment for alternative paymentvarbinary10
42P2UR_RURTPayroll Results: Results Table11ALZNRAssignment for alternative paymentvarbinary10
TOPAustria
43HRPAYAT_PAYRSRESSaves Wage Types from Simulated Payroll Results12ALZNRAssignment for alternative paymentvarbinary10
TOPDenmark
44T5M9HSplit Indicators for Wage Types Sent to PBS12ALZNRAssignment for alternative paymentvarbinary10
TOPGermany
45T5D0IFictitious Run Control: Wage Type Assignment16ALZNRDelete Indicator for Split for Alternative Paymentnvarchar10
TOPPayroll
46T5T558_ABHRCZ - Tabulka pro prenos neprítomností pri upgrade na SAP37ALZNRPrirazení alternativní platbyvarbinary10
47T7SK558_ABTransfer absences (supplement to T558D) - SK37ALZNRAssignment for alternative paymentvarbinary10
TOPPayroll General Parts
48T558DTransfer Wage Types with Split Indicator10ALZNRHR: Outsourcng: Pointer to alternative paymentnvarchar20
TOPPersonnel Administration
49T7COT8Payroll external results transfer: COAVA28ALZNRAssignment for alternative paymentvarbinary10
TOPPersonnel Management
50/BKC/S21_RT_NEUC&T! - Table RT for the payroll comparison programs15ALZNRAssignment for alternative paymentvarbinary10
TOPTools
51T532BHR: Connection to Third-Party Payroll: Choice of Wage Types12ALZNRComponent 709: Entry field for field selection in PC207nvarchar10