I_MfgExecDocumentNote

DDL: I_MFGEXECDOCUMENTNOTE SQL: IMPEEXECNOTE Type: view BASIC Package: MPE_EXEC_COMMON

Manufacturing Execution Document Note

I_MfgExecDocumentNote is a Basic CDS View that provides data about "Manufacturing Execution Document Note" in SAP S/4HANA. It reads from 1 data source (mpe_exec_note) and exposes 5 fields with key fields MfgExecDocumentCategory, ManufacturingExecutionDocument, MfgExecutionDocumentItem. It has 1 association to related views. Part of development package MPE_EXEC_COMMON.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
mpe_exec_note n from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_MfgExecDocumentCategory _MfgExecDocumentCategory $projection.MfgExecDocumentCategory = _MfgExecDocumentCategory.MfgExecDocumentCategory

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IMPEEXECNOTE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Manufacturing Execution Document Note view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY MfgExecDocumentCategory doc_cat
KEY ManufacturingExecutionDocument doc_nmbr
KEY MfgExecutionDocumentItem doc_item
MfgExecutionDocumentNote note
_MfgExecDocumentCategory _MfgExecDocumentCategory 
@AbapCatalog.sqlViewName: 'IMPEEXECNOTE'
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Manufacturing Execution Document Note'
/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ]  } */
define view I_MfgExecDocumentNote
  as select from mpe_exec_note as n
  association [1..1] to I_MfgExecDocumentCategory as _MfgExecDocumentCategory on $projection.MfgExecDocumentCategory = _MfgExecDocumentCategory.MfgExecDocumentCategory
{
  @ObjectModel.foreignKey.association: '_MfgExecDocumentCategory'
  key doc_cat  as MfgExecDocumentCategory,
  key doc_nmbr as ManufacturingExecutionDocument,
  key doc_item as MfgExecutionDocumentItem,
      note     as MfgExecutionDocumentNote,

  _MfgExecDocumentCategory
};

Learn More