A_ExciseTaxMatlDocItem

@AbapCatalog.sqlViewName: 'AET_MATLDOCITM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'MatlDocItem for Industry Extensions'
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
    usageType: {
        sizeCategory: #XXL,
        serviceQuality: #C,
        dataClass: #MIXED
        },
    createEnabled: false,
    updateEnabled: false
}

@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.personalData.blocking:#('TRANSACTIONAL_DATA')

define view A_ExciseTaxMatlDocItem as select from I_ExciseTaxMatlDocItem as _MaterialDocumentItem

association [1..1] to I_MaterialDocumentYear   as _MaterialDocumentYear   on  $projection.MaterialDocumentYear        = _MaterialDocumentYear.MaterialDocumentYear
association [1..1] to A_MaterialDocumentHeader as _MaterialDocumentHeader on  $projection.MaterialDocumentYear        = _MaterialDocumentHeader.MaterialDocumentYear
                                                                          and $projection.MaterialDocument            = _MaterialDocumentHeader.MaterialDocument
----> Extension Associations
association [1..1] to E_MaterialDocumentItem_2   as _MaterialDocumentItemExtension on  $projection.MaterialDocument     = _MaterialDocumentItemExtension.MaterialDocument
                                                                                 and $projection.MaterialDocumentYear = _MaterialDocumentItemExtension.MaterialDocumentYear
                                                                                 and $projection.MaterialDocumentItem = _MaterialDocumentItemExtension.MaterialDocumentItem
                                                                                 and _MaterialDocumentItemExtension.MaterialDocumentRecordType = 'MDOC'
association [0..1] to E_PurchasingDocumentItem as _PurchaseOrderItemExtension    on  $projection.PurchaseOrder        = _PurchaseOrderItemExtension.PurchasingDocument
                                                                                 and $projection.PurchaseOrderItem    = _PurchaseOrderItemExtension.PurchasingDocumentItem
