C_RequirementTrackingPurReq

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_RequirementTrackingPurReq.
-- 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: CREQTRACKPR

CREATE VIEW C_RequirementTrackingPurReq AS
SELECT
  PurchaseRequisition.PurchaseRequisition AS PurchaseRequisition,
  PurchaseRequisition.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  concat(PurchaseRequisition.PurchaseRequisition, concat('/', PurchaseRequisition.PurchaseRequisitionItem)) AS FormattedPurRequisitionItem,
  PurchaseRequisition.RequirementTracking AS RequirementTracking,
  PurchaseRequisition.MaterialGroup AS MaterialGroup,
  PurchaseRequisition.PurchasingOrganization AS PurchasingOrganization,
  PurchaseRequisition.PurchasingGroup AS PurchasingGroup,
  PurchaseRequisition.AccountAssignmentCategory AS AccountAssignmentCategory,
  PurchaseRequisition.Material AS Material,
  PurchaseRequisition.Plant AS Plant,
  PurchaseRequisition.Supplier AS Supplier,
  PurchaseRequisition.RequestedQuantity AS RequestedQuantity,
  PurchaseRequisition.BaseUnit AS BaseUnit,
  PurchaseRequisition.PurchaseRequisitionPrice AS PurchaseRequisitionPrice,
  PurchaseRequisition.PurReqnItemCurrency AS PurReqnItemCurrency,
  case PurchaseRequisition.PurReqnPriceQuantity when 0 then cast(PurchaseRequisition.PurchaseRequisitionPrice * PurchaseRequisition.RequestedQuantity as abap.curr( 25, 2 )) else cast(division( cast(PurchaseRequisition.PurchaseRequisitionPrice * PurchaseRequisition.RequestedQuantity as abap.dec( 25, 2 )), cast(PurchaseRequisition.PurReqnPriceQuantity as abap.dec( 25, 2 )),2 ) as abap.curr( 25, 2 )) end as PurReqnTotalAmountInDspCrcy AS curr252endasPurReqnTotalAmountInDspCrcy,
  PurchaseRequisition.DeliveryDate AS DeliveryDate,
  PurchaseRequisition.StorageLocation AS StorageLocation,
  PurchaseRequisition.PurchaseRequisitionItemText AS PurchasingText,
  PurchaseRequisition.FixedSupplier AS FixedSupplier,
  PurchaseRequisition._Supplier.SupplierName AS SupplierName,
  PurchaseRequisition.PurchaseRequisitionType AS PurchaseRequisitionType,
  PurchaseRequisition._PurchasingDocumentType.PurchasingDocumentType AS PurchasingDocumentType,
  PurchaseRequisition._PurchasingDocumentType.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  PurchaseRequisition._PurchasingDocumentType._Text[1: Language = $session.system_language].PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  _PurgDocumentItemCategory._Text[1: Language = $session.system_language ].PurgDocExternalItemCategory AS PurgDocExternalItemCategory,
  _PurgDocumentItemCategory._Text[1: Language = $session.system_language ].PurgDocItemCategoryName AS PurgDocItemCategoryName,
  PurchaseRequisition.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  _PurchasingCategoryMatlGroup._PurchasingCategory.PurchasingCategory AS PurchasingCategory,
  _PurchasingCategoryMatlGroup._PurchasingCategory.PurgCatName AS PurgCatName,
  PurchaseRequisition.CreationDate AS CreationDate,
  PurchaseRequisition.PurReqCreationDate AS PurReqCreationDate,
  PurchaseRequisition.PurchaseRequisitionReleaseDate AS PurchaseRequisitionReleaseDate,
  PurchaseRequisition.PurReqnReleaseStatus AS PurReqnReleaseStatus,
  PurchaseRequisition.ReleaseCode AS ReleaseCode,
  _ReleaseIndicatorDesc.PurchasingReleaseIndicatorDesc AS PurchasingReleaseIndicatorDesc,
  PurchaseRequisition.ProcessingStatus AS ProcessingStatus,
  PurchaseRequisition.PurchasingInfoRecord AS PurchasingInfoRecord,
  PurchaseRequisition._PurchasingInfoRecord.PurchasingInfoRecordDesc AS PurchasingInfoRecordDesc,
  PurchaseRequisition.PurReqnRequestor AS PurReqnRequestor,
  PurchaseRequisition.RequisitionerName AS RequisitionerName,
  PurchaseRequisition.MRPController AS MRPController,
  PurchaseRequisition.Batch AS Batch,
  PurchaseRequisition.PurReqnOrigin AS PurReqnOrigin,
  _PurchaseReqnOrigin.DomainText AS DomainText,
  PurchaseRequisition.ReleaseStrategy AS ReleaseStrategy,
  PurchaseRequisition.CompanyCode AS CompanyCode,
  PurchaseRequisition.CreatedByUser AS CreatedByUser,
  _User.UserDescription AS UserDescription,
  PurchaseRequisition.ConsumptionPosting AS ConsumptionPosting
FROM I_Purchaserequisitionitem AS PurchaseRequisition
LEFT OUTER JOIN C_PurReqnProcessStatValueHelp AS _PurReqnProcessingStatus ON _PurReqnProcessingStatus.ProcessingStatus = ProcessingStatus  -- association [0..1]
LEFT OUTER JOIN C_PurReqnReleaseStatuValueHelp AS _PurchaseReqnReleaseStatus ON _PurchaseReqnReleaseStatus.PurReqnReleaseStatus = PurReqnReleaseStatus  -- association [0..1]
LEFT OUTER JOIN I_PRReleaseIndicatorDesc AS _ReleaseIndicatorDesc ON _ReleaseIndicatorDesc.PurchasingReleaseStatus = PurchaseRequisition.ReleaseCode AND _ReleaseIndicatorDesc.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_MM_MRPCtrlrsValueHelp AS _MRPControllerDesc ON _MRPControllerDesc.MRPController = PurchaseRequisition.MRPController AND _MRPControllerDesc.Plant = PurchaseRequisition.Plant  -- association [0..1]
LEFT OUTER JOIN C_PurReqnCreationInd AS _PurchaseReqnOrigin ON _PurchaseReqnOrigin.DomainValue = PurReqnOrigin  -- association [0..1]
LEFT OUTER JOIN I_ProcmtBlockedSupplier AS _ProcmtBlockedSupplier ON _ProcmtBlockedSupplier.PurchasingIsBlockedForSupplier = 'X'  -- association [1..1]
LEFT OUTER JOIN I_PurgDocumentItemCategory AS _PurgDocumentItemCategory ON PurchasingDocumentItemCategory = _PurgDocumentItemCategory.PurchasingDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_PurchasingCategoryMatlGroup AS _PurchasingCategoryMatlGroup ON MaterialGroup = _PurchasingCategoryMatlGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_AccountAssignmentCategory AS _AccountAssignmentCategory ON AccountAssignmentCategory = _AccountAssignmentCategory.AccountAssignmentCategory  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
;