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

104 columns | Print definition?ERP 6.0  | MOPGK

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T5AA0Absence Quota Type for Recognition of Leave2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
2T5F03Employee groups/subgroups - special features (France)4MOPGKEmployee groups / subgroupsnvarchar20
3T5R2FQuota Type Gerenation Rule Singapore2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
4T5R2GQuota Generation Rule Lists Singapore2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
5T5UPBSPOOLASick Leave Pool Attributes7MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
6T5UPBSPOOL_TRANSSick Leave Donation - transaction history record14MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
7T77TIM_AQGRPAbsence Quota Groups2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
8T77TIM_AQGRPTAbsence Quota Groups Description3MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
9T7AE20Leave Passage : Evaluation Wage Types per Quota Type2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
10T7AE21Assign Off-cycle Encashment Methods2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
11T7AEPBS66Absence Type Limit Condition5MOPGKReserved Field/Unused Fieldnvarchar10
12T7INLEMET_WT_MAPMap quota compensation method with WT for 267 infotype3MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
13T7KW20Leave Passage : Evaluation Wage Types per Quota Type (KW)2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
14T7KW31Assign Off-cycle Encashment Methods (KW)2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
15T7OM20Leave Passage : Evaluation Wage Types per Quota Type (OM)2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
16T7OM23Assign Off-cycle Encashment Methods (OM)2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
17T7QA15Addtional Leave Quota Adjustment(QA)2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
18T7QA20Leave Passage : Evaluation Wage Types per Quota Type (QA)2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
19T7QA31Assign Off-cycle Encashment Methods (QA)2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
20T7RU_T559DRussian Validity Period: Absence Quotas for Default Values2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
21T7RU_T559LAutomatic Absence Quota Generation (Russian extension)2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
22T7SA29Leave Passage : Evaluation Wage Types per Quota Type2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
23T7SA31Assign Off-cycle Encashment Methods KSA2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
24T7SAPBS30Absence Quota Generation Refinement3MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
25T7UA556WWage Type Assignment for Absence Quota Comp-Ukranian fields3MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
TOPArgentina
26T7AR69Vacation provision: Calculation wage types2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
TOPAustralia
27T5QIAPS Specific Characteristic for absence type2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
28T5QIGLeave Quota Grouping2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
29T5QITCalculation rule for transfer frequency2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
30T5QLLAustralian Leave Loading - international leave2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
31T5QPRAust. Leave Provision for international leave2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
32T5QRTTerm. Rules for Long Serv-Leave & Leave Loading Australia3MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
33T5QTRTerm. Rules for Long Serv. Leave & Leave Loading Australia4MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
TOPBelgium
34T5B31Translation Table BE Educational Leave Quotums2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
TOPBrazil
35T7BR86Wage types for saving entitlement to leave reserve2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
36T7BRCPWage type assignment for absence double compensation2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
37T7BRQCQuota compensation types2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
38T7BRQTAbsence quota type2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
TOPConstruction Industry
39T5DB_KTARTGRPAbsence Quota Types Groups for IT 20062MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
40T5DB_KTARTGRTTexts for Absence Quota Types Groups for IT 20063MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
41T5DB_UREGELNLeave Regulations for IT 20062MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
42T5DB_ZUORDUREGAssignments for Leave Regulations for IT 20063MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
TOPFinland
43T7FIV1Assignment of Vacation Quota Types to Wage Types2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
TOPFrance
44T5F1DContributions plan3MOPGKEmployee groups / subgroupsnvarchar20
TOPIntegration with Time Management
45T5DTM_URLAbsence Quota Types Specific to Germany2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
TOPNew Zealand
46T7NZLCLeave Payment Calculation Table - NZ3MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
47T7NZLLLeave Payment Calculation Table - NZ3MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
48T7NZLTTermination Wage Types for Leave NZ3MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
49T7NZLVLeave accrual payout rules on termination3MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
TOPNorway
50T5V3GLeave quota types2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
TOPPayroll
51T5HPBS64Controlling leave quotas2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
52T5HPBS66Rules for leave quota conflicts2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
53T5HPBS67Long texts for leave quota category3MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
54T5TL5Krácení kontingentu pro dovolenou v IT20062MOPGKSeskupení okruhu pracovníku pro typy kontingentu casunvarchar10
55T7BGQ3Vacation debt2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
56T7SKL5Quota reduction for leave in IT20062MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
57T7SKL6Quota reduction for leave in IT20062MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
TOPPersonnel Administration
58T7COQPAbsence quota attributes2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
59T7PLL0Allowed limits configuration2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
TOPPersonnel Time Management
60T554ABreakdown of Absences After Quota Deduction5MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
61T555LTransfer to Absence Quotas4MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
62T556AAbsence Quota Types2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
63T556A_WEBESS Leave Request: Quota Types for Display3MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
64T556BAbsence Quota Type Texts3MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
65T556CCounting Rule for Attendances and Absences2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
66T556DAbsence Counting With/Without Quotas Texts3MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
67T556PAttendance Quotas2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
68T556P_WEBESS Leave Request: Quota Types to Be Displayed3MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
69T556QAttendance Quota Type Texts3MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
70T556RRules for Deduction Sequence for Absence Quotas2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
71T556STexts for Deduction Sequence Rules for Absence Quotas3MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
72T556UAttendance/Absence Quota Compensation Types2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
73T556VTexts for Attendance/Absence Quota Compensation Types3MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
74T556WWage Type Assignment for Att./Absence Quota Compensations3MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
75T557JRelation Table: Quota Types for Reporting4MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
76T559DValidity/Deduction Interval for Absence Quotas2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
77T559D_WEBESS Leave Request: Obsolete; Now T556A_WEB2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
78T559EBase Entitlement for Leave Accrual2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
79T559FProcessing of Absence Quota Remainders3MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
80T559JConvert Leave Types to Quota Types4MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
81T559LAutomatic Absence Quota Generation2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
82T559QTTransfer Remaining Quota to New Quotas2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
83T559TTexts for Leave Accrual Rule3MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
84T559VValidity Period: Absence Quotas for Default Values2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
85T7TIM_BSB_KTARTAAssignment of Business Subject to an Absence Quota3MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
86T7TIM_BSB_KTARTPAssignment of Business Subject to an Attendance Quota3MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
87T7TIM_QUOTA_STEPRule Blocks Under QUOTA4MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
TOPPortugal
88T5PV1HR-PT: Assignment of quota type selection rule group2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
89T5PV2HR-PT: Classification of absence quota types2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
TOPPublic Sector
90T5QPBS2EParallel deduction sequence of quota types4MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
91T5QPBS2FLWOP/UNAL impact on individual leave type2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
92T5QPBS2NOrgn change & simulation quota for Absence Quotas2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
93T5QPBS2OImpact of Organizational change7MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
94T5QPBS2TTo determine the Seniority based on the Anniversary date2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
95T5QPBS5AHR AU PS:Australian Leave Loading2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
96T5QPBS5BHR AU PS:Australian Leave Loading for varying percentage2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
TOPPublic sector Sweden
97T5SVA_CEVacation debt2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
TOPReuse Services for Country Development
98T799L42Asignment between absence types and legal categories4MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
TOPRussia
99T7RU_556BAbsence Quota Type Texts3MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
TOPSweden
100T5SVAVacation and Compensation debt2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
TOPSwitzerland
101T5C20Time Quotas for Subapplications CH3MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
TOPTime Data Recording and Administration
102TMW_TDTYPETime Data ID23MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
TOPVenezuela
103T7VE10Assignment of date class to absence quota2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10
104T7VEQPAbsence quota attributes2MOPGKEmployee Subgroup Grouping for Time Quota Typesnvarchar10