I_AccrSubobjItmWthPerdcAmounts

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_AccrSubobjItmWthPerdcAmounts.
-- 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.
-- Parameters: P_FiscalYearPeriod : fins_fyearperiod

CREATE VIEW I_AccrSubobjItmWthPerdcAmounts AS
SELECT
  case P_AccrSubobjItemPrecalc.AccrualEngineAccrualObjectType when 'POAC' then _PurgDocAccountAssignment.BusinessArea else _AccrEngineAccrSubobjAssgmt.BusinessArea end as BusinessArea AS BusinessAreaendasBusinessArea,
  case P_AccrSubobjItemPrecalc.AccrualEngineAccrualObjectType when 'POAC' then _PurgDocAccountAssignment.ProfitCenter else _AccrEngineAccrSubobjAssgmt.ProfitCenter end as ProfitCenter AS ProfitCenterendasProfitCenter,
  case P_AccrSubobjItemPrecalc.AccrualEngineAccrualObjectType when 'POAC' then _PurgDocAccountAssignment.Fund else _AccrEngineAccrSubobjAssgmt.Fund end as Fund AS FundendasFund,
  case P_AccrSubobjItemPrecalc.AccrualEngineAccrualObjectType when 'POAC' then _PurgDocAccountAssignment.FundsCenter else _AccrEngineAccrSubobjAssgmt.FundsCenter end as FundsCenter AS FundsCenterendasFundsCenter,
  case P_AccrSubobjItemPrecalc.AccrualEngineAccrualObjectType when 'POAC' then _PurgDocAccountAssignment.FunctionalArea else _AccrEngineAccrSubobjAssgmt.FunctionalArea end as FunctionalArea AS FunctionalAreaendasFunctionalArea,
  case P_AccrSubobjItemPrecalc.AccrualEngineAccrualObjectType when 'POAC' then _PurgDocAccountAssignment.GrantID else _AccrEngineAccrSubobjAssgmt.GrantID end as GrantID AS GrantIDendasGrantID,
  case P_AccrSubobjItemPrecalc.AccrualEngineAccrualObjectType when 'POAC' then _PurgDocAccountAssignment.BudgetPeriod else _AccrEngineAccrSubobjAssgmt.BudgetPeriod end as BudgetPeriod AS BudgetPeriodendasBudgetPeriod,
  case P_AccrSubobjItemPrecalc.AccrualEngineAccrualObjectType when 'POAC' then _PurgDocAccountAssignment.CostCenter else _AccrEngineAccrSubobjAssgmt.CostCenter end as CostCenter AS CostCenterendasCostCenter,
  case P_AccrSubobjItemPrecalc.AccrualEngineAccrualObjectType when 'POAC' then _PurgDocAccountAssignment.ControllingArea else _AccrEngineAccrSubobjAssgmt.ControllingArea end as ControllingArea AS ControllingAreaendasControllingArea,
  case P_AccrSubobjItemPrecalc.AccrualEngineAccrualObjectType when 'POAC' then _PurgDocAccountAssignment.OrderID else _AccrEngineAccrSubobjAssgmt.OrderID end as OrderID AS OrderIDendasOrderID,
  case P_AccrSubobjItemPrecalc.AccrualEngineAccrualObjectType when 'POAC' then _PurgDocAccountAssignment.CostObject else _AccrEngineAccrSubobjAssgmt.CostObject end as CostObject AS CostObjectendasCostObject,
  case P_AccrSubobjItemPrecalc.AccrualEngineAccrualObjectType when 'POAC' then _PurgDocAccountAssignment.ProjectNetwork else _AccrEngineAccrSubobjAssgmt.ProjectNetworkObject end as ProjectNetwork AS ProjectNetworkObjectendasProjectNetwork,
  case P_AccrSubobjItemPrecalc.AccrualEngineAccrualObjectType when 'POAC' then _PurgDocAccountAssignment.BusinessProcess else _AccrEngineAccrSubobjAssgmt.BusinessProcess end as BusinessProcess AS BusinessProcessendasBusinessProcess,
  case P_AccrSubobjItemPrecalc.AccrualEngineAccrualObjectType when 'POAC' then _PurgDocAccountAssignment.SalesOrder else _AccrEngineAccrSubobjAssgmt.SalesOrder end as SalesOrder AS SalesOrderendasSalesOrder,
  case P_AccrSubobjItemPrecalc.AccrualEngineAccrualObjectType when 'POAC' then _PurgDocAccountAssignment.SalesOrderItem else _AccrEngineAccrSubobjAssgmt.SalesOrderItem end as SalesOrderItem AS SalesOrderItemendasSalesOrderItem,
  I_AccrEnginePeriodicAmounts.AccrualEngineReferenceObject AS AccrualEngineReferenceObject,
  I_AccrEnginePeriodicAmounts.AccrualPeriodEndDate AS AccrualPeriodEndDate,
  I_AccrEnginePeriodicAmounts.AccrualPeriodStartDate AS AccrualPeriodStartDate,
  I_AccrEnginePeriodicAmounts.AccrPeriodAmtCalculationMethod AS AccrPeriodAmtCalculationMethod,
  I_AccrEnginePeriodicAmounts.TransactionCurrency AS TransactionCurrency,
  I_AccrEnginePeriodicAmounts.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_AccrEnginePeriodicAmounts.GlobalCurrency AS GlobalCurrency,
  I_AccrEnginePeriodicAmounts.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  I_AccrEnginePeriodicAmounts.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  I_AccrEnginePeriodicAmounts.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  I_AccrEnginePeriodicAmounts.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  I_AccrEnginePeriodicAmounts.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  I_AccrEnginePeriodicAmounts.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  I_AccrEnginePeriodicAmounts.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  I_AccrEnginePeriodicAmounts.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  I_AccrEnginePeriodicAmounts.TotalAccrualQuantityUnit AS TotalAccrualQuantityUnit,
  I_AccrEnginePeriodicAmounts.PlannedCostInTransCrcy AS PlannedCostInTransCrcy,
  I_AccrEnginePeriodicAmounts.PlndCostInCoCodeCrcy AS PlndCostInCoCodeCrcy,
  I_AccrEnginePeriodicAmounts.PlannedCostInGlobalCrcy AS PlannedCostInGlobalCrcy,
  I_AccrEnginePeriodicAmounts.PlannedCostInFreeDfndCrcy1 AS PlannedCostInFreeDfndCrcy1,
  I_AccrEnginePeriodicAmounts.PlannedCostInFreeDfndCrcy2 AS PlannedCostInFreeDfndCrcy2,
  I_AccrEnginePeriodicAmounts.PlannedCostInFreeDfndCrcy3 AS PlannedCostInFreeDfndCrcy3,
  I_AccrEnginePeriodicAmounts.PlannedCostInFreeDfndCrcy4 AS PlannedCostInFreeDfndCrcy4,
  I_AccrEnginePeriodicAmounts.PlannedCostInFreeDfndCrcy5 AS PlannedCostInFreeDfndCrcy5,
  I_AccrEnginePeriodicAmounts.PlannedCostInFreeDfndCrcy6 AS PlannedCostInFreeDfndCrcy6,
  I_AccrEnginePeriodicAmounts.PlannedCostInFreeDfndCrcy7 AS PlannedCostInFreeDfndCrcy7,
  I_AccrEnginePeriodicAmounts.PlannedCostInFreeDfndCrcy8 AS PlannedCostInFreeDfndCrcy8,
  I_AccrEnginePeriodicAmounts.AccrualEnginePlndQtyInBaseUnit AS AccrualEnginePlndQtyInBaseUnit,
  I_AccrEnginePeriodicAmounts.AdjustedPlannedCostInTransCrcy AS AdjustedPlannedCostInTransCrcy,
  I_AccrEnginePeriodicAmounts.AdjdPlannedCostInCoCodeCrcy AS AdjdPlannedCostInCoCodeCrcy,
  I_AccrEnginePeriodicAmounts.AdjdPlannedCostInGlobalCrcy AS AdjdPlannedCostInGlobalCrcy,
  I_AccrEnginePeriodicAmounts.AdjdPlannedCostInFreeDfndCrcy1 AS AdjdPlannedCostInFreeDfndCrcy1,
  I_AccrEnginePeriodicAmounts.AdjdPlannedCostInFreeDfndCrcy2 AS AdjdPlannedCostInFreeDfndCrcy2,
  I_AccrEnginePeriodicAmounts.AdjdPlannedCostInFreeDfndCrcy3 AS AdjdPlannedCostInFreeDfndCrcy3,
  I_AccrEnginePeriodicAmounts.AdjdPlannedCostInFreeDfndCrcy4 AS AdjdPlannedCostInFreeDfndCrcy4,
  I_AccrEnginePeriodicAmounts.AdjdPlannedCostInFreeDfndCrcy5 AS AdjdPlannedCostInFreeDfndCrcy5,
  I_AccrEnginePeriodicAmounts.AdjdPlannedCostInFreeDfndCrcy6 AS AdjdPlannedCostInFreeDfndCrcy6,
  I_AccrEnginePeriodicAmounts.AdjdPlannedCostInFreeDfndCrcy7 AS AdjdPlannedCostInFreeDfndCrcy7,
  I_AccrEnginePeriodicAmounts.AdjdPlannedCostInFreeDfndCrcy8 AS AdjdPlannedCostInFreeDfndCrcy8,
  I_AccrEnginePeriodicAmounts.AccrualEngineAdjdQtyInBaseUnit AS AccrualEngineAdjdQtyInBaseUnit,
  I_AccrEnginePeriodicAmounts.ActualCostInTransCrcy AS ActualCostInTransCrcy,
  I_AccrEnginePeriodicAmounts.ActualCostAmtInCCCrcy AS ActualCostAmtInCCCrcy,
  I_AccrEnginePeriodicAmounts.ActualCostInGlobalCrcy AS ActualCostInGlobalCrcy,
  I_AccrEnginePeriodicAmounts.ActualCostInFreeDfndCrcy1 AS ActualCostInFreeDfndCrcy1,
  I_AccrEnginePeriodicAmounts.ActualCostInFreeDfndCrcy2 AS ActualCostInFreeDfndCrcy2,
  I_AccrEnginePeriodicAmounts.ActualCostInFreeDfndCrcy3 AS ActualCostInFreeDfndCrcy3,
  I_AccrEnginePeriodicAmounts.ActualCostInFreeDfndCrcy4 AS ActualCostInFreeDfndCrcy4,
  I_AccrEnginePeriodicAmounts.ActualCostInFreeDfndCrcy5 AS ActualCostInFreeDfndCrcy5,
  I_AccrEnginePeriodicAmounts.ActualCostInFreeDfndCrcy6 AS ActualCostInFreeDfndCrcy6,
  I_AccrEnginePeriodicAmounts.ActualCostInFreeDfndCrcy7 AS ActualCostInFreeDfndCrcy7,
  I_AccrEnginePeriodicAmounts.ActualCostInFreeDfndCrcy8 AS ActualCostInFreeDfndCrcy8,
  I_AccrEnginePeriodicAmounts.AccrualEngineActlQtyInBaseUnit AS AccrualEngineActlQtyInBaseUnit,
  I_AccrEnginePeriodicAmounts.AdjustedAccrAmtInTransCrcy AS AdjustedAccrAmtInTransCrcy,
  I_AccrEnginePeriodicAmounts.AdjustedAccrAmtInCoCodeCrcy AS AdjustedAccrAmtInCoCodeCrcy,
  I_AccrEnginePeriodicAmounts.AdjustedAccrAmtInGlobalCrcy AS AdjustedAccrAmtInGlobalCrcy,
  I_AccrEnginePeriodicAmounts.AdjdAccrAmtInInFreeDfndCrcy1 AS AdjdAccrAmtInInFreeDfndCrcy1,
  I_AccrEnginePeriodicAmounts.AdjdAccrAmtInInFreeDfndCrcy2 AS AdjdAccrAmtInInFreeDfndCrcy2,
  I_AccrEnginePeriodicAmounts.AdjdAccrAmtInInFreeDfndCrcy3 AS AdjdAccrAmtInInFreeDfndCrcy3,
  I_AccrEnginePeriodicAmounts.AdjdAccrAmtInInFreeDfndCrcy4 AS AdjdAccrAmtInInFreeDfndCrcy4,
  I_AccrEnginePeriodicAmounts.AdjdAccrAmtInInFreeDfndCrcy5 AS AdjdAccrAmtInInFreeDfndCrcy5,
  I_AccrEnginePeriodicAmounts.AdjdAccrAmtInInFreeDfndCrcy6 AS AdjdAccrAmtInInFreeDfndCrcy6,
  I_AccrEnginePeriodicAmounts.AdjdAccrAmtInInFreeDfndCrcy7 AS AdjdAccrAmtInInFreeDfndCrcy7,
  I_AccrEnginePeriodicAmounts.AdjdAccrAmtInInFreeDfndCrcy8 AS AdjdAccrAmtInInFreeDfndCrcy8,
  I_AccrEnginePeriodicAmounts.AccrualEngineAccrQtyInBaseUnit AS AccrualEngineAccrQtyInBaseUnit,
  I_AccrEnginePeriodicAmounts.DeferredCostInTransCrcy AS DeferredCostInTransCrcy,
  I_AccrEnginePeriodicAmounts.DeferredCostInCoCodeCrcy AS DeferredCostInCoCodeCrcy,
  I_AccrEnginePeriodicAmounts.DeferredCostInGlobalCrcy AS DeferredCostInGlobalCrcy,
  I_AccrEnginePeriodicAmounts.DeferredCostInFreeDfndCrcy1 AS DeferredCostInFreeDfndCrcy1,
  I_AccrEnginePeriodicAmounts.DeferredCostInFreeDfndCrcy2 AS DeferredCostInFreeDfndCrcy2,
  I_AccrEnginePeriodicAmounts.DeferredCostInFreeDfndCrcy3 AS DeferredCostInFreeDfndCrcy3,
  I_AccrEnginePeriodicAmounts.DeferredCostInFreeDfndCrcy4 AS DeferredCostInFreeDfndCrcy4,
  I_AccrEnginePeriodicAmounts.DeferredCostInFreeDfndCrcy5 AS DeferredCostInFreeDfndCrcy5,
  I_AccrEnginePeriodicAmounts.DeferredCostInFreeDfndCrcy6 AS DeferredCostInFreeDfndCrcy6,
  I_AccrEnginePeriodicAmounts.DeferredCostInFreeDfndCrcy7 AS DeferredCostInFreeDfndCrcy7,
  I_AccrEnginePeriodicAmounts.DeferredCostInFreeDfndCrcy8 AS DeferredCostInFreeDfndCrcy8,
  I_AccrEnginePeriodicAmounts.DeferredQuantityInBaseUnit AS DeferredQuantityInBaseUnit,
  I_AccrEnginePeriodicAmounts.ProposedAccrAmtInTransCrcy AS ProposedAccrAmtInTransCrcy,
  I_AccrEnginePeriodicAmounts.ProposedAccrAmtInCoCodeCrcy AS ProposedAccrAmtInCoCodeCrcy,
  I_AccrEnginePeriodicAmounts.ProposedAccrAmtInGlobalCrcy AS ProposedAccrAmtInGlobalCrcy,
  I_AccrEnginePeriodicAmounts.ProposedAccrAmtInFreeDfndCrcy1 AS ProposedAccrAmtInFreeDfndCrcy1,
  I_AccrEnginePeriodicAmounts.ProposedAccrAmtInFreeDfndCrcy2 AS ProposedAccrAmtInFreeDfndCrcy2,
  I_AccrEnginePeriodicAmounts.ProposedAccrAmtInFreeDfndCrcy3 AS ProposedAccrAmtInFreeDfndCrcy3,
  I_AccrEnginePeriodicAmounts.ProposedAccrAmtInFreeDfndCrcy4 AS ProposedAccrAmtInFreeDfndCrcy4,
  I_AccrEnginePeriodicAmounts.ProposedAccrAmtInFreeDfndCrcy5 AS ProposedAccrAmtInFreeDfndCrcy5,
  I_AccrEnginePeriodicAmounts.ProposedAccrAmtInFreeDfndCrcy6 AS ProposedAccrAmtInFreeDfndCrcy6,
  I_AccrEnginePeriodicAmounts.ProposedAccrAmtInFreeDfndCrcy7 AS ProposedAccrAmtInFreeDfndCrcy7,
  I_AccrEnginePeriodicAmounts.ProposedAccrAmtInFreeDfndCrcy8 AS ProposedAccrAmtInFreeDfndCrcy8,
  I_AccrEnginePeriodicAmounts.AccrualEnginePrpsdQtyInBsUnt AS AccrualEnginePrpsdQtyInBsUnt,
  I_AccrEnginePeriodicAmounts.AccrualAmountProposedByUser AS AccrualAmountProposedByUser,
  I_AccrEnginePeriodicAmounts.AccrualAmountProposalTime AS AccrualAmountProposalTime,
  I_AccrEnginePeriodicAmounts.AccrualAmountProposalDate AS AccrualAmountProposalDate,
  I_AccrEnginePeriodicAmounts.AccrualAmountProposalDateTime AS AccrualAmountProposalDateTime,
  I_AccrEnginePeriodicAmounts.ProposedAccrAmtAdjmtReason AS ProposedAccrAmtAdjmtReason,
  I_AccrEnginePeriodicAmounts.AccrualAmountAdjustedByUser AS AccrualAmountAdjustedByUser,
  I_AccrEnginePeriodicAmounts.AccrualAmountAdjustmentDate AS AccrualAmountAdjustmentDate,
  I_AccrEnginePeriodicAmounts.AccrualAmountAdjustmentTime AS AccrualAmountAdjustmentTime,
  I_AccrEnginePeriodicAmounts.AccrAmountAdjustmentDateTime AS AccrAmountAdjustmentDateTime,
  I_AccrEnginePeriodicAmounts.AccrualPostingReviewType AS AccrualPostingReviewType,
  I_AccrEnginePeriodicAmounts.AccrualAmountReviewStatus AS AccrualAmountReviewStatus,
  I_AccrEnginePeriodicAmounts.AccrualAmountIsReviewed AS AccrualAmountIsReviewed,
  I_AccrEnginePeriodicAmounts.ReviewProcessIsActive AS ReviewProcessIsActive,
  I_AccrEnginePeriodicAmounts.ReviewApprovalAccrualType AS ReviewApprovalAccrualType,
  I_AccrEnginePeriodicAmounts.ReviewedByUser AS ReviewedByUser,
  I_AccrEnginePeriodicAmounts.ReviewComment AS ReviewComment,
  I_AccrEnginePeriodicAmounts.AmountReviewDate AS AmountReviewDate,
  I_AccrEnginePeriodicAmounts.AmountReviewTime AS AmountReviewTime,
  I_AccrEnginePeriodicAmounts.AccrAmountReviewDateTime AS AccrAmountReviewDateTime,
  I_AccrEnginePeriodicAmounts.AccrualPostingApprovalType AS AccrualPostingApprovalType,
  I_AccrEnginePeriodicAmounts.AccrualAmountApprovalStatus AS AccrualAmountApprovalStatus,
  I_AccrEnginePeriodicAmounts.AccrualAmountIsApproved AS AccrualAmountIsApproved,
  I_AccrEnginePeriodicAmounts.ApprovedByUser AS ApprovedByUser,
  I_AccrEnginePeriodicAmounts.AccrualAmountApprovalDate AS AccrualAmountApprovalDate,
  I_AccrEnginePeriodicAmounts.AccrualAmountApprovalTime AS AccrualAmountApprovalTime,
  I_AccrEnginePeriodicAmounts.AccrAmountApprovalDateTime AS AccrAmountApprovalDateTime,
  I_AccrEnginePeriodicAmounts._TransactionCurrency AS _TransactionCurrency,
  I_AccrEnginePeriodicAmounts._CompanyCodeCurrency AS _CompanyCodeCurrency,
  I_AccrEnginePeriodicAmounts._GlobalCurrency AS _GlobalCurrency,
  I_AccrEnginePeriodicAmounts._FreeDefinedCurrency1 AS _FreeDefinedCurrency1,
  I_AccrEnginePeriodicAmounts._FreeDefinedCurrency2 AS _FreeDefinedCurrency2,
  I_AccrEnginePeriodicAmounts._FreeDefinedCurrency3 AS _FreeDefinedCurrency3,
  I_AccrEnginePeriodicAmounts._FreeDefinedCurrency4 AS _FreeDefinedCurrency4,
  I_AccrEnginePeriodicAmounts._FreeDefinedCurrency5 AS _FreeDefinedCurrency5,
  I_AccrEnginePeriodicAmounts._FreeDefinedCurrency6 AS _FreeDefinedCurrency6,
  I_AccrEnginePeriodicAmounts._FreeDefinedCurrency7 AS _FreeDefinedCurrency7,
  I_AccrEnginePeriodicAmounts._FreeDefinedCurrency8 AS _FreeDefinedCurrency8,
  I_AccrEnginePeriodicAmounts._BaseUnit AS _BaseUnit,
  I_AccrEnginePeriodicAmounts._ProposedByUser AS _ProposedByUser,
  I_AccrEnginePeriodicAmounts._AdjustedByUser AS _AdjustedByUser,
  I_AccrEnginePeriodicAmounts._ReviewedByUser AS _ReviewedByUser,
  I_AccrEnginePeriodicAmounts._ApprovedByUser AS _ApprovedByUser,
  Derivation.FiscalPeriodEndDate AS FiscalPeriodEndDate,
  P_AccrSubobjItemPrecalc.AccrualEngineAccrualObjectType AS AccrualEngineAccrualObjectType,
  P_AccrSubobjItemPrecalc.AccrualObjectLogicalSystem AS AccrualObjectLogicalSystem,
  P_AccrSubobjItemPrecalc.CompanyCode AS CompanyCode,
  P_AccrSubobjItemPrecalc.AccrualObject AS AccrualObject,
  P_AccrSubobjItemPrecalc.AccrualSubobject AS AccrualSubobject,
  P_AccrSubobjItemPrecalc.AccrualItemType AS AccrualItemType,
  P_AccrSubobjItemPrecalc.Ledger AS Ledger,
  P_AccrSubobjItemPrecalc.AccrSubobjectItmValdtyEndDte AS AccrSubobjectItmValdtyEndDte,
  P_AccrSubobjItemPrecalc.AccrSubobjectItmValdtyStrtDte AS AccrSubobjectItmValdtyStrtDte,
  P_AccrSubobjItemPrecalc.AccrualMethod AS AccrualMethod,
  P_AccrSubobjItemPrecalc.AccrSubobjHdrStartOfLifeDate AS AccrSubobjHdrStartOfLifeDate,
  P_AccrSubobjItemPrecalc.AccrSubobjHdrEndOfLifeDate AS AccrSubobjHdrEndOfLifeDate,
  P_AccrSubobjItemPrecalc.AccrualItemIsObsolete AS AccrualItemIsObsolete,
  P_AccrSubobjItemPrecalc.PlanAccrualItemType AS PlanAccrualItemType,
  P_AccrSubobjItemPrecalc.PlanAccrualMethod AS PlanAccrualMethod,
  P_AccrSubobjItemPrecalc.ActualAccrualItemType AS ActualAccrualItemType,
  P_AccrSubobjItemPrecalc.ActualAccrualMethod AS ActualAccrualMethod,
  P_AccrSubobjItemPrecalc.DeferralItemType AS DeferralItemType,
  P_AccrSubobjItemPrecalc.DeferralMethod AS DeferralMethod,
  P_AccrSubobjItemPrecalc.TotalAccrualQuantity AS TotalAccrualQuantity,
  P_AccrSubobjItemPrecalc.TotalAccrAmountInTransCrcy AS TotalAccrAmountInTransCrcy,
  P_AccrSubobjItemPrecalc.TotalAccrAmtInCompanyCodeCrcy AS TotalAccrAmtInCompanyCodeCrcy,
  P_AccrSubobjItemPrecalc.TotalAccrAmountInGlobalCrcy AS TotalAccrAmountInGlobalCrcy,
  P_AccrSubobjItemPrecalc.TotalAccrAmountInFreeDfndCrcy1 AS TotalAccrAmountInFreeDfndCrcy1,
  P_AccrSubobjItemPrecalc.TotalAccrAmountInFreeDfndCrcy2 AS TotalAccrAmountInFreeDfndCrcy2,
  P_AccrSubobjItemPrecalc.TotalAccrAmountInFreeDfndCrcy3 AS TotalAccrAmountInFreeDfndCrcy3,
  P_AccrSubobjItemPrecalc.TotalAccrAmountInFreeDfndCrcy4 AS TotalAccrAmountInFreeDfndCrcy4,
  P_AccrSubobjItemPrecalc.TotalAccrAmountInFreeDfndCrcy5 AS TotalAccrAmountInFreeDfndCrcy5,
  P_AccrSubobjItemPrecalc.TotalAccrAmountInFreeDfndCrcy6 AS TotalAccrAmountInFreeDfndCrcy6,
  P_AccrSubobjItemPrecalc.TotalAccrAmountInFreeDfndCrcy7 AS TotalAccrAmountInFreeDfndCrcy7,
  P_AccrSubobjItemPrecalc.TotalAccrAmountInFreeDfndCrcy8 AS TotalAccrAmountInFreeDfndCrcy8,
  P_AccrSubobjItemPrecalc.AccrOpngPostgDocumentType AS AccrOpngPostgDocumentType,
  P_AccrSubobjItemPrecalc.AccrPerdcPostgDocumentType AS AccrPerdcPostgDocumentType,
  P_AccrSubobjItemPrecalc.AccrClsgPostgDocumentType AS AccrClsgPostgDocumentType,
  P_AccrSubobjItemPrecalc.AccrOpngPostgAccrAccount AS AccrOpngPostgAccrAccount,
  P_AccrSubobjItemPrecalc.AccrOpngPostgOffstgAccount AS AccrOpngPostgOffstgAccount,
  P_AccrSubobjItemPrecalc.AccrPerdcPostgAccrAccount AS AccrPerdcPostgAccrAccount,
  P_AccrSubobjItemPrecalc.AccrPerdcPostgOffstgAcct AS AccrPerdcPostgOffstgAcct,
  P_AccrSubobjItemPrecalc.AccrClsgPostgAccrAccount AS AccrClsgPostgAccrAccount,
  P_AccrSubobjItemPrecalc.AccrClsgPostgOffstgAccount AS AccrClsgPostgOffstgAccount,
  P_AccrSubobjItemPrecalc.AccrualItemLastChangeDateTime AS AccrualItemLastChangeDateTime,
  P_AccrSubobjItemPrecalc.AccrSubobjectLifeCycleStatus AS AccrSubobjectLifeCycleStatus,
  P_AccrSubobjItemPrecalc.PurchasingDocumentItem AS PurchasingDocumentItem,
  P_AccrSubobjItemPrecalc.AccountAssignmentNumber AS AccountAssignmentNumber,
  P_AccrSubobjItemPrecalc._AccrCompanyCode AS _AccrCompanyCode,
  P_AccrSubobjItemPrecalc._AccrItemType AS _AccrItemType,
  P_AccrSubobjItemPrecalc._AccrLogicalSystem AS _AccrLogicalSystem,
  P_AccrSubobjItemPrecalc._AccrMethod AS _AccrMethod,
  P_AccrSubobjItemPrecalc._AccrObj AS _AccrObj,
  P_AccrSubobjItemPrecalc._AccrObjectType AS _AccrObjectType,
  P_AccrSubobjItemPrecalc._AccrSubobj AS _AccrSubobj,
  P_AccrSubobjItemPrecalc._ActualAccrItemType AS _ActualAccrItemType,
  P_AccrSubobjItemPrecalc._ActualAccrMethod AS _ActualAccrMethod,
  P_AccrSubobjItemPrecalc._ActualItem AS _ActualItem,
  P_AccrSubobjItemPrecalc._ClsgPostgAccrAccount AS _ClsgPostgAccrAccount,
  P_AccrSubobjItemPrecalc._ClsgPostgDocumentType AS _ClsgPostgDocumentType,
  P_AccrSubobjItemPrecalc._ClsgPostgOffstgAccount AS _ClsgPostgOffstgAccount,
  P_AccrSubobjItemPrecalc._DeferralItem AS _DeferralItem,
  P_AccrSubobjItemPrecalc._DeferralItemType AS _DeferralItemType,
  P_AccrSubobjItemPrecalc._DeferralMethod AS _DeferralMethod,
  P_AccrSubobjItemPrecalc._Ledger AS _Ledger,
  P_AccrSubobjItemPrecalc._OpngPostgAccrAccount AS _OpngPostgAccrAccount,
  P_AccrSubobjItemPrecalc._OpngPostgDocumentType AS _OpngPostgDocumentType,
  P_AccrSubobjItemPrecalc._OpngPostgOffstgAccount AS _OpngPostgOffstgAccount,
  P_AccrSubobjItemPrecalc._PerdcPostgAccrAccount AS _PerdcPostgAccrAccount,
  P_AccrSubobjItemPrecalc._PerdcPostgDocumentType AS _PerdcPostgDocumentType,
  P_AccrSubobjItemPrecalc._PerdcPostgOffstgAccount AS _PerdcPostgOffstgAccount,
  P_AccrSubobjItemPrecalc._PlanAccrItemType AS _PlanAccrItemType,
  P_AccrSubobjItemPrecalc._PlanAccrMethod AS _PlanAccrMethod,
  P_AccrSubobjItemPrecalc._PlanItem AS _PlanItem,
  _AccrEngineAccrSubobjAssgmt.Segment AS Segment,
  _AccrEngineAccrSubobjAssgmt.FundedProgram AS FundedProgram,
  _MnlAccrsAccrualSubobjectItem.ManualAccrualsAccrObjectType AS ManualAccrualsAccrObjectType,
  _MnlAccrsAccrualSubobjectItem.ManualAccrualsAccrObject AS ManualAccrualsAccrObject
