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

117 columns | Print definition?ERP 6.0  | CNTR2

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1HRBW_REC_DTPY-XX-RECON : Country specific reports detailed results12CNTR2National assignment indicatorvarbinary10
2HRBW_REC_DT_NEWPY-XX-RECON : Country specific reports detailed results15CNTR2National assignment indicatorvarbinary10
3J_1UF_TP_RESGRPInformation of Notification. Grouping39CNTR2Notification Numbernvarchar80
4P2AA_PS_SAPayroll Result: Pension Data for KSA5CNTR2National assignment indicatorvarbinary10
5P2AR_ARIMPTax master data5CNTR2National assignment indicatorvarbinary10
6P2B2_ABHCM Declustering B2 - Absences11CNTR2National splitvarbinary10
7P2BR_BRIRRFWithholding Incoming Tax: master data5CNTR2National assignment indicatorvarbinary10
8P2CL_CLTAXPayroll Results: Tax (CL)5CNTR2Tax splitvarbinary10
9P2CN_CNREIPayroll result: structure for retro difference details12CNTR2National assignment indicatorvarbinary10
10P2CN_CNREOPayroll result: structure for retro difference details12CNTR2National assignment indicatorvarbinary10
11P2CN_TAXPayroll result: Income Tax (CN)5CNTR2Tax splitvarbinary10
12P2CO_COAVAPC2CO_AVA26CNTR2National assignment indicatorvarbinary10
13P2FI_CSTTax result table for Finland, cumulative5CNTR2Tax splitvarbinary10
14P2FI_SCRTTax result table for Finland, cumulated wage type level5CNTR2Tax splitvarbinary10
15P2FI_STTax result structure for Finland5CNTR2Tax splitvarbinary10
16P2HK_RETIPayroll structure for retroactive accounting14CNTR2National assignment indicatorvarbinary10
17P2HK_RETOPayroll structure for retroactive accounting14CNTR2National assignment indicatorvarbinary10
18P2HK_STHR-HK: Payroll structure for Tax - Period by period5CNTR2Tax splitvarbinary10
19P2HR_CUFStructure of difference table Croatia11CNTR2National assignment indicatorvarbinary10
20P2HR_CUPStructure of difference table Croatia11CNTR2National assignment indicatorvarbinary10
21P2HR_DTFStructure of difference table Croatia11CNTR2National assignment indicatorvarbinary10
22P2HR_DTPStructure of difference table Croatia11CNTR2National assignment indicatorvarbinary10
23P2HR_HR_CUXStructure of difference table for tax calculation6CNTR2National assignment indicatorvarbinary10
24P2HR_HR_DPAStructure of difference table for tax calculation6CNTR2National assignment indicatorvarbinary10
25P2IN_CCOPayroll India - Car and Conveyance5CNTR2Tax splitvarbinary10
26P2IN_EXMPayroll structure for exemptions5CNTR2Tax splitvarbinary10
27P2IN_PTXPayroll India - Professional Tax6CNTR2Tax splitvarbinary10
28P2IN_TANCompany code cluster line item5CNTR2National assignment indicatorvarbinary10
29P2IS_RETIPayroll structure for retroactive accounting14CNTR2National assignment indicatorvarbinary10
30P2IS_RETOPayroll structure for retroactive accounting14CNTR2National assignment indicatorvarbinary10
31P2IS_TAXPayroll Indonesia Tax Data5CNTR2Split Counternvarchar20
32P2KR_KRTAXPayroll Result Korea : Tax5CNTR2Tax splitvarbinary10
33P2KW_SI_KWPayroll Result: PIFSS Data for Kuwait6CNTR2Tax splitvarbinary10
34P2KZ_FUPStructure for Table FUP - Future Periods12CNTR2National assignment indicatorvarbinary10
35P2MX_TAXTax for calculation data included5CNTR2National assignment indicatorvarbinary10
36P2NZ_SALSACSalary Sacrifice Details11CNTR2National assignment indicatorvarbinary10
37P2PH_TAXPHR-PH: Include for Tax structure - Philippines5CNTR2Tax splitvarbinary10
38P2PL_STPayroll Result PL: Split 2, income tax5CNTR2Tax splitvarbinary10
39P2QA_PS_QAPayroll Result: Pension Data for QA5CNTR2National assignment indicatorvarbinary10
40P2RA_DFRTPayroll Result for Other Payroll Periods12CNTR2National assignment indicatorvarbinary10
41P2RA_STPayroll Result: Tax (Austria)5CNTR2Tax splitvarbinary10
42P2RA_SV_STHR-AT: Transfer Data SI -> Tax for Special Payments5CNTR2Tax splitvarbinary10
43P2RB_BEEVLPayroll Results: Belgium table for Evaluation10CNTR2National assignment indicatorvarbinary10
44P2RB_STTax payroll Belgium5CNTR2National assignment indicatorvarbinary10
45P2RB_SVSocial Insurance payroll Belgium6CNTR2National assignment indicatorvarbinary10
46P2RC_CHVSHR-CH: Payroll result insurance34CNTR2C2 Splitvarbinary10
47P2RC_STPayroll Results: Taxes (Switzerland)5CNTR2Tax splitvarbinary10
48P2RD_STPayroll Result: Tax (G)5CNTR2Tax splitvarbinary10
49P2RE_STPayroll result: Taxes (ES)5CNTR2Tax splitvarbinary10
50P2RH_ADOStructure of table ADO5CNTR2Tax splitvarbinary10
51P2RH_HU_HKIFP21PB9CNTR2National assignment indicatorvarbinary10
52P2RI_IPCUMRI cluster structure for cumulations (IPCUM)9CNTR2National assignment indicatorvarbinary10
53P2RI_ITIOTRI cluster structure for retroactive accounting11CNTR2National assignment indicatorvarbinary10
54P2RJ_JP_SHUKKOShukko settlement information5CNTR2National assignment indicatorvarbinary10
55P2RJ_RET_INFOPayroll Results: Retirement Information Table5CNTR2Tax Flagvarbinary10
56P2RL_TAXPayroll result: Tax (Malaysia)5CNTR2Tax splitvarbinary10
57P2RN_STPayroll Results: Wage Tax (NL)5CNTR2Tax splitvarbinary10
58P2RP_DAHR-PT: Payroll Results: Disability5CNTR2Tax splitvarbinary10
59P2RP_SCRTHR-PT: Cumulated result table (Legal entity dependent)6CNTR2Tax splitvarbinary10
60P2RP_TXHR-PT: Payroll Results: Tax5CNTR2Tax splitvarbinary10
61P2RQ_HTPayroll Results: Results Table9CNTR2National assignment indicatorvarbinary10
62P2RQ_NTPayroll Results: Results Table9CNTR2National assignment indicatorvarbinary10
63P2RQ_SMTHSMTH and SQTR for Superannuation (Australia)9CNTR2National assignment indicatorvarbinary10
64P2RQ_SQTRSMTH and SQTR for Superannuation (Australia)9CNTR2National assignment indicatorvarbinary10
65P2RQ_TAXPStructure for tax routine (Australia)5CNTR2Tax splitvarbinary10
66P2RR_RMPayroll Results: Table for Master data (SG)72CNTR2National assignment indicatorvarbinary10
67P2RR_SRTPayroll Results: Results Table9CNTR2National assignment indicatorvarbinary10
68P2RR_STPayroll Results: Tax (Singapore)5CNTR2Tax splitvarbinary10
69P2RS_SSKATPayroll result: Tax (SE)5CNTR2Tax splitvarbinary10
70P2RT_STStructure of table ST - Tax CZ5CNTR2Tax splitvarbinary10
71P2RV_STST for Norway (Cluster for tax)5CNTR2Tax splitvarbinary10
72P2RW_BRSPayroll Result: Bursaries5CNTR2Tax splitvarbinary10
73P2RW_CBRSPayroll Result: Bursaries5CNTR2Tax splitvarbinary10
74P2RW_CDTPayroll Result: Cumulated Directives (South Africa)5CNTR2Tax splitvarbinary10
75P2RW_CSTPayroll Result: Cumulated Tax Data for South Africa.5CNTR2Tax splitvarbinary10
76P2RW_SCRTPayroll Result: Cumulated Tax Results for South Africa5CNTR2Tax splitvarbinary10
77P2RW_STPayroll Result: Tax Data for South Africa.5CNTR2Tax splitvarbinary10
78P2RX_ABCluster RD/B2: Table AB9CNTR2National splitvarbinary10
79P2RX_CODISTDistribution opf Liabilities11CNTR2Tax splitvarbinary10
80P2RX_GRTPayroll Results: Results Table9CNTR2National assignment indicatorvarbinary10
81P2RX_MODIFHR-PAY: Modifiers7CNTR2National assignment indicatorvarbinary10
82P2RX_RTPayroll Results: Results Table9CNTR2National assignment indicatorvarbinary10
83P2RX_RT_PERSONResults Table (Person)13CNTR2National assignment indicatorvarbinary10
84P2SK_STStructure of table ST - Tax SK5CNTR2Tax splitvarbinary10
85P2TH_TAXPayroll Structure for TAX - TH5CNTR2Tax splitvarbinary10
86P2TN_TAXPayroll Structure Tax (Taiwan)5CNTR2Tax splitvarbinary10
87P2TN_TWOTPayroll Results: Results Table9CNTR2National assignment indicatorvarbinary10
88P2UA_FUPtable FUP - future periods12CNTR2National assignment indicatorvarbinary10
89P2UA_TAXUkrainian Tax5CNTR2National assignment indicatorvarbinary10
90P2UA_UARFStructure for Ukrainian social insurance(PF) calculation12CNTR2National assignment indicatorvarbinary10
91P2UA_UARTPayroll Results: Results Table9CNTR2National assignment indicatorvarbinary10
92P2UA_UATIStructure for Ukrainian social insurance(PF) calculation13CNTR2National assignment indicatorvarbinary10
93P2UA_UATRStructure for Ukrainian social insurance(PF) calculation13CNTR2National assignment indicatorvarbinary10
94P2UA_UATSStructure for Ukrainian social insurance(PF) calculation13CNTR2National assignment indicatorvarbinary10
95P2UN_HTPayroll Results: Results Table9CNTR2National assignment indicatorvarbinary10
96P2UN_NTPayroll Results: Results Table9CNTR2National assignment indicatorvarbinary10
97P2UR_FUPtable FUP - future periods12CNTR2National assignment indicatorvarbinary10
98P2UR_RURTPayroll Results: Results Table9CNTR2National assignment indicatorvarbinary10
99P2VE_TAXHRMS-VE: Income Tax Percentages5CNTR2Tax splitvarbinary10
TOPAustria
100HRPAYAT_PAYRSRESSaves Wage Types from Simulated Payroll Results10CNTR2National assignment indicatorvarbinary10
TOPDenmark
101T5M9HSplit Indicators for Wage Types Sent to PBS10CNTR2National assignment indicatorvarbinary10
TOPGermany
102T5D0IFictitious Run Control: Wage Type Assignment14CNTR2Delete Indicator for Tax Splitnvarchar10
TOPGlobal Trade Services
103/SAPSLL/PREGPPROGTS: Preference: Procedure Groups (Data Provider Upload)6CNTR22-Digit Sequence Numbernvarchar20
104/SAPSLL/PRFPMRPSLL: Preference: Log: product: Result of BOM Calc - Proc.6CNTR22-Digit Sequence Numbernvarchar20
105/SAPSLL/PSVGPPROGTS: Preference: Procedure Groups (Manual Entry)6CNTR22-Digit Sequence Numbernvarchar20
106/SAPSLL/SPLAUDKLegal Control - SPL - Audit: Comments5CNTR22-Digit Sequence Numbernvarchar20
107/SAPSLL/TPAGRAAssignment of Partner Function to Partner Function Grouping3CNTR22-Digit Sequence Numbernvarchar20
TOPPayroll
108T5T558_ABHRCZ - Tabulka pro prenos neprítomností pri upgrade na SAP8CNTR2Národní rozdelenívarbinary10
109T7SK558_ABTransfer absences (supplement to T558D) - SK8CNTR2National splitvarbinary10
TOPPayroll General Parts
110T558DTransfer Wage Types with Split Indicator8CNTR2HR: Outsourcing: Split Indicator - 2 NOT USEDnvarchar20
TOPPersonnel Administration
111T7COT8Payroll external results transfer: COAVA26CNTR2National assignment indicatorvarbinary10
TOPPersonnel Management
112/BKC/S21_EVSol21: Vergleich von Abrechnungsergebnissen10CNTR2Zuordnungskennzeichen Nationalvarbinary10
113/BKC/S21_EV1Sol21: Vergleich von Abrechnungsergebnissen - ohne PERNR.9CNTR2Zuordnungskennzeichen Nationalvarbinary10
114/BKC/S21_RTC&T! - Table RT for the payroll comparison programs11CNTR2National assignment indicatorvarbinary10
115/BKC/S21_RT_NEUC&T! - Table RT for the payroll comparison programs13CNTR2National assignment indicatorvarbinary10
116/BKC/S21_RT_NOPNC&T! - Table RT for the payroll comparison programs10CNTR2National assignment indicatorvarbinary10
TOPTools
117T532BHR: Connection to Third-Party Payroll: Choice of Wage Types10CNTR2Component 709: Entry field for field selection in PC207nvarchar10