I_RO_SAFTMaterialDocumentItem

@AbapCatalog.sqlViewName: 'IROSAFTMATDOC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass:  #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #B
@Analytics: { dataCategory: #DIMENSION }
@Analytics.internalName:#LOCAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@VDM.viewType: #BASIC
@Metadata.allowExtensions:true
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel.supportedCapabilities: [#CDS_MODELING_ASSOCIATION_TARGET,
                                     #CDS_MODELING_DATA_SOURCE,
                                     #SQL_DATA_SOURCE]
@EndUserText.label: 'RO SAFT Material Document Item'

define view I_RO_SAFTMaterialDocumentItem as select from matdoc 
{
      mblnr as MaterialDocument,
      mjahr as MaterialDocumentYear,
//      line_id as MaterialDocumentLine,

      cast( lpad(zeile, 6, '0') as fins_awitem ) as MaterialDocumentLine,  //n3283572

//    key lpad(zeile, 6, '0') as awitem,

      werks as Plant,
      sobkz as ProjectNetworkHasSpecialStock,
      bukrs as CompanyCode,
      bwart as GoodsMovementType,
      erfme as EntryUnit,
      @Semantics.quantity.unitOfMeasure : 'EntryUnit'
      erfmg as GoodsMovementEntryQty,
      budat as PostingDate,
      matnr as Product,
      meins as AlternativeUnit,
      menge as GoodsMovementQuantity,
      xblnr as DocumentReferenceID,
      charg as Batch,
      lgort as StorageLocation,
      shkzg as DebitCreditCode,
      sakto as ActiveGLAccount,
      blart as AccountingDocumentType,
      sgtxt as MaterialDocumentItemText, 
      vgart as MaterialLedgerTransactionType,
      cast(concat( mblnr, mjahr) as fac_awkey) as OriginalReferenceDocument

} where record_type = 'MDOC'