I_ServiceDocItemTypeSlsSttg

DDL: I_SERVICEDOCITEMTYPESLSSTTG Type: view BASIC

Sales Setting for Srvc Trans Item Cat

I_ServiceDocItemTypeSlsSttg is a Basic CDS View (Dimension) that provides data about "Sales Setting for Srvc Trans Item Cat" in SAP S/4HANA. It reads from 1 data source (crmc_sales_item) and exposes 4 fields with key field ServiceDocItemCategory. It has 1 association to related views.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
crmc_sales_item crmc_sales_item from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ServiceDocItemCategory _ServiceDocItemCategory $projection.ServiceDocItemCategory = _ServiceDocItemCategory.ServiceDocItemCategory

Annotations (14)

NameValueLevelField
EndUserText.label Sales Setting for Srvc Trans Item Cat view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ISERVDOCITMSLSTG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey ServiceDocItemCategory view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
Analytics.dataCategory #DIMENSION view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocItemCategory itm_type
ItemIsBillingRelevant billing_relevant
SrvcDocQuotationItemIsCopied copy_quote
_ServiceDocItemCategory _ServiceDocItemCategory 
@EndUserText.label: 'Sales Setting for Srvc Trans Item Cat'
@ClientHandling.algorithm: #SESSION_VARIABLE

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

@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ObjectModel: {
   representativeKey: 'ServiceDocItemCategory',
   usageType: {
     dataClass:      #CUSTOMIZING,
     serviceQuality: #X,
     sizeCategory:   #S
   },
   supportedCapabilities: [#ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE]
}

@Analytics.dataCategory: #DIMENSION
@Metadata.allowExtensions:true
@Metadata.ignorePropagatedAnnotations: true



define view I_ServiceDocItemTypeSlsSttg
  as select from crmc_sales_item
  association [1..1] to I_ServiceDocItemCategory as _ServiceDocItemCategory on $projection.ServiceDocItemCategory = _ServiceDocItemCategory.ServiceDocItemCategory
{

      @ObjectModel.foreignKey.association: '_ServiceDocItemCategory'
  key itm_type             as ServiceDocItemCategory,
      billing_relevant     as ItemIsBillingRelevant,
      @Semantics.booleanIndicator 
       case is_quotation
         when '0' then ' '
         when '2' then 'X'
         when '3' then ' '
                  else ' '
       end                  as SrvcDocItemCategoryIsQuotation,
       @Semantics.booleanIndicator 
       copy_quote           as SrvcDocQuotationItemIsCopied,      

      _ServiceDocItemCategory

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

Learn More