ICM_PARTNER_CONTACT

DDL: ICM_PARTNER_CONTACT SQL: ICM_PARTNER_CONT Type: view
28 Fields 6 Data Sources

BusinessPartner_contact

ICM_PARTNER_CONTACT is a CDS View that provides data about "BusinessPartner_contact" in SAP S/4HANA. It reads from 6 data sources and exposes 28 fields with key fields relnr, partner1, partner2, date_to, addrnumber.

Data Sources (6)

SourceAliasJoin Type
adr2 a2 left_outer
adr6 a6 left_outer
adrc ac inner
adcp ad inner
but000 b00 inner
but052 b52 from

Annotations (3)

NameValueLevelField
AbapCatalog.sqlViewName ICM_PARTNER_CONT view
AbapCatalog.compiler.compareFilter true view
EndUserText.label BusinessPartner_contact view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY relnr but052 relnr BP Rel. Number
KEY partner1 but052 partner1 Busn. Partner
KEY partner2 but052 partner2 Busn. Partner
KEY date_to but052 date_to Validity End Date
KEY addrnumber but052 addrnumber Address Number
KEY nation adrc nation Country/Region
KEY nation_adcp adcp nation Country/Region
KEY consnumber adr2 consnumber Sequence Number
KEY consnumber_1 adr6 consnumber Sequence Number
name1 adrc name1 PA text
name2 adrc name2 Name2/First nme
name3 adrc name3 Name 3
name4 adrc name4 Name 4
city1 adrc city1 City
post_code1 adrc post_code1 Postal Code
post_code2 adrc post_code2 PO Box Post Cde
po_box adrc po_box PO Box
street adrc street Street Code
house_num1 adrc house_num1 House Number
country adrc country Venue: Ctry/Reg
region adrc region Venue Region
name_last but000 name_last Last Name
name_first but000 name_first First Name
augrp but000 augrp Component of the Version Number
persnumber but000 persnumber Person Number
telnr_long adr2 telnr_long Telephone no.
smtp_addr adr6 smtp_addr E-Mail Address
comp_pers adcp comp_pers Company/Person

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view ICM_PARTNER_CONTACT.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ICM_PARTNER_CONT

CREATE VIEW ICM_PARTNER_CONTACT AS
SELECT
  b52.relnr AS relnr,
  b52.partner1 AS partner1,
  b52.partner2 AS partner2,
  b52.date_to AS date_to,
  b52.addrnumber AS addrnumber,
  ac.nation AS nation,
  ad.nation AS nation_adcp,
  a2.consnumber AS consnumber,
  a6.consnumber AS consnumber_1,
  ac.name1 AS name1,
  ac.name2 AS name2,
  ac.name3 AS name3,
  ac.name4 AS name4,
  ac.city1 AS city1,
  ac.post_code1 AS post_code1,
  ac.post_code2 AS post_code2,
  ac.po_box AS po_box,
  ac.street AS street,
  ac.house_num1 AS house_num1,
  ac.country AS country,
  ac.region AS region,
  b00.name_last AS name_last,
  b00.name_first AS name_first,
  b00.augrp AS augrp,
  b00.persnumber AS persnumber,
  a2.telnr_long AS telnr_long,
  a6.smtp_addr AS smtp_addr,
  ad.comp_pers AS comp_pers
FROM but052 AS b52
INNER JOIN adrc AS ac ON /* join condition not captured in parsed metadata */
INNER JOIN but000 AS b00 ON /* join condition not captured in parsed metadata */
INNER JOIN adcp AS ad ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adr2 AS a2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adr6 AS a6 ON /* join condition not captured in parsed metadata */
;

Learn More