I_PurchaseOrderAccrual

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_PurchaseOrderAccrual.
-- 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: IPOACCR

CREATE VIEW I_PurchaseOrderAccrual AS
SELECT
  AccrualEngineApplication,
  AccrualObjectLogicalSystem,
  CompanyCode,
  AccrualObject,
  AccrualSubobject,
  AccrualItemType,
  Ledger,
  AccrualPeriodEndDate,
  ProposedAccrAmtIsExisting,
  _CompanyCode.ControllingArea AS ControllingArea,
  _CompanyCode.FiscalYearVariant AS FiscalYearVariant,
  ReviewProcessIsActive,
  ReviewedAccrualItemType,
  AccrualPeriodStartDate,
  AccrPeriodAmtCalculationMethod,
  _MLPrpslPerdAccr.AccrPrpsdRlibtyClassfctn AS AccrPrpsdRlibtyClassfctn,
  _MLPrpslPerdAccr._Text[1:Language = $session.system_language].AccrPrpsdRlibtyClassfctnName AS AccrPrpsdRlibtyClassfctnName,
  _MLPrpslPerdAccr.PrpsdAccrAmtMaxClProbability AS PrpsdAccrAmtMaxClProbability,
  _MLPrpslPerdAccr.PrpsdAccrAmtIsConfirmed AS PrpsdAccrAmtIsConfirmed,
  ProposedAccrAmtAdjmtReason,
  _AccrAmtAdjustmentReason._Text[1:Language = $session.system_language].ProposedAccrAmtAdjmtReasonName AS ProposedAccrAmtAdjmtReasonName,
  ReviewComment,
  AccrualAmountAdjustedByUser,
  AccrualAmountAdjustmentDate,
  AccrualAmountAdjustmentTime,
  AccrualAmountReviewStatus,
  AccrualPostingReviewType,
  _AccrualPostingReviewType._Text[1:Language = $session.system_language].AccrualPostingReviewTypeName AS AccrualPostingReviewTypeName,
  ReviewedByUser,
  AmountReviewDate,
  AmountReviewTime,
  AccrualAmountApprovalStatus,
  AccrualAmountIsApproved,
  AccrualPostingApprovalType,
  ApprovedByUser,
  AccrualAmountApprovalDate,
  AccrualAmountApprovalTime,
  ProposedAccrAmtInTransCrcy,
  ProposedAccrAmtInFreeDfndCrcy1,
  ProposedAccrAmtInFreeDfndCrcy2,
  ProposedAccrAmtInFreeDfndCrcy3,
  ProposedAccrAmtInFreeDfndCrcy4,
  ProposedAccrAmtInFreeDfndCrcy5,
  ProposedAccrAmtInFreeDfndCrcy6,
  ProposedAccrAmtInFreeDfndCrcy7,
  ProposedAccrAmtInFreeDfndCrcy8,
  AccrualAmtInTransCrcy,
  AccrualAmtInFreeDfndCrcy1,
  AccrualAmtInFreeDfndCrcy2,
  AccrualAmtInFreeDfndCrcy3,
  AccrualAmtInFreeDfndCrcy4,
  AccrualAmtInFreeDfndCrcy5,
  AccrualAmtInFreeDfndCrcy6,
  AccrualAmtInFreeDfndCrcy7,
  AccrualAmtInFreeDfndCrcy8,
  PlannedAccrualItemType,
  PlannedCostInTransCrcy,
  PlannedCostInFreeDfndCrcy1,
  PlannedCostInFreeDfndCrcy2,
  PlannedCostInFreeDfndCrcy3,
  PlannedCostInFreeDfndCrcy4,
  PlannedCostInFreeDfndCrcy5,
  PlannedCostInFreeDfndCrcy6,
  PlannedCostInFreeDfndCrcy7,
  PlannedCostInFreeDfndCrcy8,
  AdjustedCostInTransCrcy,
  AdjustedCostInFreeDfndCrcy1,
  AdjustedCostInFreeDfndCrcy2,
  AdjustedCostInFreeDfndCrcy3,
  AdjustedCostInFreeDfndCrcy4,
  AdjustedCostInFreeDfndCrcy5,
  AdjustedCostInFreeDfndCrcy6,
  AdjustedCostInFreeDfndCrcy7,
  AdjustedCostInFreeDfndCrcy8,
  ActualAccrualItemType,
  ActualCostInTransCrcy,
  ActualCostInFreeDfndCrcy1,
  ActualCostInFreeDfndCrcy2,
  ActualCostInFreeDfndCrcy3,
  ActualCostInFreeDfndCrcy4,
  ActualCostInFreeDfndCrcy5,
  ActualCostInFreeDfndCrcy6,
  ActualCostInFreeDfndCrcy7,
  ActualCostInFreeDfndCrcy8,
  DeferralItemType,
  DeferredCostInTransCrcy,
  DeferredCostInCoCodeCrcy,
  DeferredCostInGlobalCrcy,
  DeferredCostInFreeDfndCrcy1,
  DeferredCostInFreeDfndCrcy2,
  DeferredCostInFreeDfndCrcy3,
  DeferredCostInFreeDfndCrcy4,
  DeferredCostInFreeDfndCrcy5,
  DeferredCostInFreeDfndCrcy6,
  DeferredCostInFreeDfndCrcy7,
  DeferredCostInFreeDfndCrcy8,
  RecognizedCostInTransCrcy,
  RecognizedCostInCoCodeCrcy,
  RecognizedCostInGlobalCrcy,
  RecognizedCostInFreeDfndCrcy1,
  RecognizedCostInFreeDfndCrcy2,
  RecognizedCostInFreeDfndCrcy3,
  RecognizedCostInFreeDfndCrcy4,
  RecognizedCostInFreeDfndCrcy5,
  RecognizedCostInFreeDfndCrcy6,
  RecognizedCostInFreeDfndCrcy7,
  RecognizedCostInFreeDfndCrcy8,
  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,
  _purord.TotalAccrAmountInTransCrcy AS TotalAccrAmountInTransCrcy,
  _purord.TotalAccrAmountInFreeDfndCrcy1 AS TotalAccrAmountInFreeDfndCrcy1,
  _purord.TotalAccrAmountInFreeDfndCrcy2 AS TotalAccrAmountInFreeDfndCrcy2,
  _purord.TotalAccrAmountInFreeDfndCrcy3 AS TotalAccrAmountInFreeDfndCrcy3,
  _purord.TotalAccrAmountInFreeDfndCrcy4 AS TotalAccrAmountInFreeDfndCrcy4,
  _purord.TotalAccrAmountInFreeDfndCrcy5 AS TotalAccrAmountInFreeDfndCrcy5,
  _purord.TotalAccrAmountInFreeDfndCrcy6 AS TotalAccrAmountInFreeDfndCrcy6,
  _purord.TotalAccrAmountInFreeDfndCrcy7 AS TotalAccrAmountInFreeDfndCrcy7,
  _purord.TotalAccrAmountInFreeDfndCrcy8 AS TotalAccrAmountInFreeDfndCrcy8,
  TransactionCurrency,
  _purord._CompanyCode.Currency AS CompanyCodeCurrency,
  _purord._ControllingArea.ControllingAreaCurrency AS GlobalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AccrualItemETag,
  PlannedAccrualItemETag,
  ActualAccrualItemETag
