P_SRVCDOCHAVINGSGLPRDCSSRQTAN

CDS View

P_SRVCDOCHAVINGSGLPRDCSSRQTAN is a CDS View in S/4HANA. It contains 2 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 2 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_SrvcDocWithSglPrdcssrQtan view_entity from COMPOSITE

Fields (2)

KeyField CDS FieldsUsed in Views
KEY ServiceDocumentUUID ServiceDocumentUUID 1
ServiceDocument ServiceDocument 1 
@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