I_SalesOrderRequestPartner

DDL: I_SALESORDERREQUESTPARTNER Type: view_entity BASIC Package: VDM_SD_SLS_SOR

Sales Order Request Partner

I_SalesOrderRequestPartner is a Basic CDS View that provides data about "Sales Order Request Partner" in SAP S/4HANA. It reads from 1 data source (sdsls_sorprtn) and exposes 10 fields with key fields SalesOrderRequest, PartnerFunction. It has 1 association to related views. Part of development package VDM_SD_SLS_SOR.

Data Sources (1)

SourceAliasJoin Type
sdsls_sorprtn SalesOrderRequestPartnr from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_SalesOrderRequest _SalesOrderRequest $projection.SalesOrderRequest = _SalesOrderRequest.SalesOrderRequest

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Sales Order Request Partner view
ObjectModel.representativeKey SalesOrderRequest view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY SalesOrderRequest salesorderrequest
KEY PartnerFunction partnerfunction
Customer customer
ContactPerson contactperson
AddressID addressid
AddressPersonID addresspersonid
SDDocPartnerAddressRefType sddocpartneraddressreftype
BPRefAddressIDForDocSpcfcAddr bprefaddressidfordocspcfcaddr
AddressObjectType addressobjecttype
_SalesOrderRequest _SalesOrderRequest
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@EndUserText.label: 'Sales Order Request Partner'
@ObjectModel:{
  representativeKey: 'SalesOrderRequest',
  usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #L
   },
   supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
}

@VDM: {
  viewType: #BASIC
}

define view entity I_SalesOrderRequestPartner
  as select from sdsls_sorprtn as SalesOrderRequestPartnr
  association [0..1] to I_SalesOrderRequest as _SalesOrderRequest on $projection.SalesOrderRequest = _SalesOrderRequest.SalesOrderRequest
{
  key salesorderrequest             as SalesOrderRequest,
  key partnerfunction               as PartnerFunction,
      customer                      as Customer,
      contactperson                 as ContactPerson,
      addressid                     as AddressID,
      addresspersonid               as AddressPersonID,
      sddocpartneraddressreftype    as SDDocPartnerAddressRefType,
      bprefaddressidfordocspcfcaddr as BPRefAddressIDForDocSpcfcAddr,
      addressobjecttype   as AddressObjectType,

      _SalesOrderRequest

}
where salesorderrequestitem is initial