I_ABOPVariantDraft

DDL: I_ABOPVARIANTDRAFT SQL: IABOPVARIANTD Type: view BASIC

BOP Variant Draft

I_ABOPVariantDraft is a Basic CDS View that provides data about "BOP Variant Draft" in SAP S/4HANA. It reads from 2 data sources (abopvariant_d, I_DraftAdministrativeData) and exposes 12 fields with key field ABOPVariantUUID.

2 data source(s) 12 fields

Data Sources (2)

SourceAliasJoin Type
abopvariant_d DraftDocument from
I_DraftAdministrativeData I_DraftAdministrativeData inner

Annotations (9)

NameValueLevelField
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IABOPVARIANTD view
EndUserText.label BOP Variant Draft view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
ObjectModel.representativeKey ABOPVariantUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY ABOPVariantUUID abopvariant_d abopvariantuuid
ActiveABOPVariantUUID
ABOPVariantName abopvariant_d abopvariantname
ABOPVariantHRFProcedure abopvariant_d abopvarianthrfprocedure
ABOPVariantProcedure abopvariant_d abopvariantprocedure
CreationDateTime abopvariant_d creationdatetime
CreatedByUser abopvariant_d createdbyuser
LastChangeDateTime abopvariant_d lastchangedatetime
LastChangedByUser abopvariant_d lastchangedbyuser
ABOPFallbackVariantUUID abopvariant_d abopfallbackvariantuuid
ABOPDeliveryGroupHandling abopvariant_d abopdeliverygrouphandling
HasActiveEntity abopvariant_d hasactiveentity 
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'IABOPVARIANTD'
@EndUserText.label: 'BOP Variant Draft'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@ObjectModel: {
    representativeKey: 'ABOPVariantUUID',
    usageType: {
      serviceQuality: #C,
      sizeCategory: #M,
      dataClass: #MASTER
    }
}
define view I_ABOPVariantDraft
  as select from abopvariant_d             as DraftDocument
    inner join   I_DraftAdministrativeData as I_DraftAdministrativeData on I_DraftAdministrativeData.DraftUUID = DraftDocument.abopvariantuuid

{
  key DraftDocument.abopvariantuuid                                   as ABOPVariantUUID,
      cast(hextobin('00000000000000000000000000000000') as sysuuid_x) as ActiveABOPVariantUUID,
      DraftDocument.abopvariantname                                   as ABOPVariantName,
      DraftDocument.abopvarianthrfprocedure                           as ABOPVariantHRFProcedure,
      DraftDocument.abopvariantprocedure                              as ABOPVariantProcedure,
      DraftDocument.creationdatetime                                  as CreationDateTime,
      DraftDocument.createdbyuser                                     as CreatedByUser,
      DraftDocument.lastchangedatetime                                as LastChangeDateTime,
      DraftDocument.lastchangedbyuser                                 as LastChangedByUser,
      DraftDocument.abopfallbackvariantuuid                           as ABOPFallbackVariantUUID,
      DraftDocument.abopdeliverygrouphandling                         as ABOPDeliveryGroupHandling,
      DraftDocument.hasactiveentity                                   as HasActiveEntity
}
where
     I_DraftAdministrativeData.CreatedByUser   = $session.user
  or I_DraftAdministrativeData.InProcessByUser = $session.user

Learn More