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

66 columns | Print definition?ERP 6.0  | C1ZNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1HRBW_REC_DT_NEWPY-XX-RECON : Country specific reports detailed results31C1ZNRPointer to cost accountingvarbinary20
2P2B2_C1HCM Declustering B2 - Cost Distribution Table C17C1ZNRPointer to cost accountingvarbinary20
3P2B2_ZLHCM Declustering B2 - Time Wage Types (Table ZL)11C1ZNRPointer to cost accountingvarbinary20
4P2BR_BRZLTime events in planned period7C1ZNRPointer to cost accountingvarbinary20
5P2CN_CNREIPayroll result: structure for retro difference details15C1ZNRPointer to cost accountingvarbinary20
6P2CN_CNREOPayroll result: structure for retro difference details15C1ZNRPointer to cost accountingvarbinary20
7P2CO_COAVAPC2CO_AVA29C1ZNRPointer to cost accountingvarbinary20
8P2HK_RETIPayroll structure for retroactive accounting17C1ZNRPointer to cost accountingvarbinary20
9P2HK_RETOPayroll structure for retroactive accounting17C1ZNRPointer to cost accountingvarbinary20
10P2IS_RETIPayroll structure for retroactive accounting17C1ZNRPointer to cost accountingvarbinary20
11P2IS_RETOPayroll structure for retroactive accounting17C1ZNRPointer to cost accountingvarbinary20
12P2KZ_FUPStructure for Table FUP - Future Periods14C1ZNRPointer to cost accountingvarbinary20
13P2NZ_SALSACSalary Sacrifice Details14C1ZNRPointer to cost accountingvarbinary20
14P2RA_DFRTPayroll Result for Other Payroll Periods15C1ZNRPointer to cost accountingvarbinary20
15P2RB_BEEVLPayroll Results: Belgium table for Evaluation13C1ZNRPointer to cost accountingvarbinary20
16P2RB_CIPayroll Result: Complementary Indemnity- CI (BE)49C1ZNRPointer to cost accountingvarbinary20
17P2RB_DAYDETDaydetails for payroll outsourcing (B)17C1ZNRPointer to cost accountingvarbinary20
18P2RD_XITPayroll Results: Extended IT9C1ZNRPointer to cost accountingvarbinary20
19P2RD_ZTPayroll Result: Time Data for Reduced Hours Compensation12C1ZNRPointer to cost accountingvarbinary20
20P2RD_ZTBAUPayroll Result: Construction Pay Daily Statement6C1ZNRPointer to cost accountingvarbinary20
21P2RF_ZLPTime Wage Types (Table ZL)9C1ZNRPointer to cost accountingvarbinary20
22P2RG_COSTSDistribution of Employer's Cost (Payroll Function XDEC)24C1ZNRPointer to cost accountingvarbinary20
23P2RG_MSAXMSA Changes Across EOY14C1ZNRPointer to cost accountingvarbinary20
24P2RG_PAEPensions Auto Enrolment - GB28C1ZNRPAE: Arrears C1 Splitvarbinary20
25P2RH_HU_HKIFP21PB12C1ZNRPointer to cost accountingvarbinary20
26P2RI_IPCUMRI cluster structure for cumulations (IPCUM)12C1ZNRPointer to cost accountingvarbinary20
27P2RI_ITIOTRI cluster structure for retroactive accounting14C1ZNRPointer to cost accountingvarbinary20
28P2RP_OVTime Wage Types (Table ZL)9C1ZNRPointer to cost accountingvarbinary20
29P2RQ_HTPayroll Results: Results Table12C1ZNRPointer to cost accountingvarbinary20
30P2RQ_NTPayroll Results: Results Table12C1ZNRPointer to cost accountingvarbinary20
31P2RQ_SMTHSMTH and SQTR for Superannuation (Australia)12C1ZNRPointer to cost accountingvarbinary20
32P2RQ_SQTRSMTH and SQTR for Superannuation (Australia)12C1ZNRPointer to cost accountingvarbinary20
33P2RR_RMPayroll Results: Table for Master data (SG)65C1ZNRPointer to cost accountingvarbinary20
34P2RR_SRTPayroll Results: Results Table12C1ZNRPointer to cost accountingvarbinary20
35P2RT_CZDAVP18_038C1ZNRPointer to cost accountingvarbinary20
36P2RU_CLMOverpayments Processing structure34C1ZNRPointer to cost accountingvarbinary20
37P2RU_CLM_PERSONOverpayments Processing structure36C1ZNRPointer to cost accountingvarbinary20
38P2RU_COSTSDistribution of Employer's Cost (Payroll Function XDEC)24C1ZNRPointer to cost accountingvarbinary20
39P2RX_ACCRPayroll Result: Month End Accruals8C1ZNRPointer to cost accountingvarbinary20
40P2RX_C1Cost Distribution Table C15C1ZNRPointer to cost accountingvarbinary20
41P2RX_CODISTDistribution opf Liabilities14C1ZNRPointer to cost accountingvarbinary20
42P2RX_GRTPayroll Results: Results Table12C1ZNRPointer to cost accountingvarbinary20
43P2RX_LIDICost-Distributed Liabilities7C1ZNRPointer to cost accountingvarbinary20
44P2RX_LSPayroll Results: Subsequent Time Tickets11C1ZNRPointer to cost accountingvarbinary20
45P2RX_RTPayroll Results: Results Table12C1ZNRPointer to cost accountingvarbinary20
46P2RX_RT_PERSONResults Table (Person)16C1ZNRPointer to cost accountingvarbinary20
47P2TN_TWOTPayroll Results: Results Table12C1ZNRPointer to cost accountingvarbinary20
48P2UA_FUPtable FUP - future periods14C1ZNRPointer to cost accountingvarbinary20
49P2UA_UARFStructure for Ukrainian social insurance(PF) calculation15C1ZNRPointer to cost accountingvarbinary20
50P2UA_UARTPayroll Results: Results Table12C1ZNRPointer to cost accountingvarbinary20
51P2UA_UATIStructure for Ukrainian social insurance(PF) calculation16C1ZNRPointer to cost accountingvarbinary20
52P2UA_UATRStructure for Ukrainian social insurance(PF) calculation16C1ZNRPointer to cost accountingvarbinary20
53P2UA_UATSStructure for Ukrainian social insurance(PF) calculation16C1ZNRPointer to cost accountingvarbinary20
54P2UN_HTPayroll Results: Results Table12C1ZNRPointer to cost accountingvarbinary20
55P2UN_NTPayroll Results: Results Table12C1ZNRPointer to cost accountingvarbinary20
56P2UR_FUPtable FUP - future periods14C1ZNRPointer to cost accountingvarbinary20
57P2UR_RURESRussian Statuses8C1ZNRPointer to cost accountingvarbinary20
58P2UR_RURTPayroll Results: Results Table12C1ZNRPointer to cost accountingvarbinary20
TOPAustria
59HRPAYAT_PAYRSRESSaves Wage Types from Simulated Payroll Results13C1ZNRPointer to cost accountingvarbinary20
TOPDenmark
60T5M9HSplit Indicators for Wage Types Sent to PBS13C1ZNRPointer to cost accountingvarbinary20
TOPGermany
61T5D0IFictitious Run Control: Wage Type Assignment17C1ZNRDelete Indicator for Cost Assignmentnvarchar10
TOPPayroll
62T5TPSC1SPLITRozdelení nákladu15C1ZNRPriraz.náklad.úcetnictvívarbinary20
TOPPayroll General Parts
63T558DTransfer Wage Types with Split Indicator11C1ZNRHR: Outsourcing: Pointer to cost accountingnvarchar40
TOPPersonnel Administration
64T7COT8Payroll external results transfer: COAVA29C1ZNRPointer to cost accountingvarbinary20
TOPPersonnel Management
65/BKC/S21_RT_NEUC&T! - Table RT for the payroll comparison programs16C1ZNRPointer to cost accountingvarbinary20
TOPTools
66T532BHR: Connection to Third-Party Payroll: Choice of Wage Types13C1ZNRComponent 709: Entry field for field selection in PC207nvarchar10