R_SrvcContrItmPartnerAddressTP

DDL: R_SRVCCONTRITMPARTNERADDRESSTP Type: view_entity TRANSACTIONAL Package: CRMS4_SERVICE_CONTRACT_RAP

Partner Address in Srvc Contr Item - TP

R_SrvcContrItmPartnerAddressTP is a Transactional CDS View that provides data about "Partner Address in Srvc Contr Item - TP" in SAP S/4HANA. It reads from 2 data sources (I_ServiceDocumentItem, R_SrvcDocItemPartnerAddress) and exposes 42 fields with key fields ServiceContract, ServiceContractItem, CustMgmtPartnerFunction, CustMgmtBusinessPartner. It has 1 association to related views. Part of development package CRMS4_SERVICE_CONTRACT_RAP.

2 data source(s) 42 fields

Data Sources (2)

SourceAliasJoin Type
I_ServiceDocumentItem ServiceContractItem inner
R_SrvcDocItemPartnerAddress ServicePartnerAddress from

Associations (1)

CardinalityTargetAliasCondition
[0..1] R_ServiceContractTP _ServiceContractTP $projection.ServiceContract = _ServiceContractTP.ServiceContract

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 in Srvc Contr Item - TP view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY ServiceContract R_SrvcDocItemPartnerAddress ServiceDocument
KEY ServiceContractItem R_SrvcDocItemPartnerAddress ServiceDocumentItem
KEY CustMgmtPartnerFunction R_SrvcDocItemPartnerAddress CustMgmtPartnerFunction
KEY CustMgmtBusinessPartner R_SrvcDocItemPartnerAddress CustMgmtBusinessPartner
AddressID R_SrvcDocItemPartnerAddress AddressID
AddressPersonID R_SrvcDocItemPartnerAddress AddressPersonID
AddressObjectType R_SrvcDocItemPartnerAddress AddressObjectType
AddresseeFullName R_SrvcDocItemPartnerAddress AddresseeFullName
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
PhoneNumberCountry R_SrvcDocItemPartnerAddress PhoneNumberCountry
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
_SrvcContrItemPartnerTP _SrvcContrItemPartnerTP
_ServiceContractTP _ServiceContractTP 
@AccessControl: {
  authorizationCheck: #MANDATORY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@Metadata:
{
  ignorePropagatedAnnotations: true
}
@EndUserText.label: 'Partner Address in Srvc Contr Item - TP'
@ObjectModel: {
   usageType: {dataClass:      #TRANSACTIONAL,
                serviceQuality: #C,
                sizeCategory:   #L}
}

define view entity R_SrvcContrItmPartnerAddressTP
  as select from R_SrvcDocItemPartnerAddress as ServicePartnerAddress

    inner join   I_ServiceDocumentItem       as ServiceContractItem on  ServicePartnerAddress.ServiceDocument     = ServiceContractItem.ServiceDocument
                                                                    and ServicePartnerAddress.ServiceDocumentItem = ServiceContractItem.ServiceDocumentItem
                                                                    and ServiceContractItem.ServiceObjectType     = 'BUS2000112'
                                                                    and ServiceContractItem.ServiceDocumentTemplateType    is initial

  association        to parent R_SrvcContrItemPartnerTP as _SrvcContrItemPartnerTP on  $projection.ServiceContract         = _SrvcContrItemPartnerTP.ServiceContract
                                                                                   and $projection.ServiceContractItem     = _SrvcContrItemPartnerTP.ServiceContractItem
                                                                                   and $projection.CustMgmtPartnerFunction = _SrvcContrItemPartnerTP.CustMgmtPartnerFunction
                                                                                   and $projection.CustMgmtBusinessPartner = _SrvcContrItemPartnerTP.CustMgmtBusinessPartner
  association [0..1] to R_ServiceContractTP             as _ServiceContractTP      on  $projection.ServiceContract = _ServiceContractTP.ServiceContract

{
      @ObjectModel.foreignKey.association: '_ServiceContractTP'
  key ServicePartnerAddress.ServiceDocument     as ServiceContract,
  key ServicePartnerAddress.ServiceDocumentItem as ServiceContractItem,
  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

      _SrvcContrItemPartnerTP,
      _ServiceContractTP
}
where
      ServicePartnerAddress.CustMgmtObjectType  = 'BUS2000112'
  and ServicePartnerAddress.ServiceDocumentItem is not initial

Learn More