R_SalesOrderPartnerTP

DDL: R_SALESORDERPARTNERTP Type: view_entity TRANSACTIONAL

Sales Order Partner - TP

R_SalesOrderPartnerTP is a Transactional CDS View that provides data about "Sales Order Partner - TP" in SAP S/4HANA. It reads from 1 data source (I_SalesOrderPartner) and exposes 55 fields with key fields SalesOrder, PartnerFunction. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SalesOrderPartner SalesOrderPartner from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_PartnerFunction _PartnerFunction $projection.PartnerFunctionForEdit = _PartnerFunction.PartnerFunction
[0..1] I_Language _CorrespondenceLanguage $projection.CorrespondenceLanguage = _CorrespondenceLanguage.Language
[0..1] I_FormOfAddress _FormOfAddress $projection.FormOfAddress = _FormOfAddress.FormOfAddress
[0..1] I_TransportationZone _TransportationZone $projection.transportzone = _TransportationZone.TransportZone and $projection.country = _TransportationZone.CountryCode

Annotations (8)

NameValueLevelField
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Sales Order Partner - TP view

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder SalesOrder
KEY PartnerFunction
PartnerFunctionForEdit
Customer I_SalesOrderPartner Customer
Supplier I_SalesOrderPartner Supplier
Personnel I_SalesOrderPartner Personnel
ContactPerson I_SalesOrderPartner ContactPerson
ReferenceBusinessPartner I_SalesOrderPartner ReferenceBusinessPartner
Partner I_SalesOrderPartner Partner
FullName I_SalesOrderPartner FullName
SDDocumentPartnerType _PartnerFunction SDDocumentPartnerType
FormOfAddress I_SalesOrderPartner FormOfAddress
PostalCode
CityName
DistrictName
Country
Region
StreetName
StreetPrefixName1
StreetPrefixName2
StreetSuffixName1
StreetSuffixName2
HouseNumber
InternationalPhoneNumber I_SalesOrderPartner InternationalPhoneNumber
InternationalMobilePhoneNumber I_SalesOrderPartner InternationalMobilePhoneNumber
EmailAddress I_SalesOrderPartner EmailAddress
InternationalFaxNumber I_SalesOrderPartner InternationalFaxNumber
POBox
POBoxPostalCode
CorrespondenceLanguage I_SalesOrderPartner CorrespondenceLanguage
TaxJurisdiction
TransportZone
UnloadingPointName I_SalesOrderPartner UnloadingPointName
VATRegistration I_SalesOrderPartner VATRegistration
AddressID I_SalesOrderPartner AddressID
SDDocPartnerAddrIsDocSpecific I_SalesOrderPartner SDDocPartnerAddrIsDocSpecific
AddressPersonID I_SalesOrderPartner AddressPersonID
AddressObjectType I_SalesOrderPartner AddressObjectType
SDDocPartnerAddressRefType I_SalesOrderPartner SDDocPartnerAddressRefType
BPAddrDeterminationTransaction I_SalesOrderPartner BPAddrDeterminationTransaction
BPRefAddressIDForDocSpcfcAddr I_SalesOrderPartner BPRefAddressIDForDocSpcfcAddr
SalesOrderType _SalesOrder SalesOrderType
SalesOrganization _SalesOrder SalesOrganization
DistributionChannel _SalesOrder DistributionChannel
OrganizationDivision _SalesOrder OrganizationDivision
_SalesOrder _SalesOrder
_PartnerFunction _PartnerFunction
_CorrespondenceLanguage _CorrespondenceLanguage
_FormOfAddress _FormOfAddress
_TransportationZone _TransportationZone
_DfltAddrRprstn I_SalesOrderPartner _DfltAddrRprstn
_BusinessPartnerAddress I_SalesOrderPartner _BusinessPartnerAddress
_BPRefAddressForDocSpcfcAddr I_SalesOrderPartner _BPRefAddressForDocSpcfcAddr
_Country
_Region
@VDM: {
  lifecycle.contract.type: #SAP_INTERNAL_API,
  viewType: #TRANSACTIONAL
}

@AccessControl: { 
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA'),
  privilegedAssociations: [ '_DfltAddrRprstn' ]
}

@ObjectModel: {
    usageType: {
        dataClass: #TRANSACTIONAL,
        serviceQuality: #C,
        sizeCategory: #L
    }
}

@ObjectModel.semanticKey: ['SalesOrder', 'PartnerFunction']

@Metadata.ignorePropagatedAnnotations: true

