A_FundsCenter

DDL: A_FUNDSCENTER Type: view_entity COMPOSITE Package: PSM_FM_API
17 Fields 1 Data Sources 1 Associations 1 OData Services

Funds Center

A_FundsCenter is a Composite CDS View that provides data about "Funds Center" in SAP S/4HANA. It reads from 1 data source (R_FundsCenterTP) and exposes 17 fields with key fields FinancialManagementArea, FundsCenter, ValidityEndDate. It has 1 association to related views. It is exposed through 1 OData service (API_FUNDSCENTER). Part of development package PSM_FM_API.

Data Sources (1)

SourceAliasJoin Type
R_FundsCenterTP R_FundsCenterTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] A_FundsCenterText _Text $projection.FinancialManagementArea = _Text.FinancialManagementArea and $projection.FundsCenter = _Text.FundsCenter and $projection.ValidityEndDate = _Text.ValidityEndDate

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
OData.entityType.name FundsCenter_Type view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #COMPOSITE view
EndUserText.label Funds Center view

OData Services (1)

ServiceBindingVersionContractRelease
API_FUNDSCENTER API_FUNDSCENTER V2 C2 C1

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea FinancialManagementArea FM Area
KEY FundsCenter FundsCenter Funds Center
KEY ValidityEndDate ValidityEndDate ValidTo
ValidityStartDate ValidityStartDate Validity Start Date
CreationDate CreationDate Time Stamp
LastChangeDate LastChangeDate Time Stamp
FundsCenterName FundsCenterName
FundsCenterDescription FundsCenterDescription
FundsCenterExpirationDate FundsCenterExpirationDate
FundsCenterManager FundsCenterManager
FundsCenterResponsibleName FundsCenterResponsibleName
FundsCenterDefaultFund FundsCenterDefaultFund
FundsCenterAuthznGrp FundsCenterAuthznGrp
FndsCenterFinMgmtAreaForAuthzn FndsCenterFinMgmtAreaForAuthzn
CompanyCode CompanyCode Receiver Company Code
BusinessArea BusinessArea Business Area
_Text _Text

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 A_FundsCenter.
-- 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 A_FundsCenter AS
SELECT
  FinancialManagementArea,
  FundsCenter,
  ValidityEndDate,
  ValidityStartDate,
  CreationDate,
  LastChangeDate,
  FundsCenterName,
  FundsCenterDescription,
  FundsCenterExpirationDate,
  FundsCenterManager,
  FundsCenterResponsibleName,
  FundsCenterDefaultFund,
  FundsCenterAuthznGrp,
  FndsCenterFinMgmtAreaForAuthzn,
  CompanyCode,
  BusinessArea
FROM R_FundsCenterTP
LEFT OUTER JOIN A_FundsCenterText AS _Text ON FinancialManagementArea = _Text.FinancialManagementArea AND FundsCenter = _Text.FundsCenter AND ValidityEndDate = _Text.ValidityEndDate  -- association [0..*]
;

Learn More