I_SrvcDocExecutionStatus

DDL: I_SRVCDOCEXECUTIONSTATUS Type: view BASIC Package: CRMS4_SERV_COMMON

Service Transaction Execution Status

I_SrvcDocExecutionStatus is a Basic CDS View (Dimension) that provides data about "Service Transaction Execution Status" in SAP S/4HANA. It reads from 1 data source (crms4c_stat_exec) and exposes 4 fields with key fields ServiceDocumentIsQuotation, SrvcDocExecutionStatus. It has 2 associations to related views. Part of development package CRMS4_SERV_COMMON.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
crms4c_stat_exec crms4c_stat_exec from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_SrvcDocExecutionStatusText _Text $projection.SrvcDocExecutionStatus = _Text.SrvcDocExecutionStatus and $projection.ServiceDocumentIsQuotation = _Text.ServiceDocumentIsQuotation
[1..1] I_SrvcDocQuotationStatus_2 _SrvcDocIsQuotation $projection.ServiceDocumentIsQuotation = _SrvcDocIsQuotation.ServiceDocumentIsQuotation

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName ISRVCDOCEXECST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Service Transaction Execution Status view
ObjectModel.representativeKey SrvcDocExecutionStatus view
ObjectModel.sapObjectNodeType.name SrvcDocExecutionStatus view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.resultSet.sizeCategory #XS view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocumentIsQuotation stat_quotation
KEY SrvcDocExecutionStatus stat_execution
_Text _Text
_SrvcDocIsQuotation _SrvcDocIsQuotation 
@AbapCatalog:
    {
        sqlViewName: 'ISRVCDOCEXECST',
        compiler.compareFilter: true,
        buffering:
            {
                status: #ACTIVE,
                type: #FULL
            }
    }
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Analytics: {
      dataCategory: #DIMENSION,
      internalName:#LOCAL,
      dataExtraction.enabled: true
}

@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Service Transaction Execution Status'
@ObjectModel:
    {
        representativeKey: 'SrvcDocExecutionStatus',
        sapObjectNodeType.name: 'SrvcDocExecutionStatus',
        supportedCapabilities: [ #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #ANALYTICAL_DIMENSION, #CDS_MODELING_DATA_SOURCE, #EXTRACTION_DATA_SOURCE ],
        usageType:
            {
                dataClass: #META,
                serviceQuality: #A,
                sizeCategory: #S
            },
        dataCategory: #VALUE_HELP,
        resultSet.sizeCategory: #XS
    }
@VDM.viewType: #BASIC
@Metadata.ignorePropagatedAnnotations: true

define view I_SrvcDocExecutionStatus
  as select from crms4c_stat_exec

  association [0..*] to I_SrvcDocExecutionStatusText as _Text               on  $projection.SrvcDocExecutionStatus     = _Text.SrvcDocExecutionStatus
                                                                            and $projection.ServiceDocumentIsQuotation = _Text.ServiceDocumentIsQuotation

   association [1..1] to I_SrvcDocQuotationStatus_2                  as _SrvcDocIsQuotation on  $projection.ServiceDocumentIsQuotation = _SrvcDocIsQuotation.ServiceDocumentIsQuotation


{
      @ObjectModel.foreignKey.association: '_SrvcDocIsQuotation'
      @Semantics.booleanIndicator
  key stat_quotation as ServiceDocumentIsQuotation,

      @ObjectModel.text.association: '_Text'
  key stat_execution as SrvcDocExecutionStatus,

      _Text,
      _SrvcDocIsQuotation
}

where
  object_type = 'BUS2000116'

Learn More