I_SrvcDocExecutionStatus

DDL: I_SRVCDOCEXECUTIONSTATUS Type: view BASIC

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.

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_Indicator _SrvcDocIsQuotation $projection.ServiceDocumentIsQuotation = _SrvcDocIsQuotation.IndicatorValue

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName ISRVCDOCEXECST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey 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
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

Fields (4)

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

@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Service Transaction Execution Status'
@ObjectModel:
    {
        representativeKey: 'SrvcDocExecutionStatus',
        sapObjectNodeType.name: 'SrvcDocExecutionStatus',
        supportedCapabilities: [ #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ],
        usageType:
            {
                dataClass: #META,
                serviceQuality: #A,
                sizeCategory: #S
            },
        dataCategory: #VALUE_HELP,
        resultSet.sizeCategory: #XS
    }
@VDM.viewType: #BASIC
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_Indicator                  as _SrvcDocIsQuotation on  $projection.ServiceDocumentIsQuotation = _SrvcDocIsQuotation.IndicatorValue


{
      @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'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CRMS4C_STAT_EXEC"
],
"ASSOCIATED":
[
"I_INDICATOR",
"I_SRVCDOCEXECUTIONSTATUSTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More