R_SrvcDocDocumentFlow

DDL: R_SRVCDOCDOCUMENTFLOW SQL: RSRVCDOCFLOW Type: view COMPOSITE

Transaction flow for Service Transaction

R_SrvcDocDocumentFlow is a Composite CDS View that provides data about "Transaction flow for Service Transaction" in SAP S/4HANA. It reads from 1 data source (I_SrvcDocDocumentFlow) and exposes 11 fields with key fields ServiceDocument, ReltdSrvcDocIsPredecessor. It has 1 association to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_SrvcDocDocumentFlow I_SrvcDocDocumentFlow from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ServiceDocumentEnhcd _ServiceDocumentEnhcd $projection.SrvcMgmtObjectUUID = _ServiceDocumentEnhcd.ServiceDocumentUUID and _ServiceDocumentEnhcd.ServiceObjectType = $projection.PrdcssrSuccssrDocObjectType

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName RSRVCDOCFLOW view
AbapCatalog.dataMaintenance #RESTRICTED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Transaction flow for Service Transaction view
ObjectModel.representativeKey ServiceDocument view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocument ServiceDocument
KEY ReltdSrvcDocIsPredecessor ReltdSrvcDocIsPredecessor
ServiceObjectType ServiceObjectType
ServiceDocumentUUID ServiceDocumentUUID
SrvcMgmtObjectUUID SrvcMgmtObjectUUID
ServiceDocumentRelationUUID ServiceDocumentRelationUUID
PrdcssrSuccssrDocObjectType PrdcssrSuccssrDocObjectType
ServiceDocumentType ServiceDocumentType
ServiceDocumentIsQuotation _ServiceDocumentEnhcd ServiceDocumentIsQuotation
ServiceDocumentTemplateType _ServiceDocumentEnhcd ServiceDocumentTemplateType
_ServiceDocumentEnhcd _ServiceDocumentEnhcd 
@AbapCatalog.sqlViewName: 'RSRVCDOCFLOW'
@AbapCatalog.dataMaintenance: #RESTRICTED
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Transaction flow for Service Transaction'
@ObjectModel: {
  semanticKey: ['ServiceDocument'],
  representativeKey: 'ServiceDocument',
   usageType: {dataClass:      #TRANSACTIONAL,
                serviceQuality: #C,
                sizeCategory:   #XL}
}
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@ClientHandling.algorithm:#SESSION_VARIABLE
define view R_SrvcDocDocumentFlow
  as select from I_SrvcDocDocumentFlow
  association [1..1] to I_ServiceDocumentEnhcd         as _ServiceDocumentEnhcd      //  on  $projection.ServiceDocumentUUID          = _ServiceDocumentEnhcd.ServiceDocumentUUID

   on  $projection.SrvcMgmtObjectUUID          = _ServiceDocumentEnhcd.ServiceDocumentUUID
                                                                                        and _ServiceDocumentEnhcd.ServiceObjectType = $projection.PrdcssrSuccssrDocObjectType
                                                                                     //    and _ServiceDocumentEnhcd.ServiceObjectType = $projection.ServiceObjectType

{

  key    ServiceDocument,
  key    case  PrdcssrSuccssrDocObjectType
          when 'BUS2000117'
           then _ServiceDocumentEnhcd.ServiceDocument
          when 'BUS2000116'
           then _ServiceDocumentEnhcd.ServiceDocument
          when 'BUS2000112'
           then _ServiceDocumentEnhcd.ServiceDocument
          when 'BUS2000172'
           then _ServiceDocumentEnhcd.ServiceDocument
          when 'BUS2000223'
           then _ServiceDocumentEnhcd.ServiceDocument  
          when 'BUS2017'
           then substring(CustMgmtPrdcssrTransactionKey,  1, 10)
//          when 'BUS2081'

//           then substring(CustMgmtPrdcssrTransactionKey, 1, 10)

          else CustMgmtPrdcssrTransactionKey     end as   CustMgmtPrdcssrTransactionKey,
  key     ReltdSrvcDocIsPredecessor,  
  
          ServiceObjectType,
          ServiceDocumentUUID,
          SrvcMgmtObjectUUID,
          ServiceDocumentRelationUUID,
          PrdcssrSuccssrDocObjectType,
          ServiceDocumentType,  
            
         _ServiceDocumentEnhcd.ServiceDocumentIsQuotation  as ServiceDocumentIsQuotation,
         _ServiceDocumentEnhcd.ServiceDocumentTemplateType as ServiceDocumentTemplateType,
         
         _ServiceDocumentEnhcd
}
where
  CustMgmtPrdcssrTransactionKey != '' and
  ServiceDocumentRelationType = 'VONA'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERVICEDOCUMENTENHCD",
"I_SRVCDOCDOCUMENTFLOW"
],
"ASSOCIATED":
[
"I_SERVICEDOCUMENTENHCD"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More