R_SRVCDOCITEMPARTNERADDRESS

CDS View

Partner Address For Srvc Trans Item

R_SRVCDOCITEMPARTNERADDRESS is a CDS View in S/4HANA. Partner Address For Srvc Trans Item. It contains 40 fields. 6 CDS views read from this table.

Used by 6 CDS view(s) 40 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
R_BusSolnOrdItmPartnerAddrTP view_entity from TRANSACTIONAL Business Soln Ord Item Partner Address - TP
R_SrvcConfItemPartnerAddressTP view_entity from TRANSACTIONAL Partner Address For Service Conf Item
R_SrvcContrItmPartnerAddressTP view_entity from TRANSACTIONAL Partner Address in Srvc Contr Item - TP
R_SrvcOrdItemPartnerAddressTP view_entity from TRANSACTIONAL Partner Address For Service Order Item
R_SrvcOrdTmplItmPrtnAddressTP view_entity from TRANSACTIONAL Partner Address For SrvcOrd TmplItm - TP
R_SrvcQtanItemPartnerAddressTP view_entity from TRANSACTIONAL Prtn Addr For Service Quotation Item-TP

Fields (40)

KeyField CDS FieldsUsed in Views
KEY CustMgmtBusinessPartner CustMgmtBusinessPartner 5
KEY CustMgmtPartnerFunction CustMgmtPartnerFunction 5
KEY ServiceDocument BusinessSolutionOrder,ServiceContract,ServiceOrder,ServiceOrderTemplate,ServiceQuotation 5
KEY ServiceDocumentItem BusinessSolutionOrderItem,ServiceContractItem,ServiceOrderItem,ServiceOrderTemplateItem,ServiceQuotationItem 5
AddresseeFullName AddresseeFullName 2
AddressID AddressID 2
AddressObjectType AddressObjectType 2
AddressPersonID AddressPersonID 2
CityName CityName 5
CorrespondenceLanguage CorrespondenceLanguage 5
Country Country 5
DistrictName DistrictName 5
EmailAddress EmailAddress 5
FaxAreaCodeSubscriberNumber FaxAreaCodeSubscriberNumber 5
FaxExtensionNumber FaxExtensionNumber 5
FaxNumberCountry FaxNumberCountry 5
FormOfAddress FormOfAddress 5
HouseNumber HouseNumber 5
MobileNumber MobileNumber 5
MobilePhoneCountry MobilePhoneCountry 5
OrganizationName1 OrganizationName1 5
OrganizationName2 OrganizationName2 5
OrganizationName3 OrganizationName3 5
OrganizationName4 OrganizationName4 5
PersonFamilyName PersonFamilyName 5
PersonGivenName PersonGivenName 5
PhoneExtensionNumber PhoneExtensionNumber 5
PhoneNumber PhoneNumber 5
PhoneNumberCountry PhoneNumberCountry 2
POBox POBox 5
POBoxPostalCode POBoxPostalCode 5
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 5 
@AccessControl: {
  authorizationCheck:#PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #MIXED
}
@EndUserText.label: 'Partner Address For Srvc Trans Item'
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
define view entity R_SrvcDocItemPartnerAddress 
as select from I_ServiceDocumentItemPartner //P_SrvcDocItemPartner

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


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

       ServicePartner.ServiceObjectType                                     as 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