I_LCMPersonAddrAssignment

Person Address Assignment | view: ILCMPERSADDR | Extraction: Not supported | Component: Enterprise Contract Management - Generic Functions
Tables used: ADCP
Column Name Description
AddressNumber FK Address Number
PersonNumber FK Person Number
Column Name Description
Column Name Description
Column Name Description
ValidityStartDate Valid-from date - in current Release only 00010101 possible
ValidityEndDate Valid-to date in current Release only 99991231 possible
Column Name Description
Column Name Description Domain name
Department Department TEXT40
Master Data Relations Join Conditions
Address key
  • ?
  • Address Number
  • Client
  • ?
  • I_LCMPERSONADDRASSIGNMENT.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_LCMPERSONADDRASSIGNMENT.ADDRESSNUMBER == ADRC.ADDRNUMBER
  • I_LCMPERSONADDRASSIGNMENT.MANDT == ADRC.CLIENT
  • I_LCMPERSONADDRASSIGNMENT.[column in domain "AD_NATION"] == ADRC.NATION
Key of person
  • Person Number
  • ?
  • Client
  • ?
  • I_LCMPERSONADDRASSIGNMENT.PERSONNUMBER == ADRP.PERSNUMBER
  • I_LCMPERSONADDRASSIGNMENT.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • I_LCMPERSONADDRASSIGNMENT.MANDT == ADRP.CLIENT
  • I_LCMPERSONADDRASSIGNMENT.[column in domain "AD_NATION"] == ADRP.NATION