P_CHMLCMPLMKTREQANDCOVSUM

CDS View

P_CHMLCMPLMKTREQANDCOVSUM is a CDS View in S/4HANA. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ChmlCmplMktReqAndCovGrpSum view from COMPOSITE
@AbapCatalog:
{
  sqlViewName: 'PCCMKTREQCOVS',
  compiler.compareFilter: true
}

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

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

@ObjectModel.usageType.serviceQuality: #B

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

define view P_ChmlCmplMktReqAndCovSum
  as select from P_ChmlCmplMktReqAndCov
{

  chemicalcomplianceuuid                                                             as chemicalcomplianceuuid,

  country                                                                            as Country,

  (ProductionRequested +  SalesRequested)                                           as SumRequested,
  (ProductionProcessed +  SalesProcessed)                                           as SumProcessed,
  (ProductionUnprocessed + SalesUnprocessed)                                        as SumUnprocessed
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_CHMLCMPLMKTREQANDCOV"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/