1. Home
  2. Resources
  3. SAP Tables
  4. Q0149 - Tax Informations (RSA)

SAP Table Q0149

Tax Informations (RSA)

Q0149 (Tax Informations (RSA)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link Q0149 to other SAP tables.

Source: Q0149 (Tax Informations (RSA))

Q0149 table fields

Field Data element Checktable Datatype Length Decimals
PERNR Personnel Number PERNR_D NUMC 8 0
INFTY Infotype INFTY CHAR 4 0
SUBTY Subtype SUBTY CHAR 4 0
OBJPS Object Identification OBJPS CHAR 2 0
SPRPS Lock Indicator for HR Master Data Record SPRPS CHAR 1 0
ENDDA End Date ENDDA DATS 8 0
BEGDA Start Date BEGDA DATS 8 0
SEQNR Number of Infotype Record with Same Key SEQNR NUMC 3 0
AEDTM Changed On AEDAT DATS 8 0
UNAME User Name UNAME CHAR 12 0
HISTO Historical Record Flag HISTO CHAR 1 0
ITXNR Text Module for Infotype ITXNR NUMC 8 0
PREAS Reason for Changing Master Data PREAS CHAR 2 0
FZAMT Tax Revenue Office Code FYAMT CHAR 4 0
TOTXT Receiver of Revenue Tax Office Text TOTXT CHAR 50 0
REFNO Tax Reference Number ZA P16_REFNO CHAR 10 0
TXSTA Tax Status Indicator TYSTA CHAR 2 0
STTXT Tax status Text ZA P16_STTXT CHAR 20 0
STDIR Status Directive STDIR CHAR 1 0
X Yes
NULL No
NODEP Tax Number of Dependants NODEP NUMC 3 0
AGIND Age Group Indicator AGIND CHAR 2 0
AGTXT Age indicator text P16_AGTXT CHAR 40 0
PFIND Employment Indicator PFYND CHAR 2 0
PFTXT Employment Indicator Text PFTYT CHAR 40 0
DIRPC Directive Percentage DIRPC DEC 5 2
PCDIR Directive Amount or Percentage Received? PCDIR CHAR 1 0
X Yes
NULL No
RBAMT Tax rebate amount RBAMT DEC 9 2
EXAMT Directive Amount EYAMT DEC 9 2
TXPRO Tax Procedure Code TYPRO CHAR 1 0
1 Constant Tax, based on periods
2 Constant Tax, based on days
5 Steady Site, based on periods
6 Steady Site, based on days
9 Zero Tax (provisional taxpayer)
PTEXT Tax Procedure Text FTEYT CHAR 40 0
FLEXI Flexi Remuneration Indicator FLEXI CHAR 1 0
X Yes
NULL No
IBBEG Start of validity period for indirect valuation IBBEG DATS 8 0
RGTXT Tax Region Text RSA RGTXT CHAR 40 0
WAE01 Currency Key WAERS T500W CUKY 5 0
RSCDE RSC Description P16_RSCDE CHAR 30 0

Q0149 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
Q0149 WAE01 SYST MANDT T500W Valid Country Currencies MANDT
Q0149 WAE01 PSYST LAND T500W Valid Country Currencies LAND1
Q0149 WAE01 Q0149 WAE01 T500W Valid Country Currencies WAERS