I_AccrEngineDefrlPerdcAmounts

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_AccrEngineDefrlPerdcAmounts.
-- 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: IACEDFRLPERDCAMT

CREATE VIEW I_AccrEngineDefrlPerdcAmounts 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_accr_amnt_wcurr_der preserving type ) AS DeferredCostInTransCrcy,
  cast(PeriodicAmountInCoCodeCrcy as ace_accr_amnt_hcurr_der preserving type ) AS DeferredCostInCoCodeCrcy,
  cast(PeriodicAmountInGlobalCrcy as ace_accr_amnt_kcurr_der preserving type ) AS DeferredCostInGlobalCrcy,
  cast(PeriodicAmountInFreeDfndCrcy1 as ace_accr_amnt_ocurr_der preserving type ) AS DeferredCostInFreeDfndCrcy1,
  cast(PeriodicAmountInFreeDfndCrcy2 as ace_accr_amnt_vcurr_der preserving type ) AS DeferredCostInFreeDfndCrcy2,
  cast(PeriodicAmountInFreeDfndCrcy3 as ace_accr_amnt_bcurr_der preserving type ) AS DeferredCostInFreeDfndCrcy3,
  cast(PeriodicAmountInFreeDfndCrcy4 as ace_accr_amnt_ccurr_der preserving type ) AS DeferredCostInFreeDfndCrcy4,
  cast(PeriodicAmountInFreeDfndCrcy5 as ace_accr_amnt_dcurr_der preserving type ) AS DeferredCostInFreeDfndCrcy5,
  cast(PeriodicAmountInFreeDfndCrcy6 as ace_accr_amnt_ecurr_der preserving type ) AS DeferredCostInFreeDfndCrcy6,
  cast(PeriodicAmountInFreeDfndCrcy7 as ace_accr_amnt_fcurr_der preserving type ) AS DeferredCostInFreeDfndCrcy7,
  cast(PeriodicAmountInFreeDfndCrcy8 as ace_accr_amnt_gcurr_der preserving type ) AS DeferredCostInFreeDfndCrcy8,
  TotalAccrualQuantityUnit,
  cast(AccrualEnginePrpsdQtyInBsUnt as ace_accr_amnt_msl_der preserving type ) AS DeferredQuantityInBaseUnit
FROM I_AccrEngineBasicPerdcAmounts
INNER JOIN I_AccrEngineDeferralItemType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AccrEngineDeferralItemType AS _DeferralItemType ON AccrualEngineAccrualObjectType = _DeferralItemType.AccrualEngineAccrualObjectType AND AccrualItemType = _DeferralItemType.DeferralItemType  -- association [0..1]
;