FOT_ATR_TBTG_MAP

Adv. Tax Return: Mapping TaxBox to TaxGrp | #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_BOX FK Tax Box (Adv. Tax Return)
TAX_GROUP FK Adv. Tax Return: Tax Group
Column Name Description
Column Name Description
Column Name Description
VALID_FROM Valid From Date for Tax Box Structure
Column Name Description
Column Name Description Domain name
OPERA Type of Arithmetical Operation CHAR1
Master Data Relations Join Conditions
Country/Region Key
  • Country/Region Key
  • Client
  • FOT_ATR_TBTG_MAP.LAND1 == T005.LAND1
  • FOT_ATR_TBTG_MAP.MANDT == T005.MANDT
Client FOT_ATR_TBTG_MAP.MANDT == T000.MANDT
Tax Box
Other Relations | to Master Data Relations ↑ Join Conditions
Tax Group
  • ?
  • ?
  • ?
  • ?
  • ?
  • ?
  • Client
  • ?
  • ?
  • ?
  • FOT_ATR_TBTG_MAP.[column in domain "LAND1"] == FOT_ATR_TAX_GRP.LAND1
  • FOT_ATR_TBTG_MAP.[column in domain "FOT_ATR_TAX_BOX_STRUCT_TYPE"] == FOT_ATR_TAX_GRP.TYPE
  • FOT_ATR_TBTG_MAP.[column in domain "MWSKZ"] == FOT_ATR_TAX_GRP.MWSKZ
  • FOT_ATR_TBTG_MAP.[column in domain "FOT_ATR_TAX_GROUP"] == FOT_ATR_TAX_GRP.TAX_GROUP
  • FOT_ATR_TBTG_MAP.[column in domain "KTOSL_007B"] == FOT_ATR_TAX_GRP.KTOSL
  • FOT_ATR_TBTG_MAP.[column in domain "SHKZG_UMSV"] == FOT_ATR_TAX_GRP.SHKZG_UMSV
  • FOT_ATR_TBTG_MAP.MANDT == FOT_ATR_TAX_GRP.MANDT
  • FOT_ATR_TBTG_MAP.[column in domain "FOT_ATR_TBS_VALID_FROM"] == FOT_ATR_TAX_GRP.VALID_FROM
  • FOT_ATR_TBTG_MAP.[column in domain "FOT_ATR_TAX_REPORTING_COUNTRY"] == FOT_ATR_TAX_GRP.TAX_REPT_COUNTRY
  • FOT_ATR_TBTG_MAP.[column in domain "FOT_TXDAT_FROM"] == FOT_ATR_TAX_GRP.TXDAT_FROM