I_PrmtHbRpldPurchaseReqnItem

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_PrmtHbRpldPurchaseReqnItem.
-- 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: IPRMTHBPRITEM

CREATE VIEW I_PrmtHbRpldPurchaseReqnItem 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,
  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,
  PrmtHbLimitItemCurrency,
  ExpectedOverallLimitAmount,
  OverallLimitAmount,
  PrmtHbConsumptionLimitAmount,
  PurContractForOverallLimit,
  PurContractItemForOverallLimit,
  PrmtHbItemIsLimit,
  ConsumptionPosting,
  SourceOfSupplyIsAssigned,
  UserDescription,
  IsEndOfPurposeBlocked,
  HasAttachment,
  HasNote,
  PurchaseReqnItemUniqueID,
  PurReqnCmpltnsCat,
  ProcmtHubPurgObjCtrlInd,
  ItemDeliveryAddressID,
  central_purreqn_proc AS PurReqnIsValdInCntrlReqnProcg,
  cast( concat(purchaserequisition , purchaserequisitionitem ) as purgdocnodeuniqueid ) AS PurchasingDocumentUniqueID,
  ProcmtHubPrpsdFllwOnDoc,
  ProcmtHubPrpsdFllwOnDocCat,
  PurReqnHasDelegateApproval,
  MultipleAcctAssgmtDistribution,
  matgrp_rcmd_status AS PrmtHbPurReqnMatlGrpRecmdnSts,
  PrmtHbRpldPurReqnSLAID,
  PrmtHbRpldPurReqnSLAStrtDteTme,
  PrmtHbRpldPurReqnSLAEndDteTme,
  PrmtHbRpldPurReqnSLAStatus,
  PurReqnDescription,
  globalteamid AS RespyMgmtGlobalTeamID,
  mmpur_pr_ext_sourcing_status AS PrmHbRplPurRqExtSrcgStggSts
FROM mmpur_ext_eban
;