I_SpecValAssgmt

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_SpecValAssgmt.
-- 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: ISPECVA

CREATE VIEW I_SpecValAssgmt AS
SELECT
  recn AS SpecValAssgmt,
  actn AS SpecValAssgmtChangeState,
  recnroot AS SpecificationInternalID,
  recntvh AS SpecValAssgmtHdr,
  valfr AS SpecValAssgmtValidityStartDate,
  valto AS SpecValAssgmtValidityEndDate,
  aennr AS SpecValAssgmtChangeNumber,
  crdat AS SpecValAssgmtCreationDate,
  crnam AS SpecValAssgmtCreatedByUser,
  upddat AS SpecValAssgmtLastChangeDate,
  updnam AS SpecValAssgmtLastChangedByUser,
  ord AS SpecValAssgmtSortSequence,
  comprel AS SpecValAssgmtUnitRefDimension,
  comprel AS SpecValAssgmtRefValueCode,
  flg_inhsrc AS SpecValAssgmtIsInhtncSource,
  flg_inhovr AS InhtdSpecValAssgmtIsTmpChgd,
  flg_inhexcl AS InhtdSpecValAssgmtIsPermChgd,
  recn_tplh AS SpecInheritanceTemplate,
  recntva_src AS SpecValAssgmtInheritanceParent,
  recntva_orig AS SpecValAssgmtInheritanceRoot,
  recnroot_orig AS SpecValAssgmtRootSpecIntID,
  tpl_ord AS SpecInheritanceTmplSortSeq,
  delflg AS SpecValAssgmtIsDeleted
FROM estva
LEFT OUTER JOIN I_SpecValAssgmtReferenceValue AS _SpecValAssgmtReferenceValue ON SpecValAssgmtRefValueCode = _SpecValAssgmtReferenceValue.SpecValAssgmtRefValueCode  -- association [0..1]
;