P_BillingPlan

@VDM.viewType: #BASIC
@VDM.private: true
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #NOT_REQUIRED
}
@ObjectModel: {
   representativeKey: 'BillingPlan',
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #L
   }
}
@ObjectModel.supportedCapabilities: [#CDS_MODELING_ASSOCIATION_TARGET,
                                     #CDS_MODELING_DATA_SOURCE,
//                                     #EXTRACTION_DATA_SOURCE,

//                                     #SEARCHABLE_ENTITY,

                                     #SQL_DATA_SOURCE]

define view entity P_BillingPlan
  as select from fpla
  association [0..*] to P_BillingPlanItem           as _BillingPlanItem          on _BillingPlanItem.BillingPlan = $projection.BillingPlan
  association [0..1] to I_BillingPlanCategory       as _BillingPlanCategory      on _BillingPlanCategory.BillingPlanCategory = $projection.BillingPlanCategory
  association [0..1] to I_BillgPlnUsgeCat_2         as _BillingPlanUsageCategory on _BillingPlanUsageCategory.BillingPlanUsageCategory = $projection.BillingPlanUsageCategory
  association [0..1] to I_BillingPlanType           as _BillingPlanType          on _BillingPlanType.BillingPlanType = $projection.BillingPlanType
  association [0..1] to I_IndirectDateDetermineRule as _StartDateRule            on _StartDateRule.IndirectDateDetermineRule = $projection.BillingPlanStartDateRule
  association [0..1] to I_IndirectDateDetermineRule as _EndDateRule              on _EndDateRule.IndirectDateDetermineRule = $projection.BillingPlanEndDateRule
  association [0..1] to I_IndirectDateDetermineRule as _NextBillingDateRule      on _NextBillingDateRule.IndirectDateDetermineRule = $projection.BillingPlanNextBillingDateRule
  //  association [0..1] to I_IndirectDateDetermineRule as _DeviatingDteDetermineRule on _DeviatingDteDetermineRule.IndirectDateDetermineRule = $projection.DeviatingBillgDteDetermineRule

  //  association [0..1] to I_IndirectDateDetermineRule as _HrznDateDetermineRule     on _HrznDateDetermineRule.IndirectDateDetermineRule = $projection.BillgPlnHrznDateDetermineRule

  //  association [0..1] to I_IndirectDateDetermineRule as _FromDateRule              on _FromDateRule.IndirectDateDetermineRule = $projection.BillingPlanFromDateRule

  //  association [0..1] to I_IndirectDateDetermineRule as _UntilDateRule             on _UntilDateRule.IndirectDateDetermineRule = $projection.BillingPlanUntilDateRule

  //  association [0..1] to I_FactoryCalendar           as _FactoryCalendar           on _FactoryCalendar.FactoryCalendar = $projection.BillgDocDateFactoryCalendar

{
  key cast( fpla.fplnr as tds_bplan_id preserving type )     as BillingPlan,
      @ObjectModel.foreignKey.association: '_BillingPlanCategory'
      fpla.fptyp                                             as BillingPlanCategory,
      @ObjectModel.foreignKey.association: '_BillingPlanUsageCategory'
      fpla.bpcat                                             as BillingPlanUsageCategory,
      @ObjectModel.foreignKey.association: '_BillingPlanType'
      fpla.fpart                                             as BillingPlanType,
      cast( fpla.bedat as tds_bp_start_date preserving type) as BillingPlanStartDate,
      @ObjectModel.foreignKey.association: '_StartDateRule'
      fpla.bedar                                             as BillingPlanStartDateRule,
      cast( fpla.endat as tds_bp_end_date preserving type )  as BillingPlanEndDate,
      @ObjectModel.foreignKey.association: '_EndDateRule'
      fpla.endar                                             as BillingPlanEndDateRule,
      fpla.sortl                                             as BillingPlanSearchTerm,
      fpla.vbeln                                             as SalesDocument,
      @ObjectModel.foreignKey.association: '_NextBillingDateRule'
      fpla.perio                                             as BillingPlanNextBillingDateRule,
      //      @ObjectModel.foreignKey.association: '_DeviatingDteDetermineRule'

      //      fpla.peraf  as DeviatingBillgDteDetermineRule,

      //      @ObjectModel.foreignKey.association: '_HrznDateDetermineRule'

      //      fpla.horiz  as BillgPlnHrznDateDetermineRule,

      //      fpla.autte  as BillgDocIsCreatedInAdvance,

      //      fpla.lodat  as BillingPlanFromDate,

      //      fpla.tndat  as BillingPlanUntilDate,

      //      @ObjectModel.foreignKey.association: '_FromDateRule'

      //      fpla.lodar  as BillingPlanFromDateRule,

      //      @ObjectModel.foreignKey.association: '_UntilDateRule'

      //      fpla.tndar  as BillingPlanUntilDateRule,

      //      fpla.autkor as CorrectionDateIsAutoCreated,

      //      @ObjectModel.foreignKey.association: '_FactoryCalendar'

      //      fpla.fakca  as BillgDocDateFactoryCalendar,

      cast( fpla.rfpln as tds_refbplan_id preserving type )  as ReferenceBillingPlan,

      //Associations

      _BillingPlanItem,
      _BillingPlanCategory,
      _BillingPlanUsageCategory,
      _BillingPlanType,
      _StartDateRule,
      _EndDateRule,
      _NextBillingDateRule
      //      _DeviatingDteDetermineRule,

      //      _HrznDateDetermineRule,

      //      _FromDateRule,

      //      _UntilDateRule,

      //      _FactoryCalendar

}