CIC_SalesDocumentPartner

DDL: CIC_SALESDOCUMENTPARTNER Type: view_entity

Projection on Sales Doc. Partner (Industry Cloud Solutions)

CIC_SalesDocumentPartner is a CDS View that provides data about "Projection on Sales Doc. Partner (Industry Cloud Solutions)" in SAP S/4HANA. It reads from 3 data sources (adrc, CIC_GEO_COORDINATES, I_SalesDocumentPartner) and exposes 37 fields with key fields SalesDocument, Partner, PartnerFunction.

3 data source(s) 37 fields

Data Sources (3)

SourceAliasJoin Type
adrc _Address left_outer
CIC_GEO_COORDINATES Coordinates left_outer
I_SalesDocumentPartner Partner from

Annotations (5)

NameValueLevelField
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Projection on Sales Doc. Partner (Industry Cloud Solutions) view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument I_SalesDocumentPartner SalesDocument
KEY Partner I_SalesDocumentPartner Partner
KEY PartnerFunction I_SalesDocumentPartner PartnerFunction
AddressObjectType I_SalesDocumentPartner AddressObjectType
CityName
CityNumber
StreetName
AddressTimeZone
Country
Region
SecondaryRegion
SecondaryRegionName
TertiaryRegion
TertiaryRegionName
PostalCode
BPCityDistrictCode adrc cityp_code
DistrictName
HouseNumber
AddresseeName1
AddresseeName2
AddresseeName3
AddresseeName4
CareOfName
firstname
middlename
lastname
Building
Floor
RoomNumber
AdditionalCityName
altidute CIC_GEO_COORDINATES altitude
latitude CIC_GEO_COORDINATES latitude
longitude CIC_GEO_COORDINATES longitude
EmailAddress I_SalesDocumentPartner EmailAddress
InternationalMobilePhoneNumber I_SalesDocumentPartner InternationalMobilePhoneNumber
InternationalPhoneNumber I_SalesDocumentPartner InternationalPhoneNumber
InternationalFaxNumber I_SalesDocumentPartner InternationalFaxNumber 
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #X,
     sizeCategory:   #XXL
   }
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Projection on Sales Doc. Partner (Industry Cloud Solutions)'
define view entity CIC_SalesDocumentPartner
  as select from    I_SalesDocumentPartner as Partner
    left outer join CIC_GEO_COORDINATES    as Coordinates on Partner.AddressID = Coordinates.addrnumber
    left outer join adrc                   as _Address    on  Partner.AddressID  = _Address.addrnumber
                                                          and _Address.nation    is initial
                                                          and _Address.date_from = '00010101'
{
  key Partner.SalesDocument,
  key Partner.Partner,
  key Partner.PartnerFunction,
      Partner.AddressObjectType,
      coalesce( Partner._PersonAddress.CityName, Partner._OrganizationAddress.CityName )                       as CityName,
      coalesce( Partner._PersonAddress.CityNumber, Partner._OrganizationAddress.CityNumber )                   as CityNumber,
      coalesce( Partner._PersonAddress.StreetName, Partner._OrganizationAddress.StreetName )                   as StreetName,
      coalesce( Partner._PersonAddress.AddressTimeZone, Partner._OrganizationAddress.AddressTimeZone )         as AddressTimeZone,
      coalesce( Partner._PersonAddress.Country, Partner._OrganizationAddress.Country )                         as Country,
      coalesce( Partner._PersonAddress.Region, Partner._OrganizationAddress.Region )                           as Region,
      coalesce( Partner._PersonAddress.SecondaryRegion, Partner._OrganizationAddress.SecondaryRegion )         as SecondaryRegion,
      coalesce( Partner._PersonAddress.SecondaryRegionName, Partner._OrganizationAddress.SecondaryRegionName ) as SecondaryRegionName,
      coalesce( Partner._PersonAddress.TertiaryRegion, Partner._OrganizationAddress.TertiaryRegion )           as TertiaryRegion,
      coalesce( Partner._PersonAddress.TertiaryRegionName, Partner._OrganizationAddress.TertiaryRegionName )   as TertiaryRegionName,
      coalesce( Partner._PersonAddress.PostalCode, Partner._OrganizationAddress.PostalCode )                   as PostalCode,
      _Address.cityp_code                                                                                      as BPCityDistrictCode,
      coalesce( Partner._PersonAddress.DistrictName, Partner._OrganizationAddress.DistrictName )               as DistrictName,
      coalesce( Partner._PersonAddress.HouseNumber, Partner._OrganizationAddress.HouseNumber )                 as HouseNumber,
      Partner._OrganizationAddress.AddresseeName1                                                              as AddresseeName1,
      Partner._OrganizationAddress.AddresseeName2                                                              as AddresseeName2,
      Partner._OrganizationAddress.AddresseeName3                                                              as AddresseeName3,
      Partner._OrganizationAddress.AddresseeName4                                                              as AddresseeName4,
      Partner._OrganizationAddress.CareOfName                                                                  as CareOfName,
      Partner._PersonAddress.GivenName                                                                         as firstname,
      Partner._PersonAddress.PersonMiddleName                                                                  as middlename,
      Partner._PersonAddress.FamilyName                                                                        as lastname,
      Partner._PersonAddress.PersonFullName                                                                    as personfullname,
      coalesce( Partner._PersonAddress.Building, Partner._OrganizationAddress.Building )                       as Building,
      coalesce( Partner._PersonAddress.Floor, Partner._OrganizationAddress.Floor )                             as Floor,
      coalesce( Partner._PersonAddress.RoomNumber, Partner._OrganizationAddress.RoomNumber )                   as RoomNumber,
      coalesce( Partner._PersonAddress.VillageName, Partner._OrganizationAddress.VillageName )                 as AdditionalCityName,
      Coordinates.altitude                                                                                     as altidute,
      Coordinates.latitude                                                                                     as latitude,
      Coordinates.longitude                                                                                    as longitude,
      Partner.EmailAddress                                                                                     as EmailAddress,
      Partner.InternationalMobilePhoneNumber                                                                   as InternationalMobilePhoneNumber,
      Partner.InternationalPhoneNumber                                                                         as InternationalPhoneNumber ,
      Partner.InternationalFaxNumber                                                                           as InternationalFaxNumber
}
where
     Partner.PartnerFunction = 'RE'
  or Partner.PartnerFunction = 'WE'
  or Partner.PartnerFunction = 'RG'
  or Partner.PartnerFunction = 'AG'

Learn More