I_AccrEngnRptgSimlnActlCostC

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_AccrEngnRptgSimlnActlCostC.
-- 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_KeyDate : ace_reporting_date

CREATE VIEW I_AccrEngnRptgSimlnActlCostC AS
SELECT
  SourceLedger,
  CompanyCode,
  FiscalYear,
  JournalEntry,
  LedgerGLLineItem,
  Ledger,
  FinancialPlanningReqTransSqnc,
  FinancialPlanningDataPacket,
  FinancialPlanningEntryItem,
  PlanningCategory,
  AccrualEngineAccrualObjectType,
  AccrualObjectLogicalSystem,
  AccrualObject,
  AccrualSubobject,
  AccrualItemType,
  AccrualReferenceObject,
  AccrualValueDate,
  AccrualTransactionType,
  TransactionCurrency,
  CompanyCodeCurrency,
  GlobalCurrency,
  PostdAccrAmtInTransCurrency,
  PostdAccrAmtInCoCodeCrcy,
  PostdAccrAmtInGlobalCurrency,
  SmltdAccrAmtInTransCrcy,
  SmltdAccrAmtInCoCodeCrcy,
  SmltdAccrAmtInGlobCrcy,
  AccrualObjectDescription,
  AccrObjPersonResponsibleName,
  AccrSubobjHdrStartOfLifeDate,
  AccrSubobjHdrEndOfLifeDate,
  FiscalYearVariant,
  FiscalPeriod,
  FiscalYearPeriod,
  LedgerFiscalYear,
  PostingDate,
  CreationDateTime,
  AccountingDocCreatedByUser,
  BusinessTransactionType,
  ReferenceDocumentType,
  ReferenceDocumentContext,
  ReferenceDocument,
  FinancialTransactionType,
  SubLedgerAcctLineItemType,
  FunctionalArea,
  ControllingArea,
  DocumentItemText,
  BusinessArea,
  Product,
  GLAccount,
  OffsettingAccount,
  ChartOfAccounts,
  OffsettingChartOfAccounts,
  CostCenter,
  ProfitCenter,
  SalesDocument,
  SalesDocumentItem,
  OrderID,
  WBSElementExternalID,
  ProjectExternalID,
  ProjectNetwork,
  Segment,
  Customer,
  AssignmentReference,
  _AccrualSubobject.AccrSubobjectLifeCycleStatus AS AccrSubobjectLifeCycleStatus,
  _AccrualSubobject.AccrSubobjPauseDate AS AccrSubobjPauseDate,
  _AccrualSubobject.AccrSubobjSuspensionDate AS AccrSubobjSuspensionDate,
  _AccrualSubobject.AccrSubobjPrematureFinishDate AS AccrSubobjPrematureFinishDate,
  _AccrualSubobject.DeferralFinishDate AS DeferralFinishDate,
  _ReferenceSemanticKey.PurchaseOrder AS PurchaseOrder,
  _ReferenceSemanticKey.PurchaseOrderItem AS PurchaseOrderItem,
  _ReferenceSemanticKey.AccountAssignmentNumber AS AccountAssignmentNumber,
  _ReferenceSemanticKey.ServiceEntrySheet AS ServiceEntrySheet,
  _ReferenceSemanticKey.ServiceEntrySheetItem AS ServiceEntrySheetItem,
  cast( _ReferenceSemanticKey.SrvcEntrShtItmAcctAssgmtNumber as ssac_dzekkn preserving type ) AS SrvcEntrShtItmAcctAssgmtNumber
