R_AccrEnginePeriodicAmountsTP

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 R_AccrEnginePeriodicAmountsTP.
-- 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.

CREATE VIEW R_AccrEnginePeriodicAmountsTP AS
SELECT
  AccrualEngineAccrualObjectType,
  AccrualObjectLogicalSystem,
  CompanyCode,
  AccrualObject,
  AccrualSubobject,
  AccrualItemType,
  Ledger,
  AccrualEngineReferenceObject,
  AccrualPeriodEndDate,
  _AccrLedgerGroup.LedgerGroup AS LedgerGroup,
  AccrualPeriodStartDate,
  AccrPeriodAmtCalculationMethod,
  AccrualAmountProposedByUser,
  _ProposedByUser.FullName AS AccrAmtProposedByUserFullName,
  AccrualAmountProposalDate,
  AccrualAmountProposalTime,
  AccrualAmountProposalDateTime,
  PlanAccrualItemType,
  ActualAccrualItemType,
  DeferralItemType,
  ReviewProcessIsActive,
  ReviewApprovalAccrualType,
  TransactionCurrency,
  cast( _CompanyCode.Currency as fins_currh preserving type ) AS CompanyCodeCurrency,
  cast( _CompanyCode._ControllingArea.ControllingAreaCurrency as fins_currk preserving type ) AS GlobalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  TotalAccrualQuantityUnit,
  ProposedAccrAmtInTransCrcy,
  ProposedAccrAmtInCoCodeCrcy,
  ProposedAccrAmtInGlobalCrcy,
  ProposedAccrAmtInFreeDfndCrcy1,
  ProposedAccrAmtInFreeDfndCrcy2,
  ProposedAccrAmtInFreeDfndCrcy3,
  ProposedAccrAmtInFreeDfndCrcy4,
  ProposedAccrAmtInFreeDfndCrcy5,
  ProposedAccrAmtInFreeDfndCrcy6,
  ProposedAccrAmtInFreeDfndCrcy7,
  ProposedAccrAmtInFreeDfndCrcy8,
  AccrualEnginePrpsdQtyInBsUnt,
  PlannedCostInTransCrcy,
  PlndCostInCoCodeCrcy,
  PlannedCostInGlobalCrcy,
  PlannedCostInFreeDfndCrcy1,
  PlannedCostInFreeDfndCrcy2,
  PlannedCostInFreeDfndCrcy3,
  PlannedCostInFreeDfndCrcy4,
  PlannedCostInFreeDfndCrcy5,
  PlannedCostInFreeDfndCrcy6,
  PlannedCostInFreeDfndCrcy7,
  PlannedCostInFreeDfndCrcy8,
  AccrualEnginePlndQtyInBaseUnit,
  ActualCostInTransCrcy,
  ActualCostAmtInCCCrcy,
  ActualCostInGlobalCrcy,
  ActualCostInFreeDfndCrcy1,
  ActualCostInFreeDfndCrcy2,
  ActualCostInFreeDfndCrcy3,
  ActualCostInFreeDfndCrcy4,
  ActualCostInFreeDfndCrcy5,
  ActualCostInFreeDfndCrcy6,
  ActualCostInFreeDfndCrcy7,
  ActualCostInFreeDfndCrcy8,
  AccrualEngineActlQtyInBaseUnit,
  DeferredCostInTransCrcy,
  DeferredCostInCoCodeCrcy,
  DeferredCostInGlobalCrcy,
  DeferredCostInFreeDfndCrcy1,
  DeferredCostInFreeDfndCrcy2,
  DeferredCostInFreeDfndCrcy3,
  DeferredCostInFreeDfndCrcy4,
  DeferredCostInFreeDfndCrcy5,
  DeferredCostInFreeDfndCrcy6,
  DeferredCostInFreeDfndCrcy7,
  DeferredCostInFreeDfndCrcy8,
  DeferredQuantityInBaseUnit,
  AdjustedPlannedCostInTransCrcy,
  AdjdPlannedCostInCoCodeCrcy,
  AdjdPlannedCostInGlobalCrcy,
  AdjdPlannedCostInFreeDfndCrcy1,
  AdjdPlannedCostInFreeDfndCrcy2,
  AdjdPlannedCostInFreeDfndCrcy3,
  AdjdPlannedCostInFreeDfndCrcy4,
  AdjdPlannedCostInFreeDfndCrcy5,
  AdjdPlannedCostInFreeDfndCrcy6,
  AdjdPlannedCostInFreeDfndCrcy7,
  AdjdPlannedCostInFreeDfndCrcy8,
  AccrualEngineAdjdQtyInBaseUnit,
  AdjustedAccrAmtInTransCrcy,
  AdjustedAccrAmtInCoCodeCrcy,
  AdjustedAccrAmtInGlobalCrcy,
  AdjdAccrAmtInInFreeDfndCrcy1,
  AdjdAccrAmtInInFreeDfndCrcy2,
  AdjdAccrAmtInInFreeDfndCrcy3,
  AdjdAccrAmtInInFreeDfndCrcy4,
  AdjdAccrAmtInInFreeDfndCrcy5,
  AdjdAccrAmtInInFreeDfndCrcy6,
  AdjdAccrAmtInInFreeDfndCrcy7,
  AdjdAccrAmtInInFreeDfndCrcy8,
  AccrualEngineAccrQtyInBaseUnit,
  ProposedAccrAmtAdjmtReason,
  ReviewComment,
  AccrualAmountAdjustedByUser,
  _AdjustedByUser.FullName AS AccrAmtAdjustedByUserFullName,
  AccrualAmountAdjustmentDate,
  AccrualAmountAdjustmentTime,
  AccrAmountAdjustmentDateTime,
  AccrualPostingReviewType,
  AccrualAmountReviewStatus,
  AccrualAmountIsReviewed,
  ReviewedByUser,
  _ReviewedByUser.FullName AS ReviewedByUserFullName,
  AmountReviewDate,
  AmountReviewTime,
  AccrAmountReviewDateTime,
  AccrualPostingApprovalType,
  AccrualAmountApprovalStatus,
  AccrualAmountIsApproved,
  ApprovedByUser,
  _ApprovedByUser.FullName AS ApprovedByUserFullName,
  AccrualAmountApprovalDate,
  AccrualAmountApprovalTime,
  AccrAmountApprovalDateTime
FROM I_AccrEnginePeriodicAmounts
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
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_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]
;