I_MM_SalesOrderValueHelp

DDL: I_MM_SALESORDERVALUEHELP SQL: IMMSLSORD_VH Type: view COMPOSITE

Sales Order Value Help

I_MM_SalesOrderValueHelp is a Composite CDS View that provides data about "Sales Order Value Help" in SAP S/4HANA. It reads from 1 data source (I_SalesDocument) and exposes 8 fields with key field SalesOrder.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_SalesDocument SalesOrder from

Annotations (15)

NameValueLevelField
VDM.viewType #COMPOSITE view
EndUserText.label Sales Order Value Help view
AbapCatalog.sqlViewName IMMSLSORD_VH view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.representativeKey SalesOrder view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.preserveKey true view
ObjectModel.dataCategory #VALUE_HELP view
Consumption.ranked true view
Search.searchable true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder I_SalesDocument SalesDocument
CreatedByUser I_SalesDocument CreatedByUser
ValidityStartDate I_SalesDocument AgrmtValdtyStartDate
ValidityEndDate I_SalesDocument AgrmtValdtyEndDate
SalesOrganization I_SalesDocument SalesOrganization
SalesDocumentType I_SalesDocument SalesDocumentType
OrganizationDivision I_SalesDocument OrganizationDivision
DistributionChannel I_SalesDocument DistributionChannel 
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Sales Order Value Help'

@AbapCatalog.sqlViewName: 'IMMSLSORD_VH'
@AbapCatalog.compiler.compareFilter: true

@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.representativeKey: 'SalesOrder'

@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AbapCatalog.preserveKey:true 
@ObjectModel.dataCategory: #VALUE_HELP
@Consumption.ranked: true

@Search.searchable: true
//Required fields( Agreement Start And End Dates) not available in I_SalesOrder, hence we are selecting from I_SalesDocument with category 'C -> Sales Order'

define view I_MM_SalesOrderValueHelp
  as select from I_SalesDocument as SalesOrder
{

      @Search: { defaultSearchElement: true, ranking: #HIGH }
  key SalesOrder.SalesDocument        as SalesOrder,

      @Search: { defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8 }
      SalesOrder.CreatedByUser        as CreatedByUser,

      @Search: { defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8 }
      SalesOrder.AgrmtValdtyStartDate as ValidityStartDate,

      @Search: { defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8 }
      SalesOrder.AgrmtValdtyEndDate as ValidityEndDate,       // 2920169


      @Search: { defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8 }
      SalesOrder.SalesOrganization    as SalesOrganization,

      @Search: { defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8 }
      SalesOrder.SalesDocumentType    as SalesDocumentType,
      
      @Consumption.hidden: true
      @UI.hidden: true
      SalesOrder.OrganizationDivision   as OrganizationDivision,
       
      @Consumption.hidden: true
      @UI.hidden: true
      SalesOrder.DistributionChannel   as  DistributionChannel
      
      
}
where
  SalesOrder.SDDocumentCategory = 'C';

Learn More