C_WorkItemPurReqnItemDetail

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_WorkItemPurReqnItemDetail.
-- 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: CWIPRITMDET

CREATE VIEW C_WorkItemPurReqnItemDetail AS
SELECT
  _WorkItemPurReqnItemDetailTP.PurchaseRequisition AS PurchaseRequisition,
  _WorkItemPurReqnItemDetailTP.WorkflowTaskInternalID AS WorkflowTaskInternalID,
  _WorkItemPurReqnItemDetailTP.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  _WorkItemPurReqnItemDetailTP.PurReqnReleaseStatus AS PurReqnReleaseStatus,
  _WorkItemPurReqnItemDetailTP.PurchaseRequisitionItemText AS PurchaseRequisitionItemText,
  _WorkItemPurReqnItemDetailTP.Plant AS Plant,
  _WorkItemPurReqnItemDetailTP.PurReqnItemCurrency AS PurReqnItemCurrency,
  _WorkItemPurReqnItemDetailTP.PurReqnItemCurrency AS Currency,
  _WorkItemPurReqnItemDetailTP.CnsldtnMaterialText AS CnsldtnMaterialText,
  _WorkItemPurReqnItemDetailTP.SourceOfSupply AS SourceOfSupply,
  _WorkItemPurReqnItemDetailTP.CreatedByUser AS CreatedByUser,
  _WorkItemPurReqnItemDetailTP.RequestedQuantity AS RequestedQuantity,
  _WorkItemPurReqnItemDetailTP.PurchasingOrganization AS PurchasingOrganization,
  _WorkItemPurReqnItemDetailTP.PurchasingGroup AS PurchasingGroup,
  _WorkItemPurReqnItemDetailTP.PurReqnPriceQuantity AS PurReqnPriceQuantity,
  cast ( ('00') as abap.curr(15,2) ) AS ItemNetAmount,
  _WorkItemPurReqnItemDetailTP.Supplier AS Supplier,
  _WorkItemPurReqnItemDetailTP.FixedSupplier AS FixedSupplier,
  cast('' as md_supplier_name ) AS SupplierName,
  cast('' as md_supplier_name ) AS FixedSupplierName,
  _WorkItemPurReqnItemDetailTP.AccountAssignmentCategory AS AccountAssignmentCategory,
  _WorkItemPurReqnItemDetailTP.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  _WorkItemPurReqnItemDetailTP.ProcurementHubSourceSystem AS ProcurementHubSourceSystem,
  _WorkItemPurReqnItemDetailTP.Material AS Material,
  _WorkItemPurReqnItemDetailTP.MaterialGroup AS MaterialGroup,
  _WorkItemPurReqnItemDetailTP.BaseUnit AS BaseUnit,
  _WorkItemPurReqnItemDetailTP.PurchaseRequisitionType AS PurchaseRequisitionType,
  _WorkItemPurReqnItemDetailTP.ConsumptionPosting AS ConsumptionPosting,
  _WorkItemPurReqnItemDetailTP.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  _PurgDocumentItemCategoryText.PurgDocItemCategoryName AS PurgDocItemCategoryName,
  _WorkItemPurReqnItemDetailTP.ProductTypeCode AS ProductTypeCode,
  _ProductTypeValueHelp.ProductTypeName AS ProductTypeName,
  _WorkItemPurReqnItemDetailTP.ExpectedOverallLimitAmount AS ExpectedOverallLimitAmount,
  _WorkItemPurReqnItemDetailTP.OverallLimitAmount AS OverallLimitAmount,
  _WorkItemPurReqnItemDetailTP.StorageLocation AS StorageLocation,
  _StorageLocationValueHelp.StorageLocationName AS StorageLocationName,
  _WorkItemPurReqnItemDetailTP.PurReqCreationDate AS PurReqCreationDate,
  _WorkItemPurReqnItemDetailTP.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  _WorkItemPurReqnItemDetailTP.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  _WorkItemPurReqnItemDetailTP.PurchaseRequisitionReleaseDate AS PurchaseRequisitionReleaseDate,
  _WorkItemPurReqnItemDetailTP.DeliveryDate AS DeliveryDate,
  _WorkItemPurReqnItemDetailTP.ExtPlantForPurg AS ExtPlantForPurg,
  _WorkItemPurReqnItemDetailTP.ExtPurgOrgForPurg AS ExtPurgOrgForPurg,
  _WorkItemPurReqnItemDetailTP.ExtMaterialForPurg AS ExtMaterialForPurg,
  _WorkItemPurReqnItemDetailTP.ExtCompanyCodeForPurg AS ExtCompanyCodeForPurg,
  _WorkItemPurReqnItemDetailTP.PurReqnSSPCatalog AS PurReqnSSPCatalog,
  _ProcCatalogCallDetails.OpnCtlgWebServiceName AS OpnCtlgWebServiceName,
  _WorkItemPurReqnItemDetailTP.ItemUoM AS ItemUoM,
  _WorkItemPurReqnItemDetailTP.PurchaseRequisitionPrice AS PurchaseRequisitionPrice,
  WorkflowTaskRecipient,
  _WorkItemPurReqnItemDetailTP.PurchaseReqnItemUniqueID AS PurchaseReqnItemUniqueID,
  _WorkItemPurReqnItemDetailTP.RequisitionerName AS RequisitionerName,
  PurReqnSSPRequestor
