C_ExtPurchaseRequisitionItem

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_ExtPurchaseRequisitionItem.
-- 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: CEXTPRITEM

CREATE VIEW C_ExtPurchaseRequisitionItem 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,
  concat_with_space(I_PrmtHbRpldPurchaseReqnItem.ProcmtHubPurchaseRequisition, concat_with_space ('/', I_PrmtHbRpldPurchaseReqnItem.ProcmtHubPurRequisitionItem,2),2) AS FormattedPurRequisitionItem,
  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,
  PurReqnDescription,
  ProductType,
  ProcmtHubCreatedByUser,
  UserDescription,
  PurReqnOrigin,
  RequisitionerName,
  ProcmtHubMRPController,
  ProcmtHubRequirementTracking,
  ProcmtHubCompanyCode,
  PurReqnReleaseStatus,
  ProcmtHubSupplierName,
  LastChangeDateTime,
  ConsumptionPosting,
  PurReqnItemBlockingReason,
  ServicePerformer,
  ExpectedOverallLimitAmount,
  OverallLimitAmount,
  ProcmtHubServicePackage,
  cast( '' as boolean ) AS HasError,
  PurReqnCmpltnsCat,
  cast( '' as char40 ) AS ApproverName,
  ItemDeliveryAddressID,
  cast( '' as abap.sstring( 450 ) ) AS NoteTypeListText,
  SourceOfSupplyIsAssigned,
  PurReqnExternalSystemId,
  PurchaseReqnItemUniqueID,
  I_PrmtHbRpldPurReqnAddlDetails.ProcmtHubPurReqnDfrrdUntilDate AS ProcmtHubPurReqnDfrrdUntilDate,
  ProcmtHubPurgObjCtrlInd,
  PurReqnIsValdInCntrlReqnProcg,
  IsEndOfPurposeBlocked,
  I_PrmtHbRpldPurchaseReqnItem.PurReqnHasDelegateApproval AS PurReqnHasDelegateApproval,
  cast('' as mmpur_d_ukms_enabled) AS PrmtHbIsUKMSEnabled,
  I_PrmtHbRpldPurchaseReqnItem.ProcmtHubPrpsdFllwOnDoc AS ProcmtHubPrpsdFllwOnDoc,
  I_PrmtHbRpldPurchaseReqnItem.ProcmtHubPrpsdFllwOnDocCat AS ProcmtHubPrpsdFllwOnDocCat,
  I_PrmtHbRpldPurchaseReqnItem.PrmtHbPurReqnMatlGrpRecmdnSts AS PrmtHbPurReqnMatlGrpRecmdnSts,
  _PrmHbRplPurRqItmAssgdProcsr.PurgDocAssgdProcsrID AS PurgDocAssgdProcsrID,
  _PrmHbRplPurRqItmAssgdProcsr.PurgDocAssgdProcsrFullName AS PurgDocAssgdProcsrFullName,
  cast( '' as boolean ) AS PrmtHbPurReqnHasComments,
  cast( '' as abap.char( 02 ) ) AS PrmtHbRpldPurReqnReworkStatus,
  cast( '' as mm_approval_status ) AS PrmtHbRpldPurReqnRwrkStsName
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_ProcmtHubSupplierVH AS _ProcmtHubSupplierVH ON _ProcmtHubSupplierVH.ProcmtHubFixedSupplier = ProcmtHubFixedSupplier AND _ProcmtHubSupplierVH.ProcurementHubSourceSystem = PurReqnExternalSystemId AND _ProcmtHubSupplierVH.ProcmtHubPurchasingOrg = ProcmtHubPurchasingOrg AND _ProcmtHubSupplierVH.ProcmtHubCompanyCode = ProcmtHubCompanyCode  -- 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_ProcmtHubProductVH AS _ProcmtHubProductVH ON _ProcmtHubProductVH.ProcmtHubProduct = ProcmtHubProduct AND _ProcmtHubProductVH.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 C_ProcmtHubSupplierPurgOrgVH AS _ProcmtHubSupplierPurgOrgVH ON _ProcmtHubSupplierPurgOrgVH.Supplier = ProcmtHubFixedSupplier AND _ProcmtHubSupplierPurgOrgVH.PurchasingOrganization = ProcmtHubPurchasingOrg AND _ProcmtHubSupplierPurgOrgVH.ProcurementHubSourceSystem = PurReqnExternalSystemId  -- 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_ProcmtHubBackendSrceSystemVH AS _BackendSrceSystemVH ON _BackendSrceSystemVH.ProcurementHubSourceSystem = PurReqnExternalSystemId  -- 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_PrmtHbRpldPurchaseOrderVH AS _ProcmtHubPurchaseOrder ON _ProcmtHubPurchaseOrder.ExtSourceSystem = 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 C_PrmtHbRpldPurReqnPlantVH AS _PrmtHbRpldPurReqnPlantVH ON _PrmtHbRpldPurReqnPlantVH.ProcmtHubPlant = ProcmtHubPlant AND _PrmtHbRpldPurReqnPlantVH.ProcmtHubCompanyCode = ProcmtHubCompanyCode AND _PrmtHbRpldPurReqnPlantVH.ProcurementHubSourceSystem = PurReqnExternalSystemId  -- association [0..1]
LEFT OUTER JOIN I_PurgDocumentCategoryText AS _PurgDocumentCategoryText ON _PurgDocumentCategoryText.PurchasingDocumentCategory = ProcmtHubPrpsdFllwOnDocCat AND _PurgDocumentCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_PurchasingDocCategoryVH AS _PurchasingDocCategoryVH ON _PurchasingDocCategoryVH.PurchasingDocumentCategory = ProcmtHubPrpsdFllwOnDocCat  -- association [0..1]
LEFT OUTER JOIN C_PrmHbRplPurRqItmAssgdProcsr AS _PrmHbRplPurRqItmAssgdProcsr ON _PrmHbRplPurRqItmAssgdProcsr.ProcmtHubPurchaseRequisition = ProcmtHubPurchaseRequisition AND _PrmHbRplPurRqItmAssgdProcsr.ProcmtHubPurRequisitionItem = ProcmtHubPurRequisitionItem AND _PrmHbRplPurRqItmAssgdProcsr.ProcurementHubSourceSystem = ProcurementHubSourceSystem  -- association [1..1]
;