C_BillgReqLineObjPgPrcDets

DDL: C_BILLGREQLINEOBJPGPRCDETS SQL: CBILLREQPRCDETS Type: view CONSUMPTION

Billing Request Line Price Details

C_BillgReqLineObjPgPrcDets is a Consumption CDS View that provides data about "Billing Request Line Price Details" in SAP S/4HANA. It reads from 1 data source (I_BillingRequestItem) and exposes 19 fields with key fields ServiceContractItem, ServiceContract, ServiceContractType, BillingRequestItem, PricingProcedureStep.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
I_BillingRequestItem I_BillingRequestItem from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CBILLREQPRCDETS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Billing Request Line Price Details view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey ServiceContractItem view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY ServiceContractItem ServiceDocumentItem
KEY ServiceContract ServiceDocument
KEY ServiceContractType ServiceObjectType
KEY BillingRequestItem BillingRequestItem
KEY PricingProcedureStep
KEY PricingProcedureCounter
ServiceDocumentType _ServiceDocItem ServiceDocumentType
ConditionInactiveReason Status
ConditionType Price Element
ConditionTypeName
ConditionRateValue Price
ConditionCurrency
ConditionQuantity Price Unit
ConditionQuantityUnit Unit of Measurement
ConditionCalculationType Calculation Type
ConditionCalculationTypeName
ConditionAmount End Value
TransactionCurrency
_ServiceDocItem _ServiceDocItem 
@AbapCatalog.sqlViewName: 'CBILLREQPRCDETS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Billing Request Line Price Details'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
  viewType: #CONSUMPTION
}

@ObjectModel: {
   representativeKey: 'ServiceContractItem',
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #XXL
   }
}
define view C_BillgReqLineObjPgPrcDets
  as select from I_BillingRequestItem
{

            @UI.hidden: true
  key       ServiceDocumentItem                                                                                                                                        as ServiceContractItem,

            @UI.hidden: true
  key       ServiceDocument                                                                                                                                            as ServiceContract,

            @UI.hidden: true
  key       ServiceObjectType                                                                                                                                          as ServiceContractType,

            @UI.hidden: true
  key       BillingRequestItem,

            @UI.hidden: true
  key       cast('' as abap.numc(3))                                                                                                                                   as PricingProcedureStep,

            @UI.hidden: true
  key       cast('' as abap.numc(3))                                                                                                                                   as PricingProcedureCounter,

            @UI.hidden: true
            _ServiceDocItem.ServiceDocumentType,


            @UI.lineItem.position:10
            @EndUserText.label: 'Status'
            cast( '' as abap.char( 1 ) )                                                                                                                               as ConditionInactiveReason,

            @UI.lineItem.position:20
            @ObjectModel.text.element:  [ 'ConditionTypeName' ]
            @EndUserText.label: 'Price Element'
            cast( '' as abap.char( 4 ) )                                                                                                                               as ConditionType,

            @UI.hidden: true
            cast( '' as abap.char( 30 ) )                                                                                                                              as ConditionTypeName,

            @UI.lineItem.position:40
            @EndUserText.label: 'Price'
 //           @Semantics.amount.currencyCode: 'ConditionCurrency'

            cast( 0 as abap.dec( 24, 2 ) )                                                                                                                             as ConditionRateValue,

            @UI.hidden: true
            @Semantics.currencyCode: true
            cast( '' as abap.cuky( 5 ) )                                                                                                                               as ConditionCurrency,

            @UI.lineItem.position:60
            @EndUserText.label: 'Price Unit'
            cast( 0 as abap.dec( 5 ) )                                                                                                                                 as ConditionQuantity,

            @UI.lineItem.position:70
            @EndUserText.label: 'Unit of Measurement'
            cast( '' as abap.unit( 3 ) )                                                                                                                               as ConditionQuantityUnit,

            @UI.lineItem.position:80
            @ObjectModel.text.element:  [ 'ConditionCalculationTypeName' ]
            @EndUserText.label: 'Calculation Type'
            cast ( '' as abap.char(3) )                                                                                                                                as ConditionCalculationType,

            @UI.hidden: true
            cast ( '' as abap.char(60) )                                                                                                                               as ConditionCalculationTypeName,

            @UI.lineItem.position:100
            @EndUserText.label: 'End Value'
            @Semantics.amount.currencyCode: 'TransactionCurrency'
            cast( 0 as abap.curr(15, 2 ) )                                                                                                                             as ConditionAmount,

            @UI.hidden: true
            @Semantics.currencyCode: true
            cast( '' as abap.cuky( 5 ) )                                                                                                                               as TransactionCurrency,

            //Associations

            _ServiceDocItem


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLINGREQUESTITEM",
"I_SERVICEDOCUMENTITEM"
],
"ASSOCIATED":
[
"I_SERVICEDOCUMENTITEM"
],
"BASE":
[
"I_BILLINGREQUESTITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More