@EndUserText.label: 'Sales Order Partner - TP'
define view entity R_SalesOrderPartnerTP 
  as select from I_SalesOrderPartner as SalesOrderPartner
 
   association        to parent R_SalesOrderTP   as _SalesOrder             on $projection.SalesOrder = _SalesOrder.SalesOrder
   
   association [0..1] to I_PartnerFunction       as _PartnerFunction        on $projection.PartnerFunctionForEdit = _PartnerFunction.PartnerFunction
   
   association [0..1] to I_Language              as _CorrespondenceLanguage on $projection.CorrespondenceLanguage = _CorrespondenceLanguage.Language
   
   association [0..1] to I_FormOfAddress         as _FormOfAddress          on  $projection.FormOfAddress = _FormOfAddress.FormOfAddress

   association [0..1] to I_TransportationZone    as _TransportationZone     on  $projection.transportzone = _TransportationZone.TransportZone
                                                                            and $projection.country       = _TransportationZone.CountryCode
{

  key  SalesOrder,
  
  key cast(SalesOrderPartner.PartnerFunction as parvw_unv preserving type )         as PartnerFunction,
  
      @ObjectModel.foreignKey.association: '_PartnerFunction'
      cast(SalesOrderPartner.PartnerFunction as parvw_unv preserving type )         as PartnerFunctionForEdit,
  
      SalesOrderPartner.Customer,

      SalesOrderPartner.Supplier,
      
      SalesOrderPartner.Personnel,
      
      SalesOrderPartner.ContactPerson,
      
      SalesOrderPartner.ReferenceBusinessPartner,
      
      @ObjectModel.text.element: ['FullName']
      SalesOrderPartner.Partner,
      
      @Semantics.name.fullName: true
      @Semantics.text: true
      SalesOrderPartner.FullName,
      
      _PartnerFunction.SDDocumentPartnerType,
      
      @ObjectModel.foreignKey.association: '_FormOfAddress'
      @Semantics.name.jobTitle: true
      SalesOrderPartner.FormOfAddress,     

      @Semantics.address.zipCode:true
      SalesOrderPartner._OrgNamePostalAddress.PostalCode,

      @Semantics.address.city:true
      SalesOrderPartner._OrgNamePostalAddress.CityName,

      SalesOrderPartner._OrgNamePostalAddress.DistrictName,    
       
      @Semantics.address.country:true
      @ObjectModel.foreignKey.association: '_Country'
      SalesOrderPartner._OrgNamePostalAddress.Country,

      @ObjectModel.foreignKey.association: '_Region'
      @Semantics.address.region: true
      SalesOrderPartner._OrgNamePostalAddress.Region,

      @Semantics.address.street: true
      SalesOrderPartner._OrgNamePostalAddress.StreetName,

      @Semantics.address.street: true
      SalesOrderPartner._OrgNamePostalAddress.StreetPrefixName1,

      @Semantics.address.street: true
      SalesOrderPartner._OrgNamePostalAddress.StreetPrefixName2,

      @Semantics.address.street: true
      SalesOrderPartner._OrgNamePostalAddress.StreetSuffixName1,

      @Semantics.address.street: true
      SalesOrderPartner._OrgNamePostalAddress.StreetSuffixName2,

      @Semantics.address.streetNoNumber: true
      SalesOrderPartner._OrgNamePostalAddress.HouseNumber,

      @Semantics.telephone.type: [#WORK]
      SalesOrderPartner.InternationalPhoneNumber,

      @Semantics.telephone.type:  [#CELL]
      SalesOrderPartner.InternationalMobilePhoneNumber,

      @Semantics.eMail.address: true
      @Semantics.eMail.type:  [#WORK]
      SalesOrderPartner.EmailAddress,

      @Semantics.telephone.type: [#FAX]
      SalesOrderPartner.InternationalFaxNumber,

      @Semantics.address.postBox: true
      SalesOrderPartner._OrgNamePostalAddress.POBox,

      @Semantics.address.zipCode:true
      SalesOrderPartner._OrgNamePostalAddress.POBoxPostalCode,

      @ObjectModel.foreignKey.association: '_CorrespondenceLanguage'
      SalesOrderPartner.CorrespondenceLanguage,

      SalesOrderPartner._OrgNamePostalAddress.TaxJurisdiction,

      @ObjectModel.foreignKey.association: '_TransportationZone'
      SalesOrderPartner._OrgNamePostalAddress.TransportZone,

      @Semantics.text: true
      SalesOrderPartner.UnloadingPointName,

      SalesOrderPartner.VATRegistration,
      
      SalesOrderPartner.AddressID,
      
      SalesOrderPartner.SDDocPartnerAddrIsDocSpecific,

      SalesOrderPartner.AddressPersonID,

      SalesOrderPartner.AddressObjectType,
            
//    On Conditions For Associations

      @Consumption.hidden: true
      SalesOrderPartner.SDDocPartnerAddressRefType,
      @Consumption.hidden: true
      SalesOrderPartner.BPAddrDeterminationTransaction,
      @Consumption.hidden: true
      SalesOrderPartner.BPRefAddressIDForDocSpcfcAddr,

//    DCL

      @Consumption.hidden: true
      _SalesOrder.SalesOrderType,
      @Consumption.hidden: true
      _SalesOrder.SalesOrganization,
      @Consumption.hidden: true
      _SalesOrder.DistributionChannel,
      @Consumption.hidden: true
      _SalesOrder.OrganizationDivision,

//    Associations      

      _SalesOrder,
      _PartnerFunction,
      _CorrespondenceLanguage,
      _FormOfAddress,
      _TransportationZone,
      
      SalesOrderPartner._DfltAddrRprstn,
      SalesOrderPartner._BusinessPartnerAddress, 
      SalesOrderPartner._BPRefAddressForDocSpcfcAddr,
      SalesOrderPartner._OrgNamePostalAddress._Country,
      SalesOrderPartner._OrgNamePostalAddress._Region
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRORGNAMEPOSTALADDRESS",
"I_PARTNERFUNCTION",
"I_SALESORDERPARTNER",
"R_SALESORDERTP"
],
"ASSOCIATED":
[
"I_ADDRESS_2",
"I_BUSPARTADDRESS",
"I_COUNTRY",
"I_FORMOFADDRESS",
"I_LANGUAGE",
"I_PARTNERFUNCTION",
"I_REGION",
"I_TRANSPORTATIONZONE",
"R_SALESORDERTP"
],
"BASE":
[
"I_ADDRORGNAMEPOSTALADDRESS",
"I_SALESORDERPARTNER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/