I_AccrSubobjItmWthAcctAsgt

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_AccrSubobjItmWthAcctAsgt.
-- 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_AccrualKeyDate : ace_effdate_s4

CREATE VIEW I_AccrSubobjItmWthAcctAsgt AS
SELECT
  AceSobjItem.AccrualEngineAccrualObjectType AS AccrualEngineAccrualObjectType,
  AceSobjItem.AccrualObjectLogicalSystem AS AccrualObjectLogicalSystem,
  AceSobjItem.CompanyCode AS CompanyCode,
  AceSobjItem.AccrualObject AS AccrualObject,
  AceSobjItem.AccrualSubobject AS AccrualSubobject,
  AceSobjItem.AccrualItemType AS AccrualItemType,
  AceSobjItem.Ledger AS Ledger,
  $parameters.P_AccrualKeyDate AS AccrualKeyDate,
  _AccrEngineAccrualSubobject.AccrualObjectInternalID AS AccrualObjectInternalID,
  _AccrEngineAccrualSubobject.AccrualSubobjectInternalID AS AccrualSubobjectInternalID,
  _AccrEngineAccrualSubobject.AccrSubobjPauseDate AS AccrSubobjPauseDate,
  _AccrEngineAccrualSubobject.AccrSubobjSuspensionDate AS AccrSubobjSuspensionDate,
  _AccrEngineAccrualSubobject.AccrSubobjPrematureFinishDate AS AccrSubobjPrematureFinishDate,
  _AccrEngineAccrualSubobject.AccrSubobjectLifeCycleStatus AS AccrSubobjectLifeCycleStatus,
  _AccrEngineAccrualSubobject.AccrualSubobjectCreatedByUser AS AccrualSubobjectCreatedByUser,
  _AccrEngineAccrualSubobject.AccrSubobjCreationDateTime AS AccrSubobjCreationDateTime,
  _AccrEngineAccrualSubobject.AccrualSubobjectCreationDate AS AccrualSubobjectCreationDate,
  _AccrEngineAccrualSubobject.AccrualSubobjectCreationTime AS AccrualSubobjectCreationTime,
  _AccrEngineAccrualSubobject.AccrSubobjLastChangedByUser AS AccrSubobjLastChangedByUser,
  _AccrEngineAccrualSubobject.AccrualSubobjectLastChangeDate AS AccrualSubobjectLastChangeDate,
  _AccrEngineAccrualSubobject.AccrualSubobjectLastChangeTime AS AccrualSubobjectLastChangeTime,
  _AccrEngineAccrualSubobject.AccrSubobjLastChangeDateTime AS AccrSubobjLastChangeDateTime,
  AceSobjItem.AccrualMethod AS AccrualMethod,
  AceSobjItem.AccrSubobjHdrStartOfLifeDate AS AccrSubobjHdrStartOfLifeDate,
  AceSobjItem.AccrSubobjHdrEndOfLifeDate AS AccrSubobjHdrEndOfLifeDate,
  AceSobjItem.AccrualItemIsObsolete AS AccrualItemIsObsolete,
  AceSobjItem.TotalAccrualQuantity AS TotalAccrualQuantity,
  AceSobjItem.TotalAccrualQuantityUnit AS TotalAccrualQuantityUnit,
  AceSobjItem.TotalAccrAmountInTransCrcy AS TotalAccrAmountInTransCrcy,
  AceSobjItem.TotalAccrAmtInCompanyCodeCrcy AS TotalAccrAmtInCompanyCodeCrcy,
  AceSobjItem.TotalAccrAmountInGlobalCrcy AS TotalAccrAmountInGlobalCrcy,
  AceSobjItem.TotalAccrAmountInFreeDfndCrcy1 AS TotalAccrAmountInFreeDfndCrcy1,
  AceSobjItem.TotalAccrAmountInFreeDfndCrcy2 AS TotalAccrAmountInFreeDfndCrcy2,
  AceSobjItem.TotalAccrAmountInFreeDfndCrcy3 AS TotalAccrAmountInFreeDfndCrcy3,
  AceSobjItem.TotalAccrAmountInFreeDfndCrcy4 AS TotalAccrAmountInFreeDfndCrcy4,
  AceSobjItem.TotalAccrAmountInFreeDfndCrcy5 AS TotalAccrAmountInFreeDfndCrcy5,
  AceSobjItem.TotalAccrAmountInFreeDfndCrcy6 AS TotalAccrAmountInFreeDfndCrcy6,
  AceSobjItem.TotalAccrAmountInFreeDfndCrcy7 AS TotalAccrAmountInFreeDfndCrcy7,
  AceSobjItem.TotalAccrAmountInFreeDfndCrcy8 AS TotalAccrAmountInFreeDfndCrcy8,
  AceSobjItem.TransactionCurrency AS TransactionCurrency,
  AceSobjItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  AceSobjItem.GlobalCurrency AS GlobalCurrency,
  AceSobjItem.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  AceSobjItem.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  AceSobjItem.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  AceSobjItem.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  AceSobjItem.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  AceSobjItem.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  AceSobjItem.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  AceSobjItem.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  AceSobjItem.AccrOpngPostgDocumentType AS AccrOpngPostgDocumentType,
  AceSobjItem.AccrPerdcPostgDocumentType AS AccrPerdcPostgDocumentType,
  AceSobjItem.AccrClsgPostgDocumentType AS AccrClsgPostgDocumentType,
  AceSobjItem.AccrOpngPostgAccrAccount AS AccrOpngPostgAccrAccount,
  AceSobjItem.AccrOpngPostgOffstgAccount AS AccrOpngPostgOffstgAccount,
  AceSobjItem.AccrPerdcPostgAccrAccount AS AccrPerdcPostgAccrAccount,
  AceSobjItem.AccrPerdcPostgOffstgAcct AS AccrPerdcPostgOffstgAcct,
  AceSobjItem.AccrClsgPostgAccrAccount AS AccrClsgPostgAccrAccount,
  AceSobjItem.AccrClsgPostgOffstgAccount AS AccrClsgPostgOffstgAccount,
  _MnlAccrsAccrualSubobjectItem.ManualAccrualsAccrObjectType AS ManualAccrualsAccrObjectType,
  _MnlAccrsAccrualSubobjectItem.ManualAccrualsAccrObject AS ManualAccrualsAccrObject,
  case AceSobjItem.AccrualEngineAccrualObjectType when 'POAC' then _PurgDocAccountAssignment.BusinessArea else _AccrEngineAccrSubobjAssgmt.BusinessArea end as BusinessArea AS BusinessAreaendasBusinessArea,
  case AceSobjItem.AccrualEngineAccrualObjectType when 'POAC' then _PurgDocAccountAssignment.ProfitCenter else _AccrEngineAccrSubobjAssgmt.ProfitCenter end as ProfitCenter AS ProfitCenterendasProfitCenter,
  _AccrEngineAccrSubobjAssgmt.Segment AS Segment,
  case AceSobjItem.AccrualEngineAccrualObjectType when 'POAC' then _PurgDocAccountAssignment.Fund else _AccrEngineAccrSubobjAssgmt.Fund end as Fund AS FundendasFund,
  case AceSobjItem.AccrualEngineAccrualObjectType when 'POAC' then _PurgDocAccountAssignment.FundsCenter else _AccrEngineAccrSubobjAssgmt.FundsCenter end as FundsCenter AS FundsCenterendasFundsCenter,
  case AceSobjItem.AccrualEngineAccrualObjectType when 'POAC' then _PurgDocAccountAssignment.FunctionalArea else _AccrEngineAccrSubobjAssgmt.FunctionalArea end as FunctionalArea AS FunctionalAreaendasFunctionalArea,
  case AceSobjItem.AccrualEngineAccrualObjectType when 'POAC' then _PurgDocAccountAssignment.GrantID else _AccrEngineAccrSubobjAssgmt.GrantID end as GrantID AS GrantIDendasGrantID,
  _AccrEngineAccrSubobjAssgmt.FundedProgram AS FundedProgram,
  case AceSobjItem.AccrualEngineAccrualObjectType when 'POAC' then _PurgDocAccountAssignment.BudgetPeriod else _AccrEngineAccrSubobjAssgmt.BudgetPeriod end as BudgetPeriod AS BudgetPeriodendasBudgetPeriod,
  case AceSobjItem.AccrualEngineAccrualObjectType when 'POAC' then _PurgDocAccountAssignment.CostCenter else _AccrEngineAccrSubobjAssgmt.CostCenter end as CostCenter AS CostCenterendasCostCenter,
  case AceSobjItem.AccrualEngineAccrualObjectType when 'POAC' then _PurgDocAccountAssignment.ControllingArea else _AccrEngineAccrSubobjAssgmt.ControllingArea end as ControllingArea AS ControllingAreaendasControllingArea,
  case AceSobjItem.AccrualEngineAccrualObjectType when 'POAC' then _PurgDocAccountAssignment.OrderID else _AccrEngineAccrSubobjAssgmt.OrderID end as OrderID AS OrderIDendasOrderID,
  case AceSobjItem.AccrualEngineAccrualObjectType when 'POAC' then _PurgDocAccountAssignment.CostObject else _AccrEngineAccrSubobjAssgmt.CostObject end as CostObject AS CostObjectendasCostObject,
  case AceSobjItem.AccrualEngineAccrualObjectType when 'POAC' then _PurgDocAccountAssignment.ProjectNetwork else _AccrEngineAccrSubobjAssgmt.ProjectNetworkObject end as ProjectNetwork AS ProjectNetworkObjectendasProjectNetwork,
  case AceSobjItem.AccrualEngineAccrualObjectType when 'POAC' then _PurgDocAccountAssignment.BusinessProcess else _AccrEngineAccrSubobjAssgmt.BusinessProcess end as BusinessProcess AS BusinessProcessendasBusinessProcess,
  case AceSobjItem.AccrualEngineAccrualObjectType when 'POAC' then _PurgDocAccountAssignment.SalesOrder else _AccrEngineAccrSubobjAssgmt.SalesOrder end as SalesOrder AS SalesOrderendasSalesOrder,
  case AceSobjItem.AccrualEngineAccrualObjectType when 'POAC' then _PurgDocAccountAssignment.SalesOrderItem else _AccrEngineAccrSubobjAssgmt.SalesOrderItem end as SalesOrderItem AS SalesOrderItemendasSalesOrderItem,
  AceSobjItem.PurchasingDocumentItem AS PurchasingDocumentItem,
  AceSobjItem.AccountAssignmentNumber AS AccountAssignmentNumber,
  _AccrEngineAccrItemTypeBasic.AccrualItemTypeCategory AS AccrualItemTypeCategory,
  KeyDateFiscalYearPeriod,
  StartDateFiscalYearPeriod,
  EndDateFiscalYearPeriod
