C_LastValidFundsCenterWST

DDL: C_LASTVALIDFUNDSCENTERWST SQL: CLVFNDSCENTERWST Type: view CONSUMPTION
12 Fields 1 Data Sources

Last Valid Funds Center with Session Language Texts

C_LastValidFundsCenterWST is a Consumption CDS View that provides data about "Last Valid Funds Center with Session Language Texts" in SAP S/4HANA. It reads from 1 data source (C_FundsCenterWST) and exposes 12 fields with key fields FinancialManagementArea, FundsCenter.

Data Sources (1)

SourceAliasJoin Type
C_FundsCenterWST C_FundsCenterWST from

Annotations (11)

NameValueLevelField
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.sqlViewName CLVFNDSCENTERWST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Last Valid Funds Center with Session Language Texts view
UI.headerInfo.typeName Is Default in Funds Centers view
UI.headerInfo.typeNamePlural Is Default in Funds Centers view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea C_FundsCenterWST FinancialManagementArea Financial Management Area
KEY FundsCenter C_FundsCenterWST FundsCenter Funds Center
ValidityEndDate
ValidityStartDate C_FundsCenterWST ValidityStartDate Validity Start Date
FundsCenterResponsible C_FundsCenterWST FundsCenterResponsible Responsible Person
FundsCenterResponsibleName C_FundsCenterWST FundsCenterResponsibleName Responsible Person Name
FundsCenterDefaultFund C_FundsCenterWST FundsCenterDefaultFund Default Fund
FundsCenterAuthznGrp C_FundsCenterWST FundsCenterAuthznGrp
FndsCenterFinMgmtAreaForAuthzn C_FundsCenterWST FndsCenterFinMgmtAreaForAuthzn
FundsCenterName C_FundsCenterWST FundsCenterName Funds Center Name
FundsCenterExtendedName C_FundsCenterWST FundsCenterExtendedName
FundsCenterDescription C_FundsCenterWST FundsCenterDescription

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 C_LastValidFundsCenterWST.
-- 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: CLVFNDSCENTERWST

CREATE VIEW C_LastValidFundsCenterWST AS
SELECT
  C_FundsCenterWST.FinancialManagementArea AS FinancialManagementArea,
  C_FundsCenterWST.FundsCenter AS FundsCenter,
  max (C_FundsCenterWST.ValidityEndDate) AS ValidityEndDate,
  C_FundsCenterWST.ValidityStartDate AS ValidityStartDate,
  C_FundsCenterWST.FundsCenterResponsible AS FundsCenterResponsible,
  C_FundsCenterWST.FundsCenterResponsibleName AS FundsCenterResponsibleName,
  C_FundsCenterWST.FundsCenterDefaultFund AS FundsCenterDefaultFund,
  C_FundsCenterWST.FundsCenterAuthznGrp AS FundsCenterAuthznGrp,
  C_FundsCenterWST.FndsCenterFinMgmtAreaForAuthzn AS FndsCenterFinMgmtAreaForAuthzn,
  C_FundsCenterWST.FundsCenterName AS FundsCenterName,
  C_FundsCenterWST.FundsCenterExtendedName AS FundsCenterExtendedName,
  C_FundsCenterWST.FundsCenterDescription AS FundsCenterDescription
FROM C_FundsCenterWST
;

Learn More