P_ACDOCAMEXTRACT

@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #BASIC
//'M EXTRACT with with placeholders for references'

define view entity P_ACDOCAMEXTRACT
  as select from acdoca_m_extract 
{
  key belnr     as AccountingDocument,
  key docln     as GLAccountLineItem,
  key cast(fiscyearper as fis_jahrper_conv preserving type ) as FiscalYearPeriod, // Data element differs in GFN ... check whether works out 

  key rldnr     as Ledger,
  key rbukrs    as CompanyCode,
  key kalnr     as CostEstimate,
      matnr     as Material,
      bwtar     as InventoryValuationType,
      bwkey     as ValuationArea,
      ml_sobkz  as InvtryValnSpecialStockType,
      ml_kdauf  as SalesOrder,
      ml_kdpos  as SalesOrderItem,
      ml_lifnr  as Supplier,
      cast( ml_pspnr  as fis_wbsint_no_conv preserving type ) as WBSElementInternalID,
      cast( 'KG' as meins )       as UnitOfMeasure,   
      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasure'   
      cast( vmsl as fis_vquan1_12 preserving type )           as ValuationQuantity,
      cast( 'EUR' as waers )      as Currency,
      @Semantics: { amount : {currencyCode: 'Currency'} }
      cast( hsl as fis_hsl preserving type )                  as AmountInCompanyCodeCurrency,
      @Semantics: { amount : {currencyCode: 'Currency'} }
      cast( ksl as fis_ksl preserving type )                  as AmountInGlobalCurrency,
      @Semantics: { amount : {currencyCode: 'Currency'} }
      cast( osl as fis_osl preserving type )                  as AmountInFreeDefinedCurrency1,
      @Semantics: { amount : {currencyCode: 'Currency'} }
      cast( vsl as fis_vsl preserving type )                  as AmountInFreeDefinedCurrency2,
      @Semantics: { amount : {currencyCode: 'Currency'} }
      cast( bsl as fis_bsl preserving type )                  as AmountInFreeDefinedCurrency3,
      @Semantics: { amount : {currencyCode: 'Currency'} }
      cast( csl as fis_csl preserving type )                  as AmountInFreeDefinedCurrency4,
      @Semantics: { amount : {currencyCode: 'Currency'} }
      cast( dsl as fis_dsl preserving type )                  as AmountInFreeDefinedCurrency5,
      @Semantics: { amount : {currencyCode: 'Currency'} }
      cast( esl as fis_esl preserving type )                  as AmountInFreeDefinedCurrency6,
      @Semantics: { amount : {currencyCode: 'Currency'} }
      cast( fsl as fis_fsl preserving type )                  as AmountInFreeDefinedCurrency7,
      @Semantics: { amount : {currencyCode: 'Currency'} }
      cast( gsl as fis_gsl preserving type )                  as AmountInFreeDefinedCurrency8
}