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
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OINM101Whse Journal

154 columns | Print definition?ERP 6.0  | MOABW

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVLTHCM_PERNRPersonnel Number Organisational data (Before Conversion)27MOABWPersonnel Subarea Grouping for Absence and Attendance Typesnvarchar20
2P2VE_ABC_EVALHRMS-VE: Record of Absences that Reduce Length of Service5MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
3T5A4ODescription of Attendance/Absence Categories3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
4T5A4PAttendance/Absence Categories2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
5T5BP1Control of Personal Calendar (B)2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
6T5BP2Grace period and regulations (B)2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
7T5BP3Responses personnel calendar2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
8T5DPBS3GAssignment of Absence to Absence Category2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
9T5FDSNABCATAbsence categories for DSN2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
10T5FPBS2BAutorisation des catégories d'absence (maladie)2MOABWGroupe de sous-domaines du pers. pour cat. abs./présencesnvarchar20
11T5GPBS31Absence Evaluation Cross Reference (T554S Extension)2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
12T5GPBS32Absence Evaluation: Linking Absence Grouping2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
13T5GPBSH_PLHESA: Parental Leave2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
14T5GPBSS_ABSSWF: Absences2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
15T5GPBST_EXCTPS Absence evaluation rules relevant as days excluded3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
16T5H47Ellátásfajták IT3267 infótípushoz3MOABWSzem.ü. részterületek csoportosít. távol-/jelenlétfajtákhoznvarchar20
17T5H48Távollétfajták - magyar customizing2MOABWSzem.ü. részterületek csoportosít. távol-/jelenlétfajtákhoznvarchar20
18T5PPBSABHR-PT-PS: Absence/Attendance types - Reporting clas. for PS2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
19T77PADKZAG0Attendance or Absence Groups2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
20T77PADKZAG0TAA Group Texts3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
21T77PADKZAG1Assign Attendance and Absence Types to Groups2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
22T77PAYAR_DIVABTable of Configurable Divisors for Leaves2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
23T7AEPBS22Service Duration Deduction3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
24T7AEPBS23Service Duration Deductions / Additions3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
25T7AEPBS66Absence Type Limit Condition3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
26T7KW08Absence Type Limit Condition2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
27T7KW09Absence Distribution Kuwait6MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
28T7OM28Absence Distribution Oman6MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
29T7OM33Absence Type Limit Condition2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
30T7QA16Absence Distribution Qatar6MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
31T7QA36Occupational Hazard Type Mapping Absence Type3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
32T7QA37Absences Type for Occupational Hazard2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
33T7QA88Absence for Qatar Fund Type3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
34T7QAPBS25Absence Type Limit Condition2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
35T7RU554SAdditional property of SocInsurance Absence Types2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
36T7RU_T554TAttendance and Absence Long Texts3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
37T7SA43Absence Type Identification3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
38T7SA44Valuation Rule Linking of Absence types3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
39T7SAMS02Service Duration Deduction5MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
40T7SAPBS31Absence Distribution KSA Public Sector3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
41T7SAPBS32Absence Distribution KSA Public Sector3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
42T7SAPBS37Absence Type Refinement Rule Group Assign3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
43T7SAPBS66Absence Type Limit Condition2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPArgentina
44T7AR45Additional information for absences2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPAustralia
45T5QIAPS Specific Characteristic for absence type6MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
46T5QLAAustralian Leave Accrual Unpaid Absence Rules4MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
47T5QRARedundancy LWOP Absences Australia3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPAustria
48T5A4QCharacteristics of Attendance/Absence Categories2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
49T5AE1Absence Types: Entry for Illness Notification3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
50T5AE2Absence Types: Alignment for Illness Notification3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
51T5AE3Absence Types: Conversion in Event of Missing Illness Notif.3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
52T5APBS20Properties for Absence Types for FRSC2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
53T5APBS22Properties for Absence Types for FRSC (New)2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPBelgium
54T5BP10Mapping of absence categories to internal absence types2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
55T5BP4Absence splitting table2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
56T5BP5Absence neighboring definition2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
57T5BP6Rules for absence collision2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
58T5BP8Absence category attributes2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
59T5BP9Absence processing BE: illness attributes table.2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPBrazil
60T7BR02Additional information for absence and quota generation2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
61T7BRABAdditional information for absences2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPBudget Management
62T7PMNValuation of Absence Types2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPCanada
63T5K0SSickness grouping for absence types2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
64T5K1AAbsence type reason relevant to ROE (Canada)2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
65T5KS2Short / long term disability: Assign absences to illnesses3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
66T5KV4Vacation pay: Absence types without corresp. entitlements2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
67T5UBX_GTL_AWARTProcessing group for absence types3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPChina
68T7CN82Define Relevant Absence Types3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPConstruction Industry
69T5DBIConstruct. Pay: Effects of Short Indicators for Trans. Data8MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPDenmark
70T5M_ABSTY_ABSCDLink: Absence Types and Employer Org. to Absence Codes2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
71T5M_ABS_TREATMNTAbsence Processing5MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPFinland
72T7FIAGFinnish absence classification2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
73T7FIAG_MULTIFinnish absence classification (multiple)2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
74T7FIWTEMWTE Model (Finland)13MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPFrance
75T5FDA1Absence categories for DADS-U structures2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
76T77TNM_DETNM: deduction customizing table6MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPGermany
77T5D0DPart Time Work During ParentalLeave2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
78T5D0SGrouping of Absences2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
79T5DL1Absence Events2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
80T5DL2Texts for Absence Events3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
81T5DL3Rules for Absence Events2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
82T5DL4Texts for Rules for Absence Events3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
83T5DL5Rule Type for Absence Events2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPItaly
84T5ITGGTable of general data for EEF3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
85T5ITI3Percentage table2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
86T5ITIEAbsence indicators2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
87T5ITIVNursing table2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPMexico
88T7MX40Additional information for absences2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPNetherlands
89T5NI4PW Absence Types2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPNew Zealand
90T7NZLSCountry Specific Attendance and Absence Types3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
91T7NZLULeave Unpaid Absence Rules - NZ5MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
92T7NZPLA/A types with absence quotas affected by parental leave3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPNorway
93T5VA5Norwegian absence classification2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPOff-Cycle
94T52OCAOff-Cycle Reasons for Absence Types4MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPPayroll
95T5HPBS65Rules for leave quota reduction2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
96T5T04Absences for reports2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
97T7SK04Grouping of absences for reports2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
98T7UAAG0Attendance or Absence Groups2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
99T7UAAG0TAA Group Texts3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
100T7UAAG1Asign Attendance and Absence Types to Groups2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
101T7UAT5Sick-list payments5MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPPension Administration
102T7DEPBSNV0DAssignment of Absence Types to Suspension Types2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPPersonnel Administration
103T001PPersonnel Area/Subarea9MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
104T5H5HAbsence identification to corrected absences on P04413MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
105T7CO07Absence general configuration3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPPersonnel Time Management
106T554GTypes of Birth3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
107T554MAbsences for Maternity Protection: Rule Table2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
108T554PSymbols for Attendances and Absences (Calendar)3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
109T554QAssignment of Valuation of Absences2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
110T554SAttendance and Absence Types2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
111T554S_ESSEXESS: Deactivation of Attendance/Absence types2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
112T554S_WEBESS Leave Request: Attributes of Attendance/Absence Types3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
113T554TAbsence and Attendance Texts3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
114T554VDefaults for Absence Types3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
115T554WPeriods of Military Service2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
116T555D[OBSOLETE; NOW USE T705A] Abs./Attendance Reasons Subsystem4MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
117T555G[OBSOLETE; NOW USE T705H] Att./Absence Reasons Subssys. Text5MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
118T556MProcess Partial-Day Absences Using XNAB Function2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
119T557CUReporting Time Types4MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
120T557GRelation Table: Absence/Attendance Accumulation4MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
121T705AAttendance/Absence Reasons for Subsystem4MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
122T705HAttendance/Absence Reason Texts for Subsystem5MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
123T77HRTIMABSGROUPGrouping of Attendance/Absence Types4MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPPortugal
124T5PABHR-PT: Absence/Attendance types - Reporting classification2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPPublic Sector
125T5APBS10Properties for Attendence/Absence Types for SI Publ. Sector2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
126T5PBSR1TLink table for absence and NS Type (No longer in use)3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
127T5PBSR3IDefine the maximum number of absence days w/o proration2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
128T5QPBS2AParameter setting for Prior Service and Leave Management2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
129T5QPBS2CMaster leave code and their characteristic2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
130T5QPBS2CTTexts for master leave code3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
131T5QPBS2DMapping business rules between PS Infotype 0573 and 20012MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
132T5QPBS2EParallel deduction sequence of quota types2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
133T5QPBS2JPS Specific Characteristic for absence type2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
134T5QPBS2KControl table for infotype 0573 popup2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
135T5QPBS2OImpact of Organizational change14MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
136T5QPBS5CHR AU PS:Australian absence type grouping2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
137T5RPBS8DOBSOLETE (Absences not counted as Pensionable Service)2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
138T5VPPS_SPKPCode for SPK for leave-agreement with valid years3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPPublic sector Sweden
139T5SAM_CEAbsences to Limit code Mapping2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
140T5SAW_CEPart-time absences made from WTs in infotype 146MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPReuse Services for Country Development
141T799L15Absence Grouping for Day Type in Divisor 303MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPRussia
142T7RUT5Social Insurance5MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
143T7RUT5_PAIDSocial Insurance - Paid days of illness3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
144T7RU_554TAbsence and Attendance Texts3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPShift Planning
145PSOLLShift Planning: Target Plan11MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
146T77EDShift Planning: Definition of Shifts14MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPSouth Africa
147T5W4SAbsence Types for UIF Download Report2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPSweden
148T5SMTMapping table for old and new absence types2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPTime Data Recording and Administration
149TMW_TDTYPETime Data ID7MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPTraining and Event Management
150T77KAIncompatible Attendances/Absences3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPUnited Kingdom
151T5GPBS33SxP Absence Processing Type2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPUSA
152T7US_FMLA_AB_ADMPermissibility of Absences for FMLA3MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
TOPVenezuela
153T7VEA2Transfer of external payroll results: Absence5MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20
154T7VEABAbsence Type Attributes2MOABWPersonnel subarea grouping for absence and attendance typesnvarchar20