I_SpecValAssgmtWithHeader

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_SpecValAssgmtWithHeader.
-- 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: ISPECVAWHDR
-- Parameters: P_KeyDate : sydate

CREATE VIEW I_SpecValAssgmtWithHeader AS
SELECT
  SpecValAssgmtHdr,
  SpecValAssgmt,
  usg.SpecValAssgmtUsageInternalID AS SpecValAssgmtUsageInternalID,
  header.SpecificationInternalID AS SpecificationInternalID,
  SpecValAssgmtType,
  SpecValAssgmtHdrIsDeleted,
  SpecValAssgmtChangeState,
  SpecValAssgmtValidityStartDate,
  SpecValAssgmtValidityEndDate,
  SpecValAssgmtChangeNumber,
  SpecValAssgmtCreationDate,
  SpecValAssgmtCreatedByUser,
  SpecValAssgmtLastChangeDate,
  SpecValAssgmtLastChangedByUser,
  SpecValAssgmtSortSequence,
  SpecValAssgmtUnitRefDimension,
  SpecValAssgmtIsInhtncSource,
  InhtdSpecValAssgmtIsTmpChgd,
  InhtdSpecValAssgmtIsPermChgd,
  SpecInheritanceTemplate,
  SpecValAssgmtInheritanceParent,
  SpecValAssgmtInheritanceRoot,
  SpecValAssgmtRootSpecIntID,
  SpecValAssgmtIsDeleted,
  usg.SpecificationRating AS SpecificationRating,
  usg.SpecificationValidityArea AS SpecificationValidityArea,
  usg.SpecValAssgmtUsageIsExcluded AS SpecValAssgmtUsageIsExcluded,
  usg.SpecValAssgmtUsageIsActive AS SpecValAssgmtUsageIsActive,
  usg.SpecValAssgmtUsageIsRelevant AS SpecValAssgmtUsageIsRelevant
FROM P_SpecValAssgmtInstanceNormal
LEFT OUTER JOIN I_SpecValAssgmtUsage AS usg ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SpecRating AS _Rating ON SpecificationRating = _Rating.SpecificationRating  -- association [0..1]
LEFT OUTER JOIN I_SpecValidityArea AS _ValidityArea ON SpecificationValidityArea = _ValidityArea.SpecificationValidityArea  -- association [0..1]
LEFT OUTER JOIN I_SpecificationForKeyDate AS _SpecificationForKeyDate ON SpecificationInternalID = _SpecificationForKeyDate.SpecificationInternalID  -- association [0..1]
;