A_BusSolnQtanItemTblParam

DDL: A_BUSSOLNQTANITEMTBLPARAM Type: view COMPOSITE

Convergent Charging Table Parameters

A_BusSolnQtanItemTblParam is a Composite CDS View that provides data about "Convergent Charging Table Parameters" in SAP S/4HANA. It reads from 1 data source (I_BusSolnQtnItmCnvChrgParam) and exposes 8 fields with key fields BusinessSolutionQuotation, BusSolutionQuotationItem, ChargePlanParameterUUID. It has 2 associations to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_BusSolnQtnItmCnvChrgParam BusSolnQtnItmCnvChrgParam from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ChargePlanParameter _Chargeplanparameter $projection.ChargePlanAssignmentUUID = _Chargeplanparameter.ChargePlanAssignmentUUID and $projection.ChargePlanParameterID = _Chargeplanparameter.ChargePlanParameterID
[1..1] A_BusinessSolutionQuotation _BusinessSolutionQuotation $projection.BusinessSolutionQuotation = _BusinessSolutionQuotation.BusinessSolutionQuotation

Annotations (16)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Convergent Charging Table Parameters view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.sqlViewName ABSQITTBLPAR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY BusinessSolutionQuotation BusinessSolutionQuotation
KEY BusSolutionQuotationItem ServiceDocumentItem
KEY ChargePlanParameterUUID _Chargeplanparameter ChargePlanParameterUUID
ChargePlanAssignmentUUID I_BusSolnQtnItmCnvChrgParam ChargePlanAssignmentUUID
ChargePlanParameterID I_BusSolnQtnItmCnvChrgParam ChargePlanParameterID
ChargePlanParameterUseValue I_BusSolnQtnItmCnvChrgParam ChargePlanParameterUseValue
ChargePlanParameterStringValue I_BusSolnQtnItmCnvChrgParam ChargePlanParameterValue
_BusinessSolutionQuotation _BusinessSolutionQuotation 
        @ClientHandling.algorithm:#SESSION_VARIABLE
@EndUserText.label: 'Convergent Charging Table Parameters'
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@AbapCatalog: {
  sqlViewName: 'ABSQITTBLPAR',
  compiler.compareFilter: true,
  preserveKey: true
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #NOT_REQUIRED
}
@ObjectModel: {
   createEnabled: true,
   updateEnabled: true,
   deleteEnabled: true,
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   }
}
@Metadata.ignorePropagatedAnnotations: true


/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ]  } */
define view A_BusSolnQtanItemTblParam
  as select from I_BusSolnQtnItmCnvChrgParam as BusSolnQtnItmCnvChrgParam
  association [0..1] to I_ChargePlanParameter       as _Chargeplanparameter       on  $projection.ChargePlanAssignmentUUID = _Chargeplanparameter.ChargePlanAssignmentUUID
                                                                                  and $projection.ChargePlanParameterID    = _Chargeplanparameter.ChargePlanParameterID
  association [1..1] to A_BusinessSolutionQuotation as _BusinessSolutionQuotation on  $projection.BusinessSolutionQuotation = _BusinessSolutionQuotation.BusinessSolutionQuotation
{

  key BusinessSolutionQuotation,
  key ServiceDocumentItem as BusSolutionQuotationItem,
  key    _Chargeplanparameter.ChargePlanParameterUUID,
      @Consumption.hidden: true
      BusSolnQtnItmCnvChrgParam.ChargePlanAssignmentUUID,
      @Consumption.hidden: true
      BusSolnQtnItmCnvChrgParam.ChargePlanParameterID,
      BusSolnQtnItmCnvChrgParam.ChargePlanParameterUseValue,
      BusSolnQtnItmCnvChrgParam.ChargePlanParameterValue  as ChargePlanParameterStringValue,
      
      @Consumption.hidden: true     
      _BusinessSolutionQuotation
} where _Chargeplanparameter.ChargePlanParameterUsage = '6' or  _Chargeplanparameter.ChargePlanParameterUsage = '8'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSSOLNQTNITMCNVCHRGPARAM",
"I_CHARGEPLANPARAMETER"
],
"ASSOCIATED":
[
"A_BUSINESSSOLUTIONQUOTATION",
"I_CHARGEPLANPARAMETER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More