C_SrvcContrOutputParam

DDL: C_SRVCCONTROUTPUTPARAM SQL: CSRVSRVCOMPARAM Type: view CONSUMPTION Package: CRMS4_SERVICE_CONTRACT_OM

Service Contract Output Parameter Determination

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

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocument I_ServiceDocument from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BPCurrentDefaultAddress _BPAddress _BPAddress.BusinessPartner = I_ServiceDocument.ContactPerson
[0..1] E_ServiceDocument _ServiceDocumentExt $projection.ServiceObjectType = _ServiceDocumentExt.ServiceCategory and $projection.ServiceDocument = _ServiceDocumentExt.ServiceOrder

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CSRVSRVCOMPARAM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view
EndUserText.label Service Contract Output Parameter Determination view

Fields (14)

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
ContactPersonCountry
_ServiceDocumentType _ServiceDocumentType
_ServiceObjType _ServiceObjType
@AbapCatalog.sqlViewName: 'CSRVSRVCOMPARAM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl :{
    authorizationCheck: #NOT_REQUIRED,
    personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey: true
@ObjectModel.usageType: {
             dataClass: #TRANSACTIONAL,
             serviceQuality: #B,
             sizeCategory:  #L
          }
@VDM: {
  viewType: #CONSUMPTION
}
@EndUserText.label: 'Service Contract Output Parameter Determination'
define view C_SrvcContrOutputParam as select from I_ServiceDocument
association [1..1] to I_BPCurrentDefaultAddress as _BPAddress on _BPAddress.BusinessPartner = I_ServiceDocument.ContactPerson   
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,
  _BPAddress._Address.Country as ContactPersonCountry,
  _ServiceDocumentType,
  _ServiceObjType
}
where ServiceObjectType = 'BUS2000112'
and ServiceDocumentTemplateType = ''