I_InvoiceListRemuneration

DDL: I_INVOICELISTREMUNERATION Type: view_entity COMPOSITE Package: VDM_SD_BIL_IL

Invoice List Remuneration

I_InvoiceListRemuneration (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Sales

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.

SAP API Hub

CategoryComposite
StateC1
Line of BusinessSales
Application ComponentSD-BIL-IL-2CL
CapabilitiesData Source in SQL Select,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageSales for SAP S/4HANA Cloud Public Edition

Documentation

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 Invoice List
TransactionCurrency I_InvoiceListItem TransactionCurrency Transaction Currency
TotalRemunerationNetAmount Factoring (Delcredere) Discount
TotalRemunerationTaxAmount Factoring (Delcredere) Discount Tax
_TransactionCurrency _TransactionCurrency
_InvoiceList _InvoiceList

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_InvoiceListRemuneration.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_InvoiceListRemuneration AS
SELECT
  InvoiceListItem.InvoiceList AS InvoiceList,
  InvoiceListItem.TransactionCurrency AS TransactionCurrency,
  cast(sum(InvoiceListItem.RemunerationNetAmount) as kwert_rl preserving type) AS TotalRemunerationNetAmount,
  cast(sum(InvoiceListItem.RemunerationTaxAmount) as mwsbp_rl preserving type) AS TotalRemunerationTaxAmount
FROM I_InvoiceListItem AS InvoiceListItem
LEFT OUTER JOIN I_InvoiceList AS _InvoiceList ON InvoiceList = _InvoiceList.InvoiceList  -- association [1..1]
;