C_CustRetRefDocSrlNmbr

DDL: C_CUSTRETREFDOCSRLNMBR Type: view_entity CONSUMPTION

Returns Order Reference Document Serial Number

C_CustRetRefDocSrlNmbr is a Consumption CDS View that provides data about "Returns Order Reference Document Serial Number" in SAP S/4HANA. It reads from 4 data sources (I_SerialNmbrDelivery, I_MaintenanceItemObject, I_MaintenanceItemObject, I_SerialNmbrSalesOrder) and exposes 14 fields with key fields SerialNumber, ReferenceSDDocument, ReferenceSDDocumentItem, ReferenceSDDocument.

4 data source(s) 14 fields

Data Sources (4)

SourceAliasJoin Type
I_SerialNmbrDelivery DeliverySerialNmbr inner
I_MaintenanceItemObject MaintenanceItemObject inner
I_MaintenanceItemObject MaintenanceItemObject inner
I_SerialNmbrSalesOrder SerialNumberSalesOrder from

Annotations (8)

NameValueLevelField
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Returns Order Reference Document Serial Number view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY SerialNumber I_MaintenanceItemObject SerialNumber
KEY ReferenceSDDocument
KEY ReferenceSDDocumentItem
Product
SDDocumentCategory I_SerialNmbrSalesOrder SDDocumentCategory
OrganizationDivision
SalesOrganization
SerialNumber
KEY ReferenceSDDocument
Product BillingItem Product
SDDocumentCategory BillingItem SDDocumentCategory
OrganizationDivision BillingItem OrganizationDivision
SalesOrganization BillingItem SalesOrganization
DistributionChannel BillingItem DistributionChannel 
@VDM: {
  viewType: #CONSUMPTION
}
@ObjectModel: {
  usageType: {
    dataClass: #MIXED,
    serviceQuality: #C,
    sizeCategory: #XL
   }
}
@Search: {
  searchable: true
}
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #CHECK 
@EndUserText.label: 'Returns Order Reference Document Serial Number'

define view entity C_CustRetRefDocSrlNmbr 
  as select from I_SerialNmbrSalesOrder  as SerialNumberSalesOrder

    inner join   I_MaintenanceItemObject as MaintenanceItemObject on SerialNumberSalesOrder.MaintenanceItemObjectList = MaintenanceItemObject.MaintenanceItemObjectList
                                                              
{
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      key MaintenanceItemObject.SerialNumber,
      
      key 
      cast(SerialNumberSalesOrder.SalesOrder as vgbel) as ReferenceSDDocument,
      
      key 
      cast(SerialNumberSalesOrder.SalesOrderItem as vgpos) as ReferenceSDDocumentItem,

      SerialNumberSalesOrder._SalesOrderItem.Product,
      @UI.hidden: true
      SerialNumberSalesOrder.SDDocumentCategory,
      @UI.hidden: true
      SerialNumberSalesOrder._SalesOrder.OrganizationDivision,
      @UI.hidden: true
      SerialNumberSalesOrder._SalesOrder.SalesOrganization,
      @UI.hidden: true
      SerialNumberSalesOrder._SalesOrder.DistributionChannel
      

}
union
  select distinct from I_BillingDocumentItemBasic  as BillingItem 
       //Associations

    inner join I_SerialNmbrDelivery           as DeliverySerialNmbr       on BillingItem.ReferenceSDDocument           = DeliverySerialNmbr.DeliveryDocument
                                                                         and BillingItem.ReferenceSDDocumentItem       = DeliverySerialNmbr.DeliveryDocumentItem
    inner join I_MaintenanceItemObject as MaintenanceItemObject  on DeliverySerialNmbr.MaintenanceItemObjectList = MaintenanceItemObject.MaintenanceItemObjectList
  {
      key MaintenanceItemObject.SerialNumber,
      
      key 
      cast(BillingItem.BillingDocument as vgbel) as ReferenceSDDocument,  
      
      key 
      cast(BillingItem.BillingDocumentItem as vgpos)as ReferenceSDDocumentItem,
      
      BillingItem.Product,

      BillingItem.SDDocumentCategory,
    
      BillingItem.OrganizationDivision,

      BillingItem.SalesOrganization,

      BillingItem.DistributionChannel
      
  }

Learn More