CIC_CustomerData

DDL: CIC_CUSTOMERDATA Type: view_entity

Proj. View on Customer

CIC_CustomerData is a CDS View that provides data about "Proj. View on Customer" in SAP S/4HANA. It reads from 2 data sources (I_BusinessPartner, I_Customer_to_BusinessPartner) and exposes 20 fields with key field Customer. It has 2 associations to related views.

2 data source(s) 20 fields

Data Sources (2)

SourceAliasJoin Type
I_BusinessPartner _BusinessPartner inner
I_Customer_to_BusinessPartner _CustomerBPAssoc inner

Associations (2)

CardinalityTargetAliasCondition
[0..1] CIC_LanguageRegion _Language $projection.BPLanguage = _Language.Language
[0..1] CIC_LanguageRegion _CorresLanguage $projection.BPCorrespondenceLanguage = _CorresLanguage.Language

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Proj. View on Customer view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY Customer Customer Customer
DeletionIndicator Customer DeletionIndicator
BusinessPartner I_BusinessPartner BusinessPartner
BusinessPartnerCategory I_BusinessPartner BusinessPartnerCategory
FirstName I_BusinessPartner FirstName
LastName I_BusinessPartner LastName
MiddleName I_BusinessPartner MiddleName
BusinessPartnerName I_BusinessPartner BusinessPartnerName
BPLanguage I_BusinessPartner Language
GenderCodeName I_BusinessPartner GenderCodeName
BPCorrespondenceLanguage I_BusinessPartner CorrespondenceLanguage
BirthDate I_BusinessPartner BirthDate
AcademicTitle I_BusinessPartner AcademicTitle
OrganizationBPName1 I_BusinessPartner OrganizationBPName1
OrganizationBPName2 I_BusinessPartner OrganizationBPName2
OrganizationBPName3 I_BusinessPartner OrganizationBPName3
OrganizationBPName4 I_BusinessPartner OrganizationBPName4
IsBusinessPurposeCompleted Customer IsBusinessPurposeCompleted
Language _Language iso2_country
CorrespondenceLanguage _CorresLanguage iso2_country 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Proj. View on Customer'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XL,
  dataClass: #MASTER
}
define view entity CIC_CustomerData
  as select distinct from I_Customer                    as Customer
  //    inner join            I_BPMultipleAssignment as _CustomerBPAssoc on  _CustomerBPAssoc.BPObjectID           = Customer.Customer

  //                                                                     and _CustomerBPAssoc.BPAssignmentCategory = 'CUST'

  //                                                                     and _CustomerBPAssoc.IsStandardAssignment = 'X'

    inner join            I_Customer_to_BusinessPartner as _CustomerBPAssoc on _CustomerBPAssoc.Customer = Customer.Customer
    inner join            I_BusinessPartner             as _BusinessPartner on _BusinessPartner.BusinessPartnerUUID = _CustomerBPAssoc.BusinessPartnerUUID
    association [0..1] to CIC_LanguageRegion     as _Language    on $projection.BPLanguage = _Language.Language
    association [0..1] to CIC_LanguageRegion     as _CorresLanguage    on $projection.BPCorrespondenceLanguage = _CorresLanguage.Language
{
  key Customer.Customer,
      Customer.DeletionIndicator,
      _BusinessPartner.BusinessPartner,
      _BusinessPartner.BusinessPartnerCategory, //Person or Organization

      _BusinessPartner.FirstName,
      _BusinessPartner.LastName,
      _BusinessPartner.MiddleName,
      _BusinessPartner.BusinessPartnerName, //BP Full Name for Person and Organization

      _BusinessPartner.Language as BPLanguage,
      _BusinessPartner.GenderCodeName,
      _BusinessPartner.CorrespondenceLanguage as BPCorrespondenceLanguage,
      _BusinessPartner.BirthDate,
      _BusinessPartner.AcademicTitle,

      // Organization fields

      _BusinessPartner.OrganizationBPName1,
      _BusinessPartner.OrganizationBPName2,
      _BusinessPartner.OrganizationBPName3,
      _BusinessPartner.OrganizationBPName4,

      Customer.IsBusinessPurposeCompleted,

     _Language.iso2_country as Language,
     _CorresLanguage.iso2_country as CorrespondenceLanguage

      //      _BusinessPartner.AdditionalLastName,

      //      _BusinessPartner.Initials,

      //      _BusinessPartner.FormOfAddress,

      //      _BusinessPartner.AcademicTitle,

      //      _BusinessPartner.AcademicTitle2,

      //      _BusinessPartner.LastNamePrefix,

      //      _BusinessPartner.LastNameSecondPrefix,

      //      _BusinessPartner.BusinessPartnerSupplementName,

      //      _BusinessPartner.BusinessPartnerBirthName,

      //      _BusinessPartner.BusinessPartnerNicknameLabel,

      //      _BusinessPartner.BusPartMaritalStatus,

      //      _BusinessPartner.NaturalPersonEmployerName,

      //      _BusinessPartner.BusinessPartnerOccupation,

      //      _BusinessPartner.BusinessPartnerBirthplaceName,

      //      _BusinessPartner.BusinessPartnerDeathDate,

      //      _BusinessPartner.NameCountry,

      //      _BusinessPartner.NameFormat,

      //      _BusinessPartner.BusinessPartnerSalutation,



}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CIC_LANGUAGEREGION",
"I_BUSINESSPARTNER",
"I_CUSTOMER",
"I_CUSTOMER_TO_BUSINESSPARTNER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More