ICM_PARTNER_PERSON

Duplicate check for BP-person | view: ICM_PARTNER_PERS | Extraction: Not supported | Component: Information Consistency
Tables used: ADCPADR2ADR6ADRCBUT000
Column Name Description
partner Business Partner Number
addrnumber_adcp FK Address Number
date_from_adcp Valid-from date - in current Release only 00010101 possible
addrnumber Address Number
date_from_adrc Valid-from date - in current Release only 00010101 possible
nation FK Version ID for International Addresses
persnumber_adr2 FK Person Number
date_from_adr2_adr Valid-from date - in current Release only 00010101 possible
consnumber Sequence Number
persnumber_adr6 FK Person 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_from_adcp Valid-from date - in current Release only 00010101 possible
date_from_adrc 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
type Business Partner Category Show values
comp_pers Flag: Person in company (C) or private (P) address Show values
Column Name Description Domain name
persnumber Person Number AD_PERSNUM
name_first First name of business partner (person) BU_NAME
name_last Last name of business partner (person) BU_NAME
city1 City TEXT40
post_code1 City postal code CHAR10
street Street TEXT60
house_num1 House Number TEXT10
telnr_long Complete Number: Dialling Code+Number+Extension CHAR30
smtp_addr E-Mail Address AD_SMTPADR
Master Data Relations Join Conditions
Address key
  • ?
  • Address Number
  • Address Number
  • Version ID for International Addresses
  • Client
  • ICM_PARTNER_PERSON.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • ICM_PARTNER_PERSON.ADDRNUMBER == ADRC.ADDRNUMBER
  • ICM_PARTNER_PERSON.ADDRNUMBER_ADCP == ADRC.ADDRNUMBER
  • ICM_PARTNER_PERSON.NATION == ADRC.NATION
  • ICM_PARTNER_PERSON.MANDT == ADRC.CLIENT
Authorization Group
  • ?
  • Authorization Group
  • Client
  • ICM_PARTNER_PERSON.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • ICM_PARTNER_PERSON.AUGRP == TB037.AUGRP
  • ICM_PARTNER_PERSON.MANDT == TB037.CLIENT
Country key
  • Client
  • Country/Region Key
  • ICM_PARTNER_PERSON.MANDT == T005.MANDT
  • ICM_PARTNER_PERSON.COUNTRY == T005.LAND1
Version ID for International Addresses ICM_PARTNER_PERSON.NATION == TSADV.NATION
Person number
  • ?
  • ?
  • Client
  • Person Number
  • Person Number
  • Person Number
  • ICM_PARTNER_PERSON.[column in domain "AD_NATION"] == ADRP.NATION
  • ICM_PARTNER_PERSON.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • ICM_PARTNER_PERSON.MANDT == ADRP.CLIENT
  • ICM_PARTNER_PERSON.PERSNUMBER_ADR6 == ADRP.PERSNUMBER
  • ICM_PARTNER_PERSON.PERSNUMBER == ADRP.PERSNUMBER
  • ICM_PARTNER_PERSON.PERSNUMBER_ADR2 == ADRP.PERSNUMBER
Person number
  • ?
  • ?
  • Client
  • Person Number
  • Person Number
  • Person Number
  • ICM_PARTNER_PERSON.[column in domain "AD_NATION"] == ADRP.NATION
  • ICM_PARTNER_PERSON.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • ICM_PARTNER_PERSON.MANDT == ADRP.CLIENT
  • ICM_PARTNER_PERSON.PERSNUMBER_ADR6 == ADRP.PERSNUMBER
  • ICM_PARTNER_PERSON.PERSNUMBER == ADRP.PERSNUMBER
  • ICM_PARTNER_PERSON.PERSNUMBER_ADR2 == ADRP.PERSNUMBER
Region code
  • Region (State, Province, County)
  • Client
  • Country/Region Key
  • ICM_PARTNER_PERSON.REGION == T005S.BLAND
  • ICM_PARTNER_PERSON.MANDT == T005S.MANDT
  • ICM_PARTNER_PERSON.COUNTRY == T005S.LAND1