CIC_SalesDocumentPartner

DDL: CIC_SALESDOCUMENTPARTNER Type: view_entity
37 Fields 3 Data Sources

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.

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 SD Document
KEY Partner I_SalesDocumentPartner Partner With Partner
KEY PartnerFunction I_SalesDocumentPartner PartnerFunction Partner Functn
AddressObjectType I_SalesDocumentPartner AddressObjectType Address Type
CityName
CityNumber
StreetName
AddressTimeZone
Country
Region
SecondaryRegion
SecondaryRegionName
TertiaryRegion
TertiaryRegionName
PostalCode
BPCityDistrictCode adrc cityp_code District Code
DistrictName
HouseNumber
AddresseeName1
AddresseeName2
AddresseeName3
AddresseeName4
CareOfName
firstname
middlename
lastname
Building
Floor
RoomNumber
AdditionalCityName
altidute CIC_GEO_COORDINATES altitude Height
latitude CIC_GEO_COORDINATES latitude Latitude
longitude CIC_GEO_COORDINATES longitude Longitude
EmailAddress I_SalesDocumentPartner EmailAddress E-Mail Address
InternationalMobilePhoneNumber I_SalesDocumentPartner InternationalMobilePhoneNumber
InternationalPhoneNumber I_SalesDocumentPartner InternationalPhoneNumber Telephone no.
InternationalFaxNumber I_SalesDocumentPartner InternationalFaxNumber Fax Number

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 CIC_SalesDocumentPartner.
-- 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 CIC_SalesDocumentPartner AS
SELECT
  Partner.SalesDocument AS SalesDocument,
  Partner.Partner AS Partner,
  Partner.PartnerFunction AS PartnerFunction,
  Partner.AddressObjectType AS 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,
  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
FROM I_SalesDocumentPartner AS Partner
LEFT OUTER JOIN CIC_GEO_COORDINATES AS Coordinates ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adrc AS _Address ON /* join condition not captured in parsed metadata */
;

Learn More