I_ENGSNPSHTHDR

CDS View

Engineering Snapshot Header

I_ENGSNPSHTHDR is a CDS View in S/4HANA. Engineering Snapshot Header. It contains 10 fields. 10 CDS views read from this table.

Used by 10 CDS view(s) 10 fields

CDS Views using this table (10)

ViewTypeJoinVDMDescription
I_ChgRecdRefEngSnpshtTP view inner TRANSACTIONAL Change Record Ref Object Eng Snapshot
I_ChgRecdRefMfgSnpshtTP view inner TRANSACTIONAL Change Record Ref Obj Mfg Snapshot - TP
I_EngSnpshtEBOM view inner COMPOSITE Engineering snapshot EBOMs
I_EngSnpshtEBOMWithoutHdrEBOM view inner COMPOSITE EBOMs linked to Engineering snapshot without header EBOM
I_EngSnpshtHdrEBOM view inner COMPOSITE Engineering snapshot header EBOM
I_EngSnpshtLatestRevision view from COMPOSITE Engineering Snapshot Latest Revision
I_EngSnpshtRefDoc view inner COMPOSITE Engineering Snapshot Ref Obj Document
I_EngSnpshtRefEngBOM view inner COMPOSITE Engineering Snapshot Reference Obj EBOM
I_EngSnpshtRefMfgBOM view inner COMPOSITE Engineering Snapshot Reference Obj MBOM
P_ChgRecdSnapshotObjRef view inner COMPOSITE Snapshots Obj Ref assigned to Chg Record

Fields (10)

KeyField CDS FieldsUsed in Views
BillOfMaterialVariant BillOfMaterialVariant,EngSnpshtHdrEBOMVariant 4
BillOfMaterialVariantUsage BillOfMaterialVariantUsage,EngSnpshtHdrEBOMVariantUsage 4
EngSnapshotID EngSnapshotID 7
EngSnapshotType EngSnapshotType 4
EngSnapshotUUID EngSnapshotUUID 2
EngSnpshtAuxiliaryPrepSts EngSnpshtAuxiliaryPrepSts 3
EngSnpshtProposedEffectiveDate EngSnpshtProposedEffectiveDate 1
EngSnpshtRevisionNumber EngSnpshtRevisionNumber 7
Material EngSnpshtHdrEBOMMaterial,Material 4
Plant EngSnpshtHdrEBOMPlant,Plant 4 
@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
}

Learn More