I_PurOrdSchedLineEnhcdAPI01

//The view contains schedule line details in addition to item level details for Purchase Orders and mostly used for analytical purpose

@AbapCatalog.sqlViewName: 'IMMPOSCENHAPI01'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE ]
@VDM.viewType : #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@EndUserText.label: 'Purchase Order Schedule Line Details'
define view I_PurOrdSchedLineEnhcdAPI01 
as select from I_PurOrdScheduleLineEnhanced

{
  key PurchaseOrder,
  key PurchaseOrderItem,
  key ScheduleLine,
  key ProcurementHubSourceSystem,
      ScheduleLineUniqueID,
      PurchasingOrganization,
      PurchasingGroup,
      CompanyCode,
      PurgDocHdrCompanyCode,
      Supplier,
      Plant,
      Material,
      MaterialGroup,

      PurchaseOrderItemText,

      ServicePerformer,

      @Semantics.currencyCode: true
      DocumentCurrency,
      @Semantics.currencyCode: true
      AnalyticalReportingCurrency,
      @Semantics.currencyCode: true
      AnalyticalReportingCurrency2,
      @Semantics.currencyCode: true
      CompanyCodeCurrency,

      AnlytlCrcyExchangeRateStatus,


      @Semantics.amount.currencyCode: 'AnalyticalReportingCurrency'
      NetPriceInReportingCurrency,
      @Semantics.amount.currencyCode: 'AnalyticalReportingCurrency2'
      NetPriceInReportingCurrency2,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      NetPriceAmount,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      NetPriceInCompanyCodeCrcy,

      

      @Semantics.amount.currencyCode: 'AnalyticalReportingCurrency'
      NetAmountInReportingCurrency,
      @Semantics.amount.currencyCode: 'AnalyticalReportingCurrency2'
      NetAmountInReportingCurrency2,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      NetAmount,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      NetAmountInCoCodeCurrency,
      @Semantics.amount.currencyCode: 'AnalyticalReportingCurrency'
      OpenAmountInReportingCurrency,
      @Semantics.amount.currencyCode: 'AnalyticalReportingCurrency2'
      OpenAmountInReportingCurrency2,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      OpenAmountInDocumentCurrency,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      OpenAmountInCompanyCodeCrcy,

      //MMPUR_S_ANA_OTHER_ATTRIBUTES


      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      ScheduleLineOpenQuantity,
      @Semantics.unitOfMeasure: true
      OrderQuantityUnit,
      IsCompletelyDelivered,
      GoodsReceiptIsExpected,
      PurchasingDocumentDeletionCode,
      PurgDocumentItemDeletionCode,
      PurchasingCompletenessStatus,
      PurgDocSchdLnHasNextDelivery,
      PurchaseOrderCategory,
      PurchaseOrderType,
      PurchaseOrderItemCategory,
      AccountAssignmentCategory,
      CreationDate,
      PurchasingDocumentOrigin,
      CreatedByUser,
      LastChangeDateTime,
      PurchasingProcessingStatus,
      PurchaseOrderDate,
      PurchasingDocumentIsAged,
      ProductTypeCode,
      ReleaseIsNotCompleted,
      
      @Semantics.unitOfMeasure: true
      PurchaseOrderQuantityUnit,
      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit'
      OrderQuantity,
            

      //Time Variance Data


      PurOrdItmFirstGRPostingDate,
      PurOrdItmFinalGRPostingDate,
      OriglPurOrdItm1stGRPostgDte,
      OriglPurOrdItmFnlGRPostgDte,
      POItmFinalScheduleLineIsActive,
      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit'
      POPrevSchdLnTotalExpectedQty,
      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit'
      POScheduleLineTotalExpectedQty,

      TimeVarianceInDays,
      TimeVarianceInPct,
      TimeVarianceInPctByDelivDate,
      TimeVarianceScore,
      TimeVarianceScoreByDelivDate,

      // MMPUR_ANA_EKETDATA


      ScheduleLineDeliveryDate,
      SchedLineStscDeliveryDate,
      OriglPOSchdLnDelivDte,
      OriglPOSchedLineStstclDelivDte,

      DelivDateCategory,

      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      ScheduleLineOrderQuantity,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      PrevDelivQtyOfScheduleLine,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      GoodsReceiptQuantity,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      ScheduleLineIssuedQuantity,

      ScheduleLineDeliveryTime,
      PurchaseRequisition,
      PurchaseRequisitionItem,

      SourceOfCreation,
      PurchasingSchdLnNrOfReminders,
      SchedulingAgreementReleaseType,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      ScheduleLineCommittedQuantity,
      ProductAvailabilityDate,
      ProductAvailabilityTime,
      LoadingDate,
      LoadingTime,
      TransportationPlanningDate,
      TransportationPlanningTime,
      GoodsIssueDate,
      GoodsIssueTime,
      STOLatestPossibleGRDate,
      STOLatestPossibleGRTime,
      PurchaseContractItem,
      PurchaseContract,
      MultipleAcctAssgmtDistribution,
      IsReturnsItem,
      SupplierConfirmationControlKey,
      @Semantics.quantity.unitOfMeasure: 'OrderPriceUnit'
      NetPriceQuantity,
      OrderItemQtyToBaseQtyNmrtr,
      OrderItemQtyToBaseQtyDnmntr,
      BaseUnit,
      @Semantics.unitOfMeasure: true
      OrderPriceUnit,
      SupplyingPlant,
      MaterialDocumentYear,
      MaterialDocument,
      MaterialDocumentItem,
      PostingDate,
      PurOrdItmAnlytsIndIsActv
}