P_SourcingProjectBiddingCount

DDL: P_SOURCINGPROJECTBIDDINGCOUNT Type: view_entity COMPOSITE

P_SourcingProjectBiddingCount is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (R_SourcingProject) and exposes 4 fields with key field SourcingProjectUUID.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
R_SourcingProject R_SourcingProject from

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY SourcingProjectUUID SourcingProjectUUID
NumberOfBidders
NumberOfBiddersWithRefusal
BidderasNumberOfBiddersWithQuotation 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED

@VDM.viewType: #COMPOSITE
@VDM.private: true

define view entity P_SourcingProjectBiddingCount
  as select from R_SourcingProject
{
  key SourcingProjectUUID,

      count( distinct _SrcgProjPubdSuplrListBP.SrcgProjPubdSuplrListUUID)                                         as NumberOfBidders,
      count( distinct _SrcgProjPubdSuplrListBP[SrcgProjParticipationStatus = '03'].SrcgProjPubdSuplrListUUID )    as NumberOfBiddersWithRefusal,
      count( distinct _SourcingProjectQuotation[SrcgProjQtnLifecycleStatus = '02'
                                             or SrcgProjQtnLifecycleStatus = '03'
                                             or SrcgProjQtnLifecycleStatus = '08'].Bidder)                     as NumberOfBiddersWithQuotation
      /*count( distinct _SourcingProjectQuotation[SrcgProjQtnLifecycleStatus = '02'
                                             or SrcgProjQtnLifecycleStatus = '03'
                                             or SrcgProjQtnLifecycleStatus = '08'].SourcingProjectQuotationUUID ) as NumberOfBiddersWithQuotation*/
}
group by
  SourcingProjectUUID
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SOURCINGPROJECTQUOTATION",
"I_SRCGPROJPUBDSUPLRLISTBP",
"R_SOURCINGPROJECT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More