C_PrmtHbRpldPurReqnItmApprvl

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 C_PrmtHbRpldPurReqnItmApprvl.
-- 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: CREPLPRITMWF

CREATE VIEW C_PrmtHbRpldPurReqnItmApprvl AS
SELECT
  I_PrmtHbRpldPurchaseReqnItem.ProcmtHubPurchaseRequisition AS ProcmtHubPurchaseRequisition,
  I_PrmtHbRpldPurchaseReqnItem.ProcmtHubPurRequisitionItem AS ProcmtHubPurRequisitionItem,
  I_PrmtHbRpldPurchaseReqnItem.ProcurementHubSourceSystem AS ProcurementHubSourceSystem,
  ProcmtHubPurRequisitionType,
  PurchasingDocumentUniqueID,
  _ProcmtHubExtRefForPurReqnItm.PurchaseRequisition AS PurchaseRequisition,
  _PurgDocAutomationStatus.PurgDocAutomationStatus AS PurgDocAutomationStatus,
  ProcessingStatus,
  HasAttachment,
  HasNote,
  ProcmtHubPurchasingGroup,
  PurchaseRequisitionItemText,
  ProcmtHubProduct,
  ProcmtHubPlant,
  ProcmtHubProductGroup,
  _ProcmtHubProductGroupVH.ProductGroupName AS ProductGroupName,
  ProcmtHubSupplierProductNumber,
  RequestedQuantity,
  OrderedQuantity,
  BaseUnit,
  PurReqnPriceQuantity,
  case when PurReqnPriceQuantity = 0 then cast( RequestedQuantity * PurchaseRequisitionPrice as abap.curr(15,2)) when ProcmtHubPurgDocItmCategory = 'A' then ExpectedOverallLimitAmount else cast( division(RequestedQuantity * PurchaseRequisitionPrice , PurReqnPriceQuantity, 2) as abap.curr(15,2)) end as ItemNetAmount AS curr152endasItemNetAmount,
  PurchaseOrderPriceType,
  InvoiceIsExpected,
  GoodsReceiptIsExpected,
  GoodsReceiptIsNonValuated,
  DeliveryDate,
  PurchaseRequisitionReleaseDate,
  MaterialPlannedDeliveryDurn,
  MaterialGoodsReceiptDuration,
  CreationDate,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  ProcmtHubBatch,
  MaterialRevisionLevel,
  PurchaseRequisitionPrice,
  I_PrmtHbRpldPurchaseReqnItem.IsDeleted AS IsDeleted,
  ProcmtHubAcctAssgmtCategory,
  _ProcmtHubPurgDocItmCatVH.PurgDocExternalItemCategory AS PurgDocExternalItemCategory,
  ProcmtHubPurgDocItmCategory,
  LastChangedDate,
  ProcmtHubPurchaseContract,
  ProcmtHubPurchaseContractItem,
  ProcmtHubPurchasingInfoRecord,
  ProcmtHubPurchasingOrg,
  IsClosed,
  PurchaseRequisitionIsFixed,
  ProcmtHubSupplier,
  ProcmtHubFixedSupplier,
  PurReqnItemCurrency,
  IsPurReqnBlocked,
  I_PrmtHbRpldPurchaseReqnItem.PurReqnDescription AS PurReqnDescription,
  ProductType AS ProductTypeCode,
  ProcmtHubCreatedByUser,
  UserDescription,
  PurReqnOrigin,
  RequisitionerName,
  ProcmtHubMRPController,
  ProcmtHubRequirementTracking,
  ProcmtHubCompanyCode,
  PurReqnReleaseStatus,
  ProcmtHubSupplierName,
  LastChangeDateTime,
  ConsumptionPosting,
  PurReqnItemBlockingReason,
  ServicePerformer,
  PrmtHbLimitItemCurrency,
  OverallLimitAmount,
  ExpectedOverallLimitAmount,
  PrmtHbConsumptionLimitAmount,
  PurContractForOverallLimit,
  PrmtHbItemIsLimit,
  ( case when (ProcmtHubPurgDocItmCategory = 'A' or ProcmtHubPurgDocItmCategory = '1' ) then 1 else 0 end ) AS PHRPRqIsLimitItemSupported,
  ( case when (ProcmtHubPurgDocItmCategory <> 'A'and ProcmtHubPurgDocItmCategory <> '1') then 1 else 0 end ) AS PHRPRqItemIsNotLimitItem,
  ProcmtHubServicePackage,
  cast( '' as boolean ) AS HasError,
  PurReqnCmpltnsCat,
  cast( '' as char40 ) AS ApproverName,
  ItemDeliveryAddressID,
  cast( '' as abap.sstring( 450 ) ) AS NoteTypeListText,
  SourceOfSupplyIsAssigned,
  PurReqnExternalSystemId,
  PurchaseReqnItemUniqueID AS PrmtHbRpldPurReqnItmUnqID,
  I_PrmtHbRpldPurReqnAddlDetails.ProcmtHubPurReqnDfrrdUntilDate AS ProcmtHubPurReqnDfrrdUntilDate,
  ProcmtHubPurgObjCtrlInd,
  PurReqnIsValdInCntrlReqnProcg,
  PurReqnHasDelegateApproval,
  cast('' as mmpur_d_ukms_enabled) AS PrmtHbIsUKMSEnabled,
  I_PrmtHbRpldPurchaseReqnItem.ProcmtHubPrpsdFllwOnDoc AS ProcmtHubPrpsdFllwOnDoc,
  I_PrmtHbRpldPurchaseReqnItem.ProcmtHubPrpsdFllwOnDocCat AS ProcmtHubPrpsdFllwOnDocCat,
  concat_with_space(I_PrmtHbRpldPurchaseReqnItem.ProcmtHubPurchaseRequisition, concat_with_space ('/', I_PrmtHbRpldPurchaseReqnItem.ProcmtHubPurRequisitionItem,2),2) AS FormattedPurRequisitionItem
