P_AUDIT_AT_KNA1

Austrian Audit Masterdata Customer Accts | view: PAUDITATKNA1 | Extraction: Not supported | Component: Financials Austria
Tables used: KNA1KNB1
Column Name Description
bukrs FK Company Code
kunnr Customer Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
stkzu Liable for VAT Show values
Column Name Description Domain name
name1 Name 1 NAME
name2 Name 2 NAME
ort01 City TEXT35
pfach PO Box PFACH
pstlz Postal Code PSTLZ
sortl Sort field CHAR10
stras Street and House Number TEXT35
adrnr Address ADRNR
mcod1 Search term for matchcode search CHAR25
mcod2 Search Term for Matchcode Search CHAR25
mcod3 Search term for matchcode search CHAR25
konzs Group key KONZS
stceg VAT Registration Number STCEG
stcd1 Tax Number 1 STCD1
stcd2 Tax Number 2 STCD2
stcd3 Tax Number 3 CHAR18
stcd4 Tax Number 4 CHAR18
stcd5 Tax Number 5 CHAR60
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_AUDIT_AT_KNA1.BUKRS == T001.BUKRS
  • P_AUDIT_AT_KNA1.MANDT == T001.MANDT
Customer Account Group
  • Customer Account Group
  • Client
  • P_AUDIT_AT_KNA1.KTOKD == T077D.KTOKD
  • P_AUDIT_AT_KNA1.MANDT == T077D.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • P_AUDIT_AT_KNA1.LAND1 == T005.LAND1
  • P_AUDIT_AT_KNA1.MANDT == T005.MANDT
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • P_AUDIT_AT_KNA1.MANDT == LFA1.MANDT
  • P_AUDIT_AT_KNA1.LIFNR == LFA1.LIFNR
Region (State, Province, County)
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • P_AUDIT_AT_KNA1.LAND1 == T005S.LAND1
  • P_AUDIT_AT_KNA1.MANDT == T005S.MANDT
  • P_AUDIT_AT_KNA1.REGIO == T005S.BLAND
Tax Jurisdiction
  • Client
  • Tax Jurisdiction
  • ?
  • P_AUDIT_AT_KNA1.MANDT == TTXJ.MANDT
  • P_AUDIT_AT_KNA1.TXJCD == TTXJ.TXJCD
  • P_AUDIT_AT_KNA1.[column in domain "TAX_KALSM"] == TTXJ.KALSM