I_SRVCDOCPARTNERADDRESS

CDS View

Service Transaction Partner Address

I_SRVCDOCPARTNERADDRESS is a CDS View in S/4HANA. Service Transaction Partner Address. It contains 35 fields. 6 CDS views read from this table.

Used by 6 CDS view(s) 35 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
R_SrvcConfItemPartnerAddressTP view_entity from TRANSACTIONAL Partner Address For Service Conf Item
R_SrvcConfPartnerAddressTP view_entity from TRANSACTIONAL Partner Address For Service Confirmation
R_SrvcOrdItemPartnerAddressTP view_entity from TRANSACTIONAL Partner Address For Service Order Item
R_SrvcOrdPartnerAddressTP view_entity from TRANSACTIONAL Partner Address For Service Order - TP
R_SrvcOrdTmplItmPrtnAddressTP view_entity from TRANSACTIONAL Partner Address For SrvcOrd TmplItm - TP
R_SrvcOrdTmplPartnerAddressTP view_entity from TRANSACTIONAL Partner Address For Srvc Ord Tmpl - TP

Fields (35)

KeyField CDS FieldsUsed in Views
KEY CustMgmtBusinessPartner CustMgmtBusinessPartner 2
KEY CustMgmtPartnerFunction CustMgmtPartnerFunction 2
KEY ServiceDocument ServiceOrderTemplate 2
KEY ServiceDocumentItem ServiceOrderTemplateItem 1
CityName CityName 2
CorrespondenceLanguage CorrespondenceLanguage 2
Country Country 2
DistrictName DistrictName 2
EmailAddress EmailAddress 2
FaxAreaCodeSubscriberNumber FaxAreaCodeSubscriberNumber 2
FaxExtensionNumber FaxExtensionNumber 2
FaxNumberCountry FaxNumberCountry 2
FormOfAddress FormOfAddress 2
HouseNumber HouseNumber 2
MobileNumber MobileNumber 2
MobilePhoneCountry MobilePhoneCountry 2
OrganizationName1 OrganizationName1 2
OrganizationName2 OrganizationName2 2
OrganizationName3 OrganizationName3 2
OrganizationName4 OrganizationName4 2
PersonFamilyName PersonFamilyName 2
PersonGivenName PersonGivenName 2
PhoneExtensionNumber PhoneExtensionNumber 2
PhoneNumber PhoneNumber 2
POBox POBox 2
POBoxPostalCode POBoxPostalCode 2
PostalCode PostalCode 2
Region Region 2
StreetName StreetName 2
StreetPrefixName1 StreetPrefixName1 2
StreetPrefixName2 StreetPrefixName2 2
StreetSuffixName1 StreetSuffixName1 2
StreetSuffixName2 StreetSuffixName2 2
TaxJurisdiction TaxJurisdiction 2
TransportZone TransportZone 2 
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Service Transaction Partner Address'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality:#C,
  sizeCategory: #L,
  dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE
define view entity I_SrvcDocPartnerAddress
  as select from I_CustMgmtPartner as ServicePartner
  association [0..1] to I_Address_2              as _Address                on  $projection.AddressID         =  _Address.AddressID
//                                                                            and $projection.AddressObjectType <> '3'

  association [0..1] to I_PersonWorkplaceAddress as _PersonWorkplaceAddress on  $projection.AddressID         = _PersonWorkplaceAddress.AddressID
                                                                            and $projection.AddressPersonID   = _PersonWorkplaceAddress.AddressPersonID
                                                                            and $projection.AddressObjectType = '3'


{
  key  ServicePartner.CustMgmtDocument                                      as ServiceDocument,
  key  CustMgmtDocumentItem                                                 as ServiceDocumentItem,
  key  ServicePartner.CustMgmtPartnerFunction,
  key  ServicePartner.CustMgmtBusinessPartner,

       CustMgmtObjectType,
       //Added for PersonWorkPlaceAddress association

       @Consumption.hidden: true
       @ObjectModel.readOnly: true
       ServicePartner.AddressID,
       @Consumption.hidden: true
       @ObjectModel.readOnly: true
       ServicePartner.AddressPersonID,

       @Consumption.hidden: true
       @ObjectModel.readOnly: true
       //Added to fetch address details based on address type

       ServicePartner.AddressObjectType,

       @ObjectModel.readOnly: true
       case
           when ServicePartner.AddressObjectType = '3'
            then _PersonWorkplaceAddress.PersonFullName
           else _Address.AddresseeFullName
       end                                                                  as AddresseeFullName,
       _Address.CityName,
       case
           when ServicePartner.AddressObjectType = '1'
            then _Address.CorrespondenceLanguage
       //            _PersonWorkplaceAddress.CorrespondenceLanguage

           else _Address.CorrespondenceLanguage
       end                                                                  as CorrespondenceLanguage,
       _Address.Country,
       _Address.DistrictName,
       _Address._CurrentDfltEmailAddress.EmailAddress,
       _Address._CurrentDfltFaxNumber.FaxAreaCodeSubscriberNumber,
       _Address._CurrentDfltFaxNumber.FaxExtensionNumber,
       _Address._CurrentDfltFaxNumber.FaxNumberCountry,
       case
           when ServicePartner.AddressObjectType = '3'
            then _PersonWorkplaceAddress.FormOfAddress
           else _Address.FormOfAddress
       end                                                                  as FormOfAddress,
       _Address.HouseNumber,
       _Address._CurrentDfltMobilePhoneNumber.PhoneAreaCodeSubscriberNumber as MobileNumber,
       _Address._CurrentDfltMobilePhoneNumber.PhoneNumberCountry            as MobilePhoneCountry,
       _Address.OrganizationName1,
       _Address.OrganizationName2,
       _Address.OrganizationName3,
       _Address.OrganizationName4,
       case
           when ServicePartner.AddressObjectType = '3'
            then _PersonWorkplaceAddress.FamilyName
           else _Address.PersonFamilyName
       end                                                                  as PersonFamilyName,
       case
           when ServicePartner.AddressObjectType = '3'
            then _PersonWorkplaceAddress.GivenName
           else _Address.PersonGivenName
       end                                                                  as PersonGivenName,

       _Address._CurrentDfltLandlinePhoneNmbr.PhoneExtensionNumber,
       _Address._CurrentDfltLandlinePhoneNmbr.PhoneAreaCodeSubscriberNumber as PhoneNumber,
       _Address._CurrentDfltLandlinePhoneNmbr.PhoneNumberCountry,
       _Address.POBox,
       _Address.POBoxPostalCode,
       _Address.PostalCode,
       _Address.Region,
       _Address.StreetName,
       _Address.StreetPrefixName1,
       _Address.StreetPrefixName2,
       _Address.StreetSuffixName1,
       _Address.StreetSuffixName2,
       _Address.TaxJurisdiction,
       _Address.TransportZone

}

Learn More