I_EngSnpshtHdr

@AbapCatalog.sqlViewName: 'IENGSNPHDR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Engineering Snapshot Header'
@ObjectModel.usageType: {serviceQuality: #C,
                         dataClass: #MIXED,
                         sizeCategory: #L}
@VDM.viewType:#BASIC

define view I_EngSnpshtHdr
  as select from mpe_snp_hdr as Header
{
  key Header.uuid                  as EngSnapshotUUID,
      Header.snapshot_id           as EngSnapshotID,
      Header.snapshot_name         as EngSnapshotName,
      Header.snapshot_type         as EngSnapshotType,
      Header.matnr                 as Material,
      Header.werks                 as Plant,
      Header.stlan                 as BillOfMaterialVariantUsage,
      Header.stlal                 as BillOfMaterialVariant,
      Header.dokar                 as DocumentInfoRecordDocType,
      Header.doknr                 as DocumentInfoRecordDocNumber,
      Header.doktl                 as DocumentInfoRecordDocPart,
      Header.plan_scope_documentid as PlanningScopeInternalID,
      Header.plan_scope_alt        as PlanningScopeAlternative,
      Header.revn_nmbr             as EngSnpshtRevisionNumber,
      Header.aux_prep_sts          as EngSnpshtAuxiliaryPrepSts,
      Header.chg_prep_sts          as EngSnpshtChangePrepSts,
      Header.prpsd_effective_date  as EngSnpshtProposedEffectiveDate,
      Header.created_by            as CreatedByUser,
      Header.created_at            as CreationDateTime,
      Header.changed_by            as LastChangedByUser,
      Header.changed_at            as LastChangeDateTime
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MPE_SNP_HDR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/