FROM P_AccrSubobjRawItemPrecalc
LEFT OUTER JOIN I_AccrEngineAccrualSubobject AS _AccrEngineAccrualSubobject ON _AccrEngineAccrualSubobject.AccrualEngineAccrualObjectType = AceSobjItem.AccrualEngineAccrualObjectType AND _AccrEngineAccrualSubobject.AccrualObjectLogicalSystem = AceSobjItem.AccrualObjectLogicalSystem AND _AccrEngineAccrualSubobject.CompanyCode = AceSobjItem.CompanyCode AND _AccrEngineAccrualSubobject.AccrualObject = AceSobjItem.AccrualObject AND _AccrEngineAccrualSubobject.AccrualSubobject = AceSobjItem.AccrualSubobject  -- association [1..1]
LEFT OUTER JOIN I_AccrEngineAccrSubobjAssgmt AS _AccrEngineAccrSubobjAssgmt ON _AccrEngineAccrSubobjAssgmt.AccrualEngineAccrualObjectType = AceSobjItem.AccrualEngineAccrualObjectType AND _AccrEngineAccrSubobjAssgmt.AccrualObjectLogicalSystem = AceSobjItem.AccrualObjectLogicalSystem AND _AccrEngineAccrSubobjAssgmt.CompanyCode = AceSobjItem.CompanyCode AND _AccrEngineAccrSubobjAssgmt.AccrualObject = AceSobjItem.AccrualObject AND _AccrEngineAccrSubobjAssgmt.AccrualSubobject = AceSobjItem.AccrualSubobject AND _AccrEngineAccrSubobjAssgmt.AccrAcctAssgmtValdtyStrtDte <= $parameters.P_AccrualKeyDate AND _AccrEngineAccrSubobjAssgmt.AccrAcctAssgmtValdtyEndDte >= $parameters.P_AccrualKeyDate  -- association [0..1]
LEFT OUTER JOIN I_AccrEngineAccrSubobjAssgmt AS _NxtAccrEngineAccrSubobjAssgmt ON _NxtAccrEngineAccrSubobjAssgmt.AccrualEngineAccrualObjectType = AceSobjItem.AccrualEngineAccrualObjectType AND _NxtAccrEngineAccrSubobjAssgmt.AccrualObjectLogicalSystem = AceSobjItem.AccrualObjectLogicalSystem AND _NxtAccrEngineAccrSubobjAssgmt.CompanyCode = AceSobjItem.CompanyCode AND _NxtAccrEngineAccrSubobjAssgmt.AccrualObject = AceSobjItem.AccrualObject AND _NxtAccrEngineAccrSubobjAssgmt.AccrualSubobject = AceSobjItem.AccrualSubobject AND _NxtAccrEngineAccrSubobjAssgmt.AccrAcctAssgmtValdtyStrtDte > $parameters.P_AccrualKeyDate AND _NxtAccrEngineAccrSubobjAssgmt.AccrAcctAssgmtValdtyStrtDte <= AceSobjItem.AccrSubobjectItmValdtyEndDte  -- association [0..1]
LEFT OUTER JOIN I_PurgDocAccountAssignment AS _PurgDocAccountAssignment ON _PurgDocAccountAssignment.PurchasingDocument = AceSobjItem.AccrualObject AND _PurgDocAccountAssignment.PurchasingDocumentItem = AceSobjItem.PurchasingDocumentItem AND _PurgDocAccountAssignment.AccountAssignmentNumber = AceSobjItem.AccountAssignmentNumber  -- association [0..1]
LEFT OUTER JOIN I_MnlAccrsAccrualSubobjectItem AS _MnlAccrsAccrualSubobjectItem ON _MnlAccrsAccrualSubobjectItem.CompanyCode = AceSobjItem.CompanyCode AND _MnlAccrsAccrualSubobjectItem.AccrualObject = AceSobjItem.AccrualObject AND _MnlAccrsAccrualSubobjectItem.AccrualSubobject = AceSobjItem.AccrualSubobject  -- association [0..1]
LEFT OUTER JOIN I_AccrEngineAccrItemTypeBasic AS _AccrEngineAccrItemTypeBasic ON AceSobjItem.AccrualEngineAccrualObjectType = _AccrEngineAccrItemTypeBasic.AccrualEngineAccrualObjectType AND AceSobjItem.AccrualItemType = _AccrEngineAccrItemTypeBasic.AccrualItemType  -- association [0..1]
LEFT OUTER JOIN I_AccrEngineAccrObjectTypeText AS _AccrObjectTypeText ON AceSobjItem.AccrualEngineAccrualObjectType = _AccrObjectTypeText.AccrualEngineAccrualObjectType  -- association [0..*]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON AceSobjItem.CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON CostCenter = _CostCenterText.CostCenter AND ControllingArea = _CostCenterText.ControllingArea AND $parameters.P_AccrualKeyDate >= _CostCenterText.ValidityStartDate AND $parameters.P_AccrualKeyDate <= _CostCenterText.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUserContactCard ON _AccrEngineAccrualSubobject.AccrualSubobjectCreatedByUser = _CreatedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangedByUserContactCard ON _AccrEngineAccrualSubobject.AccrSubobjLastChangedByUser = _LastChangedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_LedgerText AS _LedgerText ON AceSobjItem.Ledger = _LedgerText.Ledger  -- association [0..*]
LEFT OUTER JOIN I_AccrEngineSubobjLifeCycStsT AS _LifeCycleStatusText ON _AccrEngineAccrualSubobject.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 $parameters.P_AccrualKeyDate >= _ProfitCenterText.ValidityStartDate AND $parameters.P_AccrualKeyDate <= _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]
;