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

125 columns | Print definition?ERP 6.0  | ABART

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1ARBERP_D_SO_SARSAR versioning for outbound messages4ABARTScheduling agreement release typenvarchar10
2P2B2_ABHCM Declustering B2 - Absences8ABARTSettlement Typenvarchar10
3P2B2_WPBPHCM Declustering B2 - Payroll Results Work Center/Basic Pay22ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
4P2CN_CNREIPayroll result: structure for retro difference details8ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
5P2CN_CNREOPayroll result: structure for retro difference details8ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
6P2CO_COAVAPC2CO_AVA22ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
7P2HK_RETIPayroll structure for retroactive accounting10ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
8P2HK_RETOPayroll structure for retroactive accounting10ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
9P2HR_CUFStructure of difference table Croatia5ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
10P2HR_CUPStructure of difference table Croatia5ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
11P2HR_DTFStructure of difference table Croatia5ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
12P2HR_DTPStructure of difference table Croatia5ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
13P2IS_RETIPayroll structure for retroactive accounting10ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
14P2IS_RETOPayroll structure for retroactive accounting10ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
15P2KR_BEN_BPSPayroll result for benefit point request6ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
16P2KZ_FUPStructure for Table FUP - Future Periods8ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
17P2NZ_SALSACSalary Sacrifice Details7ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
18P2PL_RETROADJPayroll Result PL: Retro, originals and changes7ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
19P2PL_RETRODIFPayroll Result PL: Retro, originals and changes7ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
20P2PL_RETROMEMPayroll Result PL: Retro, originals and changes7ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
21P2RA_DFRTPayroll Result for Other Payroll Periods8ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
22P2RH_HU_HKIFP21PB5ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
23P2RI_IPCUMRI cluster structure for cumulations (IPCUM)5ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
24P2RI_ITIOTRI cluster structure for retroactive accounting7ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
25P2RQ_HTPayroll Results: Results Table5ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
26P2RQ_NTPayroll Results: Results Table5ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
27P2RQ_SMTHSMTH and SQTR for Superannuation (Australia)5ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
28P2RQ_SQTRSMTH and SQTR for Superannuation (Australia)5ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
29P2RR_SRTPayroll Results: Results Table5ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
30P2RX_ABCluster RD/B2: Table AB6ABARTSettlement Typenvarchar10
31P2RX_ACCRPayroll Result: Month End Accruals5ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
32P2RX_DFTPayroll Results: Differences for Gross/Net Payroll5ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
33P2RX_GRTPayroll Results: Results Table5ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
34P2RX_RTPayroll Results: Results Table5ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
35P2RX_RT_PERSONResults Table (Person)9ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
36P2RX_WPBPPayroll Results: Work Center/Basic Pay20ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
37P2SI_CUFDifference table of payroll results5ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
38P2SI_CUPDifference table of payroll results5ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
39P2SI_DTFDifference table of payroll results5ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
40P2SI_DTPDifference table of payroll results5ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
41P2TN_TWOTPayroll Results: Results Table5ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
42P2UA_FUPtable FUP - future periods8ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
43P2UA_UARFStructure for Ukrainian social insurance(PF) calculation8ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
44P2UA_UARTPayroll Results: Results Table5ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
45P2UA_UATIStructure for Ukrainian social insurance(PF) calculation9ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
46P2UA_UATRStructure for Ukrainian social insurance(PF) calculation9ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
47P2UA_UATSStructure for Ukrainian social insurance(PF) calculation9ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
48P2UN_HTPayroll Results: Results Table5ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
49P2UN_NTPayroll Results: Results Table5ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
50P2UR_FUPtable FUP - future periods8ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
51P2UR_RURTPayroll Results: Results Table5ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
52T517AEducational Establishment Types/Final Certificates3ABARTCertificatenvarchar20
53T546Employee Subgroup for PersCalcRule/CollAgreemProvision2ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
54TKKAS_CONVCopy of TKKAS9ABARTResults Analysis Typenvarchar10
55TN23OEBSDE: Outpatient P301 Billing: OU-POWN Assignment4ABARTIS-H: Billing Type for Patient Accountingnvarchar20
56ZEIM_LIPSSD document: Delivery: Item data136ABARTRelease typenvarchar10
57ZEIM_VBEPSales Document: Schedule Line Data36ABARTRelease typenvarchar10
TOPAgency Business Global Trade
58TMFKAgency Business: Billing Document Types15ABARTSettlement Typenvarchar10
59WBRKAgency business: Header8ABARTSettlement Typenvarchar10
TOPBasic Data
60TNF32IS-H: Work Organizers with Billing Type and Ins. Prov. Cond.5ABARTIS-H: Billing Type for Patient Accountingnvarchar20
61TNRELIS-H: Insurance Provider Assignments8ABARTIS-H: Billing Type for Patient Accountingnvarchar20
TOPBelgium
62T5BVDMapping Table Educational Type3ABARTCertificatenvarchar20
TOPCost Object
63TKKASControl Table for Results Analysis9ABARTResults Analysis Typenvarchar10
64TKKAUResults Analysis Methods - Default Values in TKKAS5ABARTResults Analysis Typenvarchar10
TOPCross-Application Components
65VVBEPSales Document: Schedule Line Data36ABARTRelease typenvarchar10
TOPDenmark
66T5M9HSplit Indicators for Wage Types Sent to PBS19ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
TOPEnhancements to scheduling agreements MM Outbound
67ISAUTOEKLWESLast Deliveries for FLAB4ABARTRelease typenvarchar10
68ISAUTOEKLWESHLast Deliveries for FLAB4ABARTRelease typenvarchar10
TOPFinland
69T7FIV0Holiday Bonus Handling Types2ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
TOPGermany
70T5D0IFictitious Run Control: Wage Type Assignment11ABARTNotional Run Control: Employee Subgroup Proc. Groupingnvarchar10
TOPHong Kong
71T7HK4BFactor & constants for LSP/severance payments2ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
TOPPatient Accounting
72NTFIIS-H: Service Catalog Determination Rules9ABARTIS-H: Billing Type for Patient Accountingnvarchar20
73NVBRPIS-H: Billing document item data58ABARTIS-H: Billing Type for Patient Accountingnvarchar20
74TN20AIS-H: Service Catalog Column Determination5ABARTIS-H: Billing Type for Patient Accountingnvarchar20
75TN21IS-H: Billing Types3ABARTIS-H: Billing Type for Patient Accountingnvarchar20
76TN21AIS-H: Billing Type Determination8ABARTIS-H: Billing Type for Patient Accountingnvarchar20
77TN21TIS-H: Texts for Billing Types4ABARTIS-H: Billing Type for Patient Accountingnvarchar20
TOPPayroll
78T5T558_ABHRCZ - Tabulka pro prenos neprítomností pri upgrade na SAP5ABARTDruh zúctovánínvarchar10
79T7BGQ3Vacation debt4ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
80T7SK558_ABTransfer absences (supplement to T558D) - SK5ABARTSettlement Typenvarchar10
TOPPayroll General Parts
81HRPY_CYCLEINFOComments for Payroll Rules3ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
82HRPY_WPBPHR-PAY: Transparent Table WPBP18ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
83T52C5Personnel Calculation Rules3ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
84T546AEmployee Subgroup Grouping for Payroll2ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
85T546TEE Subgroup Groupings for Personnel Calculation Rules3ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
86T558DTransfer Wage Types with Split Indicator4ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
TOPPersonnel Administration
87T503Employee Group/Subgroup4ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
88T7COT8Payroll external results transfer: COAVA22ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
89T7SI0VEducational Establishment Types/Final Certificates3ABARTRequired educational levelnvarchar30
TOPPersonnel Cost Planning
90HRP1015Infotype 1015 DB table21ABARTTime unit (payroll type) used to evaluate the wage elementnvarchar10
91T77KLWage Elements in Personnel Cost Planning9ABARTTime unit (payroll type) used to evaluate the wage elementnvarchar10
TOPPersonnel Management
92/BKC/S21_RT_NEUC&T! - Table RT for the payroll comparison programs5ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
TOPPersonnel Time Management
93T555MPDC Accounting Types3ABARTEmployee grouping for the time evaluation rulenvarchar10
94T555NEmployee Grouping for the Time Evaluation Rule2ABARTEmployee grouping for the time evaluation rulenvarchar10
TOPPublic sector Sweden
95T5SVA_CEVacation debt4ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
TOPPurchasing
96EKEHScheduling Agreement Release Documentation4ABARTScheduling agreement release typenvarchar10
97EKEHHRemoved Scheduling Agreement Release Documentation4ABARTScheduling agreement release typenvarchar10
98EKEKHeader Data for Scheduling Agreement Releases4ABARTScheduling agreement release typenvarchar10
99EKEKHRemoved Header Data of Scheduling Agreement Releases4ABARTScheduling agreement release typenvarchar10
100EKETScheduling Agreement Schedule Lines29ABARTScheduling agreement release typenvarchar10
101EKETHScheduling Agreement Schedules: History Tables29ABARTScheduling agreement release typenvarchar10
TOPReuse Services for Country Development
102T599ETime-Dependent Rounding for Operation RNDC4ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
TOPSales
103VBAGSales Document: Release Data by Schedule Line in Sch.Agrmt.4ABARTRelease typenvarchar10
104VBEHSchedule line history6ABARTRelease typenvarchar10
105VBEPSales Document: Schedule Line Data36ABARTRelease typenvarchar10
106VBLBSales document: Release order data5ABARTRelease typenvarchar10
TOPSAP Healthcare - Industry-Specific Components for Hospitals
107/ISHFR/TN21AIS-H FR: Determine Billing Type10ABARTIS-H: Billing Type for Patient Accountingnvarchar20
108NNTFIS-H NL: Service Catalog Determination12ABARTIS-H: Billing Type for Patient Accountingnvarchar20
109TN22DIS-H: Steuerungstabelle für Art der ambulanten Zuzahlung4ABARTIS-H: Abrechnungsart der Patientenabrechnungnvarchar20
110TNEO_BILLTYP_DETIS-H: External Orders - Billing Type Determination8ABARTIS-H: Billing Type for Patient Accountingnvarchar20
111TNWCH107Billing Type Determination for Fee Billing11ABARTIS-H: Billing Type for Patient Accountingnvarchar20
112TNWCH81IS-H CH: Billing Type Determination12ABARTIS-H: Billing Type for Patient Accountingnvarchar20
113TNWCH83Ermittlung der Baserate3ABARTIS-H: Abrechnungsart der Patientenabrechnungnvarchar20
114TNWCHEA10IS-H CH: Abrechnungsartenermittlung für Externe Aufträge8ABARTIS-H: tipo fatturazione della fatturazione pazientenvarchar20
TOPShipping
115LIPSSD document: Delivery: Item data136ABARTRelease typenvarchar10
TOPSimulation
116VSVBEP_CNVersion: Sales document: Schedule line data37ABARTRelease typenvarchar10
TOPStatements
117P01W_DBAEData Module: Statement of Earnings - Remuneration15ABARTFixed Monthly Salary/Monthly Remunerationnvarchar10
118P01W_DBEKData Module: Statement of Earnings for Sick Child36ABARTFixed Monthly Salary/Monthly Remunerationnvarchar10
119P01W_DBKRData Module: Remuneration Statement for Sick Pay50ABARTFixed Monthly Salary/Monthly Remunerationnvarchar10
120P01W_DBMUData Module: Statement of Earnings, Maternity Pay52ABARTFixed Monthly Salary/Monthly Remunerationnvarchar10
TOPStatistical Key Figures
121TAPRFCap. inv. measure profile for AuC and dep. simulation10ABARTIndicator: Line item settlement of inv. measurenvarchar10
TOPSweden
122T5SVAVacation and Compensation debt5ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
TOPSwitzerland
123T5C3HHR-CH: Control of End of Year Bonus (13th Wage)4ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
124T5CZVHR-CH: Differing Reduction Rules4ABARTEmployee subgroup grouping for personnel calculation rulenvarchar10
TOPTools
125T532BHR: Connection to Third-Party Payroll: Choice of Wage Types6ABARTComponent 709: Entry field for field selection in PC207nvarchar10