P_QTYCONTRACTPREDICTION
Quantity Contract Prediction
P_QTYCONTRACTPREDICTION is a CDS View in S/4HANA. Quantity Contract Prediction. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_Contractmaintain_Trans | view | left_outer | COMPOSITE | P View For Transient Fields in Contracts |
@AbapCatalog.sqlViewName: 'PQTYCONTRPREDICT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AccessControl.personalData.blocking: #NOT_REQUIRED
define view P_QtyContractPrediction
as select from I_QuantityContractPrediction
{ key PurchaseContract,
PurchasingGroup,
PurchasingOrganization,
CompanyCode,
min(ContractExpiryPredictedDate) as ContractExpiryPredictedDate
}
group by PurchaseContract,
PurchasingGroup,
PurchasingOrganization,
CompanyCode