P_VariantConfigurationProfile

DDL: P_VARIANTCONFIGURATIONPROFILE Type: view BASIC
28 Fields 1 Data Sources

P_VariantConfigurationProfile is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (cuco) and exposes 28 fields with key fields ConfigurationObject, ConfigurationProfileNumber, ObjectDatabaseTable.

Data Sources (1)

SourceAliasJoin Type
cuco cuco from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PVARCONFPROFILE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #BASIC view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY ConfigurationObject objek Object
KEY ConfigurationProfileNumber zaehl Sort pos.
KEY ObjectDatabaseTable obtab Table
ConfigurationProfileName prfid Rate Profile
ClassType klart Class Type
ClfnOrganizationalArea vview Org.area
ConfigurationProfileStatus status Workflow Status
ConfProfileValidityStartDate datuv Valid-from date
ConfProfileValidityEndDate datub Valid to
VarConfignPrflIsStrtLogoDspd clogo Start logo
VarConfignPrflIsSalesRelevant kdset Set
VarConfignPrflIsOrderBOMRlvt stlkd Order BOM
VarConfignPrflIsRsltOrdBOMRlvt eoasl Result-oriented
BOMExplosionIsOff stldy Pln/prod. order
BOMExplosionIsSingleLevel single Single-level
BOMExplosionIsMultilevel valev Multilevel
BOMExplosionApplication apids BOM Application
ConfignPrflIsOnlyConfigblAssy cbaug Config. assembs
VarConfignPrflUIDesignName design Design
CreatedByUserName ersnu Created By
CreationDateTime ersdt Created On
LastChangedByUser aesbn Changed By
LastChangeDate aedat Obsolete
VarConfignIsDynTaskListExplsn apldy Pln/prod. order
ChangeNumber aennr Change Number
DependencyObjectNumber knobj Assgmt no.
VarConfignPrflIsDeleted kzloe Delete
EngineProcessingMode proc_mode Processing Mode

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_VariantConfigurationProfile.
-- 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.

CREATE VIEW P_VariantConfigurationProfile AS
SELECT
  objek AS ConfigurationObject,
  zaehl AS ConfigurationProfileNumber,
  obtab AS ObjectDatabaseTable,
  prfid AS ConfigurationProfileName,
  klart AS ClassType,
  vview AS ClfnOrganizationalArea,
  status AS ConfigurationProfileStatus,
  datuv AS ConfProfileValidityStartDate,
  datub AS ConfProfileValidityEndDate,
  clogo AS VarConfignPrflIsStrtLogoDspd,
  kdset AS VarConfignPrflIsSalesRelevant,
  stlkd AS VarConfignPrflIsOrderBOMRlvt,
  eoasl AS VarConfignPrflIsRsltOrdBOMRlvt,
  stldy AS BOMExplosionIsOff,
  single AS BOMExplosionIsSingleLevel,
  valev AS BOMExplosionIsMultilevel,
  apids AS BOMExplosionApplication,
  cbaug AS ConfignPrflIsOnlyConfigblAssy,
  design AS VarConfignPrflUIDesignName,
  ersnu AS CreatedByUserName,
  ersdt AS CreationDateTime,
  aesbn AS LastChangedByUser,
  aedat AS LastChangeDate,
  apldy AS VarConfignIsDynTaskListExplsn,
  aennr AS ChangeNumber,
  knobj AS DependencyObjectNumber,
  kzloe AS VarConfignPrflIsDeleted,
  proc_mode AS EngineProcessingMode
FROM cuco
;

Learn More