I_SVTProdnPrprocgDocument

@AbapCatalog.sqlViewName: 'ISVTPREPROCPRO'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'SVT production preprocessing document.'
@VDM.viewType: #BASIC

@ObjectModel: {
    usageType:{
        dataClass: #TRANSACTIONAL,
        serviceQuality: #A,
        sizeCategory: #L
      }
}

@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_SVTProdnPrprocgDocument
  as select from ehpmad_svt_proco
  association [0..1] to I_Country       as _ProductionPlantCountry on $projection.ProductionPlantCountry = _ProductionPlantCountry.Country
  association [1..1] to I_UnitOfMeasure as _UnitOfMeasure          on $projection.QuantityUnit = _UnitOfMeasure.UnitOfMeasure
{
  key svtproductionconfirmedqtyuuid                      as SVTConfirmedProductionDocUUID,
      materialdocument                                   as MaterialDocument,
      material                                           as Material,
      @Semantics.quantity.unitOfMeasure: 'QuantityUnit'
      cast( materialquantity as ehpma_svt_subst_vol_ui ) as Quantity,
      @Semantics.unitOfMeasure: true
      materialquantityunit                               as QuantityUnit,
      materialdocumentitem                               as MaterialDocumentItem,
      materialdocumentyear                               as MaterialDocumentYear,
      productioncompanycode                              as ProductionCompanyCode,
      productionplant                                    as ProductionPlant,
      postingdate                                        as PostingDate,
      creationtimelogsystem                              as CreationTime,
      creationdatetime                                   as CreationDateTime,
      storagelocation                                    as StorageLocation,
      processedstatus                                    as SVTPreprocessingStatus,
      orderquantity                                      as OrderQuantity,
      orderquantityuom                                   as OrderQuantityUnit,

      isdeleted                                          as IsDeleted,
      goodsmovementtype                                  as GoodsMovementType,
      debitcreditcode                                    as DebitCreditCode,
      accountingdocumenttype                             as AccountingDocumentType,
      inventorytransactiontype                           as InventoryTransactionType,
      prodcmplnceventuuid                                as ProdCmplncEventUUID,
      prodcmplncexclcoplntuuid                           as ProdCmplncExclCoPlntUUID,
      productionplantcountry                             as ProductionPlantCountry,
      productionplantregion                              as ProductionPlantRegion,
      manufacturingorder                                 as ManufacturingOrder,
      ordertype                                          as OrderType,
      ordercategory                                      as OrderCategory,
      iscompletelydelivered                              as IsCompletelyDelivered,
      reservation                                        as Reservation,
      reservationitem                                    as ReservationItem,
      reservationisfinallyissued                         as ReservationIsFinallyIssued,
      recordtype                                         as RecordType,
      svtbusinessprocesscategory                         as SVTBusinessProcessCategory,
      
      _ProductionPlantCountry,
      _UnitOfMeasure
}