R_CustomerMaterialDraft

@VDM.viewType:#BASIC
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Customer Material - Draft'
@AbapCatalog.dataMaintenance: #RESTRICTED
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #S,
  dataClass: #TRANSACTIONAL
}
@AbapCatalog.extensibility: {
  extensible: true,
  dataSources: ['_Extension'],
  elementSuffix: 'CMR',
  quota: {
    maximumFields: 170,
    maximumBytes: 3400
  }
}

define view entity R_CustomerMaterialDraft
  as select from sdcustmat_d as CustomerMaterialDraft
  inner join sdraft_admin on sdraft_admin.draft_key = CustomerMaterialDraft.draftadministrativedatauuid
  association [0..1] to I_Customer         as _Customer  on  $projection.Customer = _Customer.Customer
  //Extensibility

  association [0..1] to E_CustomerMaterialDraft as _Extension on  $projection.Product        = _Extension.Material
                                                         and $projection.Customer            = _Extension.Customer
                                                         and $projection.SalesOrganization   = _Extension.SalesOrganization
                                                         and $projection.DistributionChannel = _Extension.DistributionChannel
                                                         and $projection.DraftUUID           = _Extension.DraftUUID
{
  key CustomerMaterialDraft.salesorganization              as SalesOrganization,
  key CustomerMaterialDraft.distributionchannel            as DistributionChannel,
  key CustomerMaterialDraft.product                        as Product,
  key CustomerMaterialDraft.customer                       as Customer,
  key CustomerMaterialDraft.draftuuid                      as DraftUUID,
      @ObjectModel.editableFieldFor: 'SalesOrganization'
      CustomerMaterialDraft.salesorganizationforedit       as SalesOrganizationForEdit,
      @ObjectModel.editableFieldFor: 'DistributionChannel'
      CustomerMaterialDraft.distributionchannelforedit     as DistributionChannelForEdit,
      @ObjectModel.editableFieldFor: 'Customer'
      CustomerMaterialDraft.customerforedit                as CustomerForEdit,
      @ObjectModel.editableFieldFor: 'Product'
      CustomerMaterialDraft.productforedit                 as ProductForEdit,
      CustomerMaterialDraft.materialbycustomer             as MaterialByCustomer,
      CustomerMaterialDraft.materialdescriptionbycustomer  as MaterialDescriptionByCustomer,
      CustomerMaterialDraft.customermaterialsearchterm     as CustomerMaterialSearchTerm,
      CustomerMaterialDraft.roundingprofile                as RoundingProfile,
      CustomerMaterialDraft.plant                          as Plant,
      CustomerMaterialDraft.deliverypriority               as DeliveryPriority,
      @Semantics.quantity.unitOfMeasure : 'baseunit'
      CustomerMaterialDraft.mindeliveryqtyinbaseunit       as MinDeliveryQtyInBaseUnit,
      CustomerMaterialDraft.baseunit                       as BaseUnit,
      CustomerMaterialDraft.partialdeliveryisallowed       as PartialDeliveryIsAllowed,
      CustomerMaterialDraft.maxnmbrofpartialdelivery       as MaxNmbrOfPartialDelivery,
      CustomerMaterialDraft.underdelivtolrtdlmtratioinpct  as UnderdelivTolrtdLmtRatioInPct,
      CustomerMaterialDraft.overdelivtolrtdlmtratioinpct   as OverdelivTolrtdLmtRatioInPct,
      CustomerMaterialDraft.unlimitedoverdeliveryisallowed as UnlimitedOverdeliveryIsAllowed,
      CustomerMaterialDraft.customermaterialitemusage      as CustomerMaterialItemUsage,
      CustomerMaterialDraft.salesunit                      as SalesUnit,
      CustomerMaterialDraft.salesqtytobaseqtydnmntr        as SalesQtyToBaseQtyDnmntr,
      CustomerMaterialDraft.salesqtytobaseqtynmrtr         as SalesQtyToBaseQtyNmrtr,
      CustomerMaterialDraft.lastchangedbyuser              as LastChangedByUser,
      CustomerMaterialDraft.lastchangedatetime             as LastChangeDateTime,
      CustomerMaterialDraft.draftentitycreationdatetime    as DraftEntityCreationDateTime,
      CustomerMaterialDraft.draftentitylastchangedatetime  as DraftEntityLastChangeDateTime,
      CustomerMaterialDraft.draftadministrativedatauuid    as DraftAdministrativeDataUUID,
      CustomerMaterialDraft.draftentityoperationcode       as DraftEntityOperationCode,
      CustomerMaterialDraft.hasactiveentity                as HasActiveEntity,
      CustomerMaterialDraft.draftfieldchanges              as DraftFieldChanges,
      // for DCL

      _Customer
}
where sdraft_admin.created_by = $session.user