C_PurReqItemAcctMntr

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_PurReqItemAcctMntr.
-- 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: CPREQITMACCMNTR

CREATE VIEW C_PurReqItemAcctMntr AS
SELECT
  PurReqnAccountAssignment.PurchaseRequisition AS PurchaseRequisition,
  PurReqnAccountAssignment.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  PurReqnAccountAssignment.PurchaseReqnAcctAssgmtNumber AS PurchaseReqnAcctAssgmtNumber,
  PurReqnAccountAssignment.CompanyCode AS CompanyCode,
  PurReqnAccountAssignment._CompanyCode.CompanyCodeName AS CompanyCodeName,
  concat(concat(PurReqnAccountAssignment.PurchaseRequisition, '/'), PurReqnAccountAssignment.PurchaseRequisitionItem) AS FormattedPurRequisitionItem,
  PurReqnAccountAssignment.Material AS Material,
  PurReqnAccountAssignment.MaterialName AS MaterialName,
  PurReqnAccountAssignment.AccountAssignmentCategory AS AccountAssignmentCategory,
  PurReqnAccountAssignment.AcctAssignmentCategoryName AS AcctAssignmentCategoryName,
  PurReqnAccountAssignment.ValidityDate AS ValidityDate,
  PurReqnAccountAssignment.CostCenter AS CostCenter,
  _CostCenter._Text[1: Language = $session.system_language ].CostCenterName AS SenderCostCenterName,
  PurReqnAccountAssignment.PurchaseRequisitionType AS PurchaseRequisitionType,
  PurReqnAccountAssignment.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  _WBSElement.WBSElement AS WBSElement,
  _WBSElement.WBSElementExternalID AS WBSElementExternalID,
  _WBSElement.WBSDescription AS WBSDescription,
  PurReqnAccountAssignment.WBSElementInternalID AS WBSElementInternalID,
  PurReqnAccountAssignment.MaterialGroup AS MaterialGroup,
  PurReqnAccountAssignment.MaterialGroupName AS MaterialGroupName,
  PurReqnAccountAssignment.Supplier AS Supplier,
  PurReqnAccountAssignment._Supplier.SupplierName AS SupplierName,
  PurReqnAccountAssignment.PurchasingOrganization AS PurchasingOrganization,
  PurReqnAccountAssignment.PurchasingOrganizationName AS PurchasingOrganizationName,
  PurReqnAccountAssignment.PurchasingGroup AS PurchasingGroup,
  PurReqnAccountAssignment.PurchasingGroupName AS PurchasingGroupName,
  PurReqnAccountAssignment.MasterFixedAsset AS MasterFixedAsset,
  PurReqnAccountAssignment.ProjectNetwork AS ProjectNetwork,
  _ProjectNetworkVH.ProjectNetworkDescription AS ProjectNetworkDescription,
  PurReqnAccountAssignment.PurReqnRequestor AS PurReqnRequestor,
  PurReqnAccountAssignment.SalesOrderScheduleLine AS SalesOrderScheduleLine,
  PurReqnAccountAssignment.RequirementTracking AS RequirementTracking,
  PurReqnAccountAssignment.DeliveryDate AS DeliveryDate,
  PurReqnAccountAssignment.PurchaseRequisitionReleaseDate AS PurchaseRequisitionReleaseDate,
  PurReqnAccountAssignment.Quantity AS Quantity,
  PurReqnAccountAssignment.RequestedQuantity AS RequestedQuantity,
  PurReqnAccountAssignment.BaseUnit AS BaseUnit,
  PurReqnAccountAssignment.PurchaseRequisitionPrice AS PurchaseRequisitionPrice,
  PurReqnAccountAssignment.PurReqnItemCurrency AS PurReqnItemCurrency,
  PurReqnAccountAssignment.PurReqnItemCurrency AS SalesPlanCurrency,
  PurReqnAccountAssignment.Plant AS Plant,
  PurReqnAccountAssignment.PlantName AS PlantName,
  PurReqnAccountAssignment.ExtDesiredSupplierForPurg AS ExtDesiredSupplierForPurg,
  _DesiredSupplierText.SupplierName AS PreferredSupplierName,
  PurReqnAccountAssignment.ProcessingStatus AS PurchaseRequisitionStatus,
  PurReqnAccountAssignment.DomainText AS ProcessingStatusName,
  PurReqnAccountAssignment.PurReqCreationDate AS PurReqCreationDate,
  PurReqnAccountAssignment.ReleaseCode AS ReleaseCode,
  PurReqnAccountAssignment.PurchasingReleaseIndicatorDesc AS PurchasingReleaseIndicatorDesc,
  PurReqnAccountAssignment.StorageLocation AS StorageLocation,
  PurReqnAccountAssignment.StorageLocationName AS StorageLocationName,
  PurReqnAccountAssignment.PurchasingInfoRecord AS PurchasingInfoRecord,
  PurReqnAccountAssignment.PurchasingInfoRecordDesc AS PurchasingInfoRecordDesc,
  PurReqnAccountAssignment.PurReqnOrigin AS PurReqnOrigin,
  PurReqnAccountAssignment.DomainText AS DomainText,
  PurReqnAccountAssignment.MRPController AS MRPController,
  PurReqnAccountAssignment.MRPControllerName AS ProcmtHubMRPController,
  PurReqnAccountAssignment.ReleaseStrategy AS ReleaseStrategy,
  PurReqnAccountAssignment.CreationDate AS LastChangeDate,
  PurReqnAccountAssignment.ProcessOrder AS ProcessOrder,
  PurReqnAccountAssignment.OrderDescription AS OrderDescription,
  PurReqnAccountAssignment.Batch AS Batch,
  PurReqnAccountAssignment.SalesOrder AS SDDocument,
  PurReqnAccountAssignment.FixedAsset AS FixedAsset,
  PurReqnAccountAssignment.FixedAssetDescription AS FixedAssetDescription,
  PurReqnAccountAssignment.ControllingArea AS ControllingArea,
  PurReqnAccountAssignment._ControllingArea.ControllingAreaName AS ControllingAreaName,
  PurReqnAccountAssignment.BusinessArea AS BusinessArea,
  PurReqnAccountAssignment._BusinessArea._Text[1: Language = $session.system_language].BusinessAreaName AS BusinessAreaName
