I_VarCnfHistlConstraintNet

DDL: I_VARCNFHISTLCONSTRAINTNET Type: view_entity COMPOSITE
15 Fields 1 Data Sources 3 Associations

Historical Constraint Net

I_VarCnfHistlConstraintNet is a Composite CDS View that provides data about "Historical Constraint Net" in SAP S/4HANA. It reads from 1 data source (I_VarCnfHistlCstrtNetBasic) and exposes 15 fields with key fields VarCnfConstraintNetName, ChangeNumber. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_VarCnfHistlCstrtNetBasic I_VarCnfHistlCstrtNetBasic from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_VarCnfObjDpndcyStatusText _StatusText _StatusText.ObjectDependencyStatus = $projection.ObjectDependencyStatus
[0..*] I_VarCnfObjDependencyGroupText _GroupText _GroupText.ObjectDependencyGroup = $projection.ObjectDependencyGroup
[0..*] I_VarCnfObjDpnAuthznGroupText _AuthorizationGroupText _AuthorizationGroupText.ObjDpndcyAuthorizationGroup = $projection.ObjDpndcyAuthorizationGroup

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Historical Constraint Net view
ObjectModel.representativeKey VarCnfConstraintNetName view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY VarCnfConstraintNetName VarCnfConstraintNetName Dependency
KEY ChangeNumber ChangeNumber Change Number
ObjectDependencyStatus ObjectDependencyStatus Status
ObjectDependencyGroup ObjectDependencyGroup Dependency Grp
ObjDpndcyAuthorizationGroup ObjDpndcyAuthorizationGroup Maint. Auth.
CreationDate CreationDate Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangedByUser LastChangedByUser User Name
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
IsDeleted IsDeleted TRUE
_StatusText _StatusText
_GroupText _GroupText
_AuthorizationGroupText _AuthorizationGroupText

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_VarCnfHistlConstraintNet.
-- 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_VarCnfHistlConstraintNet AS
SELECT
  VarCnfConstraintNetName,
  ChangeNumber,
  ObjectDependencyStatus,
  ObjectDependencyGroup,
  ObjDpndcyAuthorizationGroup,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  ValidityStartDate,
  ValidityEndDate,
  IsDeleted
FROM I_VarCnfHistlCstrtNetBasic
LEFT OUTER JOIN I_VarCnfObjDpndcyStatusText AS _StatusText ON _StatusText.ObjectDependencyStatus = ObjectDependencyStatus  -- association [0..*]
LEFT OUTER JOIN I_VarCnfObjDependencyGroupText AS _GroupText ON _GroupText.ObjectDependencyGroup = ObjectDependencyGroup  -- association [0..*]
LEFT OUTER JOIN I_VarCnfObjDpnAuthznGroupText AS _AuthorizationGroupText ON _AuthorizationGroupText.ObjDpndcyAuthorizationGroup = ObjDpndcyAuthorizationGroup  -- association [0..*]
;

Learn More