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

72 columns | Print definition?ERP 6.0  | V0TYP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1HRBW_REC_DT_NEWPY-XX-RECON : Country specific reports detailed results17V0TYPVariable assignment typenvarchar10
2P2BG_BG_CUXDifference table of payroll results12V0TYPVariable assignment typenvarchar10
3P2BG_BG_DIFDifference table of payroll results12V0TYPVariable assignment typenvarchar10
4P2CN_CNREIPayroll result: structure for retro difference details18V0TYPVariable assignment typenvarchar10
5P2CN_CNREOPayroll result: structure for retro difference details18V0TYPVariable assignment typenvarchar10
6P2CO_COAVAPC2CO_AVA32V0TYPVariable assignment typenvarchar10
7P2HK_ENTHR-HK: Payroll structure for the MPF/ORSO Entitlement5V0TYPVariable assignment typenvarchar10
8P2HK_RETIPayroll structure for retroactive accounting20V0TYPVariable assignment typenvarchar10
9P2HK_RETOPayroll structure for retroactive accounting20V0TYPVariable assignment typenvarchar10
10P2IS_RETIPayroll structure for retroactive accounting20V0TYPVariable assignment typenvarchar10
11P2IS_RETOPayroll structure for retroactive accounting20V0TYPVariable assignment typenvarchar10
12P2KZ_FUPStructure for Table FUP - Future Periods16V0TYPVariable assignment typenvarchar10
13P2NZ_SALSACSalary Sacrifice Details17V0TYPVariable assignment typenvarchar10
14P2PL_RETROADJPayroll Result PL: Retro, originals and changes61V0TYPVariable assignment typenvarchar10
15P2PL_RETRODIFPayroll Result PL: Retro, originals and changes61V0TYPVariable assignment typenvarchar10
16P2PL_RETROMEMPayroll Result PL: Retro, originals and changes61V0TYPVariable assignment typenvarchar10
17P2RA_BZUPayroll Result: Organizational Assignments (A)5V0TYPHR payroll: type of variable splitnvarchar10
18P2RA_DFRTPayroll Result for Other Payroll Periods18V0TYPVariable assignment typenvarchar10
19P2RB_BEEVLPayroll Results: Belgium table for Evaluation16V0TYPVariable assignment typenvarchar10
20P2RD_XITPayroll Results: Extended IT10V0TYPVariable assignment typenvarchar10
21P2RG_COSTSDistribution of Employer's Cost (Payroll Function XDEC)19V0TYPVariable assignment typenvarchar10
22P2RH_HU_GYERChildren data5V0TYPVariable assignment typenvarchar10
23P2RH_HU_HKIFP21PB15V0TYPVariable assignment typenvarchar10
24P2RH_HU_MEMBP21MB5V0TYPVariable assignment typenvarchar10
25P2RH_HU_NRENP21PA5V0TYPVariable assignment typenvarchar10
26P2RI_IPCUMRI cluster structure for cumulations (IPCUM)15V0TYPVariable assignment typenvarchar10
27P2RI_ITIOTRI cluster structure for retroactive accounting17V0TYPVariable assignment typenvarchar10
28P2RO_RO_CUXDifference table of payroll results12V0TYPVariable assignment typenvarchar10
29P2RO_RO_DIFDifference table of payroll results12V0TYPVariable assignment typenvarchar10
30P2RP_SCRTHR-PT: Cumulated result table (Legal entity dependent)8V0TYPVariable assignment typenvarchar10
31P2RQ_HTPayroll Results: Results Table15V0TYPVariable assignment typenvarchar10
32P2RQ_NTPayroll Results: Results Table15V0TYPVariable assignment typenvarchar10
33P2RQ_QSUPSuperannuation structure for Australia23V0TYPVariable assignment typenvarchar10
34P2RQ_SMTHSMTH and SQTR for Superannuation (Australia)15V0TYPVariable assignment typenvarchar10
35P2RQ_SQTRSMTH and SQTR for Superannuation (Australia)15V0TYPVariable assignment typenvarchar10
36P2RR_SRTPayroll Results: Results Table15V0TYPVariable assignment typenvarchar10
37P2RS_SEXCPayroll result: Exceptions (SE)5V0TYPVariable assignment typenvarchar10
38P2RS_SINLPayroll result: Garnishment (SE)5V0TYPVariable assignment typenvarchar10
39P2RS_SOPISPayroll result: OPIS (SE)5V0TYPVariable assignment typenvarchar10
40P2RU_COSTSDistribution of Employer's Cost (Payroll Function XDEC)19V0TYPVariable assignment typenvarchar10
41P2RV_SCRTSCRT Norway7V0TYPVariable assignment typenvarchar10
42P2RX_ARRRSPayroll Results: Arrears Table11V0TYPVariable assignment typenvarchar10
43P2RX_CODISTDistribution opf Liabilities17V0TYPVariable assignment typenvarchar10
44P2RX_DDNTKPayroll Results: Deductions Not Effected7V0TYPVariable assignment typenvarchar10
45P2RX_GRTPayroll Results: Results Table15V0TYPVariable assignment typenvarchar10
46P2RX_RTPayroll Results: Results Table15V0TYPVariable assignment typenvarchar10
47P2RX_RT_PERSONResults Table (Person)19V0TYPVariable assignment typenvarchar10
48P2RX_V0Variable Assignment5V0TYPVariable assignment typenvarchar10
49P2TN_TWOTPayroll Results: Results Table15V0TYPVariable assignment typenvarchar10
50P2UA_FUPtable FUP - future periods16V0TYPVariable assignment typenvarchar10
51P2UA_UAILLstruc.UAILL - information about sick-list compensation calc.5V0TYPVariable assignment typenvarchar10
52P2UA_UARFStructure for Ukrainian social insurance(PF) calculation18V0TYPVariable assignment typenvarchar10
53P2UA_UARTPayroll Results: Results Table15V0TYPVariable assignment typenvarchar10
54P2UA_UATIStructure for Ukrainian social insurance(PF) calculation19V0TYPVariable assignment typenvarchar10
55P2UA_UATRStructure for Ukrainian social insurance(PF) calculation19V0TYPVariable assignment typenvarchar10
56P2UA_UATSStructure for Ukrainian social insurance(PF) calculation19V0TYPVariable assignment typenvarchar10
57P2UN_HTPayroll Results: Results Table15V0TYPVariable assignment typenvarchar10
58P2UN_NTPayroll Results: Results Table15V0TYPVariable assignment typenvarchar10
59P2UR_FUPtable FUP - future periods16V0TYPVariable assignment typenvarchar10
60P2UR_RURESRussian Statuses6V0TYPVariable assignment typenvarchar10
61P2UR_RURTPayroll Results: Results Table15V0TYPVariable assignment typenvarchar10
62T77PAYRU_TAXWTAlternative tax wage types to tax classes4V0TYPVariable assignment typenvarchar10
TOPAustria
63HRPAYAT_PAYRSRESSaves Wage Types from Simulated Payroll Results16V0TYPVariable assignment typenvarchar10
TOPCompany Pension Scheme Germany
64PDAVRTResult Table: Data for Future Pension Rights9V0TYPVariable Assignment Typenvarchar20
TOPDenmark
65T5M9HSplit Indicators for Wage Types Sent to PBS16V0TYPVariable assignment typenvarchar10
TOPGermany
66T5D0IFictitious Run Control: Wage Type Assignment20V0TYPDelete Indicator for Type of Variable Assignmentnvarchar10
TOPInterface to External Payroll Systems
67T558ETransfer External Payroll-Arrears Results (International)6V0TYPVariable assignment typenvarchar10
TOPPayroll
68T7RO558_V0Transfer family members (supplement to T558D)4V0TYPVariable assignment typenvarchar10
TOPPayroll General Parts
69T558DTransfer Wage Types with Split Indicator14V0TYPVariable assignment typenvarchar10
TOPPersonnel Administration
70T7COT8Payroll external results transfer: COAVA32V0TYPVariable assignment typenvarchar10
TOPPersonnel Management
71/BKC/S21_RT_NEUC&T! - Table RT for the payroll comparison programs19V0TYPVariable assignment typenvarchar10
TOPTools
72T532BHR: Connection to Third-Party Payroll: Choice of Wage Types16V0TYPComponent 709: Entry field for field selection in PC207nvarchar10