I_UtilsInvcgDocOutsrtgData

@EndUserText.label: 'Outsorting Data for Invoicing Document'
@Analytics.dataCategory: #DIMENSION
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'IEINVCGDOUTDATA'
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L //or XL

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'UtilsInvcgDocSqncNmbrOutsrtg'
@Metadata.allowExtensions:true
@AbapCatalog.compiler.compareFilter:true
//@AbapCatalog.preserveKey:true

@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE, #ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #CDS_MODELING_DATA_SOURCE ]
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION

define view I_UtilsInvcgDocOutsrtgData
  as select from erdo
  association [1..1] to I_UtilitiesInvoicingDocument as _UtilitiesInvoicingDocument on $projection.UtilitiesInvoicingDocument = _UtilitiesInvoicingDocument.UtilitiesInvoicingDocument
  association [0..1] to I_UtilitiesInvoicingCheck    as _UtilitiesInvoicingCheck    on $projection.UtilitiesInvoicingCheck = _UtilitiesInvoicingCheck.UtilitiesInvoicingCheck
  association [0..1] to I_UtilsInvcgMnlOutsortingRsn as _UtilsInvcgMnlOutsortingRsn on $projection.UtilsInvcgOutsortingReason = _UtilsInvcgMnlOutsortingRsn.UtilsInvcgOutsortingReason
{
      @ObjectModel.foreignKey.association: '_UtilitiesInvoicingDocument'
  key erdo.opbel                                                       as UtilitiesInvoicingDocument,

  key erdo.outcnso                                                     as UtilsInvcgDocSqncNmbrOutsrtg,

      @ObjectModel.foreignKey.association: '_UtilitiesInvoicingCheck'
      cast(erdo.validat_in as e_invcgcheck_vdm preserving type)        as UtilitiesInvoicingCheck,

      @ObjectModel.foreignKey.association: '_UtilsInvcgMnlOutsortingRsn'
      cast(erdo.manouts_in as e_outsrtngreasinvcg_vdm preserving type) as UtilsInvcgOutsortingReason,

      @Semantics.businessDate.at: true
      erdo.frei_am                                                     as UtilsInvcgDocReleaseDate,

      //      @Semantics.user.responsible: true

      erdo.frei_von                                                    as UtilsInvcgDocReleasedByUser,

      erdo.deviation                                                   as UtilsOutsrtdInvcgDocDvtgValue,
      @Semantics.booleanIndicator:true
      erdo.bgrd_release                                                as UtilsInvcgDocIsReldBackground,


      /* Associations */
      _UtilitiesInvoicingDocument,
      _UtilitiesInvoicingCheck,
      _UtilsInvcgMnlOutsortingRsn
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ERDO"
],
"ASSOCIATED":
[
"I_UTILITIESINVOICINGCHECK",
"I_UTILITIESINVOICINGDOCUMENT",
"I_UTILSINVCGMNLOUTSORTINGRSN"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/