P_CASumInterestRunHistory

DDL: P_CASUMINTERESTRUNHISTORY SQL: PCASUMINTRUN Type: view COMPOSITE
12 Fields 1 Data Sources

P_CASumInterestRunHistory is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_CAInterestHistoryItem) and exposes 12 fields with key fields CAMassRunInternalID, CAInterestDocument, CAIsSimulationRun, BusinessPartner.

Data Sources (1)

SourceAliasJoin Type
P_CAInterestHistoryItem P_CAInterestHistoryItem from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PCASUMINTRUN view
VDM.viewType #COMPOSITE view
VDM.private true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY CAMassRunInternalID CAMassRunInternalID
KEY CAInterestDocument
KEY CAIsSimulationRun CAIsSimulationRun
KEY BusinessPartner BusinessPartner Issuing Authority
CAMassRunID Run ID
CAMassRunDate Date ID
CAInterestCalcOrigin CAInterestCalcOrigin
CAInterestCategory CAInterestCategory
TransactionCurrency TransactionCurrency Transaction Currency
CAInterestAmountInTransCrcy
ContractAccount
_Currency _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_CASumInterestRunHistory.
-- 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: PCASUMINTRUN

CREATE VIEW P_CASumInterestRunHistory AS
SELECT
  CAMassRunInternalID,
  cast(CAInterestDocument as opbel_gfn_kk) AS CAInterestDocument,
  CAIsSimulationRun,
  BusinessPartner,
  cast(CAMassRunID as intlaufi_kk) AS CAMassRunID,
  cast(CAMassRunDate as intlaufd_kk) AS CAMassRunDate,
  CAInterestCalcOrigin,
  CAInterestCategory,
  TransactionCurrency,
  cast(sum(CAInterestAmountInTransCrcy) as amint_ca) AS CAInterestAmountInTransCrcy,
  max(ContractAccount) AS ContractAccount
FROM P_CAInterestHistoryItem
;

Learn More