P_FundTreasurySecurities

DDL: P_FUNDTREASURYSECURITIES Type: view COMPOSITE Package: ODATA_PSM_S4C_FM_WHRUSED_FUND
16 Fields 1 Associations

WUFUND Treasury Postion - Securities

P_FundTreasurySecurities is a Composite CDS View that provides data about "WUFUND Treasury Postion - Securities" in SAP S/4HANA. It has 1 association to related views. Part of development package ODATA_PSM_S4C_FM_WHRUSED_FUND.

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Fund _Fund $projection.ControllingArea = _Fund.FinancialManagementArea and $projection.Fund = _Fund.Fund

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PWUFUNDTRSYSECU view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label WUFUND Treasury Postion - Securities view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY FundWhereUsedObjType
KEY FinancialManagementArea _Fund FinancialManagementArea FM Area
KEY Fund Fund Sender Fund
KEY ControllingArea ControllingArea Controlling Area
KEY SecurityClass SecurityClass
KEY SecurityAccount SecurityAccount
KEY TreasuryValuationArea TreasuryValuationArea
TreasuryValuationAreaName TreasuryValuationAreaName
CompanyCode CompanyCode Receiver Company Code
FinancialInstrumentProductType FinancialInstrumentProductType
FinancialInstrProdTypeName FinancialInstrProdTypeName
ValidityStartDate StartDate Valid From
ValidityEndDate EndDate Term to
CompanyCodeName 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_FundTreasurySecurities.
-- 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_FundTreasurySecurities AS
SELECT
  '12TRMS' AS FundWhereUsedObjType,
  _Fund.FinancialManagementArea AS FinancialManagementArea,
  Fund,
  ControllingArea,
  SecurityClass,
  SecurityAccount,
  TreasuryValuationArea,
  TreasuryValuationAreaName,
  CompanyCode,
  FinancialInstrumentProductType,
  FinancialInstrProdTypeName,
  StartDate AS ValidityStartDate,
  EndDate AS ValidityEndDate,
  CompanyCodeName,
  _Fund._Text[ 1: Language = $session.system_language ].FundName AS FundName
LEFT OUTER JOIN I_Fund AS _Fund ON ControllingArea = _Fund.FinancialManagementArea AND Fund = _Fund.Fund  -- association [1..1]
;

Learn More