Fac_Ad_Cds_FOT_TXA_T030k

CDS View for FOT_TXA_T030K | view: FACADV_TXA_T030K | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: SKATT004TT005T005TT007ST687TFOT_TXA_T030K
Column Name Description
ktopl FK Chart of Accounts
ktosl FK Internal processing key
mwskz FK Tax on sales/purchases code
land1 FK Country/Region Key
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
ktopl_text Chart of Accounts Description TEXT50
transactionkey_text Name TEXT20
taxcode_text Name for value-added tax TEXT50
country_text Name of Country/Region (Short) TEXT15
account_text G/L Account Short Text TEXT20
Master Data Relations Join Conditions
Chart of Accounts
  • Chart of Accounts
  • Client
  • FAC_AD_CDS_FOT_TXA_T030K.KTOPL == T004.KTOPL
  • FAC_AD_CDS_FOT_TXA_T030K.MANDT == T004.MANDT
Internal processing key
  • Internal processing key
  • Client
  • FAC_AD_CDS_FOT_TXA_T030K.KTOSL == T007B.KTOSL
  • FAC_AD_CDS_FOT_TXA_T030K.MANDT == T007B.MANDT
Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • FAC_AD_CDS_FOT_TXA_T030K.TAX_COUNTRY_TEXT == T005.LAND1
  • FAC_AD_CDS_FOT_TXA_T030K.LAND1 == T005.LAND1
  • FAC_AD_CDS_FOT_TXA_T030K.MANDT == T005.MANDT
Tax on sales/purchases code
  • Tax on sales/purchases code
  • ?
  • Client
  • FAC_AD_CDS_FOT_TXA_T030K.MWSKZ == T007A.MWSKZ
  • FAC_AD_CDS_FOT_TXA_T030K.[column in domain "KALSM_D"] == T007A.KALSM
  • FAC_AD_CDS_FOT_TXA_T030K.MANDT == T007A.MANDT
Tax Account Number
  • Tax Account Number
  • Chart of Accounts
  • Client
  • FAC_AD_CDS_FOT_TXA_T030K.TAX_ACCOUNT == SKA1.SAKNR
  • FAC_AD_CDS_FOT_TXA_T030K.KTOPL == SKA1.KTOPL
  • FAC_AD_CDS_FOT_TXA_T030K.MANDT == SKA1.MANDT
Tax Reporting Country/Region
  • Tax Reporting Country/Region
  • Client
  • FAC_AD_CDS_FOT_TXA_T030K.TAX_COUNTRY == T005.LAND1
  • FAC_AD_CDS_FOT_TXA_T030K.MANDT == T005.MANDT
Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • FAC_AD_CDS_FOT_TXA_T030K.TAX_COUNTRY_TEXT == T005.LAND1
  • FAC_AD_CDS_FOT_TXA_T030K.LAND1 == T005.LAND1
  • FAC_AD_CDS_FOT_TXA_T030K.MANDT == T005.MANDT