C_SrvcOrderOutputParam

DDL: C_SRVCORDEROUTPUTPARAM SQL: CSRVCORDOUPTPARM Type: view CONSUMPTION

Service Order Output Parameter Determination

C_SrvcOrderOutputParam is a Consumption CDS View that provides data about "Service Order 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 1 association to related views.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocument I_ServiceDocument from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_ServiceDocument _ServiceDocumentExt $projection.ServiceObjectType = _ServiceDocumentExt.ServiceCategory and $projection.ServiceDocument = _ServiceDocumentExt.ServiceOrder

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CSRVCORDOUPTPARM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view
EndUserText.label Service Order Output Parameter Determination 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
_ServiceDocHasError _ServiceDocHasError
_ServiceObjType _ServiceObjType
_ServiceDocumentType _ServiceDocumentType 
@AbapCatalog.sqlViewName: 'CSRVCORDOUPTPARM'
@AbapCatalog.compiler.compareFilter: true

@AccessControl :{
    authorizationCheck: #NOT_REQUIRED,
    personalData.blocking: #('TRANSACTIONAL_DATA')
}
@AbapCatalog.preserveKey: true

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType: {
             dataClass: #TRANSACTIONAL,
             serviceQuality: #B,
             sizeCategory:  #L
          }
@VDM: {
  viewType: #CONSUMPTION
}
@EndUserText.label: 'Service Order Output Parameter Determination'

define view C_SrvcOrderOutputParam
  as select from I_ServiceDocument
  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.CompanyCode,

      SalesOrganization,
      DistributionChannel,
      Division,
      ServiceDocumentHasError,
      ServiceDocumentIsRejected,
      ServiceDocumentIsReleased,
      ServiceDocumentIsOpen,
      //Associations      

      _ServiceDocHasError,
      _ServiceObjType,
      _ServiceDocumentType

}

where
      ServiceObjectType          =  'BUS2000116'
  and ServiceDocumentIsQuotation <> 'X'
  and ServiceDocumentIsRejected  <> 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERVICEDOCUMENT"
],
"ASSOCIATED":
[
"E_SERVICEDOCUMENT",
"I_CUSTMGMTBUSOBJTYPE",
"I_SERVICEDOCERRORSTATUS",
"I_SERVICEDOCUMENTTYPE"
],
"BASE":
[
"I_SERVICEDOCUMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More