C_SrvcQtanOutputParam

DDL: C_SRVCQTANOUTPUTPARAM SQL: CSRVCQTANOMPARA Type: view CONSUMPTION Package: CRMS4_SERVICE_QUOTATION

Service Quotation Output Parameter Determination

C_SrvcQtanOutputParam is a Consumption CDS View that provides data about "Service Quotation Output Parameter Determination" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocument) and exposes 13 fields with key fields ServiceDocument, ServiceObjectType. It has 2 associations to related views. Part of development package CRMS4_SERVICE_QUOTATION.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocument I_ServiceDocument from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_CustMgmtBusObjType _ServiceObjType _ServiceObjType.BusinessObjectType = 'BUS2000116'
[0..1] E_ServiceDocument _ServiceDocumentExt $projection.ServiceObjectType = _ServiceDocumentExt.ServiceCategory and $projection.ServiceDocument = _ServiceDocumentExt.ServiceOrder

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CSRVCQTANOMPARA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Service Quotation Output Parameter Determination view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocument ServiceDocument
KEY ServiceObjectType ServiceObjectType
ServiceDocumentType ServiceDocumentType
SalesOrganization SalesOrganization
DistributionChannel DistributionChannel
Division Division
ServiceDocumentHasError ServiceDocumentHasError
ServiceDocumentIsRejected ServiceDocumentIsRejected
ServiceDocumentIsReleased ServiceDocumentIsReleased
ServiceDocumentIsOpen ServiceDocumentIsOpen
CompanyCode _SalesOrganization CompanyCode
_ServiceObjType _ServiceObjType
_ServiceDocumentType _ServiceDocumentType 
@AbapCatalog.sqlViewName: 'CSRVCQTANOMPARA'
@AbapCatalog.compiler.compareFilter: true
@AccessControl :{
    authorizationCheck: #CHECK,
    personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Service Quotation Output Parameter Determination'
@AbapCatalog.preserveKey: true
@ObjectModel.usageType: {
             dataClass: #MIXED,
        serviceQuality: #A,
          sizeCategory: #L
          }
@VDM: {
  viewType: #CONSUMPTION
}
define view C_SrvcQtanOutputParam
  as select from I_ServiceDocument
  association [1..1] to I_CustMgmtBusObjType as _ServiceObjType     on  _ServiceObjType.BusinessObjectType = 'BUS2000116'
  association [0..1] to E_ServiceDocument    as _ServiceDocumentExt on  $projection.ServiceObjectType = _ServiceDocumentExt.ServiceCategory
                                                                    and $projection.ServiceDocument   = _ServiceDocumentExt.ServiceOrder

{
  key ServiceDocument,
      @ObjectModel.foreignKey.association: '_ServiceObjType'
  key ServiceObjectType,
      @ObjectModel.foreignKey.association: '_ServiceDocumentType'
      ServiceDocumentType,
      SalesOrganization,
      DistributionChannel,
      Division,
      ServiceDocumentHasError,
      ServiceDocumentIsRejected,
      ServiceDocumentIsReleased,
      ServiceDocumentIsOpen,      
      _SalesOrganization.CompanyCode,
      //Associations

      _ServiceObjType, 
      _ServiceDocumentType

}

where

  ServiceDocumentIsQuotation = 'X'

Learn More