I_AccrEnginePlanPerdcAmounts

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_AccrEnginePlanPerdcAmounts.
-- 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: IACEPLNDPERDCAMT

CREATE VIEW I_AccrEnginePlanPerdcAmounts AS
SELECT
  I_AccrEngineBasicPerdcAmounts.AccrualEngineAccrualObjectType AS AccrualEngineAccrualObjectType,
  AccrualObjectLogicalSystem,
  CompanyCode,
  AccrualObject,
  AccrualSubobject,
  AccrualItemType,
  Ledger,
  I_AccrEngineBasicPerdcAmounts.AccrualEngineReferenceObject AS AccrualEngineReferenceObject,
  AccrualPeriodEndDate,
  AccrualPeriodStartDate,
  AccrPeriodAmtCalculationMethod,
  AccrualAmountProposedByUser,
  AccrualAmountProposalDate,
  AccrualAmountProposalTime,
  TransactionCurrency,
  CompanyCodeCurrency,
  GlobalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  cast( PeriodicAmountInTransCrcy as ace_plnd_cost_per_amnt_wcurr preserving type ) AS PlannedCostInTransCrcy,
  cast( PeriodicAmountInCoCodeCrcy as ace_plnd_cost_per_amnt_hcurr preserving type ) AS PlndCostInCoCodeCrcy,
  cast( PeriodicAmountInGlobalCrcy as ace_plnd_cost_per_amnt_kcurr preserving type ) AS PlannedCostInGlobalCrcy,
  cast( PeriodicAmountInFreeDfndCrcy1 as ace_plnd_cost_per_amnt_ocurr preserving type ) AS PlannedCostInFreeDfndCrcy1,
  cast( PeriodicAmountInFreeDfndCrcy2 as ace_plnd_cost_per_amnt_vcurr preserving type ) AS PlannedCostInFreeDfndCrcy2,
  cast( PeriodicAmountInFreeDfndCrcy3 as ace_plnd_cost_per_amnt_bcurr preserving type ) AS PlannedCostInFreeDfndCrcy3,
  cast( PeriodicAmountInFreeDfndCrcy4 as ace_plnd_cost_per_amnt_ccurr preserving type ) AS PlannedCostInFreeDfndCrcy4,
  cast( PeriodicAmountInFreeDfndCrcy5 as ace_plnd_cost_per_amnt_dcurr preserving type ) AS PlannedCostInFreeDfndCrcy5,
  cast( PeriodicAmountInFreeDfndCrcy6 as ace_plnd_cost_per_amnt_ecurr preserving type ) AS PlannedCostInFreeDfndCrcy6,
  cast( PeriodicAmountInFreeDfndCrcy7 as ace_plnd_cost_per_amnt_fcurr preserving type ) AS PlannedCostInFreeDfndCrcy7,
  cast( PeriodicAmountInFreeDfndCrcy8 as ace_plnd_cost_per_amnt_gcurr preserving type ) AS PlannedCostInFreeDfndCrcy8,
  TotalAccrualQuantityUnit,
  cast( AccrualEnginePrpsdQtyInBsUnt as ace_accr_amnt_msl_plnd preserving type ) AS AccrualEnginePlndQtyInBaseUnit,
  AccrualEngineAdjdQtyInBaseUnit,
  cast( AdjustedPeriodicAmtInTransCrcy as ace_adjstd_cost_per_amnt_wcurr preserving type ) AS AdjustedPlannedCostInTransCrcy,
  cast( AdjdPeriodicAmtInCoCodeCrcy as ace_adjstd_cost_per_amnt_hcurr preserving type ) AS AdjdPlannedCostInCoCodeCrcy,
  cast( AdjdPeriodicAmtInGlobalCrcy as ace_adjstd_cost_per_amnt_kcurr preserving type ) AS AdjdPlannedCostInGlobalCrcy,
  cast( AdjdPerdcAmountInFreeDfndCrcy1 as ace_adjstd_cost_per_amnt_ocurr preserving type ) AS AdjdPlannedCostInFreeDfndCrcy1,
  cast( AdjdPerdcAmountInFreeDfndCrcy2 as ace_adjstd_cost_per_amnt_vcurr preserving type ) AS AdjdPlannedCostInFreeDfndCrcy2,
  cast( AdjdPerdcAmountInFreeDfndCrcy3 as ace_adjstd_cost_per_amnt_bcurr preserving type ) AS AdjdPlannedCostInFreeDfndCrcy3,
  cast( AdjdPerdcAmountInFreeDfndCrcy4 as ace_adjstd_cost_per_amnt_ccurr preserving type ) AS AdjdPlannedCostInFreeDfndCrcy4,
  cast( AdjdPerdcAmountInFreeDfndCrcy5 as ace_adjstd_cost_per_amnt_dcurr preserving type ) AS AdjdPlannedCostInFreeDfndCrcy5,
  cast( AdjdPerdcAmountInFreeDfndCrcy6 as ace_adjstd_cost_per_amnt_ecurr preserving type ) AS AdjdPlannedCostInFreeDfndCrcy6,
  cast( AdjdPerdcAmountInFreeDfndCrcy7 as ace_adjstd_cost_per_amnt_fcurr preserving type ) AS AdjdPlannedCostInFreeDfndCrcy7,
  cast( AdjdPerdcAmountInFreeDfndCrcy8 as ace_adjstd_cost_per_amnt_gcurr preserving type ) AS AdjdPlannedCostInFreeDfndCrcy8,
  ProposedAccrAmtAdjmtReason,
  ReviewComment,
  AccrualAmountAdjustedByUser,
  AccrualAmountAdjustmentDate,
  AccrualAmountAdjustmentTime,
  AccrualAmountReviewStatus,
  AccrualPostingReviewType,
  ReviewedByUser,
  AmountReviewDate,
  AmountReviewTime,
  AccrualAmountApprovalStatus,
  AccrualPostingApprovalType,
  ApprovedByUser,
  AccrualAmountApprovalDate,
  AccrualAmountApprovalTime
FROM I_AccrEngineBasicPerdcAmounts
INNER JOIN I_AccrEnginePlanAccrItemType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AccrEnginePlanAccrItemType AS _PlanAccrItemType ON AccrualEngineAccrualObjectType = _PlanAccrItemType.AccrualEngineAccrualObjectType AND AccrualItemType = _PlanAccrItemType.PlanAccrualItemType  -- association [0..1]
;