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

65 columns | Print definition?ERP 6.0  | ABZNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2AR_ARDIVCorrection of days according to month divisor6ABZNRPointer to absencesvarbinary10
2P2B2_ABHCM Declustering B2 - Absences7ABZNRPointer to absencesvarbinary10
3P2B2_ZLHCM Declustering B2 - Time Wage Types (Table ZL)12ABZNRPointer to absencesvarbinary10
4P2BR_LADIVStructure with information for process table Div307ABZNRPointer to absencesvarbinary10
5P2CN_CNREIPayroll result: structure for retro difference details17ABZNRAbsence assignmentvarbinary10
6P2CN_CNREOPayroll result: structure for retro difference details17ABZNRAbsence assignmentvarbinary10
7P2CO_COABSPC2CO_ABS5ABZNRPointer to absencesvarbinary10
8P2CO_COAVAPC2CO_AVA31ABZNRAbsence assignmentvarbinary10
9P2CO_LADIVStructure with Information for Div30 Process Table7ABZNRPointer to absencesvarbinary10
10P2HK_RETIPayroll structure for retroactive accounting19ABZNRAbsence assignmentvarbinary10
11P2HK_RETOPayroll structure for retroactive accounting19ABZNRAbsence assignmentvarbinary10
12P2IS_RETIPayroll structure for retroactive accounting19ABZNRAbsence assignmentvarbinary10
13P2IS_RETOPayroll structure for retroactive accounting19ABZNRAbsence assignmentvarbinary10
14P2KZ_FUPStructure for Table FUP - Future Periods15ABZNRAbsence assignmentvarbinary10
15P2NZ_SALSACSalary Sacrifice Details16ABZNRAbsence assignmentvarbinary10
16P2PL_EABPayroll Result PL: Split Y, absences5ABZNRPointer to absencesvarbinary10
17P2PL_ZLABASEResults of PLZLA operation5ABZNRAbsence assignmentvarbinary10
18P2RA_DFRTPayroll Result for Other Payroll Periods17ABZNRAbsence assignmentvarbinary10
19P2RB_BEEVLPayroll Results: Belgium table for Evaluation15ABZNRAbsence assignmentvarbinary10
20P2RF_ZLPTime Wage Types (Table ZL)10ABZNRPointer to absencesvarbinary10
21P2RH_HU_HKIFP21PB14ABZNRAbsence assignmentvarbinary10
22P2RI_IPCUMRI cluster structure for cumulations (IPCUM)14ABZNRAbsence assignmentvarbinary10
23P2RI_ITIOTRI cluster structure for retroactive accounting16ABZNRAbsence assignmentvarbinary10
24P2RO_RO_ABXExtension of AB table5ABZNRPointer to absencesvarbinary10
25P2RP_LADIVStructure with Information for Div30 Process Table7ABZNRPointer to absencesvarbinary10
26P2RP_OVTime Wage Types (Table ZL)10ABZNRPointer to absencesvarbinary10
27P2RQ_HTPayroll Results: Results Table14ABZNRAbsence assignmentvarbinary10
28P2RQ_NTPayroll Results: Results Table14ABZNRAbsence assignmentvarbinary10
29P2RQ_SMTHSMTH and SQTR for Superannuation (Australia)14ABZNRAbsence assignmentvarbinary10
30P2RQ_SQTRSMTH and SQTR for Superannuation (Australia)14ABZNRAbsence assignmentvarbinary10
31P2RR_RMPayroll Results: Table for Master data (SG)66ABZNRPointer to absencesvarbinary10
32P2RR_SRTPayroll Results: Results Table14ABZNRAbsence assignmentvarbinary10
33P2RT_ABAUSStructure of ABAUS - Paid illness5ABZNRPointer to absencesvarbinary10
34P2RV_RMBRMB Structure for Norway Reimbursement5ABZNRAbsence assignmentvarbinary10
35P2RX_ABCluster RD/B2: Table AB5ABZNRPointer to absencesvarbinary10
36P2RX_CODISTDistribution opf Liabilities16ABZNRAbsence assignmentvarbinary10
37P2RX_GRTPayroll Results: Results Table14ABZNRAbsence assignmentvarbinary10
38P2RX_RTPayroll Results: Results Table14ABZNRAbsence assignmentvarbinary10
39P2RX_RT_PERSONResults Table (Person)18ABZNRAbsence assignmentvarbinary10
40P2SK_ABAUSDocuments for absence5ABZNRPointer to absencesvarbinary10
41P2TN_TWOTPayroll Results: Results Table14ABZNRAbsence assignmentvarbinary10
42P2UA_FUPtable FUP - future periods15ABZNRAbsence assignmentvarbinary10
43P2UA_UAILLstruc.UAILL - information about sick-list compensation calc.7ABZNRPointer to absencesvarbinary10
44P2UA_UARFStructure for Ukrainian social insurance(PF) calculation17ABZNRAbsence assignmentvarbinary10
45P2UA_UARTPayroll Results: Results Table14ABZNRAbsence assignmentvarbinary10
46P2UA_UATIStructure for Ukrainian social insurance(PF) calculation18ABZNRAbsence assignmentvarbinary10
47P2UA_UATRStructure for Ukrainian social insurance(PF) calculation18ABZNRAbsence assignmentvarbinary10
48P2UA_UATSStructure for Ukrainian social insurance(PF) calculation18ABZNRAbsence assignmentvarbinary10
49P2UN_HTPayroll Results: Results Table14ABZNRAbsence assignmentvarbinary10
50P2UN_NTPayroll Results: Results Table14ABZNRAbsence assignmentvarbinary10
51P2UR_FUPtable FUP - future periods15ABZNRAbsence assignmentvarbinary10
52P2UR_RURTPayroll Results: Results Table14ABZNRAbsence assignmentvarbinary10
TOPAustria
53HRPAYAT_PAYRSRESSaves Wage Types from Simulated Payroll Results15ABZNRAbsence assignmentvarbinary10
TOPDenmark
54T5M9HSplit Indicators for Wage Types Sent to PBS15ABZNRAbsence assignmentvarbinary10
TOPGermany
55T5D0IFictitious Run Control: Wage Type Assignment19ABZNRDelete Indicator for Absencesnvarchar10
TOPPayroll
56T5T558_ABHRCZ - Tabulka pro prenos neprítomností pri upgrade na SAP4ABZNRUkazatel na neprítomnostivarbinary10
57T5T558_ABAUSHRCZ - Tabulka pro prenos dat pro ABAUS pri upgrade na SAP4ABZNRUkazatel na neprítomnostivarbinary10
58T7RO558_ABTransfer absences (supplement to T558D)4ABZNRPointer to absencesvarbinary10
59T7ROA4Sick leaves - Person 1:1 with RGDIR4ABZNRPointer to absencesvarbinary10
60T7SK558_ABTransfer absences (supplement to T558D) - SK4ABZNRPointer to absencesvarbinary10
TOPPayroll General Parts
61T558DTransfer Wage Types with Split Indicator13ABZNRHR: Outsourcing: Absence assignmentnvarchar20
TOPPersonnel Administration
62T7COT4Payroll external results transfer: COABS5ABZNRPointer to absencesvarbinary10
63T7COT8Payroll external results transfer: COAVA31ABZNRAbsence assignmentvarbinary10
TOPPersonnel Management
64/BKC/S21_RT_NEUC&T! - Table RT for the payroll comparison programs18ABZNRAbsence assignmentvarbinary10
TOPTools
65T532BHR: Connection to Third-Party Payroll: Choice of Wage Types15ABZNRComponent 709: Entry field for field selection in PC207nvarchar10