R_SrvcConfPartnerAddressTP

DDL: R_SRVCCONFPARTNERADDRESSTP Type: view_entity TRANSACTIONAL

Partner Address For Service Confirmation

R_SrvcConfPartnerAddressTP is a Transactional CDS View that provides data about "Partner Address For Service Confirmation" in SAP S/4HANA. It reads from 1 data source (I_SrvcDocPartnerAddress) and exposes 36 fields with key fields ServiceConfirmation, CustMgmtPartnerFunction, CustMgmtBusinessPartner. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_SrvcDocPartnerAddress I_SrvcDocPartnerAddress from

Associations (1)

CardinalityTargetAliasCondition
[0..1] R_ServiceConfirmationTP _ServiceConfirmationTP $projection.ServiceConfirmation = _ServiceConfirmationTP.ServiceConfirmation

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 Confirmation view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY ServiceConfirmation ServiceDocument
KEY CustMgmtPartnerFunction CustMgmtPartnerFunction
KEY CustMgmtBusinessPartner CustMgmtBusinessPartner
CityName CityName
CorrespondenceLanguage CorrespondenceLanguage
Country Country
DistrictName DistrictName
EmailAddress EmailAddress
FaxAreaCodeSubscriberNumber FaxAreaCodeSubscriberNumber
FaxExtensionNumber FaxExtensionNumber
FaxNumberCountry FaxNumberCountry
FormOfAddress FormOfAddress
HouseNumber HouseNumber
MobileNumber MobileNumber
MobilePhoneCountry MobilePhoneCountry
OrganizationName1 OrganizationName1
OrganizationName2 OrganizationName2
OrganizationName3 OrganizationName3
OrganizationName4 OrganizationName4
PersonFamilyName PersonFamilyName
PersonGivenName PersonGivenName
PhoneExtensionNumber PhoneExtensionNumber
PhoneNumber PhoneNumber
POBox POBox
POBoxPostalCode POBoxPostalCode
PostalCode PostalCode
Region Region
StreetName StreetName
StreetPrefixName1 StreetPrefixName1
StreetPrefixName2 StreetPrefixName2
StreetSuffixName1 StreetSuffixName1
StreetSuffixName2 StreetSuffixName2
TaxJurisdiction TaxJurisdiction
TransportZone TransportZone
_SrvcConfPartnerTP _SrvcConfPartnerTP
_ServiceConfirmationTP _ServiceConfirmationTP
@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 Confirmation'
@ObjectModel: {
   usageType: {dataClass:      #TRANSACTIONAL,
                serviceQuality: #C,
                sizeCategory:   #L}
}
define view entity R_SrvcConfPartnerAddressTP
  as select from I_SrvcDocPartnerAddress
  association        to parent R_SrvcConfPartnerTP as _SrvcConfPartnerTP     on  $projection.ServiceConfirmation     = _SrvcConfPartnerTP.ServiceConfirmation
                                                                             and $projection.CustMgmtPartnerFunction = _SrvcConfPartnerTP.CustMgmtPartnerFunction
                                                                             and $projection.CustMgmtBusinessPartner = _SrvcConfPartnerTP.CustMgmtBusinessPartner
  association [0..1] to R_ServiceConfirmationTP    as _ServiceConfirmationTP on  $projection.ServiceConfirmation = _ServiceConfirmationTP.ServiceConfirmation

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

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

      //Associations

      _SrvcConfPartnerTP,
      _ServiceConfirmationTP
}
where
      CustMgmtObjectType  = 'BUS2000117'
  and ServiceDocumentItem is initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SRVCDOCPARTNERADDRESS"
],
"ASSOCIATED":
[
"R_SERVICECONFIRMATIONTP",
"R_SRVCCONFPARTNERTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/