I_SESAccrEngnPerdcAmounts

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_SESAccrEngnPerdcAmounts.
-- 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: ISESACEPERDCAMT

CREATE VIEW I_SESAccrEngnPerdcAmounts AS
SELECT
  AccrualEngineAccrualObjectType,
  AccrualObjectLogicalSystem,
  CompanyCode,
  AccrualObject,
  AccrualSubobject,
  AccrualItemType,
  Ledger,
  AccrualPeriodEndDate,
  _AccrLedgerGroup.LedgerGroup AS LedgerGroup,
  AccrualPeriodStartDate,
  ReviewProcessIsActive,
  ReviewApprovalAccrualType,
  PlanAccrualItemType,
  ActualAccrualItemType,
  DeferralItemType,
  TransactionCurrency,
  cast( _CompanyCode.Currency as fins_currh preserving type ) AS CompanyCodeCurrency,
  cast( _CompanyCode._ControllingArea.ControllingAreaCurrency as fins_currk preserving type ) AS GlobalCurrency,
  TotalAccrualQuantityUnit,
  ProposedAccrAmtInTransCrcy,
  ProposedAccrAmtInCoCodeCrcy,
  ProposedAccrAmtInGlobalCrcy,
  AccrualEnginePrpsdQtyInBsUnt,
  PlannedCostInTransCrcy,
  PlndCostInCoCodeCrcy,
  PlannedCostInGlobalCrcy,
  AccrualEnginePlndQtyInBaseUnit,
  ActualCostInTransCrcy,
  ActualCostAmtInCCCrcy,
  ActualCostInGlobalCrcy,
  AccrualEngineActlQtyInBaseUnit,
  DeferredCostInTransCrcy,
  DeferredCostInCoCodeCrcy,
  DeferredCostInGlobalCrcy,
  DeferredQuantityInBaseUnit,
  AdjustedPlannedCostInTransCrcy,
  AdjdPlannedCostInCoCodeCrcy,
  AdjdPlannedCostInGlobalCrcy,
  AccrualEngineAdjdQtyInBaseUnit,
  AdjustedAccrAmtInTransCrcy,
  AdjustedAccrAmtInCoCodeCrcy,
  AdjustedAccrAmtInGlobalCrcy,
  AccrualEngineAccrQtyInBaseUnit,
  ProposedAccrAmtAdjmtReason,
  ReviewComment,
  AccrualAmountProposedByUser,
  _ProposedByUser.FullName AS AccrAmtProposedByUserFullName,
  AccrualAmountProposalTime,
  AccrualAmountProposalDate,
  AccrualAmountAdjustedByUser,
  _AdjustedByUser.FullName AS AccrAmtAdjustedByUserFullName,
  AccrualAmountAdjustmentDate,
  AccrualAmountAdjustmentTime,
  AccrualPostingReviewType,
  AccrualAmountReviewStatus,
  AccrualAmountIsReviewed,
  ReviewedByUser,
  _ReviewedByUser.FullName AS ReviewedByUserFullName,
  AmountReviewDate,
  AmountReviewTime,
  AccrualPostingApprovalType,
  AccrualAmountApprovalStatus,
  AccrualAmountIsApproved,
  ApprovedByUser,
  _ApprovedByUser.FullName AS ApprovedByUserFullName,
  AccrualAmountApprovalDate,
  AccrualAmountApprovalTime,
  AccrualAmountProposalDateTime,
  AccrAmountAdjustmentDateTime,
  AccrAmountReviewDateTime,
  AccrAmountApprovalDateTime,
  cast( 0 as ace_s4_per_attch_count ) AS NmbrOfPerdcAmountsAttachments
FROM I_AccrEnginePeriodicAmounts
LEFT OUTER JOIN I_AccrItemTypeForLedgerGroup AS _AccrLedgerGroup ON AccrualEngineAccrualObjectType = _AccrLedgerGroup.AccrualEngineApplication AND CompanyCode = _AccrLedgerGroup.CompanyCode AND AccrualItemType = _AccrLedgerGroup.AccrualItemType AND Ledger = _AccrLedgerGroup.Ledger  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..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]
;