I_DigitalVehicleBillingDocItem

DDL: I_DIGITALVEHICLEBILLINGDOCITEM Type: view_entity COMPOSITE

Billing Document

I_DigitalVehicleBillingDocItem is a Composite CDS View that provides data about "Billing Document" in SAP S/4HANA. It reads from 2 data sources (I_BillingDocumentItem, I_BillingDocumentPartner) and exposes 17 fields with key fields BillingDocument, BillingDocumentItem. It has 3 associations to related views.

2 data source(s) 17 fields

Data Sources (2)

SourceAliasJoin Type
I_BillingDocumentItem _BillingDocumentItem from
I_BillingDocumentPartner _BillingDocumentPartner inner

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_Customer _Customer _Customer.Customer = _BillingDocumentPartner.Customer
[1..1] I_BillingDocument _BillingDocument _BillingDocument.BillingDocument = _BillingDocumentItem.BillingDocument
[1..*] I_VMSVehicle _VMSVehicle _VMSVehicle.VMSVehicleBatch = _BillingDocumentItem.Batch

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Billing Document view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument I_BillingDocumentItem BillingDocument
KEY BillingDocumentItem I_BillingDocumentItem BillingDocumentItem
VMSVehicleUUID _VMSVehicle VMSVehicleUUID
DigitalVehicleReferenceID _VMSVehicle DigitalVehicleReferenceID
BillingDocumentDate _BillingDocument BillingDocumentDate
NetAmount I_BillingDocumentItem NetAmount
TransactionCurrency I_BillingDocumentItem TransactionCurrency
Customer I_BillingDocumentPartner Customer
CustomerName _Customer CustomerName
Material I_BillingDocumentItem Material
Quantity I_BillingDocumentItem BillingQuantity
BillingQuantityUnit I_BillingDocumentItem BillingQuantityUnit
GrossAmount I_BillingDocumentItem GrossAmount
TaxCode I_BillingDocumentItem TaxCode
TaxAmount I_BillingDocumentItem TaxAmount
LastChangeDateTime _BillingDocument LastChangeDateTime
_Customer _Customer 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Billing Document'
@ObjectModel: {
    usageType: {
        sizeCategory: #XL,
        serviceQuality: #C,
        dataClass:#TRANSACTIONAL
    },
    semanticKey: ['BillingDocument','BillingDocumentItem'] }
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #COMPOSITE
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
define view entity I_DigitalVehicleBillingDocItem
  as select from I_BillingDocumentItem    as _BillingDocumentItem
    inner join   I_BillingDocumentPartner as _BillingDocumentPartner on  _BillingDocumentPartner.BillingDocument = _BillingDocumentItem.BillingDocument
                                                                     and _BillingDocumentPartner.PartnerFunction = 'RE'
  association [1..1] to I_Customer        as _Customer        on _Customer.Customer = _BillingDocumentPartner.Customer
  association [1..1] to I_BillingDocument as _BillingDocument on _BillingDocument.BillingDocument = _BillingDocumentItem.BillingDocument
  association [1..*] to I_VMSVehicle      as _VMSVehicle      on _VMSVehicle.VMSVehicleBatch = _BillingDocumentItem.Batch
{
  key _BillingDocumentItem.BillingDocument,
  key _BillingDocumentItem.BillingDocumentItem,
      _VMSVehicle.VMSVehicleUUID,
      _VMSVehicle.DigitalVehicleReferenceID,
      _BillingDocument.BillingDocumentDate,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      _BillingDocumentItem.NetAmount,
      _BillingDocumentItem.TransactionCurrency,
      _BillingDocumentPartner.Customer,
      _Customer.CustomerName,
      _BillingDocumentItem.Material,
      @Semantics.quantity.unitOfMeasure: 'BillingQuantityUnit'
      _BillingDocumentItem.BillingQuantity as Quantity,
      _BillingDocumentItem.BillingQuantityUnit,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      _BillingDocumentItem.GrossAmount,
      _BillingDocumentItem.TaxCode,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      _BillingDocumentItem.TaxAmount,
      _BillingDocument.LastChangeDateTime,
      _Customer
}
where
  _BillingDocumentItem.Batch is not initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLINGDOCUMENT",
"I_BILLINGDOCUMENTITEM",
"I_BILLINGDOCUMENTPARTNER",
"I_CUSTOMER",
"I_VMSVEHICLE"
],
"ASSOCIATED":
[
"I_CUSTOMER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More