I_FinPlanningEntryItemCube

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_FinPlanningEntryItemCube.
-- 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.

CREATE VIEW I_FinPlanningEntryItemCube AS
SELECT
  I_FinancialPlanningEntryItem.FinancialPlanningDataPacket AS FinancialPlanningDataPacket,
  I_FinancialPlanningEntryItem.FinancialPlanningEntryItem AS FinancialPlanningEntryItem,
  I_FinancialPlanningEntryItem.FinancialPlanningReqTransSqnc AS FinancialPlanningReqTransSqnc,
  I_FinancialPlanningEntryItem.AccountAssignmentType AS AccountAssignmentType,
  I_FinancialPlanningEntryItem.BillToParty AS BillToParty,
  cast( I_FinancialPlanningEntryItem._BillToParty.CustomerName as bill_to_name preserving type) AS BillToPartyName,
  I_FinancialPlanningEntryItem.BillingDocumentType AS BillingDocumentType,
  I_FinancialPlanningEntryItem.BudgetingType AS BudgetingType,
  I_FinancialPlanningEntryItem.BudgetPeriod AS BudgetPeriod,
  I_FinancialPlanningEntryItem.BudgetProcess AS BudgetProcess,
  I_FinancialPlanningEntryItem.BudgetDocWorkFlowStatus AS BudgetDocWorkFlowStatus,
  I_FinancialPlanningEntryItem.BusinessArea AS BusinessArea,
  cast( _BusinessArea._Text[1: Language = $session.system_language].BusinessAreaName as fis_busarea_name preserving type ) AS BusinessAreaName,
  I_FinancialPlanningEntryItem.BusinessTransactionCategory AS BusinessTransactionCategory,
  I_FinancialPlanningEntryItem.BusinessTransactionType AS BusinessTransactionType,
  I_FinancialPlanningEntryItem.ChartOfAccounts AS ChartOfAccounts,
  I_FinancialPlanningEntryItem.CompanyCode AS CompanyCode,
  cast( I_FinancialPlanningEntryItem._CompanyCode.CompanyCodeName as fis_butxt preserving type ) AS CompanyCodeName,
  I_FinancialPlanningEntryItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_FinancialPlanningEntryItem.ControllingArea AS ControllingArea,
  cast( I_FinancialPlanningEntryItem._ControllingArea.ControllingAreaName as fis_bezei preserving type ) AS ControllingAreaName,
  cast( I_FinancialPlanningEntryItem.ControllingDebitCreditCode as fis_co_belkz_no_conv preserving type ) AS ControllingDebitCreditCode,
  I_FinancialPlanningEntryItem.CostAnalysisResource AS CostAnalysisResource,
  I_FinancialPlanningEntryItem.CostCenter AS CostCenter,
  _CostCenter[1:ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date]._Text[1: Language = $session.system_language].CostCenterName AS CostCenterName,
  I_FinancialPlanningEntryItem.CostCtrActivityType AS CostCtrActivityType,
  cast( _CostCtrActivityType[1:ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date]._Text[1: Language = $session.system_language].CostCtrActivityTypeName as fis_lstar_text ) AS CostCtrActivityTypeName,
  I_FinancialPlanningEntryItem.CostSourceUnit AS CostSourceUnit,
  I_FinancialPlanningEntryItem.Customer AS Customer,
  I_FinancialPlanningEntryItem._Customer.CustomerName AS CustomerName,
  I_FinancialPlanningEntryItem.CustomerGroup AS CustomerGroup,
  cast( _CustomerGroup._Text[1: Language = $session.system_language].CustomerGroupName as fis_customergroup_name ) AS CustomerGroupName,
  I_FinancialPlanningEntryItem.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  I_FinancialPlanningEntryItem.CustomerSupplierCountry AS CustomerSupplierCountry,
  cast( _CustomerSupplierCountry._Text[1: Language = $session.system_language].CountryName as fis_customersupplier_country ) AS CustomerSupplierCountryName,
  I_FinancialPlanningEntryItem.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  cast( _CustomerSupplierIndustryText[1: Language = $session.system_language].CustomerSupplierIndustryName as fis_customersupplier_industry preserving type ) AS CustomerSupplierIndustryName,
  I_FinancialPlanningEntryItem.DistributionChannel AS DistributionChannel,
  cast( _DistributionChannel._Text[1: Language = $session.system_language].DistributionChannelName as fis_distributionchannel_name preserving type ) AS DistributionChannelName,
  I_FinancialPlanningEntryItem.OrganizationDivision AS OrganizationDivision,
  I_FinancialPlanningEntryItem.Division AS Division,
  cast( _OrganizationDivision._Text[1: Language = $session.system_language].DivisionName as fis_division_name ) AS DivisionName,
  I_FinancialPlanningEntryItem.FinancialTransactionType AS FinancialTransactionType,
  I_FinancialPlanningEntryItem.FinancialManagementArea AS FinancialManagementArea,
  I_FinancialPlanningEntryItem.FiscalPeriod AS FiscalPeriod,
  I_FinancialPlanningEntryItem.FiscalYear AS FiscalYear,
  I_FinancialPlanningEntryItem.FiscalYearPeriod AS FiscalYearPeriod,
  I_FinancialPlanningEntryItem.FiscalYearVariant AS FiscalYearVariant,
  I_FinancialPlanningEntryItem.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  I_FinancialPlanningEntryItem.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  I_FinancialPlanningEntryItem.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  I_FinancialPlanningEntryItem.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  I_FinancialPlanningEntryItem.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  I_FinancialPlanningEntryItem.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  I_FinancialPlanningEntryItem.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  I_FinancialPlanningEntryItem.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  I_FinancialPlanningEntryItem.FunctionalArea AS FunctionalArea,
  I_FinancialPlanningEntryItem.Fund AS Fund,
  cast( _FunctionalArea._Text[1: Language = $session.system_language].FunctionalAreaName as fis_funcarea_name ) AS FunctionalAreaName,
  I_FinancialPlanningEntryItem.GLAccount AS GLAccount,
  cast( _GLAccountInChartOfAccounts._Text[1: Language = $session.system_language].GLAccountName as fis_txt30_skat ) AS GLAccountName,
  cast( _GLAccountInChartOfAccounts._Text[1: Language = $session.system_language].GLAccountLongName as fis_txt50_skat ) AS GLAccountLongName,
  I_FinancialPlanningEntryItem.FunctionalCurrency AS FunctionalCurrency,
  I_FinancialPlanningEntryItem.GlobalCurrency AS GlobalCurrency,
  I_FinancialPlanningEntryItem.GrantID AS GrantID,
  I_FinancialPlanningEntryItem.Ledger AS Ledger,
  _Ledger._Text[1: Language = $session.system_language].LedgerName AS LedgerName,
  I_FinancialPlanningEntryItem.LedgerFiscalYear AS LedgerFiscalYear,
  I_FinancialPlanningEntryItem.Material AS Material,
  _Material._Text[1: Language = $session.system_language].MaterialName AS MaterialName,
  I_FinancialPlanningEntryItem.MaterialGroup AS MaterialGroup,
  _MaterialGroup._Text[1: Language = $session.system_language].MaterialGroupName AS MaterialGroupName,
  I_FinancialPlanningEntryItem.Product AS Product,
  _Product._Text[1: Language = $session.system_language].ProductName AS ProductName,
  I_FinancialPlanningEntryItem.ProductGroup AS ProductGroup,
  _ProductGroup_2._ProductGroupText[1: Language = $session.system_language].ProductGroupName AS ProductGroupName,
  I_FinancialPlanningEntryItem.ControllingObjectCurrency AS ControllingObjectCurrency,
  I_FinancialPlanningEntryItem.OrderID AS OrderID,
  I_FinancialPlanningEntryItem.OrderItem AS OrderItem,
  I_FinancialPlanningEntryItem.PartnerAccountAssignmentType AS PartnerAccountAssignmentType,
  I_FinancialPlanningEntryItem.PartnerBusinessArea AS PartnerBusinessArea,
  cast( _PartnerBusinessArea._Text[1: Language = $session.system_language].BusinessAreaName as fis_partner_busarea_name preserving type ) AS PartnerBusinessAreaName,
  I_FinancialPlanningEntryItem.PartnerCompany AS PartnerCompany,
  cast( _PartnerCompany[1: Language = $session.system_language].CompanyName as fis_rcomp_name preserving type ) AS PartnerCompanyName,
  I_FinancialPlanningEntryItem.PartnerCompanyCode AS PartnerCompanyCode,
  cast( I_FinancialPlanningEntryItem._PartnerCompanyCode.CompanyCodeName as fis_partner_company_code_name preserving type ) AS PartnerCompanyCodeName,
  I_FinancialPlanningEntryItem.PartnerCostCenter AS PartnerCostCenter,
  cast( _PartnerCostCenter[1:ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date]._Text[1: Language = $session.system_language].CostCenterName as fis_partner_kostl_name preserving type) AS PartnerCostCenterName,
  I_FinancialPlanningEntryItem.PartnerCostCtrActivityType AS PartnerCostCtrActivityType,
  cast( _PartnerCostCtrActivityType[1:ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date]._Text[1: Language = $session.system_language].CostCtrActivityTypeName as fis_partner_activity_type_name ) AS PartnerCostCtrActivityTypeName,
  I_FinancialPlanningEntryItem.PartnerFunctionalArea AS PartnerFunctionalArea,
  cast( _PartnerFunctionalArea._Text[1: Language = $session.system_language].FunctionalAreaName as fis_partner_funcarea_name ) AS PartnerFunctionalAreaName,
  I_FinancialPlanningEntryItem.PartnerOrder AS PartnerOrder,
  I_FinancialPlanningEntryItem.PartnerOrder_2 AS PartnerOrder_2,
  I_FinancialPlanningEntryItem.PartnerProfitCenter AS PartnerProfitCenter,
  cast( _PartnerProfitCenter[1:ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date]._Text[1: Language = $session.system_language].ProfitCenterName as fis_partner_prctr_name ) AS PartnerProfitCenterName,
  I_FinancialPlanningEntryItem.PartnerProject AS PartnerProject,
  cast( I_FinancialPlanningEntryItem._PartnerProjectBasicData.ProjectDescription as fis_partner_project_descript preserving type ) AS PartnerProjectDescription,
  I_FinancialPlanningEntryItem.PartnerSegment AS PartnerSegment,
  cast( _PartnerSegment._Text[1: Language = $session.system_language].SegmentName as fis_partner_segment_name preserving type ) AS PartnerSegmentName,
  I_FinancialPlanningEntryItem.PartnerWBSElement AS PartnerWBSElement,
  cast( I_FinancialPlanningEntryItem._PartnerWBSElementBasicData.WBSDescription as fis_partner_wbs_descript preserving type ) AS PartnerWBSElementDescription,
  I_FinancialPlanningEntryItem.PersonnelNumber AS PersonnelNumber,
  IsStatisticalOrder,
  IsStatisticalCostCenter,
  IsStatisticalSalesDocument,
  WBSIsStatisticalWBSElement,
  I_FinancialPlanningEntryItem.PlanningCategory AS PlanningCategory,
  I_FinancialPlanningEntryItem.Plant AS Plant,
  I_FinancialPlanningEntryItem._Plant.PlantName AS PlantName,
  I_FinancialPlanningEntryItem.PostingDate AS PostingDate,
  I_FinancialPlanningEntryItem.ServiceDocumentType AS ServiceDocumentType,
  I_FinancialPlanningEntryItem.ServiceDocument AS ServiceDocument,
  I_FinancialPlanningEntryItem.ServiceDocumentItem AS ServiceDocumentItem,
  I_FinancialPlanningEntryItem.ProfitCenter AS ProfitCenter,
  _ProfitCenter[1:ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date]._Text[1: Language = $session.system_language].ProfitCenterName AS ProfitCenterName,
  I_FinancialPlanningEntryItem.Project AS Project,
  ProjectInternalID,
  cast( I_FinancialPlanningEntryItem._ProjectBasicData.ProjectExternalID as fis_projectext_no_conv preserving type ) AS ProjectExternalID,
  PartnerProjectInternalID,
  I_FinancialPlanningEntryItem._PartnerProjectBasicData.ProjectExternalID AS PartnerProjectExternalID,
  cast( I_FinancialPlanningEntryItem._ProjectBasicData.ProjectDescription as fis_project_description preserving type ) AS ProjectDescription,
  I_FinancialPlanningEntryItem.ReferenceDocument AS ReferenceDocument,
  I_FinancialPlanningEntryItem.ReferenceDocumentContext AS ReferenceDocumentContext,
  I_FinancialPlanningEntryItem.ReferenceDocumentType AS ReferenceDocumentType,
  I_FinancialPlanningEntryItem.SalesDistrict AS SalesDistrict,
  _SalesDistrict._Text[1: Language = $session.system_language].SalesDistrictName AS SalesDistrictName,
  I_FinancialPlanningEntryItem.SalesOrder AS SalesOrder,
  I_FinancialPlanningEntryItem.SalesOrderItem AS SalesOrderItem,
  I_FinancialPlanningEntryItem.SalesDocument AS SalesDocument,
  I_FinancialPlanningEntryItem.SalesDocumentItem AS SalesDocumentItem,
  I_FinancialPlanningEntryItem.SalesOrganization AS SalesOrganization,
  cast( _SalesOrganization._Text[1: Language = $session.system_language].SalesOrganizationName as fis_sales_organization_name preserving type ) AS SalesOrganizationName,
  I_FinancialPlanningEntryItem.Segment AS Segment,
  _Segment._Text[1: Language = $session.system_language].SegmentName AS SegmentName,
  I_FinancialPlanningEntryItem.ShipToParty AS ShipToParty,
  cast( I_FinancialPlanningEntryItem._ShipToParty.CustomerName as ship_to_name preserving type ) AS ShipToPartyName,
  I_FinancialPlanningEntryItem.SoldMaterial AS SoldMaterial,
  cast( _SoldMaterial._Text[1: Language = $session.system_language].MaterialName as fis_matnr_copa_name preserving type ) AS SoldMaterialName,
  I_FinancialPlanningEntryItem.SoldProduct AS SoldProduct,
  cast( _SoldProduct._Text[1: Language = $session.system_language].ProductName as fis_matnr_copa_name preserving type) AS SoldProductName,
  I_FinancialPlanningEntryItem.SoldProductGroup AS SoldProductGroup,
  _SoldProductGroup._Text[1: Language = $session.system_language].MaterialGroupName AS SoldProductGroupName,
  I_FinancialPlanningEntryItem.TransactionCurrency AS TransactionCurrency,
  I_FinancialPlanningEntryItem.WBSElementInternalID AS WBSElementInternalID,
  I_FinancialPlanningEntryItem.WBSElement AS WBSElement,
  cast( I_FinancialPlanningEntryItem._WBSElementBasicData.WBSElementExternalID as fis_wbsext_no_conv preserving type ) AS WBSElementExternalID,
  PartnerWBSElementInternalID,
  I_FinancialPlanningEntryItem._PartnerWBSElementBasicData.WBSElementExternalID AS PartnerWBSElementExternalID,
  I_FinancialPlanningEntryItem._WBSElementBasicData.WBSDescription AS WBSElementDescription,
  I_FinancialPlanningEntryItem.WorkItem AS WorkItem,
  I_FinancialPlanningEntryItem.WorkPackage AS WorkPackage,
  I_FinancialPlanningEntryItem._WorkCenter.WorkCenter AS WorkCenter,
  I_FinancialPlanningEntryItem.WorkCenterInternalID AS WorkCenterInternalID,
  I_FinancialPlanningEntryItem.OrderOperation AS OrderOperation,
  I_FinancialPlanningEntryItem.BillableControl AS BillableControl,
  I_FinancialPlanningEntryItem.IsLotSizeIndependent AS IsLotSizeIndependent,
  SubLedgerAcctLineItemType,
  AssetDepreciationArea,
  MasterFixedAsset,
  FixedAsset,
  AssetAcctTransClassfctn,
  AssetClass,
  I_FinancialPlanningEntryItem._CalendarDate.CalendarYear AS CalendarYear,
  I_FinancialPlanningEntryItem._CalendarDate.CalendarQuarter AS CalendarQuarter,
  I_FinancialPlanningEntryItem._CalendarDate.YearQuarter AS CalendarYearQuarter,
  I_FinancialPlanningEntryItem._CalendarDate.CalendarMonth AS CalendarMonth,
  I_FinancialPlanningEntryItem._CalendarDate.YearMonth AS CalendarYearMonth,
  I_FinancialPlanningEntryItem._CalendarDate.CalendarWeek AS CalendarWeek,
  I_FinancialPlanningEntryItem._CalendarDate.YearWeek AS CalendarYearWeek,
  I_FinancialPlanningEntryItem._FiscalCalendarDate.FiscalQuarter AS FiscalQuarter,
  I_FinancialPlanningEntryItem._FiscalCalendarDate.FiscalWeek AS FiscalWeek,
  I_FinancialPlanningEntryItem._FiscalCalendarDate.FiscalYearQuarter AS FiscalYearQuarter,
  I_FinancialPlanningEntryItem._FiscalCalendarDate.FiscalYearWeek AS FiscalYearWeek,
  I_FinancialPlanningEntryItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  I_FinancialPlanningEntryItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  I_FinancialPlanningEntryItem.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  I_FinancialPlanningEntryItem.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  I_FinancialPlanningEntryItem.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  I_FinancialPlanningEntryItem.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  I_FinancialPlanningEntryItem.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  I_FinancialPlanningEntryItem.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  I_FinancialPlanningEntryItem.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  I_FinancialPlanningEntryItem.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  I_FinancialPlanningEntryItem.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  I_FinancialPlanningEntryItem.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  I_FinancialPlanningEntryItem.AmountInObjectCurrency AS AmountInObjectCurrency,
  I_FinancialPlanningEntryItem.FixedAmountInGlobalCrcy AS FixedAmountInGlobalCrcy,
  I_FinancialPlanningEntryItem.FixedAmountInCoCodeCrcy AS FixedAmountInCoCodeCrcy,
  I_FinancialPlanningEntryItem.FixedAmountInTransCrcy AS FixedAmountInTransCrcy,
  I_FinancialPlanningEntryItem.ValuationQuantity AS ValuationQuantity,
  I_FinancialPlanningEntryItem.ValuationFixedQuantity AS ValuationFixedQuantity,
  I_FinancialPlanningEntryItem.ReferenceQuantityUnit AS ReferenceQuantityUnit,
  I_FinancialPlanningEntryItem.ReferenceQuantity AS ReferenceQuantity,
  SponsoredProgram,
  SponsoredClass,
  GteeMBudgetValidityNumber,
  REBusinessEntity,
  RealEstateBuilding,
  RealEstateProperty,
  RERentalObject,
  RealEstateContract,
  REServiceChargeKey,
  RESettlementUnitID,
  SettlementReferenceDate,
  I_FinancialPlanningEntryItem._BillableControl AS _BillableControl,
  I_FinancialPlanningEntryItem._BillToParty AS _BillToParty,
  I_FinancialPlanningEntryItem._BillingDocumentType AS _BillingDocumentType,
  I_FinancialPlanningEntryItem._BudgetingType AS _BudgetingType,
  I_FinancialPlanningEntryItem._BudgetPeriod AS _BudgetPeriod,
  I_FinancialPlanningEntryItem._BudgetProcess AS _BudgetProcess,
  I_FinancialPlanningEntryItem._BusinessArea AS _BusinessArea,
  I_FinancialPlanningEntryItem._BusinessTransactionType AS _BusinessTransactionType,
  I_FinancialPlanningEntryItem._CalendarDate AS _CalendarDate,
  I_FinancialPlanningEntryItem._ChartOfAccounts AS _ChartOfAccounts,
  I_FinancialPlanningEntryItem._CompanyCode AS _CompanyCode,
  I_FinancialPlanningEntryItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
  I_FinancialPlanningEntryItem._ControllingArea AS _ControllingArea,
  I_FinancialPlanningEntryItem._ControllingDebitCreditCode AS _ControllingDebitCreditCode,
  I_FinancialPlanningEntryItem._CostAnalysisResource AS _CostAnalysisResource,
  I_FinancialPlanningEntryItem._CostCenter AS _CostCenter,
  I_FinancialPlanningEntryItem._ProfitCenter AS _ProfitCenter,
  I_FinancialPlanningEntryItem._CostCtrActivityType AS _CostCtrActivityType,
  I_FinancialPlanningEntryItem._CostSourceUnit AS _CostSourceUnit,
  I_FinancialPlanningEntryItem._AccountAssignmentType AS _AccountAssignmentType,
  I_FinancialPlanningEntryItem._CurrentCostCenter AS _CurrentCostCenter,
  I_FinancialPlanningEntryItem._CurrentProfitCenter AS _CurrentProfitCenter,
  I_FinancialPlanningEntryItem._Customer AS _Customer,
  I_FinancialPlanningEntryItem._CustomerGroup AS _CustomerGroup,
  I_FinancialPlanningEntryItem._CustomerSupplierCountry AS _CustomerSupplierCountry,
  I_FinancialPlanningEntryItem._DistributionChannel AS _DistributionChannel,
  I_FinancialPlanningEntryItem._OrganizationDivision AS _OrganizationDivision,
  I_FinancialPlanningEntryItem._Division AS _Division,
  I_FinancialPlanningEntryItem._Employment AS _Employment,
  I_FinancialPlanningEntryItem._PersonWorkAgreement_1 AS _PersonWorkAgreement_1,
  I_FinancialPlanningEntryItem._FinancialManagementArea AS _FinancialManagementArea,
  I_FinancialPlanningEntryItem._FinancialTransactionType AS _FinancialTransactionType,
  I_FinancialPlanningEntryItem._FiscalCalendarDate AS _FiscalCalendarDate,
  I_FinancialPlanningEntryItem._FiscalPeriodForVariant AS _FiscalPeriodForVariant,
  I_FinancialPlanningEntryItem._FiscalYear AS _FiscalYear,
  I_FinancialPlanningEntryItem._FiscalYearPeriodForVariant AS _FiscalYearPeriodForVariant,
  I_FinancialPlanningEntryItem._FiscalYearVariant AS _FiscalYearVariant,
  I_FinancialPlanningEntryItem._FreeDefinedCurrency1 AS _FreeDefinedCurrency1,
  I_FinancialPlanningEntryItem._FreeDefinedCurrency2 AS _FreeDefinedCurrency2,
  I_FinancialPlanningEntryItem._FreeDefinedCurrency3 AS _FreeDefinedCurrency3,
  I_FinancialPlanningEntryItem._FreeDefinedCurrency4 AS _FreeDefinedCurrency4,
  I_FinancialPlanningEntryItem._FreeDefinedCurrency5 AS _FreeDefinedCurrency5,
  I_FinancialPlanningEntryItem._FreeDefinedCurrency6 AS _FreeDefinedCurrency6,
  I_FinancialPlanningEntryItem._FreeDefinedCurrency7 AS _FreeDefinedCurrency7,
  I_FinancialPlanningEntryItem._FreeDefinedCurrency8 AS _FreeDefinedCurrency8,
  I_FinancialPlanningEntryItem._FunctionalArea AS _FunctionalArea,
  I_FinancialPlanningEntryItem._Fund AS _Fund,
  I_FinancialPlanningEntryItem._Grant AS _Grant,
  I_FinancialPlanningEntryItem._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  I_FinancialPlanningEntryItem._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  I_FinancialPlanningEntryItem._GlobalCurrency AS _GlobalCurrency,
  I_FinancialPlanningEntryItem._FunctionalCurrency AS _FunctionalCurrency,
  I_FinancialPlanningEntryItem._InternalOrder AS _InternalOrder,
  I_FinancialPlanningEntryItem._Ledger AS _Ledger,
  I_FinancialPlanningEntryItem._LedgerFiscalYearForVariant AS _LedgerFiscalYearForVariant,
  I_FinancialPlanningEntryItem._Material AS _Material,
  I_FinancialPlanningEntryItem._MaterialGroup AS _MaterialGroup,
  I_FinancialPlanningEntryItem._SoldProductGroup_2 AS _SoldProductGroup_2,
  I_FinancialPlanningEntryItem._ProductGroup_2 AS _ProductGroup_2,
  I_FinancialPlanningEntryItem._Order AS _Order,
  I_FinancialPlanningEntryItem._PartnerBusinessArea AS _PartnerBusinessArea,
  I_FinancialPlanningEntryItem._PartnerCompany AS _PartnerCompany,
  I_FinancialPlanningEntryItem._PartnerCompanyCode AS _PartnerCompanyCode,
  I_FinancialPlanningEntryItem._PartnerCostCenter AS _PartnerCostCenter,
  I_FinancialPlanningEntryItem._PartnerCostCtrActivityType AS _PartnerCostCtrActivityType,
  I_FinancialPlanningEntryItem._PartnerFunctionalArea AS _PartnerFunctionalArea,
  I_FinancialPlanningEntryItem._PartnerOrder AS _PartnerOrder,
  I_FinancialPlanningEntryItem._PartnerOrder_2 AS _PartnerOrder_2,
  I_FinancialPlanningEntryItem._PartnerProfitCenter AS _PartnerProfitCenter,
  I_FinancialPlanningEntryItem._PartnerProject AS _PartnerProject,
  I_FinancialPlanningEntryItem._PartnerProjectBasicData AS _PartnerProjectBasicData,
  I_FinancialPlanningEntryItem._PartnerSegment AS _PartnerSegment,
  I_FinancialPlanningEntryItem._PartnerWBSElement AS _PartnerWBSElement,
  I_FinancialPlanningEntryItem._PartnerWBSElementBasicData AS _PartnerWBSElementBasicData,
  I_FinancialPlanningEntryItem._PlanningCategory AS _PlanningCategory,
  I_FinancialPlanningEntryItem._Plant AS _Plant,
  I_FinancialPlanningEntryItem._Product AS _Product,
  I_FinancialPlanningEntryItem._ProductGroup AS _ProductGroup,
  I_FinancialPlanningEntryItem._Project AS _Project,
  I_FinancialPlanningEntryItem._ProjectBasicData AS _ProjectBasicData,
  I_FinancialPlanningEntryItem._ReferenceQuantityUnit AS _ReferenceQuantityUnit,
  I_FinancialPlanningEntryItem._SalesDistrict AS _SalesDistrict,
  I_FinancialPlanningEntryItem._SalesOrder AS _SalesOrder,
  I_FinancialPlanningEntryItem._SalesOrderItem AS _SalesOrderItem,
  I_FinancialPlanningEntryItem._SalesDocument AS _SalesDocument,
  I_FinancialPlanningEntryItem._SalesDocumentItem AS _SalesDocumentItem,
  I_FinancialPlanningEntryItem._SalesOrganization AS _SalesOrganization,
  I_FinancialPlanningEntryItem._Segment AS _Segment,
  I_FinancialPlanningEntryItem._ShipToParty AS _ShipToParty,
  I_FinancialPlanningEntryItem._SoldMaterial AS _SoldMaterial,
  I_FinancialPlanningEntryItem._SoldProduct AS _SoldProduct,
  I_FinancialPlanningEntryItem._SoldProductGroup AS _SoldProductGroup,
  I_FinancialPlanningEntryItem._TransactionCurrency AS _TransactionCurrency,
  I_FinancialPlanningEntryItem._WBSElement AS _WBSElement,
  I_FinancialPlanningEntryItem._WBSElementByInternalKey AS _WBSElementByInternalKey,
  I_FinancialPlanningEntryItem._WBSElementBasicData AS _WBSElementBasicData,
  I_FinancialPlanningEntryItem._WorkPackage AS _WorkPackage,
  I_FinancialPlanningEntryItem._WorkPackageWorkItem AS _WorkPackageWorkItem,
  GLAccountAuthorizationGroup,
  CustomerBasicAuthorizationGrp,
  OrderType,
  SalesOrderType
