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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
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
10OBOT10Bill Of Exchang Transaction

104 columns | Print definition?ERP 6.0  | MOZKO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T5AA0Absence Quota Type for Recognition of Leave3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
2T5R2FQuota Type Gerenation Rule Singapore3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
3T5R2GQuota Generation Rule Lists Singapore3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
4T5UPBSPOOLASick Leave Pool Attributes8MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
5T5UPBSPOOL_TRANSSick Leave Donation - transaction history record15MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
6T77TIM_AQGRPAbsence Quota Groups3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
7T77TIM_AQGRPTAbsence Quota Groups Description4MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
8T7AE20Leave Passage : Evaluation Wage Types per Quota Type3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
9T7AE21Assign Off-cycle Encashment Methods3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
10T7AEPBS66Absence Type Limit Condition6MOZKONot usednvarchar20
11T7INLEMET_WT_MAPMap quota compensation method with WT for 267 infotype4MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
12T7KW20Leave Passage : Evaluation Wage Types per Quota Type (KW)3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
13T7KW31Assign Off-cycle Encashment Methods (KW)3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
14T7OM20Leave Passage : Evaluation Wage Types per Quota Type (OM)3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
15T7OM23Assign Off-cycle Encashment Methods (OM)3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
16T7QA15Addtional Leave Quota Adjustment(QA)3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
17T7QA20Leave Passage : Evaluation Wage Types per Quota Type (QA)3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
18T7QA31Assign Off-cycle Encashment Methods (QA)3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
19T7RU_T559DRussian Validity Period: Absence Quotas for Default Values3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
20T7RU_T559LAutomatic Absence Quota Generation (Russian extension)3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
21T7SA29Leave Passage : Evaluation Wage Types per Quota Type3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
22T7SA31Assign Off-cycle Encashment Methods KSA3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
23T7SAPBS30Absence Quota Generation Refinement2MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
24T7UA556WWage Type Assignment for Absence Quota Comp-Ukranian fields4MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
TOPArgentina
25T7AR69Vacation provision: Calculation wage types3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
TOPAustralia
26T5QIAPS Specific Characteristic for absence type3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
27T5QIGLeave Quota Grouping3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
28T5QITCalculation rule for transfer frequency3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
29T5QLLAustralian Leave Loading - international leave3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
30T5QPRAust. Leave Provision for international leave3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
31T5QTRTerm. Rules for Long Serv. Leave & Leave Loading Australia5MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
TOPBelgium
32T5B31Translation Table BE Educational Leave Quotums3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
TOPBrazil
33T7BR86Wage types for saving entitlement to leave reserve3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
34T7BRCPWage type assignment for absence double compensation3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
35T7BRQCQuota compensation types3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
36T7BRQTAbsence quota type3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
TOPConstruction Industry
37T5DB_KTARTGRPAbsence Quota Types Groups for IT 20063MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
38T5DB_KTARTGRTTexts for Absence Quota Types Groups for IT 20064MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
39T5DB_UREGELNLeave Regulations for IT 20063MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
40T5DB_ZUORDUREGAssignments for Leave Regulations for IT 20064MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
TOPFinland
41T7FIV1Assignment of Vacation Quota Types to Wage Types3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
TOPFrance
42T77TNM_DETNM: deduction customizing table7MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
43T77TNM_QUTNM: quota customizing table6MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
TOPIntegration with Time Management
44T5DTM_URLAbsence Quota Types Specific to Germany3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
TOPNew Zealand
45T7NZLCLeave Payment Calculation Table - NZ4MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
46T7NZLLLeave Payment Calculation Table - NZ4MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
47T7NZLTTermination Wage Types for Leave NZ4MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
48T7NZLVLeave accrual payout rules on termination4MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
TOPNorway
49T5V3GLeave quota types3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
TOPPayroll
50T5HPBS64Controlling leave quotas3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
51T5HPBS66Rules for leave quota conflicts3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
52T5HPBS67Long texts for leave quota category4MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
53T5TL5Krácení kontingentu pro dovolenou v IT20063MOZKOSeskup.dílc.personálních oblastí pro typy kontingentu casunvarchar20
54T7BGQ3Vacation debt3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
55T7SKL5Quota reduction for leave in IT20063MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
56T7SKL6Quota reduction for leave in IT20063MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
TOPPersonnel Administration
57T001PPersonnel Area/Subarea16MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
58T7COQPAbsence quota attributes3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
59T7PLL0Allowed limits configuration3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
TOPPersonnel Time Management
60T554ABreakdown of Absences After Quota Deduction4MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
61T555LTransfer to Absence Quotas5MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
62T556AAbsence Quota Types3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
63T556A_WEBESS Leave Request: Quota Types for Display4MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
64T556BAbsence Quota Type Texts4MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
65T556CCounting Rule for Attendances and Absences3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
66T556DAbsence Counting With/Without Quotas Texts4MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
67T556PAttendance Quotas3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
68T556P_WEBESS Leave Request: Quota Types to Be Displayed4MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
69T556QAttendance Quota Type Texts4MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
70T556RRules for Deduction Sequence for Absence Quotas3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
71T556STexts for Deduction Sequence Rules for Absence Quotas4MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
72T556UAttendance/Absence Quota Compensation Types3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
73T556VTexts for Attendance/Absence Quota Compensation Types4MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
74T556WWage Type Assignment for Att./Absence Quota Compensations4MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
75T557JRelation Table: Quota Types for Reporting5MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
76T559DValidity/Deduction Interval for Absence Quotas3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
77T559D_WEBESS Leave Request: Obsolete; Now T556A_WEB3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
78T559EBase Entitlement for Leave Accrual3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
79T559FProcessing of Absence Quota Remainders4MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
80T559JConvert Leave Types to Quota Types5MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
81T559LAutomatic Absence Quota Generation3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
82T559QTTransfer Remaining Quota to New Quotas3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
83T559TTexts for Leave Accrual Rule4MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
84T559VValidity Period: Absence Quotas for Default Values3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
85T7TIM_BSB_KTARTAAssignment of Business Subject to an Absence Quota2MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
86T7TIM_BSB_KTARTPAssignment of Business Subject to an Attendance Quota2MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
87T7TIM_QUOTA_STEPRule Blocks Under QUOTA5MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
TOPPortugal
88T5PV1HR-PT: Assignment of quota type selection rule group3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
89T5PV2HR-PT: Classification of absence quota types3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
TOPPublic Sector
90T5QPBS2EParallel deduction sequence of quota types5MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
91T5QPBS2FLWOP/UNAL impact on individual leave type3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
92T5QPBS2NOrgn change & simulation quota for Absence Quotas3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
93T5QPBS2OImpact of Organizational change8MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
94T5QPBS2TTo determine the Seniority based on the Anniversary date3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
95T5QPBS5AHR AU PS:Australian Leave Loading3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
96T5QPBS5BHR AU PS:Australian Leave Loading for varying percentage3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
TOPPublic sector Sweden
97T5SVA_CEVacation debt3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
TOPReuse Services for Country Development
98T799L42Asignment between absence types and legal categories5MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
TOPRussia
99T7RU_556BAbsence Quota Type Texts4MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
TOPSweden
100T5SVAVacation and Compensation debt3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
TOPSwitzerland
101T5C20Time Quotas for Subapplications CH4MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
TOPTime Data Recording and Administration
102TMW_TDTYPETime Data ID22MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
TOPVenezuela
103T7VE10Assignment of date class to absence quota3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20
104T7VEQPAbsence quota attributes3MOZKOGrouping of Personnel Subareas for Time Quota Typesnvarchar20