R_SrvcOrdPartnerAddressTP

DDL: R_SRVCORDPARTNERADDRESSTP Type: view_entity TRANSACTIONAL

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 1 data source (I_SrvcDocPartnerAddress) and exposes 36 fields with key fields ServiceOrder, 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_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 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
_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
  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 ServiceDocument as ServiceOrder,
  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

      _SrvcOrdPartnerTP,
      _ServiceOrderTP
}
where
      CustMgmtObjectType  = 'BUS2000116'
  and ServiceDocumentItem is initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SRVCDOCPARTNERADDRESS"
],
"ASSOCIATED":
[
"R_SERVICEORDERTP",
"R_SRVCORDPARTNERTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/