C_SrvcContrItmObjPgSettlmtPerd

DDL: C_SRVCCONTRITMOBJPGSETTLMTPERD SQL: CSRVCNTITMSETPRD Type: view CONSUMPTION

Settlement Periods

C_SrvcContrItmObjPgSettlmtPerd is a Consumption CDS View that provides data about "Settlement Periods" in SAP S/4HANA. It reads from 1 data source (I_BillingRequestItem) and exposes 16 fields with key fields ServiceObjectType, ServiceDocument, ServiceDocumentItem, BillingRequestItem. It has 1 association to related views.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_BillingRequestItem I_BillingRequestItem from

Associations (1)

CardinalityTargetAliasCondition
[1..*] C_BillgReqLineObjPgPrcDets _BillingReqPriceDets $projection.ServiceDocument = _BillingReqPriceDets.ServiceContract and $projection.ServiceDocumentItem = _BillingReqPriceDets.ServiceContractItem and $projection.ServiceObjectType = _BillingReqPriceDets.ServiceContractType and $projection.BillingRequestItem = _BillingReqPriceDets.BillingRequestItem

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CSRVCNTITMSETPRD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Settlement Periods view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey BillingRequestItem view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType ServiceObjectType
KEY ServiceDocument ServiceDocument
KEY ServiceDocumentItem ServiceDocumentItem
KEY BillingRequestItem BillingRequestItem
ServiceDocumentType _ServiceDocItem ServiceDocumentType
BillgReqItemBillingStatus BillgReqItemBillingStatus
clientNULLasSettlementStartDate
clientNULLasSettlementEndDate
clientNULLasBillgReqItemBillingDate
BillgReqItemBillingStatusName
TransactionCurrency TransactionCurrency
BillingDocument
BillgReqItemNetAmount BillgReqItemNetAmount
_BillingReqPriceDets _BillingReqPriceDets
_BillgReqItmSettlmtStatus _BillgReqItmSettlmtStatus
_ServiceDocItem _ServiceDocItem 
@AbapCatalog.sqlViewName: 'CSRVCNTITMSETPRD'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Settlement Periods'
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM: {
  viewType: #CONSUMPTION
}
@ObjectModel: {
   representativeKey: 'BillingRequestItem',
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #XXL
   }
}

define view C_SrvcContrItmObjPgSettlmtPerd
  as select from I_BillingRequestItem

  association [1..*] to C_BillgReqLineObjPgPrcDets as _BillingReqPriceDets on  $projection.ServiceDocument     = _BillingReqPriceDets.ServiceContract
                                                                           and $projection.ServiceDocumentItem = _BillingReqPriceDets.ServiceContractItem
                                                                           and $projection.ServiceObjectType   = _BillingReqPriceDets.ServiceContractType
                                                                           and $projection.BillingRequestItem  = _BillingReqPriceDets.BillingRequestItem


{
  key ServiceObjectType,
  key ServiceDocument,
  key ServiceDocumentItem,

  key BillingRequestItem,

      _ServiceDocItem.ServiceDocumentType,

      BillgReqItemBillingStatus,


      tstmp_to_dats( SettlementStartDateTime,
                     BillingPlanTimeZone,
                     $session.client,
                     'NULL' )                                             as    SettlementStartDate,

      tstmp_to_dats( SettlementEndDateTime,
                     BillingPlanTimeZone,
                     $session.client,
                    'NULL' )                                              as    SettlementEndDate,

      tstmp_to_dats( BillgReqItemBillingDateTime,
                     BillingPlanTimeZone,
                     $session.client,
                     'NULL' )                                             as    BillgReqItemBillingDate,

      _BillgReqItmSettlmtStatus._BillgReqItmSettlmtStatusText[1: Language=$session.system_language].BillgReqItemBillingStatusName,
      TransactionCurrency,

      @ObjectModel.virtualElement
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CRMS4_SRV_CONT_CALC_EXIT'
      cast('' as abap.char(10))                                           as    BillingDocument,

      BillgReqItemNetAmount,

      // Associations

      _BillingReqPriceDets,
      _BillgReqItmSettlmtStatus,
      _ServiceDocItem

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

Learn More