I_UtilsBillgDocDvceLineItem

DDL: I_UTILSBILLGDOCDVCELINEITEM SQL: IEBILLGITMDVCE Type: view BASIC

Billing Document Line Item for Device Data

I_UtilsBillgDocDvceLineItem is a Basic CDS View (Dimension) that provides data about "Billing Document Line Item for Device Data" in SAP S/4HANA. It reads from 1 data source (dberchz2) and exposes 14 fields with key fields UtilitiesBillingDocument, UtilitiesBillingDocLineItem. It has 1 association to related views.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
dberchz2 dberchz2 from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_UtilitiesBillingDocument _UtilitiesBillingDocument $projection.UtilitiesBillingDocument = _UtilitiesBillingDocument.UtilitiesBillingDocument

Annotations (14)

NameValueLevelField
EndUserText.label Billing Document Line Item for Device Data view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IEBILLGITMDVCE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey UtilitiesBillingDocLineItem view
Metadata.allowExtensions true view
AbapCatalog.compiler.compareFilter true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesBillingDocument belnr
KEY UtilitiesBillingDocLineItem belzeile
MeterReadingDocument ablbelnr
MeterReadingResultPreDecimals v_zwstand
MeterReadingResultDecimals n_zwstand
Equipment equnr
UtilitiesDevice geraet
UtilitiesDeviceCategory matnr
UtilitiesRegister zwnummer
MeterReadingReason ablesgr
MeterRdngResultDiffPreDecimals v_zwstdiff
MeterRdngResultDiffDecimals n_zwstdiff
UtilitiesLogicalRegisterNumber logikzw
_UtilitiesBillingDocument _UtilitiesBillingDocument 
@EndUserText.label: 'Billing Document Line Item for Device Data'
@Analytics.dataCategory: #DIMENSION
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'IEBILLGITMDVCE'
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'UtilitiesBillingDocLineItem'
@Metadata.allowExtensions:true
@AbapCatalog.compiler.compareFilter:true
//@AbapCatalog.preserveKey:true

@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE, #ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #CDS_MODELING_DATA_SOURCE ]
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION

define view I_UtilsBillgDocDvceLineItem
  as select from dberchz2
  association [1..1] to I_UtilitiesBillingDocument as _UtilitiesBillingDocument on $projection.UtilitiesBillingDocument = _UtilitiesBillingDocument.UtilitiesBillingDocument
{
      @ObjectModel.foreignKey.association: '_UtilitiesBillingDocument'
  key belnr      as UtilitiesBillingDocument,
  key belzeile   as UtilitiesBillingDocLineItem,
      ablbelnr   as MeterReadingDocument,
      v_zwstand  as MeterReadingResultPreDecimals,
      n_zwstand  as MeterReadingResultDecimals,
      equnr      as Equipment,
      geraet     as UtilitiesDevice,
      matnr      as UtilitiesDeviceCategory,
      zwnummer   as UtilitiesRegister,
      ablesgr    as MeterReadingReason,
      v_zwstdiff as MeterRdngResultDiffPreDecimals,
      n_zwstdiff as MeterRdngResultDiffDecimals,
      logikzw    as UtilitiesLogicalRegisterNumber,


      /* Associations */
      _UtilitiesBillingDocument
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DBERCHZ2"
],
"ASSOCIATED":
[
"I_UTILITIESBILLINGDOCUMENT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More