R_SrvcOrdItemPartnerAddressTP

DDL: R_SRVCORDITEMPARTNERADDRESSTP Type: view_entity TRANSACTIONAL Package: CRMS4_SERVICE_ORDER_RAP

Partner Address For Service Order Item

R_SrvcOrdItemPartnerAddressTP is a Transactional CDS View that provides data about "Partner Address For Service Order Item" in SAP S/4HANA. It reads from 2 data sources (I_ServiceDocumentItem, R_SrvcDocItemPartnerAddress) and exposes 37 fields with key fields ServiceOrder, ServiceOrderItem, CustMgmtPartnerFunction, CustMgmtBusinessPartner. It has 1 association to related views. Part of development package CRMS4_SERVICE_ORDER_RAP.

2 data source(s) 37 fields

Data Sources (2)

SourceAliasJoin Type
I_ServiceDocumentItem ServiceOrderItem inner
R_SrvcDocItemPartnerAddress ServicePartnerAddress from

Associations (1)

CardinalityTargetAliasCondition
[0..1] R_ServiceOrderTP _ServiceOrderTP $projection.ServiceOrder = _ServiceOrderTP.ServiceOrder

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Partner Address For Service Order Item view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY ServiceOrder R_SrvcDocItemPartnerAddress ServiceDocument
KEY ServiceOrderItem R_SrvcDocItemPartnerAddress ServiceDocumentItem
KEY CustMgmtPartnerFunction R_SrvcDocItemPartnerAddress CustMgmtPartnerFunction
KEY CustMgmtBusinessPartner R_SrvcDocItemPartnerAddress CustMgmtBusinessPartner
CityName R_SrvcDocItemPartnerAddress CityName
CorrespondenceLanguage R_SrvcDocItemPartnerAddress CorrespondenceLanguage
Country R_SrvcDocItemPartnerAddress Country
DistrictName R_SrvcDocItemPartnerAddress DistrictName
EmailAddress R_SrvcDocItemPartnerAddress EmailAddress
FaxAreaCodeSubscriberNumber R_SrvcDocItemPartnerAddress FaxAreaCodeSubscriberNumber
FaxExtensionNumber R_SrvcDocItemPartnerAddress FaxExtensionNumber
FaxNumberCountry R_SrvcDocItemPartnerAddress FaxNumberCountry
FormOfAddress R_SrvcDocItemPartnerAddress FormOfAddress
HouseNumber R_SrvcDocItemPartnerAddress HouseNumber
MobileNumber R_SrvcDocItemPartnerAddress MobileNumber
MobilePhoneCountry R_SrvcDocItemPartnerAddress MobilePhoneCountry
OrganizationName1 R_SrvcDocItemPartnerAddress OrganizationName1
OrganizationName2 R_SrvcDocItemPartnerAddress OrganizationName2
OrganizationName3 R_SrvcDocItemPartnerAddress OrganizationName3
OrganizationName4 R_SrvcDocItemPartnerAddress OrganizationName4
PersonFamilyName R_SrvcDocItemPartnerAddress PersonFamilyName
PersonGivenName R_SrvcDocItemPartnerAddress PersonGivenName
PhoneExtensionNumber R_SrvcDocItemPartnerAddress PhoneExtensionNumber
PhoneNumber R_SrvcDocItemPartnerAddress PhoneNumber
POBox R_SrvcDocItemPartnerAddress POBox
POBoxPostalCode R_SrvcDocItemPartnerAddress POBoxPostalCode
PostalCode R_SrvcDocItemPartnerAddress PostalCode
Region R_SrvcDocItemPartnerAddress Region
StreetName R_SrvcDocItemPartnerAddress StreetName
StreetPrefixName1 R_SrvcDocItemPartnerAddress StreetPrefixName1
StreetPrefixName2 R_SrvcDocItemPartnerAddress StreetPrefixName2
StreetSuffixName1 R_SrvcDocItemPartnerAddress StreetSuffixName1
StreetSuffixName2 R_SrvcDocItemPartnerAddress StreetSuffixName2
TaxJurisdiction R_SrvcDocItemPartnerAddress TaxJurisdiction
TransportZone R_SrvcDocItemPartnerAddress TransportZone
_SrvcOrdItmPartnerTP _SrvcOrdItmPartnerTP
_ServiceOrderTP _ServiceOrderTP 
@AccessControl: {
  authorizationCheck: #MANDATORY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@Metadata:
{
  ignorePropagatedAnnotations: true
}
@EndUserText.label: 'Partner Address For Service Order Item'
@ObjectModel: {
   usageType: {dataClass:      #TRANSACTIONAL,
                serviceQuality: #C,
                sizeCategory:   #L}
}

define view entity R_SrvcOrdItemPartnerAddressTP
  as select from R_SrvcDocItemPartnerAddress as ServicePartnerAddress

    inner join   I_ServiceDocumentItem   as ServiceOrderItem on  ServicePartnerAddress.ServiceDocument           = ServiceOrderItem.ServiceDocument
                                                             and ServicePartnerAddress.ServiceDocumentItem       = ServiceOrderItem.ServiceDocumentItem
                                                             and ServiceOrderItem.ServiceObjectType              = 'BUS2000116'
                                                             and ServiceOrderItem.ServiceDocumentItemIsQuotation is initial
                                                             and ServiceOrderItem.ServiceDocumentTemplateType    is initial


  association        to parent R_SrvcOrdItmPartnerTP as _SrvcOrdItmPartnerTP on  $projection.ServiceOrder            = _SrvcOrdItmPartnerTP.ServiceOrder
                                                                             and $projection.ServiceOrderItem        = _SrvcOrdItmPartnerTP.ServiceOrderItem
                                                                             and $projection.CustMgmtPartnerFunction = _SrvcOrdItmPartnerTP.CustMgmtPartnerFunction
                                                                             and $projection.CustMgmtBusinessPartner = _SrvcOrdItmPartnerTP.CustMgmtBusinessPartner
  association [0..1] to R_ServiceOrderTP             as _ServiceOrderTP      on  $projection.ServiceOrder = _ServiceOrderTP.ServiceOrder

{
      @ObjectModel.foreignKey.association: '_ServiceOrderTP'
  key ServicePartnerAddress.ServiceDocument     as ServiceOrder,
  key ServicePartnerAddress.ServiceDocumentItem as ServiceOrderItem,
  key ServicePartnerAddress.CustMgmtPartnerFunction,
  key ServicePartnerAddress.CustMgmtBusinessPartner,
      ServicePartnerAddress.CityName,
      ServicePartnerAddress.CorrespondenceLanguage,
      ServicePartnerAddress.Country,
      ServicePartnerAddress.DistrictName,
      ServicePartnerAddress.EmailAddress,
      ServicePartnerAddress.FaxAreaCodeSubscriberNumber,
      ServicePartnerAddress.FaxExtensionNumber,
      ServicePartnerAddress.FaxNumberCountry,
      ServicePartnerAddress.FormOfAddress,
      ServicePartnerAddress.HouseNumber,
      ServicePartnerAddress.MobileNumber,
      ServicePartnerAddress.MobilePhoneCountry,
      ServicePartnerAddress.OrganizationName1,
      ServicePartnerAddress.OrganizationName2,
      ServicePartnerAddress.OrganizationName3,
      ServicePartnerAddress.OrganizationName4,
      ServicePartnerAddress.PersonFamilyName,
      ServicePartnerAddress.PersonGivenName,
      ServicePartnerAddress.PhoneExtensionNumber,
      ServicePartnerAddress.PhoneNumber,
      //  PhoneNumberCountry,

      ServicePartnerAddress.POBox,
      ServicePartnerAddress.POBoxPostalCode,
      ServicePartnerAddress.PostalCode,
      ServicePartnerAddress.Region,
      ServicePartnerAddress.StreetName,
      ServicePartnerAddress.StreetPrefixName1,
      ServicePartnerAddress.StreetPrefixName2,
      ServicePartnerAddress.StreetSuffixName1,
      ServicePartnerAddress.StreetSuffixName2,
      ServicePartnerAddress.TaxJurisdiction,
      ServicePartnerAddress.TransportZone,

      //Associations

      _SrvcOrdItmPartnerTP,
      _ServiceOrderTP
}
where
      ServicePartnerAddress.CustMgmtObjectType  = 'BUS2000116'
  and ServicePartnerAddress.ServiceDocumentItem is not initial

Learn More