I_AvailabilityCtrlProfile

DDL: I_AVAILABILITYCTRLPROFILE SQL: IFIAVCPRFL Type: view BASIC Package: FINS_FIS_FICO
6 Fields 1 Data Sources 2 Associations

Budget Availability Control Profile

I_AvailabilityCtrlProfile (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Public Edition with built-in and side-by-side extension capabilities.

Budget Availability Control Profile · Accounting and Financial Close

I_AvailabilityCtrlProfile is a Basic CDS View (Dimension) that provides data about "Budget Availability Control Profile" in SAP S/4HANA. It reads from 1 data source (finsc_avc_prof) and exposes 6 fields with key field AvailabilityControlProfile. It has 2 associations to related views. Part of development package FINS_FIS_FICO.

SAP Help Documentation

CategoryCDS Views for Overhead Accounting
Purpose
You can use this CDS view to display information about Budget Availability Control Profiles. A Budget Availability Control Profile is a coded representation, which defines a profile to control the availability of a budget. It specifies which G/L accounts and which activity groups are checked, the thresholds (in percentage) of available budget, and whether errors or warnings are issued when thresholds are reached. The following is a Code Value example, which is defined in the profile: AvailabilityControlProfile : E9001 AvailabilityControlProfileType : PS AvailyCtrlTimeRangeType : 1 BudgetCurrencyRole : 30 Budget availability control helps you avoid budget exceedances in projects and cost centers. This CDS view provides the data to answer the following business questions: Which budget availability control profiles are defined in the system? Which currency types are considered in the budget availability control? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations One of the following business catalogs needs to be assigned to a user to be able to use this CDS view: SAP_FIN_BC_OH_REP_CCA_PC SAP_PS_BC_PROJ_FIN_ANLYTC_MC Configuration To use Budget Availability Control for your projects and cost centers, you must maintain data in several configuration steps. For more information, see: Configuration Steps for Projects Configuration Steps for Cost Centers

Structure
Fields used for filtering The main filters are as follows: AvailabilityControlProfile AvailabilityControlProfileType Further important fields Important fields in this view include the following: Field Name Description AvailyCtrlTimeRangeType Availability Control Time Range Type BudgetCurrencyRole Budget Currency Role

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-GL-IS-2CL
CapabilitiesData Source in SQL Select,Data Source for Defining CDS Entities,Association Target for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageAccounting and Financial Close for SAP S/4HANA Cloud Public Edition
Description <p>You can use this CDS view to display information about Budget Availability Control Profiles.</p> <p>A Budget Availability Control Profile is a coded representation, which defines a profile to control the availability of a budget. It specifies which G/L accounts and which activity groups are checked, the thresholds (in percentage) of available budget, and whether errors or warnings are issued when thresholds are reached. </p> The following is a Code Value example, which is defined in the profile:<ul> <li> <p>AvailabilityControlProfile: E9001</p> </li> <li> <p>AvailabilityControlProfileType: PS</p> </li> <li> <p>AvailyCtrlTimeRangeType: 1</p> </li> <li> <p>BudgetCurrencyRole : 30</p> </li> </ul> <p>Budget availability control helps you avoid budget exceedances in projects and cost centers.</p> This CDS view provides the data to answer the following business questions:<ul> <li> <p>Which budget availability control profiles are defined in the system?</p> </li> <li> <p>Which currency types are considered in the budget availability control? </p> </li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
finsc_avc_prof finsc_avc_prof from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_AvailabilityCtrlProfileText _Text $projection.AvailabilityControlProfile = _Text.AvailabilityControlProfile
[0..*] I_AvailyCtrlProfileSemanticTag _SemanticTag $projection.AvailabilityControlProfile = _SemanticTag.AvailabilityControlProfile

Annotations (16)

NameValueLevelField
EndUserText.label Budget Availability Control Profile view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IFIAVCPRFL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey AvailabilityControlProfile view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AbapCatalog.preserveKey true view
ObjectModel.sapObjectNodeType.name BdgtAvailabilityControlProfile view
AbapCatalog.compiler.compareFilter true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY AvailabilityControlProfile profile Budget Availability Control: Profile
AvailabilityControlProfileType profile_type Budget Availability Control: Profile Type
AvailyCtrlTimeRangeType time_range Budget Availability Control: Time Range
BudgetCurrencyRole budget_currency_type Budget Availability Control: Budget Currency Type
_Text _Text
_SemanticTag _SemanticTag

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 I_AvailabilityCtrlProfile.
-- 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: IFIAVCPRFL

CREATE VIEW I_AvailabilityCtrlProfile AS
SELECT
  profile AS AvailabilityControlProfile,
  profile_type AS AvailabilityControlProfileType,
  time_range AS AvailyCtrlTimeRangeType,
  budget_currency_type AS BudgetCurrencyRole
FROM finsc_avc_prof
LEFT OUTER JOIN I_AvailabilityCtrlProfileText AS _Text ON AvailabilityControlProfile = _Text.AvailabilityControlProfile  -- association [0..*]
LEFT OUTER JOIN I_AvailyCtrlProfileSemanticTag AS _SemanticTag ON AvailabilityControlProfile = _SemanticTag.AvailabilityControlProfile  -- association [0..*]
;

Learn More