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

137 columns | Print definition?ERP 6.0  | CNTR1

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1HRBW_REC_DTPY-XX-RECON : Country specific reports detailed results11CNTR1National assignment indicatorvarbinary10
2HRBW_REC_DT_NEWPY-XX-RECON : Country specific reports detailed results14CNTR1National assignment indicatorvarbinary10
3P2AA_SV_SAPayroll Result: SI Data for KSA5CNTR1National assignment indicatorvarbinary10
4P2AR_ARSESSocial Insurance master data5CNTR1National assignment indicatorvarbinary10
5P2B2_ABHCM Declustering B2 - Absences10CNTR1National splitvarbinary10
6P2BG_BG_OSIOSI properties Bulgaria5CNTR1SI splitvarbinary10
7P2CN_CNREIPayroll result: structure for retro difference details11CNTR1National assignment indicatorvarbinary10
8P2CN_CNREOPayroll result: structure for retro difference details11CNTR1National assignment indicatorvarbinary10
9P2CO_COAVAPC2CO_AVA25CNTR1National assignment indicatorvarbinary10
10P2CO_COBTRPC2CO_BTR9CNTR1SI splitvarbinary10
11P2CO_COGARPC2CO_GAR5CNTR1SI splitvarbinary10
12P2EM_SV_AEPayroll Result: SI Data for UAE5CNTR1SI splitvarbinary10
13P2FI_CSISocial ins & result structure for Finland5CNTR1SI splitvarbinary10
14P2FI_SISocial ins & result structure for Finland5CNTR1SI splitvarbinary10
15P2FI_SIRTSI result table for Finland, cumulated wage type level5CNTR1SI splitvarbinary10
16P2HK_RETIPayroll structure for retroactive accounting13CNTR1National assignment indicatorvarbinary10
17P2HK_RETOPayroll structure for retroactive accounting13CNTR1National assignment indicatorvarbinary10
18P2HK_SVHR-HK: Payroll structure for the MPF/ORSO Contribution5CNTR1National assignment indicatorvarbinary10
19P2HR_SISI properties Croatia5CNTR1SI splitvarbinary10
20P2IN_EPFPayroll structure for Provident Fund Infotype6CNTR1SI splitvarbinary10
21P2IN_ESIESI - Payroll Structure India5CNTR1SI splitvarbinary10
22P2IN_GRYPayroll structure for Gratuity6CNTR1SI splitvarbinary10
23P2IN_SANPayroll structure for Superannuation6CNTR1SI splitvarbinary10
24P2IS_INSPayroll Indonesia JAMSOSTEK & Other Insurance Data5CNTR1Split Counternvarchar20
25P2IS_RETIPayroll structure for retroactive accounting13CNTR1National assignment indicatorvarbinary10
26P2IS_RETOPayroll structure for retroactive accounting13CNTR1National assignment indicatorvarbinary10
27P2KR_KRSIPayroll Result Korea : Social Insurance5CNTR1SI splitvarbinary10
28P2KW_SI_KWPayroll Result: PIFSS Data for Kuwait5CNTR1SI splitvarbinary10
29P2KZ_FUPStructure for Table FUP - Future Periods11CNTR1National assignment indicatorvarbinary10
30P2KZ_TAXTax5CNTR1National assignment indicatorvarbinary10
31P2MX_SISoc. Insurance for calcul. data included5CNTR1National assignment indicatorvarbinary10
32P2NZ_NZSUPPayroll Result: Superannuation (NZSUP) - NZ9CNTR1National assignment indicatorvarbinary10
33P2NZ_SALSACSalary Sacrifice Details10CNTR1National assignment indicatorvarbinary10
34P2PL_SVPayroll Result PL: Split 1, social insurance5CNTR1SI splitvarbinary10
35P2QA_SV_QAPayroll Result: SI Data for Qatar5CNTR1SI splitvarbinary10
36P2RA_DFRTPayroll Result for Other Payroll Periods11CNTR1National assignment indicatorvarbinary10
37P2RA_SVPayroll Result: Technical Social Insurance (A)5CNTR1SI splitvarbinary10
38P2RA_SV_STHR-AT: Transfer Data SI -> Tax for Special Payments10CNTR1SI splitvarbinary10
39P2RB_BEEVLPayroll Results: Belgium table for Evaluation9CNTR1National assignment indicatorvarbinary10
40P2RB_SVSocial Insurance payroll Belgium5CNTR1National assignment indicatorvarbinary10
41P2RC_SVPayroll Results: Social Insurance (Switzerland)5CNTR1SI splitvarbinary10
42P2RD_SVPayroll Result: Social Insurance5CNTR1SI splitvarbinary10
43P2RD_SVZPayroll Result: Supplementary Social Insurance6CNTR1SI splitvarbinary10
44P2RE_SVPayroll result: Social Insurance (ES)5CNTR1SI splitvarbinary10
45P2RF_RECOTPayroll Results: Cumulation of Contributions6CNTR1SI splitvarbinary10
46P2RF_SVPayroll Result: Social Insurance (F)5CNTR1Tax splitvarbinary10
47P2RH_HU_HKIFP21PB8CNTR1National assignment indicatorvarbinary10
48P2RH_TBPC2465CNTR1SI splitvarbinary10
49P2RI_IPCUMRI cluster structure for cumulations (IPCUM)8CNTR1National assignment indicatorvarbinary10
50P2RI_ITIOTRI cluster structure for retroactive accounting10CNTR1National assignment indicatorvarbinary10
51P2RK_TAX1Payroll results - master data from infotypes 0461-04635CNTR1National assignment indicatorvarbinary10
52P2RK_TAX2Payroll results - Exemption Reasons from IT02245CNTR1National assignment indicatorvarbinary10
53P2RK_TAXIPayroll Results - Canada - Influx Principle7CNTR1National assignment indicatorvarbinary10
54P2RK_TAXOPayroll results - master data from infotypes 0461-04635CNTR1National assignment indicatorvarbinary10
55P2RK_WCB1Payroll results - Workers' compensation information5CNTR1National assignment indicatorvarbinary10
56P2RK_WTDTPayroll Results - Wage type processing information7CNTR1National assignment indicatorvarbinary10
57P2RL_SOCSOPayroll result: SOCSO ( Malysian Social Insurance )4CNTR1SI splitvarbinary10
58P2RM_MPACPrior Pension Accumulations after PBS Splits6CNTR1SI splitvarbinary10
59P2RM_MPENSPrivate Pension (DK)7CNTR1SI splitvarbinary10
60P2RN_SVPayroll Results: Social Insurance (NL)5CNTR1Tax splitvarbinary10
61P2RO_RO_SISI properties Romania5CNTR1SI splitvarbinary10
62P2RP_SSHR-PT: Payroll Results: Social Security5CNTR1SI splitvarbinary10
63P2RQ_HTPayroll Results: Results Table8CNTR1National assignment indicatorvarbinary10
64P2RQ_NTPayroll Results: Results Table8CNTR1National assignment indicatorvarbinary10
65P2RQ_QSPRHR-AU-PS: Payroll structure for Superannuation9CNTR1National assignment indicatorvarbinary10
66P2RQ_QSUPSuperannuation structure for Australia9CNTR1National assignment indicatorvarbinary10
67P2RQ_SMTHSMTH and SQTR for Superannuation (Australia)8CNTR1National assignment indicatorvarbinary10
68P2RQ_SQTRSMTH and SQTR for Superannuation (Australia)8CNTR1National assignment indicatorvarbinary10
69P2RR_ADDFPayresult: Additional Funds/SG5CNTR1SI splitvarbinary10
70P2RR_CAWPayroll Results: Table for CPF on AW/SG5CNTR1SI splitvarbinary10
71P2RR_RMPayroll Results: Table for Master data (SG)71CNTR1National assignment indicatorvarbinary10
72P2RR_SRTPayroll Results: Results Table8CNTR1National assignment indicatorvarbinary10
73P2RR_SVPayresult: Soc. Provident Funds/SG5CNTR1SI splitvarbinary10
74P2RS_SFORSPayroll result: Insurances (SE)5CNTR1SI splitvarbinary10
75P2RT_SVStructure SV - insurance CZ5CNTR1SI splitvarbinary10
76P2RU_TAXPayroll Results: Tax (U.S.)5CNTR1SI splitvarbinary10
77P2RW_CSVPayroll Result: Cumulated SI Data for South Africa5CNTR1SI splitvarbinary10
78P2RW_SCRTPayroll Result: Cumulated Tax Results for South Africa9CNTR1SI splitvarbinary10
79P2RW_SVPayroll Result: SI Data for South Africa5CNTR1SI splitvarbinary10
80P2RX_ABCluster RD/B2: Table AB8CNTR1National splitvarbinary10
81P2RX_CODISTDistribution opf Liabilities10CNTR1SI splitvarbinary10
82P2RX_GRTPayroll Results: Results Table8CNTR1National assignment indicatorvarbinary10
83P2RX_MODIFHR-PAY: Modifiers6CNTR1National assignment indicatorvarbinary10
84P2RX_RTPayroll Results: Results Table8CNTR1National assignment indicatorvarbinary10
85P2RX_RT_PERSONResults Table (Person)12CNTR1National assignment indicatorvarbinary10
86P2SK_SVStructure of table SV - insurance SK5CNTR1SI splitvarbinary10
87P2TH_SOCSEPayroll result: Social Security Thailand5CNTR1SI splitvarbinary10
88P2TN_NPTABPayroll Structure New Pension Taiwan5CNTR1SI splitvarbinary10
89P2TN_SIPayroll Structure Labor Insurance Taiwan5CNTR1SI splitvarbinary10
90P2TN_TWOTPayroll Results: Results Table8CNTR1National assignment indicatorvarbinary10
91P2UA_FUPtable FUP - future periods11CNTR1National assignment indicatorvarbinary10
92P2UA_UARFStructure for Ukrainian social insurance(PF) calculation11CNTR1National assignment indicatorvarbinary10
93P2UA_UARTPayroll Results: Results Table8CNTR1National assignment indicatorvarbinary10
94P2UA_UATIStructure for Ukrainian social insurance(PF) calculation12CNTR1National assignment indicatorvarbinary10
95P2UA_UATRStructure for Ukrainian social insurance(PF) calculation12CNTR1National assignment indicatorvarbinary10
96P2UA_UATSStructure for Ukrainian social insurance(PF) calculation12CNTR1National assignment indicatorvarbinary10
97P2UN_HTPayroll Results: Results Table8CNTR1National assignment indicatorvarbinary10
98P2UN_NTPayroll Results: Results Table8CNTR1National assignment indicatorvarbinary10
99P2UN_QSPRHR-UN: Payroll structure for Superannuation9CNTR1National assignment indicatorvarbinary10
100P2UR_FUPtable FUP - future periods11CNTR1National assignment indicatorvarbinary10
101P2UR_RURTPayroll Results: Results Table8CNTR1National assignment indicatorvarbinary10
102P2UR_TAXRussian Tax5CNTR1National assignment indicatorvarbinary10
103P2VE_INC_EVALHRMS-VE: INCE Payment Results5CNTR1SI splitvarbinary10
104P2VE_INT_EVALHRMS-VE: Annual Interest Results5CNTR1SI splitvarbinary10
105P2VE_LPH_EVALHRMS-VE: Results from Housing Scheme (RPVH)5CNTR1SI splitvarbinary10
106P2VE_PS_EVALHRMS-VE: Annual Balance of Profit Share Payments5CNTR1SI splitvarbinary10
107P2VE_SENHRMS-VE: Information on Length of Service5CNTR1SI splitvarbinary10
108P2VE_SEN_EVALHRMS-VE: Information on Length of Service Payment5CNTR1SI splitvarbinary10
109P2VE_SIHRMS-VE: Information on Statutory Social Insurance5CNTR1SI splitvarbinary10
110P2VE_SI_EVALHRMS-VE: Cumulated Social Insurance Results5CNTR1SI splitvarbinary10
111P2VE_TAX_EVALHRMS-VE: Information on Income Tax5CNTR1SI splitvarbinary10
112T7RU_558D_TAXSplit Indicator Tax for Transfered Wage Types4CNTR1HR: Outsourcing: Country Split Indicator - Taxesnvarchar20
TOPAustria
113HRPAYAT_PAYRSRESSaves Wage Types from Simulated Payroll Results9CNTR1National assignment indicatorvarbinary10
TOPDenmark
114T5M9HSplit Indicators for Wage Types Sent to PBS9CNTR1National assignment indicatorvarbinary10
TOPGermany
115T5D0IFictitious Run Control: Wage Type Assignment13CNTR1Delete Indicator for SI Splitnvarchar10
TOPGlobal Trade Services
116/SAPSLL/PREGPPROGTS: Preference: Procedure Groups (Data Provider Upload)4CNTR12-Digit Sequence Numbernvarchar20
117/SAPSLL/PRFPMRPSLL: Preference: Log: product: Result of BOM Calc - Proc.4CNTR12-Digit Sequence Numbernvarchar20
118/SAPSLL/PSVGPPROGTS: Preference: Procedure Groups (Manual Entry)4CNTR12-Digit Sequence Numbernvarchar20
TOPPayroll
119T5T558_ABHRCZ - Tabulka pro prenos neprítomností pri upgrade na SAP7CNTR1Národní rozdelenívarbinary10
120T7SK558_ABTransfer absences (supplement to T558D) - SK7CNTR1National splitvarbinary10
TOPPayroll General Parts
121T558DTransfer Wage Types with Split Indicator7CNTR1HR: Outsourcing: Country Split Indicator - Taxesnvarchar20
TOPPersonnel Administration
122T7COT5Payroll external results transfer: COBTR9CNTR1SI splitvarbinary10
123T7COT6Payroll external results transfer: COGAR5CNTR1SI splitvarbinary10
124T7COT8Payroll external results transfer: COAVA25CNTR1National assignment indicatorvarbinary10
TOPPersonnel Management
125/BKC/S21_EVSol21: Vergleich von Abrechnungsergebnissen9CNTR1Zuordnungskennzeichen Nationalvarbinary10
126/BKC/S21_EV1Sol21: Vergleich von Abrechnungsergebnissen - ohne PERNR.8CNTR1Zuordnungskennzeichen Nationalvarbinary10
127/BKC/S21_RTC&T! - Table RT for the payroll comparison programs10CNTR1National assignment indicatorvarbinary10
128/BKC/S21_RT_NEUC&T! - Table RT for the payroll comparison programs12CNTR1National assignment indicatorvarbinary10
129/BKC/S21_RT_NOPNC&T! - Table RT for the payroll comparison programs9CNTR1National assignment indicatorvarbinary10
TOPTools
130T532BHR: Connection to Third-Party Payroll: Choice of Wage Types9CNTR1Component 709: Entry field for field selection in PC207nvarchar10
TOPVenezuela
131T7VEI1Transfer of External Payroll results: Interest5CNTR1SI splitvarbinary10
132T7VEI2Transfer of external payroll results: INC contribution5CNTR1SI splitvarbinary10
133T7VEL1Transfer of ext. payroll res.: Housing Scheme (RPVH) contr.5CNTR1SI splitvarbinary10
134T7VEP1Transfer of External Payroll Results: Profit Share5CNTR1SI splitvarbinary10
135T7VES4Transfer of External Payroll Results: SSO/RPE5CNTR1SI splitvarbinary10
136T7VES5Transfer of External Payroll Results: Seniority5CNTR1SI splitvarbinary10
137T7VET1Transfer of External Payroll Results: Income Tax5CNTR1SI splitvarbinary10