I_SRVCDOCPARTNERADDRESS

CDS View

Service Transaction Partner Address

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

Used by 6 CDS view(s) 39 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
R_BusSolnOrdPartnerAddressTP view_entity from TRANSACTIONAL Business Soln Order Partner Address - TP
R_SrvcConfPartnerAddressTP view_entity from TRANSACTIONAL Partner Address For Service Confirmation
R_SrvcContrPartnerAddressTP view_entity from TRANSACTIONAL Partner Address in Service Contract - TP
R_SrvcOrdPartnerAddressTP view_entity from TRANSACTIONAL Partner Address For Service Order - TP
R_SrvcOrdTmplPartnerAddressTP view_entity from TRANSACTIONAL Partner Address For Srvc Ord Tmpl - TP
R_SrvcQtanPartnerAddressTP view_entity from TRANSACTIONAL Partner Address For Service Quotation-TP

Fields (39)

KeyField CDS FieldsUsed in Views
KEY CustMgmtBusinessPartner CustMgmtBusinessPartner 5
KEY CustMgmtPartnerFunction CustMgmtPartnerFunction 5
KEY ServiceDocument BusinessSolutionOrder,ServiceContract,ServiceOrder,ServiceOrderTemplate,ServiceQuotation 5
AddresseeFullName AddresseeFullName 2
AddressID AddressID 2
AddressObjectType AddressObjectType 2
AddressPersonID AddressPersonID 2
CityName CityName 5
CorrespondenceLanguage CorrespondenceLanguage 4
Country Country 5
DistrictName DistrictName 4
EmailAddress EmailAddress 5
FaxAreaCodeSubscriberNumber FaxAreaCodeSubscriberNumber 5
FaxExtensionNumber FaxExtensionNumber 5
FaxNumberCountry FaxNumberCountry 5
FormOfAddress FormOfAddress 4
HouseNumber HouseNumber 5
MobileNumber MobileNumber 5
MobilePhoneCountry MobilePhoneCountry 5
OrganizationName1 OrganizationName1 5
OrganizationName2 OrganizationName2 5
OrganizationName3 OrganizationName3 5
OrganizationName4 OrganizationName4 5
PersonFamilyName PersonFamilyName 4
PersonGivenName PersonGivenName 4
PhoneExtensionNumber PhoneExtensionNumber 5
PhoneNumber PhoneNumber 5
PhoneNumberCountry PhoneNumberCountry 2
POBox POBox 4
POBoxPostalCode POBoxPostalCode 4
PostalCode PostalCode 5
Region Region 5
StreetName StreetName 5
StreetPrefixName1 StreetPrefixName1 5
StreetPrefixName2 StreetPrefixName2 5
StreetSuffixName1 StreetSuffixName1 5
StreetSuffixName2 StreetSuffixName2 5
TaxJurisdiction TaxJurisdiction 5
TransportZone TransportZone 4 
@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,
       _Address.CorrespondenceLanguage                                      as CorrespondenceLanguage,
       //       case

       //           when ServicePartner.AddressObjectType = '1'

       //            then _Address.CorrespondenceLanguage

       //       //            _PersonWorkplaceAddress.CorrespondenceLanguage

       //           else _Address.CorrespondenceLanguage

       //       end                                                                  as CorrespondenceLanguage,

       _Address.Country,
       _Address.DistrictName,
       case
        when ServicePartner.AddressObjectType = '3'
        then _PersonWorkplaceAddress._CurrentDfltEmailAddress.EmailAddress
        else
       _Address._CurrentDfltEmailAddress.EmailAddress
       end                                                                  as EmailAddress,
       _Address._CurrentDfltFaxNumber.FaxAreaCodeSubscriberNumber,
       _Address._CurrentDfltFaxNumber.FaxExtensionNumber,
       _Address._CurrentDfltFaxNumber.FaxNumberCountry,
       _Address.FormOfAddress                                               as FormOfAddress,
       //       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,

       case
          when ServicePartner.AddressObjectType = '3'
           then _PersonWorkplaceAddress._CurrentDfltLandlinePhoneNmbr.PhoneExtensionNumber
          else _Address._CurrentDfltLandlinePhoneNmbr.PhoneExtensionNumber
       end                                                                  as PhoneExtensionNumber,
       //_Address._CurrentDfltLandlinePhoneNmbr.PhoneExtensionNumber,


       case
          when ServicePartner.AddressObjectType = '3'
           then _PersonWorkplaceAddress._CurrentDfltLandlinePhoneNmbr.PhoneAreaCodeSubscriberNumber
           else _Address._CurrentDfltLandlinePhoneNmbr.PhoneAreaCodeSubscriberNumber
          end                                                               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