C_ServiceQuotationTypeVH

DDL: C_SERVICEQUOTATIONTYPEVH SQL: CSRVQTANTYPE Type: view CONSUMPTION

C view for service quotation type

C_ServiceQuotationTypeVH is a Consumption CDS View that provides data about "C view for service quotation type" in SAP S/4HANA. It reads from 2 data sources (I_SrvcTransactionCopyControl, P_SrvcQtanTransactionType) and exposes 4 fields with key field ServiceDocumentType.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
I_SrvcTransactionCopyControl I_SrvcTransactionCopyControl inner
P_SrvcQtanTransactionType P_SrvcQtanTransactionType inner

Annotations (13)

NameValueLevelField
EndUserText.label C view for service quotation type view
AbapCatalog.sqlViewName CSRVQTANTYPE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.representativeKey ServiceDocumentType view
ObjectModel.dataCategory #VALUE_HELP view
AccessControl.authorizationCheck #CHECK view
Search.searchable true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocumentType I_ServiceQuotationType ServiceDocumentType
ServiceObjectType I_ServiceQuotationType ServiceObjectType
PrcgProcedureDocumentClfn I_ServiceQuotationType PrcgProcedureDocumentClfn
_ServiceDocumentTypeText I_ServiceQuotationType _ServiceDocumentTypeText 
@EndUserText.label: 'C view for service quotation type'
@AbapCatalog.sqlViewName: 'CSRVQTANTYPE'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM: {
  viewType: #CONSUMPTION
  }
@ObjectModel:{
  usageType.dataClass: #CUSTOMIZING,
  usageType.serviceQuality: #C,
  usageType.sizeCategory: #S,
  representativeKey: 'ServiceDocumentType',
   dataCategory: #VALUE_HELP
}
@AccessControl.authorizationCheck: #CHECK
@Search.searchable: true

define view C_ServiceQuotationTypeVH
  as select distinct from I_ServiceQuotationType 
  inner join            I_SrvcTransactionCopyControl on  I_SrvcTransactionCopyControl.SrvcTargetTransactionType = I_ServiceQuotationType.ServiceDocumentType
    //To Remove In House Repair Quotation from Service Quotation value help. Check : Predecessor for Repair Quotation shouldnt be Object Type BUS2000256

                                                       and I_SrvcTransactionCopyControl.ServiceDocPredecessorObjType != 'BUS2000256'
                                                       and I_SrvcTransactionCopyControl.ServiceDocPredecessorObjType != 'BUS2000116'
  //To Remove In House Repair Quotation from Service Quotation value help.

  inner join            P_SrvcQtanTransactionType      on  P_SrvcQtanTransactionType.ServiceDocumentType        = I_ServiceQuotationType.ServiceDocumentType
                                                       and P_SrvcQtanTransactionType.RefInHouseRepairIsExisting is null
   
  {
  
   @ObjectModel.text.association: '_ServiceDocumentTypeText'
      @Search.defaultSearchElement: true
  key I_ServiceQuotationType.ServiceDocumentType,
      I_ServiceQuotationType.ServiceObjectType,
      I_ServiceQuotationType.PrcgProcedureDocumentClfn,
      I_ServiceQuotationType._ServiceDocumentTypeText 
  }
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERVICEQUOTATIONTYPE",
"I_SRVCTRANSACTIONCOPYCONTROL",
"P_SRVCQTANTRANSACTIONTYPE"
],
"ASSOCIATED":
[
"I_SERVICEDOCUMENTTYPETEXT"
],
"BASE":
[
"I_SERVICEQUOTATIONTYPE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More