C_PurRequisitionItemFs

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_PurRequisitionItemFs.
-- 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: CPURREQITEMFS

CREATE VIEW C_PurRequisitionItemFs AS
SELECT
  cast( 0 as mm_pur_requisition_item_amount) AS PurReqnItemTotalAmount,
  cast( '' as abap.sstring(1024) ) AS PlainLongText,
  cast( case when I_WrkItmPurReqnItemInferences.ExtPlantForPurg = '' then I_WrkItmPurReqnItemInferences.Plant else I_WrkItmPurReqnItemInferences.ExtPlantForPurg end as werks_d) as Plant AS ExtPlantForPurgendaswerks_dasPlant,
  case when _PurReqnItemAdr.CreatedByUserFullName <> '' then _PurReqnItemAdr.CreatedByUserFullName else _PurReqnItemAdr.CreatedByUser end as UserFullName AS CreatedByUserendasUserFullName,
  cast ( ('') as abap.char(40) ) AS PurReqnItmConfidenceLevelDesc,
  cast ( ('') as char11 ) AS UtilsMchnLrngRelConfidenceVal,
  cast ( ('') as abap.char(80) ) AS PurReqnApprvlRank1FeatureDesc,
  cast ( ('') as mmpur_ml_feature_name1 ) AS PurReqnApprvlRank1Feature,
  cast ( ('') as mmpur_ml_feature_value1 ) AS PurReqnApprvlRank1FeatureValue,
  cast ( ('') as abap.char(80) ) AS PurReqnApprvlRank2FeatureDesc,
  cast ( ('') as mmpur_ml_feature_name2 ) AS PurReqnApprvlRank2Feature,
  cast ( ('') as mmpur_ml_feature_value2 ) AS PurReqnApprvlRank2FeatureValue,
  cast ( ('') as abap.char(80) ) AS PurReqnApprvlRank3FeatureDesc,
  cast ( ('') as mmpur_ml_feature_name3 ) AS PurReqnApprvlRank3Feature,
  cast ( ('') as mmpur_ml_feature_value3 ) AS PurReqnApprvlRank3FeatureValue,
  cast ( ('') as abap.char(80) ) AS PurReqnApprvlRank4FeatureDesc,
  cast ( ('') as mmpur_ml_feature_name4 ) AS PurReqnApprvlRank4Feature,
  cast ( ('') as mmpur_ml_feature_value4 ) AS PurReqnApprvlRank4FeatureValue,
  cast ( ('') as abap.char(80) ) AS PurReqnApprvlRank5FeatureDesc,
  cast ( ('') as mmpur_ml_feature_name5 ) AS PurReqnApprvlRank5Feature,
  cast ( ('') as mmpur_ml_feature_value5 ) AS PurReqnApprvlRank5FeatureValue,
  cast( '' as sww_wiid ) AS WorkflowTaskInternalID,
  cast ( '' as abap.char(10) ) AS WorkflowScenarioDefinition,
  cast ( '' as xfeld ) AS PurgHasFlxblWorkflowApproval,
  ( case when I_WrkItmPurReqnItemInferences.IsOutline <> '' then 0 else 1 end ) AS HasRestrictedVisibility,
  I_WrkItmPurReqnItemInferences.PurchaseRequisition AS PurchaseRequisition,
  I_WrkItmPurReqnItemInferences.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  I_WrkItmPurReqnItemInferences.ProcmtHubPurReqnItmIsChanged AS ProcmtHubPurReqnItmIsChanged,
  I_WrkItmPurReqnItemInferences.PurchaseRequisitionItemText AS PurchaseRequisitionItemText,
  I_WrkItmPurReqnItemInferences.Material AS Material,
  I_WrkItmPurReqnItemInferences.ExtMaterialForPurg AS ExtMaterialForPurg,
  I_WrkItmPurReqnItemInferences.MaterialGroup AS MaterialGroup,
  I_WrkItmPurReqnItemInferences.PurchaseRequisitionType AS PurchaseRequisitionType,
  I_WrkItmPurReqnItemInferences.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  I_WrkItmPurReqnItemInferences.PurchaseRequisitionPrice AS PurchaseRequisitionPrice,
  I_WrkItmPurReqnItemInferences.PurReqnPriceQuantity AS PurReqnPriceQuantity,
  I_WrkItmPurReqnItemInferences.PurReqnItemCurrency AS PurReqnItemCurrency,
  I_WrkItmPurReqnItemInferences.PurReqnReleaseStatus AS PurReqnReleaseStatus,
  I_WrkItmPurReqnItemInferences.ExternalApprovalStatus AS ExternalApprovalStatus,
  I_WrkItmPurReqnItemInferences.PurchaseReqnItemUniqueID AS PurchaseReqnItemUniqueID,
  I_WrkItmPurReqnItemInferences.ProcessingStatus AS ProcessingStatus,
  I_WrkItmPurReqnItemInferences.PFMTransDataFootprintUUID AS PFMTransDataFootprintUUID,
  I_WrkItmPurReqnItemInferences.RequestedQuantity AS RequestedQuantity,
  I_WrkItmPurReqnItemInferences.BaseUnit AS BaseUnit,
  I_WrkItmPurReqnItemInferences.PurchasingGroup AS PurchasingGroup,
  I_WrkItmPurReqnItemInferences.PurchasingOrganization AS PurchasingOrganization,
  I_WrkItmPurReqnItemInferences.FixedSupplier AS FixedSupplier,
  I_WrkItmPurReqnItemInferences.ExtFixedSupplierForPurg AS ExtFixedSupplierForPurg,
  I_WrkItmPurReqnItemInferences.StorageLocation AS StorageLocation,
  I_WrkItmPurReqnItemInferences.PurchasingDocument AS PurchasingDocument,
  I_WrkItmPurReqnItemInferences.Supplier AS Supplier,
  I_WrkItmPurReqnItemInferences.ExtDesiredSupplierForPurg AS ExtDesiredSupplierForPurg,
  I_WrkItmPurReqnItemInferences.IsDeleted AS IsDeleted,
  I_WrkItmPurReqnItemInferences.CreatedByUser AS CreatedByUser,
  I_WrkItmPurReqnItemInferences.PurReqnRequestor AS PurReqnRequestor,
  I_WrkItmPurReqnItemInferences.RequisitionerName AS RequisitionerName,
  I_WrkItmPurReqnItemInferences.DeliveryDate AS DeliveryDate,
  I_WrkItmPurReqnItemInferences.IsPurReqnOvrlRel AS IsPurReqnOvrlRel,
  I_WrkItmPurReqnItemInferences.ProcurementHubSourceSystem AS ProcurementHubSourceSystem,
  I_WrkItmPurReqnItemInferences.PurReqCreationDate AS PurReqCreationDate,
  I_WrkItmPurReqnItemInferences.ExpectedOverallLimitAmount AS ExpectedOverallLimitAmount,
  I_WrkItmPurReqnItemInferences.OverallLimitAmount AS OverallLimitAmount,
  I_WrkItmPurReqnItemInferences.PurchaseRequisitionReleaseDate AS PurchaseRequisitionReleaseDate,
  I_WrkItmPurReqnItemInferences.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  I_WrkItmPurReqnItemInferences.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  I_WrkItmPurReqnItemInferences.IsOnBehalfCart AS IsOnBehalfCart,
  I_WrkItmPurReqnItemInferences.IsOutline AS IsOutline,
  I_WrkItmPurReqnItemInferences.PurgConfigurableItemNumber AS PurgConfigurableItemNumber,
  I_WrkItmPurReqnItemInferences.PurReqnHasDelegateApproval AS PurReqnHasDelegateApproval,
  I_WrkItmPurReqnItemInferences.CntrlReqnIsRpldBfrApprvl AS CntrlReqnIsRpldBfrApprvl,
  I_WrkItmPurReqnItemInferences.CntrlReqnApprvlStsInRpldReqn AS CntrlReqnApprvlStsInRpldReqn,
  I_WrkItmPurReqnItemInferences._PurchaseOrder AS _PurchaseOrder,
  _ProcessingStatusText.ProcessingStatusName AS ProcessingStatusName,
  _PurchaseReqnItemCO2eqFprnt.PFMFootprintFxdPtDcmlQuantity AS PFMFootprintQuantity,
  _PurchaseReqnItemCO2eqFprnt.PFMFootprintUnit AS PFMFootprintUnit,
  _PurgDocumentItemCategoryText.PurgDocItemCategoryName AS PurgDocItemCategoryName,
  _PurReqnItemAdr.AddressID AS AddressID,
  _PurReqnItemAdr.PurReqnRequestor AS PurReqnRequestorFullName,
  _PurReqnItemAdr.CreatedByUserFullName AS CreatedByUserFullName
