P_QuantityContract

@ClientHandling.algorithm: #SESSION_VARIABLE //Inserted by VDM CDS Suite Plugin

@ObjectModel.usageType.dataClass:  #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality:#C
@ObjectModel.usageType.sizeCategory: #L 
@AbapCatalog.sqlViewName: 'PQTYCONTRACT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
define view P_QuantityContract as select from I_PurchaseContractItem as PurchaseContractItem

inner join I_PurchaseContract as PurchaseContract
    on  PurchaseContractItem.PurchaseContract = PurchaseContract.ActivePurchasingDocument

inner join I_CalendarDate  as RelevantDates
    on  PurchaseContract.ValidityStartDate = RelevantDates.CalendarDate

inner join I_PurContractClassification as ContractClassification
    on  PurchaseContract.PurchaseContractType = ContractClassification.PurchasingDocumentType

//left outer join I_PurchaseContractHistory on 

//    PurchaseContractItem.PurchaseContract       = I_PurchaseContractHistory.PurchaseContract and

//    PurchaseContractItem.PurchaseContractItem   = I_PurchaseContractHistory.PurchaseContractItem



//left outer join P_ReleaseDocumentationValues3 as ReleaseDocumentation

//    on  PurchaseContractItem.PurchaseContract = ReleaseDocumentation.PurchaseContract

//    and PurchaseContractItem.PurchaseContractItem = ReleaseDocumentation.PurchaseContractItem

{
  PurchaseContract.ActivePurchasingDocument as PurchaseContract,
  PurchaseContract.PurchaseContractType,

    PurchaseContract.PurchasingOrganization,
    PurchaseContract.PurchasingGroup,
    Plant,
    PurchaseContractItem.PurchaseContractItem, 
    CalendarYear, 
    CalendarQuarter, 
    CalendarMonth, 
    CalendarWeek,
    OrderQuantityUnit, 
    PurchaseContract.ValidityStartDate,
    PurchaseContract.ValidityEndDate,
    TargetQuantity, 
    TargetAmount, 
   
//    ReleaseOrderItemNetAmount, 

//    ReleaseOrderItemOrderQuantity,

//    ReleaseOrderCurrency,

//    ReleaseOrderItemLastChgDate,

    dats_days_between(ValidityStartDate, ValidityEndDate) as CONT_LEN
    
} 
  where ContractClassification.PurchaseContractClassification = '1' and ValidityEndDate!='00000000' and ValidityStartDate!= '00000000' and PurchaseContract.IsEndOfPurposeBlocked = ''