I_ServiceDocumentItemPrdcssr

DDL: I_SERVICEDOCUMENTITEMPRDCSSR Type: view BASIC

Service Document Item Predecessor

I_ServiceDocumentItemPrdcssr is a Basic CDS View that provides data about "Service Document Item Predecessor" in SAP S/4HANA. It reads from 1 data source (crmd_brelvonai) and exposes 20 fields with key fields ServiceDocumentItmRelationUUID, ServiceDocItmRltnSqncNumber. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
crmd_brelvonai crmd_brelvonai from

Associations (3)

CardinalityTargetAliasCondition
[1] I_ServiceDocumentItemEnhcd _ServiceDocItm $projection.ServiceDocumentItmPrdcssrUUID = _ServiceDocItm.ServiceDocumentItemUUID and $projection.ServiceDocItmPrdcssrBusObjType = _ServiceDocItm.ServiceDocumentItemObjectType
[0..1] I_UnitOfMeasure _BaseUnit $projection.SrvcDocItmDocFlowQuantityUnit = _BaseUnit.UnitOfMeasure
[0..1] I_Currency _TransactionCurrency $projection.SrvcDocItmDocFlowCurrency = _TransactionCurrency.Currency

Annotations (14)

NameValueLevelField
EndUserText.label Service Document Item Predecessor view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor I_ServiceDocumentItemPrdcssr_2 view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ISERVDOCITMPRE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocumentItmRelationUUID relationid
KEY ServiceDocItmRltnSqncNumber posno
ServiceDocItmPrdcssrCharUUID objkey_a
ServiceDocumentItemCharUUID objkey_b
ServiceDocumentItmRelationType breltyp
CharcLength
ServiceDocumentItmPrdcssrUUID
ServiceDocItmPrdcssrBusObjType objtype_a
ServiceDocumentItmRelationKind vona_kind
ServiceDocumentItemUUID
ServiceDocumentItemObjectType objtype_b
SrvcDocItmDocFlowQuantityUnit quantity_unit
SrvcDocItmDocFlowQuantity quantity
SrvcDocItmDocFlowCurrency currency
SrvcDocumentItmDocFlowAmount value
SrvcDocItmDocFlowBillingInfo doc_info
SrvcDocItmDocFlowQtyIsDiffnt qty_difference
_ServiceDocItm _ServiceDocItm
_TransactionCurrency _TransactionCurrency
_BaseUnit _BaseUnit
@EndUserText.label: 'Service Document Item Predecessor'
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API,
  lifecycle.status: #DEPRECATED,
  lifecycle.successor: 'I_ServiceDocumentItemPrdcssr_2'
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@AbapCatalog: {
  sqlViewName: 'ISERVDOCITMPRE',
  compiler.compareFilter: true ,
  preserveKey: true
}
@ObjectModel: {
//   representativeKey: 'ServiceDocumentItmRelationUUID',

   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #XL
   }
}

//@Analytics.dataCategory: #DIMENSION

//@Metadata.allowExtensions:true

@Metadata.ignorePropagatedAnnotations: true
/*
  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.
*/

/* !!!DONOT USE THIS VIEW. SOON IT IS GOING TO BE DEPRECATED!!! */

define view I_ServiceDocumentItemPrdcssr
  as select from crmd_brelvonai
  association [1]    to I_ServiceDocumentItemEnhcd as _ServiceDocItm       on  $projection.ServiceDocumentItmPrdcssrUUID  = _ServiceDocItm.ServiceDocumentItemUUID
                                                                           and $projection.ServiceDocItmPrdcssrBusObjType = _ServiceDocItm.ServiceDocumentItemObjectType

  association [0..1] to I_UnitOfMeasure            as _BaseUnit            on  $projection.SrvcDocItmDocFlowQuantityUnit = _BaseUnit.UnitOfMeasure

  association [0..1] to I_Currency                 as _TransactionCurrency on  $projection.SrvcDocItmDocFlowCurrency = _TransactionCurrency.Currency

{
  key relationid         as ServiceDocumentItmRelationUUID,
  key posno              as ServiceDocItmRltnSqncNumber,

      objkey_a           as ServiceDocItmPrdcssrCharUUID,
      objkey_b           as ServiceDocumentItemCharUUID,

      breltyp            as ServiceDocumentItmRelationType,

      /* CRMT_BRELVONAI */
      length(objkey_a)   as CharcLength,
      hextobin(objkey_a) as ServiceDocumentItmPrdcssrUUID,
      objtype_a          as ServiceDocItmPrdcssrBusObjType,
      vona_kind          as ServiceDocumentItmRelationKind,
      hextobin(objkey_b) as ServiceDocumentItemUUID,
      objtype_b          as ServiceDocumentItemObjectType,

      @ObjectModel.foreignKey.association: '_BaseUnit'
      @Semantics.unitOfMeasure:true
      quantity_unit      as SrvcDocItmDocFlowQuantityUnit,
      //@DefaultAggregation: #SUM

      @Semantics: { quantity : {unitOfMeasure: 'SrvcDocItmDocFlowQuantityUnit'} }
      quantity           as SrvcDocItmDocFlowQuantity,

      //      @ObjectModel.foreignKey.association: '_TransactionCurrency'

      @API.element.releaseState: #DEPRECATED
      @Semantics.currencyCode:true
      currency           as SrvcDocItmDocFlowCurrency,
      @API.element.releaseState: #DEPRECATED
      @Semantics: { amount : {currencyCode: 'SrvcDocItmDocFlowCurrency'} }
      value              as SrvcDocumentItmDocFlowAmount,
      doc_info           as SrvcDocItmDocFlowBillingInfo,
      qty_difference     as SrvcDocItmDocFlowQtyIsDiffnt,

      //Associations

      _ServiceDocItm,
      _TransactionCurrency,
      _BaseUnit

}
where
  objtype_a like 'BUS2000%'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CRMD_BRELVONAI"
],
"ASSOCIATED":
[
"I_CURRENCY",
"I_SERVICEDOCUMENTITEMENHCD",
"I_UNITOFMEASURE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/