I_MfgWorkInstructionVersion

DDL: I_MFGWORKINSTRUCTIONVERSION SQL: IMFGWIVERSION Type: view BASIC Package: MPE_WI
13 Fields 2 Data Sources 1 Associations

Work Instruction Basic View

I_MfgWorkInstructionVersion is a Basic CDS View that provides data about "Work Instruction Basic View" in SAP S/4HANA. It reads from 2 data sources (mpe_wi_content, mpe_wi_version) and exposes 13 fields with key fields MfgWorkInstruction, MfgWorkInstructionVersCounter, Language. It has 1 association to related views. Part of development package MPE_WI.

Data Sources (2)

SourceAliasJoin Type
mpe_wi_content Content inner
mpe_wi_version WorkInstructionVersion from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Language _Lang $projection.Language = _Lang.Language

Annotations (10)

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

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY MfgWorkInstruction mpe_wi_version wi_id WorkItem ID
KEY MfgWorkInstructionVersCounter mpe_wi_version wi_version_no Version No.
KEY Language mpe_wi_version spras Off. Language
MfgWorkInstructionContentUUID mpe_wi_version wi_content_uuid Content UUID
MfgWorkInstructionForEdit mpe_wi_version wi_id WorkItem ID
CreationTime mpe_wi_version crea_date_time Time Stamp
CreationUserName mpe_wi_version crea_uname User Name
LastChangeDateTime mpe_wi_version lchg_date_time Time Stamp
LastChangedByUser mpe_wi_version lchg_uname User Name
MfgWorkInstructionContent mpe_wi_content wi_content Content
MfgWorkInstructionVersStatus mpe_wi_version wi_status WI Status
LanguageName
_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 I_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: IMFGWIVERSION

CREATE VIEW I_MfgWorkInstructionVersion AS
SELECT
  WorkInstructionVersion.wi_id AS MfgWorkInstruction,
  WorkInstructionVersion.wi_version_no AS MfgWorkInstructionVersCounter,
  WorkInstructionVersion.spras AS Language,
  WorkInstructionVersion.wi_content_uuid AS MfgWorkInstructionContentUUID,
  WorkInstructionVersion.wi_id AS MfgWorkInstructionForEdit,
  WorkInstructionVersion.crea_date_time AS CreationTime,
  WorkInstructionVersion.crea_uname AS CreationUserName,
  WorkInstructionVersion.lchg_date_time AS LastChangeDateTime,
  WorkInstructionVersion.lchg_uname AS LastChangedByUser,
  Content.wi_content AS MfgWorkInstructionContent,
  WorkInstructionVersion.wi_status AS MfgWorkInstructionVersStatus,
  _Lang._Text[1:LanguageCode=Language].LanguageName AS LanguageName
FROM mpe_wi_version AS WorkInstructionVersion
INNER JOIN mpe_wi_content AS Content ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Language AS _Lang ON Language = _Lang.Language  -- association [1..1]
;

Learn More