A_FndsMgmtBudgetStructure

DDL: A_FNDSMGMTBUDGETSTRUCTURE Type: view_entity COMPOSITE
31 Fields 1 Data Sources

Budget Structure

A_FndsMgmtBudgetStructure is a Composite CDS View that provides data about "Budget Structure" in SAP S/4HANA. It reads from 1 data source (R_FndsMgmtBudgetStructureTP) and exposes 31 fields with key field BudgetStructureEntryDocUUID.

Data Sources (1)

SourceAliasJoin Type
R_FndsMgmtBudgetStructureTP R_FndsMgmtBudgetStructureTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Budget Structure view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #COMPOSITE view
OData.entityType.name BudgetStructure_Type view
Metadata.ignorePropagatedAnnotations true view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY BudgetStructureEntryDocUUID BudgetStructureEntryDocUUID Document Number
FinancialManagementArea FinancialManagementArea FM Area
BudgetStructure BudgetStructure
BudgetCategory BudgetCategory Plan Category
FinMgmtAreaFiscalYear FinMgmtAreaFiscalYear Fiscal Year
FndsMgmtAddressDescription FndsMgmtAddressDescription FM Address Description
Fund Fund Sender Fund
BudgetPeriod BudgetPeriod Budget Period
FundsCenter FundsCenter Funds Center
CommitmentItem CommitmentItem Commitment item
FunctionalArea FunctionalArea Sendr Fctl Area
FundedProgram FundedProgram Funded Program
GrantID GrantID Sender Grant
FundsManagementCustomerField FundsManagementCustomerField Customer Field
BudgetStructureElement BudgetStructureElement Fnds Mgmt Account Assignment
FndsMgmtAddressIsPostingAddr FndsMgmtAddressIsPostingAddr Posting Address
FndsMgmtAddressIsBudgetAddress FndsMgmtAddressIsBudgetAddress Budget Address
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
LastChangeDateTime LastChangeDateTime Timestamp
CommitmentItemFiscalYear CommitmentItemFiscalYear Commit. Item FY
_Fund _Fund
_CommitmentItem _CommitmentItem
_BudgetPeriod _BudgetPeriod
_FunctionalArea _FunctionalArea
_FundedProgram _FundedProgram
_FundsCenter _FundsCenter
_Grant _Grant

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_FndsMgmtBudgetStructure.
-- 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_FndsMgmtBudgetStructure AS
SELECT
  BudgetStructureEntryDocUUID,
  FinancialManagementArea,
  BudgetStructure,
  BudgetCategory,
  FinMgmtAreaFiscalYear,
  FndsMgmtAddressDescription,
  Fund,
  BudgetPeriod,
  FundsCenter,
  CommitmentItem,
  FunctionalArea,
  FundedProgram,
  GrantID,
  FundsManagementCustomerField,
  BudgetStructureElement,
  FndsMgmtAddressIsPostingAddr,
  FndsMgmtAddressIsBudgetAddress,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  LastChangeDateTime,
  CommitmentItemFiscalYear
FROM R_FndsMgmtBudgetStructureTP
;

Learn More