FROM P_PurReqItemAcctmntr AS PurReqnAccountAssignment
LEFT OUTER JOIN I_MM_WBSElementValueHelp AS _WBSElement ON _WBSElement.WBSElementInternalID = WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_MM_ProjectNetworkVH AS _ProjectNetworkVH ON _ProjectNetworkVH.ProjectNetwork = ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CostCenter = _CostCenter.CostCenter AND ControllingArea = _CostCenter.ControllingArea AND ValidityDate <= _CostCenter.ValidityEndDate AND ValidityDate >= _CostCenter.ValidityStartDate  -- association [0..1]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountText ON GLAccount = _GLAccountText.GLAccount AND PurReqnAccountAssignment.ChartOfAccounts = _GLAccountText.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_FundText AS _FundText ON Fund = _FundText.Fund AND _FundText.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN I_BudgetPeriodText AS _BudgetPeriodText ON BudgetPeriod = _BudgetPeriodText.BudgetPeriod AND _BudgetPeriodText.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN I_GrantText AS _GrantText ON GrantID = _GrantText.GrantID AND _GrantText.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ProfitCenter = _ProfitCenterText.ProfitCenter AND ControllingArea = _ProfitCenterText.ControllingArea AND ValidityDate = _ProfitCenterText.ValidityEndDate AND _ProfitCenterText.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN I_FunctionalAreaText AS _FunctionalAreaText ON _FunctionalAreaText.FunctionalArea = FunctionalArea  -- association [0..*]
LEFT OUTER JOIN C_PurReqnReleaseStatuValueHelp AS _ReleaseStatusText ON _ReleaseStatusText.PurReqnReleaseStatus = PurReqnReleaseStatus  -- association [0..1]
LEFT OUTER JOIN I_ProcmtDocIncompleteStatus AS _ProcmtDocIncompleteStatus ON _ProcmtDocIncompleteStatus.PurReqnCmpltnsCat = PurReqnCmpltnsCat  -- association [1..1]
LEFT OUTER JOIN C_FixedAssetOvwAssetClassVH AS _AssetClText ON _AssetClText.AssetClass = AssetClass  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _SupplyingPlant ON SupplyingPlant = _SupplyingPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _ProcuringPlant ON ProcuringPlant = _ProcuringPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Material AS _ManufacturerMaterial ON ManufacturerMaterial = _ManufacturerMaterial.Material  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _DesiredSupplierText ON ExtDesiredSupplierForPurg = _DesiredSupplierText.Supplier  -- association [0..1]
LEFT OUTER JOIN P_PURREQITMACCTMNTRFILT AS _PURREQITMACCTMNTRFILT ON PurchaseRequisition = _PURREQITMACCTMNTRFILT.PurchaseRequisition AND PurchaseRequisitionItem = _PURREQITMACCTMNTRFILT.PurchaseRequisitionItem  -- association [0..1]
;