I_InhRepairStatus

DDL: I_INHREPAIRSTATUS Type: view COMPOSITE

In-House Repair Status

I_InhRepairStatus is a Composite CDS View (Dimension) that provides data about "In-House Repair 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.

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 Repair 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 Repair Status'
@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}
}
@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

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

Learn More