C_BPCustAddrDepdntInformation

C view for Addr Dependent Cust General | view: CCUSTADDRDEPTP | Extraction: Not supported | Component: Business Partners
Tables used: BUT000KNA1_ADDRKNA1CVI_CUST_LINK
Column Name Description
AddressID FK Business Partner Address Number (from BUT020)
BusinessPartner Business Partner Number
Customer FK Customer Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
BusinessPartnerCategory Business Partner Category Show values
Column Name Description Domain name
ExpressTrainStationName Express train station BAHNH
TrainStationName Train station BAHNH
CityCode City Code CITYC
County County Code COUNC
BusinessPartnerForEdit Business Partner Number BU_PARTNER
BusinessPartnerUUID Business Partner GUID SYSUUID
Region Region (State, Province, County) REGIO
Country Country/Region Key LAND1
FormattedAddress null
ShipToPartyFormattedAddress null
Master Data Relations Join Conditions
Business Partner Address Number (from BUT020)
  • ?
  • Business Partner Address Number (from BUT020)
  • Business Partner Address Number (from BUT020)
  • Client
  • C_BPCUSTADDRDEPDNTINFORMATION.[column in domain "BU_PARTNER"] == BUT020.PARTNER
  • C_BPCUSTADDRDEPDNTINFORMATION.ADDRESSID == BUT020.ADDRNUMBER
  • C_BPCUSTADDRDEPDNTINFORMATION.ADDRESSIDFOREDIT == BUT020.ADDRNUMBER
  • C_BPCUSTADDRDEPDNTINFORMATION.MANDT == BUT020.CLIENT
Business Partner Address Number (from BUT020)
  • ?
  • Business Partner Address Number (from BUT020)
  • Business Partner Address Number (from BUT020)
  • Client
  • C_BPCUSTADDRDEPDNTINFORMATION.[column in domain "BU_PARTNER"] == BUT020.PARTNER
  • C_BPCUSTADDRDEPDNTINFORMATION.ADDRESSID == BUT020.ADDRNUMBER
  • C_BPCUSTADDRDEPDNTINFORMATION.ADDRESSIDFOREDIT == BUT020.ADDRNUMBER
  • C_BPCUSTADDRDEPDNTINFORMATION.MANDT == BUT020.CLIENT
Customer number
  • Customer Number
  • Customer Number
  • Client
  • C_BPCUSTADDRDEPDNTINFORMATION.CUSTOMER == KNA1.KUNNR
  • C_BPCUSTADDRDEPDNTINFORMATION.CUSTOMERFOREDIT == KNA1.KUNNR
  • C_BPCUSTADDRDEPDNTINFORMATION.MANDT == KNA1.MANDT
Customer number
  • Customer Number
  • Customer Number
  • Client
  • C_BPCUSTADDRDEPDNTINFORMATION.CUSTOMER == KNA1.KUNNR
  • C_BPCUSTADDRDEPDNTINFORMATION.CUSTOMERFOREDIT == KNA1.KUNNR
  • C_BPCUSTADDRDEPDNTINFORMATION.MANDT == KNA1.MANDT