T5DBF SAP (Construction Industry Leave) Table details

Dictionary Type: Table
Description: Construction Industry Leave




ABAP Code to SELECT data from T5DBF
Related tables to T5DBF
Access table T5DBF




Table field list including key, data, relationships and ABAP select examples

T5DBF is a standard SAP Table which is used to store Construction Industry Leave data and is available within R/3 SAP systems depending on the version and release level.

The T5DBF table consists of various fields, each holding specific information or linking keys about Construction Industry Leave data available in SAP. These include MOLGA (Country Grouping), MOURA (Personnel Subarea Grouping for Leave Types), TGG01 (Pay Scale Area Group for Leave in Construction Industry), BAUTY (Employee Subgroup Grouping for Construction Pay).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP T5DBF table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
MOLGACountry Grouping MOLGACHAR2T500LMOLGAMOL
MOURAPersonnel Subarea Grouping for Leave Types MOURANUMC2MODIF
TGG01Pay Scale Area Group for Leave in Construction Industry P01B_TGG01CHAR2T5D0TTRFGG
BAUTYEmployee Subgroup Grouping for Construction Pay P01B_BAUTYCHAR1P01B_BAUTY
BAUTUEmployee Subgroup Subgrouping for Construction Ind. Leave P01B_BAUTUCHAR1P01B_BAUTU
URALTMinimum Age for Leave Entitlement P01B_URALTNUMC2NUM2
URBTZMinimum Length of Service for Leave Entitlement P01B_URBTZNUMC2NUM2
BEHGRChallenge Group for Leave Entitlement P01B_BEHGRCHAR2P01B_BEHGR
ENDDAEnd Date ENDDADATS8DATUM
BEGDAStart Date BEGDADATS8DATUM
URKASLeave Fund for Construction Industry P01B_URKASCHAR2T5DBAP01B_ZVKAS
ERBTGDetermine Employment Days P01B_ERBTGCHAR1XFELD
ERAGLDetermine Adjustment Amounts P01B_ERAGLCHAR1XFELD
URAR1Leave Type P01B_URARTCHAR2T533URART
VORL1Propose Leave Type? P01B_VORLGCHAR1XFELD
UTAG1Leave Entitlement in Days P01B_UTAGEDEC5(2) URLTG
UDIV1Leave Entitlement Divisor P01B_UDIVSDEC6(4) DEC2_4
GRGL1Vacation Bonus Rule P01B_GREGLCHAR2P01B_GREGL
GPRZ1Vacation Bonus Percentage Rate P01B_GPRZSDEC4(2) DEC2_2
GBTR1Vacation Bonus Amount P01B_GBTRGCURR6(2) P_99D_WERT3
GLGA1Wage Type Vacation Bonus P01B_LGAGDCHAR4T512WLGART
ERGL1Vacation Pay Rule P01B_EGRGLCHAR2P01B_EGRGL
EPRZ1Percentage Rate for Vacation Pay P01B_EGPRZDEC4(2) DEC2_2
ELGA1Wage Type for Vacation Pay P01B_LGAEGCHAR4T512WLGART
URAR2Leave Type P01B_URARTCHAR2T533URART
VORL2Propose Leave Type? P01B_VORLGCHAR1XFELD
UTAG2Leave Entitlement in Days P01B_UTAGEDEC5(2) URLTG
UDIV2Leave Entitlement Divisor P01B_UDIVSDEC6(4) DEC2_4
GRGL2Vacation Bonus Rule P01B_GREGLCHAR2P01B_GREGL
GPRZ2Vacation Bonus Percentage Rate P01B_GPRZSDEC4(2) DEC2_2
GBTR2Vacation Bonus Amount P01B_GBTRGCURR6(2) P_99D_WERT3
GLGA2Wage Type Vacation Bonus P01B_LGAGDCHAR4T512WLGART
ERGL2Vacation Pay Rule P01B_EGRGLCHAR2P01B_EGRGL
EPRZ2Percentage Rate for Vacation Pay P01B_EGPRZDEC4(2) DEC2_2
ELGA2Wage Type for Vacation Pay P01B_LGAEGCHAR4T512WLGART
URAR3Leave Type P01B_URARTCHAR2T533URART
VORL3Propose Leave Type? P01B_VORLGCHAR1XFELD
UTAG3Leave Entitlement in Days P01B_UTAGEDEC5(2) URLTG
UDIV3Leave Entitlement Divisor P01B_UDIVSDEC6(4) DEC2_4
GRGL3Vacation Bonus Rule P01B_GREGLCHAR2P01B_GREGL
GPRZ3Vacation Bonus Percentage Rate P01B_GPRZSDEC4(2) DEC2_2
GBTR3Vacation Bonus Amount P01B_GBTRGCURR6(2) P_99D_WERT3
GLGA3Wage Type Vacation Bonus P01B_LGAGDCHAR4T512WLGART
ERGL3Vacation Pay Rule P01B_EGRGLCHAR2P01B_EGRGL
EPRZ3Percentage Rate for Vacation Pay P01B_EGPRZDEC4(2) DEC2_2
ELGA3Wage Type for Vacation Pay P01B_LGAEGCHAR4T512WLGART
URAR4Leave Type P01B_URARTCHAR2T533URART
VORL4Propose Leave Type? P01B_VORLGCHAR1XFELD
UTAG4Leave Entitlement in Days P01B_UTAGEDEC5(2) URLTG
UDIV4Leave Entitlement Divisor P01B_UDIVSDEC6(4) DEC2_4
GRGL4Vacation Bonus Rule P01B_GREGLCHAR2P01B_GREGL
GPRZ4Vacation Bonus Percentage Rate P01B_GPRZSDEC4(2) DEC2_2
GBTR4Vacation Bonus Amount P01B_GBTRGCURR6(2) P_99D_WERT3
GLGA4Wage Type Vacation Bonus P01B_LGAGDCHAR4T512WLGART
ERGL4Vacation Pay Rule P01B_EGRGLCHAR2P01B_EGRGL
EPRZ4Percentage Rate for Vacation Pay P01B_EGPRZDEC4(2) DEC2_2
ELGA4Wage Type for Vacation Pay P01B_LGAEGCHAR4T512WLGART
URAR5Leave Type P01B_URARTCHAR2T533URART
VORL5Propose Leave Type? P01B_VORLGCHAR1XFELD
UTAG5Leave Entitlement in Days P01B_UTAGEDEC5(2) URLTG
UDIV5Leave Entitlement Divisor P01B_UDIVSDEC6(4) DEC2_4
GRGL5Vacation Bonus Rule P01B_GREGLCHAR2P01B_GREGL
GPRZ5Vacation Bonus Percentage Rate P01B_GPRZSDEC4(2) DEC2_2
GBTR5Vacation Bonus Amount P01B_GBTRGCURR6(2) P_99D_WERT3
GLGA5Wage Type Vacation Bonus P01B_LGAGDCHAR4T512WLGART
ERGL5Vacation Pay Rule P01B_EGRGLCHAR2P01B_EGRGL
EPRZ5Percentage Rate for Vacation Pay P01B_EGPRZDEC4(2) DEC2_2
ELGA5Wage Type for Vacation Pay P01B_LGAEGCHAR4T512WLGART
URAR6Leave Type P01B_URARTCHAR2T533URART
VORL6Propose Leave Type? P01B_VORLGCHAR1XFELD
UTAG6Leave Entitlement in Days P01B_UTAGEDEC5(2) URLTG
UDIV6Leave Entitlement Divisor P01B_UDIVSDEC6(4) DEC2_4
GRGL6Vacation Bonus Rule P01B_GREGLCHAR2P01B_GREGL
GPRZ6Vacation Bonus Percentage Rate P01B_GPRZSDEC4(2) DEC2_2
GBTR6Vacation Bonus Amount P01B_GBTRGCURR6(2) P_99D_WERT3
GLGA6Wage Type Vacation Bonus P01B_LGAGDCHAR4T512WLGART
ERGL6Vacation Pay Rule P01B_EGRGLCHAR2P01B_EGRGL
EPRZ6Percentage Rate for Vacation Pay P01B_EGPRZDEC4(2) DEC2_2
ELGA6Wage Type for Vacation Pay P01B_LGAEGCHAR4T512WLGART
URAR7Leave Type P01B_URARTCHAR2T533URART
VORL7Propose Leave Type? P01B_VORLGCHAR1XFELD
UTAG7Leave Entitlement in Days P01B_UTAGEDEC5(2) URLTG
UDIV7Leave Entitlement Divisor P01B_UDIVSDEC6(4) DEC2_4
GRGL7Vacation Bonus Rule P01B_GREGLCHAR2P01B_GREGL
GPRZ7Vacation Bonus Percentage Rate P01B_GPRZSDEC4(2) DEC2_2
GBTR7Vacation Bonus Amount P01B_GBTRGCURR6(2) P_99D_WERT3
GLGA7Wage Type Vacation Bonus P01B_LGAGDCHAR4T512WLGART
ERGL7Vacation Pay Rule P01B_EGRGLCHAR2P01B_EGRGL
EPRZ7Percentage Rate for Vacation Pay P01B_EGPRZDEC4(2) DEC2_2
ELGA7Wage Type for Vacation Pay P01B_LGAEGCHAR4T512WLGART

Key field Non-key field



How do I retrieve data from SAP table T5DBF using ABAP code

The following ABAP code Example will allow you to do a basic selection on T5DBF to SELECT all data from the table
DATA: WA_T5DBF TYPE T5DBF.

SELECT SINGLE *
FROM T5DBF
INTO CORRESPONDING FIELDS OF WA_T5DBF
WHERE...

How to access SAP table T5DBF

Within an ECC or HANA version of SAP you can also view further information about T5DBF and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!