R_SrvcOrdPartnerAddressTP

DDL: R_SRVCORDPARTNERADDRESSTP Type: view_entity TRANSACTIONAL Package: CRMS4_SERVICE_ORDER_RAP

Partner Address For Service Order - TP

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

2 data source(s) 36 fields

Data Sources (2)

SourceAliasJoin Type
I_ServiceDocument ServiceOrder inner
I_SrvcDocPartnerAddress 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 - TP view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY ServiceOrder I_SrvcDocPartnerAddress ServiceDocument
KEY CustMgmtPartnerFunction I_SrvcDocPartnerAddress CustMgmtPartnerFunction
KEY CustMgmtBusinessPartner I_SrvcDocPartnerAddress CustMgmtBusinessPartner
CityName I_SrvcDocPartnerAddress CityName
CorrespondenceLanguage I_SrvcDocPartnerAddress CorrespondenceLanguage
Country I_SrvcDocPartnerAddress Country
DistrictName I_SrvcDocPartnerAddress DistrictName
EmailAddress I_SrvcDocPartnerAddress EmailAddress
FaxAreaCodeSubscriberNumber I_SrvcDocPartnerAddress FaxAreaCodeSubscriberNumber
FaxExtensionNumber I_SrvcDocPartnerAddress FaxExtensionNumber
FaxNumberCountry I_SrvcDocPartnerAddress FaxNumberCountry
FormOfAddress I_SrvcDocPartnerAddress FormOfAddress
HouseNumber I_SrvcDocPartnerAddress HouseNumber
MobileNumber I_SrvcDocPartnerAddress MobileNumber
MobilePhoneCountry I_SrvcDocPartnerAddress MobilePhoneCountry
OrganizationName1 I_SrvcDocPartnerAddress OrganizationName1
OrganizationName2 I_SrvcDocPartnerAddress OrganizationName2
OrganizationName3 I_SrvcDocPartnerAddress OrganizationName3
OrganizationName4 I_SrvcDocPartnerAddress OrganizationName4
PersonFamilyName I_SrvcDocPartnerAddress PersonFamilyName
PersonGivenName I_SrvcDocPartnerAddress PersonGivenName
PhoneExtensionNumber I_SrvcDocPartnerAddress PhoneExtensionNumber
PhoneNumber I_SrvcDocPartnerAddress PhoneNumber
POBox I_SrvcDocPartnerAddress POBox
POBoxPostalCode I_SrvcDocPartnerAddress POBoxPostalCode
PostalCode I_SrvcDocPartnerAddress PostalCode
Region I_SrvcDocPartnerAddress Region
StreetName I_SrvcDocPartnerAddress StreetName
StreetPrefixName1 I_SrvcDocPartnerAddress StreetPrefixName1
StreetPrefixName2 I_SrvcDocPartnerAddress StreetPrefixName2
StreetSuffixName1 I_SrvcDocPartnerAddress StreetSuffixName1
StreetSuffixName2 I_SrvcDocPartnerAddress StreetSuffixName2
TaxJurisdiction I_SrvcDocPartnerAddress TaxJurisdiction
TransportZone I_SrvcDocPartnerAddress TransportZone
_SrvcOrdPartnerTP _SrvcOrdPartnerTP
_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 - TP'
@ObjectModel: {
   usageType: {dataClass:      #TRANSACTIONAL,
                serviceQuality: #C,
                sizeCategory:   #L}
}
define view entity R_SrvcOrdPartnerAddressTP
  as select from I_SrvcDocPartnerAddress as ServicePartnerAddress
    inner join   I_ServiceDocument       as ServiceOrder on  ServicePartnerAddress.ServiceDocument    = ServiceOrder.ServiceDocument
                                                         and ServiceOrder.ServiceObjectType           = 'BUS2000116'
                                                         and ServiceOrder.ServiceDocumentIsQuotation  is initial
                                                         and ServiceOrder.ServiceDocumentTemplateType is initial
  association        to parent R_SrvcOrdPartnerTP as _SrvcOrdPartnerTP on  $projection.ServiceOrder            = _SrvcOrdPartnerTP.ServiceOrder
                                                                       and $projection.CustMgmtPartnerFunction = _SrvcOrdPartnerTP.CustMgmtPartnerFunction
                                                                       and $projection.CustMgmtBusinessPartner = _SrvcOrdPartnerTP.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.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

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

Learn More