R_SRVCDOCDOCUMENTFLOW

CDS View

Transaction flow for Service Transaction

R_SRVCDOCDOCUMENTFLOW is a CDS View in S/4HANA. Transaction flow for Service Transaction. 16 CDS views read from this table.

CDS Views using this table (16)

ViewTypeJoinVDMDescription
R_BSOrdPrdcssrSrvcContrTP view_entity from TRANSACTIONAL Business Solution Order Preceding Service Contract - TP
R_BusSolnOrdFUPSalesOrderTP view_entity from TRANSACTIONAL Business Solution Order Follow-up Sales Order - TP
R_BusSolnOrdFUPSrvcContrTP view_entity from TRANSACTIONAL Business Solution Order Follow-up Service Contract - TP
R_BusSolnOrdFUPSrvcOrdTP view_entity from TRANSACTIONAL Business Solution Order Follow-up Service Order - TP
R_SrvcConfFUPBillgDocTP view_entity from TRANSACTIONAL Follow-Up Billing Document - TP
R_SrvcConfFUPTimeSheetTP view_entity from TRANSACTIONAL Follow-Up Time Sheet - TP
R_SrvcContrFUPBillgDocTP view_entity from TRANSACTIONAL Follow-Up Billing Document - TP
R_SrvcContrFUPSrvcOrdTP view_entity from TRANSACTIONAL Follow-Up Service Order - TP
R_SrvcOrdFUPBillgDocTP view_entity from TRANSACTIONAL Follow-Up Billing Document - TP
R_SrvcOrdFUPMaintOrdTP view_entity from TRANSACTIONAL Follow-Up Maintenance Order - TP
R_SrvcOrdFUPPurchaseOrderTP view_entity from TRANSACTIONAL Follow-Up Purchase Order - TP
R_SrvcOrdFUPPurReqnTP view_entity from TRANSACTIONAL Follow-Up Purchase Requisition - TP
R_SrvcOrdFUPSrvcConfTP view_entity from TRANSACTIONAL Follow-Up Service Confirmation - TP
R_SrvcOrdFUPSrvcEntrSheetTP view_entity from TRANSACTIONAL Follow-Up Service Entry Sheet - TP
R_SrvcOrdFUPSuplrInvcTP view_entity from TRANSACTIONAL Follow-Up Supplier Invoice - TP
R_SrvcQtanFUPSrvcOrdTP view_entity from TRANSACTIONAL Follow-Up Service Order - TP
@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":""
}
}*/