C_IBCCntctProjtnSegmentation

DDL: C_IBCCNTCTPROJTNSEGMENTATION Type: view_entity CONSUMPTION
41 Fields 1 Data Sources 2 Associations

Contact Projection for Segmentation

C_IBCCntctProjtnSegmentation (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Cross Applications

C_IBCCntctProjtnSegmentation is a Consumption CDS View that provides data about "Contact Projection for Segmentation" in SAP S/4HANA. It reads from 1 data source (I_IBCContactProjection) and exposes 41 fields with key field InteractionCntctProjectionUUID. It has 2 associations to related views.

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentCA-IBC-PRF
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_IBCContactProjection I_IBCContactProjection from

Associations (2)

CardinalityTargetAliasCondition
[1..1] E_IBCContactProjection _Extension $projection.InteractionCntctProjectionUUID = _Extension.InteractionCntctProjectionUUID
[0..*] C_IBCInteractionSegmentation _Interaction $projection.InteractionContactUUID = _Interaction.InteractionContactUUID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Contact Projection for Segmentation view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.modelingPattern #NONE view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY InteractionCntctProjectionUUID InteractionCntctProjectionUUID Projection Key
InteractionContactUUID InteractionContactUUID Contact Key
RelationshipCategory RelationshipCategory Business Partner Relationship Category
FullName FullName Full Name of Person
FirstName FirstName First Name
LastName LastName Last Name
PhoneNumber PhoneNumber Telephone no.
MobileNumber MobileNumber Mobile Number
EmailAddress EmailAddress E-Mail Address
StreetName StreetName Street
AddressHouseNumber AddressHouseNumber House Number
InteractionContactDepartment InteractionContactDepartment Contact person department
IntactnCntctDepartmentName Description
InteractionContactFunction InteractionContactFunction Function of partner
PartnerFunctionName Description
MaritalStatus MaritalStatus Marital Status of Business Partner
MaritalStatusName Short name
CityName CityName Name
FormOfAddress FormOfAddress Form-of-Address Key
WebsiteURL WebsiteURL Web Site
Industry Industry Industry Sector
IndustryKeyText Description of the Industry Key
Country Country Country/Region Key
CountryName Country/Region Name
AddressRegion AddressRegion Region (State, Province, County)
RegionName Description
ContactLanguage _Language LanguageISOCode 2-Character SAP Language Code
LanguageName Name of Language
GenderCode GenderCode Gender of Business Partner (Person)
GenderCodeName Short Text for Fixed Values
BirthDate BirthDate Date of Birth
ContactPostalCode ContactPostalCode City Postal Code
CommunicationArea CommunicationArea Communication Area ID
ReferencedOrgStructure ReferencedOrgStructure Source Organization
InteractionContactType InteractionContactType Interaction Contact Type
PartnerFunctionType PartnerFunctionType Type of partner number
BusinessPartner BusinessPartner Business Partner Number (Contact)
Customer Customer Customer Number (Contact)
Supplier Supplier Supplier Number (Contact)
_Interaction _Interaction
_AuthCommArea _AuthCommArea

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 C_IBCCntctProjtnSegmentation.
-- 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.

CREATE VIEW C_IBCCntctProjtnSegmentation AS
SELECT
  InteractionCntctProjectionUUID,
  InteractionContactUUID,
  RelationshipCategory,
  FullName,
  FirstName,
  LastName,
  PhoneNumber,
  MobileNumber,
  EmailAddress,
  StreetName,
  AddressHouseNumber,
  InteractionContactDepartment,
  _MKT_Department._Text[1: Language=$session.system_language].DepartmentName AS IntactnCntctDepartmentName,
  InteractionContactFunction,
  _MKT_Function._Text[1: Language=$session.system_language].FunctionDescription AS PartnerFunctionName,
  MaritalStatus,
  _MKT_Marital._Text[1: Language=$session.system_language].MaritalStatusName AS MaritalStatusName,
  CityName,
  FormOfAddress,
  WebsiteURL,
  Industry,
  _MKT_Industry._Text[1: Language=$session.system_language].IndustryName AS IndustryKeyText,
  Country,
  _MKT_Country._Text[1: Language=$session.system_language].CountryName AS CountryName,
  AddressRegion,
  _MKT_Region._RegionText[1: Language=$session.system_language].RegionName AS RegionName,
  _Language.LanguageISOCode AS ContactLanguage,
  _Language._Text[1: Language=$session.system_language].LanguageName AS LanguageName,
  GenderCode,
  _MKT_Gender._Text[1: Language=$session.system_language].GenderCodeName AS GenderCodeName,
  BirthDate,
  ContactPostalCode,
  CommunicationArea,
  ReferencedOrgStructure,
  InteractionContactType,
  PartnerFunctionType,
  BusinessPartner,
  Customer,
  Supplier
FROM I_IBCContactProjection
LEFT OUTER JOIN E_IBCContactProjection AS _Extension ON InteractionCntctProjectionUUID = _Extension.InteractionCntctProjectionUUID  -- association [1..1]
LEFT OUTER JOIN C_IBCInteractionSegmentation AS _Interaction ON InteractionContactUUID = _Interaction.InteractionContactUUID  -- association [0..*]
;

Learn More