C_RetsRefDocItemAttribute

DDL: C_RETSREFDOCITEMATTRIBUTE Type: view_entity CONSUMPTION

Returns Document Item Attribute Search

C_RetsRefDocItemAttribute is a Consumption CDS View that provides data about "Returns Document Item Attribute Search" in SAP S/4HANA. It reads from 2 data sources (I_BillingDocumentItem, I_SalesDocumentItem) and exposes 13 fields with key fields ReferenceDocument, ReferenceDocumentItem, ReferenceDocumentItem.

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
I_BillingDocumentItem I_BillingDocumentItem union_all
I_SalesDocumentItem I_SalesDocumentItem from

Annotations (7)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Returns Document Item Attribute Search view
Metadata.ignorePropagatedAnnotations true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ReferenceDocument I_SalesDocumentItem SalesDocument
KEY ReferenceDocumentItem I_SalesDocumentItem SalesDocumentItem
Material
SDDocumentCategory I_SalesDocumentItem SDDocumentCategory
SalesOrganization I_SalesDocumentItem SalesOrganization
DistributionChannel I_SalesDocumentItem DistributionChannel
BillingDocumentasReferenceDocument
KEY ReferenceDocumentItem I_BillingDocumentItem BillingDocumentItem
Material
SDDocumentCategory I_BillingDocumentItem SDDocumentCategory
SalesOrganization I_BillingDocumentItem SalesOrganization
DistributionChannel I_BillingDocumentItem DistributionChannel
OrganizationDivision I_BillingDocumentItem OrganizationDivision 
@VDM.viewType: #CONSUMPTION
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel: {
  semanticKey: ['ReferenceDocument'],
  usageType: {
    dataClass:      #TRANSACTIONAL,
    serviceQuality: #C,
    sizeCategory:   #XL
  }
}
@EndUserText.label: 'Returns Document Item Attribute Search'
@Metadata.ignorePropagatedAnnotations: true
@Search.searchable

define view entity C_RetsRefDocItemAttribute
  as select from I_SalesDocumentItem
{

      //Key

  key I_SalesDocumentItem.SalesDocument                                    as ReferenceDocument,
  key I_SalesDocumentItem.SalesDocumentItem                                as ReferenceDocumentItem,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 1
      cast(I_SalesDocumentItem.Material as productnumber preserving type ) as Material,

      @Consumption.hidden: true
      I_SalesDocumentItem.SDDocumentCategory,
      @Consumption.hidden: true
      I_SalesDocumentItem.SalesOrganization,
      @Consumption.hidden: true
      I_SalesDocumentItem.DistributionChannel,
      @Consumption.hidden: true
      I_SalesDocumentItem.OrganizationDivision
}
where
     I_SalesDocumentItem.SDDocumentCategory = 'C'
  or I_SalesDocumentItem.SDDocumentCategory = 'I'

union all

select from I_BillingDocumentItem
{
      //Key

  key I_BillingDocumentItem.BillingDocument                                  as ReferenceDocument,
  key I_BillingDocumentItem.BillingDocumentItem                              as ReferenceDocumentItem,

      cast(I_BillingDocumentItem.Material as productnumber preserving type ) as Material,

      I_BillingDocumentItem.SDDocumentCategory,
      I_BillingDocumentItem.SalesOrganization,
      I_BillingDocumentItem.DistributionChannel,
      I_BillingDocumentItem.OrganizationDivision
}
where
  I_BillingDocumentItem.SDDocumentCategory = 'M'

Learn More