I_INHREPAIRTRANSACTIONRELATION

CDS View

Relationship between Service Transactions

I_INHREPAIRTRANSACTIONRELATION is a CDS View in S/4HANA. Relationship between Service Transactions. It contains 1 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 1 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_InhRepairItmNrOfBillgRdyItms view from COMPOSITE
P_InhReprItmNrOfOpnMaintOrd view from COMPOSITE
R_InhRepairItmNrOfOpnMaintOrds view_entity from COMPOSITE Number of open Maintenance Orders

Fields (1)

KeyField CDS FieldsUsed in Views
KEY CustMgmtPrdcssrTransactionUUID InHouseRepairItemUUID 3 
@EndUserText.label: 'Relationship between Service Transactions'
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY
}
@ObjectModel: {
  usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
}
@Metadata: {
  ignorePropagatedAnnotations: true
}
@ClientHandling: {
  algorithm: #SESSION_VARIABLE
}
@AbapCatalog: {
  sqlViewName: 'IIHRTRANSACRLTN',
  compiler.compareFilter: true,
  preserveKey: true
}

define view I_InhRepairTransactionRelation

  as select from I_CustMgmtTransactionRelation

  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
  association [0..1] to I_ServiceDocument   as _PredecessorServiceTransaction on  $projection.CustMgmtPrdcssrTransactionUUID = _PredecessorServiceTransaction.ServiceDocumentUUID
                                                                              and $projection.CustMgmtPrdcssrTransacObjType  = _PredecessorServiceTransaction.ServiceObjectType
  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
  association [0..1] to I_ServiceDocument   as _SuccessorServiceTransaction   on  $projection.CustMgmtSuccssrTransactionUUID = _SuccessorServiceTransaction.ServiceDocumentUUID
                                                                              and $projection.CustMgmtSuccssrTransacObjType  = _SuccessorServiceTransaction.ServiceObjectType
  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
  association [0..1] to I_InHouseRepairItem as _InHouseRepairItem             on  $projection.CustMgmtPrdcssrTransactionUUID = _InHouseRepairItem.InHouseRepairItemUUID
                                                                              and $projection.CustMgmtPrdcssrTransacObjType  = _InHouseRepairItem.InhRepairItemObjectType
                                                                              and $projection.CustMgmtPrdcssrTransacObjType  = 'BUS2000257'

  association [0..1] to I_CustomerReturnEnhanced as _PredecessorCustomerReturn on $projection.CustMgmtPrdcssrTransactionKey = _PredecessorCustomerReturn.CustomerReturn
  association [0..1] to I_OutboundDelivery as _OutboundDelivery on $projection.CustMgmtSuccssrTransactionKey = _OutboundDelivery.OutboundDelivery
{
  key CustMgmtTransacRelationUUID,
      CustMgmtPrdcssrTransactionUUID,
      CustMgmtPrdcssrTransacObjType,
      CustMgmtSuccssrTransactionUUID,
      CustMgmtSuccssrTransactionKey,
      CustMgmtSuccssrTransacObjType,
      CustMgmtTransacRelationType,

      //Return Order Changes

      CustMgmtPrdcssrTransactionKey, 
      
      
      // Associations

      _PredecessorServiceTransaction,
      _SuccessorServiceTransaction,
      _InHouseRepairItem,
      
      _PredecessorCustomerReturn,      
      _OutboundDelivery
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTMGMTTRANSACTIONRELATION"
],
"ASSOCIATED":
[
"I_CUSTOMERRETURNENHANCED",
"I_INHOUSEREPAIRITEM",
"I_OUTBOUNDDELIVERY",
"I_SERVICEDOCUMENT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More