P_FundTreasuryOverTheCntr

DDL: P_FUNDTREASURYOVERTHECNTR SQL: PWUFUNDTO Type: view COMPOSITE
18 Fields 2 Associations

Treasury Over the Counter

P_FundTreasuryOverTheCntr is a Composite CDS View that provides data about "Treasury Over the Counter" in SAP S/4HANA. It has 2 associations to related views.

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_FinancialTransaction _FTrans $projection.CompanyCode = _FTrans.CompanyCode and $projection.FinancialTransaction = _FTrans.FinancialTransaction
[1..1] I_Fund _Fund $projection.ControllingArea = _Fund.FinancialManagementArea and $projection.Fund = _Fund.Fund

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PWUFUNDTO view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Treasury Over the Counter view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY FundWhereUsedObjType
KEY FinancialManagementArea _Fund FinancialManagementArea FM Area
KEY Fund Fund Sender Fund
KEY ControllingArea ControllingArea Controlling Area
KEY FinancialTransaction FinancialTransaction Transaction
KEY ValidityStartDate _FTrans TermStartDate
KEY ValidityEndDate _FTrans TermEndDate
KEY TreasuryAccountingCode TreasuryAccountingCode
KEY TreasuryValuationArea TreasuryValuationArea
TreasuryValuationAreaName _TreasuryValuationArea TreasuryValuationAreaName
FinancialInstrumentProductType FinancialInstrumentProductType
FinancialInstrProdTypeName
FinancialInstrTransactionType _FTrans FinancialInstrTransactionType
FinancialInstrTransTypeName
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
FundName
_Fund _Fund

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_FundTreasuryOverTheCntr.
-- 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: PWUFUNDTO

CREATE VIEW P_FundTreasuryOverTheCntr AS
SELECT
  cast ('11TRMO' as psm_s4c_fm_fund_wu_obj_type_vh) AS FundWhereUsedObjType,
  _Fund.FinancialManagementArea AS FinancialManagementArea,
  Fund,
  ControllingArea,
  FinancialTransaction,
  _FTrans.TermStartDate AS ValidityStartDate,
  _FTrans.TermEndDate AS ValidityEndDate,
  TreasuryAccountingCode,
  TreasuryValuationArea,
  _TreasuryValuationArea.TreasuryValuationAreaName AS TreasuryValuationAreaName,
  FinancialInstrumentProductType,
  _FinancialInstrProdTypeText[ Language = $session.system_language ].FinancialInstrProdTypeName AS FinancialInstrProdTypeName,
  _FTrans.FinancialInstrTransactionType AS FinancialInstrTransactionType,
  _FTrans._FinancialInstrTransType._Text[ Language = $session.system_language ].FinancialInstrTransTypeName AS FinancialInstrTransTypeName,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _Fund._Text[ Language = $session.system_language ].FundName AS FundName
LEFT OUTER JOIN I_FinancialTransaction AS _FTrans ON CompanyCode = _FTrans.CompanyCode AND FinancialTransaction = _FTrans.FinancialTransaction  -- association [1..1]
LEFT OUTER JOIN I_Fund AS _Fund ON ControllingArea = _Fund.FinancialManagementArea AND Fund = _Fund.Fund  -- association [1..1]
;

Learn More