C_ReturnsReferenceSalesOrder

DDL: C_RETURNSREFERENCESALESORDER Type: view_entity CONSUMPTION Package: ODATA_SD_RETURN_V2

Returns Reference Sales Order

C_ReturnsReferenceSalesOrder is a Consumption CDS View that provides data about "Returns Reference Sales Order" in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentBasic) and exposes 11 fields with key field SalesOrder. It has 1 association to related views. It is exposed through 1 OData service (UI_CUSTOMERRETURNMANAGE). Part of development package ODATA_SD_RETURN_V2.

1 data source(s) Exposed by 1 service(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentBasic ReferenceDocument from

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_RetsReferenceSalesOrderItem _ReferenceDocumentItem $projection.SalesOrder = _ReferenceDocumentItem.ReferenceDocument

Annotations (10)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.modelingPattern #NONE view
Search.searchable true view
EndUserText.label Returns Reference Sales Order view

OData Services (1)

ServiceBindingVersionContractRelease
UI_CUSTOMERRETURNMANAGE UI_CUSTOMERRETURNMANAGE V4 C1 NOT_RELEASED

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder
SalesDocumentType I_SalesDocumentBasic SalesDocumentType
SoldToParty I_SalesDocumentBasic SoldToParty
SoldToPartyName
TotalNetAmount I_SalesDocumentBasic TotalNetAmount
TransactionCurrency I_SalesDocumentBasic TransactionCurrency
SDDocumentCategory I_SalesDocumentBasic SDDocumentCategory
SalesOrganization I_SalesDocumentBasic SalesOrganization
DistributionChannel I_SalesDocumentBasic DistributionChannel
OrganizationDivision I_SalesDocumentBasic OrganizationDivision
_ReferenceDocumentItem _ReferenceDocumentItem 
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@Metadata: {
  allowExtensions: true,
  ignorePropagatedAnnotations: true
}
@ObjectModel: {
   semanticKey: ['SalesOrder'],
  usageType: {
    dataClass:      #MIXED,
    serviceQuality: #C,
    sizeCategory:   #XL
  },
  supportedCapabilities: [ #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ],
  modelingPattern: #NONE
}
@Search.searchable: true
@EndUserText.label: 'Returns Reference Sales Order'
define view entity C_ReturnsReferenceSalesOrder
as select from I_SalesDocumentBasic as ReferenceDocument
   association [0..*] to C_RetsReferenceSalesOrderItem as _ReferenceDocumentItem  on $projection.SalesOrder  = _ReferenceDocumentItem.ReferenceDocument

{
      @Search.defaultSearchElement: true
  key cast(ReferenceDocument.SalesDocument as vdm_sales_order preserving type) as SalesOrder,

      ReferenceDocument.SalesDocumentType,
      //Sold-To Party

      @ObjectModel.text.element: [ 'SoldToPartyName' ]
      ReferenceDocument.SoldToParty,
      @Semantics.text: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_SD_SLSORD_UI_PARTNER_UTIL'
      cast('' as ad_namtext) as SoldToPartyName,

      //Total Amount

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      ReferenceDocument.TotalNetAmount,
      ReferenceDocument.TransactionCurrency,

      ReferenceDocument.SDDocumentCategory,

      // ACL

      @Consumption.hidden:true
      ReferenceDocument.SalesOrganization,
      @Consumption.hidden:true
      ReferenceDocument.DistributionChannel,
      @Consumption.hidden:true
      ReferenceDocument.OrganizationDivision,

      // Association

      _ReferenceDocumentItem
}
where
ReferenceDocument.SDDocumentCategory = 'C'

Learn More