I_EmrkdFndsProcgTotalsByTrans

DDL: I_EMRKDFNDSPROCGTOTALSBYTRANS Type: view_entity COMPOSITE
11 Fields 1 Data Sources

Earmarked Funds Processing Totals

I_EmrkdFndsProcgTotalsByTrans is a Composite CDS View that provides data about "Earmarked Funds Processing Totals" in SAP S/4HANA. It reads from 1 data source (I_EmrkdFndsDocItmProcgItem) and exposes 11 fields with key fields EarmarkedFundsDocument, EarmarkedFundsDocumentItem, BusinessTransactionType, EmrkdFndsItmProcgIsStatistical, IsReversed.

Data Sources (1)

SourceAliasJoin Type
I_EmrkdFndsDocItmProcgItem I_EmrkdFndsDocItmProcgItem from

Annotations (7)

NameValueLevelField
Analytics.technicalName IEFDITMPROCGTOT view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #COMPOSITE view
EndUserText.label Earmarked Funds Processing Totals view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY EarmarkedFundsDocument EarmarkedFundsDocument Earmarked Funds
KEY EarmarkedFundsDocumentItem EarmarkedFundsDocumentItem Document Item
KEY BusinessTransactionType BusinessTransactionType Bus.transaction
KEY EmrkdFndsItmProcgIsStatistical EmrkdFndsItmProcgIsStatistical Vehcle Status
KEY IsReversed IsReversed Reversed?
TransactionCurrency TransactionCurrency Transaction Currency
EmrkdFndsProcgTotalInTransCrcy
CompanyCodeCurrency CompanyCodeCurrency Local Currency
EmrkdFndsProcgTotalInCCCrcy
_TransactionCurrency _TransactionCurrency
_ControllingBusTransacType _ControllingBusTransacType

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 I_EmrkdFndsProcgTotalsByTrans.
-- 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 I_EmrkdFndsProcgTotalsByTrans AS
SELECT
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  BusinessTransactionType,
  EmrkdFndsItmProcgIsStatistical,
  IsReversed,
  TransactionCurrency,
  cast( sum( EmrkdFndsProcgAmtInTransCrcy ) as kblwta preserving type ) AS EmrkdFndsProcgTotalInTransCrcy,
  CompanyCodeCurrency,
  cast( sum( EmrkdFndsProcgAmtInCCCrcy ) as fmis_efd_amtincccrcy preserving type ) AS EmrkdFndsProcgTotalInCCCrcy
FROM I_EmrkdFndsDocItmProcgItem
;

Learn More