I_INHREPAIRITMCUSTRETRELATION

CDS View

Relationship between InHouse Repair Item

I_INHREPAIRITMCUSTRETRELATION is a CDS View in S/4HANA. Relationship between InHouse Repair Item. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_InhRepairProcessFlow view inner CONSUMPTION Transaction History of In-House Repair Item 

@EndUserText.label: 'Relationship between InHouse Repair Item'
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY
}
@ObjectModel: {
  usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
}
@Metadata: {
  ignorePropagatedAnnotations: true
}
@ClientHandling: {
  algorithm: #SESSION_VARIABLE
}
@AbapCatalog: {
  sqlViewName: 'IIHRTRANSITMRLTN',
  compiler.compareFilter: true,
  preserveKey: true
}

define view I_InhRepairItmCustRetRelation as select from I_SrvcDocItemRelation as ItemRelation

    inner join   I_CustMgmtTransactionRelation as HeaderRel      on ItemRelation.ServiceDocumentItmRelationUUID    = HeaderRel.CustMgmtTransacRelationUUID
                                                                 and(
                                                                   ItemRelation.ServiceDocItmPrdcssrBusObjType     = 'VBAP'
                                                                   or ItemRelation.ServiceDocItmSuccssrBusObjType = 'VBAP'
                                                                 )
    inner join   I_CustomerReturnItemEnhanced  as CustomerReturn on( HeaderRel.CustMgmtPrdcssrTransactionKey = CustomerReturn.CustomerReturn
                                                                    and ItemRelation.ServiceDocumentItemPredecessor = CustomerReturn.CustomerReturnItem
                                                                    and ItemRelation.ServiceDocItmPrdcssrBusObjType = 'VBAP'     )
                                                                 or(
                                                                   HeaderRel.CustMgmtSuccssrTransactionKey  = CustomerReturn.CustomerReturn
                                                                   and ItemRelation.ServiceDocumentItemSuccessor     = CustomerReturn.CustomerReturnItem
                                                                   and ItemRelation.ServiceDocItmSuccssrBusObjType = 'VBAP'
                                                                 )

{
  key ItemRelation.ServiceDocumentItmRelationUUID,
  key ItemRelation.ServiceDocItmRltnSqncNumber,
      ItemRelation.ServiceDocumentItemPredecessor,
      ItemRelation.ServiceDocItmPrdcssrBusObjType,
      ItemRelation.ServiceDocumentItemSuccessor,
      ItemRelation.ServiceDocItmSuccssrBusObjType,
      ItemRelation.ServiceDocumentItmRelationType,
      CustomerReturn.CustRetMatlAuthzn
     
} 
where ItemRelation.ServiceDocumentItmRelationType = 'VONA'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTMGMTTRANSACTIONRELATION",
"I_CUSTOMERRETURNITEMENHANCED",
"I_SRVCDOCITEMRELATION"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More