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

Home | ERP 6.0  | T5DBF
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
Payroll :: Germany :: Construction Industry
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0T5DBF911Construction Industry LeaveConstruction Industry
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, MOLGA, MOURA, TGG01, BAUTY, BAUTU, URALT, URBTZ, BEHGR, ENDDA, BEGDA, URKAS, ERBTG, ERAGL, URAR1, VORL1, UTAG1, UDIV1, GRGL1, GPRZ1, GBTR1, GLGA1, ERGL1, EPRZ1, ELGA1, URAR2, VORL2, UTAG2, UDIV2, GRGL2, GPRZ2, GBTR2, GLGA2, ERGL2, EPRZ2, ELGA2, URAR3, VORL3, UTAG3, UDIV3, GRGL3, GPRZ3, GBTR3, GLGA3, ERGL3, EPRZ3, ELGA3, URAR4, VORL4, UTAG4, UDIV4, GRGL4, GPRZ4, GBTR4, GLGA4, ERGL4, EPRZ4, ELGA4, URAR5, VORL5, UTAG5, UDIV5, GRGL5, GPRZ5, GBTR5, GLGA5, ERGL5, EPRZ5, ELGA5, URAR6, VORL6, UTAG6, UDIV6, GRGL6, GPRZ6, GBTR6, GLGA6, ERGL6, EPRZ6, ELGA6, URAR7, VORL7, UTAG7, UDIV7, GRGL7, GPRZ7, GBTR7, GLGA7, ERGL7, EPRZ7, ELGA7 FROM T5DBF
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2MOLGACountry Groupingnvarchar20CHAR(N' ')NoT500LMOLGA Allow NULL? 
3MOURAPersonnel Subarea Grouping for Leave Typesnvarchar20NUMC(N'00')NoMOURA Allow NULL? 
4TGG01Pay Scale Area Group for Leave in Construction Industrynvarchar20CHAR(N' ')NoT5D0TP01B_TGG01 Allow NULL? 
5BAUTYEmployee Subgroup Grouping for Construction Paychar10CHAR(N' ')NoP01B_BAUTY Allow NULL? 
6BAUTUEmployee Subgroup Subgrouping for Construction Ind. Leavechar10CHAR(N' ')NoP01B_BAUTU Allow NULL? 
7URALTMinimum Age for Leave Entitlementnvarchar20NUMC(N'00')NoP01B_URALT Allow NULL? 
8URBTZMinimum Length of Service for Leave Entitlementnvarchar20NUMC(N'00')NoP01B_URBTZ Allow NULL? 
9BEHGRChallenge Group for Leave Entitlementnvarchar20CHAR(N' ')NoP01B_BEHGR Allow NULL? 
10ENDDAEnd Datenvarchar80DATS(N'00000000')NoENDDA Allow NULL? 
11BEGDAStart Datenvarchar80DATS(N'00000000')NoBEGDA Allow NULL? 
12URKASLeave Fund for Construction Industrynvarchar20CHAR(N' ')YesT5DBAP01B_URKAS Allow NULL? 
13ERBTGDetermine Employment Dayschar10CHAR(N' ')YesP01B_ERBTG Allow NULL? 
14ERAGLDetermine Adjustment Amountschar10CHAR(N' ')YesP01B_ERAGL Allow NULL? 
15URAR1Leave Typenvarchar20CHAR(N' ')NoT533P01B_URART Allow NULL? 
16VORL1Propose Leave Type?char10CHAR(N' ')NoP01B_VORLG Allow NULL? 
17UTAG1Leave Entitlement in Daysdecimal52DEC((0))NoP01B_UTAGE
18UDIV1Leave Entitlement Divisordecimal64DEC((0))NoP01B_UDIVS
19GRGL1Vacation Bonus Rulenvarchar20CHAR(N' ')NoP01B_GREGL Allow NULL? 
20GPRZ1Vacation Bonus Percentage Ratedecimal42DEC((0))NoP01B_GPRZS
21GBTR1Vacation Bonus Amountdecimal62CURR((0))NoP01B_GBTRG
22GLGA1Wage Type Vacation Bonusnvarchar40CHAR(N' ')YesT512WP01B_LGAGD Allow NULL? 
23ERGL1Vacation Pay Rulenvarchar20CHAR(N' ')NoP01B_EGRGL Allow NULL? 
24EPRZ1Percentage Rate for Vacation Paydecimal42DEC((0))NoP01B_EGPRZ
25ELGA1Wage Type for Vacation Paynvarchar40CHAR(N' ')YesT512WP01B_LGAEG Allow NULL? 
26URAR2Leave Typenvarchar20CHAR(N' ')NoT533P01B_URART Allow NULL? 
27VORL2Propose Leave Type?char10CHAR(N' ')NoP01B_VORLG Allow NULL? 
28UTAG2Leave Entitlement in Daysdecimal52DEC((0))NoP01B_UTAGE
29UDIV2Leave Entitlement Divisordecimal64DEC((0))NoP01B_UDIVS
30GRGL2Vacation Bonus Rulenvarchar20CHAR(N' ')NoP01B_GREGL Allow NULL? 
31GPRZ2Vacation Bonus Percentage Ratedecimal42DEC((0))NoP01B_GPRZS
32GBTR2Vacation Bonus Amountdecimal62CURR((0))NoP01B_GBTRG
33GLGA2Wage Type Vacation Bonusnvarchar40CHAR(N' ')YesT512WP01B_LGAGD Allow NULL? 
34ERGL2Vacation Pay Rulenvarchar20CHAR(N' ')NoP01B_EGRGL Allow NULL? 
35EPRZ2Percentage Rate for Vacation Paydecimal42DEC((0))NoP01B_EGPRZ
36ELGA2Wage Type for Vacation Paynvarchar40CHAR(N' ')YesT512WP01B_LGAEG Allow NULL? 
37URAR3Leave Typenvarchar20CHAR(N' ')NoT533P01B_URART Allow NULL? 
38VORL3Propose Leave Type?char10CHAR(N' ')NoP01B_VORLG Allow NULL? 
39UTAG3Leave Entitlement in Daysdecimal52DEC((0))NoP01B_UTAGE
40UDIV3Leave Entitlement Divisordecimal64DEC((0))NoP01B_UDIVS
41GRGL3Vacation Bonus Rulenvarchar20CHAR(N' ')NoP01B_GREGL Allow NULL? 
42GPRZ3Vacation Bonus Percentage Ratedecimal42DEC((0))NoP01B_GPRZS
43GBTR3Vacation Bonus Amountdecimal62CURR((0))NoP01B_GBTRG
44GLGA3Wage Type Vacation Bonusnvarchar40CHAR(N' ')YesT512WP01B_LGAGD Allow NULL? 
45ERGL3Vacation Pay Rulenvarchar20CHAR(N' ')NoP01B_EGRGL Allow NULL? 
46EPRZ3Percentage Rate for Vacation Paydecimal42DEC((0))NoP01B_EGPRZ
47ELGA3Wage Type for Vacation Paynvarchar40CHAR(N' ')YesT512WP01B_LGAEG Allow NULL? 
48URAR4Leave Typenvarchar20CHAR(N' ')NoT533P01B_URART Allow NULL? 
49VORL4Propose Leave Type?char10CHAR(N' ')NoP01B_VORLG Allow NULL? 
50UTAG4Leave Entitlement in Daysdecimal52DEC((0))NoP01B_UTAGE
51UDIV4Leave Entitlement Divisordecimal64DEC((0))NoP01B_UDIVS
52GRGL4Vacation Bonus Rulenvarchar20CHAR(N' ')NoP01B_GREGL Allow NULL? 
53GPRZ4Vacation Bonus Percentage Ratedecimal42DEC((0))NoP01B_GPRZS
54GBTR4Vacation Bonus Amountdecimal62CURR((0))NoP01B_GBTRG
55GLGA4Wage Type Vacation Bonusnvarchar40CHAR(N' ')YesT512WP01B_LGAGD Allow NULL? 
56ERGL4Vacation Pay Rulenvarchar20CHAR(N' ')NoP01B_EGRGL Allow NULL? 
57EPRZ4Percentage Rate for Vacation Paydecimal42DEC((0))NoP01B_EGPRZ
58ELGA4Wage Type for Vacation Paynvarchar40CHAR(N' ')YesT512WP01B_LGAEG Allow NULL? 
59URAR5Leave Typenvarchar20CHAR(N' ')NoT533P01B_URART Allow NULL? 
60VORL5Propose Leave Type?char10CHAR(N' ')NoP01B_VORLG Allow NULL? 
61UTAG5Leave Entitlement in Daysdecimal52DEC((0))NoP01B_UTAGE
62UDIV5Leave Entitlement Divisordecimal64DEC((0))NoP01B_UDIVS
63GRGL5Vacation Bonus Rulenvarchar20CHAR(N' ')NoP01B_GREGL Allow NULL? 
64GPRZ5Vacation Bonus Percentage Ratedecimal42DEC((0))NoP01B_GPRZS
65GBTR5Vacation Bonus Amountdecimal62CURR((0))NoP01B_GBTRG
66GLGA5Wage Type Vacation Bonusnvarchar40CHAR(N' ')YesT512WP01B_LGAGD Allow NULL? 
67ERGL5Vacation Pay Rulenvarchar20CHAR(N' ')NoP01B_EGRGL Allow NULL? 
68EPRZ5Percentage Rate for Vacation Paydecimal42DEC((0))NoP01B_EGPRZ
69ELGA5Wage Type for Vacation Paynvarchar40CHAR(N' ')YesT512WP01B_LGAEG Allow NULL? 
70URAR6Leave Typenvarchar20CHAR(N' ')NoT533P01B_URART Allow NULL? 
71VORL6Propose Leave Type?char10CHAR(N' ')NoP01B_VORLG Allow NULL? 
72UTAG6Leave Entitlement in Daysdecimal52DEC((0))NoP01B_UTAGE
73UDIV6Leave Entitlement Divisordecimal64DEC((0))NoP01B_UDIVS
74GRGL6Vacation Bonus Rulenvarchar20CHAR(N' ')NoP01B_GREGL Allow NULL? 
75GPRZ6Vacation Bonus Percentage Ratedecimal42DEC((0))NoP01B_GPRZS
76GBTR6Vacation Bonus Amountdecimal62CURR((0))NoP01B_GBTRG
77GLGA6Wage Type Vacation Bonusnvarchar40CHAR(N' ')YesT512WP01B_LGAGD Allow NULL? 
78ERGL6Vacation Pay Rulenvarchar20CHAR(N' ')NoP01B_EGRGL Allow NULL? 
79EPRZ6Percentage Rate for Vacation Paydecimal42DEC((0))NoP01B_EGPRZ
80ELGA6Wage Type for Vacation Paynvarchar40CHAR(N' ')YesT512WP01B_LGAEG Allow NULL? 
81URAR7Leave Typenvarchar20CHAR(N' ')NoT533P01B_URART Allow NULL? 
82VORL7Propose Leave Type?char10CHAR(N' ')NoP01B_VORLG Allow NULL? 
83UTAG7Leave Entitlement in Daysdecimal52DEC((0))NoP01B_UTAGE
84UDIV7Leave Entitlement Divisordecimal64DEC((0))NoP01B_UDIVS
85GRGL7Vacation Bonus Rulenvarchar20CHAR(N' ')NoP01B_GREGL Allow NULL? 
86GPRZ7Vacation Bonus Percentage Ratedecimal42DEC((0))NoP01B_GPRZS
87GBTR7Vacation Bonus Amountdecimal62CURR((0))NoP01B_GBTRG
88GLGA7Wage Type Vacation Bonusnvarchar40CHAR(N' ')YesT512WP01B_LGAGD Allow NULL? 
89ERGL7Vacation Pay Rulenvarchar20CHAR(N' ')NoP01B_EGRGL Allow NULL? 
90EPRZ7Percentage Rate for Vacation Paydecimal42DEC((0))NoP01B_EGPRZ
91ELGA7Wage Type for Vacation Paynvarchar40CHAR(N' ')YesT512WP01B_LGAEG Allow NULL? 
NamePrimaryUniqueTypeColumns
T5DBF~0YesYesCLUSTEREDENDDA, BEHGR, URBTZ, URALT, BAUTU, BAUTY, TGG01, MOURA, MOLGA, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy