I_CnsldtnPlanRptdFinData

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_CnsldtnPlanRptdFinData.
-- 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_CreationDateTimeRgFr : timestamp, P_CreationDateTimeRgTo : timestamp

CREATE VIEW I_CnsldtnPlanRptdFinData AS
SELECT
  _Source.ConsolidationRecordNumber AS ConsolidationRecordNumber,
  _Source.ReferenceDocumentNumber AS ReferenceDocumentNumber,
  _Source.SubItemCategory AS SubItemCategory,
  _Source.SubItem AS SubItem,
  cast( _Source.PartnerConsolidationUnit as fincs_partnerconsolidationunit preserving type ) AS PartnerConsolidationUnit,
  _Source.FinancialStatementItem AS FinancialStatementItem,
  _Source.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  _Source.ConsolidationDimension AS ConsolidationDimension,
  cast( _Source.ConsolidationUnit as fincs_consolidationunit preserving type ) AS ConsolidationUnit,
  _Source.ConsolidationVersion AS ConsolidationVersion,
  _Source.ConsolidationLedger AS ConsolidationLedger,
  _Source.FiscalPeriod AS FiscalPeriod,
  _Source.FiscalYear AS FiscalYear,
  _Source.QuantityInBaseUnit AS QuantityInBaseUnit,
  _Source.BaseUnit AS BaseUnit,
  _Source.AmountInLocalCurrency AS AmountInLocalCurrency,
  _Source.LocalCurrency AS LocalCurrency,
  _Source.AmountInGroupCurrency AS AmountInGroupCurrency,
  _Source.GroupCurrency AS GroupCurrency,
  _Source.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  _Source.TransactionCurrency AS TransactionCurrency,
  _Source.FinancialTransactionType AS FinancialTransactionType,
  _Source.FunctionalArea AS FunctionalArea,
  _Source.BusinessArea AS BusinessArea,
  _Source.CostCenter AS CostCenter,
  _Source.GLAccount AS GLAccount,
  _Source.ProfitCenter AS ProfitCenter,
  _Source.Segment AS Segment,
  _Source.CompanyCode AS CompanyCode,
  _Source.ChartOfAccounts AS ChartOfAccounts,
  _Source.AssignmentReference AS AssignmentReference,
  _Source.ControllingArea AS ControllingArea,
  _Source.PartnerCostCenter AS PartnerCostCenter,
  _Source.PartnerProfitCenter AS PartnerProfitCenter,
  _Source.PartnerFunctionalArea AS PartnerFunctionalArea,
  _Source.PartnerBusinessArea AS PartnerBusinessArea,
  _Source.PartnerCompany AS PartnerCompany,
  _Source.PartnerSegment AS PartnerSegment,
  _Source.OrderID AS OrderID,
  _Source.Customer AS Customer,
  _Source.Supplier AS Supplier,
  _Source.Material AS Material,
  _Source.MaterialGroup AS MaterialGroup,
  _Source.ProductGroup AS ProductGroup,
  _Source.Plant AS Plant,
  _Source.WBSElementExternalID AS WBSElementExternalID,
  _Source.Project AS Project,
  _Source.BillingDocumentType AS BillingDocumentType,
  _Source.SalesOrganization AS SalesOrganization,
  _Source.DistributionChannel AS DistributionChannel,
  _Source.OrganizationDivision AS OrganizationDivision,
  _Source.SoldProduct AS SoldProduct,
  _Source.SoldProductGroup AS SoldProductGroup,
  _Source.CustomerGroup AS CustomerGroup,
  _Source.CustomerSupplierCountry AS CustomerSupplierCountry,
  _Source.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  _Source.SalesDistrict AS SalesDistrict,
  _Source.BillToParty AS BillToParty,
  _Source.ShipToParty AS ShipToParty,
  _Source.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  _Source.WBSElementInternalID AS WBSElementInternalID,
  _Source.CreationDateTime AS CreationDateTime,
  cast( '' as fis_ffs_product_group ) AS FinancialServicesProductGroup,
  cast( '' as fis_ffs_branch_id ) AS FinancialServicesBranch,
  cast( '' as fis_ffs_datasource_id ) AS FinancialDataSource,
  _Source.FinancialManagementArea AS FinancialManagementArea,
  _Source.GrantID AS GrantID,
  _Source.Fund AS Fund,
  cast( '' as bp_p_geber ) AS PartnerFund,
  cast( '' as fis_re_account ) AS CashLedgerAccount,
  cast( '' as ktopl ) AS CnsldtnCashLedgerChartOfAccts,
  _Source.FinancialPlanningReqTransSqnc AS FinancialPlanningReqTransSqnc,
  _Source.FinancialPlanningDataPacket AS FinancialPlanningDataPacket,
  _Source.FinancialPlanningEntryItem AS FinancialPlanningEntryItem
FROM P_PLANDATA_NRL
LEFT OUTER JOIN E_FinancialPlanningEntryItem AS _Extension ON _Source.FinancialPlanningReqTransSqnc = _Extension.FinancialPlanningReqTransSqnc AND _Source.FinancialPlanningDataPacket = _Extension.FinancialPlanningDataPacket AND _Source.FinancialPlanningEntryItem = _Extension.FinancialPlanningEntryItem  -- association [1..1]
;