I_INHREPAIRTRANSACTIONRELATION

CDS View

Relationship between Srvc Transactions

I_INHREPAIRTRANSACTIONRELATION is a CDS View in S/4HANA. Relationship between Srvc 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_entity from COMPOSITE Number of Items to be Released for Billing
P_InhReprItmNrOfOpnMaintOrd view_entity from COMPOSITE Number of Maintenance Orders
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 Srvc Transactions' //Service

@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY
}
@ObjectModel: {
  usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL},
  supportedCapabilities: [#SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET] //Added 2602 CE

}
@Metadata: {
  ignorePropagatedAnnotations: true
}
define view entity 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
}

Learn More