ICM_PARTNER_CONTACT

Duplicate check for BP-contact | view: ICM_PARTNER_CONT | Extraction: Not supported | Component: Information Consistency
Tables used: ADCP, ADR2, ADR6, ADRC, BUT000, BUT052
Column Name Description
relnr FK BP Relationship Number
partner1 Business Partner Number
partner2 Business Partner Number
date_to Validity Date (Valid To)
addrnumber FK Address Number
date_from_adrc Valid-from date - in current Release only 00010101 possible
nation FK Version ID for International Addresses
addrnumber_adcp FK Address Number
date_from_adcp Valid-from date - in current Release only 00010101 possible
nation_adcp FK Version ID for International Addresses
date_from_adr2_adr Valid-from date - in current Release only 00010101 possible
consnumber Sequence Number
date_from_adr6_adr Valid-from date - in current Release only 00010101 possible
consnumber_1 Sequence Number
Column Name Description
Column Name Description
Column Name Description
date_to Validity Date (Valid To)
date_from_adrc Valid-from date - in current Release only 00010101 possible
date_from_adcp Valid-from date - in current Release only 00010101 possible
date_from_adr2_adr Valid-from date - in current Release only 00010101 possible
date_from_adr6_adr Valid-from date - in current Release only 00010101 possible
Column Name Description
comp_pers Flag: Person in company (C) or private (P) address Show values
Column Name Description Domain name
name1 Name 1 TEXT40
name2 Name 2 TEXT40
name3 Name 3 TEXT40
name4 Name 4 TEXT40
city1 City TEXT40
post_code1 City postal code CHAR10
street Street TEXT60
house_num1 House Number TEXT10
name_last Last name of business partner (person) BU_NAME
name_first First name of business partner (person) BU_NAME
persnumber Person Number AD_PERSNUM
telnr_long Complete Number: Dialling Code+Number+Extension CHAR30
smtp_addr E-Mail Address AD_SMTPADR
Master Data Relations Join Conditions
Address Number
  • Address Number
  • Address Number
  • Client
  • Valid-from date - in current Release only 00010101 possible
  • Valid-from date - in current Release only 00010101 possible
  • Valid-from date - in current Release only 00010101 possible
  • Valid-from date - in current Release only 00010101 possible
  • Version ID for International Addresses
  • Version ID for International Addresses
  • ICM_PARTNER_CONTACT.ADDRNUMBER_ADCP == ADRC.ADDRNUMBER
  • ICM_PARTNER_CONTACT.ADDRNUMBER == ADRC.ADDRNUMBER
  • ICM_PARTNER_CONTACT.MANDT == ADRC.CLIENT
  • ICM_PARTNER_CONTACT.DATE_FROM_ADR2_ADR == ADRC.DATE_FROM
  • ICM_PARTNER_CONTACT.DATE_FROM_ADCP == ADRC.DATE_FROM
  • ICM_PARTNER_CONTACT.DATE_FROM_ADRC == ADRC.DATE_FROM
  • ICM_PARTNER_CONTACT.DATE_FROM_ADR6_ADR == ADRC.DATE_FROM
  • ICM_PARTNER_CONTACT.NATION_ADCP == ADRC.NATION
  • ICM_PARTNER_CONTACT.NATION == ADRC.NATION
Address key
  • ?
  • Address Number
  • Address Number
  • Client
  • Version ID for International Addresses
  • Version ID for International Addresses
  • ICM_PARTNER_CONTACT.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • ICM_PARTNER_CONTACT.ADDRNUMBER_ADCP == ADRC.ADDRNUMBER
  • ICM_PARTNER_CONTACT.ADDRNUMBER == ADRC.ADDRNUMBER
  • ICM_PARTNER_CONTACT.MANDT == ADRC.CLIENT
  • ICM_PARTNER_CONTACT.NATION_ADCP == ADRC.NATION
  • ICM_PARTNER_CONTACT.NATION == ADRC.NATION
Authorization Group
  • ?
  • Client
  • Authorization Group
  • ICM_PARTNER_CONTACT.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • ICM_PARTNER_CONTACT.MANDT == TB037.CLIENT
  • ICM_PARTNER_CONTACT.AUGRP == TB037.AUGRP
Country key
  • Client
  • Country/Region Key
  • ICM_PARTNER_CONTACT.MANDT == T005.MANDT
  • ICM_PARTNER_CONTACT.COUNTRY == T005.LAND1
Version ID for International Addresses
  • Version ID for International Addresses
  • Version ID for International Addresses
  • ICM_PARTNER_CONTACT.NATION_ADCP == TSADV.NATION
  • ICM_PARTNER_CONTACT.NATION == TSADV.NATION
Version ID for International Addresses
  • Version ID for International Addresses
  • Version ID for International Addresses
  • ICM_PARTNER_CONTACT.NATION_ADCP == TSADV.NATION
  • ICM_PARTNER_CONTACT.NATION == TSADV.NATION
Region code
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • ICM_PARTNER_CONTACT.MANDT == T005S.MANDT
  • ICM_PARTNER_CONTACT.COUNTRY == T005S.LAND1
  • ICM_PARTNER_CONTACT.REGION == T005S.BLAND
BP Relationship Number
  • BP Relationship Number
  • Client
  • Business Partner Number
  • Business Partner Number
  • Validity Date (Valid To)
  • ICM_PARTNER_CONTACT.RELNR == BUT050.RELNR
  • ICM_PARTNER_CONTACT.MANDT == BUT050.CLIENT
  • ICM_PARTNER_CONTACT.PARTNER1 == BUT050.PARTNER1
  • ICM_PARTNER_CONTACT.PARTNER2 == BUT050.PARTNER2
  • ICM_PARTNER_CONTACT.DATE_TO == BUT050.DATE_TO