I_MfgWorkInstructionVarblInfo

DDL: I_MFGWORKINSTRUCTIONVARBLINFO SQL: IMFGWIVARINFO Type: view BASIC
26 Fields 6 Data Sources

Work Instruction Referred Variables

I_MfgWorkInstructionVarblInfo is a Basic CDS View that provides data about "Work Instruction Referred Variables" in SAP S/4HANA. It reads from 6 data sources and exposes 26 fields with key fields MfgWorkInstruction, MfgWorkInstructionVersCounter, MfgWorkInstructionVariable, MfgWorkInstructionPlaceHolder, Language.

Data Sources (6)

SourceAliasJoin Type
mpe_oa_comp _OA_COMP left_outer
mpe_oa_pic _OA_PIC left_outer
mpe_oa_prt _OA_PRT left_outer
I_OpActyWorkInstructionAssgmt _OA_WI inner
I_MfgWorkInstrnPlaceHolder _WIPlaceholder inner
I_MfgWorkInstructionVariable _WIVariable from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMFGWIVARINFO view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Work Instruction Referred Variables view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY MfgWorkInstruction I_MfgWorkInstructionVariable MfgWorkInstruction Work Instruction
KEY MfgWorkInstructionVersCounter I_MfgWorkInstructionVariable MfgWorkInstructionVersCounter Version No.
KEY MfgWorkInstructionVariable I_MfgWorkInstructionVariable MfgWorkInstructionVariable Variable
KEY MfgWorkInstructionPlaceHolder I_MfgWorkInstrnPlaceHolder MfgWorkInstructionPlaceHolder Key Field
KEY Language I_MfgWorkInstrnPlaceHolder Language Report Text Language
SelectedContextType I_MfgWorkInstructionVariable SelectedContextType Var TYpe
MfgWrkInstrnPlchldrCollIntID I_MfgWorkInstrnPlaceHolder MfgWrkInstrnPlchldrCollIntID Document No.
SelectedContextName I_MfgWorkInstrnPlaceHolder SelectedContextName Type
MfgWrkInstrnPlaceHolderIsRef I_MfgWorkInstrnPlaceHolder MfgWrkInstrnPlaceHolderIsRef Value
MfgWrkInstrnPlaceHolderIsLink I_MfgWorkInstrnPlaceHolder MfgWrkInstrnPlaceHolderIsLink URL
WorkInstrnPlaceHolderIsInptFld I_MfgWorkInstrnPlaceHolder WorkInstrnPlaceHolderIsInptFld Attribute Flag
MfgWrkInstrnPlchldrVsblColsStr I_MfgWorkInstrnPlaceHolder MfgWrkInstrnPlchldrVsblColsStr Visible Columns
BOOOpBOMItemInternalID I_MfgWorkInstructionVariable BOOOpBOMItemInternalID Allocation no.
OriglDgtlMockUpCharcsUUID I_MfgWorkInstructionVariable OriglDgtlMockUpCharcsUUID DMU GUID
LogicalComponent I_MfgWorkInstructionVariable LogicalComponent Logical Component
LogicalComponentUUID I_MfgWorkInstructionVariable LogicalComponentUUID
BillOfMaterial I_MfgWorkInstructionVariable BillOfMaterial BOM
BillOfMaterialCategory I_MfgWorkInstructionVariable BillOfMaterialCategory BOM category
BillOfMaterialVariant I_MfgWorkInstructionVariable BillOfMaterialVariant AlternativeBOM
BillOfMaterialVersion I_MfgWorkInstructionVariable BillOfMaterialVersion BOM Version
InheritedNodeNumberForBOMItem I_MfgWorkInstructionVariable InheritedNodeNumberForBOMItem Nodes
InspectionCharacteristicNmbr
BOOCharcGroup I_MfgWorkInstructionVariable BOOCharcGroup Characteristic Group
ProdnRsceToolCounter
ProdMfgInfoCameraInternalID
ProdMfgInfoItemValueUUID

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_MfgWorkInstructionVarblInfo.
-- 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: IMFGWIVARINFO

CREATE VIEW I_MfgWorkInstructionVarblInfo AS
SELECT
  _WIVariable.MfgWorkInstruction AS MfgWorkInstruction,
  _WIVariable.MfgWorkInstructionVersCounter AS MfgWorkInstructionVersCounter,
  _WIVariable.MfgWorkInstructionVariable AS MfgWorkInstructionVariable,
  _WIPlaceholder.MfgWorkInstructionPlaceHolder AS MfgWorkInstructionPlaceHolder,
  _WIPlaceholder.Language AS Language,
  _WIVariable.SelectedContextType AS SelectedContextType,
  _WIPlaceholder.MfgWrkInstrnPlchldrCollIntID AS MfgWrkInstrnPlchldrCollIntID,
  _WIPlaceholder.SelectedContextName AS SelectedContextName,
  _WIPlaceholder.MfgWrkInstrnPlaceHolderIsRef AS MfgWrkInstrnPlaceHolderIsRef,
  _WIPlaceholder.MfgWrkInstrnPlaceHolderIsLink AS MfgWrkInstrnPlaceHolderIsLink,
  _WIPlaceholder.WorkInstrnPlaceHolderIsInptFld AS WorkInstrnPlaceHolderIsInptFld,
  _WIPlaceholder.MfgWrkInstrnPlchldrVsblColsStr AS MfgWrkInstrnPlchldrVsblColsStr,
  _WIVariable.BOOOpBOMItemInternalID AS BOOOpBOMItemInternalID,
  _WIVariable.OriglDgtlMockUpCharcsUUID AS OriglDgtlMockUpCharcsUUID,
  _WIVariable.LogicalComponent AS LogicalComponent,
  _WIVariable.LogicalComponentUUID AS LogicalComponentUUID,
  _WIVariable.BillOfMaterial AS BillOfMaterial,
  _WIVariable.BillOfMaterialCategory AS BillOfMaterialCategory,
  _WIVariable.BillOfMaterialVariant AS BillOfMaterialVariant,
  _WIVariable.BillOfMaterialVersion AS BillOfMaterialVersion,
  _WIVariable.InheritedNodeNumberForBOMItem AS InheritedNodeNumberForBOMItem,
  _WIVariable.BOOCharcGroup AS BOOCharcGroup
FROM I_MfgWorkInstructionVariable AS _WIVariable
INNER JOIN I_OpActyWorkInstructionAssgmt AS _OA_WI ON /* join condition not captured in parsed metadata */
INNER JOIN I_MfgWorkInstrnPlaceHolder AS _WIPlaceholder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN mpe_oa_comp AS _OA_COMP ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN mpe_oa_pic AS _OA_PIC ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN mpe_oa_prt AS _OA_PRT ON /* join condition not captured in parsed metadata */
;

Learn More