PA0074 SAP table for – HR Master Record: Infotype 0074 (Leave Processing – DK)

Here we would like to draw your attention to PA0074 table in SAP. As we know it is being mainly used with the SAP PA-PA (Personnel Administration in PA) component which is coming under HR (HCM) PA module (Personnel Management). PA0074 is a SAP standard transp table used for storing HR Master Record: Infotype 0074 (Leave Processing – DK) related data in SAP. If you want to download PDF material about SAP HR PA click here. It comes under the package PB09.

SAP PA0074 table

Table PA0074 technical data

TablePA0074
Data storingHR Master Record: Infotype 0074 (Leave Processing – DK)
ModulePA
Sub ModulePA-PA-DK
SAP PackagePB09
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_HRCDK
Table CategoryTRANSP

SAP PA0074 Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in PA0074 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Key for HR Master Data
    Its a key field.
  • PERNR : Personnel number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 8
  • SUBTY : Subtype
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • OBJPS : Object Identification
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • SPRPS : Lock Indicator for HR Master Data Record
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • ENDDA : End Date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BEGDA : Start Date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SEQNR : Number of Infotype Record With Same Key
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • .INCLUDE : HR Master Record: Control Field
  • AEDTM : Last Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UNAME : Name of Person Who Changed Object
    Its data type is CHAR (Character String) with field length 12
  • HISTO : Historical Record Flag
    Its data type is CHAR (Character String) with field length 1
  • ITXEX : Text Exists for Infotype
    Its data type is CHAR (Character String) with field length 1
  • REFEX : Reference Fields Exist (Primary/Secondary Costs)
    Its data type is CHAR (Character String) with field length 1
  • ORDEX : Confirmation Fields Exist
    Its data type is CHAR (Character String) with field length 1
  • ITBLD : Infotype Screen Control
    Its data type is CHAR (Character String) with field length 2
  • PREAS : Reason for Changing Master Data
    Its data type is CHAR (Character String) with field length 2
  • FLAG1 : Reserved Field/Unused Field
    Its data type is CHAR (Character String) with field length 1
  • FLAG2 : Reserved Field/Unused Field
    Its data type is CHAR (Character String) with field length 1
  • FLAG3 : Reserved Field/Unused Field
    Its data type is CHAR (Character String) with field length 1
  • FLAG4 : Reserved Field/Unused Field
    Its data type is CHAR (Character String) with field length 1
  • RESE1 : Reserved Field/Unused Field of Length 2
    Its data type is CHAR (Character String) with field length 2
  • RESE2 : Reserved Field/Unused Field of Length 2
    Its data type is CHAR (Character String) with field length 2
  • GRPVL : Grouping Value for Personnel Assignments
    Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : HR Master Record: Infotype 0074 (Leave Processing – DK)
  • FEORD : Leave provision – Denmark
    Its data type is CHAR (Character String) with field length 2
  • FGPCT : Vacation Bonus Savings Percentage Rate – Denmark
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • FTPCT : Percentage of Vacation Bonus (Denmark)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • FPFRE : Vacation Bonus / Transfer / Payment Frequency
    Its data type is CHAR (Character String) with field length 2
  • SHORD : SH agreement
    Its data type is CHAR (Character String) with field length 2
  • SHPCT : Percentage for holiday pay allowance (Denmark)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • SHBEU : SH-Money net pay per day (upto 18 years old)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • SHBEO : SH-Money net pay per day (over 18)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • SHFRE : SH-Money/frequency of transfer/payments
    Its data type is CHAR (Character String) with field length 2
  • SHNEG : Negative SH balance allowed
    Its data type is CHAR (Character String) with field length 1
  • OFKOD : Leave schema Denmark
    Its data type is CHAR (Character String) with field length 2
  • FZTAG : Number of additional leave days Denmark
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • FETAG : Number of additional leave days Denmark
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • F6TAG : Number of leave days guaranteed in ยง6A (DK)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • CALJ0 : Processing leave account, year 0
    Its data type is CHAR (Character String) with field length 1
  • DELJ0 : Reset leave, year 0
    Its data type is CHAR (Character String) with field length 1
  • ABMET : Payroll method – PBS field (DK)
    Its data type is CHAR (Character String) with field length 1
  • CALZU : Indicator: Payroll accounting savings percentage rate (DK)
    Its data type is CHAR (Character String) with field length 1
  • CALEX : Indicator: Payroll accounting bonus percentage rate (DK)
    Its data type is CHAR (Character String) with field length 1
  • SHCLR : Indicator: Closing SH balance (DK)
    Its data type is CHAR (Character String) with field length 1
  • SHTCO : Leave account transaction key (DK)
    Its data type is CHAR (Character String) with field length 1
  • FKNUM : Leave account, daily exception factor, FORM40 col.40
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • FKSIC : Indicator: calculate sick/leave hours (DK)
    Its data type is CHAR (Character String) with field length 1
  • FKFRE : Indicator: Leave account, exemption card (DK)
    Its data type is CHAR (Character String) with field length 1
  • CALDAT : Action date, for one-off payroll actions (DK)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SHIND : Action date, for one-off payroll actions (DK)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SHPOR : SH individual payment percentage rate (DK)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 6
  • SHDKK : SH individual payment amount (DK)
    Its data type is CURR (Currency Field) with field length 9
  • SHCUR : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • SHCSA : Indicator: SH individual closing (DK)
    Its data type is CHAR (Character String) with field length 1
  • SHOR2 : SH regulations (DK)
    Its data type is CHAR (Character String) with field length 1
  • TPROM : Days per period of the leave basis (DK)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • FERIE : Indicator: Pay into FerieKonto for each period (DK)
    Its data type is CHAR (Character String) with field length 1
  • UKBRP : Payroll period for determining time period
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • UKBRJ : Payroll year for determining time period
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • CALJ1 : Processing leave account, year 1
    Its data type is CHAR (Character String) with field length 1
  • CALJ2 : Processing leave account, year 2
    Its data type is CHAR (Character String) with field length 1
  • DELJ1 : Reset leave, year-1
    Its data type is CHAR (Character String) with field length 1
  • DELJ2 : Reset leave, year-2
    Its data type is CHAR (Character String) with field length 1
  • UTYPE : Leave type, duplicate of SUPTYPE DK
    Its data type is CHAR (Character String) with field length 4
  • ASME0 : Payment method year 0
    Its data type is CHAR (Character String) with field length 1
  • ARWT0 : Garnishment Wage Type for Vacation Bonus Deduction, Year 0
    Its data type is CHAR (Character String) with field length 4
  • CVM1 : Code for Vacation Bonus Taxation and Payment, Base Value 1
    Its data type is CHAR (Character String) with field length 1
  • CVM2 : Code for Vacation Bonus Taxation and Payment, Bse Val. 2
    Its data type is CHAR (Character String) with field length 1
  • CVM3 : Code for Vacation Bonus Taxation and Pymnt, Bse Val. 3
    Its data type is CHAR (Character String) with field length 1
  • VMTXD : Code for Vacation Bonus Payment that is already Taxed
    Its data type is CHAR (Character String) with field length 1
  • TXSH : Code for SH balance taxation and payment
    Its data type is CHAR (Character String) with field length 1
  • TXRT0 : Percentage for Taxing Vacation Bonus, Year 0
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 2
  • BPA0 : Basic tax exemption, year 0
    Its data type is CURR (Currency Field) with field length 7
  • FRIK0 : EE taxation with exemption card, year 0
    Its data type is CHAR (Character String) with field length 1
  • VM1 : Vacation Bonus to be Calculated, Base Value 1
    Its data type is CURR (Currency Field) with field length 8
  • VM2 : Vacation Bonus to be Calculated, Base Value 2
    Its data type is CURR (Currency Field) with field length 8
  • VM3 : Vacation Bonus to be Calculated, Base Value 3
    Its data type is CURR (Currency Field) with field length 8
  • CVADA : Code for payment of leave days
    Its data type is CHAR (Character String) with field length 1
  • SMTDT : Payroll Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VADA0 : No. of leave days, year 0
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • CXVS0 : Code for performing payroll for extra leave bonus, year 0
    Its data type is CHAR (Character String) with field length 1
  • XVS0 : Extra leave bonus to be calculated, year 0
    Its data type is CURR (Currency Field) with field length 8
  • CCARE : Code for payment of support days not used
    Its data type is CHAR (Character String) with field length 1
  • ASME1 : Payment method year 1
    Its data type is CHAR (Character String) with field length 1
  • ARWT1 : Garnishment Wage Types for Deducting Vac.Bonus Year 1
    Its data type is CHAR (Character String) with field length 4
  • TXRT1 : Percentage for Vacation Bonus Taxation, Year-1
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 2
  • BPA1 : Basic tax exemption, year-1
    Its data type is CURR (Currency Field) with field length 7
  • FRIK1 : EE taxation with exemption card, year-1
    Its data type is CHAR (Character String) with field length 1
  • VACSU : Leave bonus to be calculated
    Its data type is CURR (Currency Field) with field length 8
  • VADA1 : No. of leave days, year-1
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • VARE1 : Leave remuneration, year-1
    Its data type is CURR (Currency Field) with field length 8
  • CXVS1 : Code for calculating extra leave bonus, year-1
    Its data type is CHAR (Character String) with field length 1
  • XVS1 : Extra leave bonus to be calculated, year-1
    Its data type is CURR (Currency Field) with field length 8
  • FERK1 : Number of leave days on leave card, year-1
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • ASME2 : Payment method year-2
    Its data type is CHAR (Character String) with field length 1
  • ARWT2 : Garn. Wage Type for Deducting Vac. Bonus, Year 2
    Its data type is CHAR (Character String) with field length 4
  • TXRT2 : Percentage for Vacation Bonus Taxation, Year-2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 2
  • BPA2 : Basic tax exemption, year-2
    Its data type is CURR (Currency Field) with field length 7
  • FRIK2 : EE taxation with exemption card (Frikort), year-2
    Its data type is CHAR (Character String) with field length 1
  • VADA2 : No. of leave days, year-2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • VARE2 : Leave remuneration, year-2
    Its data type is CURR (Currency Field) with field length 8
  • CXVS2 : Code for calculating extra leave bonus, year-2
    Its data type is CHAR (Character String) with field length 1
  • XVS2 : Extra leave bonus to be calculated, year-2
    Its data type is CURR (Currency Field) with field length 8
  • FERK2 : Number of leave days on leave card, year-2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • IGNJ0 : No processing of leave, year 0
    Its data type is CHAR (Character String) with field length 1
  • IGNJ1 : No processing of leave, year 1
    Its data type is CHAR (Character String) with field length 1
  • IGNJ2 : No processing of leave, year 2
    Its data type is CHAR (Character String) with field length 1
  • SVM1 : Default identifier for leave handling
    Its data type is CHAR (Character String) with field length 1
  • SVM2 : Default identifier for leave handling
    Its data type is CHAR (Character String) with field length 1
  • SVM3 : Default identifier for leave handling
    Its data type is CHAR (Character String) with field length 1
  • STAX0 : Default identifier for leave handling
    Its data type is CHAR (Character String) with field length 1
  • SVD0 : Default identifier for leave handling
    Its data type is CHAR (Character String) with field length 1
  • SXVS0 : Default identifier for leave handling
    Its data type is CHAR (Character String) with field length 1
  • SSD : Default identifier for leave handling
    Its data type is CHAR (Character String) with field length 1
  • STAX1 : Default identifier for leave handling
    Its data type is CHAR (Character String) with field length 1
  • SVD1 : Default identifier for leave handling
    Its data type is CHAR (Character String) with field length 1
  • SVS : Default identifier for leave handling
    Its data type is CHAR (Character String) with field length 1
  • SXVS1 : Default identifier for leave handling
    Its data type is CHAR (Character String) with field length 1
  • SVR1 : Default identifier for leave handling
    Its data type is CHAR (Character String) with field length 1
  • SFK1 : Default identifier for leave handling
    Its data type is CHAR (Character String) with field length 1
  • STAX2 : Default identifier for leave handling
    Its data type is CHAR (Character String) with field length 1
  • SVD2 : Default identifier for leave handling
    Its data type is CHAR (Character String) with field length 1
  • SXVS2 : Default identifier for leave handling
    Its data type is CHAR (Character String) with field length 1
  • SVR2 : Default identifier for leave handling
    Its data type is CHAR (Character String) with field length 1
  • SFK2 : Default identifier for leave handling
    Its data type is CHAR (Character String) with field length 1
  • FWV0N : No Payment 1/2 % Leave Accumulation for Year – 0
    Its data type is CHAR (Character String) with field length 1
  • FWV0F : Payment 1/2 % Leave Accumulation Year – 0 for Holiday Acct
    Its data type is CHAR (Character String) with field length 1
  • FWV0K : Payment 1/2 % Leave Accumulation for Leave Card Y-0
    Its data type is CHAR (Character String) with field length 1
  • FWV0C : Payment for 1/2 % Leave Accumulation in Cash Y-0
    Its data type is CHAR (Character String) with field length 1
  • FWV0S : Standard Amount for Payment 1/2 % Leave Accumulation Y-0
    Its data type is CHAR (Character String) with field length 1
  • FWV0A : Special Payment Amount for 1/2 % Leave Accumulation Y-0
    Its data type is CHAR (Character String) with field length 1
  • FWV0B : Special Payment Amount for 1/2 % Leave Accumulation Year-0
    Its data type is CURR (Currency Field) with field length 8
  • FWV1N : No Payment 1/2 % Leave Accumulation for Year – 1
    Its data type is CHAR (Character String) with field length 1
  • FWV1F : Payment 1/2 % Leave Accumulation Year – 1 for Holiday Acct.
    Its data type is CHAR (Character String) with field length 1
  • FWV1K : Payment 1/2 % Leave Accumulation for Leave Card Y-1
    Its data type is CHAR (Character String) with field length 1
  • FWV1C : Payment 1/2 % Leave Accumulation in Cash Year-1
    Its data type is CHAR (Character String) with field length 1
  • FWV1S : Standard Amount for Payment 1/2 % Leave Accumulation Y-1
    Its data type is CHAR (Character String) with field length 1
  • FWV1A : Special Payment Amount 1/2 % Leave Accumulation Y-1
    Its data type is CHAR (Character String) with field length 1
  • FWV1B : Special Payment Amount 1/2 % Leave Accumulation Year-1
    Its data type is CURR (Currency Field) with field length 8
  • FWV2N : No Payment 1/2 % Leave Accumulation Year – 2
    Its data type is CHAR (Character String) with field length 1
  • FWV2F : Payment 1/2 % Leave Accumulation Year – 2 for Holiday Acct.
    Its data type is CHAR (Character String) with field length 1
  • FWV2K : Payment 1/2 % Leave Accumulation for Leave Card Y-2
    Its data type is CHAR (Character String) with field length 1
  • FWV2C : Payment 1/2 % Leave Accumulation in Cash Year-2
    Its data type is CHAR (Character String) with field length 1
  • FWV2S : Standard Amount for Payment 1/2 % Leave Accum. Y-2
    Its data type is CHAR (Character String) with field length 1
  • FWV2A : Special Payment Amount 1/2 % Leave Accumulation Y-2
    Its data type is CHAR (Character String) with field length 1
  • FWV2B : Special Payment Amount 1/2 % Leave Accumulation Year-2
    Its data type is CURR (Currency Field) with field length 8
  • PAYTY : Payroll type
    Its data type is CHAR (Character String) with field length 1
  • PAYID : Payroll Identifier
    Its data type is CHAR (Character String) with field length 1
  • FTUBT : Payment of Leave Bonus
    Its data type is CHAR (Character String) with field length 1
  • NODIF : No Calculation of Leave Difference
    Its data type is CHAR (Character String) with field length 1
  • URLJJ : Leave year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • OBJP0 : Object Identification
    Its data type is CHAR (Character String) with field length 2
  • UAR00 : Leave type
    Its data type is CHAR (Character String) with field length 2
  • UAR01 : Leave type
    Its data type is CHAR (Character String) with field length 2
  • UAN00 : Leave entitlement
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes