I_SrvcDocPartnerAddress

DDL: I_SRVCDOCPARTNERADDRESS Type: view_entity COMPOSITE
40 Fields 1 Data Sources 2 Associations

Service Transaction Partner Address

I_SrvcDocPartnerAddress is a Composite CDS View that provides data about "Service Transaction Partner Address" in SAP S/4HANA. It reads from 1 data source (I_CustMgmtPartner) and exposes 40 fields with key fields ServiceDocument, ServiceDocumentItem, CustMgmtPartnerFunction, CustMgmtBusinessPartner. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CustMgmtPartner ServicePartner from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Address_2 _Address $projection.AddressID = _Address.AddressID
[0..1] I_PersonWorkplaceAddress _PersonWorkplaceAddress $projection.AddressID = _PersonWorkplaceAddress.AddressID and $projection.AddressPersonID = _PersonWorkplaceAddress.AddressPersonID and $projection.AddressObjectType = '3'

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Service Transaction Partner Address view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocument I_CustMgmtPartner CustMgmtDocument Transaction ID
KEY ServiceDocumentItem CustMgmtDocumentItem Item Number in Doc.
KEY CustMgmtPartnerFunction I_CustMgmtPartner CustMgmtPartnerFunction Partner Function
KEY CustMgmtBusinessPartner I_CustMgmtPartner CustMgmtBusinessPartner Partner ID
CustMgmtObjectType CustMgmtObjectType Trans. Cat.
AddressID I_CustMgmtPartner AddressID Ship-to address
AddressPersonID I_CustMgmtPartner AddressPersonID Person Number
AddressObjectType I_CustMgmtPartner AddressObjectType Address Type
AddresseeFullNameendasAddresseeFullName
CityName _Address CityName Name
Country _Address Country Venue: Ctry/Reg
DistrictName _Address DistrictName District
EmailAddress
FaxAreaCodeSubscriberNumber
FaxExtensionNumber
FaxNumberCountry
FormOfAddressendasFormOfAddress
HouseNumber _Address HouseNumber House Number
MobileNumber
MobilePhoneCountry
OrganizationName1 _Address OrganizationName1 Name
OrganizationName2 _Address OrganizationName2 Name 2
OrganizationName3 _Address OrganizationName3 Name 3
OrganizationName4 _Address OrganizationName4 Name 4
PersonFamilyNameendasPersonFamilyName
PersonGivenNameendasPersonGivenName
PhoneExtensionNumber
PhoneNumber
PhoneNumberCountry
POBox _Address POBox PO Box
POBoxPostalCode _Address POBoxPostalCode PO Box Postal Code
PostalCode _Address PostalCode Postal Code
Region _Address Region Venue Region
StreetName _Address StreetName Text
StreetPrefixName1 _Address StreetPrefixName1 Street 2
StreetPrefixName2 _Address StreetPrefixName2 Street 3
StreetSuffixName1 _Address StreetSuffixName1 Street 4
StreetSuffixName2 _Address StreetSuffixName2 Street 5
TaxJurisdiction _Address TaxJurisdiction Tax Jurisdiction
TransportZone _Address TransportZone Transport Zone

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 I_SrvcDocPartnerAddress.
-- 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 I_SrvcDocPartnerAddress AS
SELECT
  ServicePartner.CustMgmtDocument AS ServiceDocument,
  CustMgmtDocumentItem AS ServiceDocumentItem,
  ServicePartner.CustMgmtPartnerFunction AS CustMgmtPartnerFunction,
  ServicePartner.CustMgmtBusinessPartner AS CustMgmtBusinessPartner,
  CustMgmtObjectType,
  ServicePartner.AddressID AS AddressID,
  ServicePartner.AddressPersonID AS AddressPersonID,
  ServicePartner.AddressObjectType AS AddressObjectType,
  case when ServicePartner.AddressObjectType = '3' then _PersonWorkplaceAddress.PersonFullName else _Address.AddresseeFullName end as AddresseeFullName AS AddresseeFullNameendasAddresseeFullName,
  _Address.CityName AS CityName,
  _Address.Country AS Country,
  _Address.DistrictName AS DistrictName,
  _Address._CurrentDfltEmailAddress.EmailAddress AS EmailAddress,
  _Address._CurrentDfltFaxNumber.FaxAreaCodeSubscriberNumber AS FaxAreaCodeSubscriberNumber,
  _Address._CurrentDfltFaxNumber.FaxExtensionNumber AS FaxExtensionNumber,
  _Address._CurrentDfltFaxNumber.FaxNumberCountry AS FaxNumberCountry,
  case when ServicePartner.AddressObjectType = '3' then _PersonWorkplaceAddress.FormOfAddress else _Address.FormOfAddress end as FormOfAddress AS FormOfAddressendasFormOfAddress,
  _Address.HouseNumber AS HouseNumber,
  _Address._CurrentDfltMobilePhoneNumber.PhoneAreaCodeSubscriberNumber AS MobileNumber,
  _Address._CurrentDfltMobilePhoneNumber.PhoneNumberCountry AS MobilePhoneCountry,
  _Address.OrganizationName1 AS OrganizationName1,
  _Address.OrganizationName2 AS OrganizationName2,
  _Address.OrganizationName3 AS OrganizationName3,
  _Address.OrganizationName4 AS OrganizationName4,
  case when ServicePartner.AddressObjectType = '3' then _PersonWorkplaceAddress.FamilyName else _Address.PersonFamilyName end as PersonFamilyName AS PersonFamilyNameendasPersonFamilyName,
  case when ServicePartner.AddressObjectType = '3' then _PersonWorkplaceAddress.GivenName else _Address.PersonGivenName end as PersonGivenName AS PersonGivenNameendasPersonGivenName,
  _Address._CurrentDfltLandlinePhoneNmbr.PhoneExtensionNumber AS PhoneExtensionNumber,
  _Address._CurrentDfltLandlinePhoneNmbr.PhoneAreaCodeSubscriberNumber AS PhoneNumber,
  _Address._CurrentDfltLandlinePhoneNmbr.PhoneNumberCountry AS PhoneNumberCountry,
  _Address.POBox AS POBox,
  _Address.POBoxPostalCode AS POBoxPostalCode,
  _Address.PostalCode AS PostalCode,
  _Address.Region AS Region,
  _Address.StreetName AS StreetName,
  _Address.StreetPrefixName1 AS StreetPrefixName1,
  _Address.StreetPrefixName2 AS StreetPrefixName2,
  _Address.StreetSuffixName1 AS StreetSuffixName1,
  _Address.StreetSuffixName2 AS StreetSuffixName2,
  _Address.TaxJurisdiction AS TaxJurisdiction,
  _Address.TransportZone AS TransportZone
FROM I_CustMgmtPartner AS ServicePartner
LEFT OUTER JOIN I_Address_2 AS _Address ON AddressID = _Address.AddressID  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkplaceAddress AS _PersonWorkplaceAddress ON AddressID = _PersonWorkplaceAddress.AddressID AND AddressPersonID = _PersonWorkplaceAddress.AddressPersonID AND AddressObjectType = '3'  -- association [0..1]
;

Learn More