R_FundsCenterTP

DDL: R_FUNDSCENTERTP Type: view_entity TRANSACTIONAL Package: PSM_FM_API
23 Fields 1 Data Sources 1 Associations

Manage Funds Center - TP

R_FundsCenterTP is a Transactional CDS View that provides data about "Manage Funds Center - TP" in SAP S/4HANA. It reads from 1 data source (I_FundsCenter) and exposes 23 fields with key fields FinancialManagementArea, FundsCenter, ValidityEndDate. It has 1 association to related views. Part of development package PSM_FM_API.

Data Sources (1)

SourceAliasJoin Type
I_FundsCenter iFundsCenter from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_FundsCenter _Extension $projection.FinancialManagementArea = _Extension.FinancialManagementArea and $projection.FundsCenter = _Extension.FundsCenter and $projection.ValidityEndDate = _Extension.ValidityEndDate

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #B 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 Funds Center - TP view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea I_FundsCenter FinancialManagementArea FM Area
KEY FundsCenter I_FundsCenter FundsCenter Funds Center
KEY ValidityEndDate I_FundsCenter ValidityEndDate ValidTo
ValidityStartDate I_FundsCenter ValidityStartDate Validity Start Date
CreatedByUser I_FundsCenter CreatedByUser User Name
CreationDate I_FundsCenter CreationDate Time Stamp
LastChangedByUser I_FundsCenter LastChangeUser User Name
LastChangeDate I_FundsCenter LastChangeDate Time Stamp
FundsCenterExpirationDate I_FundsCenter FundsCenterExpirationDate
FundsCenterManager I_FundsCenter FundsCenterManager
FundsCenterResponsibleName I_FundsCenter FundsCenterResponsibleName
FundsCenterDefaultFund I_FundsCenter FundsCenterDefaultFund
FundsCenterAuthznGrp I_FundsCenter FundsCenterAuthznGrp
FndsCenterFinMgmtAreaForAuthzn I_FundsCenter FndsCenterFinMgmtAreaForAuthzn
CompanyCode I_FundsCenter CompanyCode Receiver Company Code
BusinessArea I_FundsCenter BusinessArea Business Area
FundsCenterName
FundsCenterDescription
_FinMgmtArea I_FundsCenter _FinMgmtArea
_Fund I_FundsCenter _Fund
_Text I_FundsCenter _Text
_CompanyCode I_FundsCenter _CompanyCode
_BusinessArea I_FundsCenter _BusinessArea

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_FundsCenterTP.
-- 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_FundsCenterTP AS
SELECT
  iFundsCenter.FinancialManagementArea AS FinancialManagementArea,
  iFundsCenter.FundsCenter AS FundsCenter,
  iFundsCenter.ValidityEndDate AS ValidityEndDate,
  iFundsCenter.ValidityStartDate AS ValidityStartDate,
  iFundsCenter.CreatedByUser AS CreatedByUser,
  iFundsCenter.CreationDate AS CreationDate,
  iFundsCenter.LastChangeUser AS LastChangedByUser,
  iFundsCenter.LastChangeDate AS LastChangeDate,
  iFundsCenter.FundsCenterExpirationDate AS FundsCenterExpirationDate,
  iFundsCenter.FundsCenterManager AS FundsCenterManager,
  iFundsCenter.FundsCenterResponsibleName AS FundsCenterResponsibleName,
  iFundsCenter.FundsCenterDefaultFund AS FundsCenterDefaultFund,
  iFundsCenter.FundsCenterAuthznGrp AS FundsCenterAuthznGrp,
  iFundsCenter.FndsCenterFinMgmtAreaForAuthzn AS FndsCenterFinMgmtAreaForAuthzn,
  iFundsCenter.CompanyCode AS CompanyCode,
  iFundsCenter.BusinessArea AS BusinessArea,
  iFundsCenter._Text[1:Language = $session.system_language].FundsCenterName AS FundsCenterName,
  iFundsCenter._Text[1:Language = $session.system_language].FundsCenterDescription AS FundsCenterDescription,
  iFundsCenter._FinMgmtArea AS _FinMgmtArea,
  iFundsCenter._Fund AS _Fund,
  iFundsCenter._Text AS _Text,
  iFundsCenter._CompanyCode AS _CompanyCode,
  iFundsCenter._BusinessArea AS _BusinessArea
FROM I_FundsCenter AS iFundsCenter
LEFT OUTER JOIN E_FundsCenter AS _Extension ON FinancialManagementArea = _Extension.FinancialManagementArea AND FundsCenter = _Extension.FundsCenter AND ValidityEndDate = _Extension.ValidityEndDate  -- association [1..1]
;

Learn More