FROM I_PrmtHbRpldPurchaseReqnItem
LEFT OUTER JOIN C_ExtPurReqnAcctAssgmt AS _ExtPurReqnAcctAssgmt ON ProcmtHubPurchaseRequisition = _ExtPurReqnAcctAssgmt.ProcmtHubPurchaseRequisition AND ProcmtHubPurRequisitionItem = _ExtPurReqnAcctAssgmt.ProcmtHubPurRequisitionItem AND ProcurementHubSourceSystem = _ExtPurReqnAcctAssgmt.ProcurementHubSourceSystem  -- association [0..*]
LEFT OUTER JOIN C_ExtPurReqnAssignedSOS AS _ExtPurReqnAssignedSOS ON ProcmtHubPurchaseRequisition = _ExtPurReqnAssignedSOS.ProcmtHubPurchaseRequisition AND ProcmtHubPurRequisitionItem = _ExtPurReqnAssignedSOS.ProcmtHubPurRequisitionItem AND ProcurementHubSourceSystem = _ExtPurReqnAssignedSOS.ProcurementHubSourceSystem  -- association [0..*]
LEFT OUTER JOIN C_ExtPurReqnDelivAddr AS _ExtPurReqnDelivAddr ON ProcmtHubPurchaseRequisition = _ExtPurReqnDelivAddr.ProcmtHubPurchaseRequisition AND ProcmtHubPurRequisitionItem = _ExtPurReqnDelivAddr.ProcmtHubPurRequisitionItem AND ProcurementHubSourceSystem = _ExtPurReqnDelivAddr.ProcurementHubSourceSystem AND ItemDeliveryAddressID = _ExtPurReqnDelivAddr.ItemDeliveryAddressID  -- association [0..1]
LEFT OUTER JOIN C_ProcmtHubPurReqnProcgStsVH AS _ProcmtHubPurReqnProcgStsVH ON _ProcmtHubPurReqnProcgStsVH.DomainValue = ProcessingStatus AND _ProcmtHubPurReqnProcgStsVH.ProcurementHubSourceSystem = PurReqnExternalSystemId  -- association [0..1]
LEFT OUTER JOIN C_ProcmtHubPurReqnRelStsVH AS _ProcmtHubPurReqnRelStsVH ON _ProcmtHubPurReqnRelStsVH.DomainValue = PurReqnReleaseStatus AND _ProcmtHubPurReqnRelStsVH.ProcurementHubSourceSystem = PurReqnExternalSystemId  -- association [0..1]
LEFT OUTER JOIN C_ProcmtHubAcctAssignmentCatVH AS _ProcmtHubAcctAssignmentCatVH ON _ProcmtHubAcctAssignmentCatVH.AccountAssignmentCategory = ProcmtHubAcctAssgmtCategory AND _ProcmtHubAcctAssignmentCatVH.ProcurementHubSourceSystem = PurReqnExternalSystemId  -- association [0..1]
LEFT OUTER JOIN C_ProcmtHubPlantVH AS _ProcmtHubPlantVH ON _ProcmtHubPlantVH.ProcmtHubPlant = ProcmtHubPlant AND _ProcmtHubPlantVH.ProcmtHubCompanyCode = ProcmtHubCompanyCode AND _ProcmtHubPlantVH.ProcurementHubSourceSystem = PurReqnExternalSystemId  -- association [0..1]
LEFT OUTER JOIN C_ProcmtHubCompanyCodeVH AS _ProcmtHubCompanyCodeVH ON _ProcmtHubCompanyCodeVH.ProcmtHubCompanyCode = ProcmtHubCompanyCode AND _ProcmtHubCompanyCodeVH.ProcurementHubSourceSystem = PurReqnExternalSystemId  -- association [0..1]
LEFT OUTER JOIN C_ProcmtHubPurgOrgVH AS _ProcmtHubPurgOrgVH ON _ProcmtHubPurgOrgVH.ProcmtHubPurchasingOrg = ProcmtHubPurchasingOrg AND _ProcmtHubPurgOrgVH.ProcurementHubSourceSystem = PurReqnExternalSystemId  -- association [0..1]
LEFT OUTER JOIN C_ProcmtHubPurgGroupVH AS _ProcmtHubPurgGroupVH ON _ProcmtHubPurgGroupVH.ProcmtHubPurchasingGroup = ProcmtHubPurchasingGroup AND _ProcmtHubPurgGroupVH.ProcurementHubSourceSystem = PurReqnExternalSystemId  -- association [0..1]
LEFT OUTER JOIN C_ProcmtHubProductGroupVH AS _ProcmtHubProductGroupVH ON _ProcmtHubProductGroupVH.ProcmtHubProductGroup = ProcmtHubProductGroup AND _ProcmtHubProductGroupVH.ProcurementHubSourceSystem = PurReqnExternalSystemId  -- association [0..1]
LEFT OUTER JOIN C_ProcmtHubPurgDocItmCatVH AS _ProcmtHubPurgDocItmCatVH ON _ProcmtHubPurgDocItmCatVH.ItemCategory = ProcmtHubPurgDocItmCategory AND _ProcmtHubPurgDocItmCatVH.ProcurementHubSourceSystem = PurReqnExternalSystemId AND _ProcmtHubPurgDocItmCatVH.PurgDocExternalItemCategory = PurgDocExternalItemCategory  -- association [0..1]
LEFT OUTER JOIN I_ProcmtHubMRPController AS _ProcmtHubMRPController ON _ProcmtHubMRPController.Plant = ProcmtHubPlant AND _ProcmtHubMRPController.MRPController = ProcmtHubMRPController AND _ProcmtHubMRPController.ProcurementHubSourceSystem = PurReqnExternalSystemId  -- association [0..1]
LEFT OUTER JOIN C_ProcmtHubBackendSrceSystemVH AS _ProcmtHubBackendSrceSystemVH ON _ProcmtHubBackendSrceSystemVH.ProcurementHubSourceSystem = ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN C_ProcmtHubPurReqnDocTypeVH AS _ProcmtHubPurReqnDocTypeVH ON _ProcmtHubPurReqnDocTypeVH.ExtSourceSystem = PurReqnExternalSystemId AND _ProcmtHubPurReqnDocTypeVH.PurchasingDocumentType = ProcmtHubPurRequisitionType  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON BaseUnit = _UnitOfMeasure.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN C_ProcmtHubExtRefForPurReqnItm AS _ProcmtHubExtRefForPurReqnItm ON ProcmtHubPurchaseRequisition = _ProcmtHubExtRefForPurReqnItm.ProcmtHubPurchaseRequisition AND ProcmtHubPurRequisitionItem = _ProcmtHubExtRefForPurReqnItm.ProcmtHubPurRequisitionItem AND ProcurementHubSourceSystem = _ProcmtHubExtRefForPurReqnItm.ProcurementHubSourceSystem  -- association [1..1]
LEFT OUTER JOIN C_PurReqnReplicationMessages AS _PurReqnReplicationMessages ON purchaserequisition = _PurReqnReplicationMessages.PurchaseRequisition AND ProcurementHubSourceSystem = _PurReqnReplicationMessages.PurReqnExternalSystemId  -- association [0..*]
LEFT OUTER JOIN C_PrmtHbRpldPurReqnProposedSOS AS _PrmtHbRpldPurReqnProposedSOS ON _PrmtHbRpldPurReqnProposedSOS.Material = ProcmtHubProduct AND _PrmtHbRpldPurReqnProposedSOS.Plant = ProcmtHubPlant  -- association [0..*]
LEFT OUTER JOIN E_PrmtHbRpldPurchaseReqnItem AS _PrmtHbRpldPurchaseReqnItem ON _PrmtHbRpldPurchaseReqnItem.ProcmtHubPurchaseRequisition = ProcmtHubPurchaseRequisition AND _PrmtHbRpldPurchaseReqnItem.ProcmtHubPurRequisitionItem = ProcmtHubPurRequisitionItem AND _PrmtHbRpldPurchaseReqnItem.ProcurementHubSourceSystem = ProcurementHubSourceSystem  -- association [1..1]
LEFT OUTER JOIN C_PurgDocAutomationStatus AS _PurgDocAutomationStatus ON _PurgDocAutomationStatus.PurchasingDocumentUniqueID = PurchasingDocumentUniqueID AND _PurgDocAutomationStatus.SAPObjectType = 'PrmtHbRpldPurchaseRequisition' AND _PurgDocAutomationStatus.ExtSourceSystem = I_PrmtHbRpldPurchaseReqnItem.ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN C_PurgDocAutomnStatusVH AS _PurgDocAutomnStatusVH ON purgdocautomationstatus = _PurgDocAutomnStatusVH.PurgDocAutomationStatus AND _PurgDocAutomnStatusVH.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PurgDocumentCategoryText AS _PurgDocumentCategoryText ON _PurgDocumentCategoryText.PurchasingDocumentCategory = ProcmtHubPrpsdFllwOnDocCat AND _PurgDocumentCategoryText.Language = $session.system_language  -- association [0..1]
;