I_InhRepairStatus

DDL: I_INHREPAIRSTATUS Type: view COMPOSITE Package: CRMS4_REPAIR_BO

In-House Service Status

I_InhRepairStatus is a Composite CDS View (Dimension) that provides data about "In-House Service Status" in SAP S/4HANA. It reads from 2 data sources (I_InhRepairUserStatus, I_SrvcLifeCycleSystemStatus) and exposes 3 fields with key fields InhRepairStatus, InhRepairStatus. It has 1 association to related views. Part of development package CRMS4_REPAIR_BO.

2 data source(s) 3 fields

Data Sources (2)

SourceAliasJoin Type
I_InhRepairUserStatus I_InhRepairUserStatus from
I_SrvcLifeCycleSystemStatus I_SrvcLifeCycleSystemStatus union

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_InhRepairStatusText _InhRepairStatusText $projection.InhRepairStatus = _InhRepairStatusText.InhRepairStatus

Annotations (15)

NameValueLevelField
EndUserText.label In-House Service Status view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey InhRepairStatus view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IIHRSTATUS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY InhRepairStatus
KEY InhRepairStatus
_InhRepairStatusText _InhRepairStatusText 
@EndUserText.label: 'In-House Service Status'  //2602 CE : Repair replaced with Service

@VDM: {
    viewType: #COMPOSITE,
    lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@Analytics: {
    dataCategory: #DIMENSION,
    internalName: #LOCAL
}
@AccessControl: {
    authorizationCheck: #NOT_REQUIRED
}
@ObjectModel: {
    representativeKey: 'InhRepairStatus',
    usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #CUSTOMIZING},
    supportedCapabilities: [#SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET,#ANALYTICAL_DIMENSION] //Added 2602 CE

}
@Metadata: {
    ignorePropagatedAnnotations: true
}
@ClientHandling: {
    algorithm: #SESSION_VARIABLE
}
@AbapCatalog: {
    sqlViewName: 'IIHRSTATUS',
    compiler.compareFilter: true,
    preserveKey: true
}


/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ]  } */
define view I_InhRepairStatus
as select from I_InhRepairUserStatus 
association [0..*] to I_InhRepairStatusText as _InhRepairStatusText on $projection.InhRepairStatus = _InhRepairStatusText.InhRepairStatus
{
@ObjectModel.text.association: '_InhRepairStatusText'
key cast(InhRepairUserStatus as crms4_repa_status_lbl preserving type ) as InhRepairStatus,

_InhRepairStatusText
}

union select from I_SrvcLifeCycleSystemStatus
association [0..*] to I_InhRepairStatusText as _InhRepairStatusText on $projection.InhRepairStatus = _InhRepairStatusText.InhRepairStatus
{

$session.client as mandt,
@ObjectModel.text.association: '_InhRepairStatusText'
key cast(SrvcLifeCycleSystemStatus as  crms4_stat_lifecycle preserving type ) as InhRepairStatus,

_InhRepairStatusText

}
where SrvcLifeCycleSystemStatus <> 'D'  // No status 'Released' in In-House Repair

Learn More