C_WorkItemPurReqnHdrItemDetail

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_WorkItemPurReqnHdrItemDetail.
-- 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: CWIPRHDRITMDET

CREATE VIEW C_WorkItemPurReqnHdrItemDetail AS
SELECT
  _WrkItmPurReqnHdrItemDetailTP.WorkflowTaskInternalID AS WorkflowTaskInternalID,
  _WrkItmPurReqnHdrItemDetailTP.PurchaseRequisition AS PurchaseRequisition,
  _WrkItmPurReqnHdrItemDetailTP.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  _WrkItmPurReqnHdrItemDetailTP.PurReqnPriceQuantity AS PurReqnPriceQuantity,
  _WrkItmPurReqnHdrItemDetailTP.PurReqnReleaseStatus AS PurReqnReleaseStatus,
  _WrkItmPurReqnHdrItemDetailTP.PurchaseRequisitionItemText AS PurchaseRequisitionItemText,
  _WrkItmPurReqnHdrItemDetailTP.Plant AS Plant,
  _WrkItmPurReqnHdrItemDetailTP.PurReqnItemCurrency AS PurReqnItemCurrency,
  _WrkItmPurReqnHdrItemDetailTP.PurReqnItemCurrency AS Currency,
  _WrkItmPurReqnHdrItemDetailTP.CnsldtnMaterialText AS CnsldtnMaterialText,
  _WrkItmPurReqnHdrItemDetailTP.SourceOfSupply AS SourceOfSupply,
  cast('' as vdm_purchasingsourcetype ) AS PurchasingSourceType,
  _WrkItmPurReqnHdrItemDetailTP.UserDescription AS UserDescription,
  _WrkItmPurReqnHdrItemDetailTP.CreatedByUser AS CreatedByUser,
  _WrkItmPurReqnHdrItemDetailTP._AccountAssignmentCategory.AcctAssignmentCategoryName AS AcctAssignmentCategoryName,
  _WrkItmPurReqnHdrItemDetailTP.RequestedQuantity AS RequestedQuantity,
  _WrkItmPurReqnHdrItemDetailTP.Supplier AS Supplier,
  _WrkItmPurReqnHdrItemDetailTP.PurchasingOrganization AS PurchasingOrganization,
  _WrkItmPurReqnHdrItemDetailTP.PurchasingGroup AS PurchasingGroup,
  _WrkItmPurReqnHdrItemDetailTP.PurchasingGroupName AS PurchasingGroupName,
  _WrkItmPurReqnHdrItemDetailTP.FixedSupplier AS FixedSupplier,
  cast('' as md_supplier_name ) AS SupplierName,
  cast('' as md_supplier_name ) AS FixedSupplierName,
  cast ( ('00') as abap.curr(15,2) ) AS ItemNetAmount,
  _WrkItmPurReqnHdrItemDetailTP.ItemNetAmount AS NetPriceAmount,
  _WrkItmPurReqnHdrItemDetailTP.AccountAssignmentCategory AS AccountAssignmentCategory,
  _WrkItmPurReqnHdrItemDetailTP.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  _MultiAcctgDistrIndValueAdjVH.MultipleAcctAssgmtDistrName AS MultipleAcctAssgmtDistrName,
  _WrkItmPurReqnHdrItemDetailTP.ProcurementHubSourceSystem AS ProcurementHubSourceSystem,
  _WrkItmPurReqnHdrItemDetailTP.Material AS Material,
  _WrkItmPurReqnHdrItemDetailTP.MaterialGroup AS MaterialGroup,
  _WrkItmPurReqnHdrItemDetailTP.BaseUnit AS BaseUnit,
  _WrkItmPurReqnHdrItemDetailTP.PurchaseRequisitionType AS PurchaseRequisitionType,
  _WrkItmPurReqnHdrItemDetailTP.ConsumptionPosting AS ConsumptionPosting,
  _WrkItmPurReqnHdrItemDetailTP.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  _WrkItmPurReqnHdrItemDetailTP.PurchaseRequisitionReleaseDate AS PurchaseRequisitionReleaseDate,
  _WrkItmPurReqnHdrItemDetailTP.DeliveryDate AS DeliveryDate,
  _WrkItmPurReqnHdrItemDetailTP.CompanyCode AS CompanyCode,
  _WrkItmPurReqnHdrItemDetailTP.ExtPlantForPurg AS ExtPlantForPurg,
  _WrkItmPurReqnHdrItemDetailTP.ExtPurgOrgForPurg AS ExtPurgOrgForPurg,
  _WrkItmPurReqnHdrItemDetailTP.ExtMaterialForPurg AS ExtMaterialForPurg,
  _WrkItmPurReqnHdrItemDetailTP.ItemUoM AS ItemUoM,
  _WrkItmPurReqnHdrItemDetailTP.PurchaseRequisitionPrice AS PurchaseRequisitionPrice,
  _WrkItmPurReqnHdrItemDetailTP.PurReqnSSPCatalog AS PurReqnSSPCatalog,
  WorkflowTaskRecipient,
  _WrkItmPurReqnHdrItemDetailTP.AccountAssignmentIsAddable AS AccountAssignmentIsAddable,
  _ProcCatalogCallDetails.OpnCtlgWebServiceName AS OpnCtlgWebServiceName,
  _WrkItmPurReqnHdrItemDetailTP.PurReqnSSPRequestor AS PurReqnSSPRequestor,
  cast('' as abap.char( 80 ) ) AS PurReqnRequestor,
  _WrkItmPurReqnHdrItemDetailTP.RequisitionerName AS RequisitionerName,
  _PurgDocumentItemCategoryText.PurgDocItemCategoryName AS PurgDocItemCategoryName,
  _WrkItmPurReqnHdrItemDetailTP.ProductTypeCode AS ProductTypeCode,
  _ProductTypeValueHelp.ProductTypeName AS ProductTypeName,
  _WrkItmPurReqnHdrItemDetailTP.ExpectedOverallLimitAmount AS ExpectedOverallLimitAmount,
  _WrkItmPurReqnHdrItemDetailTP.OverallLimitAmount AS OverallLimitAmount,
  _WrkItmPurReqnHdrItemDetailTP.StorageLocation AS StorageLocation,
  _StorageLocationValueHelp.StorageLocationName AS StorageLocationName,
  _WrkItmPurReqnHdrItemDetailTP.PurReqCreationDate AS PurReqCreationDate,
  _WrkItmPurReqnHdrItemDetailTP.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  _WrkItmPurReqnHdrItemDetailTP.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  _WrkItmPurReqnHdrItemDetailTP.PurchaseReqnItemUniqueID AS PurchaseReqnItemUniqueID,
  _WrkItmPurReqnHdrItemDetailTP.PurReqnIsCopyDraft AS PurReqnIsCopyDraft
