I_EngSnpshtObjRef

DDL: I_ENGSNPSHTOBJREF SQL: IENGSNPOBJREF Type: view BASIC

Engineering Snapshot Object Reference

I_EngSnpshtObjRef is a Basic CDS View that provides data about "Engineering Snapshot Object Reference" in SAP S/4HANA. It reads from 1 data source (mpe_snp_obj_ref) and exposes 12 fields with key field EngSnapshotRefUUID.

Data Sources (1)

SourceAliasJoin Type
mpe_snp_obj_ref reference from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IENGSNPOBJREF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Engineering Snapshot Object Reference view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY EngSnapshotRefUUID mpe_snp_obj_ref uuid
EngSnapshotUUID mpe_snp_obj_ref hdr_uuid
EngSnpshtRefType mpe_snp_obj_ref type
EngSnpshtRefKey1 mpe_snp_obj_ref ref_key1
EngSnpshtRefKey2 mpe_snp_obj_ref ref_key2
EngSnpshtRefKey3 mpe_snp_obj_ref ref_key3
EngSnpshtRefKey4 mpe_snp_obj_ref ref_key4
EngSnpshtRefKey5 mpe_snp_obj_ref ref_key5
CreatedByUser mpe_snp_obj_ref created_by
CreationDateTime mpe_snp_obj_ref created_at
LastChangedByUser mpe_snp_obj_ref changed_by
LastChangeDateTime mpe_snp_obj_ref changed_at
@AbapCatalog.sqlViewName: 'IENGSNPOBJREF'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Engineering Snapshot Object Reference'
@ObjectModel.usageType: {serviceQuality: #C,
                         dataClass: #MIXED,
                         sizeCategory: #L}
@VDM.viewType:#BASIC

define view I_EngSnpshtObjRef
  as select from mpe_snp_obj_ref as reference
{
  key reference.uuid       as EngSnapshotRefUUID,
      reference.hdr_uuid   as EngSnapshotUUID,
      reference.type       as EngSnpshtRefType,
      reference.ref_key1   as EngSnpshtRefKey1,
      reference.ref_key2   as EngSnpshtRefKey2,
      reference.ref_key3   as EngSnpshtRefKey3,
      reference.ref_key4   as EngSnpshtRefKey4,
      reference.ref_key5   as EngSnpshtRefKey5,
      reference.created_by as CreatedByUser,
      reference.created_at as CreationDateTime,
      reference.changed_by as LastChangedByUser,
      reference.changed_at as LastChangeDateTime
}