C_SalesOrderOverview

@AbapCatalog: { sqlViewName: 'CSLSORDOVP',
                compiler.compareFilter: true,
                preserveKey: true
              }

@AccessControl: { authorizationCheck: #CHECK,
                  personalData.blocking: #NOT_REQUIRED
                }
@VDM: {
  viewType: #CONSUMPTION
      }

@ObjectModel: { usageType.dataClass: #MIXED,
                usageType.serviceQuality: #C,
                usageType.sizeCategory: #L
              }

@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Additional Filters'

@Metadata:{ allowExtensions: true,
            ignorePropagatedAnnotations: true
          }

define view C_SalesOrderOverview
  with parameters
    @Consumption.valueHelpDefinition: [{ entity:{ name: 'C_CurrencyValueHelp', element: 'Currency' } }]
    P_DisplayCurrency : vdm_v_display_currency

  as select from I_SalesOrder

  //  association [0..1] to I_Customer               as _Customer               on  $projection.SoldToParty = _Customer.Customer


  association [0..1] to I_Customer_VH          as _SoldToParty         on  $projection.SoldToParty = _SoldToParty.Customer

  association [0..1] to C_Dischannelvaluehelp  as _DistributionChannel on  $projection.SalesOrganization   = _DistributionChannel.SalesOrganization
                                                                       and $projection.DistributionChannel = _DistributionChannel.DistributionChannel

  association [0..1] to C_OrgDivisionValueHelp as _Division            on  $projection.SalesOrganization    = _Division.SalesOrganization
                                                                       and $projection.DistributionChannel  = _Division.DistributionChannel
                                                                       and $projection.OrganizationDivision = _Division.Division

  //association [1..1] to C_SalesDocumentUserVH    as _CreatedByUser          on  $projection.CreatedByUser = _CreatedByUser.UserID


  association [0..1] to I_SalesOrganization    as _SalesOrganization   on  $projection.SalesOrganization = _SalesOrganization.SalesOrganization

  // association [0..1] to C_SalesDocumentUserVH    as _LastChangedByUser      on  $projection.LastChangedByUser = _LastChangedByUser.UserID


  //  association [0..1] to I_CustomerClassification as _CustomerClassification on  $projection.customerclassification = _CustomerClassification.CustomerClassification


  association [0..1] to C_SalesOfficeValueHelp as _SalesOffice         on  $projection.SalesOrganization    = _SalesOffice.SalesOrganization
                                                                       and $projection.DistributionChannel  = _SalesOffice.DistributionChannel
                                                                       and $projection.OrganizationDivision = _SalesOffice.OrganizationDivision
                                                                       and $projection.SalesOffice          = _SalesOffice.SalesOffice

  association [0..1] to C_SalesGroupValueHelp  as _SalesGroup          on  $projection.SalesOffice = _SalesGroup.SalesOffice
                                                                       and $projection.SalesGroup  = _SalesGroup.SalesGroup
{


  key SalesOrder,

      @Consumption.filter.mandatory: true
      SoldToParty,

      @ObjectModel.foreignKey.association: '_SalesOrganization'
      SalesOrganization,


      @Consumption.valueHelp: '_DistributionChannel'
      DistributionChannel,


      @Consumption.valueHelp: '_Division'
      OrganizationDivision,


      @Consumption.valueHelp: '_SalesOffice'
      SalesOffice,

      @Consumption.valueHelp: '_SalesGroup'
      SalesGroup,
      //commented as a part of UserStory:FXUBLR07-27, it could be added in the future release

      //      @EndUserText.label: 'Customer Classification'

      //      @Consumption.valueHelp: '_CustomerClassification'

      //

      //      _Customer.CustomerClassification,


      //      @Consumption.valueHelp: '_CreatedByUser'

      //      CreatedByUser,

      //

      //      @Consumption.valueHelp: '_LastChangedByUser'

      //      LastChangedByUser,


      /*Field added for DCL*/
      SalesOrderType,

      /*Associations*/
      //      @Consumption.filter.hidden: true

      //      _Customer,

      @Consumption.filter.hidden: true
      _SoldToParty,
      @Consumption.filter.hidden: true
      _DistributionChannel,
      @Consumption.filter.hidden: true
      _Division,
      @Consumption.filter.hidden: true
      _SalesOffice,
      @Consumption.filter.hidden: true
      _SalesGroup,
      //      @Consumption.filter.hidden: true

      //      _CustomerClassification,

      //      @Consumption.filter.hidden: true

      //      _CreatedByUser,

      //      @Consumption.filter.hidden: true

      //      _LastChangedByUser,

      @Consumption.filter.hidden: true
      _SalesOrganization

}
where
  SalesOrderProcessingType <> 'P'