FROM I_WrkItmPurReqnHdrItemDetailTP AS _WrkItmPurReqnHdrItemDetailTP
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 C_WrkItmPurReqnHdrItemText AS _PurchaseReqnhdrItemtxtTP ON _PurchaseReqnhdrItemtxtTP.WorkflowTaskInternalID = WorkflowTaskInternalID AND _PurchaseReqnhdrItemtxtTP.PurchaseRequisition = PurchaseRequisition AND _PurchaseReqnhdrItemtxtTP.PurchaseRequisitionItem = PurchaseRequisitionItem  -- association [0..*]
LEFT OUTER JOIN I_AccAssgnmtCategory AS _AccountAssignmentCategory ON AccountAssignmentCategory = _AccountAssignmentCategory.AccountAssignmentCategory  -- association [1..1]
LEFT OUTER JOIN C_PurReqnHdrItmAcAsWrkItm AS _PurchaseReqnHdrItemActTP ON _PurchaseReqnHdrItemActTP.WorkflowTaskInternalID = WorkflowTaskInternalID AND _PurchaseReqnHdrItemActTP.PurchaseRequisition = PurchaseRequisition AND _PurchaseReqnHdrItemActTP.PurchaseRequisitionItem = PurchaseRequisitionItem  -- association [0..*]
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]
;