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

67 columns | Print definition?ERP 6.0  | CNTR3

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1HRBW_REC_DTPY-XX-RECON : Country specific reports detailed results13CNTR3National assignment indicatorvarbinary10
2HRBW_REC_DT_NEWPY-XX-RECON : Country specific reports detailed results16CNTR3National assignment indicatorvarbinary10
3P2B2_ABHCM Declustering B2 - Absences12CNTR3National splitvarbinary10
4P2BR_BRCONTEmployment/basic pay: additional information5CNTR3National assignment indicatorvarbinary10
5P2BR_BRCUMWorking days (PRS)5CNTR3National assignment indicatorvarbinary10
6P2BR_BRDEPDependents: master data5CNTR3National assignment indicatorvarbinary10
7P2CN_CNREIPayroll result: structure for retro difference details13CNTR3National assignment indicatorvarbinary10
8P2CN_CNREOPayroll result: structure for retro difference details13CNTR3National assignment indicatorvarbinary10
9P2CN_SFEEPayroll result: Service fee for personal file (CN)5CNTR3SI splitvarbinary10
10P2CO_COAVAPC2CO_AVA27CNTR3National assignment indicatorvarbinary10
11P2CO_COGARPC2CO_GAR16CNTR3Hexadecimal field of length 1varbinary10
12P2HK_RETIPayroll structure for retroactive accounting15CNTR3National assignment indicatorvarbinary10
13P2HK_RETOPayroll structure for retroactive accounting15CNTR3National assignment indicatorvarbinary10
14P2IN_HFSPayroll India - Hard Furnishing Scheme5CNTR3Split for Commuter Lump Sumvarbinary10
15P2IN_HRAHousing(HRA/CLA/COA) details5CNTR3Split for Commuter Lump Sumvarbinary10
16P2IS_RETIPayroll structure for retroactive accounting15CNTR3National assignment indicatorvarbinary10
17P2IS_RETOPayroll structure for retroactive accounting15CNTR3National assignment indicatorvarbinary10
18P2KR_KRRPPayroll Result Korea: Retirement Pension Plan5CNTR3Split for Retirement Pensionvarbinary10
19P2KW_SI_KWPayroll Result: PIFSS Data for Kuwait7CNTR3Split for Commuter Lump Sumvarbinary10
20P2KZ_FUPStructure for Table FUP - Future Periods13CNTR3National assignment indicatorvarbinary10
21P2NZ_SALSACSalary Sacrifice Details12CNTR3National assignment indicatorvarbinary10
22P2RA_DFRTPayroll Result for Other Payroll Periods13CNTR3National assignment indicatorvarbinary10
23P2RB_BEEVLPayroll Results: Belgium table for Evaluation11CNTR3National assignment indicatorvarbinary10
24P2RC_CHVSHR-CH: Payroll result insurance5CNTR3SI splitvarbinary10
25P2RC_FMZRFamily-Related Bonus Register6CNTR3Object Identificationnvarchar20
26P2RD_VBLPayroll Result: Supplementary Pension Public Sector5CNTR3National assignment indicatorvarbinary10
27P2RH_HU_HKIFP21PB10CNTR3National assignment indicatorvarbinary10
28P2RI_IPCUMRI cluster structure for cumulations (IPCUM)10CNTR3National assignment indicatorvarbinary10
29P2RI_ITIOTRI cluster structure for retroactive accounting12CNTR3National assignment indicatorvarbinary10
30P2RJ_MATCumulation Table for Flexible Payroll6CNTR3National assignment indicatorvarbinary10
31P2RL_EPFPayroll result: EPF (Malaysia)4CNTR3Split for Commuter Lump Sumvarbinary10
32P2RQ_HTPayroll Results: Results Table10CNTR3National assignment indicatorvarbinary10
33P2RQ_NTPayroll Results: Results Table10CNTR3National assignment indicatorvarbinary10
34P2RQ_SMTHSMTH and SQTR for Superannuation (Australia)10CNTR3National assignment indicatorvarbinary10
35P2RQ_SQTRSMTH and SQTR for Superannuation (Australia)10CNTR3National assignment indicatorvarbinary10
36P2RR_RMPayroll Results: Table for Master data (SG)73CNTR3National assignment indicatorvarbinary10
37P2RR_SRTPayroll Results: Results Table10CNTR3National assignment indicatorvarbinary10
38P2RV_VAPVAP Structure Norway5CNTR3National assignment indicatorvarbinary10
39P2RX_ABCluster RD/B2: Table AB10CNTR3National splitvarbinary10
40P2RX_CODISTDistribution opf Liabilities12CNTR3Split for Commuter Lump Sumvarbinary10
41P2RX_GRTPayroll Results: Results Table10CNTR3National assignment indicatorvarbinary10
42P2RX_MODIFHR-PAY: Modifiers8CNTR3National assignment indicatorvarbinary10
43P2RX_RTPayroll Results: Results Table10CNTR3National assignment indicatorvarbinary10
44P2RX_RT_PERSONResults Table (Person)14CNTR3National assignment indicatorvarbinary10
45P2TH_PFUNDPayroll Results : Provident Fund TH5CNTR3SI splitvarbinary10
46P2TN_TWOTPayroll Results: Results Table10CNTR3National assignment indicatorvarbinary10
47P2UA_FUPtable FUP - future periods13CNTR3National assignment indicatorvarbinary10
48P2UA_UARFStructure for Ukrainian social insurance(PF) calculation13CNTR3National assignment indicatorvarbinary10
49P2UA_UARTPayroll Results: Results Table10CNTR3National assignment indicatorvarbinary10
50P2UA_UATIStructure for Ukrainian social insurance(PF) calculation14CNTR3National assignment indicatorvarbinary10
51P2UA_UATRStructure for Ukrainian social insurance(PF) calculation14CNTR3National assignment indicatorvarbinary10
52P2UA_UATSStructure for Ukrainian social insurance(PF) calculation14CNTR3National assignment indicatorvarbinary10
53P2UN_HTPayroll Results: Results Table10CNTR3National assignment indicatorvarbinary10
54P2UN_NTPayroll Results: Results Table10CNTR3National assignment indicatorvarbinary10
55P2UR_FUPtable FUP - future periods13CNTR3National assignment indicatorvarbinary10
56P2UR_RURTPayroll Results: Results Table10CNTR3National assignment indicatorvarbinary10
TOPAustria
57HRPAYAT_PAYRSRESSaves Wage Types from Simulated Payroll Results11CNTR3National assignment indicatorvarbinary10
TOPDenmark
58T5M9HSplit Indicators for Wage Types Sent to PBS11CNTR3National assignment indicatorvarbinary10
TOPGermany
59T5D0IFictitious Run Control: Wage Type Assignment15CNTR3Delete Indicator VBL Contribution (PS)nvarchar10
TOPJapan
60T5JMAMultiple payment model in a month3CNTR3National assignment indicatorvarbinary10
TOPPayroll
61T5T558_ABHRCZ - Tabulka pro prenos neprítomností pri upgrade na SAP9CNTR3Národní rozdelenívarbinary10
62T7SK558_ABTransfer absences (supplement to T558D) - SK9CNTR3National splitvarbinary10
TOPPayroll General Parts
63T558DTransfer Wage Types with Split Indicator9CNTR3HR: Outsourcing: Split Indicator - 3 NOT USEDnvarchar20
TOPPersonnel Administration
64T7COT6Payroll external results transfer: COGAR16CNTR3Hexadecimal field of length 1varbinary10
65T7COT8Payroll external results transfer: COAVA27CNTR3National assignment indicatorvarbinary10
TOPPersonnel Management
66/BKC/S21_RT_NEUC&T! - Table RT for the payroll comparison programs14CNTR3National assignment indicatorvarbinary10
TOPTools
67T532BHR: Connection to Third-Party Payroll: Choice of Wage Types11CNTR3Component 709: Entry field for field selection in PC207nvarchar10