I_InvoiceListEnhancedFields

DDL: I_INVOICELISTENHANCEDFIELDS Type: view COMPOSITE

Invoice List Enhanced Fields

I_InvoiceListEnhancedFields is a Composite CDS View that provides data about "Invoice List Enhanced Fields" in SAP S/4HANA. It reads from 1 data source (I_InvoiceList) and exposes 6 fields with key field InvoiceList. It has 2 associations to related views.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_InvoiceList InvoiceList from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_InvoiceList _InvoiceList $projection.InvoiceList = _InvoiceList.InvoiceList
[0..1] I_InvoiceListRemuneration _Remuneration $projection.InvoiceList = _Remuneration.InvoiceList

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ISDINVLSTENHFLD view
AbapCatalog.preserveKey true view
EndUserText.label Invoice List Enhanced Fields view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.representativeKey InvoiceList view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY InvoiceList I_InvoiceList InvoiceList
TransactionCurrency I_InvoiceList TransactionCurrency
TotalGrossAmount
_Remuneration _Remuneration
_TransactionCurrency _TransactionCurrency
_InvoiceList _InvoiceList 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog: {
  sqlViewName: 'ISDINVLSTENHFLD',
  preserveKey: true
}
@EndUserText.label: 'Invoice List Enhanced Fields'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.representativeKey: 'InvoiceList'
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK

define view I_InvoiceListEnhancedFields
  as select from I_InvoiceList as InvoiceList
  //Association

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

{
  key InvoiceList.InvoiceList,
      @Semantics.currencyCode:true
      InvoiceList.TransactionCurrency as TransactionCurrency,
      @DefaultAggregation: #NONE
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      cast( InvoiceList.TotalTaxAmount + InvoiceList.TotalNetAmount + _Remuneration.TotalRemunerationNetAmount + _Remuneration.TotalRemunerationTaxAmount  as sum_rl) as TotalGrossAmount,


      _Remuneration,
      _TransactionCurrency,
      //    Needed for DCL

      @Consumption.hidden: true
      _InvoiceList
}

Learn More