C_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 C_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 C_AccrSubobjItmWthPerdcAmounts AS
SELECT
  AccrualEngineAccrualObjectType,
  AccrualObjectLogicalSystem,
  CompanyCode,
  AccrualObject,
  AccrualSubobject,
  AccrualItemType,
  Ledger,
  AccrualEngineReferenceObject,
  AccrSubobjectItmValdtyEndDte,
  AccrualPeriodEndDate,
  AccrualPeriodStartDate,
  AccrualObjectForDisplay,
  AccrualMethod,
  AccrSubobjHdrStartOfLifeDate,
  AccrSubobjHdrEndOfLifeDate,
  AccrualItemIsObsolete,
  PlanAccrualItemType,
  PlanAccrualMethod,
  ActualAccrualItemType,
  ActualAccrualMethod,
  DeferralItemType,
  DeferralMethod,
  TotalAccrualQuantity,
  TotalAccrualQuantityUnit,
  TotalAccrAmountInTransCrcy,
  TotalAccrAmtInCompanyCodeCrcy,
  TotalAccrAmountInGlobalCrcy,
  TotalAccrAmountInFreeDfndCrcy1,
  TotalAccrAmountInFreeDfndCrcy2,
  TotalAccrAmountInFreeDfndCrcy3,
  TotalAccrAmountInFreeDfndCrcy4,
  TotalAccrAmountInFreeDfndCrcy5,
  TotalAccrAmountInFreeDfndCrcy6,
  TotalAccrAmountInFreeDfndCrcy7,
  TotalAccrAmountInFreeDfndCrcy8,
  TransactionCurrency,
  CompanyCodeCurrency,
  GlobalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AccrOpngPostgDocumentType,
  AccrPerdcPostgDocumentType,
  AccrClsgPostgDocumentType,
  AccrOpngPostgAccrAccount,
  AccrOpngPostgOffstgAccount,
  AccrPerdcPostgAccrAccount,
  AccrPerdcPostgOffstgAcct,
  AccrClsgPostgAccrAccount,
  AccrClsgPostgOffstgAccount,
  cast( '' as aceps_inc_blart ) AS AccrOpngPostgDocTypeDerived,
  cast( '' as aceps_per_blart ) AS AccrPerdcPostgDocTypeDerived,
  cast( '' as aceps_fin_blart ) AS AccrClsgPostgDocTypeDerived,
  cast( '' as ace_accnt_inception_accrual ) AS AccrOpngPostgAccrAcctDerived,
  cast( '' as ace_accnt_inception_offsetting ) AS AccrOpngPostgOffstgAcctDerived,
  cast( '' as ace_accnt_periodic_accrual ) AS AccrPerdcPostgAccrAcctDerived,
  cast( '' as ace_accnt_periodic_offsetting ) AS AccrPerdcPostgOffstgAcctDerivd,
  cast( '' as ace_accnt_final_accrual ) AS AccrClsgPostgAccrAcctDerived,
  cast( '' as ace_accnt_final_offsetting ) AS AccrClsgPostgOffstgAcctDerived,
  PlannedCostInTransCrcy,
  PlndCostInCoCodeCrcy,
  PlannedCostInGlobalCrcy,
  PlannedCostInFreeDfndCrcy1,
  PlannedCostInFreeDfndCrcy2,
  PlannedCostInFreeDfndCrcy3,
  PlannedCostInFreeDfndCrcy4,
  PlannedCostInFreeDfndCrcy5,
  PlannedCostInFreeDfndCrcy6,
  PlannedCostInFreeDfndCrcy7,
  PlannedCostInFreeDfndCrcy8,
  AccrualEnginePlndQtyInBaseUnit,
  AdjustedPlannedCostInTransCrcy,
  AdjdPlannedCostInCoCodeCrcy,
  AdjdPlannedCostInGlobalCrcy,
  AdjdPlannedCostInFreeDfndCrcy1,
  AdjdPlannedCostInFreeDfndCrcy2,
  AdjdPlannedCostInFreeDfndCrcy3,
  AdjdPlannedCostInFreeDfndCrcy4,
  AdjdPlannedCostInFreeDfndCrcy5,
  AdjdPlannedCostInFreeDfndCrcy6,
  AdjdPlannedCostInFreeDfndCrcy7,
  AdjdPlannedCostInFreeDfndCrcy8,
  AccrualEngineAdjdQtyInBaseUnit,
  ActualCostInTransCrcy,
  ActualCostAmtInCCCrcy,
  ActualCostInGlobalCrcy,
  ActualCostInFreeDfndCrcy1,
  ActualCostInFreeDfndCrcy2,
  ActualCostInFreeDfndCrcy3,
  ActualCostInFreeDfndCrcy4,
  ActualCostInFreeDfndCrcy5,
  ActualCostInFreeDfndCrcy6,
  ActualCostInFreeDfndCrcy7,
  ActualCostInFreeDfndCrcy8,
  AccrualEngineActlQtyInBaseUnit,
  AdjustedAccrAmtInTransCrcy,
  AdjustedAccrAmtInCoCodeCrcy,
  AdjustedAccrAmtInGlobalCrcy,
  AdjdAccrAmtInInFreeDfndCrcy1,
  AdjdAccrAmtInInFreeDfndCrcy2,
  AdjdAccrAmtInInFreeDfndCrcy3,
  AdjdAccrAmtInInFreeDfndCrcy4,
  AdjdAccrAmtInInFreeDfndCrcy5,
  AdjdAccrAmtInInFreeDfndCrcy6,
  AdjdAccrAmtInInFreeDfndCrcy7,
  AdjdAccrAmtInInFreeDfndCrcy8,
  AccrualEngineAccrQtyInBaseUnit,
  DeferredCostInTransCrcy,
  DeferredCostInCoCodeCrcy,
  DeferredCostInGlobalCrcy,
  DeferredCostInFreeDfndCrcy1,
  DeferredCostInFreeDfndCrcy2,
  DeferredCostInFreeDfndCrcy3,
  DeferredCostInFreeDfndCrcy4,
  DeferredCostInFreeDfndCrcy5,
  DeferredCostInFreeDfndCrcy6,
  DeferredCostInFreeDfndCrcy7,
  DeferredCostInFreeDfndCrcy8,
  DeferredQuantityInBaseUnit,
  ProposedAccrAmtInTransCrcy,
  ProposedAccrAmtInCoCodeCrcy,
  ProposedAccrAmtInGlobalCrcy,
  ProposedAccrAmtInFreeDfndCrcy1,
  ProposedAccrAmtInFreeDfndCrcy2,
  ProposedAccrAmtInFreeDfndCrcy3,
  ProposedAccrAmtInFreeDfndCrcy4,
  ProposedAccrAmtInFreeDfndCrcy5,
  ProposedAccrAmtInFreeDfndCrcy6,
  ProposedAccrAmtInFreeDfndCrcy7,
  ProposedAccrAmtInFreeDfndCrcy8,
  AccrualEnginePrpsdQtyInBsUnt,
  ReviewProcessIsActive,
  ReviewApprovalAccrualType,
  AccrPeriodAmtCalculationMethod,
  AccrualAmountProposedByUser,
  AccrualAmountProposalDateTime,
  ProposedAccrAmtAdjmtReason,
  ReviewComment,
  AccrualAmountAdjustedByUser,
  AccrAmountAdjustmentDateTime,
  AccrualPostingReviewType,
  AccrualAmountReviewStatus,
  AccrualAmountIsReviewed,
  ReviewedByUser,
  AccrAmountReviewDateTime,
  AccrualPostingApprovalType,
  AccrualAmountApprovalStatus,
  AccrualAmountIsApproved,
  ApprovedByUser,
  AccrAmountApprovalDateTime,
  AccrualGeneralValidityStartDte,
  AccrualGeneralValidityEndDte,
  ManualAccrualsAccrObjectType,
  ManualAccrualsAccrObject,
  BusinessArea,
  ProfitCenter,
  Segment,
  Fund,
  FundsCenter,
  cast(CommitmentItemShortID as f4900_bbp_bapi_fipos preserving type) AS CommitmentItemShortID,
  FunctionalArea,
  GrantID,
  FundedProgram,
  BudgetPeriod,
  CostCenter,
  cast('' as fis_cctr_hryid_42) AS CostCenterHierarchy,
  cast('' as fis_cctr_hrynid_50) AS CostCenterHierarchyNode,
  cast('' as fis_hryid_ccode_42) AS CompanyCodeHierarchy,
  cast('' as fis_hrynid_ccode_50) AS CompanyCodeHierarchyNode,
  cast('' as fis_prctr_hryid_42) AS ProfitCenterHierarchy,
  cast('' as fis_prctr_hrynid_50) AS ProfitCenterHierarchyNode,
  ControllingArea,
  OrderID,
  WBSElementInternalID,
  WBSElementExternalID,
  CostObject,
  CostCtrActivityType,
  ProjectNetwork,
  cast(ProjectNetworkInternalID as f4900_co_aufpl preserving type) AS ProjectNetworkInternalID,
  BusinessProcess,
  SalesOrder,
  SalesOrderItem,
  ProfitabilitySegment,
  _AccrObjectTypeText[1:Language = $session.system_language].AccrEngineAccrObjectTypeName AS AccrEngineAccrObjectTypeName,
  _AccrAmountApprovalStatusText[1:Language = $session.system_language].AccrAmountApprovalStatusName AS AccrAmountApprovalStatusName,
  _AccrAmountReviewStatusText[1:Language = $session.system_language].AccrualAmountReviewStatusName AS AccrualAmountReviewStatusName,
  _AccrualPostingReviewTypeText[1:Language = $session.system_language].AccrualPostingReviewTypeName AS AccrualPostingReviewTypeName,
  _BusinessAreaText[1:Language = $session.system_language].BusinessAreaName AS BusinessAreaName,
  _CostCenterText[1:Language = $session.system_language].CostCenterName AS CostCenterName,
  _LedgerText[1:Language = $session.system_language].LedgerName AS LedgerName,
  _LifeCycleStatusText[1:Language = $session.system_language].AccrSubobjLifeCycleStatusName AS AccrSubobjLifeCycleStatusName,
  _AccrPostingApprovalTypeText[1:Language = $session.system_language].AccrualPostingApprovalTypeName AS AccrualPostingApprovalTypeName,
  _MnlAccrsAccrObjectTypeText[1:Language = $session.system_language].ManualAccrualsAccrObjTypeName AS ManualAccrualsAccrObjTypeName,
  _ProfitCenterText[1:Language = $session.system_language].ProfitCenterName AS ProfitCenterName,
  _AccrCompanyCode.CompanyCodeName AS CompanyCodeName,
  _AccrLedgerGroup.LedgerGroup AS LedgerGroup,
  _AccrSubobj.AccrualObjectInternalID AS AccrualObjectInternalID,
  _AccrSubobj.AccrualSubobjectInternalID AS AccrualSubobjectInternalID,
  _AccrSubobj.AccrSubobjPauseDate AS AccrSubobjPauseDate,
  _AccrSubobj.AccrSubobjSuspensionDate AS AccrSubobjSuspensionDate,
  _AccrSubobj.AccrSubobjPrematureFinishDate AS AccrSubobjPrematureFinishDate,
  _AccrSubobj.AccrSubobjectLifeCycleStatus AS AccrSubobjectLifeCycleStatus,
  _AccrSubobj.AccrualSubobjectCreatedByUser AS AccrualSubobjectCreatedByUser,
  _AccrSubobj.AccrSubobjCreationDateTime AS AccrSubobjCreationDateTime,
  _AccrSubobj.AccrSubobjLastChangedByUser AS AccrSubobjLastChangedByUser,
  _AccrSubobj.AccrSubobjLastChangeDateTime AS AccrSubobjLastChangeDateTime,
  _AccrSubobj._CreatedByUser AS _CreatedByUser,
  _AccrSubobj._LastChangedByUser AS _LastChangedByUser,
  _ProjectNetwork.ProjectNetworkDescription AS ProjectNetworkDescription,
  _WBSElementBasicData.WBSDescription AS WBSDescription
