I_CUSTMGMTTRANSACTIONRELATION

CDS View

Relationship between Service Transactions

I_CUSTMGMTTRANSACTIONRELATION is a CDS View in S/4HANA. Relationship between Service Transactions. It contains 6 fields. 19 CDS views read from this table.

Used by 19 CDS view(s) 6 fields

CDS Views using this table (19)

ViewTypeJoinVDMDescription
C_InhRepairProcessFlow view inner CONSUMPTION Transaction History of In-House Repair Item
I_InhRepairItmCustRetRelation view inner COMPOSITE Relationship between InHouse Repair Item
I_InhRepairTransactionRelation view from COMPOSITE Relationship between Service Transactions
P_CustMgmtTransPredSuccRel view_entity from CONSUMPTION Predecessor/Successor of Serv.Transact.
P_CustMgmtTransPredSuccRel view_entity inner CONSUMPTION Predecessor/Successor of Serv.Transact.
P_SrvcDocIhrPrdcssrRelation view_entity from CONSUMPTION IHR-Related Predecessor of Serv. Trans.
P_SrvcDocIhrPrdcssrRelation view_entity inner CONSUMPTION IHR-Related Predecessor of Serv. Trans.
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
R_InhRepairItmSrvcOrdTP view_entity inner TRANSACTIONAL Related SrvcOrd for Inh Repr Item - TP
R_InhRepairItmSrvcQtanTP view_entity inner TRANSACTIONAL Related SrvcQtan for Inh Repr Item - TP
R_SrvcConfItmTransHistory view_entity inner COMPOSITE Transaction History in SRVC Item
R_SrvcConfItmTransHistory view_entity union_all COMPOSITE Transaction History in SRVC Item
R_SrvcConfTransHistory view_entity from COMPOSITE Transaction History in SRVC Header
R_SrvcConfTransHistory view_entity union_all COMPOSITE Transaction History in SRVC Header
R_SrvcOrdItmTransHistory view_entity inner COMPOSITE Transaction History in SRVO Item
R_SrvcOrdItmTransHistory view_entity union_all COMPOSITE Transaction History in SRVO Item
R_SrvcOrdTransHistory view_entity from COMPOSITE Transaction History in SRVO Header
R_SrvcOrdTransHistory view_entity union_all COMPOSITE Transaction History in SRVO Header

Fields (6)

KeyField CDS FieldsUsed in Views
KEY CustMgmtPrdcssrTransacObjType BusinessObjectType,IhrPrdcssrTransacObjType,PrdcssrTransacObjType,PrdcssrTransactionObjType 4
KEY CustMgmtPrdcssrTransactionUUID IhrPrdcssrTransactionUUID,PrdcssrTransactionUUID 2
KEY CustMgmtSuccssrTransacObjType BusinessObjectType,SuccssrTransacObjType,SuccssrTransactionObjType,TransactionObjType 6
KEY CustMgmtSuccssrTransactionUUID SuccssrTransactionUUID,TransactionUUID 2
KEY CustMgmtTransacRelationType PrdcssrTransactionRelType,SuccssrTransactionRelType,TransacRelationType 2
KEY CustMgmtTransacRelationUUID TransacRelationUUID 1 
@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'

Learn More