FROM I_FiscalCalYearPeriodForCoCode AS Derivation
INNER JOIN P_AccrSubobjItemPrecalc ON /* join condition not captured in parsed metadata */
INNER JOIN I_AccrEnginePeriodicAmounts ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AccrEngineAccrSubobjAssgmt AS _AccrEngineAccrSubobjAssgmt ON _AccrEngineAccrSubobjAssgmt.AccrualEngineAccrualObjectType = P_AccrSubobjItemPrecalc.AccrualEngineAccrualObjectType AND _AccrEngineAccrSubobjAssgmt.AccrualObjectLogicalSystem = P_AccrSubobjItemPrecalc.AccrualObjectLogicalSystem AND _AccrEngineAccrSubobjAssgmt.CompanyCode = P_AccrSubobjItemPrecalc.CompanyCode AND _AccrEngineAccrSubobjAssgmt.AccrualObject = P_AccrSubobjItemPrecalc.AccrualObject AND _AccrEngineAccrSubobjAssgmt.AccrualSubobject = P_AccrSubobjItemPrecalc.AccrualSubobject AND _AccrEngineAccrSubobjAssgmt.AccrAcctAssgmtValdtyStrtDte <= Derivation.FiscalPeriodEndDate AND _AccrEngineAccrSubobjAssgmt.AccrAcctAssgmtValdtyEndDte >= Derivation.FiscalPeriodEndDate  -- association [0..1]
LEFT OUTER JOIN I_AccrEngineAccrSubobjAssgmt AS _NxtAccrEngineAccrSubobjAssgmt ON _NxtAccrEngineAccrSubobjAssgmt.AccrualEngineAccrualObjectType = P_AccrSubobjItemPrecalc.AccrualEngineAccrualObjectType AND _NxtAccrEngineAccrSubobjAssgmt.AccrualObjectLogicalSystem = P_AccrSubobjItemPrecalc.AccrualObjectLogicalSystem AND _NxtAccrEngineAccrSubobjAssgmt.CompanyCode = P_AccrSubobjItemPrecalc.CompanyCode AND _NxtAccrEngineAccrSubobjAssgmt.AccrualObject = P_AccrSubobjItemPrecalc.AccrualObject AND _NxtAccrEngineAccrSubobjAssgmt.AccrualSubobject = P_AccrSubobjItemPrecalc.AccrualSubobject AND _NxtAccrEngineAccrSubobjAssgmt.AccrAcctAssgmtValdtyStrtDte > Derivation.FiscalPeriodEndDate AND _NxtAccrEngineAccrSubobjAssgmt.AccrAcctAssgmtValdtyStrtDte <= P_AccrSubobjItemPrecalc.AccrSubobjectItmValdtyEndDte  -- association [0..1]
LEFT OUTER JOIN I_PurgDocAccountAssignment AS _PurgDocAccountAssignment ON _PurgDocAccountAssignment.PurchasingDocument = P_AccrSubobjItemPrecalc.AccrualObject AND _PurgDocAccountAssignment.PurchasingDocumentItem = P_AccrSubobjItemPrecalc.PurchasingDocumentItem AND _PurgDocAccountAssignment.AccountAssignmentNumber = P_AccrSubobjItemPrecalc.AccountAssignmentNumber  -- association [0..1]
LEFT OUTER JOIN I_MnlAccrsAccrualSubobjectItem AS _MnlAccrsAccrualSubobjectItem ON _MnlAccrsAccrualSubobjectItem.CompanyCode = P_AccrSubobjItemPrecalc.CompanyCode AND _MnlAccrsAccrualSubobjectItem.AccrualObject = P_AccrSubobjItemPrecalc.AccrualObject AND _MnlAccrsAccrualSubobjectItem.AccrualSubobject = P_AccrSubobjItemPrecalc.AccrualSubobject  -- association [0..1]
LEFT OUTER JOIN I_AccrEngineAccrObjectTypeText AS _AccrObjectTypeText ON P_AccrSubobjItemPrecalc.AccrualEngineAccrualObjectType = _AccrObjectTypeText.AccrualEngineAccrualObjectType  -- association [0..*]
LEFT OUTER JOIN I_AccrAmountApprovalStatusText AS _AccrAmountApprovalStatusText ON I_AccrEnginePeriodicAmounts.AccrualAmountApprovalStatus = _AccrAmountApprovalStatusText.AccrualAmountApprovalStatus  -- association [0..*]
LEFT OUTER JOIN I_AccrAmountReviewStatusText AS _AccrAmountReviewStatusText ON I_AccrEnginePeriodicAmounts.AccrualAmountReviewStatus = _AccrAmountReviewStatusText.AccrualAmountReviewStatus  -- association [0..*]
LEFT OUTER JOIN I_AccrualPostingReviewTypeText AS _AccrualPostingReviewTypeText ON I_AccrEnginePeriodicAmounts.AccrualPostingReviewType = _AccrualPostingReviewTypeText.AccrualPostingReviewType  -- association [0..*]
LEFT OUTER JOIN I_AccrPostingApprovalTypeText AS _AccrPostingApprovalTypeText ON I_AccrEnginePeriodicAmounts.AccrualPostingApprovalType = _AccrPostingApprovalTypeText.AccrualPostingApprovalType  -- association [0..*]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON CostCenter = _CostCenterText.CostCenter AND ControllingArea = _CostCenterText.ControllingArea AND FiscalPeriodEndDate >= _CostCenterText.ValidityStartDate AND FiscalPeriodEndDate <= _CostCenterText.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_LedgerText AS _LedgerText ON P_AccrSubobjItemPrecalc.Ledger = _LedgerText.Ledger  -- association [0..*]
LEFT OUTER JOIN I_AccrEngineSubobjLifeCycStsT AS _LifeCycleStatusText ON P_AccrSubobjItemPrecalc.AccrSubobjectLifeCycleStatus = _LifeCycleStatusText.AccrSubobjectLifeCycleStatus  -- association [0..*]
LEFT OUTER JOIN I_MnlAccrsAccrObjectTypeText AS _MnlAccrsAccrObjectTypeText ON _MnlAccrsAccrualSubobjectItem.ManualAccrualsAccrObjectType = _MnlAccrsAccrObjectTypeText.ManualAccrualsAccrObjectType  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ProfitCenter = _ProfitCenterText.ProfitCenter AND ControllingArea = _ProfitCenterText.ControllingArea AND FiscalPeriodEndDate >= _ProfitCenterText.ValidityStartDate AND FiscalPeriodEndDate <= _ProfitCenterText.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_ProjectNetwork AS _ProjectNetwork ON ProjectNetwork = _ProjectNetwork.ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _AdjustedByUserContactCard ON I_AccrEnginePeriodicAmounts.AccrualAmountAdjustedByUser = _AdjustedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ApprovedByUserContactCard ON I_AccrEnginePeriodicAmounts.ApprovedByUser = _ApprovedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ProposedByUserContactCard ON I_AccrEnginePeriodicAmounts.AccrualAmountProposedByUser = _ProposedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ReviewedByUserContactCard ON I_AccrEnginePeriodicAmounts.ReviewedByUser = _ReviewedByUserContactCard.ContactCardID  -- association [0..1]
;