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

152 columns | Print definition?ERP 6.0  | AWART

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2B2_ABHCM Declustering B2 - Absences18AWARTAttendance or Absence Typenvarchar40
2P2B2_ANWESHCM Declustering B2 - Attendances (Table ANWES)13AWARTAttendance or Absence Typenvarchar40
3P2CO_COABSPC2CO_ABS7AWARTAttendance or Absence Typenvarchar40
4P2CO_COAVAPC2CO_AVA13AWARTAttendance or Absence Typenvarchar40
5P2NZ_LVPAYPayroll Result: Leave Payment LVPAY - NZ13AWARTAttendance or Absence Typenvarchar40
6P2PL_EABPayroll Result PL: Split Y, absences8AWARTAttendance or Absence Typenvarchar40
7P2RD_STUTax Payment Interruption up to Payroll Period7AWARTAttendance or Absence Typenvarchar40
8P2RP_VAHR-PT: Payroll Results: Vacation allowance grouping (VA)30AWARTAbsence type of leave period triggering allowance paymentnvarchar40
9P2RQ_SUPCOMSuperable salary components21AWARTAttendance or Absence Typenvarchar40
10P2RT_ABAUSStructure of ABAUS - Paid illness10AWARTAttendance or Absence Typenvarchar40
11P2RX_ABCluster RD/B2: Table AB16AWARTAttendance or Absence Typenvarchar40
12P2SK_ABAUSDocuments for absence10AWARTAttendance or Absence Typenvarchar40
13P2UN_SUPCOMSuperable salary components For NPO21AWARTAttendance or Absence Typenvarchar40
14P2VE_ABC_EVALHRMS-VE: Record of Absences that Reduce Length of Service6AWARTAttendance or Absence Typenvarchar40
15PA0601Antécédent d'absences (Infotype 0601)24AWARTCatégorie absence/présencenvarchar40
16PA3267Személyügyi törzsrekord, 3267 infótípus25AWARTTávol- vagy jelenlétfajtanvarchar40
17PAPBSGB_SWF_ABSSWF: Absences9AWARTAttendance or Absence Typenvarchar40
18T5DPBS3GAssignment of Absence to Absence Category3AWARTAttendance or Absence Typenvarchar40
19T5FDSNABCATAbsence categories for DSN3AWARTAttendance or Absence Typenvarchar40
20T5FPBS2BAutorisation des catégories d'absence (maladie)3AWARTCatégorie absence/présencenvarchar40
21T5GPBSH_PLHESA: Parental Leave3AWARTAttendance or Absence Typenvarchar40
22T5H47Ellátásfajták IT3267 infótípushoz7AWARTTávol- vagy jelenlétfajtanvarchar40
23T5H48Távollétfajták - magyar customizing3AWARTTávol- vagy jelenlétfajtanvarchar40
24T77PADKZAG1Assign Attendance and Absence Types to Groups4AWARTAttendance or Absence Typenvarchar40
25T7AE16Absence Distribution UAE6AWARTAttendance or Absence Typenvarchar40
26T7AEPBS22Service Duration Deduction6AWARTAttendance or Absence Typenvarchar40
27T7AEPBS66Absence Type Limit Condition4AWARTAttendance or Absence Typenvarchar40
28T7KW08Absence Type Limit Condition3AWARTAttendance or Absence Typenvarchar40
29T7KW09Absence Distribution Kuwait7AWARTAttendance or Absence Typenvarchar40
30T7OM28Absence Distribution Oman7AWARTAttendance or Absence Typenvarchar40
31T7OM33Absence Type Limit Condition3AWARTAttendance or Absence Typenvarchar40
32T7QA16Absence Distribution Qatar7AWARTAttendance or Absence Typenvarchar40
33T7QA36Occupational Hazard Type Mapping Absence Type4AWARTAttendance or Absence Typenvarchar40
34T7QA37Absences Type for Occupational Hazard3AWARTAttendance or Absence Typenvarchar40
35T7QA38Absences Type for Occupational Hazard(Obsolete)2AWARTAttendance or Absence Typenvarchar40
36T7QA84Qatar Statutory Social Insurance Fund Type26AWARTAttendance or Absence Typenvarchar40
37T7QA85Absence for Qatar Fund Type3AWARTAttendance or Absence Typenvarchar40
38T7QA88Absence for Qatar Fund Type4AWARTAttendance or Absence Typenvarchar40
39T7QAPBS25Absence Type Limit Condition3AWARTAttendance or Absence Typenvarchar40
40T7RU51AV_PTCalculation Rules for Averages: Connection of Frozen Average6AWARTAttendance or Absence Typenvarchar40
41T7RU554CRelation between absence type and wage type for days of abse4AWARTAttendance or Absence Typenvarchar40
42T7RU554SAdditional property of SocInsurance Absence Types3AWARTAttendance or Absence Typenvarchar40
43T7RU_T554TAttendance and Absence Long Texts4AWARTAttendance or Absence Typenvarchar40
44T7SA16Absence Distribution KSA6AWARTAttendance or Absence Typenvarchar40
45T7SA43Absence Type Identification7AWARTAttendance or Absence Typenvarchar40
46T7SAMS02Service Duration Deduction6AWARTAttendance or Absence Typenvarchar40
47T7SAPBS09Absences Type for Occupational Hazard2AWARTAttendance or Absence Typenvarchar40
48T7SAPBS31Absence Distribution KSA Public Sector7AWARTAttendance or Absence Typenvarchar40
49T7SAPBS32Absence Distribution KSA Public Sector7AWARTAttendance or Absence Typenvarchar40
50T7SAPBS37Absence Type Refinement Rule Group Assign4AWARTAttendance or Absence Typenvarchar40
51T7SAPBS66Absence Type Limit Condition3AWARTAttendance or Absence Typenvarchar40
52ZCATSDBRecords changed with processing status '10'30AWARTnvarchar40
53ZCATSDB2Records changed with processing status '10'31AWARTnvarchar40
54ZZZ_IF_KRANKInterface Meldesatz Krankenstände4AWARTAb- oder Anwesenheitsartnvarchar40
TOPAttendancesAbsences
55CATSHRCross-Application Time Sheet (CATS): Transfer to HR40AWARTAttendance or Absence Typenvarchar40
TOPAustralia
56T5QIAPS Specific Characteristic for absence type7AWARTAttendance or Absence Typenvarchar40
57T5QLAAustralian Leave Accrual Unpaid Absence Rules5AWARTAttendance or Absence Typenvarchar40
58T5QRARedundancy LWOP Absences Australia4AWARTAttendance or Absence Typenvarchar40
TOPAustria
59T5AE1Absence Types: Entry for Illness Notification7AWARTAttendance or Absence Typenvarchar40
60T5AE2Absence Types: Alignment for Illness Notification4AWARTAttendance or Absence Typenvarchar40
61T5AE3Absence Types: Conversion in Event of Missing Illness Notif.4AWARTAttendance or Absence Typenvarchar40
62T5APBS20Properties for Absence Types for FRSC3AWARTAttendance or Absence Typenvarchar40
63T5APBS22Properties for Absence Types for FRSC (New)4AWARTAttendance or Absence Typenvarchar40
TOPBudget Management
64T7PMNValuation of Absence Types3AWARTAttendance or Absence Typenvarchar40
TOPCalculation of Employment Period
65T525ASelection Rules for Employee Data15AWARTAttendance or Absence Typenvarchar40
TOPCanada
66T5K1AAbsence type reason relevant to ROE (Canada)3AWARTAttendance or Absence Typenvarchar40
67T5KV4Vacation pay: Absence types without corresp. entitlements3AWARTAttendance or Absence Typenvarchar40
68T5UBX_GTL_AWARTProcessing group for absence types4AWARTAttendance or Absence Typenvarchar40
TOPChile
69T7CL25Personnel Action Code Master5AWARTAttendance or Absence Typenvarchar40
TOPConstruction Industry
70PA0215Construction Pay Transaction Data35AWARTAttendance or Absence Typenvarchar40
71T5DBDConstruction: Meal+Separation Allowances/Travel Costs3AWARTType of Expensenvarchar10
72T5DBGTexts for Construction Pay Expenses4AWARTType of Expensenvarchar10
73T5DBIConstruct. Pay: Effects of Short Indicators for Trans. Data9AWARTAttendance or Absence Typenvarchar40
74T5DBOConstruction Pay Expenses: Permissible Entries3AWARTType of Expensenvarchar10
TOPESS Based on WD ABAP
75HRESS_D_CATS_FAVCATS Favorites: database table37AWARTAttendance or Absence Typenvarchar40
TOPFinland
76T7FIAGFinnish absence classification3AWARTAttendance or Absence Typenvarchar40
77T7FIAG_MULTIFinnish absence classification (multiple)3AWARTAttendance or Absence Typenvarchar40
TOPFrance
78PA0424Industrial accident / maternity / sickness statement (FR)67AWARTAttendance or Absence Typenvarchar40
79T5F2DProcess grace period for continued pay3AWARTAttendance or Absence Typenvarchar40
80T5FDA1Absence categories for DADS-U structures3AWARTAttendance or Absence Typenvarchar40
TOPGermany
81PA0597Personnel Master Record Infotype 059724AWARTAttendance or Absence Typenvarchar40
82T5D0DPart Time Work During ParentalLeave3AWARTAttendance or Absence Typenvarchar40
83T5D0SGrouping of Absences3AWARTAttendance or Absence Typenvarchar40
84T5DL5Rule Type for Absence Events5AWARTAttendance or Absence Typenvarchar40
TOPGreat Britain
85T5G26OSP-Related Data for SSP Offsetting3AWARTAttendance or Absence Typenvarchar40
TOPItaly
86PA0407HR master record, infotype 0407 (Abs.addit.inf.)24AWARTAttendance or Absence Typenvarchar40
87T5ITGGTable of general data for EEF16AWARTAttendance or Absence Typenvarchar40
88T5ITIEAbsence indicators3AWARTAttendance or Absence Typenvarchar40
89T5ITIVNursing table3AWARTAttendance or Absence Typenvarchar40
TOPNetherlands
90PA3250HR Master Record: Infotype 325040AWARTAttendance or Absence Typenvarchar40
TOPNew Zealand
91HNZLVPAYTable for modified LVPAY cluster table records15AWARTAttendance or Absence Typenvarchar40
92PT2001HR Time Record: Infotype 2001 (Absences)27AWARTAttendance or Absence Typenvarchar40
93T7NZLULeave Unpaid Absence Rules - NZ6AWARTAttendance or Absence Typenvarchar40
TOPNon Profit Organizations
94T7UNPAD_AWARTNPO Aspects for Attendance/Absence Types2AWARTAttendance or Absence Typenvarchar40
95T7UNPAD_PA2001EXExtract of PA2001 fields; for use by sick leave combined9AWARTAttendance or Absence Typenvarchar40
96T7UNSLWOP_RCSLWOP periods to be ignored for next reclassification date2AWARTAttendance or Absence Typenvarchar40
TOPNorway
97T5VA5Norwegian absence classification3AWARTAttendance or Absence Typenvarchar40
TOPOff-Cycle
98T52OCAOff-Cycle Reasons for Absence Types5AWARTAttendance or Absence Typenvarchar40
TOPPayroll
99T5H1OControl table to private pension fund monthly report7AWARTAttendance or Absence Typenvarchar40
100T5HPBS37Long-term absences2AWARTAttendance or Absence Typenvarchar40
101T5T558_ABHRCZ - Tabulka pro prenos neprítomností pri upgrade na SAP15AWARTDruh ne-/prítomnostínvarchar40
102T5T558_ABAUSHRCZ - Tabulka pro prenos dat pro ABAUS pri upgrade na SAP9AWARTDruh ne-/prítomnostínvarchar40
103T7SK558_ABTransfer absences (supplement to T558D) - SK15AWARTAttendance or Absence Typenvarchar40
104T7TRS03Sosyal Sigortalar Gününden düsülen devamsizlik türleri2AWARTDevamsizlik ya da devam türünvarchar40
105T7UAAG1Asign Attendance and Absence Types to Groups4AWARTAttendance or Absence Typenvarchar40
106T7UAT5Sick-list payments6AWARTAttendance or Absence Typenvarchar40
TOPPension Administration
107T7DEPBSNV0DAssignment of Absence Types to Suspension Types3AWARTAttendance or Absence Typenvarchar40
TOPPersonnel Administration
108PA0834HR master record for infotypes 083436AWARTAttendance or Absence Typenvarchar40
109T5H4RAccountable lost time in calculation of SI average2AWARTAttendance or Absence Typenvarchar40
110T5H5HAbsence identification to corrected absences on P04416AWARTAttendance or Absence Typenvarchar40
111T7CO01Additional data of the company35AWARTAbsence type - Leavenvarchar40
112T7CO07Absence general configuration5AWARTAttendance or Absence Typenvarchar40
113T7COT4Payroll external results transfer: COABS7AWARTAttendance or Absence Typenvarchar40
114T7COT8Payroll external results transfer: COAVA13AWARTAttendance or Absence Typenvarchar40
TOPPersonnel Time Management
115PA2001HR Time Record: Infotype 2001 (Absences)27AWARTAttendance or Absence Typenvarchar40
116PA2002HR Time Record: Infotype 2002 (Attendances)27AWARTAttendance or Absence Typenvarchar40
117PTEX2000Interface Table for Attendances/Absences Infotype(2001/2002)29AWARTAttendance or Absence Typenvarchar40
118T554MAbsences for Maternity Protection: Rule Table3AWARTAttendance or Absence Typenvarchar40
119T554TAbsence and Attendance Texts4AWARTAttendance or Absence Typenvarchar40
120T554VDefaults for Absence Types4AWARTAttendance or Absence Typenvarchar40
121T554WPeriods of Military Service3AWARTAttendance or Absence Typenvarchar40
122T555D[OBSOLETE; NOW USE T705A] Abs./Attendance Reasons Subsystem8AWARTAttendance or Absence Typenvarchar40
123T557CUReporting Time Types5AWARTAttendance or Absence Typenvarchar40
124T557GRelation Table: Absence/Attendance Accumulation5AWARTAttendance or Absence Typenvarchar40
125T705AAttendance/Absence Reasons for Subsystem8AWARTAttendance or Absence Typenvarchar40
TOPPublic Sector
126T5APBS10Properties for Attendence/Absence Types for SI Publ. Sector3AWARTAttendance or Absence Typenvarchar40
127T5PBSR1TLink table for absence and NS Type (No longer in use)4AWARTAttendance or Absence Typenvarchar40
128T5PBSR3IDefine the maximum number of absence days w/o proration3AWARTAttendance or Absence Typenvarchar40
129T5QPBS2DMapping business rules between PS Infotype 0573 and 20014AWARTAttendance or Absence Typenvarchar40
130T5QPBS2EParallel deduction sequence of quota types3AWARTAbsence types induced parallel deductionnvarchar40
131T5QPBS2JPS Specific Characteristic for absence type3AWARTAttendance or Absence Typenvarchar40
132T5QPBS2PAbsence records prior to Hiring3AWARTAttendance or Absence Typenvarchar40
133T5QPBS2RGrouping for LWOP/UNAL impact on leave accrual4AWARTAttendance or Absence Typenvarchar40
134T5QPBS5CHR AU PS:Australian absence type grouping4AWARTAttendance or Absence Typenvarchar40
135T5RPBS8QAbsence type for proration of Past salary for CPF refund2AWARTAttendance or Absence Typenvarchar40
136T5VPPS_SPKPCode for SPK for leave-agreement with valid years4AWARTAttendance or Absence Typenvarchar40
TOPPublic sector Sweden
137T5SAB_CEAbsence Properties2AWARTAttendance or Absence Typenvarchar40
138T5SAM_CEAbsences to Limit code Mapping4AWARTAttendance or Absence Typenvarchar40
TOPReuse Services for Country Development
139T799L15Absence Grouping for Day Type in Divisor 304AWARTAttendance or Absence Typenvarchar40
TOPRussia
140T7RUT5_PAIDSocial Insurance - Paid days of illness4AWARTAttendance or Absence Typenvarchar40
141T7RU_554TAbsence and Attendance Texts4AWARTAttendance or Absence Typenvarchar40
TOPShift Planning
142HRP1046Database Table for Infotype 104629AWARTAttendance or Absence Typenvarchar40
143HRP1049Database Tables for Infotype 104923AWARTAttendance or Absence Typenvarchar40
144PSOLLShift Planning: Target Plan12AWARTAttendance or Absence Typenvarchar40
145T77EDShift Planning: Definition of Shifts15AWARTAttendance or Absence Typenvarchar40
TOPSingapore
146T5R2BNRS Allowance averages calculation setting (SGP)2AWARTAttendance or Absence Typenvarchar40
TOPTaiwan
147T7TWABAbsence Split Assignment6AWARTAttendance or Absence Typenvarchar40
TOPTime Data Recording and Administration
148TMW_TDTYPETime Data ID8AWARTAttendance or Absence Typenvarchar40
TOPTime Sheet
149CATSDBCATS: Database Table for Time Sheet30AWARTAttendance or Absence Typenvarchar40
150CATS_TEMPCATS: Database Table for Templates32AWARTAttendance or Absence Typenvarchar40
151TCATX_DEDUCCATX: Data Derived from Type/Component/Level7AWARTAttendance or Absence Typenvarchar40
TOPVenezuela
152T7VEA2Transfer of external payroll results: Absence6AWARTAttendance or Absence Typenvarchar40