C_InvoiceListItemObjPg

DDL: C_INVOICELISTITEMOBJPG Type: view CONSUMPTION
14 Fields 1 Data Sources 1 Associations

C_InvoiceListItemObjPg is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_InvoiceListItem) and exposes 14 fields with key fields InvoiceList, InvoiceListItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_InvoiceListItem InvoiceListItem from

Associations (1)

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

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CINVLISTIOP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable false view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY InvoiceList I_InvoiceListItem InvoiceList Invoice List
KEY InvoiceListItem I_InvoiceListItem InvoiceListItem WBS Element
BillingDocument I_InvoiceListItem BillingDocument SD Document
SoldToParty I_InvoiceListItem SoldToParty Sold-to Party
NetAmount I_InvoiceListItem NetAmount Stated Amount
TaxAmount I_InvoiceListItem TaxAmount Tax Amt in Rptg Crcy
GrossAmount I_InvoiceListItem GrossAmount Gross value
RemunerationNetAmount I_InvoiceListItem RemunerationNetAmount SDoc List Value
RemunerationTaxAmount I_InvoiceListItem RemunerationTaxAmount SDListCond Tax
TransactionCurrency I_InvoiceListItem TransactionCurrency Transaction Currency
BillingDocumentTypeName
_BillingDocument I_InvoiceListItem _BillingDocument
_SoldToParty I_InvoiceListItem _SoldToParty
_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 C_InvoiceListItemObjPg.
-- 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 C_InvoiceListItemObjPg AS
SELECT
  InvoiceListItem.InvoiceList AS InvoiceList,
  InvoiceListItem.InvoiceListItem AS InvoiceListItem,
  InvoiceListItem.BillingDocument AS BillingDocument,
  InvoiceListItem.SoldToParty AS SoldToParty,
  InvoiceListItem.NetAmount AS NetAmount,
  InvoiceListItem.TaxAmount AS TaxAmount,
  InvoiceListItem.GrossAmount AS GrossAmount,
  InvoiceListItem.RemunerationNetAmount AS RemunerationNetAmount,
  InvoiceListItem.RemunerationTaxAmount AS RemunerationTaxAmount,
  InvoiceListItem.TransactionCurrency AS TransactionCurrency,
  InvoiceListItem._BillingDocument._BillingDocumentType._Text[1: Language = $session.system_language ].BillingDocumentTypeName AS BillingDocumentTypeName,
  InvoiceListItem._BillingDocument AS _BillingDocument,
  InvoiceListItem._SoldToParty AS _SoldToParty
FROM I_InvoiceListItem AS InvoiceListItem
LEFT OUTER JOIN C_InvoiceListObjPg AS _InvoiceList ON InvoiceList = _InvoiceList.InvoiceList  -- association [1..1]
;

Learn More