P_PubSecCtrlObjProfileCurDate1

DDL: P_PUBSECCTRLOBJPROFILECURDATE1 SQL: PPSMS4CAVCPDT1 Type: view BASIC
5 Fields 3 Data Sources

P_PubSecCtrlObjProfileCurDate1 is a Basic CDS View in SAP S/4HANA. It reads from 3 data sources (psm_d_avc_prf_as, I_CompanyCode, I_FiscalCalendarDate) and exposes 5 fields with key fields CompanyCode, FiscalYear, BudgetScenario, year_from.

Data Sources (3)

SourceAliasJoin Type
psm_d_avc_prf_as Avc_as inner
I_CompanyCode Cc from
I_FiscalCalendarDate FyDt inner

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PPSMS4CAVCPDT1 view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
AbapCatalog.buffering.status #NOT_ALLOWED view
VDM.viewType #BASIC view
VDM.private true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear I_FiscalCalendarDate FiscalYear G/L Fiscal Year
KEY BudgetScenario psm_d_avc_prf_as budget_scenario Budgeting Scenario
KEY year_from psm_d_avc_prf_as year_from Year of Budget Consumption
AvailabilityControlProfile psm_d_avc_prf_as profile WBS sched. prof

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 P_PubSecCtrlObjProfileCurDate1.
-- 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: PPSMS4CAVCPDT1

CREATE VIEW P_PubSecCtrlObjProfileCurDate1 AS
SELECT
  Cc.CompanyCode AS CompanyCode,
  FyDt.FiscalYear AS FiscalYear,
  Avc_as.budget_scenario AS BudgetScenario,
  Avc_as.year_from AS year_from,
  Avc_as.profile AS AvailabilityControlProfile
FROM I_CompanyCode AS Cc
INNER JOIN I_FiscalCalendarDate AS FyDt ON /* join condition not captured in parsed metadata */
INNER JOIN psm_d_avc_prf_as AS Avc_as ON /* join condition not captured in parsed metadata */
;

Learn More