P_ES_CreditMemoCube

DDL: P_ES_CREDITMEMOCUBE Type: view_entity COMPOSITE
12 Fields 2 Data Sources

View for Credit memo documents

P_ES_CreditMemoCube is a Composite CDS View that provides data about "View for Credit memo documents" in SAP S/4HANA. It reads from 2 data sources (I_OperationalAcctgDocItem, I_StRpWhldgTaxItem) and exposes 12 fields with key fields CompanyCode, FiscalYear.

Data Sources (2)

SourceAliasJoin Type
I_OperationalAcctgDocItem doc from
I_StRpWhldgTaxItem wht inner

Annotations (8)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_ALLOWED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
VDM.private true view
EndUserText.label View for Credit memo documents view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_OperationalAcctgDocItem CompanyCode Receiver Company Code
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear G/L Fiscal Year
InvoiceReference I_OperationalAcctgDocItem InvoiceReference Invoice Reference
BusinessPlace I_OperationalAcctgDocItem BusinessPlace Business place
WithholdingTaxType I_StRpWhldgTaxItem WithholdingTaxType WTax Type
CompanyCodeCurrency I_OperationalAcctgDocItem CompanyCodeCurrency Local Currency
StatryRptgEntity I_StRpWhldgTaxItem StatryRptgEntity Reporting Entity
StatryRptCategory I_StRpWhldgTaxItem StatryRptCategory Report ID
StatryRptRunID I_StRpWhldgTaxItem StatryRptRunID Report Run ID
WhldgTaxAmtInCoCodeCrcy
WhldgTaxBaseAmtInCoCodeCrcy
_CompanyCode I_OperationalAcctgDocItem _CompanyCode

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 P_ES_CreditMemoCube.
-- 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 P_ES_CreditMemoCube AS
SELECT
  doc.CompanyCode AS CompanyCode,
  doc.FiscalYear AS FiscalYear,
  doc.InvoiceReference AS InvoiceReference,
  doc.BusinessPlace AS BusinessPlace,
  wht.WithholdingTaxType AS WithholdingTaxType,
  doc.CompanyCodeCurrency AS CompanyCodeCurrency,
  wht.StatryRptgEntity AS StatryRptgEntity,
  wht.StatryRptCategory AS StatryRptCategory,
  wht.StatryRptRunID AS StatryRptRunID,
  sum(wht.WhldgTaxAmtInCoCodeCrcy) AS WhldgTaxAmtInCoCodeCrcy,
  sum(wht.WhldgTaxBaseAmtInCoCodeCrcy) AS WhldgTaxBaseAmtInCoCodeCrcy,
  doc._CompanyCode AS _CompanyCode
FROM I_OperationalAcctgDocItem AS doc
INNER JOIN I_StRpWhldgTaxItem AS wht ON /* join condition not captured in parsed metadata */
;

Learn More