P_QUANTITYCONTRACTPREDICTION

CDS View

I_QuantityContractPrediction

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

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_QuantityContractAcctAssgmt view union_all CONSUMPTION Quantity Contract Account Assignment 
@ClientHandling.algorithm: #SESSION_VARIABLE //Inserted by VDM CDS Suite Plugin

@ObjectModel.usageType.dataClass:  #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality:#C
@ObjectModel.usageType.sizeCategory: #L
@AbapCatalog.sqlViewName: 'PQTYCONPREDICT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'I_QuantityContractPrediction'
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED

define view P_QuantityContractPrediction

  with parameters
    P_DisplayCurrency : displaycurrency,
    P_StartDate       : vdm_validitystart,
    P_EndDate         : vdm_validitystart

  as select from P_QuantityContractPrediction1( P_DisplayCurrency:$parameters.P_DisplayCurrency,
                                                P_StartDate:$parameters.P_StartDate,
                                                P_EndDate:$parameters.P_EndDate) as ContractPrediction
{
  key ContractPrediction.PurchaseContract,
  key ContractPrediction.PurchaseContractItem,
  key ContractPrediction.AccountAssignmentNumber,
  key ContractPrediction.ReleaseOrder,
  key ContractPrediction.ReleaseOrderItem, 

      FormattedPurchaseContractItem,

      Supplier,
      ContractPrediction.PurchasingGroup,
      ContractPrediction.PurchasingOrganization,
      ContractPrediction.CompanyCode,

      ContractPrediction.Material,
      ContractPrediction.MaterialGroup,
      ContractPrediction.Plant,
      PurchasingDocumentCategory,
      ContractPrediction.PurchaseContractType,
      PurchasingDocumentItemCategory,

      CostCenter,

      CreatedByUser,
      ValidityEndDate,
      ValidityStartDate,

      @Semantics.currencyCode: true
      cast( $parameters.P_DisplayCurrency as displaycurrency ) as DisplayCurrency,

      @Semantics.unitOfMeasure: true
      ContractPrediction.OrderQuantityUnit,

      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      TargetQuantity,

      case when PredictedDaysToContrExpiry > 365
            then 0
           else  ContractNetPriceAmount * MultipleAcctAssgmtDistrPercent * (TargetQuantity - ReleaseOrderItemOrderQuantity)
      end                                                      as PredictedConsumptionAmount,

      @DefaultAggregation: #SUM

      cast( 0 as mm_a_release_order_quantity )                 as ReleaseOrderItemOrderQuantity,

      ContractExpiryPredictedDate,
      PredictedDaysToContrExpiry

}

Learn More