R_FundsMgmtFunctionalAreaTP

DDL: R_FUNDSMGMTFUNCTIONALAREATP Type: view_entity TRANSACTIONAL Package: PSM_FM_API
17 Fields 1 Data Sources 3 Associations

Manage Fnds Mgmt Functional Area - TP

R_FundsMgmtFunctionalAreaTP is a Transactional CDS View that provides data about "Manage Fnds Mgmt Functional Area - TP" in SAP S/4HANA. It reads from 1 data source (I_FundsMgmtFunctionalArea) and exposes 17 fields with key field FunctionalArea. It has 3 associations to related views. Part of development package PSM_FM_API.

Data Sources (1)

SourceAliasJoin Type
I_FundsMgmtFunctionalArea iFunctionalArea from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_User _user_created $projection.CreatedByUser = _user_created.UserID
[0..1] I_User _user_changed $projection.LastChangedByUser = _user_changed.UserID
[1..1] E_FndsMgmtFunctionalArea _Extension $projection.FunctionalArea = _Extension.FunctionalArea

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Manage Fnds Mgmt Functional Area - TP view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY FunctionalArea I_FundsMgmtFunctionalArea FunctionalArea Sendr Fctl Area
FunctionalAreaAuthznGrp I_FundsMgmtFunctionalArea FunctionalAreaAuthznGrp Authorization Group
CreatedByUser I_FundsMgmtFunctionalArea CreatedByUser User Name
CreationDate I_FundsMgmtFunctionalArea CreationDate Time Stamp
CreationTime I_FundsMgmtFunctionalArea CreationTime Time of Change
LastChangedByUser I_FundsMgmtFunctionalArea LastChangedByUser User Name
LastChangeDate I_FundsMgmtFunctionalArea LastChangeDate Time Stamp
LastChangeTime I_FundsMgmtFunctionalArea LastChangeTime Time changed
ValidityStartDate I_FundsMgmtFunctionalArea ValidityStartDate Validity Start Date
ValidityEndDate I_FundsMgmtFunctionalArea ValidityEndDate ValidTo
ExpirationDate I_FundsMgmtFunctionalArea ExpirationDate Expiratn Date
CreatedByUserDescription
LastChangedByUserDescription
FunctionalAreaSubdivisionID I_FundsMgmtFunctionalArea FunctionalAreaSubdivisionID Farea Subdivision ID
FunctionalArea1Subdivision I_FundsMgmtFunctionalArea FunctionalArea1Subdivision FN Substring 1
FunctionalArea2Subdivision I_FundsMgmtFunctionalArea FunctionalArea2Subdivision FN Substring 2
FunctionalArea3Subdivision I_FundsMgmtFunctionalArea FunctionalArea3Subdivision FN Substring 3

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 R_FundsMgmtFunctionalAreaTP.
-- 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 R_FundsMgmtFunctionalAreaTP AS
SELECT
  iFunctionalArea.FunctionalArea AS FunctionalArea,
  iFunctionalArea.FunctionalAreaAuthznGrp AS FunctionalAreaAuthznGrp,
  iFunctionalArea.CreatedByUser AS CreatedByUser,
  iFunctionalArea.CreationDate AS CreationDate,
  iFunctionalArea.CreationTime AS CreationTime,
  iFunctionalArea.LastChangedByUser AS LastChangedByUser,
  iFunctionalArea.LastChangeDate AS LastChangeDate,
  iFunctionalArea.LastChangeTime AS LastChangeTime,
  iFunctionalArea.ValidityStartDate AS ValidityStartDate,
  iFunctionalArea.ValidityEndDate AS ValidityEndDate,
  iFunctionalArea.ExpirationDate AS ExpirationDate,
  cast( _user_created.UserDescription as vdm_createdbyuserdescription preserving type ) AS CreatedByUserDescription,
  cast( _user_changed.UserDescription as vdm_lastchangedbyuserdescripti preserving type ) AS LastChangedByUserDescription,
  iFunctionalArea.FunctionalAreaSubdivisionID AS FunctionalAreaSubdivisionID,
  iFunctionalArea.FunctionalArea1Subdivision AS FunctionalArea1Subdivision,
  iFunctionalArea.FunctionalArea2Subdivision AS FunctionalArea2Subdivision,
  iFunctionalArea.FunctionalArea3Subdivision AS FunctionalArea3Subdivision
FROM I_FundsMgmtFunctionalArea AS iFunctionalArea
LEFT OUTER JOIN I_User AS _user_created ON CreatedByUser = _user_created.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _user_changed ON LastChangedByUser = _user_changed.UserID  -- association [0..1]
LEFT OUTER JOIN E_FndsMgmtFunctionalArea AS _Extension ON FunctionalArea = _Extension.FunctionalArea  -- association [1..1]
;

Learn More