I_PurchaseRequisitionItemBasic

@EndUserText.label: 'Purchase Requisition Item'
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'IPRITEMBASIC'
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck:#CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'PurchaseRequisitionItem'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@Consumption.semanticObject: 'PurchaseRequisition'
@AbapCatalog.compiler.compareFilter:true

define view I_PurchaseRequisitionItemBasic
  as select from eban
  association [1..1] to I_Purchaserequisition as _PurchaseRequisition on $projection.PurchaseRequisition = _PurchaseRequisition.PurchaseRequisition
  association [1..1] to I_UnitOfMeasure       as _UnitOfMeasure       on $projection.BaseUnit = _UnitOfMeasure.UnitOfMeasure
  association [0..1] to I_Currency            as _Currency            on $projection.PurReqnItemCurrency = _Currency.Currency

{
      @ObjectModel.foreignKey.association: '_PurchaseRequisition'
  key cast (banfn as vdm_purchaserequisition preserving type )     as PurchaseRequisition,

  key cast (bnfpo as vdm_purchaserequisitionitem preserving type ) as PurchaseRequisitionItem,

      purreqndescription                                           as PurReqnDescription,
      bsart                                                        as PurchaseRequisitionType,
      bstyp                                                        as PurchasingDocumentCategory,
      bsakz                                                        as PurchasingDocumentSubtype,
      loekz                                                        as IsDeleted,
      statu                                                        as ProcessingStatus,
      estkz                                                        as PurReqnOrigin,
      frgkz                                                        as ReleaseCode,
      frgzu                                                        as PurchaseRequisitionStatus,
      frgst                                                        as ReleaseStrategy,
      ekgrp                                                        as PurchasingGroup,
      ernam                                                        as CreatedByUser,
      erdat                                                        as LastChangedDate,
      afnam                                                        as RequisitionerName,
      txz01                                                        as PurchaseRequisitionItemText,
      matnr                                                        as Material,
      ematn                                                        as ManufacturerMaterial,
      werks                                                        as Plant,
      lgort                                                        as StorageLocation,
      bednr                                                        as RequirementTracking,
      matkl                                                        as MaterialGroup,
      reswk                                                        as SupplyingPlant,

      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      @DefaultAggregation: #NONE
      menge                                                        as RequestedQuantity,

      @ObjectModel.foreignKey.association: '_UnitOfMeasure'
      @Semantics.unitOfMeasure: true
      meins                                                        as BaseUnit,
      bumng                                                        as MaterialShortageQuantity,
      @Semantics.businessDate.at:true
      badat                                                        as CreationDate,
      creationdate                                                 as PurchaseReqnCreationDate,
      creationtime                                                 as CreationTime,
      badat                                                        as PurReqCreationDate,
      lpein                                                        as DelivDateCategory,
      lfdat                                                        as DeliveryDate,

      @Semantics.businessDate.at:true
      frgdt                                                        as PurchaseRequisitionReleaseDate,
      
      webaz                                                        as MaterialGoodsReceiptDuration,
      @Semantics.amount.currencyCode: 'PurReqnItemCurrency'
      @DefaultAggregation: #NONE
      preis                                                        as PurchaseRequisitionPrice,

      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      @DefaultAggregation: #NONE
      peinh                                                        as PurReqnPriceQuantity,
      pstyp                                                        as PurchasingDocumentItemCategory,
      knttp                                                        as AccountAssignmentCategory,
      kzvbr                                                        as ConsumptionPosting,
      vrtkz                                                        as MultipleAcctAssgmtDistribution,
      twrkz                                                        as PartialInvoiceDistribution,
      wepos                                                        as GoodsReceiptIsExpected,
      weunb                                                        as GoodsReceiptIsNonValuated,
      repos                                                        as InvoiceIsExpected,
      lifnr                                                        as Supplier,
      flief                                                        as FixedSupplier,
      ekorg                                                        as PurchasingOrganization,
      vrtyp                                                        as PurReqnSourceOfSupplyType,
      konnr                                                        as PurchaseContract,
      ktpnr                                                        as PurchaseContractItem,
      infnr                                                        as PurchasingInfoRecord,
      zugba                                                        as SourceOfSupplyIsAssigned,
      dispo                                                        as MRPController,
      ebeln                                                        as PurchasingDocument,
      ebelp                                                        as PurchasingDocumentItem,
      bedat                                                        as PurchaseOrderDate,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      bsmng                                                        as OrderedQuantity,
      @Semantics.amount.currencyCode: 'PurReqnItemCurrency'
      limit_consumption_value                                      as PurReqnLimitConsumptionAmt,
      ebakz                                                        as IsClosed,
      rsnum                                                        as Reservation,
      sobkz                                                        as InventorySpecialStockType,
      fixkz                                                        as PurchaseRequisitionIsFixed,
      bmein                                                        as MaterialOrderUnit,
      cast( revlv as vdm_qm_revlv preserving type )                as MaterialRevisionLevel,
      bpueb                                                        as PurchaseOrderPriceType,
      frggr                                                        as ReleaseGroup,
      frgrl                                                        as ReleaseIsNotCompleted,
      charg                                                        as Batch,
      cast( fipos as fmis_ci_internalname preserving type )        as CommitmentItemShortID,
      fistl                                                        as FundsCenter,
      geber                                                        as Fund,
      adrnr                                                        as AddressID,
      adrnr                                                        as ManualDeliveryAddressID,
      adrn2                                                        as ItemDeliveryAddressID,
      kunnr                                                        as PurReqnReceivingCustomer,
      emlif                                                        as Subcontractor,
      @ObjectModel.foreignKey.association: '_Currency'
      @Semantics.currencyCode: true
      waers                                                        as PurReqnItemCurrency, //2846005

      idnlf                                                        as SupplierMaterialNumber,
      gsfrg                                                        as IsPurReqnOvrlRel,
      mprof                                                        as ManufacturerPartProfile,
      spras                                                        as Language,
      mfrpn                                                        as ManufacturerPartNmbr,
      plifz                                                        as MaterialPlannedDeliveryDurn,
      berid                                                        as MRPArea,
      mwskz                                                        as TaxCode,
      fkber                                                        as FunctionalArea,
      grant_nbr                                                    as GrantID,
      memory                                                       as IsPurReqnCmplt,
      banpr                                                        as PurReqnReleaseStatus,
      blckd                                                        as IsPurReqnBlocked,
      blckt                                                        as PurReqnItemBlockingReasonText,
      beswk                                                        as ProcuringPlant,
      eprofile                                                     as ExternalProcurementProfile,
      kblnr                                                        as EarmarkedFundsDocument,
      kblpos                                                       as EarmarkedFundsDocumentItem,
      memorytype                                                   as PurReqnCmpltnsCat,
      mhdrz                                                        as MinRemainingShelfLife,
      budget_pd                                                    as BudgetPeriod,
      expert_mode                                                  as PurReqnIsCreatedInExpertMode,
      central_purreqn_proc                                         as PurReqnIsValdInCntrlReqnProcg,
      producttype                                                  as ProductTypeCode,
      serviceperformer                                             as ServicePerformer,
      iseopblocked                                                 as IsEndOfPurposeBlocked,
      startdate                                                    as PerformancePeriodStartDate,
      enddate                                                      as PerformancePeriodEndDate,
      extmaterialforpurg                                           as ExtMaterialForPurg,
      extfixedsupplierforpurg                                      as ExtFixedSupplierForPurg,
      extdesiredsupplierforpurg                                    as ExtDesiredSupplierForPurg,
      extcontractforpurg                                           as ExtContractForPurg,
      extcontractitemforpurg                                       as ExtContractItemForPurg,
      extinforecordforpurg                                         as ExtInfoRecordForPurg,
      extplantforpurg                                              as ExtPlantForPurg,
      extstoragelocationforpurg                                    as ProcmtHubStorageLocation,
      extcompanycodeforpurg                                        as ExtCompanyCodeForPurg,
      extpurgorgforpurg                                            as ExtPurgOrgForPurg,
      cast(extsourcesystem  as mmpur_d_hub_logsys)                 as ExtSourceSystem, //deprecate this

      ext_be_source_sys                                            as ProcurementHubSourceSystem,
      ext_be_prchangeindicator                                     as ProcmtHubPurReqnItmIsChanged,
      extdoctypeforpurg                                            as ExtPurchaseRequisitionType,
      procmthubrefdeliveryaddressid                                as ProcmtHubRefDeliveryAddressID,
      extapprovalstatus                                            as ExternalApprovalStatus,
      stagingfldextapprovalstatus                                  as ExtApprvlIntmdSts,
      purchasereqnitemuniqueid                                     as PurchaseReqnItemUniqueID,
      lastchangedatetime                                           as LastChangeDateTime,
      isonbehalfcart                                               as IsOnBehalfCart,
      sakto                                                        as GLAccount,
      kostl                                                        as CostCenter,
      @Semantics.amount.currencyCode: 'PurReqnItemCurrency'
      expected_value                                               as ExpectedOverallLimitAmount,

      @Semantics.amount.currencyCode: 'PurReqnItemCurrency'
      limit_amount                                                 as OverallLimitAmount,
      contract_for_limit                                           as PurContractForOverallLimit,
      contract_item_for_limit                                      as PurContractItemForOverallLimit,
      cuobj                                                        as PurReqnIntObjNmbr,

      fsh_season_year                                              as ProductSeasonYear,
      fsh_season                                                   as ProductSeason,
      fsh_collection                                               as ProductCollection,
      fsh_theme                                                    as ProductTheme,
      sc_sr_item_key                                               as PurReqnSSPCrossCatalogItem,
      sc_catalogid                                                 as PurReqnSSPCatalog,
      sc_catalogitem                                               as PurReqnSSPCatalogItem,
      sc_requestor                                                 as PurReqnSSPRequestor,
      sc_author                                                    as PurReqnSSPAuthor,
      sgt_scat                                                     as StockSegment,
      sgt_rcat                                                     as RequirementSegment,
      deliveryaddrtype                                             as PurchasingDeliveryAddressType,
      arsnr                                                        as SettlementReservation,
      arsps                                                        as SettlementReservationItem,
      pfmtransdatafootprintuuid                                    as PFMTransDataFootprintUUID,
      // Relevent for item Hierarchy

      isoutline                                                    as IsOutline,
      parent_item_no                                               as PurchasingParentItem,
      outline_type                                                 as PurReqnItemOutlineType,
      exlin                                                        as PurgConfigurableItemNumber,
      exsnr                                                        as PurgExternalSortNumber,
      iscrreplicationbeforeapproval                                as CntrlReqnIsRpldBfrApprvl,
      mmpur_pr_cen_reqn_app_rpld_pr                                as CntrlReqnApprvlStsInRpldReqn,
      //Added for Central approval

      indelegateapproval                                           as PurReqnHasDelegateApproval,
      qunum                                                        as QuotaArrangement,
      qupos                                                        as QuotaArrangementItem,
      _PurchaseRequisition,
      _UnitOfMeasure,
      _Currency
}
where
  iseopblocked = ''