FACRA_PURORDACCRUALOBJECT

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_PURORDACCRUALOBJECT.
-- 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_POACACCR
-- Parameters: P_KeyDate : date

CREATE VIEW FACRA_PURORDACCRUALOBJECT 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,
  _itemtypel.LedgerGroup AS ldgrp,
  _periodParam.ProposedAccrAmtIsExisting AS is_proposed,
  _purord.PurchasingDocument AS ebeln,
  _purord.PurchasingDocumentItem AS ebelp,
  _purord.AccountAssignmentNumber AS zekkn,
  _purord.SalesOrder AS KDAUF,
  _purord.SalesOrderItem AS KDPOS,
  _purord.GLAccount AS sakto,
  _purord.CostCenter AS kostl,
  _purord.ProfitCenter AS prctr,
  _purord._PurgDocAccountAssignment.OrderID AS aufnr,
  _purord._PurgDocAccountAssignment._WBSElementBasicData.WBSDescription AS posid_name,
  case when _purord._PurgDocAccountAssignment.WBSElementInternalID is initial or _purord._PurgDocAccountAssignment.WBSElementInternalID is null then _purord._Network.ProjectInternalID else _purord.ProjectInternalID end as psphi AS ProjectInternalIDendaspsphi,
  case when _purord.WBSElementInternalID is initial or _purord.WBSElementInternalID is null then _purord._Network._Project.Project else _purord._WBSElementBasicData._Project.Project end as pspid AS Projectendaspspid,
  cast( _purord.WBSElementInternalID as ps_psp_pnr ) AS ps_psp_pnr,
  cast( _purord._WBSElementBasicData.WBSElement as rcpe_ps_posnr) AS POSID,
  _purord.ProjectNetwork AS nplnr,
  _purord._Network.ProjectNetworkDescription AS nplnr_txt,
  _purord._NetworkActivity.NetworkActivity AS nw_vornr,
  _purord.GoodsRecepientName AS wempf,
  _purord._PurgDocAccountAssignment.BusinessArea AS gsber,
  _purord.Material AS matnr,
  _purord.DocumentCurrency AS waers,
  _purord.NetAmount AS netwr,
  _purord.PurchasingGroup AS ekgrp,
  _purord.RequisitionerName AS afnam,
  _purord.Supplier AS lifnr,
  _purord.CreatedByUser AS ernam,
  _purord.IsCompletelyDelivered AS elikz,
  _purord.PurchasingDocumentItemText AS txz01,
  _purord.InvoiceIsExpected AS repos,
  _purord.IsFinallyInvoiced AS erekz,
  _purord.GoodsReceiptIsExpected AS wepos,
  _purord.GoodsReceiptIsNonValuated AS weunb,
  _purord.ControllingArea AS kokrs,
  _accr.AccrSubobjPauseDate AS pause_date,
  _item.TotalAccrualQuantity AS quantity,
  _item.TotalAccrualQuantityUnit AS unit,
  _item.AccrualMethod 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,
  _periodParam.DeferredQuantityInBaseUnit AS deferred_msl,
  _item.TransactionCurrency AS RWCURPRC,
  cast( 0 as ace_price_amnt_wcurr ) AS ACCRUAL_PRICE_WSL,
  _item.TotalAccrualQuantityUnit AS ttl_unit,
  _periodParam.AccrualEngineAccrQtyInBaseUnit AS accrual_msl
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 [1..1]
LEFT OUTER JOIN I_AccrEngineAccrualSubobject AS _accr ON comp = _accr.AccrualEngineAccrualObjectType AND logsys = _accr.AccrualObjectLogicalSystem AND bukrs = _accr.CompanyCode AND ref_key = _accr.AccrualObject AND ref_subkey = _accr.AccrualSubobject  -- association [1..1]
LEFT OUTER JOIN I_AccrEngineAccrSubobjItem AS _item ON comp = _item.AccrualEngineAccrualObjectType 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_PurOrdAccrsAccrSubobject AS _purord ON logsys = _purord.AccrualObjectLogicalSystem AND ref_key = _purord.AccrualObject AND ref_subkey = _purord.AccrualSubobject AND bukrs = _purord.CompanyCode  -- 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 [1..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]
;