FROM I_FinancialPlanningEntryItem
LEFT OUTER JOIN I_ControllingArea AS _ControllingAreaText ON ControllingArea = _ControllingAreaText.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CalendarMonth AS _CalendarMonth ON CalendarMonth = _CalendarMonth.CalendarMonth  -- association [1..1]
LEFT OUTER JOIN I_CalendarQuarter AS _CalendarQuarter ON CalendarQuarter = _CalendarQuarter.CalendarQuarter  -- association [1..1]
LEFT OUTER JOIN I_YearMonth AS _CalendarYearMonth ON CalendarYearMonth = _CalendarYearMonth.YearMonth  -- association [1..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalID ON WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalIDText ON WBSElementExternalID = _WBSElementExternalIDText.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _PartnerWBSElementExternalID ON PartnerWBSElementExternalID = _PartnerWBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _PartnerWBSElemntExtrnalIDText ON PartnerWBSElementExternalID = _PartnerWBSElemntExtrnalIDText.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _PartnerProjectExternalID ON PartnerProjectExternalID = _PartnerProjectExternalID.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _PartnerProjctExtrnalIDText ON PartnerProjectExternalID = _PartnerProjctExtrnalIDText.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _ProjectExternalID ON ProjectExternalID = _ProjectExternalID.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _ProjectExternalIDText ON ProjectExternalID = _ProjectExternalIDText.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN E_FinancialPlanningEntryItem AS _Extension ON FinancialPlanningReqTransSqnc = _Extension.FinancialPlanningReqTransSqnc AND FinancialPlanningDataPacket = _Extension.FinancialPlanningDataPacket AND FinancialPlanningEntryItem = _Extension.FinancialPlanningEntryItem  -- association [1..1]
;