C_FndsMgmtAnnBdgtActlDets

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_FndsMgmtAnnBdgtActlDets.
-- 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: CFMANNBGTDDPST

CREATE VIEW C_FndsMgmtAnnBdgtActlDets AS
SELECT
  FinancialManagementArea,
  AvailabilityControlLedger,
  FinMgmtAreaFiscalYear,
  BdgtCashEffectivityFiscalYear,
  ControlObjectCoverGroup,
  ControlObjectGrantID,
  ControlObjectFund,
  ControlObjectBudgetPeriod,
  ControlObjectFundsCenter,
  ControlObjectCommitmentItem,
  ControlObjectFunctionalArea,
  ControlObjectFundedProgram,
  CtrlObjFundsMgmtCustomerField,
  FinancialManagementAreaCrcy,
  FundsMgmtJournalEntry,
  FundsMgmtJournalEntryItem,
  Ledger,
  FundsMgmtAmountType,
  FundsMgmtRefDocumentCategory,
  ReferenceDocumentType,
  RefDocAccountAssignment,
  ReferenceDocumentScheduleLine,
  RefDocPricingElementContent,
  ReferenceDocumentLogicalSystem,
  ReferenceDocumentContext,
  FundsMgmtLongSequenceNumber,
  cast(_ControlObjectGrantID._Text[1:Language=$session.system_language].GrantName as gmis_grant_nbr_name preserving type) AS CtrlObjGrantName,
  _ControlObjectFund.FundType AS CtrlObjFundType,
  cast(_ControlObjectFund._Text[1:Language=$session.system_language].FundName as fmis_fund_name preserving type) AS CtrlObjFundName,
  cast(_ControlObjectBudgetPeriod._Text[1:Language=$session.system_language].BudgetPeriodName as fm_budget_period_name preserving type) AS CtrlObjBudgetPeriodName,
  cast(_ControlObjectFundsCenter._Text[1:Language=$session.system_language].FundsCenterName as fmis_fc_name preserving type) AS CtrlObjFundsCenterName,
  cast(_ControlObjectCommitmentItem.CommitmentItemCategory as fmis_ctrlobj_cmmtitem_category preserving type) AS CtrlObjCommitmentItemCategory,
  cast(_ControlObjectCommitmentItem._Text[1:Language=$session.system_language].CommitmentItemName as fmis_commitment_item_name preserving type) AS CtrlObjCommitmentItemName,
  cast(_ControlObjectFunctionalArea._Text[1:Language=$session.system_language].FunctionalAreaName as fis_fkbtx preserving type) AS CtrlObjFunctionalAreaName,
  cast(_ControlObjectFundedProgram._Text[1:Language=$session.system_language].FundedProgramName as fmis_fp_name preserving type) AS CtrlObjFundedProgramName,
  PostedGrantID,
  PostedFund,
  PostedBudgetPeriod,
  PostedFundsCenter,
  PostedCommitmentItem,
  PostedFunctionalArea,
  PostedFundedProgram,
  PostedFundsMgmtCustomerField,
  CompanyCode,
  FundsMgmtValueType,
  CashEffectivityFiscalYear,
  BusinessTransactionType,
  FundsMgCarryForwardLevel,
  GLAccount,
  BusinessArea,
  ProfitCenter,
  ControllingArea,
  Segment,
  FinMgmtAreaPeriod,
  cast( -1 * PostedAmountInFMACrcy as fm_fkbtr ) AS PostedAmountInFMACrcy,
  NumberOfDocumentItems,
  GrantLifecycleStatus,
  GrantLfcycStatusForAuthzn,
  GrantAuthznGrp,
  GrantIsNotRelevantGrant,
  FundFinMgmtAreaForAuthzn,
  FundAuthznGrp,
  BudgetPeriodAuthznGrp,
  FndsCenterFinMgmtAreaForAuthzn,
  FundsCenterAuthznGrp,
  CmtmtItemFinMgmtAreaForAuthzn,
  CommitmentItemAuthznGrp,
  FunctionalAreaAuthznGrp,
  FundedPgmFinMgmtAreaForAuthzn,
  FundedProgramAuthznGrp
FROM I_FndsMgmtAnnBdgtActlDets
;