I_FinancialPlanningEntryItem

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_FinancialPlanningEntryItem.
-- 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_FinancialPlanningEntryItem AS
SELECT
  reqtsn AS FinancialPlanningReqTransSqnc,
  datapakid AS FinancialPlanningDataPacket,
  record AS FinancialPlanningEntryItem,
  kokrs AS ControllingArea,
  rbukrs AS CompanyCode,
  rldnr AS Ledger,
  racct AS GLAccount,
  ktopl AS ChartOfAccounts,
  gjahr AS FiscalYear,
  ryear AS LedgerFiscalYear,
  bttype AS BusinessTransactionCategory,
  cast(bttype as fins_custbttype preserving type ) AS BusinessTransactionType,
  rmvct AS FinancialTransactionType,
  usnam AS FinPlngEntryItemCreatedByUser,
  cast(cast(substring(reqtsn,1,14) as abap.numc( 14 )) as fis_plan_item_creation_tstmp) AS FinPlngEntryItemCrtnDateTime,
  rbusa AS BusinessArea,
  prctr AS ProfitCenter,
  rcntr AS CostCenter,
  cast(ps_pspid as fis_project preserving type ) AS Project,
  ps_prj_pnr AS ProjectInternalID,
  pps_prj_pnr AS PartnerProjectInternalID,
  ps_posid AS WBSElement,
  ps_psp_pnr AS WBSElementInternalID,
  pps_psp_pnr AS PartnerWBSElementInternalID,
  rfarea AS FunctionalArea,
  Segment,
  lstar AS CostCtrActivityType,
  rsrce AS CostAnalysisResource,
  cast( ps_posid as /cpd/plan_item_id ) AS WorkPackage,
  work_item_id AS WorkItem,
  bemot AS BillableControl,
  psknz AS IsLotSizeIndependent,
  losgr AS CostingLotSize,
  lsunit AS LotSizeUnit,
  cast(pbukrs as fis_partner_company_code preserving type) AS PartnerCompanyCode,
  ukostl AS OriginCostCenter,
  ulstar AS OriginCostCtrActivityType,
  uprctr AS OriginProfitCenter,
  sbusa AS PartnerBusinessArea,
  psegment AS PartnerSegment,
  pprctr AS PartnerProfitCenter,
  scntr AS PartnerCostCenter,
  pps_pspid AS PartnerProject,
  pps_posid AS PartnerWBSElement,
  sfarea AS PartnerFunctionalArea,
  plstar AS PartnerCostCtrActivityType,
  aufnr AS OrderID,
  cast(paufnr as fis_par_aufnr_depre preserving type ) AS PartnerOrder,
  cast(paufnr as fis_par_aufnr preserving type ) AS PartnerOrder_2,
  rassc AS PartnerCompany,
  awtyp AS ReferenceDocumentType,
  aworg AS ReferenceDocumentContext,
  awref AS ReferenceDocument,
  rwcur AS TransactionCurrency,
  wsl AS AmountInTransactionCurrency,
  rhcur AS CompanyCodeCurrency,
  hsl AS AmountInCompanyCodeCurrency,
  rkcur AS GlobalCurrency,
  ksl AS AmountInGlobalCurrency,
  rfccur AS FunctionalCurrency,
  fcsl AS AmountInFunctionalCurrency,
  rocur AS FreeDefinedCurrency1,
  osl AS AmountInFreeDefinedCurrency1,
  rvcur AS FreeDefinedCurrency2,
  vsl AS AmountInFreeDefinedCurrency2,
  rbcur AS FreeDefinedCurrency3,
  bsl AS AmountInFreeDefinedCurrency3,
  rccur AS FreeDefinedCurrency4,
  csl AS AmountInFreeDefinedCurrency4,
  rdcur AS FreeDefinedCurrency5,
  dsl AS AmountInFreeDefinedCurrency5,
  recur AS FreeDefinedCurrency6,
  esl AS AmountInFreeDefinedCurrency6,
  rfcur AS FreeDefinedCurrency7,
  fsl AS AmountInFreeDefinedCurrency7,
  rgcur AS FreeDefinedCurrency8,
  gsl AS AmountInFreeDefinedCurrency8,
  rco_ocur AS ControllingObjectCurrency,
  co_osl AS AmountInObjectCurrency,
  kfsl AS FixedAmountInGlobalCrcy,
  hfsl AS FixedAmountInCoCodeCrcy,
  wfsl AS FixedAmountInTransCrcy,
  rvunit AS CostSourceUnit,
  vmsl AS ValuationQuantity,
  vmfsl AS ValuationFixedQuantity,
  rrunit AS ReferenceQuantityUnit,
  rmsl AS ReferenceQuantity,
  periv AS FiscalYearVariant,
  poper AS FiscalPeriod,
  fiscyearper AS FiscalYearPeriod,
  cast( budat as fis_budat preserving type ) AS PostingDate,
  zuonr AS AssignmentReference,
  slalittype AS SubLedgerAcctLineItemType,
  kdauf AS SalesOrder,
  kdpos AS SalesOrderItem,
  cast(kdauf as vbeln_va preserving type) AS SalesDocument,
  cast(kdpos as posnr_va preserving type) AS SalesDocumentItem,
  werks AS Plant,
  matnr AS Material,
  cast (matnr as productnumber preserving type ) AS Product,
  kunnr AS Customer,
  sgtxt AS DocumentItemText,
  cast( objnr as fis_objnr preserving type) AS ControllingObject,
  category AS PlanningCategory,
  accasty AS AccountAssignmentType,
  paccasty AS PartnerAccountAssignmentType,
  co_belkz AS ControllingDebitCreditCode,
  pernr AS PersonnelNumber,
  service_doc_type AS ServiceDocumentType,
  service_doc_id AS ServiceDocument,
  service_doc_item_id AS ServiceDocumentItem,
  service_contract_type AS ServiceContractType,
  service_contract_id AS ServiceContract,
  service_contract_item_id AS ServiceContractItem,
  nplnr AS ProjectNetwork,
  gkont AS OffsettingAccount,
  cast( gkoar as fis_gkoar preserving type ) AS OffsettingAccountType,
  aufnr_org AS OriginOrder,
  fkart AS BillingDocumentType,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  spart AS Division,
  cast( spart as fis_spart preserving type ) AS OrganizationDivision,
  cast(matnr_copa as fis_sold_material preserving type ) AS SoldMaterial,
  cast (matnr_copa as fins_matnr_pa preserving type) AS SoldProduct,
  matkl AS MaterialGroup,
  cast (matkl as productgroup preserving type) AS SoldProductGroup,
  matkl_mm AS ProductGroup,
  kdgrp AS CustomerGroup,
  land1 AS CustomerSupplierCountry,
  cast(brsch as fis_brsch preserving type ) AS CustomerSupplierIndustry,
  bzirk AS SalesDistrict,
  kunre AS BillToParty,
  kunwe AS ShipToParty,
  cast(konzs as fis_konzs preserving type ) AS CustomerSupplierCorporateGroup,
  fikrs AS FinancialManagementArea,
  rfund AS Fund,
  rgrant_nbr AS GrantID,
  rbudget_pd AS BudgetPeriod,
  rsponsored_prog AS SponsoredProgram,
  rsponsored_class AS SponsoredClass,
  rbdgt_vldty_nbr AS GteeMBudgetValidityNumber,
  budget_process AS BudgetProcess,
  budget_subcategory AS BudgetingType,
  bdgt_doc_workflow_status AS BudgetDocWorkFlowStatus,
  arbid AS WorkCenterInternalID,
  vornr AS OrderOperation,
  aufps AS OrderItem,
  paufps AS PartnerOrderItem,
  uvorn AS OrderSuboperation,
  equnr AS Equipment,
  tplnr AS FunctionalLocation,
  istru AS Assembly,
  cast(ilart as rsh_eam_maint_activity_type preserving type ) AS MaintenanceActivityType,
  plknz AS MaintenanceOrderPlanningCode,
  artpr AS MaintPriorityType,
  priok AS MaintPriority,
  maufnr AS SuperiorOrder,
  vornr_org AS OriginOrderOperation,
  afabe AS AssetDepreciationArea,
  anln1 AS MasterFixedAsset,
  anln2 AS FixedAsset,
  movcat AS AssetAcctTransClassfctn,
  anlkl AS AssetClass,
  vname AS JointVenture,
  cast( egrup as jv_egroup_cds preserving type ) AS JointVentureEquityGroup,
  cast( recid as jv_recind_cds preserving type ) AS JointVentureCostRecoveryCode,
  cast( prodper as jv_prodper_cds preserving type ) AS JointVentureProductionDate,
  rsnum AS Reservation,
  rspos AS ReservationItem,
  rsart AS ReservationType,
  packno AS MMServicePackage,
  introw AS MMServicePackageLine,
  SWENR AS REBusinessEntity,
  SGENR AS RealEstateBuilding,
  SGRNR AS RealEstateProperty,
  SMENR AS RERentalObject,
  RECNNR AS RealEstateContract,
  snksl AS REServiceChargeKey,
  sempsl AS RESettlementUnitID,
  dabrz AS SettlementReferenceDate,
  pmatnr AS ProducedProduct,
  costg_from_date AS CostEstimateValidityStartDate,
  costg_to_date AS CostEstimateValidityEndDate,
  hkgrp AS CostOriginGroup,
  acrobjtype AS AccrualObjectType,
  acrlogsys AS AccrualObjectLogicalSystem,
  acrobj_id AS AccrualObject,
  acrsobj_id AS AccrualSubobject,
  acritmtype AS AccrualItemType,
  acrrefobj_id AS AccrualReferenceObject,
  acrvaldat AS AccrualValueDate,
  kprice AS PlanPriceInGlobalCurrency,
  hprice AS PlanPriceInCompanyCodeCurrency,
  wprice AS PlanPriceInTransactionCurrency,
  cast( '' as brgru) AS GLAccountAuthorizationGroup,
  cast( '' as brgru) AS CustomerBasicAuthorizationGrp,
  cast( '' as aufart) AS OrderType,
  cast( '' as auart) AS SalesOrderType
