I_InhRepairUserStatus

DDL: I_INHREPAIRUSERSTATUS Type: view BASIC

User Status of In-House Repair

I_InhRepairUserStatus is a Basic CDS View (Dimension) that provides data about "User Status of In-House Repair" in SAP S/4HANA. It reads from 2 data sources (I_CustMgmtLfcycUsrStsMapping, I_ServiceDocumentType) and exposes 4 fields with key fields InhRepairUserStatus, InhRepairType. It has 2 associations to related views.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
I_CustMgmtLfcycUsrStsMapping I_CustMgmtLfcycUsrStsMapping from
I_ServiceDocumentType srvcdoctype inner

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ServiceDocumentType _InhRepairType $projection.InhRepairType = _InhRepairType.ServiceDocumentType
[0..*] I_InhRepairUserStatusText _InhRepairUserStatusText $projection.InhRepairType = _InhRepairUserStatusText.InhRepairType and $projection.InhRepairUserStatus = _InhRepairUserStatusText.InhRepairUserStatus

Annotations (16)

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

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY InhRepairUserStatus
KEY InhRepairType I_ServiceDocumentType ServiceDocumentType
_InhRepairType _InhRepairType
_InhRepairUserStatusText _InhRepairUserStatusText 
@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