FROM P_AccrEngnRptgSimlnActlUnion
LEFT OUTER JOIN E_JournalEntryItem AS _Extension_acdoca ON SourceLedger = _Extension_acdoca.SourceLedger AND CompanyCode = _Extension_acdoca.CompanyCode AND FiscalYear = _Extension_acdoca.FiscalYear AND JournalEntry = _Extension_acdoca.AccountingDocument AND LedgerGLLineItem = _Extension_acdoca.LedgerGLLineItem  -- association [1..1]
LEFT OUTER JOIN E_FinancialPlanningEntryItem AS _Extension_acdocp ON FinancialPlanningReqTransSqnc = _Extension_acdocp.FinancialPlanningReqTransSqnc AND FinancialPlanningDataPacket = _Extension_acdocp.FinancialPlanningDataPacket AND FinancialPlanningEntryItem = _Extension_acdocp.FinancialPlanningEntryItem  -- association [1..1]
LEFT OUTER JOIN I_AccrEngineAccrualSubobject AS _AccrualSubobject ON AccrualEngineAccrualObjectType = _AccrualSubobject.AccrualEngineAccrualObjectType AND AccrualObjectLogicalSystem = _AccrualSubobject.AccrualObjectLogicalSystem AND CompanyCode = _AccrualSubobject.CompanyCode AND AccrualObject = _AccrualSubobject.AccrualObject AND AccrualSubobject = _AccrualSubobject.AccrualSubobject  -- association [0..1]
LEFT OUTER JOIN I_AccrEngineAccrualObject AS _AccrObj ON AccrualEngineAccrualObjectType = _AccrObj.AccrualEngineAccrualObjectType AND AccrualObjectLogicalSystem = _AccrObj.AccrualObjectLogicalSystem AND CompanyCode = _AccrObj.CompanyCode AND AccrualObject = _AccrObj.AccrualObject  -- association [0..1]
LEFT OUTER JOIN I_AccrEngineSubobjLifeCycSts AS _AccrLifeCycleStatus ON accrsubobjectlifecyclestatus = _AccrLifeCycleStatus.AccrSubobjectLifeCycleStatus  -- association [0..1]
LEFT OUTER JOIN I_AccrEngineAccrSubobjRawItem AS _SubobjAccrItem ON AccrualEngineAccrualObjectType = _SubobjAccrItem.AccrualEngineAccrualObjectType AND AccrualObjectLogicalSystem = _SubobjAccrItem.AccrualObjectLogicalSystem AND CompanyCode = _SubobjAccrItem.CompanyCode AND AccrualObject = _SubobjAccrItem.AccrualObject AND AccrualSubobject = _SubobjAccrItem.AccrualSubobject AND AccrualItemType = _SubobjAccrItem.AccrualItemType AND Ledger = _SubobjAccrItem.Ledger  -- association [0..*]
LEFT OUTER JOIN I_MnlAccrsAccrualSubobject AS _MnlAccrsAccrualSubobject ON AccrualEngineAccrualObjectType = _MnlAccrsAccrualSubobject.AccrualEngineAccrualObjectType AND AccrualObjectLogicalSystem = _MnlAccrsAccrualSubobject.AccrualObjectLogicalSystem AND CompanyCode = _MnlAccrsAccrualSubobject.CompanyCode AND AccrualObject = _MnlAccrsAccrualSubobject.AccrualObject AND AccrualSubobject = _MnlAccrsAccrualSubobject.AccrualSubobject  -- association [0..1]
LEFT OUTER JOIN I_AccrEngnReferenceSemanticKey AS _ReferenceSemanticKey ON AccrualEngineAccrualObjectType = _ReferenceSemanticKey.AccrualEngineAccrualObjectType AND AccrualObjectLogicalSystem = _ReferenceSemanticKey.AccrualObjectLogicalSystem AND CompanyCode = _ReferenceSemanticKey.CompanyCode AND AccrualObject = _ReferenceSemanticKey.AccrualObject AND AccrualSubobject = _ReferenceSemanticKey.AccrualSubobject AND AccrualReferenceObject = _ReferenceSemanticKey.AccrualEngineReferenceObject  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrder AS _PurchaseOrder ON purchaseorder = _PurchaseOrder.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderItem AS _PurchaseOrderItem ON purchaseorder = _PurchaseOrderItem.PurchaseOrder AND purchaseorderitem = _PurchaseOrderItem.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN I_PurOrdAccountAssignment AS _PurOrdAccountAssignment ON purchaseorder = _PurOrdAccountAssignment.PurchaseOrder AND purchaseorderitem = _PurOrdAccountAssignment.PurchaseOrderItem AND accountassignmentnumber = _PurOrdAccountAssignment.AccountAssignmentNumber  -- association [0..1]
LEFT OUTER JOIN I_ServiceEntrySheetBasic AS _ServiceEntrySheet ON serviceentrysheet = _ServiceEntrySheet.ServiceEntrySheet  -- association [0..1]
LEFT OUTER JOIN I_ServiceEntrySheetItemBasic AS _ServiceEntrySheetItem ON serviceentrysheet = _ServiceEntrySheetItem.ServiceEntrySheet AND serviceentrysheetitem = _ServiceEntrySheetItem.ServiceEntrySheetItem  -- association [0..1]
LEFT OUTER JOIN I_SrvEntrySheetAcctAssgmtBasic AS _SESAccountAssgmt ON serviceentrysheet = _SESAccountAssgmt.ServiceEntrySheet AND serviceentrysheetitem = _SESAccountAssgmt.ServiceEntrySheetItem AND SrvcEntrShtItmAcctAssgmtNumber = _SESAccountAssgmt.AccountAssignment  -- association [0..1]
LEFT OUTER JOIN I_AccrObjResponsiblePerson AS _AccrObjPersonResponsibleName ON AccrObjPersonResponsibleName = _AccrObjPersonResponsibleName.UserID  -- association [0..1]
;