I_SERVICEQUOTATIONTYPE

CDS View

Transaction Types relevant to quotation

I_SERVICEQUOTATIONTYPE is a CDS View in S/4HANA. Transaction Types relevant to quotation. It contains 4 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 4 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_SrvcQtanTransactionType view from COMPOSITE Transaction Types for Service Quotations

Fields (4)

KeyField CDS FieldsUsed in Views
KEY ServiceDocumentType ServiceDocumentType,ServiceQuotationType 3
_ServiceDocumentTypeText _ServiceDocumentTypeText 2
PrcgProcedureDocumentClfn PrcgProcedureDocumentClfn 1
ServiceObjectType ServiceObjectType 2 
@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