P_SrvcDocWithSglPrdcssrQtan

DDL: P_SRVCDOCWITHSGLPRDCSSRQTAN Type: view_entity COMPOSITE

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

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
P_SrvcDocHavingSglPrdcssrQtan srvcdoc 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 (3)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocumentUUID P_SrvcDocHavingSglPrdcssrQtan ServiceDocumentUUID
ServiceDocument P_SrvcDocHavingSglPrdcssrQtan ServiceDocument
ReferenceServiceQtan 
@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_SrvcDocWithSglPrdcssrQtan
  as select from            P_SrvcDocHavingSglPrdcssrQtan as srvcdoc

    left outer to many join I_ServiceDocumentPredecessor  as docflow on  docflow.ServiceDocumentUUID         = srvcdoc.ServiceDocumentUUID
                                                                     and docflow.ServiceDocumentRelationType = 'VONA'
                                                                     and docflow.ServiceDocPrdcssrBusObjType = 'BUS2000116'

{
  key srvcdoc.ServiceDocumentUUID,
      srvcdoc.ServiceDocument,
      docflow._ServiceDoc[1:inner where ServiceDocumentUUID = docflow.ServiceDocumentPredecessorUUID and ServiceDocumentIsQuotation = 'X'].ServiceDocument as ReferenceServiceQtan
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERVICEDOCUMENTENHCD",
"I_SERVICEDOCUMENTPREDECESSOR",
"P_SRVCDOCHAVINGSGLPRDCSSRQTAN"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More