C_CreditMemoReqRefInvoiceItem

DDL: C_CREDITMEMOREQREFINVOICEITEM Type: view_entity CONSUMPTION Package: ODATA_SD_CREDITMEMOREQUEST
16 Fields 2 Data Sources 1 OData Services

Credit Memo Req Reference Invoice Item

C_CreditMemoReqRefInvoiceItem is a Consumption CDS View that provides data about "Credit Memo Req Reference Invoice Item" in SAP S/4HANA. It reads from 2 data sources (I_BillingDocumentItem, C_CrdtMemoReqReferenceInvoice) and exposes 16 fields with key fields ReferenceDocument, ReferenceSDDocumentItem. It is exposed through 1 OData service (UI_CREDITMEMOREQUESTMANAGE). Part of development package ODATA_SD_CREDITMEMOREQUEST.

Data Sources (2)

SourceAliasJoin Type
I_BillingDocumentItem BillingDocumentItem from
C_CrdtMemoReqReferenceInvoice ReferenceDocument inner

Annotations (11)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Credit Memo Req Reference Invoice Item view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #NONE view
Search.searchable true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_CREDITMEMOREQUESTMANAGE UI_CREDITMEMOREQUESTMANAGE V4 C1 NOT_RELEASED

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ReferenceDocument
KEY ReferenceSDDocumentItem I_BillingDocumentItem BillingDocumentItem Item
SDDocumentCategory I_BillingDocumentItem SDDocumentCategory Document Cat.
Product I_BillingDocumentItem Product Product Sold
ProductName
BillingQuantityUnit I_BillingDocumentItem BillingQuantityUnit Sales Unit
BillingQuantity I_BillingDocumentItem BillingQuantity Invoiced Qty
NetAmount I_BillingDocumentItem NetAmount Stated Amount
TargetQuantity
TargetQuantityUnit I_BillingDocumentItem BillingQuantityUnit Sales Unit
TransactionCurrency I_BillingDocumentItem TransactionCurrency Transaction Currency
HigherLevelItem I_BillingDocumentItem HigherLevelItem Higher-Lev.Item
BillingDocumentType C_CrdtMemoReqReferenceInvoice BillingDocumentType Billing Type
Division C_CrdtMemoReqReferenceInvoice Division Internal Division ID
SalesOrganization C_CrdtMemoReqReferenceInvoice SalesOrganization Sales Organization
DistributionChannel C_CrdtMemoReqReferenceInvoice DistributionChannel RefDistCh-Cust/Mat.

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_CreditMemoReqRefInvoiceItem.
-- 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_CreditMemoReqRefInvoiceItem AS
SELECT
  cast( BillingDocumentItem.BillingDocument as vdm_invoice preserving type ) AS ReferenceDocument,
  BillingDocumentItem.BillingDocumentItem AS ReferenceSDDocumentItem,
  BillingDocumentItem.SDDocumentCategory AS SDDocumentCategory,
  BillingDocumentItem.Product AS Product,
  BillingDocumentItem._ProductText[1: Language=$session.system_language].ProductName AS ProductName,
  BillingDocumentItem.BillingQuantityUnit AS BillingQuantityUnit,
  BillingDocumentItem.BillingQuantity AS BillingQuantity,
  BillingDocumentItem.NetAmount AS NetAmount,
  cast(0 as dzmeng) AS TargetQuantity,
  BillingDocumentItem.BillingQuantityUnit AS TargetQuantityUnit,
  BillingDocumentItem.TransactionCurrency AS TransactionCurrency,
  BillingDocumentItem.HigherLevelItem AS HigherLevelItem,
  ReferenceDocument.BillingDocumentType AS BillingDocumentType,
  ReferenceDocument.Division AS Division,
  ReferenceDocument.SalesOrganization AS SalesOrganization,
  ReferenceDocument.DistributionChannel AS DistributionChannel
FROM I_BillingDocumentItem AS BillingDocumentItem
INNER JOIN C_CrdtMemoReqReferenceInvoice AS ReferenceDocument ON /* join condition not captured in parsed metadata */
;

Learn More