KNA1_ADDR

General Data in Customer Master : Address dep. attributes | #masterdata | Component: Customer Master
Column Name Description
MANDT Client
KUNNR FK Customer Number
ADRNR FK Business Partner Address Number (from BUT020)
Column Name Description
Column Name Description
Column Name Description
Column Name Description
EXABL Indicator: Unloading points exist Show values
Column Name Description Domain name
BAHNE Express train station BAHNH
BAHNS Train station BAHNH
CITYC City Code CITYC
COUNC County Code COUNC
KNA1_ADDR_EEW_CUST Customer General addr. dep. extensibility KNA1_ADDR_EEW_CUST
J_1IEXCD ECC Number CHAR40
J_1IEXRN Excise Registration Number CHAR40
J_1IEXRG Excise Range CHAR60
J_1IEXDI Excise Division CHAR60
J_1IEXCO Excise Commissionerate CHAR60
J_1IEXCICU Excise tax indicator for customer J_1IINDTAX
GST_TDS GST TDS Registration J_1IGSTCD3
Master Data Relations Join Conditions
Business Partner Address Number (from BUT020)
  • Business Partner Address Number (from BUT020)
  • ?
  • KNA1_ADDR.MANDT == BUT020.CLIENT
  • KNA1_ADDR.ADRNR == BUT020.ADDRNUMBER
  • KNA1_ADDR.[column in domain "BU_PARTNER"] == BUT020.PARTNER
Customer number
  • KNA1_ADDR.MANDT == KNA1.MANDT
  • KNA1_ADDR.KUNNR == KNA1.KUNNR