I_ManualAccrual

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_ManualAccrual.
-- 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: IMNLACCR

CREATE VIEW I_ManualAccrual AS
SELECT
  _period.AccrualEngineApplication AS AccrualEngineApplication,
  _period.CompanyCode AS CompanyCode,
  _period.AccrualObject AS AccrualObject,
  _period.AccrualSubobject AS AccrualSubobject,
  _period.AccrualItemType AS AccrualItemType,
  _period.Ledger AS Ledger,
  _period.AccrualPeriodEndDate AS AccrualPeriodEndDate,
  _period.ProposedAccrAmtIsExisting AS ProposedAccrAmtIsExisting,
  _period.AccrualObjectLogicalSystem AS AccrualObjectLogicalSystem,
  _itemtypel.LedgerGroup AS LedgerGroup,
  _period.AccrualPeriodStartDate AS AccrualPeriodStartDate,
  _period.PercentageOfCompletion AS PercentageOfCompletion,
  _period.AccrPeriodAmtCalculationMethod AS AccrPeriodAmtCalculationMethod,
  TransactionCurrency,
  CompanyCodeCurrency,
  GlobalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  _period.ProposedAccrAmtInTransCrcy AS ProposedAccrAmtInTransCrcy,
  _period.ProposedAccrAmtInCoCodeCrcy AS ProposedAccrAmtInCoCodeCrcy,
  _period.ProposedAccrAmtInGlobalCrcy AS ProposedAccrAmtInGlobalCrcy,
  _period.ProposedAccrAmtInFreeDfndCrcy1 AS ProposedAccrAmtInFreeDfndCrcy1,
  _period.ProposedAccrAmtInFreeDfndCrcy2 AS ProposedAccrAmtInFreeDfndCrcy2,
  _period.ProposedAccrAmtInFreeDfndCrcy3 AS ProposedAccrAmtInFreeDfndCrcy3,
  _period.ProposedAccrAmtInFreeDfndCrcy4 AS ProposedAccrAmtInFreeDfndCrcy4,
  _period.ProposedAccrAmtInFreeDfndCrcy5 AS ProposedAccrAmtInFreeDfndCrcy5,
  _period.ProposedAccrAmtInFreeDfndCrcy6 AS ProposedAccrAmtInFreeDfndCrcy6,
  _period.ProposedAccrAmtInFreeDfndCrcy7 AS ProposedAccrAmtInFreeDfndCrcy7,
  _period.ProposedAccrAmtInFreeDfndCrcy8 AS ProposedAccrAmtInFreeDfndCrcy8,
  _period.AccrualAmtInTransCrcy AS AccrualAmtInTransCrcy,
  _period.AccrualAmtInCCCrcy AS AccrualAmtInCCCrcy,
  _period.AccrualAmtInGlobalCrcy AS AccrualAmtInGlobalCrcy,
  _period.AccrualAmtInFreeDfndCrcy1 AS AccrualAmtInFreeDfndCrcy1,
  _period.AccrualAmtInFreeDfndCrcy2 AS AccrualAmtInFreeDfndCrcy2,
  _period.AccrualAmtInFreeDfndCrcy3 AS AccrualAmtInFreeDfndCrcy3,
  _period.AccrualAmtInFreeDfndCrcy4 AS AccrualAmtInFreeDfndCrcy4,
  _period.AccrualAmtInFreeDfndCrcy5 AS AccrualAmtInFreeDfndCrcy5,
  _period.AccrualAmtInFreeDfndCrcy6 AS AccrualAmtInFreeDfndCrcy6,
  _period.AccrualAmtInFreeDfndCrcy7 AS AccrualAmtInFreeDfndCrcy7,
  _period.AccrualAmtInFreeDfndCrcy8 AS AccrualAmtInFreeDfndCrcy8,
  _period.PlannedAccrualItemType AS PlannedAccrualItemType,
  _period.PlannedCostInTransCrcy AS PlannedCostInTransCrcy,
  _period.PlndCostInCoCodeCrcy AS PlndCostInCoCodeCrcy,
  _period.PlannedCostInGlobalCrcy AS PlannedCostInGlobalCrcy,
  _period.PlannedCostInFreeDfndCrcy1 AS PlannedCostInFreeDfndCrcy1,
  _period.PlannedCostInFreeDfndCrcy2 AS PlannedCostInFreeDfndCrcy2,
  _period.PlannedCostInFreeDfndCrcy3 AS PlannedCostInFreeDfndCrcy3,
  _period.PlannedCostInFreeDfndCrcy4 AS PlannedCostInFreeDfndCrcy4,
  _period.PlannedCostInFreeDfndCrcy5 AS PlannedCostInFreeDfndCrcy5,
  _period.PlannedCostInFreeDfndCrcy6 AS PlannedCostInFreeDfndCrcy6,
  _period.PlannedCostInFreeDfndCrcy7 AS PlannedCostInFreeDfndCrcy7,
  _period.PlannedCostInFreeDfndCrcy8 AS PlannedCostInFreeDfndCrcy8,
  _period.AdjustedCostInTransCrcy AS AdjustedCostInTransCrcy,
  _period.AdjustedCostInCoCodeCrcy AS AdjustedCostInCoCodeCrcy,
  _period.AdjustedCostInGlobalCrcy AS AdjustedCostInGlobalCrcy,
  _period.AdjustedCostInFreeDfndCrcy1 AS AdjustedCostInFreeDfndCrcy1,
  _period.AdjustedCostInFreeDfndCrcy2 AS AdjustedCostInFreeDfndCrcy2,
  _period.AdjustedCostInFreeDfndCrcy3 AS AdjustedCostInFreeDfndCrcy3,
  _period.AdjustedCostInFreeDfndCrcy4 AS AdjustedCostInFreeDfndCrcy4,
  _period.AdjustedCostInFreeDfndCrcy5 AS AdjustedCostInFreeDfndCrcy5,
  _period.AdjustedCostInFreeDfndCrcy6 AS AdjustedCostInFreeDfndCrcy6,
  _period.AdjustedCostInFreeDfndCrcy7 AS AdjustedCostInFreeDfndCrcy7,
  _period.AdjustedCostInFreeDfndCrcy8 AS AdjustedCostInFreeDfndCrcy8,
  _period.ActualAccrualItemType AS ActualAccrualItemType,
  _period.ActualCostInTransCrcy AS ActualCostInTransCrcy,
  _period.ActualCostAmtInCCCrcy AS ActualCostAmtInCCCrcy,
  _period.ActualCostInGlobalCrcy AS ActualCostInGlobalCrcy,
  _period.ActualCostInFreeDfndCrcy1 AS ActualCostInFreeDfndCrcy1,
  _period.ActualCostInFreeDfndCrcy2 AS ActualCostInFreeDfndCrcy2,
  _period.ActualCostInFreeDfndCrcy3 AS ActualCostInFreeDfndCrcy3,
  _period.ActualCostInFreeDfndCrcy4 AS ActualCostInFreeDfndCrcy4,
  _period.ActualCostInFreeDfndCrcy5 AS ActualCostInFreeDfndCrcy5,
  _period.ActualCostInFreeDfndCrcy6 AS ActualCostInFreeDfndCrcy6,
  _period.ActualCostInFreeDfndCrcy7 AS ActualCostInFreeDfndCrcy7,
  _period.ActualCostInFreeDfndCrcy8 AS ActualCostInFreeDfndCrcy8,
  _period.ProposedAccrAmtAdjmtReason AS ProposedAccrAmtAdjmtReason,
  _period.ReviewComment AS ReviewComment,
  _period.AccrualAmountAdjustedByUser AS AccrualAmountAdjustedByUser,
  _period.AccrualAmountAdjustmentDate AS AccrualAmountAdjustmentDate,
  _period.AccrualAmountAdjustmentTime AS AccrualAmountAdjustmentTime,
  _period.AccrualAmountReviewStatus AS AccrualAmountReviewStatus,
  _period.AccrualAmountIsReviewed AS AccrualAmountIsReviewed,
  _period.AccrualPostingReviewType AS AccrualPostingReviewType,
  _period.ReviewedByUser AS ReviewedByUser,
  _period.AmountReviewDate AS AmountReviewDate,
  _period.AmountReviewTime AS AmountReviewTime,
  _period.AccrualAmountApprovalStatus AS AccrualAmountApprovalStatus,
  _period.AccrualAmountIsApproved AS AccrualAmountIsApproved,
  _period.AccrualPostingApprovalType AS AccrualPostingApprovalType,
  _period.ApprovedByUser AS ApprovedByUser,
  _period.AccrualAmountApprovalDate AS AccrualAmountApprovalDate,
  _period.AccrualAmountApprovalTime AS AccrualAmountApprovalTime,
  cast(cast(AccrualAmtInTransCrcy - ProposedAccrAmtInTransCrcy as abap.curr( 23, 2 ) ) as ace_adjmt_per_accr_amnt_wcurr preserving type ) AS AdjmtAccrAmtInTransCrcy,
  cast(cast(AccrualAmtInCCCrcy - ProposedAccrAmtInCoCodeCrcy as abap.curr( 23, 2 ) ) as ace_adjmt_per_accr_amnt_hcurr preserving type ) AS AdjmtAccrAmtInCoCodeCrcy,
  cast(cast(AccrualAmtInGlobalCrcy - ProposedAccrAmtInGlobalCrcy as abap.curr( 23, 2 ) ) as ace_adjmt_per_accr_amnt_kcurr preserving type ) AS AdjmtAccrAmtInGlobalCrcy,
  cast(cast(AccrualAmtInFreeDfndCrcy1 - ProposedAccrAmtInFreeDfndCrcy1 as abap.curr( 23, 2 ) ) as ace_adjmt_per_accr_amnt_ocurr preserving type ) AS AdjmtAccrAmtInFreeDfndCrcy1,
  cast(cast(AccrualAmtInFreeDfndCrcy2 - ProposedAccrAmtInFreeDfndCrcy2 as abap.curr( 23, 2 ) ) as ace_adjmt_per_accr_amnt_vcurr preserving type ) AS AdjmtAccrAmtInFreeDfndCrcy2,
  cast(cast(AccrualAmtInFreeDfndCrcy3 - ProposedAccrAmtInFreeDfndCrcy3 as abap.curr( 23, 2 ) ) as ace_adjmt_per_accr_amnt_bcurr preserving type ) AS AdjmtAccrAmtInFreeDfndCrcy3,
  cast(cast(AccrualAmtInFreeDfndCrcy4 - ProposedAccrAmtInFreeDfndCrcy4 as abap.curr( 23, 2 ) ) as ace_adjmt_per_accr_amnt_ccurr preserving type ) AS AdjmtAccrAmtInFreeDfndCrcy4,
  cast(cast(AccrualAmtInFreeDfndCrcy5 - ProposedAccrAmtInFreeDfndCrcy5 as abap.curr( 23, 2 ) ) as ace_adjmt_per_accr_amnt_dcurr preserving type ) AS AdjmtAccrAmtInFreeDfndCrcy5,
  cast(cast(AccrualAmtInFreeDfndCrcy6 - ProposedAccrAmtInFreeDfndCrcy6 as abap.curr( 23, 2 ) ) as ace_adjmt_per_accr_amnt_ecurr preserving type ) AS AdjmtAccrAmtInFreeDfndCrcy6,
  cast(cast(AccrualAmtInFreeDfndCrcy7 - ProposedAccrAmtInFreeDfndCrcy7 as abap.curr( 23, 2 ) ) as ace_adjmt_per_accr_amnt_fcurr preserving type ) AS AdjmtAccrAmtInFreeDfndCrcy7,
  cast(cast(AccrualAmtInFreeDfndCrcy8 - ProposedAccrAmtInFreeDfndCrcy8 as abap.curr( 23, 2 ) ) as ace_adjmt_per_accr_amnt_gcurr preserving type ) AS AdjmtAccrAmtInFreeDfndCrcy8
