I_AccrEngineAccrSubobjAssgmt

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_AccrEngineAccrSubobjAssgmt.
-- 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: IACESOASSGMT

CREATE VIEW I_AccrEngineAccrSubobjAssgmt AS
SELECT
  comp AS AccrualEngineAccrualObjectType,
  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,
  cast(fipos as bbp_bapi_fipos preserving type) AS CommitmentItemInternalId,
  fkber AS FunctionalArea,
  grant_nbr AS GrantID,
  measure AS FundedProgram,
  budget_pd AS BudgetPeriod,
  kostl AS CostCenter,
  aufnr AS OrderID,
  cast( ps_psp_pnr as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  _WBSElement.WBSElementExternalID AS WBSElementExternalID,
  kstrg AS CostObject,
  lstar AS CostCtrActivityType,
  nplnr AS ProjectNetworkObject,
  aufpl AS ProjectNetworkInternalID,
  prznr AS BusinessProcess,
  kdauf AS SalesOrder,
  kdpos AS SalesOrderItem,
  paobjnr AS ProfitabilitySegment,
  _AccrCompanyCode.ControllingArea AS ControllingArea,
  _AccrCompanyCode.FinancialManagementArea AS FinancialManagementArea,
  _AccrSubobj.AccrSubobjLastChangeDateTime AS AccrAcctAssgmtLastChgDateTime
FROM acesobj_assgmt
LEFT OUTER JOIN I_AccrEngineAccrObjectType AS _AccrObjectType ON AccrualEngineAccrualObjectType = _AccrObjectType.AccrualEngineAccrualObjectType  -- association [1..1]
LEFT OUTER JOIN I_LogicalSystem AS _AccrLogicalSystem ON AccrualObjectLogicalSystem = _AccrLogicalSystem.LogicalSystem  -- association [0..1]
LEFT OUTER JOIN I_AccrualEngineCompanyCode AS _AccrCompanyCode ON AccrualEngineAccrualObjectType = _AccrCompanyCode.AccrualEngineAccrualObjectType AND CompanyCode = _AccrCompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_AccrEngineAccrualObject AS _AccrObj ON AccrualEngineAccrualObjectType = _AccrObj.AccrualEngineAccrualObjectType AND AccrualObjectLogicalSystem = _AccrObj.AccrualObjectLogicalSystem AND CompanyCode = _AccrObj.CompanyCode AND AccrualObject = _AccrObj.AccrualObject  -- association [0..1]
LEFT OUTER JOIN I_AccrEngineAccrualSubobject AS _AccrSubobj ON AccrualEngineAccrualObjectType = _AccrSubobj.AccrualEngineAccrualObjectType AND AccrualObjectLogicalSystem = _AccrSubobj.AccrualObjectLogicalSystem AND CompanyCode = _AccrSubobj.CompanyCode AND AccrualObject = _AccrSubobj.AccrualObject AND AccrualSubobject = _AccrSubobj.AccrualSubobject  -- association [0..1]
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_CostCenterText AS _CostCenterText ON CostCenter = _CostCenterText.CostCenter AND controllingarea = _CostCenterText.ControllingArea AND _CostCenterText.ValidityStartDate <= AccrAcctAssgmtValdtyEndDte AND _CostCenterText.ValidityEndDate >= AccrAcctAssgmtValdtyEndDte  -- association [0..*]
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_ProfitCenterText AS _ProfitCenterText ON ProfitCenter = _ProfitCenterText.ProfitCenter AND controllingarea = _ProfitCenterText.ControllingArea AND _ProfitCenterText.ValidityStartDate <= AccrAcctAssgmtValdtyEndDte AND _ProfitCenterText.ValidityEndDate >= AccrAcctAssgmtValdtyEndDte  -- association [0..*]
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_ControllingArea AS _ControllingArea ON controllingarea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _Segment ON Segment = _Segment.Segment  -- 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_WBSElementBasicData AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
;