P_VariantConfigurationProfile
Variant Configuration: Configuration Profile
P_VariantConfigurationProfile is a Basic CDS View that provides data about "Variant Configuration: Configuration Profile" in SAP S/4HANA. It reads from 1 data source (cuco) and exposes 28 fields with key fields ConfigurationObject, ConfigurationProfileNumber, ObjectDatabaseTable. Part of development package VCH_VDM_MD.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| cuco | cuco | from |
Annotations (7)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA