I_AbopVariantSegmentDraft

DDL: I_ABOPVARIANTSEGMENTDRAFT SQL: IABOPVARSEGD Type: view BASIC

ABOP Variant Segments Draft

I_AbopVariantSegmentDraft is a Basic CDS View that provides data about "ABOP Variant Segments Draft" in SAP S/4HANA. It reads from 2 data sources (abopvarseg_d, I_DraftAdministrativeData) and exposes 9 fields with key field ABOPVariantSegmentUUID.

Data Sources (2)

SourceAliasJoin Type
abopvarseg_d DraftDocument from
I_DraftAdministrativeData I_DraftAdministrativeData inner

Annotations (9)

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

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ABOPVariantSegmentUUID abopvarseg_d abopvariantsegmentuuid
ABOPVariantUUID abopvarseg_d abopvariantuuid
ABOPSegmentUUID abopvarseg_d abopsegmentuuid
ABOPSegmentEvaluationSequence abopvarseg_d abopsegmentevaluationsequence
ABOPSegmentCheckSequence abopvarseg_d abopsegmentchecksequence
ABOPConfirmationStrategy abopvarseg_d abopconfirmationstrategy
IsGlobalSegment abopvarseg_d isglobalsegment
IsExceptionalSegment abopvarseg_d isexceptionalsegment
HasActiveEntity abopvarseg_d hasactiveentity
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'IABOPVARSEGD'
@EndUserText.label: 'ABOP Variant Segments Draft'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@ObjectModel: {
    representativeKey: 'ABOPVariantSegmentUUID',
    usageType: {
      serviceQuality: #C,
      sizeCategory: #M,
      dataClass: #MASTER
    }
}
define view I_AbopVariantSegmentDraft
  as select from abopvarseg_d              as DraftDocument
    inner join   I_DraftAdministrativeData as I_DraftAdministrativeData on I_DraftAdministrativeData.DraftUUID = DraftDocument.abopvariantuuid

{
  key DraftDocument.abopvariantsegmentuuid        as ABOPVariantSegmentUUID,
      //      DraftDocument.activeuuid                    as ActiveUUID,

      DraftDocument.abopvariantuuid               as ABOPVariantUUID,
      //      DraftDocument.activeabopvariantuuid         as ActiveABOPVariantUUID,

      DraftDocument.abopsegmentuuid               as ABOPSegmentUUID,
      DraftDocument.abopsegmentevaluationsequence as ABOPSegmentEvaluationSequence,
      DraftDocument.abopsegmentchecksequence      as ABOPSegmentCheckSequence,
      DraftDocument.abopconfirmationstrategy      as ABOPConfirmationStrategy,
      DraftDocument.isglobalsegment               as IsGlobalSegment,
      DraftDocument.isexceptionalsegment          as IsExceptionalSegment,
      DraftDocument.hasactiveentity               as HasActiveEntity
}
where
      draftentityoperationcode <> 'D' // IF_DRAFT_CONSTANTS=>co_operation_code-deleted

  and draftentityoperationcode <> 'L' // IF_DRAFT_CONSTANTS=>co_operation_code-redeleted


//where

//     I_DraftAdministrativeData.CreatedByUser   = $session.user

//  or I_DraftAdministrativeData.InProcessByUser = $session.user

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DRAFTADMINISTRATIVEDATA",
"ABOPVARSEG_D"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/