I_SERVICEDOCUMENTITEMSUCCSSR_2

CDS View

Follow-Up Transaction of Srvc Trans Item

I_SERVICEDOCUMENTITEMSUCCSSR_2 is a CDS View in S/4HANA. Follow-Up Transaction of Srvc Trans Item. It contains 3 fields. 25 CDS views read from this table.

CDS Views using this table (25)

ViewTypeJoinVDMDescription
A_BuSoQtanItmFUPSubscrpnContr view from COMPOSITE Follow-up Subscription Contract Item
A_BusSolnOrdItmFUPSalesOrder view from COMPOSITE Follow-up Sales Order Items
A_BusSolnOrdItmFUPServiceOrder view from COMPOSITE Follow-up Service Order Items
A_BusSolnOrdItmFUPSrvcContr view from COMPOSITE Follow-up Service Contract Items
A_BusSolnQtanItmFUPSalesOrder view from COMPOSITE Follow-up Sales Order Item
A_BusSolnQtanItmFUPSrvcContr view from COMPOSITE Follow-up Service Contract Item
A_BusSolnQtanItmFUPSrvcOrder view from COMPOSITE Follow-up Service Order Item
A_ServiceContrItmReleasedOrder view from CONSUMPTION Item Released Order
C_BusSolnOrdPlndDteSitn2 view inner CONSUMPTION Trigger CDS view planned date reached
I_BusSolnOrderSrvcItmSitn view inner COMPOSITE Solution Order Service Item Situation
I_SubscrpnOrdItmFUPContrItm view_entity from COMPOSITE Item FUP Contract
I_SubscrpnOrdItmFUPSlsOrdItm view_entity from COMPOSITE Item FUP Sales Order
P_BSQPMSrvcDocFllwUpDoc view_entity inner COMPOSITE
P_BusSolnOrdSlsOrdFlwLvl1 view inner CONSUMPTION Solution Order Sales Order Flow Level 1
P_BusSolnOrdSrvcContrFlwLvl1 view inner CONSUMPTION Solution Order Service Contract Flow: Level 1
P_BusSolnOrdSrvcOrdFlwLvl0 view from CONSUMPTION Solution OrderService Order Flow: Level 0
P_BusSolnOrdSrvcOrdFlwLvl1 view inner CONSUMPTION Solution Order Service Order Flow: Level 1
P_BusSolnOrdSrvcOrdFlwLvl2 view inner CONSUMPTION Solution Order Service Order Flow: Level 2
P_ServiceOrderIssueKey view inner COMPOSITE
P_ServiceOrderItemConfirmation view from COMPOSITE
P_SrvcOrdItemAggrgdActuals view from COMPOSITE
P_SrvcOrdItmFUPSrvcConfDets view from COMPOSITE
P_SrvcTransactionIssueItemC002 view inner COMPOSITE
P_SrvcTransactionIssueItemC003 view inner COMPOSITE
P_SrvcTransactionIssueItemC004 view inner COMPOSITE

Fields (3)

KeyField CDS FieldsUsed in Views
KEY ServiceDocItmRltnSqncNumber ServiceDocItmRltnSqncNumber 1
KEY ServiceDocumentItmRelationUUID ServiceDocumentItmRelationUUID 1
ServiceDocItmSuccssrCharUUID ServiceDocItmSuccssrCharUUID 1
@EndUserText.label: 'Follow-Up 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_b', value: 'BUS2000%'}],

                    table: 'crmd_brelvonai', role: #MAIN,
                    viewElement: ['ServiceDocumentItmRelationUUID', 'ServiceDocItmRltnSqncNumber'],
                    tableElement: ['relationid', 'posno']
                }
            ]
        }
    }
 }

@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}

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

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

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

//@Analytics.dataCategory: #DIMENSION

//@Metadata.allowExtensions:true

@Metadata.ignorePropagatedAnnotations: true

/*
  1902 CE: 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.

  1911 CE: DO not 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_ServiceDocumentItemSuccessor" as well.
*/

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

{
  key relationid                                                 as ServiceDocumentItmRelationUUID,
  key posno                                                      as ServiceDocItmRltnSqncNumber,

      /* CRMT_BRELVONAI */
      //      objkey_a   as ServiceDocumentItemCharUUID,

      cast(objkey_a as crms4_object_charguid32 preserving type ) as ServiceDocumentItemCharUUID,
      //      objkey_b   as ServiceDocItmSuccssrCharUUID,

      cast(objkey_b as crms4_object_charguid32 preserving type ) as ServiceDocItmSuccssrCharUUID,
      breltyp                                                    as ServiceDocumentItmRelationType,

      objtype_a                                                  as ServiceDocumentItemObjectType,
      vona_kind                                                  as ServiceDocumentItmRelationKind,
      objtype_b                                                  as ServiceDocItmSuccssrBusObjType,

      //Associations

      _ServiceDocItm

}
where
     objtype_b like 'BUS2000%'
  or objtype_b =    'VBAP'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CRMD_BRELVONAI"
],
"ASSOCIATED":
[
"I_SERVICEDOCUMENTITEMENHCD"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/