I_INHREPAIRUSERSTATUS

CDS View

User Status of In-House Repair

I_INHREPAIRUSERSTATUS is a CDS View in S/4HANA. User Status of In-House Repair. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_InhRepairStatus view from COMPOSITE In-House Repair Status 
@EndUserText.label: 'User Status of In-House Repair'
@VDM: {
    viewType: #BASIC,
    lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@Analytics: {
    dataCategory: #DIMENSION,
    internalName: #LOCAL
}
@AccessControl: {
    authorizationCheck: #NOT_REQUIRED
}
@ObjectModel: {
    representativeKey: 'InhRepairUserStatus',
    usageType: {serviceQuality: #B, sizeCategory: #S, dataClass: #CUSTOMIZING}
}
@Metadata: {
    ignorePropagatedAnnotations: true
}
@ClientHandling: {
    algorithm: #SESSION_VARIABLE
}
@AbapCatalog: {
    sqlViewName: 'IIHRUSRSTATUS',
    compiler.compareFilter: true,
    preserveKey: true,
    buffering: {status: #SWITCHED_OFF}
}

define view I_InhRepairUserStatus
  as select from I_CustMgmtLfcycUsrStsMapping
    inner join   I_ServiceDocumentType as srvcdoctype on  srvcdoctype.ServiceObjectType         =  'BUS2000256' //In-House Repair

                                                      and srvcdoctype.SrvcDocTypeBlockingStatus <> 'X'
                                                      and srvcdoctype.StatusProfile             =  I_CustMgmtLfcycUsrStsMapping.StatusProfile

  association [0..1] to I_ServiceDocumentType     as _InhRepairType           on  $projection.InhRepairType = _InhRepairType.ServiceDocumentType
  association [0..*] to I_InhRepairUserStatusText as _InhRepairUserStatusText on  $projection.InhRepairType       = _InhRepairUserStatusText.InhRepairType
                                                                              and $projection.InhRepairUserStatus = _InhRepairUserStatusText.InhRepairUserStatus
{
        @ObjectModel.text.association: '_InhRepairUserStatusText'
  key   cast(I_CustMgmtLfcycUsrStsMapping.CustMgmtLifecycleUserStatus as  crms4_repa_header_status_lbl preserving type) as InhRepairUserStatus,
        @ObjectModel.foreignKey.association: '_InhRepairType'
  key   srvcdoctype.ServiceDocumentType                                                                                 as InhRepairType,

        /* Associations */
        _InhRepairType,
        _InhRepairUserStatusText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTMGMTLFCYCUSRSTSMAPPING",
"I_SERVICEDOCUMENTTYPE"
],
"ASSOCIATED":
[
"I_INHREPAIRUSERSTATUSTEXT",
"I_SERVICEDOCUMENTTYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More