C_RequirementTrackingPurCtr

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_RequirementTrackingPurCtr.
-- 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: CREQTRACKCTR

CREATE VIEW C_RequirementTrackingPurCtr AS
SELECT
  PurchaseContract,
  PurchaseContractItem,
  concat(PurchaseContract, concat('/', PurchaseContractItem)) AS FormattedPurchaseContractItem,
  I_PurchaseContractItem.Material AS Material,
  I_PurchaseContractItem.MaterialGroup AS MaterialGroup,
  I_PurchaseContractItem.TargetQuantity AS TargetQuantity,
  OrderQuantityUnit,
  ContractNetPriceAmount,
  NetPriceQuantity,
  OrderPriceUnit,
  TargetAmount,
  I_PurchaseContractItem.DocumentCurrency AS DocumentCurrency,
  cast(_PurchaseContractHistory.ReleaseOrderDate as vdm_latestreleasedate) AS ReleaseOrderDate,
  I_PurchaseContractItem._PurchaseContract.Supplier AS Supplier,
  AccountAssignmentCategory,
  I_PurchaseContractItem._PurchaseContract.CompanyCode AS CompanyCode,
  I_PurchaseContractItem._PurchaseContract.PurchasingOrganization AS PurchasingOrganization,
  I_PurchaseContractItem._PurchaseContract.PurchasingGroup AS PurchasingGroup,
  I_PurchaseContractItem.Plant AS Plant,
  I_PurchaseContractItem.StorageLocation AS StorageLocation,
  TaxCode,
  cast(I_PurchaseContractItem._PurchaseContract.PurchaseContractTargetAmount as abap.curr(18, 2)) AS PurchaseContractTargetAmount,
  case when _ReleasedQuantity.QuantityReleasedTillDate > TargetQuantity then cast ('0' as abap.quan(13,3)) when _ReleasedQuantity.QuantityReleasedTillDate is null then TargetQuantity else cast (TargetQuantity - _ReleasedQuantity.QuantityReleasedTillDate as abap.quan(13,3)) end as OpenTargetQuantity AS quan133endasOpenTargetQuantity,
  cast( _ContractStatusVH.PurchaseContractValidityStatus as mm_contract_status_id ) AS PurchaseContractValidityStatus,
  _ContractStatusVH.PurContrValidityStatusName AS PurContrValidityStatusName,
  cast (_PurchaseContractReleaseCode.ReleaseCodeName as vdm_releasecode) AS ReleaseCodeName,
  I_PurchaseContractItem._PurchaseContract.CreatedByUser AS CreatedByUser,
  I_PurchaseContractItem. _PurchaseContract._CreatedByUser.UserDescription AS UserDescription,
  I_PurchaseContractItem._PurchaseContract.CreationDate AS CreationDate,
  _PurchasingDocumentItem.PurchasingInfoRecord AS PurchasingInfoRecord,
  I_PurchaseContractItem._PurchaseContract.PurchaseContractType AS PurchasingDocumentType,
  I_PurchaseContractItem._PurchaseContract.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  _PurgDocumentItemCategoryText.PurgDocExternalItemCategory AS PurgDocExternalItemCategory,
  _PurgDocumentItemCategoryText.PurgDocItemCategoryName AS PurgDocItemCategoryName,
  PurchasingDocumentItemCategory,
  PurchasingCategory,
  PurgCatName,
  PurchaseContractItemText AS PurchasingText,
  RequirementTracking
FROM I_PurchaseContractItem
LEFT OUTER JOIN I_PurchasingDocumentItem AS _PurchasingDocumentItem ON PurchaseContract = _PurchasingDocumentItem.PurchasingDocument AND PurchaseContractItem = _PurchasingDocumentItem.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN P_OpenTargetQuantity AS _ReleasedQuantity ON PurchaseContract = _ReleasedQuantity.PurchaseContract AND PurchaseContractItem = _ReleasedQuantity.PurchaseContractItem  -- association [0..1]
LEFT OUTER JOIN C_ContractStatusValueHelp AS _ContractStatusVH ON PurchaseContract = _ContractStatusVH.PurchaseContract AND PurchaseContractItem = _ContractStatusVH.PurchaseContractItem  -- association [1..1]
LEFT OUTER JOIN P_PurchaseContractReleaseCode AS _PurchaseContractReleaseCode ON PurchaseContract = _PurchaseContractReleaseCode.PurchaseContract  -- association [0..1]
LEFT OUTER JOIN I_AccountAssignmentCategory AS _AccountAssignmentCategory ON AccountAssignmentCategory = _AccountAssignmentCategory.AccountAssignmentCategory  -- association [0..1]
LEFT OUTER JOIN P_PurchaseContractHistory AS _PurchaseContractHistory ON PurchaseContract = _PurchaseContractHistory.PurchaseContract AND PurchaseContractItem = _PurchaseContractHistory.PurchaseContractItem  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON companycode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ProcmtBlockedSupplierTxt AS _ProcmtBlockedSupplierTxt ON _ProcmtBlockedSupplierTxt.PurchasingIsBlockedForSupplier = 'X' AND _ProcmtBlockedSupplierTxt.Language = $session.system_language  -- association [1..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_Supplier AS _Supplier ON supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON purchasingorganization = _PurchasingOrganization.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON purchasinggroup = _PurchasingGroup.PurchasingGroup  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentType AS _PurchasingDocumentType ON purchasingdocumentcategory = _PurchasingDocumentType.PurchasingDocumentCategory AND PurchasingDocumentType = _PurchasingDocumentType.PurchasingDocumentType  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentCategory AS _PurchasingDocumentCategory ON purchasingdocumentcategory = _PurchasingDocumentCategory.PurchasingDocumentCategory  -- association [1..1]
;