ICM_PARTNER_ORGANIZATION

Duplicate check for BP-organization | view: ICM_PARTNER_ORG | Extraction: Not supported | Component: Information Consistency
Tables used: ADR2ADR6ADRCBUT000BUT020
Column Name Description
partner Business Partner Number
addrnumber Address Number
date_from_adrc Valid-from date - in current Release only 00010101 possible
nation FK Version ID for International Addresses
persnumber 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_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
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
telnr_long Complete Number: Dialling Code+Number+Extension CHAR30
smtp_addr E-Mail Address AD_SMTPADR
Master Data Relations Join Conditions
Authorization Group
  • Client
  • ?
  • Authorization Group
  • ICM_PARTNER_ORGANIZATION.MANDT == TB037.CLIENT
  • ICM_PARTNER_ORGANIZATION.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • ICM_PARTNER_ORGANIZATION.AUGRP == TB037.AUGRP
Country key
  • Country/Region Key
  • Client
  • ICM_PARTNER_ORGANIZATION.COUNTRY == T005.LAND1
  • ICM_PARTNER_ORGANIZATION.MANDT == T005.MANDT
Version ID for International Addresses ICM_PARTNER_ORGANIZATION.NATION == TSADV.NATION
Person number
  • Client
  • Person Number
  • Person Number
  • ?
  • ?
  • ICM_PARTNER_ORGANIZATION.MANDT == ADRP.CLIENT
  • ICM_PARTNER_ORGANIZATION.PERSNUMBER_ADR6 == ADRP.PERSNUMBER
  • ICM_PARTNER_ORGANIZATION.PERSNUMBER == ADRP.PERSNUMBER
  • ICM_PARTNER_ORGANIZATION.[column in domain "AD_NATION"] == ADRP.NATION
  • ICM_PARTNER_ORGANIZATION.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
Person number
  • Client
  • Person Number
  • Person Number
  • ?
  • ?
  • ICM_PARTNER_ORGANIZATION.MANDT == ADRP.CLIENT
  • ICM_PARTNER_ORGANIZATION.PERSNUMBER_ADR6 == ADRP.PERSNUMBER
  • ICM_PARTNER_ORGANIZATION.PERSNUMBER == ADRP.PERSNUMBER
  • ICM_PARTNER_ORGANIZATION.[column in domain "AD_NATION"] == ADRP.NATION
  • ICM_PARTNER_ORGANIZATION.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
Region code
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • ICM_PARTNER_ORGANIZATION.COUNTRY == T005S.LAND1
  • ICM_PARTNER_ORGANIZATION.MANDT == T005S.MANDT
  • ICM_PARTNER_ORGANIZATION.REGION == T005S.BLAND