P_CustMgmtTransPredSuccRel

DDL: P_CUSTMGMTTRANSPREDSUCCREL Type: view_entity CONSUMPTION

Predecessor/Successor of Serv.Transact.

P_CustMgmtTransPredSuccRel is a Consumption CDS View that provides data about "Predecessor/Successor of Serv.Transact." in SAP S/4HANA. It reads from 2 data sources (I_CustMgmtTransactionRelation, I_CustMgmtTransactionRelation) and exposes 8 fields with key fields PrdcssrTransactionUUID, PrdcssrTransactionRelType, SuccssrTransactionUUID, SuccssrTransactionRelType.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
I_CustMgmtTransactionRelation childRelation inner
I_CustMgmtTransactionRelation parentRelation from

Annotations (9)

NameValueLevelField
EndUserText.label Predecessor/Successor of Serv.Transact. view
VDM.private true view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #NONE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY PrdcssrTransactionUUID I_CustMgmtTransactionRelation CustMgmtPrdcssrTransactionUUID
KEY PrdcssrTransactionRelType I_CustMgmtTransactionRelation CustMgmtTransacRelationType
KEY SuccssrTransactionUUID I_CustMgmtTransactionRelation CustMgmtSuccssrTransactionUUID
KEY SuccssrTransactionRelType I_CustMgmtTransactionRelation CustMgmtTransacRelationType
PrdcssrTransactionObjType I_CustMgmtTransactionRelation CustMgmtPrdcssrTransacObjType
SuccssrTransactionObjType I_CustMgmtTransactionRelation CustMgmtSuccssrTransacObjType
TransactionUUID I_CustMgmtTransactionRelation CustMgmtSuccssrTransactionUUID
TransactionObjType I_CustMgmtTransactionRelation CustMgmtSuccssrTransacObjType 
@EndUserText.label: 'Predecessor/Successor of Serv.Transact.'
@VDM: {
  private: true,
  viewType: #CONSUMPTION,
  lifecycle.contract.type: #NONE
}
@AccessControl: {
    authorizationCheck: #NOT_REQUIRED
}
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XL,
  dataClass: #MIXED
}
@Metadata: {
    ignorePropagatedAnnotations: true
}
define view entity P_CustMgmtTransPredSuccRel
  as select from I_CustMgmtTransactionRelation as parentRelation
  inner join I_CustMgmtTransactionRelation as childRelation on  childRelation.CustMgmtTransacRelationType    = parentRelation.CustMgmtTransacRelationType
                                                            and childRelation.CustMgmtPrdcssrTransactionUUID = parentRelation.CustMgmtSuccssrTransactionUUID
                                                            and childRelation.CustMgmtPrdcssrTransacObjType  = parentRelation.CustMgmtSuccssrTransacObjType
{
  key parentRelation.CustMgmtPrdcssrTransactionUUID  as PrdcssrTransactionUUID,
  key parentRelation.CustMgmtTransacRelationType     as PrdcssrTransactionRelType,
  key childRelation.CustMgmtSuccssrTransactionUUID   as SuccssrTransactionUUID,
  key childRelation.CustMgmtTransacRelationType      as SuccssrTransactionRelType,
      parentRelation.CustMgmtPrdcssrTransacObjType   as PrdcssrTransactionObjType,
      childRelation.CustMgmtSuccssrTransacObjType    as SuccssrTransactionObjType,
      parentRelation.CustMgmtSuccssrTransactionUUID  as TransactionUUID,
      parentRelation.CustMgmtSuccssrTransacObjType   as TransactionObjType
}

Learn More