I_CndnContrConditionUsage

@AbapCatalog: {
    sqlViewName: 'ICCCNDNUSG',
    compiler.compareFilter: true,
    preserveKey: true
    }
@EndUserText.label: 'Condition Contract Condition Usage'
@VDM: {
    viewType: #BASIC,
    lifecycle.contract.type: #PUBLIC_LOCAL_API
    }
@AccessControl: {
    authorizationCheck: #MANDATORY,
    personalData.blocking: #('TRANSACTIONAL_DATA')
    }
@ObjectModel: {
    representativeKey: 'DocRelationshipUUID',
    modelingPattern: #ANALYTICAL_DIMENSION,
    supportedCapabilities: [ #ANALYTICAL_DIMENSION,
                             #CDS_MODELING_ASSOCIATION_TARGET,
                             #SQL_DATA_SOURCE,
                             #CDS_MODELING_DATA_SOURCE],
    usageType: {
      dataClass:      #TRANSACTIONAL,
      serviceQuality: #C,
      sizeCategory:   #XXL
      }
    }
@ClientHandling: {
    type: #INHERITED,
    algorithm: #SESSION_VARIABLE
    }
@Analytics: {
    dataCategory: #DIMENSION,
    dataExtraction.enabled: false,
    internalName: #LOCAL
    }
@Metadata: {
    ignorePropagatedAnnotations: true,
    allowExtensions:true
    }

/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ]  } */
define view I_CndnContrConditionUsage
  as select from R_CndnContrConditionUsage

  association [1..1] to I_ConditionContract    as _ConditionContract    on  $projection.ConditionContract = _ConditionContract.ConditionContract
  association [0..1] to I_CndnContrAccrRvslSts as _CndnContrAccrRvslSts on  $projection.CndnContrAccrRvslSts = _CndnContrAccrRvslSts.CndnContrAccrRvslSts

  association [0..1] to I_PricingConditionType as _PricingConditionType on  $projection.ConditionApplication = _PricingConditionType.ConditionApplication
                                                                        and $projection.ConditionType        = _PricingConditionType.ConditionType
  association [0..1] to I_Currency             as _ConditionCurrency    on  $projection.ConditionCurrency = _ConditionCurrency.Currency
  association [0..1] to I_Plant                as _Plant                on  $projection.Plant = _Plant.Plant
  association [0..1] to I_CompanyCode          as _CompanyCode          on  $projection.CompanyCode = _CompanyCode.CompanyCode

{

  key DocRelationshipUUID,
      PricingDocument,
      PricingProcedureStep,
      PricingProcedureCounter,
      @ObjectModel.foreignKey.association: '_ConditionContract'
      @Consumption: {
        valueHelpDefinition: [{ entity: { name: 'I_ConditionContractStdVH', element: 'ConditionContract' } }]
      }
      ConditionContract,
      CndnContrUUID,
      ConditionRecord,
      @API.element:{releaseState: #DEPRECATED, successor: 'ConditionSequentialNumberShort'}
      cast( '00' as kopos preserving type )                              as ConditionSequentialNumber,
      ConditionSequentialNumberShort,
      @ObjectModel.foreignKey.association: '_CndnContrAccrRvslSts'
      CndnContrAccrRvslSts,

      @ObjectModel.foreignKey.association: '_ConditionApplication'
      ConditionApplication,
      @ObjectModel.foreignKey.association: '_PricingConditionType'
      ConditionType,
      @Semantics.amount.currencyCode: 'ConditionCurrency'
      @DefaultAggregation: #SUM
      ConditionAmount,
      @ObjectModel.foreignKey.association: '_ConditionCurrency'
      @Semantics.currencyCode: true
      cast( AccrSrceDocCurrency as waers preserving type )               as ConditionCurrency,
      @API.element:{releaseState: #DEPRECATED, successor: 'AccrSrceDocPostingDate'}
      cast( AccrSrceDocPostingDate as wcb_wcocof_budat preserving type ) as AR_DocumentPostingDate,
      AccrSrceDocPostingDate,
      SettlmtDate,
      SettlmtDateSequentialID,
      RefSettlmtDate,
      RefSettlmtDateSequentialID,
      AccrSrceDocFiscalYear                                              as FiscalYear,
      @ObjectModel.foreignKey.association: '_Plant'
      @Consumption: {
        valueHelpDefinition: [{ entity: { name: 'I_PlantStdVH', element: 'Plant' } }]
      }
      AccrSrceDocItemPlant                                               as Plant,
      @ObjectModel.foreignKey.association: '_CompanyCode'
      @Consumption: {
         valueHelpDefinition: [{ entity: { name: 'I_CompanyCodeStdVH', element: 'CompanyCode' } }]
      }
      AccrSrceDocCompanyCode                                             as CompanyCode,

      @ObjectModel.foreignKey.association: '_CndnContrAccrSource'
      CndnContrAccrSource,

      /* Material Document*/
      //MaterialDocumentYear,

      //MaterialDocument,

      //MaterialDocumentItem,


      /* Settlement Management Document*/
      //SettlmtMgmtDoc,

      //SettlmtMgmtDocItem,


      /* Billing Document*/
      @ObjectModel.foreignKey.association: '_BillingDocument'
      @Consumption: {
        valueHelpDefinition: [{ entity: { name: 'I_BillingDocumentStdVH', element: 'BillingDocument' } }]
      }
      BillingDocument,
      @ObjectModel.foreignKey.association: '_BillingDocumentItem'
      @Consumption: {
        valueHelpDefinition: [{ entity: { name: 'I_BillingDocumentItemStdVH', element: 'BillingDocumentItem' } }]
      }
      BillingDocumentItem,

      /* Associations */
      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT]
      _ConditionContract,
      _CndnContrAccrRvslSts,
      _ConditionApplication,
      _PricingConditionType,
      _ConditionCurrency,
      _Plant,
      _CompanyCode,
      _CndnContrAccrSource,
      _BillingDocument,
      _BillingDocumentItem

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_CNDNCONTRCONDITIONUSAGE"
],
"ASSOCIATED":
[
"I_BILLINGDOCUMENT",
"I_BILLINGDOCUMENTITEM",
"I_CNDNCONTRACCRRVSLSTS",
"I_CNDNCONTRACCRSOURCE",
"I_COMPANYCODE",
"I_CONDITIONAPPLICATION",
"I_CONDITIONCONTRACT",
"I_CURRENCY",
"I_PLANT",
"I_PRICINGCONDITIONTYPE"
],
"BASE":
[
"R_CNDNCONTRCONDITIONUSAGE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/