I_SpecValAssgmtHeader

DDL: I_SPECVALASSGMTHEADER SQL: ISPECVAHDR Type: view BASIC
14 Fields 1 Data Sources 2 Associations

Specification Value Assignment Header

I_SpecValAssgmtHeader is a Basic CDS View that provides data about "Specification Value Assignment Header" in SAP S/4HANA. It reads from 1 data source (estvh) and exposes 14 fields with key fields SpecValAssgmtHdr, SpecValAssgmtHdrChangeState. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
estvh estvh from

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_SpecValAssgmt _ValueAssignment $projection.SpecValAssgmtHdr = _ValueAssignment.SpecValAssgmtHdr
[0..1] I_SpecValAssgmtType _ValueAssignmentType $projection.SpecValAssgmtType = _ValueAssignmentType.SpecValAssgmtType

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISPECVAHDR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #BASIC view
EndUserText.label Specification Value Assignment Header view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY SpecValAssgmtHdr recn Unique ID No.
KEY SpecValAssgmtHdrChangeState actn GUID number
SpecificationInternalID recnroot Record number
SpecValAssgmtType estcat Val. Asst Type
SpecValAssgmtHdrIsDeleted delflg DID
SpecValAssgmtHdrValdtyStrtDate valfr Valid From
SpecValAssgmtHdrValdtyEndDate valto Valid To
SpecValAssgmtHdrChangeNumber aennr Change Number
SpecValAssgmtHdrCreationDate crdat Generation Time
SpecValAssgmtHdrCreatedByUser crnam Requester
SpecValAssgmtHdrLastChangeDate upddat Changed On
SpecValAssgmtHdrLastChgdByUser updnam User Name
_ValueAssignment _ValueAssignment
_ValueAssignmentType _ValueAssignmentType

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_SpecValAssgmtHeader.
-- 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: ISPECVAHDR

CREATE VIEW I_SpecValAssgmtHeader AS
SELECT
  recn AS SpecValAssgmtHdr,
  actn AS SpecValAssgmtHdrChangeState,
  recnroot AS SpecificationInternalID,
  estcat AS SpecValAssgmtType,
  delflg AS SpecValAssgmtHdrIsDeleted,
  valfr AS SpecValAssgmtHdrValdtyStrtDate,
  valto AS SpecValAssgmtHdrValdtyEndDate,
  aennr AS SpecValAssgmtHdrChangeNumber,
  crdat AS SpecValAssgmtHdrCreationDate,
  crnam AS SpecValAssgmtHdrCreatedByUser,
  upddat AS SpecValAssgmtHdrLastChangeDate,
  updnam AS SpecValAssgmtHdrLastChgdByUser
FROM estvh
LEFT OUTER JOIN I_SpecValAssgmt AS _ValueAssignment ON SpecValAssgmtHdr = _ValueAssignment.SpecValAssgmtHdr  -- association [1..*]
LEFT OUTER JOIN I_SpecValAssgmtType AS _ValueAssignmentType ON SpecValAssgmtType = _ValueAssignmentType.SpecValAssgmtType  -- association [0..1]
;

Learn More