A_SrvcOrdPartnerAddress

DDL: A_SRVCORDPARTNERADDRESS Type: view_entity COMPOSITE
39 Fields 3 Data Sources 2 Associations

Partner Address of Service Order

A_SrvcOrdPartnerAddress is a Composite CDS View that provides data about "Partner Address of Service Order" in SAP S/4HANA. It reads from 3 data sources (I_Address_2, I_ServiceDocument, I_CustMgmtPartner) and exposes 39 fields with key fields ServiceOrder, CustMgmtPartnerFunction, CustMgmtBusinessPartner. It has 2 associations to related views.

Data Sources (3)

SourceAliasJoin Type
I_Address_2 Address inner
I_ServiceDocument ServiceOrder inner
I_CustMgmtPartner ServicePartner from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_PersonWorkplaceAddress _PersonWorkplaceAddress $projection.AddressID = _PersonWorkplaceAddress.AddressID and $projection.AddressPersonID = _PersonWorkplaceAddress.AddressPersonID
[1] A_ServiceOrder _ServiceOrder $projection.ServiceOrder = _ServiceOrder.ServiceOrder

Annotations (9)

NameValueLevelField
EndUserText.label Partner Address of Service Order view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.updateEnabled true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view

Fields (39)

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

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 A_SrvcOrdPartnerAddress.
-- 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 A_SrvcOrdPartnerAddress AS
SELECT
  ServicePartner.CustMgmtDocument AS ServiceOrder,
  ServicePartner.CustMgmtPartnerFunction AS CustMgmtPartnerFunction,
  ServicePartner.CustMgmtBusinessPartner AS CustMgmtBusinessPartner,
  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
INNER JOIN I_Address_2 AS Address ON /* join condition not captured in parsed metadata */
INNER JOIN I_ServiceDocument AS ServiceOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PersonWorkplaceAddress AS _PersonWorkplaceAddress ON AddressID = _PersonWorkplaceAddress.AddressID AND AddressPersonID = _PersonWorkplaceAddress.AddressPersonID  -- association [0..1]
LEFT OUTER JOIN A_ServiceOrder AS _ServiceOrder ON ServiceOrder = _ServiceOrder.ServiceOrder  -- association [1]
;

Learn More