P_CHMLCMPLMKTREQANDCOVSUM
Unpackaged Product Market Sum Requests Unprocessed/Covered
P_CHMLCMPLMKTREQANDCOVSUM is a CDS View in S/4HANA. Unpackaged Product Market Sum Requests Unprocessed/Covered. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_ChmlCmplMktReqAndCovGrpSum | view | from | COMPOSITE | Unpackaged Product Market Group Total Req. Unproc./Covered |
@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
}