C_MfgWorkInstructionVersion

DDL: C_MFGWORKINSTRUCTIONVERSION SQL: CMFGWIVERLANG Type: view CONSUMPTION Package: MPE_WI
13 Fields 4 Data Sources 1 OData Services

Work Instruction Consumption View

C_MfgWorkInstructionVersion is a Consumption CDS View that provides data about "Work Instruction Consumption View" in SAP S/4HANA. It reads from 4 data sources (I_ProcgExecOperationActivity, I_ShopFloorItemAtOpActy, I_MfgWorkInstructionVersion, I_MfgWorkInstructionVersionTP) and exposes 13 fields with key fields WorkInstruction, WorkInstructionVersionCounter, Language, OpActyNtwkElement, OpActyNtwkInstance. It is exposed through 1 OData service (UI_OPACTYSFIGROUP_EXECUTE). Part of development package MPE_WI.

Data Sources (4)

SourceAliasJoin Type
I_ProcgExecOperationActivity _OA inner
I_ShopFloorItemAtOpActy _SFI left_outer
I_MfgWorkInstructionVersion _WI from
I_MfgWorkInstructionVersionTP _WIVer inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CMFGWIVERLANG view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Work Instruction Consumption View view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

OData Services (1)

ServiceBindingVersionContractRelease
UI_OPACTYSFIGROUP_EXECUTE UI_OPACTYSFIGROUP_EXECUTE V2 C1 NOT_RELEASED

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY WorkInstruction I_MfgWorkInstructionVersion MfgWorkInstruction Work Instruction
KEY WorkInstructionVersionCounter I_MfgWorkInstructionVersion MfgWorkInstructionVersCounter Version No.
KEY Language I_MfgWorkInstructionVersion Language Report Text Language
KEY OpActyNtwkElement I_ProcgExecOperationActivity OpActyNtwkElement Element Number
KEY OpActyNtwkInstance I_ProcgExecOperationActivity OpActyNtwkInstance Instance ID
KEY ShopFloorItemendasShopFloorItem
MfgWorkInstructionContent I_MfgWorkInstructionVersion MfgWorkInstructionContent Content
LanguageName I_MfgWorkInstructionVersion LanguageName Name
MfgWorkInstructionMode I_MfgWorkInstructionVersionTP MfgWorkInstructionMode
ProductionPlant I_ShopFloorItemAtOpActy ProductionPlant Prod plnt
WorkCenter I_ShopFloorItemAtOpActy WorkCenter Work Center
OpActyNtwkSegmentType I_ShopFloorItemAtOpActy OpActyNtwkSegmentType
_Lang _Lang

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 C_MfgWorkInstructionVersion.
-- 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: CMFGWIVERLANG

CREATE VIEW C_MfgWorkInstructionVersion AS
SELECT
  _WI.MfgWorkInstruction AS WorkInstruction,
  _WI.MfgWorkInstructionVersCounter AS WorkInstructionVersionCounter,
  _WI.Language AS Language,
  _OA.OpActyNtwkElement AS OpActyNtwkElement,
  _OA.OpActyNtwkInstance AS OpActyNtwkInstance,
  case _SFI.ShopFloorItem when 0 then 0 else _SFI.ShopFloorItem end as ShopFloorItem AS ShopFloorItemendasShopFloorItem,
  _WI.MfgWorkInstructionContent AS MfgWorkInstructionContent,
  _WI.LanguageName AS LanguageName,
  _WIVer.MfgWorkInstructionMode AS MfgWorkInstructionMode,
  _SFI.ProductionPlant AS ProductionPlant,
  _SFI.WorkCenter AS WorkCenter,
  _SFI.OpActyNtwkSegmentType AS OpActyNtwkSegmentType
FROM I_MfgWorkInstructionVersion AS _WI
INNER JOIN I_ProcgExecOperationActivity AS _OA ON /* join condition not captured in parsed metadata */
INNER JOIN I_MfgWorkInstructionVersionTP AS _WIVer ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ShopFloorItemAtOpActy AS _SFI ON /* join condition not captured in parsed metadata */
;

Learn More