FROM I_WrkItmPurReqnItemInferences
LEFT OUTER JOIN P_PurReqnItemAdr AS _PurReqnItemAdr ON PurchaseRequisition = _PurReqnItemAdr.PurchaseRequisition AND PurchaseRequisitionItem = _PurReqnItemAdr.PurchaseRequisitionItem  -- association [1..1]
LEFT OUTER JOIN C_PurReqnItemSourceOfSupply AS _PurReqnItemSourceOfSupply ON PurchaseRequisition = _PurReqnItemSourceOfSupply.PurchaseRequisition AND PurchaseRequisitionItem = _PurReqnItemSourceOfSupply.PurchaseRequisitionItem  -- association [1..1]
LEFT OUTER JOIN P_PurReqnTotalAmount AS _PurReqnTotalAmount ON PurchaseRequisition = _PurReqnTotalAmount.PurchaseRequisition AND PurchaseRequisitionItem = _PurReqnTotalAmount.PurchaseRequisitionItem  -- association [1..1]
LEFT OUTER JOIN C_PurReqnAccountAssignment AS _PurReqnAccountAssignment ON PurchaseRequisition = _PurReqnAccountAssignment.PurchaseRequisition AND PurchaseRequisitionItem = _PurReqnAccountAssignment.PurchaseRequisitionItem  -- association [0..*]
LEFT OUTER JOIN I_Processingstatustext AS _ProcessingStatusText ON ProcessingStatus = _ProcessingStatusText.ProcessingStatus AND _ProcessingStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PurReqnReleaseStatusVH AS _PurReqnReleaseStatusVH ON PurReqnReleaseStatus = _PurReqnReleaseStatusVH.PurReqnReleaseStatus AND _PurReqnReleaseStatusVH.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_PurchaseReqnItemCategoryVH AS _PurchaseReqnItemCategory ON _PurchaseReqnItemCategory.PurchasingDocumentItemCategory = PurchasingDocumentItemCategory AND _PurchaseReqnItemCategory.PurchaseRequisitionType = PurchaseRequisitionType  -- 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 I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_PurchasingDocumentTypeText AS _PurchasingDocumentTypeText ON PurchaseRequisitionType = _PurchasingDocumentTypeText.PurchasingDocumentType AND _PurchasingDocumentTypeText.PurchasingDocumentCategory = 'B'  -- association [0..*]
LEFT OUTER JOIN C_ProcmtHubPurReqnItmChgs AS _ProcmtHubPurReqnItmChgs ON PurchaseRequisition = _ProcmtHubPurReqnItmChgs.PurchaseRequisition AND PurchaseRequisitionItem = _ProcmtHubPurReqnItmChgs.PurchaseRequisitionItem  -- association [1..*]
LEFT OUTER JOIN I_PurReqnExtApprovalStsT AS _PurReqnExtApprovalStatusText ON I_WrkItmPurReqnItemInferences.ExternalApprovalStatus = _PurReqnExtApprovalStatusText.ExternalApprovalStatus AND _PurReqnExtApprovalStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PFMTransDataCO2eqFprnt AS _PurchaseReqnItemCO2eqFprnt ON _PurchaseReqnItemCO2eqFprnt.PFMTransDataFootprintUUID = PFMTransDataFootprintUUID  -- association [1..1]
LEFT OUTER JOIN C_PurReqnFactSheetItemNotes AS _PurReqnFactSheetItemNotes ON PurchaseRequisition = _PurReqnFactSheetItemNotes.PurchaseRequisition  -- association [1..1]
LEFT OUTER JOIN E_Purchaserequisitionitem AS _PurchaseReqnItemExtension ON _PurchaseReqnItemExtension.PurchaseRequisition = PurchaseRequisition AND _PurchaseReqnItemExtension.PurchaseRequisitionItem = PurchaseRequisitionItem  -- association [0..1]
;