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

71 columns | Print definition?ERP 6.0  | V0ZNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1HRBW_REC_DT_NEWPY-XX-RECON : Country specific reports detailed results18V0ZNRVariable assignment numbervarbinary10
2P2BG_BG_CUXDifference table of payroll results13V0ZNRVariable assignment numbervarbinary10
3P2BG_BG_DIFDifference table of payroll results13V0ZNRVariable assignment numbervarbinary10
4P2CN_CNREIPayroll result: structure for retro difference details19V0ZNRVariable assignment numbervarbinary10
5P2CN_CNREOPayroll result: structure for retro difference details19V0ZNRVariable assignment numbervarbinary10
6P2CO_COAVAPC2CO_AVA33V0ZNRVariable assignment numbervarbinary10
7P2FI_GARGarnishment results Finland5V0ZNRVariable assignment numbervarbinary10
8P2HK_ENTHR-HK: Payroll structure for the MPF/ORSO Entitlement6V0ZNRVariable assignment numbervarbinary10
9P2HK_RETIPayroll structure for retroactive accounting21V0ZNRVariable assignment numbervarbinary10
10P2HK_RETOPayroll structure for retroactive accounting21V0ZNRVariable assignment numbervarbinary10
11P2IS_RETIPayroll structure for retroactive accounting21V0ZNRVariable assignment numbervarbinary10
12P2IS_RETOPayroll structure for retroactive accounting21V0ZNRVariable assignment numbervarbinary10
13P2KZ_FUPStructure for Table FUP - Future Periods17V0ZNRVariable assignment numbervarbinary10
14P2NZ_SALSACSalary Sacrifice Details18V0ZNRVariable assignment numbervarbinary10
15P2PL_RETROADJPayroll Result PL: Retro, originals and changes62V0ZNRVariable assignment numbervarbinary10
16P2PL_RETRODIFPayroll Result PL: Retro, originals and changes62V0ZNRVariable assignment numbervarbinary10
17P2PL_RETROMEMPayroll Result PL: Retro, originals and changes62V0ZNRVariable assignment numbervarbinary10
18P2RA_BZUPayroll Result: Organizational Assignments (A)6V0ZNRTax splitvarbinary10
19P2RA_DFRTPayroll Result for Other Payroll Periods19V0ZNRVariable assignment numbervarbinary10
20P2RB_BEEVLPayroll Results: Belgium table for Evaluation17V0ZNRVariable assignment numbervarbinary10
21P2RD_XITPayroll Results: Extended IT11V0ZNRVariable assignment numbervarbinary10
22P2RG_COSTSDistribution of Employer's Cost (Payroll Function XDEC)20V0ZNRVariable assignment numbervarbinary10
23P2RH_HU_GYERChildren data6V0ZNRVariable assignment numbervarbinary10
24P2RH_HU_HKIFP21PB16V0ZNRVariable assignment numbervarbinary10
25P2RH_HU_MEMBP21MB6V0ZNRVariable assignment numbervarbinary10
26P2RH_HU_NRENP21PA6V0ZNRVariable assignment numbervarbinary10
27P2RI_IPCUMRI cluster structure for cumulations (IPCUM)16V0ZNRVariable assignment numbervarbinary10
28P2RI_ITIOTRI cluster structure for retroactive accounting18V0ZNRVariable assignment numbervarbinary10
29P2RM_MLONHR-DK: Relationship between SAP Loans and PBS Wage Types5V0ZNRVariable assignment numbervarbinary10
30P2RO_RO_CUXDifference table of payroll results13V0ZNRVariable assignment numbervarbinary10
31P2RO_RO_DIFDifference table of payroll results13V0ZNRVariable assignment numbervarbinary10
32P2RP_SCRTHR-PT: Cumulated result table (Legal entity dependent)9V0ZNRVariable assignment numbervarbinary10
33P2RQ_HTPayroll Results: Results Table16V0ZNRVariable assignment numbervarbinary10
34P2RQ_NTPayroll Results: Results Table16V0ZNRVariable assignment numbervarbinary10
35P2RQ_SMTHSMTH and SQTR for Superannuation (Australia)16V0ZNRVariable assignment numbervarbinary10
36P2RQ_SQTRSMTH and SQTR for Superannuation (Australia)16V0ZNRVariable assignment numbervarbinary10
37P2RR_SRTPayroll Results: Results Table16V0ZNRVariable assignment numbervarbinary10
38P2RS_SEXCPayroll result: Exceptions (SE)6V0ZNRVariable assignment numbervarbinary10
39P2RS_SINLPayroll result: Garnishment (SE)6V0ZNRVariable assignment numbervarbinary10
40P2RS_SOPISPayroll result: OPIS (SE)6V0ZNRVariable assignment numbervarbinary10
41P2RU_COSTSDistribution of Employer's Cost (Payroll Function XDEC)20V0ZNRVariable assignment numbervarbinary10
42P2RX_ARRRSPayroll Results: Arrears Table12V0ZNRVariable assignment numbervarbinary10
43P2RX_CODISTDistribution opf Liabilities18V0ZNRVariable assignment numbervarbinary10
44P2RX_DDNTKPayroll Results: Deductions Not Effected8V0ZNRVariable assignment numbervarbinary10
45P2RX_GRTPayroll Results: Results Table16V0ZNRVariable assignment numbervarbinary10
46P2RX_RTPayroll Results: Results Table16V0ZNRVariable assignment numbervarbinary10
47P2RX_RT_PERSONResults Table (Person)20V0ZNRVariable assignment numbervarbinary10
48P2RX_V0Variable Assignment6V0ZNRVariable assignment numbervarbinary10
49P2TN_TWOTPayroll Results: Results Table16V0ZNRVariable assignment numbervarbinary10
50P2UA_FUPtable FUP - future periods17V0ZNRVariable assignment numbervarbinary10
51P2UA_UAILLstruc.UAILL - information about sick-list compensation calc.6V0ZNRVariable assignment numbervarbinary10
52P2UA_UARFStructure for Ukrainian social insurance(PF) calculation19V0ZNRVariable assignment numbervarbinary10
53P2UA_UARTPayroll Results: Results Table16V0ZNRVariable assignment numbervarbinary10
54P2UA_UATIStructure for Ukrainian social insurance(PF) calculation20V0ZNRVariable assignment numbervarbinary10
55P2UA_UATRStructure for Ukrainian social insurance(PF) calculation20V0ZNRVariable assignment numbervarbinary10
56P2UA_UATSStructure for Ukrainian social insurance(PF) calculation20V0ZNRVariable assignment numbervarbinary10
57P2UN_HTPayroll Results: Results Table16V0ZNRVariable assignment numbervarbinary10
58P2UN_NTPayroll Results: Results Table16V0ZNRVariable assignment numbervarbinary10
59P2UR_FUPtable FUP - future periods17V0ZNRVariable assignment numbervarbinary10
60P2UR_RURESRussian Statuses7V0ZNRVariable assignment numbervarbinary10
61P2UR_RURTPayroll Results: Results Table16V0ZNRVariable assignment numbervarbinary10
TOPAustria
62HRPAYAT_PAYRSRESSaves Wage Types from Simulated Payroll Results17V0ZNRVariable assignment numbervarbinary10
TOPCompany Pension Scheme Germany
63PDAVRTResult Table: Data for Future Pension Rights10V0ZNRVariable Assignmentnvarchar20
TOPDenmark
64T5M9HSplit Indicators for Wage Types Sent to PBS17V0ZNRVariable assignment numbervarbinary10
TOPGermany
65T5D0IFictitious Run Control: Wage Type Assignment21V0ZNRDelete Indicator for Number of Variable Assignmentnvarchar10
TOPInterface to External Payroll Systems
66T558ETransfer External Payroll-Arrears Results (International)7V0ZNRHR: Outsourcing: Variable assignment numbernvarchar20
TOPPayroll
67T7RO558_V0Transfer family members (supplement to T558D)5V0ZNRVariable assignment numbervarbinary10
TOPPayroll General Parts
68T558DTransfer Wage Types with Split Indicator15V0ZNRHR: Outsourcing: Variable assignment numbernvarchar20
TOPPersonnel Administration
69T7COT8Payroll external results transfer: COAVA33V0ZNRVariable assignment numbervarbinary10
TOPPersonnel Management
70/BKC/S21_RT_NEUC&T! - Table RT for the payroll comparison programs20V0ZNRVariable assignment numbervarbinary10
TOPTools
71T532BHR: Connection to Third-Party Payroll: Choice of Wage Types17V0ZNRComponent 709: Entry field for field selection in PC207nvarchar10