P_PL_ExcessDelayAcctItemRefSum

DDL: P_PL_EXCESSDELAYACCTITEMREFSUM SQL: PEDACTITMREFSUM Type: view COMPOSITE Package: GLO_FIN_IS_PL
9 Fields 1 Data Sources

Amount sum of docs with same invoice ref

P_PL_ExcessDelayAcctItemRefSum is a Composite CDS View that provides data about "Amount sum of docs with same invoice ref" in SAP S/4HANA. It reads from 1 data source (P_PL_ExcessDelayAccountingItem) and exposes 9 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, InvoiceReferenceFiscalYear. Part of development package GLO_FIN_IS_PL.

Data Sources (1)

SourceAliasJoin Type
P_PL_ExcessDelayAccountingItem ExcessDelayAccountingItem from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PEDACTITMREFSUM view
AbapCatalog.compiler.compareFilter true view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Amount sum of docs with same invoice ref view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity P_PL_ExcessDelayAccountingItem StatryRptgEntity Reporting Entity
KEY StatryRptCategory P_PL_ExcessDelayAccountingItem StatryRptCategory Report ID
KEY StatryRptRunID P_PL_ExcessDelayAccountingItem StatryRptRunID Report Run ID
KEY CompanyCode P_PL_ExcessDelayAccountingItem CompanyCode Receiver Company Code
KEY InvoiceReferenceFiscalYear P_PL_ExcessDelayAccountingItem InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
KEY InvoiceReference P_PL_ExcessDelayAccountingItem InvoiceReference Invoice Reference
KEY InvoiceItemReference P_PL_ExcessDelayAccountingItem InvoiceItemReference Item
AmountInCompanyCodeCurrency
CompanyCodeCurrency P_PL_ExcessDelayAccountingItem CompanyCodeCurrency Local Currency

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_PL_ExcessDelayAcctItemRefSum.
-- 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.
-- SQL view name: PEDACTITMREFSUM

CREATE VIEW P_PL_ExcessDelayAcctItemRefSum AS
SELECT
  ExcessDelayAccountingItem.StatryRptgEntity AS StatryRptgEntity,
  ExcessDelayAccountingItem.StatryRptCategory AS StatryRptCategory,
  ExcessDelayAccountingItem.StatryRptRunID AS StatryRptRunID,
  ExcessDelayAccountingItem.CompanyCode AS CompanyCode,
  ExcessDelayAccountingItem.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  ExcessDelayAccountingItem.InvoiceReference AS InvoiceReference,
  ExcessDelayAccountingItem.InvoiceItemReference AS InvoiceItemReference,
  sum(ExcessDelayAccountingItem.AmountInCompanyCodeCurrency) AS AmountInCompanyCodeCurrency,
  ExcessDelayAccountingItem.CompanyCodeCurrency AS CompanyCodeCurrency
FROM P_PL_ExcessDelayAccountingItem AS ExcessDelayAccountingItem
;

Learn More