I_Specification

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_Specification.
-- 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: ISPECIFICATION

CREATE VIEW I_Specification AS
SELECT
  estrh.recn AS SpecificationInternalID,
  estrh.actn AS SpecificationChangeState,
  cast(estrh.subid as /plmb/spc_ext_id_no_conv preserving type) AS Specification,
  estrh.valfr AS SpecificationValidityStartDate,
  estrh.valto AS SpecificationValidityEndDate,
  cast(estrh.aennr as /plmb/spc_change_number preserving type ) AS SpecificationChangeNumber,
  estrh.delflg AS SpecificationIsDeleted,
  cast(estrh.crdat as /plmb/spc_created_on preserving type) AS SpecificationCreationDate,
  cast(estrh.crnam as /plmb/spc_created_by preserving type) AS SpecificationCreatedByUser,
  cast(estrh.upddats as /plmb/spc_changed_on preserving type) AS SpecificationLastChangeDate,
  cast(estrh.updnams as /plmb/spc_changed_by preserving type) AS SpecificationLastChangedByUser,
  cast(estrh.subcat as /plmb/spc_type preserving type) AS SpecificationType,
  cast(estrh.subchar as /plmb/spc_subst_natr preserving type ) AS SpecificationSubstanceNatr,
  cast(estrh.authgrp as /plmb/spc_auth_group preserving type ) AS SpecificationAuthznGroup,
  estrh.rem AS SpecificationNote
FROM estrh
INNER JOIN I_SpecificationTypeValidity ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SpecType AS _SpecificationType ON SpecificationType = _SpecificationType.SpecificationType  -- association [0..1]
LEFT OUTER JOIN I_SpecAuthorizationGroup AS _SpecificationAuthGroup ON SpecificationAuthznGroup = _SpecificationAuthGroup.SpecificationAuthznGroup  -- association [0..1]
LEFT OUTER JOIN I_SpecIdentifier AS _Identifier ON SpecificationInternalID = _Identifier.SpecificationInternalID  -- association [0..*]
LEFT OUTER JOIN I_User AS _CreatedByUser ON SpecificationCreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON SpecificationLastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_SpecSubstanceNature AS _SubstanceNature ON SpecificationSubstanceNatr = _SubstanceNature.SpecificationSubstanceNatr  -- association [0..1]
LEFT OUTER JOIN I_SpecAssignedHeaderStatus AS _AssignedHeaderStatus ON SpecificationInternalID = _AssignedHeaderStatus.SpecificationInternalID  -- association [0..1]
LEFT OUTER JOIN I_ChangeMaster AS _ChangeMaster ON SpecificationChangeNumber = _ChangeMaster.ChangeNumber  -- association [0..1]
LEFT OUTER JOIN I_SpecAssignedMaterial AS _SpecAssignedMaterial ON SpecificationInternalID = _SpecAssignedMaterial.SpecificationInternalID  -- association [0..*]
LEFT OUTER JOIN I_DocumentInfoRecordObjectLink AS _DocumentInfoRecordObjectLink ON Specification = _DocumentInfoRecordObjectLink.LinkedSAPObjectKey AND _DocumentInfoRecordObjectLink.LinkedSAPObject = 'ESTRH'  -- association [0..*]
LEFT OUTER JOIN I_RecipeFormulaItem AS _RecipeFormulaItem ON SpecificationInternalID = _RecipeFormulaItem.SpecificationInternalID  -- association [0..1]
LEFT OUTER JOIN I_LogAccMObjectTypeActive AS _LogAccMObjectTypeActive ON _LogAccMObjectTypeActive.LogAccMObjectType = 'PLM_RSPSUB'  -- association [0..1]
LEFT OUTER JOIN I_LogAccMObjSecureIDAssgmt AS _LogAccMObjSecureIDAssgmt ON SpecificationInternalID = _LogAccMObjSecureIDAssgmt.LogAccMObjectID AND _LogAccMObjSecureIDAssgmt.LogAccMObjectType = 'PLM_RSPSUB'  -- association [0..*]
LEFT OUTER JOIN I_LogAccMObjectUserAuthzn AS _LogAccMObjectUserAuthzn ON SpecificationInternalID = _LogAccMObjectUserAuthzn.LogAccMObjectID AND _LogAccMObjectUserAuthzn.LogAccMObjectType = 'PLM_RSPSUB' AND _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject = 'PLM_SPC' AND _LogAccMObjectUserAuthzn.LogAccMReadActivityIsEnabled = 'X' AND _LogAccMObjectUserAuthzn.LogAccMUserAuthznField = 'ACTVT' AND _LogAccMObjectUserAuthzn.UserID = $session.user  -- association [0..*]
;