P_PubSecCtrlObjProfileCurDate

DDL: P_PUBSECCTRLOBJPROFILECURDATE SQL: PPSMS4CAVCPDT Type: view BASIC Package: PSM_S4C_AVC
3 Fields 2 Data Sources

PSM AVC Profile to Current Date

P_PubSecCtrlObjProfileCurDate is a Basic CDS View that provides data about "PSM AVC Profile to Current Date" in SAP S/4HANA. It reads from 2 data sources (P_PubSecCtrlObjProfileCurDate1, P_PubSecCtrlObjProfileCurDate2) and exposes 3 fields with key fields CompanyCode, BudgetScenario. Part of development package PSM_S4C_AVC.

Data Sources (2)

SourceAliasJoin Type
P_PubSecCtrlObjProfileCurDate1 Main inner
P_PubSecCtrlObjProfileCurDate2 Profile_max_yr from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PPSMS4CAVCPDT 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 (3)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_PubSecCtrlObjProfileCurDate1 CompanyCode Receiver Company Code
KEY BudgetScenario P_PubSecCtrlObjProfileCurDate1 BudgetScenario Budgeting Scenario
AvailabilityControlProfile P_PubSecCtrlObjProfileCurDate1 AvailabilityControlProfile Budget Availability Control Profile

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_PubSecCtrlObjProfileCurDate.
-- 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: PPSMS4CAVCPDT

CREATE VIEW P_PubSecCtrlObjProfileCurDate AS
SELECT
  Main.CompanyCode AS CompanyCode,
  Main.BudgetScenario AS BudgetScenario,
  Main.AvailabilityControlProfile AS AvailabilityControlProfile
FROM P_PubSecCtrlObjProfileCurDate2 AS Profile_max_yr
INNER JOIN P_PubSecCtrlObjProfileCurDate1 AS Main ON /* join condition not captured in parsed metadata */
;

Learn More