Which tables does ICM_EMPLOYEE_CONTACT use?

ICM_EMPLOYEE_CONTACT reads from 6 data source(s): adr2, adr6, adrc, adcp, but000, mom052.

How many fields does ICM_EMPLOYEE_CONTACT have?

ICM_EMPLOYEE_CONTACT has 17 fields. Key fields: partner_guid, address_guid, addrnumber, nation, partner.

ICM_EMPLOYEE_CONTACT

DDL: ICM_EMPLOYEE SQL: ICM_EMPLOYEE Type: view Package: S_IC_DUPLICATE_CHECK_ON_HANA

Employee

ICM_EMPLOYEE_CONTACT is a CDS View that provides data about "Employee" in SAP S/4HANA. It reads from 6 data sources and exposes 17 fields with key fields partner_guid, address_guid, addrnumber, nation, partner. Part of development package S_IC_DUPLICATE_CHECK_ON_HANA.

Data Sources (6)

Source	Alias	Join Type
adr2	a2	left_outer
adr6	a6	left_outer
adrc	ac	inner
adcp	ad	inner
but000	b00	inner
mom052	m52	from

Annotations (3)

Name	Value	Level
AbapCatalog.sqlViewName	ICM_EMPLOYEE	view
AbapCatalog.compiler.compareFilter	true	view
EndUserText.label	Employee	view

Fields (17)

Key	Field	Source Table	Source Field
KEY	partner_guid	mom052	partner_guid
KEY	address_guid	mom052	address_guid
KEY	addrnumber	adrc	addrnumber
KEY	nation	adrc	nation
KEY	partner	but000	partner
	persnumber	but000	persnumber
	name_last	but000	name_last
	name_first	but000	name_first
	augrp	but000	augrp
	city1	adrc	city1
	post_code1	adrc	post_code1
	street	adrc	street
	house_num1	adrc	house_num1
	country	adrc	country
	region	adrc	region
	telnr_long	adr2	telnr_long
	smtp_addr	adr6	smtp_addr

@AbapCatalog.sqlViewName: 'ICM_EMPLOYEE'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Employee'
@ObjectModel.semanticKey: ['addrnumber', 'persnumber']

define view ICM_EMPLOYEE_CONTACT
  as select from   mom052 as m52
     inner join adrc  as ac  on(
      m52.org_addr_number = ac.addrnumber
    )

    inner join but000  as b00  on(
      m52.partner_guid = b00.partner_guid

    )
    inner join adcp  as ad  on(
      b00.persnumber = ad.persnumber and
      ac.addrnumber  = ad.addrnumber

    )
    left outer join adr2  as a2  on(
      ad.addrnumber = a2.addrnumber and
      ad.persnumber = a2.persnumber

    )
    left outer join adr6  as a6  on(
      ad.addrnumber = a6.addrnumber and
      ad.persnumber = a6.persnumber

    )

{

      key m52.partner_guid,
      key m52.address_guid,

      key ac.addrnumber as addrnumber,
      key ac.date_from   as date_from_adrc,
      key ac.nation      as nation,

      key b00.partner,     

      key a2.persnumber as persnumber_adr2,
      key a2.addrnumber as addrnumber_adr2,
      key a2.date_from   as date_from_adr2_adr,
      key a2.consnumber  as consumer_adr2,

      key a6.persnumber  as persnumber_adr6,
      key a6.addrnumber  as addrnumber_adr6,
      key a6.date_from   as date_from_adr6_adr,
      key a6.consnumber  as consnumber_adr6,


      b00.persnumber,
      b00.name_last,
      b00.name_first,
      b00.augrp,
      ac.city1,
      ac.post_code1,
      ac.street,
      ac.house_num1,
      ac.country,
      ac.region,
      a2.telnr_long as telnr_long,
      a6.smtp_addr as smtp_addr

}

// for employee like contact

where ad.comp_pers = 'C'

Depth:

ICM_EMPLOYEE_CONTACT view