FROM I_PeriodAccrual
LEFT OUTER JOIN I_PurOrdAccrualObject AS _purord ON AccrualEngineApplication = _purord.AccrualEngineApplication AND AccrualObjectLogicalSystem = _purord.AccrualObjectLogicalSystem AND CompanyCode = _purord.CompanyCode AND AccrualObject = _purord.AccrualObject AND AccrualSubobject = _purord.AccrualSubobject AND AccrualItemType = _purord.AccrualItemType AND Ledger = _purord.Ledger AND AccrualPeriodEndDate >= _purord.AccrSubobjectItmValdtyStrtDte AND AccrualPeriodEndDate <= _purord.AccrSubobjectItmValdtyEndDte  -- association [1..1]
LEFT OUTER JOIN I_MchnLrngPrpslPeriodAccrual AS _MLPrpslPerdAccr ON AccrualEngineApplication = _MLPrpslPerdAccr.AccrualEngineApplication AND CompanyCode = _MLPrpslPerdAccr.CompanyCode AND AccrualObject = _MLPrpslPerdAccr.AccrualObject AND AccrualSubobject = _MLPrpslPerdAccr.AccrualSubobject AND AccrualItemType = _MLPrpslPerdAccr.AccrualItemType AND Ledger = _MLPrpslPerdAccr.Ledger AND AccrualPeriodEndDate = _MLPrpslPerdAccr.AccrualPeriodEndDate  -- association [0..*]
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 [1..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 [1..1]
LEFT OUTER JOIN I_AccrualPostingReviewType AS _AccrualPostingReviewType ON AccrualPostingReviewType = _AccrualPostingReviewType.AccrualPostingReviewType  -- association [1..1]
LEFT OUTER JOIN I_AccrAmtAdjustmentReason AS _AccrAmtAdjustmentReason ON AccrualEngineApplication = _AccrAmtAdjustmentReason.AccrualEngineApplication AND ProposedAccrAmtAdjmtReason = _AccrAmtAdjustmentReason.ProposedAccrAmtAdjmtReason  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_User AS _ApprovedByUserName ON ApprovedByUser = _ApprovedByUserName.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _ReviewedByUserName ON ReviewedByUser = _ReviewedByUserName.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _AdjustedByUserName ON AccrualAmountAdjustedByUser = _AdjustedByUserName.UserID  -- association [0..1]
;