FROM I_WorkItemPurReqnItemDetailTP AS _WorkItemPurReqnItemDetailTP
LEFT OUTER JOIN C_PurchaseReqnWorkItem AS _PurchaseReqnWorkItem ON _PurchaseReqnWorkItem.WorkflowTaskInternalID = WorkflowTaskInternalID AND _PurchaseReqnWorkItem.PurchaseRequisition = PurchaseRequisition  -- association [1..1]
LEFT OUTER JOIN C_PurchaseReqnProposedSoS AS _PurchaseReqnProposedSoS ON _PurchaseReqnProposedSoS.Material = Material AND _PurchaseReqnProposedSoS.Plant = Plant  -- association [1..*]
LEFT OUTER JOIN C_SSPSupplierPurgOrgVH AS _Supplier ON ( FixedSupplier = _Supplier.Supplier OR Supplier = _Supplier.Supplier ) AND PurchasingOrganization = _Supplier.PurchasingOrganization AND ProcurementHubSourceSystem = _Supplier.ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN C_PurchaseReqnInfoRecordVH AS _PurchaseReqnInfoRecordVH ON Material = _PurchaseReqnInfoRecordVH.Material AND PurchasingOrganization = _PurchaseReqnInfoRecordVH.PurchasingOrganization AND Plant = _PurchaseReqnInfoRecordVH.Plant  -- association [1..*]
LEFT OUTER JOIN C_PurchaseReqnContractVH AS _PurchaseReqnContractVH ON _PurchaseReqnContractVH.Material = Material  -- association [1..*]
LEFT OUTER JOIN C_PurReqnSchedAgrmtVH AS _PurReqnSchedAgrmtVH ON _PurReqnSchedAgrmtVH.Material = Material  -- association [1..*]
LEFT OUTER JOIN C_PurReqnItemDeliveryAddress AS _PurReqnItemDeliveryAddress ON _PurReqnItemDeliveryAddress.PurchaseRequisition = PurchaseRequisition AND _PurReqnItemDeliveryAddress.PurchaseRequisitionItem = PurchaseRequisitionItem  -- association [1..1]
LEFT OUTER JOIN C_MultiAcctgDistrIndValueAdjVH AS _MultiAcctgDistrIndValueAdjVH ON _MultiAcctgDistrIndValueAdjVH.MultipleAcctAssgmtDistribution = MultipleAcctAssgmtDistribution  -- association [0..1]
LEFT OUTER JOIN I_AccAssgnmtCategory AS _AccountAssignmentCategory ON AccountAssignmentCategory = _AccountAssignmentCategory.AccountAssignmentCategory  -- association [1..1]
LEFT OUTER JOIN C_PrmtHbRpldPurReqnProposedSOS AS _ExtPurReqnProposedSOSnew ON _ExtPurReqnProposedSOSnew.Material = ExtMaterialForPurg AND _ExtPurReqnProposedSOSnew.Plant = ExtPlantForPurg  -- association [1..*]
LEFT OUTER JOIN C_MM_MaterialGroupValueHelp AS _MaterialGroupVH ON _MaterialGroupVH.MaterialGroup = MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON _Currency.Currency = PurReqnItemCurrency  -- association [1..1]
LEFT OUTER JOIN I_CurrencyText AS _CurrencyText ON _CurrencyText.Currency = PurReqnItemCurrency AND _CurrencyText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON BaseUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitOfMeasureText ON BaseUnit = _UnitOfMeasureText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _ItemUnitOfMeasure ON ItemUoM = _ItemUnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _ItemUnitOfMeasureText ON ItemUoM = _ItemUnitOfMeasureText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_Proccatalogcalldetails AS _ProcCatalogCallDetails ON _ProcCatalogCallDetails.OpnCtlgWebServiceID = PurReqnSSPCatalog  -- association [0..1]
LEFT OUTER JOIN C_SSPPurchasingGroup AS _PurchasingGroup ON _PurchasingGroup.PurchasingGroup = PurchasingGroup AND _PurchasingGroup.Material = Material AND _PurchasingGroup.Plant = Plant AND _PurchasingGroup.MaterialGroup = MaterialGroup AND _PurchasingGroup.ProcurementHubSourceSystem = ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN C_PurchaseReqnItemCategoryVH AS _PurchaseReqnItemCategory ON _PurchaseReqnItemCategory.PurchasingDocumentItemCategory = PurchasingDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_PurgDocumentItemCategoryText AS _PurgDocumentItemCategoryText ON PurchasingDocumentItemCategory = _PurgDocumentItemCategoryText.PurchasingDocumentItemCategory AND _PurgDocumentItemCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_MM_ProductTypeValueHelp AS _ProductTypeValueHelp ON _ProductTypeValueHelp.ProductType = ProductTypeCode  -- association [0..1]
LEFT OUTER JOIN C_MM_StorLocValueHelp AS _StorageLocationValueHelp ON _StorageLocationValueHelp.StorageLocation = StorageLocation AND _StorageLocationValueHelp.Plant = Plant  -- association [0..1]
;