association [0..1] to E_SalesDocumentItemBasic as _SalesDocumentItemExtension    on  $projection.SalesOrder           = _SalesDocumentItemExtension.SalesDocument
                                                                                 and $projection.SalesOrderItem       = _SalesDocumentItemExtension.SalesDocumentItem
{
  key _MaterialDocumentItem.MaterialDocument     as MaterialDocument,
  key _MaterialDocumentItem.MaterialDocumentYear as MaterialDocumentYear,
  key _MaterialDocumentItem.MaterialDocumentItem as MaterialDocumentItem,
    
      /*goodsmovement document fields*/

      // organizational data      

      _MaterialDocumentItem.CompanyCode     as CompanyCode,
      _MaterialDocumentItem.Plant           as Plant,
//      _MaterialDocumentItem.PlantCountry    as PlantCountry,

      _MaterialDocumentItem.StorageLocation as StorageLocation,
      _MaterialDocumentItem.CostCenter      as CostCenter,
      
      // dates

      @Semantics.businessDate.at: true
      _MaterialDocumentItem.PostingDate  as PostingDate,
      @Semantics.businessDate.at: true
      _MaterialDocumentItem.DocumentDate as DocumentDate,
      // timestamp

      _MaterialDocumentItem.CreationDate as CreationDate,
      _MaterialDocumentItem.CreationTime as CreationTime,
          
      // material

      _MaterialDocumentItem.Material as Material,
      _MaterialDocumentItem.Batch    as Batch,
      
      // units of measure

      @Semantics.quantity.unitOfMeasure: 'EntryUnit'
      _MaterialDocumentItem.QuantityInEntryUnit as QuantityInEntryUnit,
      @Semantics.unitOfMeasure: true
      _MaterialDocumentItem.EntryUnit           as EntryUnit,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      _MaterialDocumentItem.QuantityInBaseUnit  as QuantityInBaseUnit,
      @Semantics.unitOfMeasure: true
      _MaterialDocumentItem.MaterialBaseUnit    as MaterialBaseUnit,
      
      // movement type

      _MaterialDocumentItem.GoodsMovementType       as GoodsMovementType,
      _MaterialDocumentItem.IsReversalMovementType  as IsReversalMovementType,
      _MaterialDocumentItem.GoodsMovementRefDocType as GoodsMovementRefDocType, 
      _MaterialDocumentItem.DebitCreditCode         as DebitCreditCode,
      _MaterialDocumentItem.IsAutomaticallyCreated  as IsAutomaticallyCreated,
      _MaterialDocumentItem.GoodsMovementReasonCode as GoodsMovementReasonCode,
      
      // partners (including master data)

      _MaterialDocumentItem.Supplier                 as Supplier,
//      _MaterialDocumentItem.SupplierCountry          as SupplierCountry,

      _MaterialDocumentItem.SupplyingSupplier        as SupplyingSupplier,
//      _MaterialDocumentItem.SupplyingSupplierCountry as SupplyingSupplierCountry,

      _MaterialDocumentItem.Customer                 as Customer,
//      _MaterialDocumentItem.CustomerCountry          as CustomerCountry,

      _MaterialDocumentItem.GoodsRecipientName       as GoodsRecipientName,
  
      // transfers      

      _MaterialDocumentItem.IssuingOrReceivingPlant        as IssuingOrReceivingPlant,
//      _MaterialDocumentItem.IssuingOrReceivingPlantCountry as IssuingOrReceivingPlantCountry,

      _MaterialDocumentItem.IssuingOrReceivingStorageLoc   as IssuingOrReceivingStorageLoc,
      _MaterialDocumentItem.IssgOrRcvgMaterial             as IssgOrRcvgMaterial,
      _MaterialDocumentItem.IssgOrRcvgBatch                as IssgOrRcvgBatch,
      _MaterialDocumentItem.SupplyingPlant                 as SupplyingPlant,
      //_MaterialDocumentItem.SupplyingPlantCountry          as SupplyingPlantCountry,

//      _MaterialDocumentItem.PlantSupplier                  as PlantSupplier,

//      _MaterialDocumentItem.PlantSupplierCountry           as PlantSupplierCountry,

//      _MaterialDocumentItem.PlantCustomer                  as PlantCustomer, 

//      _MaterialDocumentItem.PlantCustomerCountry           as PlantCustomerCountry,

//      _MaterialDocumentItem.IssgOrRcvgPlantSupplier        as IssgOrRcvgPlantSupplier,

//      _MaterialDocumentItem.IssgOrRcvgPlantSupplierCountry as IssgOrRcvgPlantSupplierCountry,

//      _MaterialDocumentItem.IssgOrRcvgPlantCustomer        as IssgOrRcvgPlantCustomer,

//      _MaterialDocumentItem.IssgOrRcvgPlantCustomerCountry as IssgOrRcvgPlantCustomerCountry,

      
      // reference documenmts

      _MaterialDocumentItem.OriginalMaterialDocumentItem as OriginalMaterialDocumentItem,
      _MaterialDocumentHeader.ReferenceDocument          as ReferenceDocument,

      // cancellation

      _MaterialDocumentItem.ReversedMaterialDocument     as ReversedMaterialDocument,
      _MaterialDocumentItem.ReversedMaterialDocumentItem as ReversedMaterialDocumentItem,
      _MaterialDocumentItem.ReversedMaterialDocumentYear as ReversedMaterialDocumentYear,
           
      /*references*/

      _MaterialDocumentItem.DeliveryDocument          as DeliveryDocument,
      _MaterialDocumentItem.DeliveryDocumentItem      as DeliveryDocumentItem,
      _MaterialDocumentItem.PurchaseOrder             as PurchaseOrder,
      _MaterialDocumentItem.PurchaseOrderItem         as PurchaseOrderItem,
      _MaterialDocumentItem.PurchaseOrderCategory     as PurchaseOrderCategory,
      _MaterialDocumentItem.PurchaseOrderItemCategory as PurchaseOrderItemCategory,
      _MaterialDocumentItem.PurchaseOrderType         as PurchaseOrderType,
      _MaterialDocumentItem.PurchaseOrderSubtype      as PurchaseOrderSubtype,
      _MaterialDocumentItem.SalesOrder                as SalesOrder,
      _MaterialDocumentItem.SalesOrderItem            as SalesOrderItem,
      _MaterialDocumentItem.SalesOrderType            as SalesOrderType,
      _MaterialDocumentItem.SalesDocumentItemCategory as SalesDocumentItemCategory,
      _MaterialDocumentItem.OrderID                   as OrderID,
      _MaterialDocumentItem.OrderItem                 as OrderItem,
      _MaterialDocumentItem.OrderCategory             as OrderCategory,
      _MaterialDocumentItem.OrderType                 as OrderType,
    
       /*Authorizations*/
      
      _MaterialDocumentItem.SupplierAuthznGrp              as SupplierAuthznGrp,
      _MaterialDocumentItem.CustomerAuthznGrp              as CustomerAuthznGrp,
      _MaterialDocumentItem.IsStorLocAuthznCheckActive     as IsStorLocAuthznCheckActive,
      _MaterialDocumentItem.IsIssgOrRcvgStorLocAuthChkActv as IsIssgOrRcvgStorLocAuthChkActv
      
}