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

48 columns | Print definition?ERP 6.0  | RTE_CURR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2BR_BRAVERAGEFrozen averages10RTE_CURRCurrency Keynvarchar50
2P2CN_CNREIPayroll result: structure for retro difference details24RTE_CURRCurrency Keynvarchar50
3P2CN_CNREOPayroll result: structure for retro difference details24RTE_CURRCurrency Keynvarchar50
4P2CO_COAVAPC2CO_AVA38RTE_CURRCurrency Keynvarchar50
5P2HK_RETIPayroll structure for retroactive accounting26RTE_CURRCurrency Keynvarchar50
6P2HK_RETOPayroll structure for retroactive accounting26RTE_CURRCurrency Keynvarchar50
7P2IS_RETIPayroll structure for retroactive accounting26RTE_CURRCurrency Keynvarchar50
8P2IS_RETOPayroll structure for retroactive accounting26RTE_CURRCurrency Keynvarchar50
9P2KZ_FUPStructure for Table FUP - Future Periods21RTE_CURRCurrency Keynvarchar50
10P2KZ_KZAVCumulations for Calculation of Averages15RTE_CURRCurrency Keynvarchar50
11P2NZ_SALSACSalary Sacrifice Details25RTE_CURRCurrency Keynvarchar50
12P2RA_DFRTPayroll Result for Other Payroll Periods24RTE_CURRCurrency Keynvarchar50
13P2RB_DAYDETDaydetails for payroll outsourcing (B)15RTE_CURRCurrency Keynvarchar50
14P2RG_MSAMaternity and Sickness Absences (GB)12RTE_CURRCurrency Keynvarchar50
15P2RH_HU_HKIFP21PB21RTE_CURRCurrency Keynvarchar50
16P2RI_IPCUMRI cluster structure for cumulations (IPCUM)21RTE_CURRCurrency Keynvarchar50
17P2RI_ITIOTRI cluster structure for retroactive accounting23RTE_CURRCurrency Keynvarchar50
18P2RJ_HEITPayroll Results: Hei Ran Results Table10RTE_CURRCurrency Keynvarchar50
19P2RQ_HTPayroll Results: Results Table21RTE_CURRCurrency Keynvarchar50
20P2RQ_NTPayroll Results: Results Table21RTE_CURRCurrency Keynvarchar50
21P2RQ_SMTHSMTH and SQTR for Superannuation (Australia)21RTE_CURRCurrency Keynvarchar50
22P2RQ_SQTRSMTH and SQTR for Superannuation (Australia)21RTE_CURRCurrency Keynvarchar50
23P2RR_SRTPayroll Results: Results Table21RTE_CURRCurrency Keynvarchar50
24P2RU_BALPayroll Results: Tax Retro Differences -(USA)10RTE_CURRCurrency Keynvarchar50
25P2RU_UNBPayroll Results: Tax Retro Differences -(USA)10RTE_CURRCurrency Keynvarchar50
26P2RU_XDFRTPayroll Results: Tax Retro Differences -(USA)10RTE_CURRCurrency Keynvarchar50
27P2RX_AVERAGEFrozen Average Values in Payroll Result9RTE_CURRCurrency Keynvarchar50
28P2RX_GRTPayroll Results: Results Table21RTE_CURRCurrency Keynvarchar50
29P2RX_LSPayroll Results: Subsequent Time Tickets22RTE_CURRCurrency Keynvarchar50
30P2RX_RTPayroll Results: Results Table21RTE_CURRCurrency Keynvarchar50
31P2RX_RT_GPPayroll Result: Payroll for Global Employees12RTE_CURRCurrency Keynvarchar50
32P2RX_RT_PERSONResults Table (Person)25RTE_CURRCurrency Keynvarchar50
33P2TN_TWOTPayroll Results: Results Table21RTE_CURRCurrency Keynvarchar50
34P2UA_FUPtable FUP - future periods21RTE_CURRCurrency Keynvarchar50
35P2UA_UAAVHR-PAY: Cumulations for calculation of averages13RTE_CURRCurrency Keynvarchar50
36P2UA_UARFStructure for Ukrainian social insurance(PF) calculation24RTE_CURRCurrency Keynvarchar50
37P2UA_UARTPayroll Results: Results Table21RTE_CURRCurrency Keynvarchar50
38P2UA_UATIStructure for Ukrainian social insurance(PF) calculation25RTE_CURRCurrency Keynvarchar50
39P2UA_UATRStructure for Ukrainian social insurance(PF) calculation25RTE_CURRCurrency Keynvarchar50
40P2UA_UATSStructure for Ukrainian social insurance(PF) calculation25RTE_CURRCurrency Keynvarchar50
41P2UN_HTPayroll Results: Results Table21RTE_CURRCurrency Keynvarchar50
42P2UN_NTPayroll Results: Results Table21RTE_CURRCurrency Keynvarchar50
43P2UR_FUPtable FUP - future periods21RTE_CURRCurrency Keynvarchar50
44P2UR_RUAVECumulations for calculation of averages13RTE_CURRCurrency Keynvarchar50
45P2UR_RURTPayroll Results: Results Table21RTE_CURRCurrency Keynvarchar50
TOPAustria
46HRPAYAT_PAYRSRESSaves Wage Types from Simulated Payroll Results22RTE_CURRCurrency Keynvarchar50
TOPPersonnel Administration
47T7COT8Payroll external results transfer: COAVA38RTE_CURRCurrency Keynvarchar50
TOPPersonnel Management
48/BKC/S21_RT_NEUC&T! - Table RT for the payroll comparison programs22RTE_CURRCurrency Keynvarchar50