@AbapCatalog.sqlViewName: 'ZBTMATERIAL'

@ObjectModel.dataCategory: #TEXT

@Analytics: { dataCategory: #TEXT, dataExtraction.enabled: true }

@AccessControl.authorizationCheck: #NOT_REQUIRED

@VDM.viewType: #BASIC

@EndUserText.label: 'Material Text'

@ObjectModel.representativeKey: 'Material'

define view Zbt_Material as

  select from makt

        {

          @ObjectModel.text.element:  [ 'MaterialName' ]

          key makt.matnr as Material,

          @Semantics.language: true

          key makt.spras as Language,

          @Semantics.text: true

              makt.maktx as MaterialName}

where makt.spras = $session.system_language

@AbapCatalog.sqlViewName: 'ZBDMATERIAL'

@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }

@VDM.viewType: #BASIC

@AbapCatalog.compiler.compareFilter: true

@EndUserText.label: 'Material Attributes'

@ObjectModel.representativeKey: 'Material'

@AccessControl.authorizationCheck: #NOT_REQUIRED

define view Zbd_Material as select from mara 

association [0..1] to Zbt_Material           as _Text           on $projection.Material      = _Text.Material

association [0..1] to Zbd_MaterialType       as _MaterialType   on $projection.MaterialType  = _MaterialType.MaterialType

association [0..1] to Zbd_MaterialGroup      as _MaterialGroup  on $projection.MaterialGroup = _MaterialGroup.MaterialGroup

association [0..1] to I_UnitOfMeasure        as _BaseUnit       on $projection.MaterialBaseUnit = _BaseUnit.UnitOfMeasure

association [0..1] to I_UnitOfMeasure        as _WeightUnit     on $projection.MaterialWeightUnit = _WeightUnit.UnitOfMeasure

association [0..1] to Zbt_Storage_Conditions as _StorCond       on $projection.StorageCondition = _StorCond.StorageCond

     { @EndUserText.label: 'Material'

       @ObjectModel.text.association: '_Text'

          key mara.matnr as Material, _Text,

       @ObjectModel.foreignKey.association: '_MaterialType'

       @EndUserText.label: 'Material Type'

              mara.mtart as MaterialType, _MaterialType,

       @ObjectModel.foreignKey.association: '_MaterialGroup'

       @EndUserText.label: 'Material Group'

              mara.matkl as MaterialGroup, _MaterialGroup,

       @EndUserText.label: 'Base Unit of Measure'

       @Semantics.unitOfMeasure: true

       @ObjectModel.foreignKey.association: '_BaseUnit'

              mara.meins as MaterialBaseUnit, _BaseUnit,

       @EndUserText.label: 'Gross Weight'

       @Semantics.quantity.unitOfMeasure: 'MaterialWeightUnit'

       @DefaultAggregation: #NONE

              mara.brgew as MaterialGrossWeight,

       @EndUserText.label: 'Net Weight'

       @Semantics.quantity.unitOfMeasure: 'MaterialWeightUnit'

       @DefaultAggregation: #NONE

                     mara.ntgew as MaterialNetWeight,

       @EndUserText.label: 'Weight Unit'

       @Semantics.unitOfMeasure: true

       @ObjectModel.foreignKey.association: '_WeightUnit'

              mara.gewei as MaterialWeightUnit, _WeightUnit,

              mara.mfrnr as MaterialManufacturerNumber,

              mara.mfrpn as MaterialManufacturerPartNumber,

       @EndUserText.label: 'Storage Condition'

       @ObjectModel.text.association: '_StorCond'

              mara.raube as StorageCondition, _StorCond,

       @EndUserText.label: 'Product Hierarchy'

              mara.prdha as ProductHierarchy

}

@AbapCatalog.sqlViewName: 'ZBFACDOCAXX'

@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: 'Universal Journal Entry, Basic'

@VDM.viewType: #BASIC

@Analytics.dataCategory: #FACT

@Analytics.dataExtraction.enabled: true

define view ZBF_ACDOCA_XX as select from acdoca 

{

       rbukrs as CompCode,

       gjahr  as FiscalYear,

       poper  as Period,

       racct  as GLAccount,

       matnr  as Material,

       werks  as Plant,

// UOMs - Currencies

       runit  as UOM,

       rhcur  as CCCurr,

// Measures

       msl    as Quantity,

       hsl    as AmtCC

}

@AbapCatalog.sqlViewName: 'ZCCACDOCAXX'

@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: 'Universal Journal Entry, Composite'

@VDM.viewType: #COMPOSITE

@Analytics.dataCategory: #CUBE

@Analytics.dataExtraction.enabled: true

define view ZCC_ACDOCA_XX as select from ZBF_ACDOCA_XX 

association [0..1] to I_Material    as _Mat      on $projection.Material = _Mat.Material

association [0..1] to I_Plant       as _Plant    on $projection.Plant    = _Plant.Plant

association [0..1] to I_CompanyCode as _CompCode on $projection.CompCode = _CompCode.CompanyCode

{

      @ObjectModel.foreignKey.association: '_CompCode'

      CompCode, _CompCode,

      FiscalYear,

      Period,

      GLAccount,

      @ObjectModel.foreignKey.association: '_Mat'

      Material, _Mat,

      @ObjectModel.foreignKey.association: '_Plant'

      Plant, _Plant,

      //UOMs - Currencies

      @Semantics.unitOfMeasure: true

      @EndUserText.label: 'Base UOM'

      UOM,

      @Semantics.currencyCode: true

      @EndUserText.label: 'Comp. Code Curr.'

      CCCurr,

//Measures

      @DefaultAggregation: #SUM

      @EndUserText.label: 'Quantity'

      @Semantics.quantity.unitOfMeasure: 'UOM'

      Quantity,

      @DefaultAggregation: #SUM

      @EndUserText.label: 'Amount CC'

      @Semantics.amount.currencyCode: 'CCCurr'

      AmtCC

}

@AbapCatalog.sqlViewName: 'ZCCACDOCAXXQ001'

@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: 'Universal Journal Entry, Query'

@VDM.viewType: #CONSUMPTION

@Analytics.query: true

define view ZCC_ACDOCA_XX_Q001 as select from ZCC_ACDOCA_XX 

{

    //ZCC_ACDOCA_XX

    @Consumption.filter: {mandatory: false, selectionType: #SINGLE, multipleSelections: true}

    CompCode,

    FiscalYear,

    Period,

    GLAccount,

    Material,

    @AnalyticsDetails.query.display: #KEY_TEXT

    @AnalyticsDetails.query.axis: #ROWS

    Plant, 

//UOMs - Currencies

    UOM,

    CCCurr, 

//Measures

    Quantity,

    AmtCC 

}