I_MfgWrkInstrnInspCharcInfoTP

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_MfgWrkInstrnInspCharcInfoTP.
-- 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: IEMBWIPICINFOTP

CREATE VIEW I_MfgWrkInstrnInspCharcInfoTP AS
SELECT
  MfgWorkInstruction,
  MfgWorkInstructionVersCounter,
  MfgWorkInstructionVariable,
  ProdnRtgVersBOMInternalID,
  SelectedContextType,
  cast ('0000' as qmerknrp preserving type) AS InspectionCharacteristicNmbr,
  cast ( ' ' as qchargroup preserving type) AS BOOCharcGroup,
  cast ( ' ' as qtolunc preserving type) AS InspSpecLowerLimit,
  cast ( ' ' as qmasseh ) AS InspectionSpecificationUnit,
  cast ( ' ' as qmerknr preserving type) AS InspectionSpecification,
  cast ( ' ' as qtxt_cha preserving type) AS InspectionCharacteristicText,
  cast ( ' ' as qsollwertc preserving type) AS InspSpecTargetValue,
  cast ( ' ' as qtolobc preserving type) AS InspSpecUpperLimit,
  cast(' ' as qcgrausw preserving type) AS SelectedCodeSet,
  cast(' ' as qkzqunmk preserving type ) AS InspSpecIsQuantitative,
  cast ( ' ' as qchargroupdesc preserving type) AS InspCharcGrpDesc,
  cast ( '0000' as qdivisionint preserving type ) AS BOOCharcGroupDivision,
  cast ( ' ' as qdivisiondesc preserving type) AS InspCharcGrpDivnDesc,
  cast ( '0000' as qchargroup_cref preserving type) AS BOOCharcSourceCharc,
  cast ( 0 as mpe_group_column_no ) AS OpActyCharcGrpSqnc,
  cast ( 0 as mpe_division_seq_no ) AS OpActyCharcDivnSqnc,
  cast( 0 as tzntstmps ) AS CreationDateTime,
  cast( ' ' as usnam preserving type) AS ChangedBy,
  cast( 0 as tzntstmps ) AS LastChangeDateTime,
  cast(' ' as flag preserving type ) AS MfgIsItemSelected,
  cast(' ' as mseh6 preserving type ) AS UnitOfMeasureTechnicalName,
  cast( ' ' as idnrk preserving type) AS BillOfMaterialComponent,
  cast (' ' as maktx preserving type) AS BillOfMaterialComponentName,
  BOOOpBOMItemInternalID,
  OriglDgtlMockUpCharcsUUID,
  cast(' ' as mpe_rtgv_bom_ref_designator preserving type ) AS ReferenceDesignatorValue,
  cast(' ' as fhktx preserving type ) AS ProductionResourceToolDesc,
  ' ' AS ProdnRsceToolCategory,
  cast (' ' as fhmnr preserving type ) AS ProductionResourceTool,
  cast('' as qspcmk preserving type ) AS InspSpecHasControlChart
FROM I_MfgWorkInstructionVariable
LEFT OUTER JOIN I_OpActyWorkInstructionTP AS _OpActyWorkinstructionTP ON MfgWorkInstruction = _OpActyWorkinstructionTP.MfgWorkInstruction AND MfgWorkInstructionVersCounter = _OpActyWorkinstructionTP.MfgWorkInstructionVersCounter  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _Unit ON InspectionSpecificationUnit = _Unit.UnitOfMeasure  -- association [1..1]
;