I_InvoiceListRemuneration

DDL: I_INVOICELISTREMUNERATION Type: view_entity COMPOSITE Package: VDM_SD_BIL_IL

Invoice List Remuneration

I_InvoiceListRemuneration is a Composite CDS View that provides data about "Invoice List Remuneration" in SAP S/4HANA. It reads from 1 data source (I_InvoiceListItem) and exposes 6 fields with key field InvoiceList. It has 1 association to related views. Part of development package VDM_SD_BIL_IL.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_InvoiceListItem InvoiceListItem from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_InvoiceList _InvoiceList $projection.InvoiceList = _InvoiceList.InvoiceList

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Analytics.technicalName ISDINVOICELSTRMN view
EndUserText.label Invoice List Remuneration view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey InvoiceList view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY InvoiceList I_InvoiceListItem InvoiceList
TransactionCurrency I_InvoiceListItem TransactionCurrency
TotalRemunerationNetAmount
TotalRemunerationTaxAmount
_TransactionCurrency _TransactionCurrency
_InvoiceList _InvoiceList 
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')

@Analytics.technicalName: 'ISDINVOICELSTRMN'

@EndUserText.label: 'Invoice List Remuneration'

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.representativeKey: 'InvoiceList'
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
@ObjectModel.usageType: { dataClass: #TRANSACTIONAL, serviceQuality: #C, sizeCategory: #L }

@VDM.viewType: #COMPOSITE

define view entity I_InvoiceListRemuneration
  as select from I_InvoiceListItem as InvoiceListItem

  association [1..1] to I_InvoiceList as _InvoiceList on $projection.InvoiceList = _InvoiceList.InvoiceList

{
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_InvoiceListStdVH', element: 'InvoiceList' } } ]
  key InvoiceListItem.InvoiceList,

      InvoiceListItem.TransactionCurrency,

      @DefaultAggregation: #NONE
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      cast(sum(InvoiceListItem.RemunerationNetAmount) as kwert_rl preserving type) as TotalRemunerationNetAmount,

      @DefaultAggregation: #NONE
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      cast(sum(InvoiceListItem.RemunerationTaxAmount) as mwsbp_rl preserving type) as TotalRemunerationTaxAmount,

      _TransactionCurrency,

      // Needed for DCL

      @Consumption.hidden: true
      _InvoiceList
}

group by InvoiceListItem.InvoiceList,
         InvoiceListItem.TransactionCurrency

Learn More