Which tables does R_SalesOrderPartnerTP use?

R_SalesOrderPartnerTP reads from 1 data source(s): I_SalesOrderPartner.

How many fields does R_SalesOrderPartnerTP have?

R_SalesOrderPartnerTP has 55 fields. Key fields: SalesOrder, PartnerFunction.

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)

Source	Alias	Join Type
I_SalesOrderPartner	SalesOrderPartner	from

Associations (4)

Cardinality	Target	Alias	Condition
[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)

Name	Value	Level
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)

Key	Field	Source Table	Source Field
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
}

Depth:

R_SalesOrderPartnerTP view_entity

I_SalesOrderPartner view