R_BusSolnOrdPartnerAddressTP

DDL: R_BUSSOLNORDPARTNERADDRESSTP Type: view_entity TRANSACTIONAL Package: CRMS4_SOLUTION_ORDER_RAP

Business Soln Order Partner Address - TP

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

2 data source(s) 41 fields

Data Sources (2)

SourceAliasJoin Type
I_SrvcDocPartnerAddress ServicePartnerAddress from
I_ServiceDocument SolutionOrder inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] R_BusinessSolutionOrderTP _BusinessSolutionOrderTP $projection.BusinessSolutionOrder = _BusinessSolutionOrderTP.BusinessSolutionOrder

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 Business Soln Order Partner Address - TP view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY BusinessSolutionOrder I_SrvcDocPartnerAddress ServiceDocument
KEY CustMgmtPartnerFunction I_SrvcDocPartnerAddress CustMgmtPartnerFunction
KEY CustMgmtBusinessPartner I_SrvcDocPartnerAddress CustMgmtBusinessPartner
AddressID I_SrvcDocPartnerAddress AddressID
AddressPersonID I_SrvcDocPartnerAddress AddressPersonID
AddressObjectType I_SrvcDocPartnerAddress AddressObjectType
AddresseeFullName I_SrvcDocPartnerAddress AddresseeFullName
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
PhoneNumberCountry I_SrvcDocPartnerAddress PhoneNumberCountry
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
_BusSolnOrdPartnerTP _BusSolnOrdPartnerTP
_BusinessSolutionOrderTP _BusinessSolutionOrderTP 
@AccessControl: {
  authorizationCheck: #MANDATORY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@Metadata:
{
  ignorePropagatedAnnotations: true
}
@EndUserText.label: 'Business Soln Order Partner Address - TP'
@ObjectModel: {
   usageType: {dataClass:      #TRANSACTIONAL,
                serviceQuality: #C,
                sizeCategory:   #L}
}
define view entity R_BusSolnOrdPartnerAddressTP
  as select from I_SrvcDocPartnerAddress as ServicePartnerAddress
    inner join   I_ServiceDocument       as SolutionOrder on  ServicePartnerAddress.ServiceDocument    = SolutionOrder.ServiceDocument
                                                          and SolutionOrder.ServiceObjectType           = 'BUS2000172'

  association  to parent R_BusSolnOrdPartnerTP as _BusSolnOrdPartnerTP on  $projection.BusinessSolutionOrder            = _BusSolnOrdPartnerTP.BusinessSolutionOrder
                                                                       and $projection.CustMgmtPartnerFunction = _BusSolnOrdPartnerTP.CustMgmtPartnerFunction
                                                                       and $projection.CustMgmtBusinessPartner = _BusSolnOrdPartnerTP.CustMgmtBusinessPartner
  association [0..1] to R_BusinessSolutionOrderTP          as _BusinessSolutionOrderTP   on  $projection.BusinessSolutionOrder = _BusinessSolutionOrderTP.BusinessSolutionOrder

{
      @ObjectModel.foreignKey.association: '_BusinessSolutionOrderTP'
  key ServicePartnerAddress.ServiceDocument as BusinessSolutionOrder,
  key ServicePartnerAddress.CustMgmtPartnerFunction,
  key ServicePartnerAddress.CustMgmtBusinessPartner,
      ServicePartnerAddress.AddressID,
      ServicePartnerAddress.AddressPersonID,
      ServicePartnerAddress.AddressObjectType,
      ServicePartnerAddress.AddresseeFullName,
      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,
      ServicePartnerAddress.PhoneNumberCountry,
      ServicePartnerAddress.POBox,
      ServicePartnerAddress.POBoxPostalCode,
      ServicePartnerAddress.PostalCode,
      ServicePartnerAddress.Region,
      ServicePartnerAddress.StreetName,
      ServicePartnerAddress.StreetPrefixName1,
      ServicePartnerAddress.StreetPrefixName2,
      ServicePartnerAddress.StreetSuffixName1,
      ServicePartnerAddress.StreetSuffixName2,
      ServicePartnerAddress.TaxJurisdiction,
      ServicePartnerAddress.TransportZone,

      //Associations

      _BusSolnOrdPartnerTP,
      _BusinessSolutionOrderTP
}
where
      ServicePartnerAddress.CustMgmtObjectType  = 'BUS2000172'
  and ServicePartnerAddress.ServiceDocumentItem is initial

Learn More