I_ExciseDueDocBase

@EndUserText.label: 'Excise Duelist Base'
@AbapCatalog.sqlViewName: 'ISDEXDUEDOCBS'
//@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE

@ObjectModel.usageType.serviceQuality:#D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED

define view I_ExciseDueDocBase
  as select from    I_BillingDocument
    left outer join I_ExciseRevDoc  on I_BillingDocument.BillingDocument = I_ExciseRevDoc.ExciseRefDoc1
    left outer join P_SdPricingPrcd on P_SdPricingPrcd.DeliveryDocument = I_BillingDocument.BillingDocument
  association [1..1] to I_ExciseSeriesGrpDetrmn      as _ExciseSeriesGrpDtmn on  (
      $projection.SalesOrganization       = _ExciseSeriesGrpDtmn.SalesOrganization
      and $projection.DistributionChannel = _ExciseSeriesGrpDtmn.DistributionChannel
      and $projection.Division            = _ExciseSeriesGrpDtmn.Division
      and $projection.ShippingPoint       = _ExciseSeriesGrpDtmn.ShippingPoint
    )
  association [1..1] to I_SDDocumentCompletePartners as _Partner             on  $projection.BillingDocument     = _Partner.SDDocument
                                                                             and $projection.BillingDocumentItem = _Partner.SDDocumentItem
                                                                             and _Partner.PartnerFunction        = 'WE'
  association [0..1] to I_DistributionChannel        as _DistributionChannel on  $projection.DistributionChannel = _DistributionChannel.DistributionChannel
  association [0..1] to I_Division                   as _Division            on  $projection.Division = _Division.Division
  association [0..1] to I_SalesOrganization          as _SalesOrganization   on  $projection.SalesOrganization = _SalesOrganization.SalesOrganization
{

  key BillingDocument,
  key _Item.BillingDocumentItem as BillingDocumentItem,
      @ObjectModel.foreignKey.association: '_SalesOrganization'
  key  SalesOrganization,
      @ObjectModel.foreignKey.association: '_DistributionChannel'
  key DistributionChannel,
      @ObjectModel.foreignKey.association: '_Division'
  key Division,
  key BillingDocumentCategory,
  key SoldToParty,
  key BillingDocumentDate,
  key BillingDocumentType,
  key PricingDocument,
  key TransactionCurrency,
  key _ExciseHeader.ExciseDocStatus,
  key _Item.ReferenceSDDocument,
  key  DeliveryDocument,
  key _Item.ShippingPoint       as ShippingPoint,
  key _Item.Material,
  key _Item._Material._Text.MaterialName,
  key _Item._Material._Text.Language,
  key _Item.BaseUnit,
  key _Item.BillingQuantity,
  key _Item.BillingQuantityUnit,
  key _Item.PricingDate,
  key _Item.StorageLocation,
  key _Item.Batch,
  key _Item.BusinessArea,
  key _Item.ProfitCenter,
  key _Item.ProfitabilitySegment_2 as ProfitabilitySegment,
  key _Item.CostCenter,
  key _Item.Plant,
  key _Item._Plant.PlantName,
      //_Item.Sto

      //_Item.SalesDocumentItemCategory,

  key _Country.TaxCalculationProcedure,
  key I_BillingDocument.CompanyCode,
  key _CompanyCode._Currency.Currency,
 
    
      case I_BillingDocument.SDPricingProcedure
      when '' then
      P_SdPricingPrcd.SDPricingProcedure
      else
      I_BillingDocument.SDPricingProcedure
      end                       as SDPricingProcedure,


      /*Association*/

      _Item,
      _ExciseSeriesGrpDtmn,
      _BillingDocumentCategory,
      _Partner,
      _DistributionChannel,
      _Division,
      _SalesOrganization

}
where
  (
       _ExciseHeader.ExciseDocStatus        is null
    or _ExciseHeader.ExciseDocStatus        = 'R'
    or _ExciseHeader.ExciseDocStatus        = 'B'
  )
  and(
       BillingDocumentIsCancelled           = ' '
    or BillingDocumentIsCancelled           is null
  )
  and(
       CancelledBillingDocument             = ' '
    or CancelledBillingDocument             is null
  )
  and(
       I_BillingDocument.SDDocumentCategory = 'M'
    or I_BillingDocument.SDDocumentCategory = 'U'
    or I_BillingDocument.SDDocumentCategory = '5'
  )                                                 
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLINGDOCUMENT",
"I_BILLINGDOCUMENTITEM",
"I_COMPANYCODE",
"I_COUNTRY",
"I_CURRENCY",
"I_EXCISEDOCUMENT",
"I_EXCISEREVDOC",
"I_MATERIAL",
"I_MATERIALTEXT",
"I_PLANT",
"P_SDPRICINGPRCD"
],
"ASSOCIATED":
[
"I_BILLINGDOCUMENTCATEGORY",
"I_BILLINGDOCUMENTITEM",
"I_DISTRIBUTIONCHANNEL",
"I_DIVISION",
"I_EXCISESERIESGRPDETRMN",
"I_SALESORGANIZATION",
"I_SDDOCUMENTCOMPLETEPARTNERS"
],
"BASE":
[
"I_BILLINGDOCUMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/