I_AccrualObjectAcctAssgmt

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 I_AccrualObjectAcctAssgmt.
-- 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: IAOACCTASSI

CREATE VIEW I_AccrualObjectAcctAssgmt AS
SELECT
  comp AS AccrualEngineApplication,
  logsys AS AccrualObjectLogicalSystem,
  bukrs AS CompanyCode,
  ref_key AS AccrualObject,
  ref_subkey AS AccrualSubobject,
  date_to AS AccrAcctAssgmtValdtyEndDte,
  date_from AS AccrAcctAssgmtValdtyStrtDte,
  gsber AS BusinessArea,
  prctr AS ProfitCenter,
  Segment,
  geber AS Fund,
  fistl AS FundsCenter,
  fipos AS CommitmentItemInternalId,
  fkber AS FunctionalArea,
  grant_nbr AS GrantID,
  measure AS FundedProgram,
  budget_pd AS BudgetPeriod,
  companyCode.ControllingArea AS ControllingArea,
  companyCode.FinancialManagementArea AS FinancialManagementArea,
  kostl AS CostCenter,
  aufnr AS OrderID,
  ps_psp_pnr AS WBSElement,
  kstrg AS CostObject,
  lstar AS CostCtrActivityType,
  nplnr AS ProjectNetworkObject,
  aufpl AS ProjectNetworkInternalID,
  prznr AS BusinessProcess,
  kdauf AS SalesOrder,
  kdpos AS SalesOrderItem,
  paobjnr AS ProfitabilitySegment
FROM acesobj_assgmt AS assignment
LEFT OUTER JOIN I_CompanyCode AS companyCode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CostCenter = _CostCenter.CostCenter AND ControllingArea = _CostCenter.ControllingArea AND _CostCenter.ValidityStartDate <= AccrAcctAssgmtValdtyEndDte AND _CostCenter.ValidityEndDate >= AccrAcctAssgmtValdtyEndDte  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ProfitCenter = _ProfitCenter.ProfitCenter AND ControllingArea = _ProfitCenter.ControllingArea AND _ProfitCenter.ValidityStartDate <= AccrAcctAssgmtValdtyEndDte AND _ProfitCenter.ValidityEndDate >= AccrAcctAssgmtValdtyEndDte  -- association [0..1]
LEFT OUTER JOIN I_CostCenterActivityType AS _ActivityType ON CostCtrActivityType = _ActivityType.CostCtrActivityType AND ControllingArea = _ActivityType.ControllingArea AND _ActivityType.ValidityStartDate <= AccrAcctAssgmtValdtyEndDte AND _ActivityType.ValidityEndDate >= AccrAcctAssgmtValdtyEndDte  -- association [0..1]
LEFT OUTER JOIN I_FundsCenter AS _FundsCenter ON FinancialManagementArea = _FundsCenter.FinancialManagementArea AND FundsCenter = _FundsCenter.FundsCenter AND _FundsCenter.ValidityStartDate <= AccrAcctAssgmtValdtyEndDte AND _FundsCenter.ValidityEndDate >= AccrAcctAssgmtValdtyEndDte  -- association [0..1]
LEFT OUTER JOIN I_Fund AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND Fund = _Fund.Fund AND _Fund.ValidityStartDate <= AccrAcctAssgmtValdtyEndDte AND _Fund.ValidityEndDate >= AccrAcctAssgmtValdtyEndDte  -- association [0..1]
LEFT OUTER JOIN I_OrdMstrData AS _InternalOrder ON OrderID = _InternalOrder.OrderID  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON SalesOrder = _SalesOrderItem.SalesOrder AND SalesOrderItem = _SalesOrderItem.SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _WBSElement ON WBSElement = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectNetwork AS _Network ON ProjectNetworkObject = _Network.ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN E_AccrEngineAccrSubobjAssgmt AS _Extension ON AccrualEngineApplication = _Extension.AccrualEngineAccrualObjectType AND AccrualObjectLogicalSystem = _Extension.AccrualObjectLogicalSystem AND CompanyCode = _Extension.CompanyCode AND AccrualObject = _Extension.AccrualObject AND AccrualSubobject = _Extension.AccrualSubobject AND AccrAcctAssgmtValdtyEndDte = _Extension.AccrAcctAssgmtValdtyEndDte  -- association [1..1]
;