I_AccrEngineBasicPerdcAmounts

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_AccrEngineBasicPerdcAmounts.
-- 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: IACEBSCPERDCAMT

CREATE VIEW I_AccrEngineBasicPerdcAmounts AS
SELECT
  comp AS AccrualEngineAccrualObjectType,
  logsys AS AccrualObjectLogicalSystem,
  bukrs AS CompanyCode,
  ref_key AS AccrualObject,
  ref_subkey AS AccrualSubobject,
  itemtype AS AccrualItemType,
  rldnr AS Ledger,
  refobj_key AS AccrualEngineReferenceObject,
  period_end_date AS AccrualPeriodEndDate,
  period_start_date AS AccrualPeriodStartDate,
  period_amnt_source AS AccrPeriodAmtCalculationMethod,
  cast( period_amnt_changed_by as ace_ds_paccr_proposedby_uname preserving type) AS AccrualAmountProposedByUser,
  cast( period_amnt_changed_on as ace_ds_proposed_on_date preserving type) AS AccrualAmountProposalDate,
  cast( period_amnt_changed_at as ace_ds_proposed_at_time preserving type) AS AccrualAmountProposalTime,
  rwcurper AS TransactionCurrency,
  rhcurper AS CompanyCodeCurrency,
  rkcurper AS GlobalCurrency,
  rocurper AS FreeDefinedCurrency1,
  rvcurper AS FreeDefinedCurrency2,
  rbcurper AS FreeDefinedCurrency3,
  rccurper AS FreeDefinedCurrency4,
  rdcurper AS FreeDefinedCurrency5,
  recurper AS FreeDefinedCurrency6,
  rfcurper AS FreeDefinedCurrency7,
  rgcurper AS FreeDefinedCurrency8,
  period_amnt_wsl AS PeriodicAmountInTransCrcy,
  period_amnt_hsl AS PeriodicAmountInCoCodeCrcy,
  period_amnt_ksl AS PeriodicAmountInGlobalCrcy,
  period_amnt_osl AS PeriodicAmountInFreeDfndCrcy1,
  period_amnt_vsl AS PeriodicAmountInFreeDfndCrcy2,
  period_amnt_bsl AS PeriodicAmountInFreeDfndCrcy3,
  period_amnt_csl AS PeriodicAmountInFreeDfndCrcy4,
  period_amnt_dsl AS PeriodicAmountInFreeDfndCrcy5,
  period_amnt_esl AS PeriodicAmountInFreeDfndCrcy6,
  period_amnt_fsl AS PeriodicAmountInFreeDfndCrcy7,
  period_amnt_gsl AS PeriodicAmountInFreeDfndCrcy8,
  period_unit AS TotalAccrualQuantityUnit,
  period_msl AS AccrualEnginePrpsdQtyInBsUnt,
  adjusted_per_amnt_wsl AS AdjustedPeriodicAmtInTransCrcy,
  adjusted_per_amnt_hsl AS AdjdPeriodicAmtInCoCodeCrcy,
  adjusted_per_amnt_ksl AS AdjdPeriodicAmtInGlobalCrcy,
  adjusted_per_amnt_osl AS AdjdPerdcAmountInFreeDfndCrcy1,
  adjusted_per_amnt_vsl AS AdjdPerdcAmountInFreeDfndCrcy2,
  adjusted_per_amnt_bsl AS AdjdPerdcAmountInFreeDfndCrcy3,
  adjusted_per_amnt_csl AS AdjdPerdcAmountInFreeDfndCrcy4,
  adjusted_per_amnt_dsl AS AdjdPerdcAmountInFreeDfndCrcy5,
  adjusted_per_amnt_esl AS AdjdPerdcAmountInFreeDfndCrcy6,
  adjusted_per_amnt_fsl AS AdjdPerdcAmountInFreeDfndCrcy7,
  adjusted_per_amnt_gsl AS AdjdPerdcAmountInFreeDfndCrcy8,
  adjusted_per_msl AS AccrualEngineAdjdQtyInBaseUnit,
  adjstmnt_reason AS ProposedAccrAmtAdjmtReason,
  adjstmnt_comment AS ReviewComment,
  adjusted_by AS AccrualAmountAdjustedByUser,
  adjusted_on AS AccrualAmountAdjustmentDate,
  adjusted_at AS AccrualAmountAdjustmentTime,
  review_status AS AccrualAmountReviewStatus,
  review_type AS AccrualPostingReviewType,
  reviewed_by AS ReviewedByUser,
  reviewed_on AS AmountReviewDate,
  reviewed_at AS AmountReviewTime,
  approval_status AS AccrualAmountApprovalStatus,
  approval_type AS AccrualPostingApprovalType,
  approved_by AS ApprovedByUser,
  approved_on AS AccrualAmountApprovalDate,
  approved_at AS AccrualAmountApprovalTime
FROM acesobj_item_per
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_AccrEngineAccrItemTypeBasic AS _AccrItemType ON AccrualEngineAccrualObjectType = _AccrItemType.AccrualEngineAccrualObjectType AND AccrualItemType = _AccrItemType.AccrualItemType  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _GlobalCurrency ON GlobalCurrency = _GlobalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency1 ON FreeDefinedCurrency1 = _FreeDefinedCurrency1.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency2 ON FreeDefinedCurrency2 = _FreeDefinedCurrency2.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency3 ON FreeDefinedCurrency3 = _FreeDefinedCurrency3.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency4 ON FreeDefinedCurrency4 = _FreeDefinedCurrency4.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency5 ON FreeDefinedCurrency5 = _FreeDefinedCurrency5.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency6 ON FreeDefinedCurrency6 = _FreeDefinedCurrency6.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency7 ON FreeDefinedCurrency7 = _FreeDefinedCurrency7.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency8 ON FreeDefinedCurrency8 = _FreeDefinedCurrency8.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON TotalAccrualQuantityUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_User AS _ProposedByUser ON AccrualAmountProposedByUser = _ProposedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _AdjustedByUser ON AccrualAmountAdjustedByUser = _AdjustedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _ReviewedByUser ON ReviewedByUser = _ReviewedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _ApprovedByUser ON ApprovedByUser = _ApprovedByUser.UserID  -- association [0..1]
;