I_MfgWorkInstructionVariable

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_MfgWorkInstructionVariable.
-- 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: IMPEWIVARBL

CREATE VIEW I_MfgWorkInstructionVariable AS
SELECT
  WIVariable.wi_id AS MfgWorkInstruction,
  WIVariable.wi_version_no AS MfgWorkInstructionVersCounter,
  WIVariable.wi_variable AS MfgWorkInstructionVariable,
  WIVariable.plmb_zuonr AS ProdnRtgVersBOMInternalID,
  WIVariable.variable_type AS SelectedContextType,
  WIVariable.merknr AS InspectionCharacteristicNmbr,
  WIVariable.pzlfh AS ProdnRsceToolCounter,
  WIVariable.plmz_zuonr AS BOOOpBOMItemInternalID,
  WIVariable.chargroup AS BOOCharcGroup,
  WIVariable.inst_guid AS OriglDgtlMockUpCharcsUUID,
  WIVariable.log_comp_counter AS LogicalComponent,
  WIVariable.camera_counter AS ProdMfgInfoCameraInternalID,
  WIVariable.item_val_guid AS ProdMfgInfoItemValueUUID,
  WIVariable.stlty AS BillOfMaterialCategory,
  cast(WIVariable.stlnr as abap.char(8)) AS BillOfMaterial,
  WIVariable.stlal AS BillOfMaterialVariant,
  WIVariable.bom_versn AS BillOfMaterialVersion,
  WIVariable.stvkn AS InheritedNodeNumberForBOMItem
FROM mpe_wi_varbl AS WIVariable
LEFT OUTER JOIN I_MfgWorkInstructionInternalID AS _WorkInstructionInternalId ON MfgWorkInstruction = _WorkInstructionInternalId.MfgWorkInstruction  -- association [1..1]
LEFT OUTER JOIN I_MfgWrkInstrnVarblAttribute AS _MfgWrkInstrnVarblAttribute ON SelectedContextType = _MfgWrkInstrnVarblAttribute.MfgWrkInstrnVariableType  -- association [0..*]
;