I_ProcmtHubPurReqnItem

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_ProcmtHubPurReqnItem.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IPROCMTHUBPRITEM

CREATE VIEW I_ProcmtHubPurReqnItem AS
SELECT
  purchaserequisition AS ProcmtHubPurchaseRequisition,
  purchaserequisitionitem AS ProcmtHubPurRequisitionItem,
  extsourcesystem AS ProcurementHubSourceSystem,
  purchaserequisitiontype AS ProcmtHubPurRequisitionType,
  ProcessingStatus,
  purchasinggroup AS ProcmtHubPurchasingGroup,
  PurchaseRequisitionItemText,
  material AS ProcmtHubProduct,
  plant AS ProcmtHubPlant,
  materialgroup AS ProcmtHubProductGroup,
  RequestedQuantity,
  BaseUnit,
  DeliveryDate,
  CreationDate,
  PurchaseRequisitionPrice,
  IsDeleted,
  accountassignmentcategory AS ProcmtHubAcctAssgmtCategory,
  purchasingdocumentitemcategory AS ProcmtHubPurgDocItmCategory,
  GoodsReceiptIsExpected,
  InvoiceIsExpected,
  supplier AS ProcmtHubSupplier,
  fixedsupplier AS ProcmtHubFixedSupplier,
  PurReqnItemCurrency,
  IsPurReqnBlocked,
  ProductType,
  RequisitionerName,
  createdbyuser AS ProcmtHubCreatedByUser,
  PurchaseRequisitionIsFixed,
  LastChangedDate,
  suppliermaterialnumber AS ProcmtHubSupplierProductNumber,
  batch AS ProcmtHubBatch,
  requirementtracking AS ProcmtHubRequirementTracking,
  PurReqnItemBlockingReason,
  purreqnitemblockingreason AS PurReqnItemBlockingReasonText,
  cast( materialrevisionlevel as vdm_qm_revlv) AS MaterialRevisionLevel,
  IsClosed,
  MaterialPlannedDeliveryDurn,
  MaterialGoodsReceiptDuration,
  PurchaseOrderPriceType,
  GoodsReceiptIsNonValuated,
  supplyingplant AS ProcmtHubSupplyingPlant,
  purchasecontract AS ProcmtHubPurchaseContract,
  purchasecontractitem AS ProcmtHubPurchaseContractItem,
  purchasinginforecord AS ProcmtHubPurchasingInfoRecord,
  mrpcontroller AS ProcmtHubMRPController,
  PurReqnOrigin,
  purchasingorganization AS ProcmtHubPurchasingOrg,
  ServicePerformer,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  PurchaseRequisitionReleaseDate,
  OrderedQuantity,
  PurReqnPriceQuantity,
  companycode AS ProcmtHubCompanyCode,
  PurReqnReleaseStatus,
  desiredsuppliername AS PreferredSupplierName,
  fixedsuppliername AS ProcmtHubSupplierName,
  lastextractiontimestamp AS LastChangeDateTime,
  servicepackage AS ProcmtHubServicePackage,
  StorageLocation,
  case when purreqnpricequantity = 0 then cast( requestedquantity * purchaserequisitionprice as abap.curr(15,2)) when purchasingdocumentitemcategory = 'A' then expectedoveralllimitamount else cast( division(requestedquantity * purchaserequisitionprice , purreqnpricequantity, 2) as abap.curr(15,2)) end as ItemNetAmount AS curr152endasItemNetAmount,
  ExpectedOverallLimitAmount,
  OverallLimitAmount,
  ConsumptionPosting,
  SourceOfSupplyIsAssigned,
  UserDescription,
  IsEndOfPurposeBlocked,
  HasAttachment,
  HasNote,
  PurchaseReqnItemUniqueID,
  ext_be_src_sys AS PurReqnExternalSystemId,
  PurReqnCmpltnsCat,
  case when requestedquantity > orderedquantity then requestedquantity - orderedquantity else 0.000 end as OpenQuantity AS 000endasOpenQuantity
FROM mmpur_ext_eban
;