P_AVC_ConfigurationProfiles

DDL: P_AVC_CONFIGURATIONPROFILES SQL: PAVCCONFPROFILE Type: view CONSUMPTION
16 Fields 2 Data Sources 1 Associations

P_AVC_ConfigurationProfiles is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (P_ConfigurationCount, I_ConfigurationProfile) and exposes 16 fields with key fields ProductConfiguration, ObjectDatabaseTable, ConfigurationProfileNumber. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
P_ConfigurationCount _ConfigurationCount inner
I_ConfigurationProfile ConfigurationProfiles from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_User _UserFullName $projection.LastChangedByUser = _UserFullName.UserID

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PAVCCONFPROFILE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ProductConfiguration I_ConfigurationProfile ProductConfiguration Object
KEY ObjectDatabaseTable I_ConfigurationProfile ObjectDatabaseTable Table
KEY ConfigurationProfileNumber I_ConfigurationProfile ConfigurationProfileNumber Sort pos.
ConfigurationProfileName I_ConfigurationProfile ConfigurationProfileName Rate Profile
ConfigurationProfileStatus I_ConfigurationProfile ConfigurationProfileStatus Workflow Status
LastChangedByUser I_ConfigurationProfile LastChangedByUser User Name
LastChangeDate I_ConfigurationProfile LastChangeDate Time Stamp
ConfigurationProfileProcess I_ConfigurationProfile ConfigurationProfileProcess
BOMExplosionLevel I_ConfigurationProfile BOMExplosionLevel
BOMExplosionApplication I_ConfigurationProfile BOMExplosionApplication BOM Application
ConfProfileValidityStartDate I_ConfigurationProfile ConfProfileValidityStartDate Valid-from date
ConfProfileValidityEndDate I_ConfigurationProfile ConfProfileValidityEndDate Valid to
DependencyObjectNumber I_ConfigurationProfile DependencyObjectNumber Assgmt no.
EngineProcessingMode I_ConfigurationProfile EngineProcessingMode Processing Mode
UserFullName _UserFullName UserDescription Full Name
ClassType ClassType X Flag

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_AVC_ConfigurationProfiles.
-- 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: PAVCCONFPROFILE

CREATE VIEW P_AVC_ConfigurationProfiles AS
SELECT
  ConfigurationProfiles.ProductConfiguration AS ProductConfiguration,
  ConfigurationProfiles.ObjectDatabaseTable AS ObjectDatabaseTable,
  ConfigurationProfiles.ConfigurationProfileNumber AS ConfigurationProfileNumber,
  ConfigurationProfiles.ConfigurationProfileName AS ConfigurationProfileName,
  ConfigurationProfiles.ConfigurationProfileStatus AS ConfigurationProfileStatus,
  ConfigurationProfiles.LastChangedByUser AS LastChangedByUser,
  ConfigurationProfiles.LastChangeDate AS LastChangeDate,
  ConfigurationProfiles.ConfigurationProfileProcess AS ConfigurationProfileProcess,
  ConfigurationProfiles.BOMExplosionLevel AS BOMExplosionLevel,
  ConfigurationProfiles.BOMExplosionApplication AS BOMExplosionApplication,
  ConfigurationProfiles.ConfProfileValidityStartDate AS ConfProfileValidityStartDate,
  ConfigurationProfiles.ConfProfileValidityEndDate AS ConfProfileValidityEndDate,
  ConfigurationProfiles.DependencyObjectNumber AS DependencyObjectNumber,
  ConfigurationProfiles.EngineProcessingMode AS EngineProcessingMode,
  _UserFullName.UserDescription AS UserFullName,
  ClassType
FROM I_ConfigurationProfile AS ConfigurationProfiles
INNER JOIN P_ConfigurationCount AS _ConfigurationCount ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_User AS _UserFullName ON LastChangedByUser = _UserFullName.UserID  -- association [1..1]
;

Learn More