R_SrvcDocItemDocumentFlow

DDL: R_SRVCDOCITEMDOCUMENTFLOW SQL: RSRVCDOCFLWITM Type: view COMPOSITE

Transaction flow for Srvc Transac Itm

R_SrvcDocItemDocumentFlow is a Composite CDS View that provides data about "Transaction flow for Srvc Transac Itm" in SAP S/4HANA. It reads from 1 data source (I_SrvcDocItmDocumentFlow) and exposes 13 fields with key fields ServiceDocument, ServiceDocumentItem, CustMgmtPrdcssrTransactionKey. It has 2 associations to related views.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_SrvcDocItmDocumentFlow I_SrvcDocItmDocumentFlow from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_SrvcDocDocumentFlow _SrvcDocDocumentFlow $projection.ServiceDocumentItmRelationUUID = _SrvcDocDocumentFlow.ServiceDocumentRelationUUID and $projection.ServiceDocument != _SrvcDocDocumentFlow.CustMgmtPrdcssrTransactionKey
[1..1] I_ServiceDocumentItemEnhcd _ServiceDocumentItemEnhcd $projection.ServiceDocumentItemSuccessor = _ServiceDocumentItemEnhcd.ServiceDocumentItemCharUUID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName RSRVCDOCFLWITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Transaction flow for Srvc Transac Itm view
ObjectModel.representativeKey ServiceDocumentItem 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 (13)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocument ServiceDocument
KEY ServiceDocumentItem ServiceDocumentItem
KEY CustMgmtPrdcssrTransactionKey _SrvcDocDocumentFlow CustMgmtPrdcssrTransactionKey
ServiceDocumentItmRelationUUID ServiceDocumentItmRelationUUID
ServiceDocumentIsQuotation _SrvcDocDocumentFlow ServiceDocumentIsQuotation
ServiceObjectType ServiceObjectType
ServiceDocumentItemSuccessor ServiceDocumentItemSuccessor
ReltdSrvcDocItemIsPredecessor I_SrvcDocItmDocumentFlow ReltdSrvcDocItemIsPredecessor
PrdcssrSuccssrDocObjectType _SrvcDocDocumentFlow PrdcssrSuccssrDocObjectType
ServiceDocumentItemIsQuotation _ServiceDocumentItemEnhcd ServiceDocumentItemIsQuotation
ServiceDocumentTemplateType _ServiceDocumentItemEnhcd ServiceDocumentTemplateType
_SrvcDocDocumentFlow _SrvcDocDocumentFlow
_ServiceDocumentItemEnhcd _ServiceDocumentItemEnhcd 
@AbapCatalog.sqlViewName: 'RSRVCDOCFLWITM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Transaction flow for Srvc Transac Itm'
@ObjectModel: {
  semanticKey: ['ServiceDocumentItem'],
  representativeKey: 'ServiceDocumentItem',
   usageType: {dataClass:      #TRANSACTIONAL,
                serviceQuality: #C,
                sizeCategory:   #XL}
}
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@ClientHandling.algorithm:#SESSION_VARIABLE

define view R_SrvcDocItemDocumentFlow
   as select from I_SrvcDocItmDocumentFlow  
  association [1..1] to R_SrvcDocDocumentFlow      as _SrvcDocDocumentFlow      on  $projection.ServiceDocumentItmRelationUUID = _SrvcDocDocumentFlow.ServiceDocumentRelationUUID
                                                                                and $projection.ServiceDocument != _SrvcDocDocumentFlow.CustMgmtPrdcssrTransactionKey

  association [1..1] to I_ServiceDocumentItemEnhcd as _ServiceDocumentItemEnhcd on  $projection.ServiceDocumentItemSuccessor = _ServiceDocumentItemEnhcd.ServiceDocumentItemCharUUID

{
         //    @ObjectModel.foreignKey.association: '_SrvcDocDocumentFlow'          

  key        ServiceDocument,
  key        ServiceDocumentItem,
  key        _SrvcDocDocumentFlow.CustMgmtPrdcssrTransactionKey,
  key       case  _SrvcDocDocumentFlow.PrdcssrSuccssrDocObjectType
             when 'BUS2000117'
             then _ServiceDocumentItemEnhcd.ServiceDocumentItem
             when 'BUS2000116'
             then _ServiceDocumentItemEnhcd.ServiceDocumentItem
             when 'BUS2000112'
             then _ServiceDocumentItemEnhcd.ServiceDocumentItem
             when 'BUS2000172'
             then _ServiceDocumentItemEnhcd.ServiceDocumentItem
             when 'BUS2000223'
             then _ServiceDocumentItemEnhcd.ServiceDocumentItem            
             else
             cast( ServiceDocumentItemSuccessor as njit_btd_item_id ) end as BusinessTransactionDocItem, //LTRIM(ServiceDocumentItemCharUUID,'0'),

  
              ServiceDocumentItmRelationUUID,
             _SrvcDocDocumentFlow.ServiceDocumentIsQuotation              as ServiceDocumentIsQuotation,
             ServiceObjectType,
             
             
//             cast( _SrvcDocDocumentFlow.CustMgmtPrdcssrTransactionKey as crmt_object_id_db ) as PrdcssrSuccssrDoc,             

//             cast ( ServiceDocumentItemSuccessor as crms4_number_int ) as  SrvcPrdcssrSuccssrDocumentItem, //CustMgmtDocumentItem,

             ServiceDocumentItemSuccessor,
             I_SrvcDocItmDocumentFlow.ReltdSrvcDocItemIsPredecessor,
             _SrvcDocDocumentFlow.PrdcssrSuccssrDocObjectType      as PrdcssrSuccssrDocObjectType,
           //  _SrvcDocDocumentFlow.BusinessObjectTypeName,

              _ServiceDocumentItemEnhcd.ServiceDocumentItemIsQuotation  as ServiceDocumentItemIsQuotation,
              _ServiceDocumentItemEnhcd.ServiceDocumentTemplateType as ServiceDocumentTemplateType,
         
             _SrvcDocDocumentFlow,
             _ServiceDocumentItemEnhcd
}
where
  ServiceDocumentItmRelationUUID != ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERVICEDOCUMENTITEMENHCD",
"I_SRVCDOCITMDOCUMENTFLOW",
"R_SRVCDOCDOCUMENTFLOW"
],
"ASSOCIATED":
[
"I_SERVICEDOCUMENTITEMENHCD",
"R_SRVCDOCDOCUMENTFLOW"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More