FACRA_MANUALACCRUALOBJECT

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 FACRA_MANUALACCRUALOBJECT.
-- 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: FACRA_ACACACCR
-- Parameters: P_KeyDate : date

CREATE VIEW FACRA_MANUALACCRUALOBJECT AS
SELECT
  _period.comp AS comp,
  _period.logsys AS logsys,
  _period.bukrs AS bukrs,
  _period.ref_key AS ref_key,
  _period.ref_subkey AS ref_subkey,
  _period.itemtype AS itemtype,
  _period.rldnr AS rldnr,
  _periodParam.ProposedAccrAmtIsExisting AS is_proposed,
  _itemtypel.LedgerGroup AS ldgrp,
  _manual.ManualAccrualsAccrObjectType AS acac_objtype,
  _manual.AccrualObjectDescription AS text,
  _manual.CreatedByUser AS uname,
  _manual.AccrSubobjPauseDate AS pause_date,
  _item.AccrualCalculationMethod AS acrmethod,
  _item.AccrualItemIsObsolete AS xobsolete,
  _item.TransactionCurrency AS rwcurttl,
  _item.CompanyCodeCurrency AS rhcurttl,
  _item.GlobalCurrency AS rkcurttl,
  _item.FreeDefinedCurrency1 AS rocurttl,
  _item.FreeDefinedCurrency2 AS rvcurttl,
  _item.FreeDefinedCurrency3 AS rbcurttl,
  _item.FreeDefinedCurrency4 AS rccurttl,
  _item.FreeDefinedCurrency5 AS rdcurttl,
  _item.FreeDefinedCurrency6 AS recurttl,
  _item.FreeDefinedCurrency7 AS rfcurttl,
  _item.FreeDefinedCurrency8 AS rgcurttl,
  _periodParam.AccrualAmountAdjustedByUser AS adjusted_by,
  _periodParam.AccrualAmountAdjustmentDate AS adjusted_on,
  _periodParam.AccrualAmountAdjustmentTime AS adjusted_at,
  _periodParam.AccrualAmountIsReviewed AS xreviewed,
  _periodParam.AccrualPostingReviewType AS review_type,
  _periodParam.ReviewedByUser AS reviewed_by,
  _periodParam.AmountReviewDate AS reviewed_on,
  _periodParam.AmountReviewTime AS reviewed_at,
  _periodParam.AccrualAmountIsApproved AS xapproved,
  _periodParam.ApprovedByUser AS approved_by,
  _periodParam.AccrualAmountApprovalDate AS approved_on,
  _periodParam.AccrualAmountApprovalTime AS approved_at,
  _periodParam.AccrualAmountProposedByUser AS PERIOD_AMNT_CHANGED_BY,
  _periodParam.AccrualAmountProposalDate AS PERIOD_AMNT_CHANGED_ON,
  _periodParam.AccrualAmountProposalTime AS PERIOD_AMNT_CHANGED_AT,
  _assgmt._ProfitCenter._Text[1: Language = $session.system_language].ProfitCenterName AS prctr_name,
  _assgmt._FundsCenter._Text[1: Language = $session.system_language].FundsCenterName AS fistl_name,
  _assgmt._Fund._Text[1: Language = $session.system_language].FundName AS geber_name,
  _assgmt._FunctionalArea._Text[1: Language = $session.system_language].FunctionalAreaName AS fkber_name,
  _assgmt.FinancialManagementArea AS fikrs,
  _assgmt.ControllingArea AS kokrs,
  _assgmt._InternalOrder.OrderDescription AS aufnr_name,
  cast(case when _assgmt.WBSElement is null then '' else _assgmt.WBSElement end as ps_psp_pnr) as ps_psp_pnr AS WBSElementendasps_psp_pnrasps_psp_pnr,
  cast(case when _assgmt._WBSElement.WBSElement is null then '' else _assgmt._WBSElement.WBSElement end as rcpe_ps_posnr) as posid AS WBSElementendasrcpe_ps_posnrasposid,
  _assgmt._ActivityType._Text[1: Language = $session.system_language].CostCtrActivityTypeName AS lstar_name,
  cast(case when _assgmt.SalesOrderItem is null then '' else _assgmt.SalesOrderItem end as kdpos) as kdpos AS SalesOrderItemendaskdposaskdpos,
  cast(case when _assgmt._WBSElement.ProjectInternalID is null then '' else _assgmt._WBSElement.ProjectInternalID end as ps_psphi) as psphi AS ProjectInternalIDendasps_psphiaspsphi,
  cast(case when _assgmt._WBSElement.Project is null then '' else _assgmt._WBSElement.Project end as ps_pspid) as PSPID AS Projectendasps_pspidasPSPID
FROM P_ACCRUALOBJECTPERIOD_ALL
LEFT OUTER JOIN I_PeriodAccrual AS _periodParam ON comp = _periodParam.AccrualEngineApplication AND logsys = _periodParam.AccrualObjectLogicalSystem AND bukrs = _periodParam.CompanyCode AND ref_key = _periodParam.AccrualObject AND ref_subkey = _periodParam.AccrualSubobject AND itemtype = _periodParam.AccrualItemType AND rldnr = _periodParam.Ledger AND period_end_date = _periodParam.AccrualPeriodEndDate  -- association [0..1]
LEFT OUTER JOIN I_AccrualSubObjItem AS _item ON comp = _item.AccrualObjectType AND logsys = _item.AccrualObjectLogicalSystem AND bukrs = _item.CompanyCode AND ref_key = _item.AccrualObject AND ref_subkey = _item.AccrualSubobject AND itemtype = _item.AccrualItemType AND rldnr = _item.Ledger AND period_end_date >= _item.AccrSubobjectItmValdtyStrtDte AND period_end_date <= _item.AccrSubobjectItmValdtyEndDte  -- association [1..1]
LEFT OUTER JOIN I_ManualAccrualObject AS _manual ON bukrs = _manual.CompanyCode AND ref_key = _manual.AccrualObject AND ref_subkey = _manual.AccrualSubobject  -- association [1..1]
LEFT OUTER JOIN I_AccrSubObjItemPostedAmt AS _posted ON comp = _posted.AccrualEngineApplication AND logsys = _posted.AccrualObjectLogicalSystem AND bukrs = _posted.CompanyCode AND ref_key = _posted.AccrualObject AND ref_subkey = _posted.AccrualSubobject AND itemtype = _posted.AccrualItemType AND rldnr = _posted.Ledger AND period_end_date = _posted.AccrualPeriodEndDate  -- association [0..1]
LEFT OUTER JOIN I_AccrualObjectAcctAssgmt AS _assgmt ON comp = _assgmt.AccrualEngineApplication AND logsys = _assgmt.AccrualObjectLogicalSystem AND bukrs = _assgmt.CompanyCode AND ref_key = _assgmt.AccrualObject AND ref_subkey = _assgmt.AccrualSubobject AND period_end_date >= _assgmt.AccrAcctAssgmtValdtyStrtDte AND period_end_date <= _assgmt.AccrAcctAssgmtValdtyEndDte  -- association [0..1]
LEFT OUTER JOIN I_AccrItemTypeForLedgerGroup AS _itemtypel ON comp = _itemtypel.AccrualEngineApplication AND bukrs = _itemtypel.CompanyCode AND itemtype = _itemtypel.AccrualItemType AND rldnr = _itemtypel.Ledger  -- association [0..1]
;