C_CustomerReturnRefDoc

DDL: C_CUSTOMERRETURNREFDOC Type: view CONSUMPTION

Return Reference Document

C_CustomerReturnRefDoc is a Consumption CDS View that provides data about "Return Reference Document" in SAP S/4HANA. It reads from 1 data source (I_CustomerReturnItem) and exposes 13 fields with key fields CustomerReturn, ReferenceSDDocument, ReferenceSDDocument.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_CustomerReturnItem CustomerReturnItem inner

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Return Reference Document view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.sqlViewName CSDCUSTRETREFDOC view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ObjectModel.compositionRoot true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY CustomerReturn CustomerReturn CustomerReturn
KEY ReferenceSDDocument CustomerReturn ReferenceSDDocument
ReferenceSDDocumentCategory CustomerReturn ReferenceSDDocumentCategory
CustomerReturnType CustomerReturn CustomerReturnType
OrganizationDivision CustomerReturn OrganizationDivision
SalesOrganization CustomerReturn SalesOrganization
CustomerReturn
KEY ReferenceSDDocument I_CustomerReturnItem ReferenceSDDocument
ReferenceSDDocumentCategory I_CustomerReturnItem ReferenceSDDocumentCategory
CustomerReturnType CustomerReturn CustomerReturnType
OrganizationDivision CustomerReturn OrganizationDivision
SalesOrganization CustomerReturn SalesOrganization
DistributionChannel CustomerReturn DistributionChannel 
@ClientHandling.algorithm:#SESSION_VARIABLE
@EndUserText.label: 'Return Reference Document'
@VDM.viewType: #CONSUMPTION
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #NOT_REQUIRED
}
@AbapCatalog: {
  sqlViewName: 'CSDCUSTRETREFDOC',
  preserveKey: true,
  compiler.compareFilter: true
}
@ObjectModel: {
   compositionRoot: true,
   semanticKey: ['CustomerReturn'],
   usageType: {
     dataClass:      #MIXED,
     serviceQuality: #D,
     sizeCategory:   #XL
   }
}

define view C_CustomerReturnRefDoc
as select distinct from I_CustomerReturn as CustomerReturn
{
      @Consumption.semanticObject: 'CustomerReturn'
  key CustomerReturn.CustomerReturn,
  key CustomerReturn.ReferenceSDDocument,
      CustomerReturn.ReferenceSDDocumentCategory,
      @UI.hidden: true
      CustomerReturn.CustomerReturnType,
      @UI.hidden: true
      CustomerReturn.OrganizationDivision,
      @UI.hidden: true
      CustomerReturn.SalesOrganization,
      @UI.hidden: true
      CustomerReturn.DistributionChannel
}
where
  CustomerReturn.ReferenceSDDocument is not initial

union all

select distinct from I_CustomerReturn as CustomerReturn
inner join I_CustomerReturnItem as CustomerReturnItem on CustomerReturn.CustomerReturn = CustomerReturnItem.CustomerReturn

{

      @Consumption.semanticObject: 'CustomerReturn'
  key CustomerReturn.CustomerReturn,
  key CustomerReturnItem.ReferenceSDDocument,
      CustomerReturnItem.ReferenceSDDocumentCategory,
      @UI.hidden: true
      CustomerReturn.CustomerReturnType,
      @UI.hidden: true
      CustomerReturn.OrganizationDivision,
      @UI.hidden: true
      CustomerReturn.SalesOrganization,
      @UI.hidden: true
      CustomerReturn.DistributionChannel
}
where
      CustomerReturnItem.ReferenceSDDocument <> CustomerReturn.ReferenceSDDocument
  and CustomerReturnItem.ReferenceSDDocument is not initial

Learn More