I_InspectionMethodVersion

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_InspectionMethodVersion.
-- 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_InspectionMethodVersion AS
SELECT
  qmtb.werks AS InspectionMethodPlant,
  qmtb.pmtnr AS InspectionMethod,
  qmtb.version AS InspectionMethodVersion,
  qmtb.gueltigab AS InspectionMethodValidFromDate,
  qmtb.sortfeld AS InspectionMethodSearchField,
  qmtb.loekz AS InspectionMethodStatus,
  qmtb.prfql AS InspectorQualification,
  qmtb.dummy10 AS InspMethInformationField1,
  qmtb.dummy20 AS InspMethInformationField2,
  qmtb.dummy40 AS InspMethInformationField3,
  qmtb.qauth AS QltyMstrDataAuthorizationGroup,
  qmtb.autor AS CreatedByUser,
  qmtb.dates AS CreationDate,
  qmtb.aeaut AS LastChangedByUser,
  qmtb.datae AS LastChangeDate,
  case qmtb.changeddatetime when 0 then cast( '19000101010101' as tzntstmps ) else qmtb.changeddatetime end as ChangedDateTime AS changeddatetimeendasChangedDateTime
FROM qmtb
LEFT OUTER JOIN I_InspectionMethod AS _InspectionMethod ON InspectionMethodPlant = _InspectionMethod.InspectionMethodPlant AND InspectionMethod = _InspectionMethod.InspectionMethod  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _InspectionMethodPlant ON InspectionMethodPlant = _InspectionMethodPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_InspectionMethodVersionText AS _InspectionMethodText ON InspectionMethodPlant = _InspectionMethodText.InspectionMethodPlant AND InspectionMethod = _InspectionMethodText.InspectionMethod AND InspectionMethodVersion = _InspectionMethodText.InspectionMethodVersion  -- association [1..*]
LEFT OUTER JOIN I_InspectionMstrDataStatus AS _InspectionMethodStatus ON InspectionMethodStatus = _InspectionMethodStatus.InspectionMasterDataStatus  -- association [0..1]
LEFT OUTER JOIN I_InspectionMstrDataStatusText AS _InspectionMethodStatusText ON InspectionMethodStatus = _InspectionMethodStatusText.InspectionMasterDataStatus  -- association [0..*]
LEFT OUTER JOIN I_InspectorQualification AS _InspectorQualification ON InspectorQualification = _InspectorQualification.InspectorQualification  -- association [0..1]
LEFT OUTER JOIN I_InspectorQualificationText AS _InspectorQualificationText ON InspectorQualification = _InspectorQualificationText.InspectorQualification  -- association [0..*]
LEFT OUTER JOIN I_QltyMstrDataAuthorizationGrp AS _QltyMstrDataAuthznGrp ON QltyMstrDataAuthorizationGroup = _QltyMstrDataAuthznGrp.QltyMstrDataAuthorizationGroup  -- association [0..1]
LEFT OUTER JOIN I_QltyMstrDataAuthznGroupTxt AS _QltyMstrDataAuthznGrpTxt ON QltyMstrDataAuthorizationGroup = _QltyMstrDataAuthznGrpTxt.QltyMstrDataAuthorizationGroup  -- association [0..*]
LEFT OUTER JOIN I_User AS _InspMethCreatedByUser ON CreatedByUser = _InspMethCreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _InspMethLastChangedByUser ON LastChangedByUser = _InspMethLastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUserContactCard ON CreatedByUser = _CreatedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangedByUserContactCard ON LastChangedByUser = _LastChangedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN E_InspectionMethodVersion AS _Extension ON InspectionMethodPlant = _Extension.InspectionMethodPlant AND InspectionMethod = _Extension.InspectionMethod AND InspectionMethodVersion = _Extension.InspectionMethodVersion  -- association [1..1]
;