I_ServiceDocumentItemPrdcssr_2

DDL: I_SERVICEDOCUMENTITEMPRDCSSR_2 Type: view BASIC Package: CRMS4_REPORT

Preceding Transaction of Srvc Trans Item

I_ServiceDocumentItemPrdcssr_2 is a Basic CDS View (Fact) that provides data about "Preceding Transaction of Srvc Trans Item" in SAP S/4HANA. It reads from 1 data source (crmd_brelvonai) and exposes 9 fields with key fields ServiceDocumentItmRelationUUID, ServiceDocItmRltnSqncNumber. It has 1 association to related views. Part of development package CRMS4_REPORT.

Data Sources (1)

SourceAliasJoin Type
crmd_brelvonai crmd_brelvonai from

Associations (1)

CardinalityTargetAliasCondition
[1] I_ServiceDocumentItemEnhcd _ServiceDocItm $projection.ServiceDocItmPrdcssrCharUUID = _ServiceDocItm.ServiceDocumentItemCharUUID

Annotations (15)

NameValueLevelField
EndUserText.label Preceding Transaction of Srvc Trans Item view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Analytics.dataCategory #FACT view
Analytics.dataExtraction.enabled true view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ISERVDOCITMPRE2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name ServiceDocumentItemPredecessor view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocumentItmRelationUUID relationid
KEY ServiceDocItmRltnSqncNumber posno
ServiceDocItmPrdcssrCharUUID
ServiceDocumentItemCharUUID
ServiceDocumentItmRelationType breltyp
ServiceDocItmPrdcssrBusObjType objtype_a
ServiceDocumentItmRelationKind vona_kind
ServiceDocumentItemObjectType objtype_b
_ServiceDocItm _ServiceDocItm
@EndUserText.label: 'Preceding Transaction of Srvc Trans Item'
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}

@Analytics: {
    dataCategory: #FACT,
    dataExtraction: {
        enabled: true,
        delta.changeDataCapture: {
            mapping:[
                {
//                   filter: [{operator: #EQ, tableElement: 'objtype_a', value: 'BUS2000%'}],

                    table: 'crmd_brelvonai', role: #MAIN,
                    viewElement: ['ServiceDocumentItmRelationUUID', 'ServiceDocItmRltnSqncNumber'],
                    tableElement: ['relationid', 'posno']
                }
            ]
        }
    }
 }
 
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}

@AbapCatalog: {
  sqlViewName: 'ISERVDOCITMPRE2',
  compiler.compareFilter: true ,
  preserveKey: true
}

@ObjectModel: {
//   representativeKey: 'ServiceDocumentItmRelationUUID',

   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #A,
     sizeCategory:   #XL
   },
   supportedCapabilities: [#SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #EXTRACTION_DATA_SOURCE]
}

//@Analytics.dataCategory: #DIMENSION

//@Metadata.allowExtensions:true

@Metadata.ignorePropagatedAnnotations: true

//! Business Object SONT for the Service Document Item Predecessor

@ObjectModel.sapObjectNodeType.name: 'ServiceDocumentItemPredecessor'
/*
  1902CE: Data preview might give you an error because hextobin conversion may not work on properly on junk data. Hence dump occurs.
  To view the data, you have to apply the condition "CharcLength = 32" to get the results for Service scenario only.

  1911CE: DONOT use hextobin converted attribute.

*/

/*
If there is any new Business object addition in service document view (e.g. BUS2000116 )
then the same business object has to be added in DCL "I_ServiceDocumentItemPrdcssr" as well.
*/

define view I_ServiceDocumentItemPrdcssr_2
  as select from crmd_brelvonai
  association [1] to I_ServiceDocumentItemEnhcd as _ServiceDocItm on $projection.ServiceDocItmPrdcssrCharUUID = _ServiceDocItm.ServiceDocumentItemCharUUID

{
  key relationid                                as ServiceDocumentItmRelationUUID,
  key posno                                     as ServiceDocItmRltnSqncNumber,

      /* CRMT_BRELVONAI */
      cast(objkey_a as crms4_object_charguid32 preserving type ) as ServiceDocItmPrdcssrCharUUID,
      
      cast(objkey_b as crms4_object_charguid32 preserving type ) as ServiceDocumentItemCharUUID,
      breltyp                                   as ServiceDocumentItmRelationType,
      
      objtype_a                                 as ServiceDocItmPrdcssrBusObjType,
      vona_kind                                 as ServiceDocumentItmRelationKind,
      objtype_b                                 as ServiceDocumentItemObjectType,

      //Associations

      _ServiceDocItm

}
where
  objtype_a like 'BUS2000%'