C_POAccountAssignmentFactSheet

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_POAccountAssignmentFactSheet.
-- 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: CPOACCASSFS

CREATE VIEW C_POAccountAssignmentFactSheet AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  AccountAssignmentNumber,
  CompanyCode,
  ValidityDate,
  CostCenter,
  MasterFixedAsset,
  FixedAsset,
  ProjectNetwork,
  NetworkActivityInternalID,
  ProjectNetworkInternalID,
  _NetworkActivityByInternalKey.NetworkActivity AS NetworkActivity,
  MultipleAcctAssgmtDistrPercent,
  GLAccount,
  ChartOfAccounts,
  SalesOrder,
  SalesOrderItem,
  OrderID,
  UnloadingPointName,
  ControllingArea,
  ProfitCenter,
  WBSElementExternalID,
  cast ( WBSElementInternalID as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  CommitmentItemShortID,
  _CommitmentItemShortID.CommitmentItem AS CommitmentItem,
  FundsCenter,
  Fund,
  FunctionalArea,
  GoodsRecipientName,
  BusinessProcess,
  GrantID,
  BudgetPeriod,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  case when ProjectNetwork is not initial then _NetworkActivityByInternalKey._ProjectNetworkBasicData._Project.ProjectDescription else _WBSElement._Project.ProjectDescription end as ProjectName AS ProjectDescriptionendasProjectName,
  _WBSElement.WBSDescription AS WorkPackageName,
  _orderbasic.OrderDescription AS OrderDescription
FROM I_PurOrdAccountAssignment
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..*]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset AND CompanyCode = _FixedAsset.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ProjectNetwork AS _ProjectNetwork ON ProjectNetwork = _ProjectNetwork.ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_NetworkActivityByInternalKey AS _NetworkActivityByInternalKey ON ProjectNetworkInternalID = _NetworkActivityByInternalKey.ProjectNetworkInternalID AND NetworkActivityInternalID = _NetworkActivityByInternalKey.NetworkActivityInternalID  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterDesc ON CostCenter = _CostCenterDesc.CostCenter AND ControllingArea = _CostCenterDesc.ControllingArea AND ValidityDate <= _CostCenterDesc.ValidityEndDate AND ValidityDate >= _CostCenterDesc.ValidityStartDate AND _CostCenterDesc.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountDesc ON GLAccount = _GLAccountDesc.GLAccount AND ChartOfAccounts = _GLAccountDesc.ChartOfAccounts AND _GLAccountDesc.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _FunctionalAreaDesc ON FunctionalArea = _FunctionalAreaDesc.FunctionalArea AND _FunctionalAreaDesc.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterDesc ON ProfitCenter = _ProfitCenterDesc.ProfitCenter AND ControllingArea = _ProfitCenterDesc.ControllingArea AND ValidityDate <= _ProfitCenterDesc.ValidityEndDate AND ValidityDate >= _ProfitCenterDesc.ValidityStartDate AND _ProfitCenterDesc.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_OrderBasic AS _orderbasic ON OrderID = _orderbasic.OrderID  -- association [0..1]
;