I_ServiceProductList

DDL: I_SERVICEPRODUCTLIST Type: view BASIC

Service Product List

I_ServiceProductList is a Basic CDS View that provides data about "Service Product List" in SAP S/4HANA. It reads from 1 data source (crms4d_ordprp_i) and exposes 7 fields with key fields ServiceObjectType, ServiceDocument, ServiceDocumentItem, ServiceProductListItem. It has 1 association to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
crms4d_ordprp_i crms4d_ordprp_i from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Material _Material $projection.SrvcProductListProduct = _Material.Material

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Service Product List view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ISERVPRODLIST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.representativeKey ServiceDocumentItem view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType objtype_h
KEY ServiceDocument object_id
KEY ServiceDocumentItem number_int
KEY ServiceProductListItem counter
SrvcProductListProduct product_id
ProductHierarchy prod_hierarchy
_Material _Material 
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Service Product List'

@VDM: {
  viewType: #BASIC
}
@AccessControl: {
  authorizationCheck: #NOT_REQUIRED,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@AbapCatalog: {
  sqlViewName: 'ISERVPRODLIST',
  compiler.compareFilter: true,
  preserveKey:true 
}
@ObjectModel: {
   representativeKey: 'ServiceDocumentItem',
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #XXL
   }
}




define view I_ServiceProductList
  as select from crms4d_ordprp_i
  association [0..1] to I_Material as _Material on $projection.SrvcProductListProduct = _Material.Material
{
  key objtype_h                     as ServiceObjectType,
  key object_id                     as ServiceDocument,
  key number_int                    as ServiceDocumentItem,
  key counter                       as ServiceProductListItem,

      @ObjectModel.foreignKey.association: '_Material'
      product_id                    as SrvcProductListProduct,
      prod_hierarchy                as ProductHierarchy,

      _Material

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CRMS4D_ORDPRP_I"
],
"ASSOCIATED":
[
"I_MATERIAL"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More