What is C_MyFMOvrlAlertDrillPost in SAP S/4HANA?

C_MyFMOvrlAlertDrillPost is a consumption CDS view in SAP S/4HANA. FM Ovrl Alert, FM Drilldown per User It contains 56 fields.

Which tables does C_MyFMOvrlAlertDrillPost read from?

C_MyFMOvrlAlertDrillPost reads data from: I_MyFMOvrlAlertDrillPost.

What VDM layer is C_MyFMOvrlAlertDrillPost?

C_MyFMOvrlAlertDrillPost is classified as a Consumption view optimized for specific business scenarios and reporting.

C_MyFMOvrlAlertDrillPost

DDL: C_MYFMOVRLALERTDRILLPOST SQL: CMYFMOVLALTDDPST Type: view CONSUMPTION

56 Fields 1 Data Sources

FM Ovrl Alert, FM Drilldown per User

C_MyFMOvrlAlertDrillPost is a Consumption CDS View that provides data about "FM Ovrl Alert, FM Drilldown per User" in SAP S/4HANA. It reads from 1 data source (I_MyFMOvrlAlertDrillPost) and exposes 56 fields with key fields FinancialManagementArea, AvailabilityControlLedger, FinMgmtAreaFiscalYear, BdgtCashEffectivityFiscalYear, ControlObjectCoverGroup.

Data Sources (1)

Source	Alias	Join Type
I_MyFMOvrlAlertDrillPost	I_MyFMOvrlAlertDrillPost	from

Parameters (1)

Name	Type	Default
P_BudgetUsageThldInPercent	buavc_budget_usage

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	CMYFMOVLALTDDPST	view
ClientHandling.type	#CLIENT_DEPENDENT	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
VDM.viewType	#CONSUMPTION	view
VDM.private	false	view
OData.publish	true	view
EndUserText.label	FM Ovrl Alert, FM Drilldown per User	view

Fields (56)

Key	Field	Source Table	Source Field	Description
KEY	FinancialManagementArea		FinancialManagementArea	FM Area
KEY	AvailabilityControlLedger		AvailabilityControlLedger
KEY	FinMgmtAreaFiscalYear		FinMgmtAreaFiscalYear	Fiscal Year
KEY	BdgtCashEffectivityFiscalYear		BdgtCashEffectivityFiscalYear
KEY	ControlObjectCoverGroup		ControlObjectCoverGroup
KEY	ControlObjectGrantID		ControlObjectGrantID
KEY	ControlObjectFund		ControlObjectFund
KEY	ControlObjectBudgetPeriod		ControlObjectBudgetPeriod
KEY	ControlObjectFundsCenter		ControlObjectFundsCenter
KEY	ControlObjectCommitmentItem		ControlObjectCommitmentItem
KEY	ControlObjectFunctionalArea		ControlObjectFunctionalArea
KEY	ControlObjectFundedProgram		ControlObjectFundedProgram
KEY	CtrlObjFundsMgmtCustomerField		CtrlObjFundsMgmtCustomerField
KEY	FinancialManagementAreaCrcy		FinancialManagementAreaCrcy	FM Area Currency
KEY	FundsMgmtJournalEntry		FundsMgmtJournalEntry
KEY	FundsMgmtJournalEntryItem		FundsMgmtJournalEntryItem
KEY	Ledger		Ledger	Ledger
KEY	FundsMgmtAmountType		FundsMgmtAmountType
KEY	FundsMgmtRefDocumentCategory		FundsMgmtRefDocumentCategory
KEY	ReferenceDocumentType		ReferenceDocumentType	Reference Document Type
KEY	RefDocAccountAssignment		RefDocAccountAssignment
KEY	ReferenceDocumentScheduleLine		ReferenceDocumentScheduleLine	Schedule Line
KEY	RefDocPricingElementContent		RefDocPricingElementContent
KEY	ReferenceDocumentLogicalSystem		ReferenceDocumentLogicalSystem	Ref. Doc. Lgcl Syst.
KEY	ReferenceDocumentContext		ReferenceDocumentContext	Reference Document Context
KEY	FundsMgmtLongSequenceNumber		FundsMgmtLongSequenceNumber
	CtrlObjGrantName
	CtrlObjFundType	_ControlObjectFund	FundType	Fund Type
	CtrlObjFundName
	CtrlObjBudgetPeriodName
	CtrlObjFundsCenterName
	CtrlObjCommitmentItemCategory
	CtrlObjCommitmentItemName
	CtrlObjFunctionalAreaName
	CtrlObjFundedProgramName
	PostedGrantID		PostedGrantID
	PostedFund		PostedFund
	PostedBudgetPeriod		PostedBudgetPeriod
	PostedFundsCenter		PostedFundsCenter
	PostedCommitmentItem		PostedCommitmentItem
	PostedFunctionalArea		PostedFunctionalArea
	PostedFundedProgram		PostedFundedProgram
	PostedFundsMgmtCustomerField		PostedFundsMgmtCustomerField
	CompanyCode		CompanyCode	Receiver Company Code
	FundsMgmtValueType		FundsMgmtValueType
	CashEffectivityFiscalYear		CashEffectivityFiscalYear
	BusinessTransactionType		BusinessTransactionType	Bus.transaction
	FundsMgCarryForwardLevel		FundsMgCarryForwardLevel
	GLAccount		GLAccount	General Ledger
	BusinessArea		BusinessArea	Business Area
	ProfitCenter		ProfitCenter	Profit Center
	ControllingArea		ControllingArea	Controlling Area
	Segment		Segment	Segment number
	FinMgmtAreaPeriod		FinMgmtAreaPeriod
	PostedAmountInFMACrcy
	NumberOfDocumentItems		NumberOfDocumentItems

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_MyFMOvrlAlertDrillPost.
-- 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: CMYFMOVLALTDDPST
-- Parameters: P_BudgetUsageThldInPercent : buavc_budget_usage

CREATE VIEW C_MyFMOvrlAlertDrillPost 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
FROM I_MyFMOvrlAlertDrillPost
;

Depth:

C_MyFMOvrlAlertDrillPost view

I_MyFMOvrlAlertDrillPost view