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

77 columns | Print definition?ERP 6.0  | AMT_CURR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2CN_CNREIPayroll result: structure for retro difference details25AMT_CURRCurrency Keynvarchar50
2P2CN_CNREOPayroll result: structure for retro difference details25AMT_CURRCurrency Keynvarchar50
3P2CO_COAVAPC2CO_AVA39AMT_CURRCurrency Keynvarchar50
4P2HK_RETIPayroll structure for retroactive accounting27AMT_CURRCurrency Keynvarchar50
5P2HK_RETOPayroll structure for retroactive accounting27AMT_CURRCurrency Keynvarchar50
6P2IN_S89Payroll structure for section 89(1)9AMT_CURRCurrency Keynvarchar50
7P2IS_RETIPayroll structure for retroactive accounting27AMT_CURRCurrency Keynvarchar50
8P2IS_RETOPayroll structure for retroactive accounting27AMT_CURRCurrency Keynvarchar50
9P2KR_KRSP2Payroll Results Korea: Separation payroll II10AMT_CURRCurrency Keynvarchar50
10P2KZ_FUPStructure for Table FUP - Future Periods22AMT_CURRCurrency Keynvarchar50
11P2KZ_KZAVCumulations for Calculation of Averages18AMT_CURRCurrency Keynvarchar50
12P2MX_LNCTMX Loans Processing12AMT_CURRCurrency Keynvarchar50
13P2NZ_RETPPayroll structure NZ: RETP Table8AMT_CURRCurrency Keynvarchar50
14P2NZ_SALSACSalary Sacrifice Details26AMT_CURRCurrency Keynvarchar50
15P2RA_DFRTPayroll Result for Other Payroll Periods25AMT_CURRCurrency Keynvarchar50
16P2RB_DAYDETDaydetails for payroll outsourcing (B)16AMT_CURRCurrency Keynvarchar50
17P2RG_MSAMaternity and Sickness Absences (GB)13AMT_CURRCurrency Keynvarchar50
18P2RH_HU_ADIFDifferences spanning over year-limit8AMT_CURRCurrency Keynvarchar50
19P2RH_HU_CDIFDifferences spanning over year-limit11AMT_CURRCurrency Keynvarchar50
20P2RH_HU_DDIFDifferences spanning over year-limit10AMT_CURRCurrency Keynvarchar50
21P2RH_HU_EDIFDifferences spanning over year-limit8AMT_CURRCurrency Keynvarchar50
22P2RH_HU_HKIFP21PB22AMT_CURRCurrency Keynvarchar50
23P2RH_HU_JKORDifferences spanning over year-limit10AMT_CURRCurrency Keynvarchar50
24P2RH_HU_KDIFDifferences spanning over year-limit9AMT_CURRCurrency Keynvarchar50
25P2RH_HU_ODIFDifferences spanning over year-limit8AMT_CURRCurrency Keynvarchar50
26P2RI_IPCUMRI cluster structure for cumulations (IPCUM)22AMT_CURRCurrency Keynvarchar50
27P2RI_ITIOTRI cluster structure for retroactive accounting24AMT_CURRCurrency Keynvarchar50
28P2RJ_HEITPayroll Results: Hei Ran Results Table11AMT_CURRCurrency Keynvarchar50
29P2RJ_KGTKijungai time occured in for-period with Position info10AMT_CURRCurrency Keynvarchar50
30P2RJ_MATCumulation Table for Flexible Payroll9AMT_CURRCurrency Keynvarchar50
31P2RJ_MSTPayroll result: Monthly socail insurance table9AMT_CURRCurrency Keynvarchar50
32P2RK_GRCUMCumulation for garnishment results14AMT_CURRCurrency Keynvarchar50
33P2RK_TCRTPayroll Results - Fed. and Prov. Tax Cumulations10AMT_CURRCurrency Keynvarchar50
34P2RP_MFHR-PT: Payroll Results: Membership fees14AMT_CURRCurrency Keynvarchar50
35P2RP_SCRTHR-PT: Cumulated result table (Legal entity dependent)14AMT_CURRCurrency Keynvarchar50
36P2RP_VAHR-PT: Payroll Results: Vacation allowance grouping (VA)20AMT_CURRCurrency Keynvarchar50
37P2RQ_HTPayroll Results: Results Table22AMT_CURRCurrency Keynvarchar50
38P2RQ_NTPayroll Results: Results Table22AMT_CURRCurrency Keynvarchar50
39P2RQ_PASUMPayment summary components14AMT_CURRCurrency Keynvarchar50
40P2RQ_RETPPayroll Structure: RETP Table8AMT_CURRCurrency Keynvarchar50
41P2RQ_SMTHSMTH and SQTR for Superannuation (Australia)22AMT_CURRCurrency Keynvarchar50
42P2RQ_SQTRSMTH and SQTR for Superannuation (Australia)22AMT_CURRCurrency Keynvarchar50
43P2RR_SRTPayroll Results: Results Table22AMT_CURRCurrency Keynvarchar50
44P2RU_BALPayroll Results: Tax Retro Differences -(USA)11AMT_CURRCurrency Keynvarchar50
45P2RU_GRCUMCumulation for garnishment results14AMT_CURRCurrency Keynvarchar50
46P2RU_UNBPayroll Results: Tax Retro Differences -(USA)11AMT_CURRCurrency Keynvarchar50
47P2RU_UTIPSPayroll Results: Cumulated tips result10AMT_CURRCurrency Keynvarchar50
48P2RU_XDFRTPayroll Results: Tax Retro Differences -(USA)11AMT_CURRCurrency Keynvarchar50
49P2RV_RETPRETP Structure Norway8AMT_CURRCurrency Keynvarchar50
50P2RV_SCRTSCRT Norway11AMT_CURRCurrency Keynvarchar50
51P2RX_CRTPayroll Results: Cumulated Results Table9AMT_CURRCurrency Keynvarchar50
52P2RX_CRT_PERSONCumulated Results Table (Person)11AMT_CURRCurrency Keynvarchar50
53P2RX_GRTPayroll Results: Results Table22AMT_CURRCurrency Keynvarchar50
54P2RX_LSPayroll Results: Subsequent Time Tickets23AMT_CURRCurrency Keynvarchar50
55P2RX_RTPayroll Results: Results Table22AMT_CURRCurrency Keynvarchar50
56P2RX_RT_GPPayroll Result: Payroll for Global Employees13AMT_CURRCurrency Keynvarchar50
57P2RX_RT_PERSONResults Table (Person)26AMT_CURRCurrency Keynvarchar50
58P2TN_TWOTPayroll Results: Results Table22AMT_CURRCurrency Keynvarchar50
59P2UA_FUPtable FUP - future periods22AMT_CURRCurrency Keynvarchar50
60P2UA_UAAVHR-PAY: Cumulations for calculation of averages16AMT_CURRCurrency Keynvarchar50
61P2UA_UARFStructure for Ukrainian social insurance(PF) calculation25AMT_CURRCurrency Keynvarchar50
62P2UA_UARTPayroll Results: Results Table22AMT_CURRCurrency Keynvarchar50
63P2UA_UATIStructure for Ukrainian social insurance(PF) calculation26AMT_CURRCurrency Keynvarchar50
64P2UA_UATRStructure for Ukrainian social insurance(PF) calculation26AMT_CURRCurrency Keynvarchar50
65P2UA_UATSStructure for Ukrainian social insurance(PF) calculation26AMT_CURRCurrency Keynvarchar50
66P2UN_HTPayroll Results: Results Table22AMT_CURRCurrency Keynvarchar50
67P2UN_NTPayroll Results: Results Table22AMT_CURRCurrency Keynvarchar50
68P2UR_FUPtable FUP - future periods22AMT_CURRCurrency Keynvarchar50
69P2UR_RUAVECumulations for calculation of averages16AMT_CURRCurrency Keynvarchar50
70P2UR_RURTPayroll Results: Results Table22AMT_CURRCurrency Keynvarchar50
TOPAustralia
71T5QGOGroup Certificate Overrides7AMT_CURRCurrency Keynvarchar50
TOPAustria
72HRPAYAT_PAYRSRESSaves Wage Types from Simulated Payroll Results23AMT_CURRCurrency Keynvarchar50
TOPPayroll
73T5T4045Výsledky RZD pro prevzetí do výpoctu - MD /404 a /40510AMT_CURRZúctování mezd a pl.: Cástkadecimal152
74T5TA3Results of annual tax calculation for RPCALC8AMT_CURRCurrency Keynvarchar50
75T7SKA3Results of annual tax calculation for RPCALC10AMT_CURRCurrency Keynvarchar50
TOPPersonnel Administration
76T7COT8Payroll external results transfer: COAVA39AMT_CURRCurrency Keynvarchar50
TOPPersonnel Management
77/BKC/S21_RT_NEUC&T! - Table RT for the payroll comparison programs23AMT_CURRCurrency Keynvarchar50