FROM I_PeriodAccrual AS _period
LEFT OUTER JOIN I_AccrualSubObjItem AS _item ON AccrualEngineApplication = _item.AccrualObjectType AND AccrualObjectLogicalSystem = _item.AccrualObjectLogicalSystem AND CompanyCode = _item.CompanyCode AND AccrualObject = _item.AccrualObject AND AccrualSubobject = _item.AccrualSubobject AND AccrualItemType = _item.AccrualItemType AND Ledger = _item.Ledger AND AccrualPeriodEndDate >= _item.AccrSubobjectItmValdtyStrtDte AND AccrualPeriodEndDate <= _item.AccrSubobjectItmValdtyEndDte  -- association [1..1]
LEFT OUTER JOIN I_ManualAccrualObject AS _manual ON CompanyCode = _manual.CompanyCode AND AccrualObject = _manual.AccrualObject AND AccrualSubobject = _manual.AccrualSubobject  -- association [1..1]
LEFT OUTER JOIN I_AccrSubObjItemPostedAmt AS _posted ON AccrualEngineApplication = _posted.AccrualEngineApplication AND AccrualObjectLogicalSystem = _posted.AccrualObjectLogicalSystem AND CompanyCode = _posted.CompanyCode AND AccrualObject = _posted.AccrualObject AND AccrualSubobject = _posted.AccrualSubobject AND AccrualItemType = _posted.AccrualItemType AND Ledger = _posted.Ledger AND AccrualPeriodEndDate = _posted.AccrualPeriodEndDate  -- association [0..1]
LEFT OUTER JOIN I_AccrualObjectAcctAssgmt AS _assgmt ON AccrualEngineApplication = _assgmt.AccrualEngineApplication AND AccrualObjectLogicalSystem = _assgmt.AccrualObjectLogicalSystem AND CompanyCode = _assgmt.CompanyCode AND AccrualObject = _assgmt.AccrualObject AND AccrualSubobject = _assgmt.AccrualSubobject AND AccrualPeriodEndDate >= _assgmt.AccrAcctAssgmtValdtyEndDte AND AccrualPeriodEndDate <= _assgmt.AccrAcctAssgmtValdtyEndDte  -- association [0..1]
LEFT OUTER JOIN I_AccrItemTypeForLedgerGroup AS _itemtypel ON AccrualEngineApplication = _itemtypel.AccrualEngineApplication AND CompanyCode = _itemtypel.CompanyCode AND AccrualItemType = _itemtypel.AccrualItemType AND Ledger = _itemtypel.Ledger  -- association [0..1]
;