I_CUSTMGMTTRANSACTIONRELATION

CDS View

Relationship between Service Transactions

I_CUSTMGMTTRANSACTIONRELATION is a CDS View in S/4HANA. Relationship between Service Transactions. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_InhRepairProcessFlow view inner CONSUMPTION Transaction History of In-House Repair Item
I_InhRepairItmCustRetRelation view_entity inner COMPOSITE Relationship between InHouse Repair Item
I_InhRepairTransactionRelation view_entity from COMPOSITE Relationship between Srvc Transactions
R_InhRepairFUPCustReturnTP view_entity inner TRANSACTIONAL Follow-Up Returns Order for IHR - TP
R_InhRepairItmFUPCustReturnTP view_entity inner TRANSACTIONAL FollowUp Returns Ord Itm for IHR Itm - TP
@EndUserText.label: 'Relationship between Service Transactions'
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY
}
@ObjectModel: {
  representativeKey: 'CustMgmtTransacRelationUUID',
  usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
}
@Metadata: {
  ignorePropagatedAnnotations: true
}
@ClientHandling: {
  algorithm: #SESSION_VARIABLE
}
@AbapCatalog: {
  sqlViewName: 'ICMTRANSACRLTN',
  compiler.compareFilter: true,
  preserveKey: true
}

define view I_CustMgmtTransactionRelation
  as select from crmd_brelvonae
{
  key relationid    as CustMgmtTransacRelationUUID,
      breltyp       as CustMgmtTransacRelationType,
      objguid_a_sel as CustMgmtPrdcssrTransactionUUID,
      objkey_a_sel  as CustMgmtPrdcssrTransactionKey,
      objtype_a_sel as CustMgmtPrdcssrTransacObjType,
      objguid_b_sel as CustMgmtSuccssrTransactionUUID,
      objkey_b_sel  as CustMgmtSuccssrTransactionKey,
      objtype_b_sel as CustMgmtSuccssrTransacObjType
}
where
  posno = '0000'