I_MfgWorkInstructionVersion

DDL: I_MFGWORKINSTRUCTIONVERSION SQL: IMFGWIVERSION Type: view BASIC

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.

2 data source(s) 13 fields

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
KEY MfgWorkInstructionVersCounter mpe_wi_version wi_version_no
KEY Language mpe_wi_version spras
MfgWorkInstructionContentUUID mpe_wi_version wi_content_uuid
MfgWorkInstructionForEdit mpe_wi_version wi_id
CreationTime mpe_wi_version crea_date_time
CreationUserName mpe_wi_version crea_uname
LastChangeDateTime mpe_wi_version lchg_date_time
LastChangedByUser mpe_wi_version lchg_uname
MfgWorkInstructionContent mpe_wi_content wi_content
MfgWorkInstructionVersStatus mpe_wi_version wi_status
LanguageName
_Lang _Lang 
@AbapCatalog.sqlViewName: 'IMFGWIVERSION'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Work Instruction Basic View'
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_MfgWorkInstructionVersion
  as select from mpe_wi_version as WorkInstructionVersion
    inner join   mpe_wi_content as Content on WorkInstructionVersion.wi_content_uuid = Content.wi_content_uuid
  association [1..1] to I_Language as _Lang on $projection.Language = _Lang.Language
{
  key  WorkInstructionVersion.wi_id                                       as MfgWorkInstruction,
  key  WorkInstructionVersion.wi_version_no                               as MfgWorkInstructionVersCounter,
       @ObjectModel.foreignKey.association: '_Lang'
       @ObjectModel.text.element: ['LanguageName']
  key  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,                                              
       _Lang
     
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LANGUAGE",
"I_LANGUAGETEXT",
"MPE_WI_CONTENT",
"MPE_WI_VERSION"
],
"ASSOCIATED":
[
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More