FOT_ATR_TAX_GRP

Adv. Tax Return: Tax Groups | #other | Component: Value Added Tax (VAT)
Column Name Description
MANDT FK Client
LAND1 FK Country/Region Key
TYPE FK Tax Box Structure Type (Adv. Tax Return)
VALID_FROM Valid From Date for Tax Box Structure
TAX_GROUP Adv. Tax Return: Tax Group
TAX_REPT_COUNTRY FK Tax Reporting Country/Region
MWSKZ FK Tax on sales/purchases code
TXDAT_FROM Valid-From Date of the Tax Rate
KTOSL FK Internal processing key
SHKZG_UMSV Indicator: Total Balance, Debit Balance or Credit Balance? Show values
TXJCD FK Tax Jurisdiction
BLART FK Document Type
UMSKZ FK Special G/L Indicator
KTOKK FK Vendor account group
Column Name Description
Column Name Description
Column Name Description
VALID_FROM Valid From Date for Tax Box Structure
TXDAT_FROM Valid-From Date of the Tax Rate
TXDAT_TO Valid-To Date of the Tax Rate
Column Name Description
SHKZG_UMSV Indicator: Total Balance, Debit Balance or Credit Balance? Show values
Column Name Description Domain name
OPERA Type of Arithmetical Operation CHAR1
FC_CODE Free Classification Code CHAR8
Master Data Relations Join Conditions
Document Type
  • Document Type
  • Client
  • FOT_ATR_TAX_GRP.BLART == T003.BLART
  • FOT_ATR_TAX_GRP.MANDT == T003.MANDT
Vendor account group
  • Vendor account group
  • Client
  • FOT_ATR_TAX_GRP.KTOKK == T077K.KTOKK
  • FOT_ATR_TAX_GRP.MANDT == T077K.MANDT
Internal processing key
  • FOT_ATR_TAX_GRP.MANDT == T007B.MANDT
  • FOT_ATR_TAX_GRP.KTOSL == T007B.KTOSL
Country/Region Key
  • Country/Region Key
  • Client
  • FOT_ATR_TAX_GRP.LAND1 == T005.LAND1
  • FOT_ATR_TAX_GRP.MANDT == T005.MANDT
Client FOT_ATR_TAX_GRP.MANDT == T000.MANDT
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • FOT_ATR_TAX_GRP.MANDT == T007A.MANDT
  • FOT_ATR_TAX_GRP.[column in domain "KALSM_D"] == T007A.KALSM
  • FOT_ATR_TAX_GRP.MWSKZ == T007A.MWSKZ
Tax Reporting Country/Region
  • Tax Reporting Country/Region
  • Client
  • FOT_ATR_TAX_GRP.TAX_REPT_COUNTRY == T005.LAND1
  • FOT_ATR_TAX_GRP.MANDT == T005.MANDT
Tax Jurisdiction
  • ?
  • Tax Jurisdiction
  • FOT_ATR_TAX_GRP.MANDT == TTXJ.MANDT
  • FOT_ATR_TAX_GRP.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • FOT_ATR_TAX_GRP.TXJCD == TTXJ.TXJCD
Special G/L Indicator
  • Special G/L Indicator
  • ?
  • FOT_ATR_TAX_GRP.MANDT == T074U.MANDT
  • FOT_ATR_TAX_GRP.UMSKZ == T074U.UMSKZ
  • FOT_ATR_TAX_GRP.[column in domain "KOART"] == T074U.KOART