I_VarCnfHistoricalProfileBasic

DDL: I_VARCNFHISTORICALPROFILEBASIC Type: view BASIC Package: VCH_VDM_MD_CP
18 Fields 1 Data Sources

Historical Variant Configuration Profile

I_VarCnfHistoricalProfileBasic is a Basic CDS View that provides data about "Historical Variant Configuration Profile" in SAP S/4HANA. It reads from 1 data source (cuco) and exposes 18 fields with key fields VariantConfigurationObject, VarConfigurationProfileName, ChangeNumber, ObjectDatabaseTable. Part of development package VCH_VDM_MD_CP.

Data Sources (1)

SourceAliasJoin Type
cuco cuco from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IVCHCPBSC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Historical Variant Configuration Profile view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY VariantConfigurationObject objek Object
KEY VarConfigurationProfileName prfid Rate Profile
KEY ChangeNumber aennr Change Number
KEY ObjectDatabaseTable obtab Table
VarConfigurationProfileNumber zaehl Sort pos.
ClassType klart Class Type
VarConfigurationProfileStatus status Workflow Status
ValidityStartDate datuv Valid-from date
ValidityEndDate datub Valid to
IsDeleted kzloe Delete
BOMExplosionApplication apids BOM Application
VarCnfProfilePriorityValue prio Profile priority
ObjDpnAssignmentNumber knobj Assgmt no.
CreationDate ersdt Created On
CreatedByUser ersnu Created By
LastChangeDate aedat Obsolete
LastChangedByUser aesbn Changed By
LastChangeDateTime lastchangedatetime Timestamp

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 I_VarCnfHistoricalProfileBasic.
-- 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 I_VarCnfHistoricalProfileBasic AS
SELECT
  objek AS VariantConfigurationObject,
  prfid AS VarConfigurationProfileName,
  aennr AS ChangeNumber,
  obtab AS ObjectDatabaseTable,
  zaehl AS VarConfigurationProfileNumber,
  klart AS ClassType,
  status AS VarConfigurationProfileStatus,
  datuv AS ValidityStartDate,
  datub AS ValidityEndDate,
  kzloe AS IsDeleted,
  apids AS BOMExplosionApplication,
  prio AS VarCnfProfilePriorityValue,
  knobj AS ObjDpnAssignmentNumber,
  ersdt AS CreationDate,
  ersnu AS CreatedByUser,
  aedat AS LastChangeDate,
  aesbn AS LastChangedByUser,
  LastChangeDateTime
FROM cuco
;

Learn More