I_ServiceQuotationType

DDL: I_SERVICEQUOTATIONTYPE SQL: QUOTETRANSTYPE Type: view BASIC

Transaction Types relevant to quotation

I_ServiceQuotationType is a Basic CDS View that provides data about "Transaction Types relevant to quotation" in SAP S/4HANA. It reads from 5 data sources (crmc_it_assign, crmc_item_type, crmc_sales_head, crmc_sales_item, I_ServiceDocumentTypeStdVH) and exposes 6 fields with key fields ServiceDocumentType, ServiceDocItemCategory, ItemCategoryGroup.

5 data source(s) 6 fields

Data Sources (5)

SourceAliasJoin Type
crmc_it_assign _it_assign inner
crmc_item_type _item_type inner
crmc_sales_head _sales_head inner
crmc_sales_item _sales_item inner
I_ServiceDocumentTypeStdVH I_ServiceDocumentTypeStdVH from

Annotations (13)

NameValueLevelField
EndUserText.label Transaction Types relevant to quotation view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName QUOTETRANSTYPE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey ServiceDocumentType view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.dataCategory #VALUE_HELP view
Search.searchable true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocumentType ServiceDocumentType
KEY ServiceDocItemCategory crmc_item_type itm_type
KEY ItemCategoryGroup crmc_it_assign item_cat_group
ServiceObjectType ServiceObjectType
PrcgProcedureDocumentClfn doc_pric_proc
_ServiceDocumentTypeText _ServiceDocumentTypeText 
@EndUserText.label: 'Transaction Types relevant to quotation'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'QUOTETRANSTYPE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM: {
  viewType: #BASIC
  }
@AccessControl.authorizationCheck: #CHECK

@ObjectModel: {
   representativeKey: 'ServiceDocumentType',
   usageType: {
     dataClass:      #META,
     serviceQuality: #B,
     sizeCategory:   #S
   },
   dataCategory: #VALUE_HELP
}   

@Search.searchable: true

define view I_ServiceQuotationType
  as select from I_ServiceDocumentTypeStdVH

    inner join   crmc_sales_head as _sales_head on I_ServiceDocumentTypeStdVH.ServiceDocumentType = _sales_head.process_type 
    inner join   crmc_it_assign  as _it_assign  on I_ServiceDocumentTypeStdVH.ServiceDocumentType = _it_assign.process_type and _it_assign.item_type_main = ''
    inner join   crmc_item_type  as _item_type  on _it_assign.itm_type = _item_type.itm_type
    inner join   crmc_sales_item as _sales_item on _it_assign.itm_type = _sales_item.itm_type
  //association [0..1] to I_SrvcMgmtSlsTransacParameter as _SrvcMgmtSlsTransacParameter on $projection.ServiceDocumentType = I_ServiceDocumentTypeStdVH.ServiceDocumentType

{


      @ObjectModel.text.association: '_ServiceDocumentTypeText'
  key ServiceDocumentType,
  key _item_type.itm_type as ServiceDocItemCategory,
  key _it_assign.item_cat_group as ItemCategoryGroup,
      ServiceObjectType,
      //_SrvcMgmtSlsTransacParameter.PricingProcedure,

       doc_pric_proc as PrcgProcedureDocumentClfn,
      _ServiceDocumentTypeText

}
where
       I_ServiceDocumentTypeStdVH.ServiceObjectType = 'BUS2000116'
  and(
       doc_pric_proc                                = 'S1'
    or doc_pric_proc                                = 'S4'

//          _SrvcMgmtSlsTransacParameter.PricingProcedure = 'S1'

//          or _SrvcMgmtSlsTransacParameter.PricingProcedure = 'S4'

  )
  and  _sales_item.is_quotation                     = '2'

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERVICEDOCUMENTTYPESTDVH",
"CRMC_ITEM_TYPE",
"CRMC_IT_ASSIGN",
"CRMC_SALES_HEAD",
"CRMC_SALES_ITEM"
],
"ASSOCIATED":
[
"I_SERVICEDOCUMENTTYPETEXT"
],
"BASE":
[
"I_SERVICEDOCUMENTTYPESTDVH"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More