FROM I_AccrSubobjItmWthPerdcAmounts
LEFT OUTER JOIN E_AccrEngineAccrSubobjAssgmt AS _AssgmtExtension ON I_AccrSubobjItmWthPerdcAmounts.AccrualEngineAccrualObjectType = _AssgmtExtension.AccrualEngineAccrualObjectType AND I_AccrSubobjItmWthPerdcAmounts.AccrualObjectLogicalSystem = _AssgmtExtension.AccrualObjectLogicalSystem AND I_AccrSubobjItmWthPerdcAmounts.CompanyCode = _AssgmtExtension.CompanyCode AND I_AccrSubobjItmWthPerdcAmounts.AccrualObject = _AssgmtExtension.AccrualObject AND I_AccrSubobjItmWthPerdcAmounts.AccrualSubobject = _AssgmtExtension.AccrualSubobject AND I_AccrSubobjItmWthPerdcAmounts.AccrualGeneralValidityEndDte = _AssgmtExtension.AccrAcctAssgmtValdtyEndDte association[0..*] to C_HierRuntimeRprstnDplLeafNode as _CostCenterHierarchyLeafNode on CostCenter = _CostCenterHierarchyLeafNode.UnivHierarchyBusinessEntity AND ControllingArea = _CostCenterHierarchyLeafNode.HierarchyNodeClass AND _CostCenterHierarchyLeafNode.ValidityStartDate <= $session.system_date AND _CostCenterHierarchyLeafNode.ValidityEndDate >= $session.system_date AND _CostCenterHierarchyLeafNode.HierarchyType = '0101' association[0..*] to C_HierRuntimeRprstnDplLeafNode as _CompanyCodeHierLeafNode on CompanyCode = _CompanyCodeHierLeafNode.UnivHierarchyBusinessEntity AND _CompanyCodeHierLeafNode.ValidityStartDate <= $session.system_date AND _CompanyCodeHierLeafNode.ValidityEndDate >= $session.system_date AND _CompanyCodeHierLeafNode.HierarchyType = 'COCD' association[0..*] to C_HierRuntimeRprstnDplLeafNode as _ProfitCenterHierLeafNode on ProfitCenter = _ProfitCenterHierLeafNode.UnivHierarchyBusinessEntity AND ControllingArea = _ProfitCenterHierLeafNode.HierarchyNodeClass AND _ProfitCenterHierLeafNode.ValidityStartDate <= $session.system_date AND _ProfitCenterHierLeafNode.ValidityEndDate >= $session.system_date AND _ProfitCenterHierLeafNode.HierarchyType = '0106'  -- 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]
;