P_SrvcDocHavingSglPrdcssrQtan

DDL: P_SRVCDOCHAVINGSGLPRDCSSRQTAN Type: view_entity COMPOSITE

P_SrvcDocHavingSglPrdcssrQtan is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentPredecessor) and exposes 2 fields with key field ServiceDocumentUUID.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentPredecessor docflow from

Annotations (8)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #NONE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocumentUUID I_ServiceDocumentPredecessor ServiceDocumentUUID
ServiceDocument srvcdoc ServiceDocument 
@VDM: {
  private: true,
  viewType: #COMPOSITE,
  lifecycle.contract.type: #NONE
}
@AccessControl: {
  authorizationCheck: #NOT_REQUIRED
}
@ObjectModel: {
  usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
}
@Metadata: {
  ignorePropagatedAnnotations: true
}

define view entity P_SrvcDocHavingSglPrdcssrQtan
  as select from           I_ServiceDocumentPredecessor as docflow

    left outer to one join I_ServiceDocument            as srvcdoc on docflow.ServiceDocumentUUID = srvcdoc.ServiceDocumentUUID

{
  key docflow.ServiceDocumentUUID,
      srvcdoc.ServiceDocument
}
where
      docflow.ServiceDocumentRelationType            = 'VONA'
  and docflow.ServiceDocPrdcssrBusObjType            = 'BUS2000116'
  and docflow._ServiceDoc.ServiceDocumentIsQuotation = 'X'
group by
  docflow.ServiceDocumentUUID,
  srvcdoc.ServiceDocument
having
  count(*) = 1
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERVICEDOCUMENT",
"I_SERVICEDOCUMENTENHCD",
"I_SERVICEDOCUMENTPREDECESSOR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More