I_BillingPlanItemUsageText

DDL: I_BILLINGPLANITEMUSAGETEXT Type: view BASIC Package: VDM_SD_BIL_IV_BP

Billing Plan Item Usage Text

I_BillingPlanItemUsageText is a Basic CDS View that provides data about "Billing Plan Item Usage Text" in SAP S/4HANA. It reads from 1 data source (sdbp_itm_usage_t) and exposes 7 fields with key fields Language, BillingPlanUsageCategory, BillingPlanItemUsage. It has 3 associations to related views. Part of development package VDM_SD_BIL_IV_BP.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
sdbp_itm_usage_t sdbp_itm_usage_t from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language
[0..1] I_BillingPlanItemUsage _BillingPlanItemUsage $projection.BillingPlanUsageCategory = _BillingPlanItemUsage.BillingPlanUsageCategory and $projection.BillingPlanItemUsage = _BillingPlanItemUsage.BillingPlanItemUsage
[0..1] I_BillgPlnUsgeCat_2 _BillingPlanUsageCategory $projection.BillingPlanUsageCategory = _BillingPlanUsageCategory.BillingPlanUsageCategory

Annotations (14)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey BillingPlanItemUsage view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
AbapCatalog.sqlViewName ISDBPITMUSAGET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Billing Plan Item Usage Text view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Language langu
KEY BillingPlanUsageCategory bpcat
KEY BillingPlanItemUsage item_usage
BillingPlanItemUsageName item_usage_text
_Language _Language
_BillingPlanUsageCategory _BillingPlanUsageCategory
_BillingPlanItemUsage _BillingPlanItemUsage 
@ClientHandling.algorithm: #SESSION_VARIABLE //Inserted by VDM CDS Suite Plugin

@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'BillingPlanItemUsage'
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@AbapCatalog: {
  sqlViewName: 'ISDBPITMUSAGET',
  compiler.compareFilter: true,
  buffering: {
    status: #ACTIVE,
    type: #FULL
  },
  preserveKey: true
}
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Billing Plan Item Usage Text'
define view I_BillingPlanItemUsageText
  as select from sdbp_itm_usage_t
  association [0..1] to I_Language             as _Language                 on  $projection.Language = _Language.Language
  association [0..1] to I_BillingPlanItemUsage as _BillingPlanItemUsage     on  $projection.BillingPlanUsageCategory = _BillingPlanItemUsage.BillingPlanUsageCategory
                                                                            and $projection.BillingPlanItemUsage     = _BillingPlanItemUsage.BillingPlanItemUsage
  association [0..1] to I_BillgPlnUsgeCat_2    as _BillingPlanUsageCategory on  $projection.BillingPlanUsageCategory = _BillingPlanUsageCategory.BillingPlanUsageCategory
{

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

      @Semantics.language
  key langu           as Language,
      @ObjectModel.foreignKey.association: '_BillingPlanUsageCategory'
  key bpcat           as BillingPlanUsageCategory,
      @ObjectModel.foreignKey.association: '_BillingPlanItemUsage'
  key item_usage      as BillingPlanItemUsage,

      @Semantics.text
      item_usage_text as BillingPlanItemUsageName,

      //Associations

      _Language,
      _BillingPlanUsageCategory,
      _BillingPlanItemUsage

}

Learn More