P_ChmlCmplncMktReqCt

DDL: P_CHMLCMPLNCMKTREQCT Type: view CONSUMPTION Package: EHFND_BO_CCI

Count Market Requests from Finished Goods and Product

P_ChmlCmplncMktReqCt is a Consumption CDS View that provides data about "Count Market Requests from Finished Goods and Product" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncMktReq) and exposes 3 fields with key field ChmlCmplncInfoUUID. Part of development package EHFND_BO_CCI.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncMktReq I_ChmlCmplncMktReq from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PCCMKTREQCT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncInfoUUID ChmlCmplncInfoUUID
QntyMReq
NmbrOfChmlCmplncReqReqd 
@AbapCatalog:
{
  -- SQL view name (16 characters)
  sqlViewName: 'PCCMKTREQCT',

  --If it's true, the filter conditions are compared and, if they match, the associated join expression is evaluated only once
  compiler.compareFilter: true
}

--Access Control: Authorizations Checks
@AccessControl:
{
  authorizationCheck: #NOT_REQUIRED
}

--Client Handling of the view
@ClientHandling.algorithm: #SESSION_VARIABLE

--VDM view type
@VDM.viewType: #CONSUMPTION
@VDM.private: true

define view P_ChmlCmplncMktReqCt
  as select from I_ChmlCmplncMktReq
{
  key ChmlCmplncInfoUUID,
      count(*) as QntyMReq,
      count(*) as NmbrOfChmlCmplncReqReqd

}
group by
  ChmlCmplncInfoUUID

Learn More