FROM P_ACDOCP_COM
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _LedgerFiscalYear ON LedgerFiscalYear = _LedgerFiscalYear.FiscalYear AND CompanyCode = _LedgerFiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearPeriodForCmpnyCode AS _FiscalPeriod ON FiscalYear = _FiscalPeriod.FiscalYear AND FiscalPeriod = _FiscalPeriod.FiscalPeriod AND CompanyCode = _FiscalPeriod.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalCalYearPeriodForCoCode AS _FiscalYearPeriod ON FiscalYearPeriod = _FiscalYearPeriod.FiscalYearPeriod AND CompanyCode = _FiscalYearPeriod.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForVariant AS _FiscalYearForVariant ON FiscalYear = _FiscalYearForVariant.FiscalYear AND FiscalYearVariant = _FiscalYearForVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForVariant AS _LedgerFiscalYearForVariant ON LedgerFiscalYear = _LedgerFiscalYearForVariant.FiscalYear AND FiscalYearVariant = _LedgerFiscalYearForVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _FiscalPeriodForVariant ON LedgerFiscalYear = _FiscalPeriodForVariant.FiscalYear AND FiscalPeriod = _FiscalPeriodForVariant.FiscalPeriod AND FiscalYearVariant = _FiscalPeriodForVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearPeriodForVariant AS _FiscalYearPeriodForVariant ON FiscalYearPeriod = _FiscalYearPeriodForVariant.FiscalYearPeriod AND FiscalYearVariant = _FiscalYearPeriodForVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [1..1]
LEFT OUTER JOIN I_CalendarDate AS _CalendarDate ON PostingDate = _CalendarDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_FiscalCalendarDate AS _FiscalCalendarDate ON PostingDate = _FiscalCalendarDate.CalendarDate AND FiscalYearVariant = _FiscalCalendarDate.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_BusinessTransactionCategory AS _BusinessTransactionCategory ON BusinessTransactionCategory = _BusinessTransactionCategory.BusinessTransactionCategory  -- association [0..1]
LEFT OUTER JOIN I_BusinessTransactionType AS _BusinessTransactionType ON BusinessTransactionType = _BusinessTransactionType.BusinessTransactionType  -- association [0..1]
LEFT OUTER JOIN I_FinancialTransactionType AS _FinancialTransactionType ON FinancialTransactionType = _FinancialTransactionType.FinancialTransactionType  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _GlobalCurrency ON GlobalCurrency = _GlobalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FunctionalCurrency ON FunctionalCurrency = _FunctionalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency1 ON FreeDefinedCurrency1 = _FreeDefinedCurrency1.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency2 ON FreeDefinedCurrency2 = _FreeDefinedCurrency2.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency3 ON FreeDefinedCurrency3 = _FreeDefinedCurrency3.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency4 ON FreeDefinedCurrency4 = _FreeDefinedCurrency4.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency5 ON FreeDefinedCurrency5 = _FreeDefinedCurrency5.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency6 ON FreeDefinedCurrency6 = _FreeDefinedCurrency6.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency7 ON FreeDefinedCurrency7 = _FreeDefinedCurrency7.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency8 ON FreeDefinedCurrency8 = _FreeDefinedCurrency8.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ControllingObjectCurrency ON ControllingObjectCurrency = _ControllingObjectCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CostSourceUnit ON CostSourceUnit = _CostSourceUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ReferenceQuantityUnit ON ReferenceQuantityUnit = _ReferenceQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _Segment ON Segment = _Segment.Segment  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _CurrentProfitCenter ON ControllingArea = _CurrentProfitCenter.ControllingArea AND ProfitCenter = _CurrentProfitCenter.ProfitCenter AND _CurrentProfitCenter.ValidityStartDate <= $session.system_date AND _CurrentProfitCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenter AS _CurrentCostCenter ON ControllingArea = _CurrentCostCenter.ControllingArea AND CostCenter = _CurrentCostCenter.CostCenter AND _CurrentCostCenter.ValidityStartDate <= $session.system_date AND _CurrentCostCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_CostCenterActivityType AS _CostCtrActivityType ON ControllingArea = _CostCtrActivityType.ControllingArea AND CostCtrActivityType = _CostCtrActivityType.CostCtrActivityType  -- association [0..*]
LEFT OUTER JOIN I_WBSElement AS _WBSElement ON WBSElement = _WBSElement.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElementByInternalKey ON WBSElementInternalID = _WBSElementByInternalKey.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _PartnerWBSElementBasicData ON PartnerWBSElementInternalID = _PartnerWBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_Project AS _Project ON Project = _Project.Project  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _ProjectBasicData ON ProjectInternalID = _ProjectBasicData.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _PartnerProjectBasicData ON PartnerProjectInternalID = _PartnerProjectBasicData.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInChartOfAccounts.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccountInCompanyCode ON CompanyCode = _GLAccountInCompanyCode.CompanyCode AND GLAccount = _GLAccountInCompanyCode.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_CustomerCompany AS _CustomerCompany ON Customer = _CustomerCompany.Customer AND CompanyCode = _CustomerCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CustomerGroup AS _CustomerGroup ON CustomerGroup = _CustomerGroup.CustomerGroup  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup AS _SoldProductGroup ON SoldProductGroup = _SoldProductGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup_2 AS _SoldProductGroup_2 ON SoldProductGroup = _SoldProductGroup_2.ProductGroup  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup AS _ProductGroup ON ProductGroup = _ProductGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup_2 AS _ProductGroup_2 ON ProductGroup = _ProductGroup_2.ProductGroup  -- association [0..1]
LEFT OUTER JOIN I_Material AS _SoldMaterial ON SoldMaterial = _SoldMaterial.Material  -- association [0..1]
LEFT OUTER JOIN I_Product AS _SoldProduct ON SoldProduct = _SoldProduct.Product  -- association [0..1]
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON SalesOrder = _SalesOrderItem.SalesOrder AND SalesOrderItem = _SalesOrderItem.SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON SalesDocument = _SalesDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesDocumentItem ON SalesDocument = _SalesDocumentItem.SalesDocument AND SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _InternalOrder ON OrderID = _InternalOrder.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_Order AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_CostAnalysisResource AS _CostAnalysisResource ON ControllingArea = _CostAnalysisResource.ControllingArea AND CostAnalysisResource = _CostAnalysisResource.CostAnalysisResource  -- association [0..*]
LEFT OUTER JOIN I_WorkPackageWorkItem AS _WorkPackageWorkItem ON WorkItem = _WorkPackageWorkItem.WorkItem AND WorkPackage = _WorkPackageWorkItem.WorkPackage  -- association [0..1]
LEFT OUTER JOIN I_WorkPackage AS _WorkPackage ON WorkPackage = _WorkPackage.WorkPackage  -- association [0..1]
LEFT OUTER JOIN I_Employment AS _Employment ON PersonnelNumber = _Employment.EmploymentInternalID  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonWorkAgreement_1 ON PersonnelNumber = _PersonWorkAgreement_1.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _PartnerCostCenter ON ControllingArea = _PartnerCostCenter.ControllingArea AND PartnerCostCenter = _PartnerCostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _PartnerProfitCenter ON ControllingArea = _PartnerProfitCenter.ControllingArea AND PartnerProfitCenter = _PartnerProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_BusinessArea AS _PartnerBusinessArea ON PartnerBusinessArea = _PartnerBusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _PartnerFunctionalArea ON PartnerFunctionalArea = _PartnerFunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _PartnerCompanyCode ON PartnerCompanyCode = _PartnerCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _PartnerSegment ON PartnerSegment = _PartnerSegment.Segment  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _User ON FinPlngEntryItemCreatedByUser = _User.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_CostCenterActivityType AS _PartnerCostCtrActivityType ON ControllingArea = _PartnerCostCtrActivityType.ControllingArea AND PartnerCostCtrActivityType = _PartnerCostCtrActivityType.CostCtrActivityType  -- association [0..*]
LEFT OUTER JOIN I_InternalOrder AS _PartnerOrder ON PartnerOrder = _PartnerOrder.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_Order AS _PartnerOrder_2 ON PartnerOrder_2 = _PartnerOrder_2.OrderID  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _PartnerWBSElement ON PartnerWBSElement = _PartnerWBSElement.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_Project AS _PartnerProject ON PartnerProject = _PartnerProject.Project  -- association [0..1]
LEFT OUTER JOIN I_Partnercompany AS _PartnerCompany ON PartnerCompany = _PartnerCompany.PartnerCompany  -- association [0..1]
LEFT OUTER JOIN I_ControllingDebitCreditCode AS _ControllingDebitCreditCode ON ControllingDebitCreditCode = _ControllingDebitCreditCode.ControllingDebitCreditCode  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_BillingDocumentType AS _BillingDocumentType ON BillingDocumentType = _BillingDocumentType.BillingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_Division AS _OrganizationDivision ON OrganizationDivision = _OrganizationDivision.Division  -- association [0..1]
LEFT OUTER JOIN I_Country AS _CustomerSupplierCountry ON CustomerSupplierCountry = _CustomerSupplierCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_SalesDistrict AS _SalesDistrict ON SalesDistrict = _SalesDistrict.SalesDistrict  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _BillToParty ON BillToParty = _BillToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _ShipToParty ON ShipToParty = _ShipToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_CustomerSupplierIndustryText AS _CustomerSupplierIndustryText ON CustomerSupplierIndustry = _CustomerSupplierIndustryText.Industry  -- association [0..*]
LEFT OUTER JOIN I_PlanningCategory AS _PlanningCategory ON PlanningCategory = _PlanningCategory.PlanningCategory  -- 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]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON WorkCenterInternalID = _WorkCenter.WorkCenterInternalID AND _WorkCenter.WorkCenterTypeCode = 'A'  -- association [0..1]
LEFT OUTER JOIN I_BillableControl AS _BillableControl ON BillableControl = _BillableControl.BillableControl  -- association [0..1]
LEFT OUTER JOIN I_SemTagGLAccount AS _SemTagGLAccount ON GLAccount = _SemTagGLAccount.GLAccount AND ChartOfAccounts = _SemTagGLAccount.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinancialManagementArea ON FinancialManagementArea = _FinancialManagementArea.FinancialManagementArea  -- association [0..1]
LEFT OUTER JOIN I_Fund AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND Fund = _Fund.Fund  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _Grant ON GrantID = _Grant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriod AS _BudgetPeriod ON BudgetPeriod = _BudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_BudgetProcess AS _BudgetProcess ON BudgetProcess = _BudgetProcess.BudgetProcess  -- association [0..1]
LEFT OUTER JOIN I_BudgetingType AS _BudgetingType ON BudgetingType = _BudgetingType.BudgetingType  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_SubLedgerAccLineItemType AS _SubLedgerAccLineItemType ON SubLedgerAcctLineItemType = _SubLedgerAccLineItemType.SubLedgerAcctLineItemType  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _Equipment ON Equipment = _Equipment.Equipment  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocation AS _FunctionalLocation ON FunctionalLocation = _FunctionalLocation.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Assembly ON Assembly = _Assembly.Product  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceActivityType AS _MaintenanceActivityType ON MaintenanceActivityType = _MaintenanceActivityType.MaintenanceActivityType  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _LotSizeUnit ON LotSizeUnit = _LotSizeUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _OriginCostCenter ON ControllingArea = _OriginCostCenter.ControllingArea AND OriginCostCenter = _OriginCostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenterActivityType AS _OriginCostCtrActivityType ON ControllingArea = _OriginCostCtrActivityType.ControllingArea AND OriginCostCtrActivityType = _OriginCostCtrActivityType.CostCtrActivityType  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _OriginProfitCenter ON ControllingArea = _OriginProfitCenter.ControllingArea AND OriginProfitCenter = _OriginProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_Product AS _ProducedProduct ON ProducedProduct = _ProducedProduct.Product  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentType AS _ServiceDocumentType ON ServiceDocumentType = _ServiceDocumentType.ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocByDocumentType AS _ServiceDocument ON ServiceDocumentType = _ServiceDocument.ServiceDocumentType AND ServiceDocument = _ServiceDocument.ServiceDocument  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocItemByDocumentType AS _ServiceDocumentItem ON ServiceDocumentType = _ServiceDocumentItem.ServiceDocumentType AND ServiceDocument = _ServiceDocumentItem.ServiceDocument AND ServiceDocumentItem = _ServiceDocumentItem.ServiceDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentType AS _ServiceContractType ON ServiceContractType = _ServiceContractType.ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocByDocumentType AS _ServiceContract ON ServiceContractType = _ServiceContract.ServiceDocumentType AND ServiceContract = _ServiceContract.ServiceDocument  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocItemByDocumentType AS _ServiceContractItem ON ServiceContractType = _ServiceContractItem.ServiceDocumentType AND ServiceContract = _ServiceContractItem.ServiceDocument AND ServiceContractItem = _ServiceContractItem.ServiceDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_SponsoredClassCore AS _SponsoredClass ON SponsoredClass = _SponsoredClass.SponsoredClass  -- association [0..1]
LEFT OUTER JOIN I_SponsoredProgramCore AS _SponsoredProgram ON SponsoredProgram = _SponsoredProgram.SponsoredProgram  -- association [0..1]
LEFT OUTER JOIN I_AccountAssignmentType AS _AccountAssignmentType ON AccountAssignmentType = _AccountAssignmentType.AccountAssignmentType  -- association [0..1]
;