I_GLAccountLineItemRawData

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_GLAccountLineItemRawData.
-- 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_GLAccountLineItemRawData AS
SELECT
  rldnr AS SourceLedger,
  rbukrs AS CompanyCode,
  gjahr AS FiscalYear,
  belnr AS AccountingDocument,
  docln AS LedgerGLLineItem,
  ryear AS LedgerFiscalYear,
  rrcty AS GLRecordType,
  DOCNR_LD AS JrnlEntrAltvFYConsecutiveID,
  ktopl AS ChartOfAccounts,
  kokrs AS ControllingArea,
  rmvct AS FinancialTransactionType,
  vorgn AS GLBusinessTransactionType,
  bttype AS BusinessTransactionCategory,
  cbttype AS BusinessTransactionType,
  closingstep AS FinancialClosingStep,
  vrgng AS ControllingBusTransacType,
  awtyp AS ReferenceDocumentType,
  awsys AS LogicalSystem,
  aworg AS ReferenceDocumentContext,
  awref AS ReferenceDocument,
  cast( awitem as fis_awitem preserving type ) AS ReferenceDocumentItem,
  cast( awitgrp as fis_awitgrp preserving type ) AS ReferenceDocumentItemGroup,
  subta AS TransactionSubitem,
  ACCTG_NOTIF_UUID AS AccountingNotificationUUID,
  xreversing AS IsReversal,
  xreversed AS IsReversed,
  awtyp_rev AS ReversalReferenceDocumentType,
  cast( aworg_rev as fis_aworg_rev preserving type ) AS ReversalReferenceDocumentCntxt,
  cast( awref_rev as fis_awref_rev preserving type ) AS ReversalReferenceDocument,
  subta_rev AS ReversalTransactionSubitem,
  xsettling AS IsSettlement,
  xsettled AS IsSettled,
  cast( prec_awtyp as fis_prec_awtyp preserving type ) AS PredecessorReferenceDocType,
  cast( prec_aworg as fis_prec_aworg preserving type ) AS PredecessorReferenceDocCntxt,
  cast( prec_awref as fis_prec_awref preserving type ) AS PredecessorReferenceDocument,
  cast( prec_awitem as fis_prec_awitem preserving type ) AS PredecessorReferenceDocItem,
  cast( prec_bukrs as fins_prec_bukrs_gfc preserving type ) AS PrdcssrJournalEntryCompanyCode,
  prec_gjahr AS PrdcssrJournalEntryFiscalYear,
  cast( prec_belnr as fins_prec_belnr_gfc preserving type ) AS PredecessorJournalEntry,
  cast( prec_docln as fins_prec_docln_gfc preserving type ) AS PredecessorJournalEntryItem,
  cast( src_awtyp as fis_src_awtyp preserving type ) AS SourceReferenceDocumentType,
  cast( src_awsys as fis_src_awsys preserving type ) AS SourceLogicalSystem,
  cast( src_aworg as fis_src_aworg preserving type ) AS SourceReferenceDocumentCntxt,
  cast( src_awref as fis_src_awref preserving type ) AS SourceReferenceDocument,
  cast( src_awitem as fis_src_awitem preserving type ) AS SourceReferenceDocumentItem,
  cast( src_awsubit as fis_src_awsubit preserving type ) AS SourceReferenceDocSubitem,
  cast( xcommitment as fis_xcommitment preserving type ) AS IsCommitment,
  obs_reason AS JrnlEntryItemObsoleteReason,
  XSECONDARY AS JournalEntryIsSecondaryEntry,
  closing_run_id AS JrnlPeriodEndClosingRunLogUUID,
  orgl_change AS OrganizationalChange,
  racct AS GLAccount,
  rcntr AS CostCenter,
  prctr AS ProfitCenter,
  rfarea AS FunctionalArea,
  rbusa AS BusinessArea,
  Segment,
  scntr AS PartnerCostCenter,
  pprctr AS PartnerProfitCenter,
  sfarea AS PartnerFunctionalArea,
  sbusa AS PartnerBusinessArea,
  rassc AS PartnerCompany,
  psegment AS PartnerSegment,
  rtcur AS BalanceTransactionCurrency,
  tsl AS AmountInBalanceTransacCrcy,
  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,
  cast( rbcur as fis_curr3 preserving type ) AS FreeDefinedCurrency3,
  bsl AS AmountInFreeDefinedCurrency3,
  cast( rccur as fis_curr4 preserving type ) AS FreeDefinedCurrency4,
  csl AS AmountInFreeDefinedCurrency4,
  cast( rdcur as fis_curr5 preserving type ) AS FreeDefinedCurrency5,
  dsl AS AmountInFreeDefinedCurrency5,
  cast( recur as fis_curr6 preserving type ) AS FreeDefinedCurrency6,
  esl AS AmountInFreeDefinedCurrency6,
  rfcur AS FreeDefinedCurrency7,
  fsl AS AmountInFreeDefinedCurrency7,
  cast( rgcur as fis_curr8 preserving type ) AS FreeDefinedCurrency8,
  gsl AS AmountInFreeDefinedCurrency8,
  kfsl AS FixedAmountInGlobalCrcy,
  cast( kfsl2 as fis_vgcur12_fix2 preserving type ) AS GrpValnFixedAmtInGlobCrcy,
  cast( kfsl3 as fis_vgcur12_fix3 preserving type ) AS PrftCtrValnFxdAmtInGlobCrcy,
  hfsl AS FixedAmountInCoCodeCrcy,
  wfsl AS FixedAmountInTransCrcy,
  psl AS TotalPriceVarcInGlobalCrcy,
  cast( psl2 as fis_vpcur12_2 preserving type ) AS GrpValnTotPrcVarcInGlobCrcy,
  cast( psl3 as fis_vpcur12_3 preserving type ) AS PrftCtrValnTotPrcVarcInGlbCrcy,
  pfsl AS FixedPriceVarcInGlobalCrcy,
  cast( pfsl2 as fis_vpfcur12_2 preserving type ) AS GrpValnFixedPrcVarcInGlobCrcy,
  cast( pfsl3 as fis_vpfcur12_3 preserving type ) AS PrftCtrValnFxdPrcVarcInGlbCrcy,
  rco_ocur AS ControllingObjectCurrency,
  cast( co_osl as fis_vco_ocur12 preserving type ) AS AmountInObjectCurrency,
  rgm_ocur AS GrantCurrency,
  gm_osl AS AmountInGrantCurrency,
  runit AS BaseUnit,
  msl AS Quantity,
  cast( mfsl as fis_quan1_12_fix preserving type ) AS FixedQuantity,
  rvunit AS CostSourceUnit,
  cast( vmsl as fis_vquan1_12 preserving type ) AS ValuationQuantity,
  cast( vmfsl as fis_vquan1_12_fix preserving type ) AS ValuationFixedQuantity,
  rrunit AS ReferenceQuantityUnit,
  rmsl AS ReferenceQuantity,
  cast( qunit1 as fis_qunit1 preserving type ) AS AdditionalQuantity1Unit,
  cast( quant1 as fis_quan1_l preserving type ) AS AdditionalQuantity1,
  cast( qunit2 as fis_qunit2 preserving type ) AS AdditionalQuantity2Unit,
  cast( quant2 as fis_quan2_l preserving type ) AS AdditionalQuantity2,
  cast( qunit3 as fis_qunit3 preserving type ) AS AdditionalQuantity3Unit,
  cast( quant3 as fis_quan3_l preserving type ) AS AdditionalQuantity3,
  CO_MEINH AS IncmpltSummableValnQtyUnt,
  CO_MEGBTR AS IncmpltSummableValnQty,
  CO_MEFBTR AS IncmpltSummableValnFxdQty,
  drcrk AS DebitCreditCode,
  poper AS FiscalPeriod,
  periv AS FiscalYearVariant,
  fiscyearper AS FiscalYearPeriod,
  budat AS PostingDate,
  bldat AS DocumentDate,
  blart AS AccountingDocumentType,
  buzei AS AccountingDocumentItem,
  zuonr AS AssignmentReference,
  bstat AS AccountingDocumentCategory,
  linetype AS JournalEntryItemCategory,
  bschl AS PostingKey,
  ktosl AS TransactionTypeDetermination,
  slalittype AS SubLedgerAcctLineItemType,
  usnam AS AccountingDocCreatedByUser,
  cast( timestamp as fis_creation_datetime preserving type ) AS CreationDateTime,
  cast(substring( cast(timestamp as abap.char(30)) , 1 , 8) as fis_cpdat) AS CreationDate,
  cast( eprctr as fis_eprctr preserving type ) AS EliminationProfitCenter,
  rhoart AS OriginObjectType,
  glaccount_type AS GLAccountType,
  cast(lokkt as fis_alternativeglaccount preserving type ) AS AlternativeGLAccount,
  ktop2 AS CountryChartOfAccounts,
  cast( xsplitmod as xsplitmod_acd preserving type ) AS ItemIsSplit,
  rbunit AS ConsolidationUnit,
  rbuptr AS PartnerConsolidationUnit,
  rcomp AS Company,
  ritclg AS ConsolidationChartOfAccounts,
  ritem AS CnsldtnFinancialStatementItem,
  sityp AS CnsldtnSubitemCategory,
  subit AS CnsldtnSubitem,
  rebzg AS InvoiceReference,
  rebzj AS InvoiceReferenceFiscalYear,
  cast( rebzt as fis_rebzt preserving type ) AS FollowOnDocumentType,
  rebzz AS InvoiceItemReference,
  rbest AS ReferencePurchaseOrderCategory,
  ebeln AS PurchasingDocument,
  ebelp AS PurchasingDocumentItem,
  cast( zekkn as fis_dzekkn preserving type ) AS AccountAssignmentNumber,
  sgtxt AS DocumentItemText,
  cast(kdauf as vbeln_va preserving type) AS SalesDocument,
  cast(kdpos as posnr_va preserving type) AS SalesDocumentItem,
  cast (matnr as productnumber) AS Product,
  werks AS Plant,
  lifnr AS Supplier,
  kunnr AS Customer,
  fbuda AS ServicesRenderedDate,
  perop_beg AS PerformancePeriodStartDate,
  perop_end AS PerformancePeriodEndDate,
  coco_num AS ConditionContract,
  wwert AS ExchangeRateDate,
  koart AS FinancialAccountType,
  umskz AS SpecialGLCode,
  mwskz AS TaxCode,
  tax_country AS TaxCountry,
  hbkid AS HouseBank,
  hktid AS HouseBankAccount,
  xopvw AS IsOpenItemManaged,
  augdt AS ClearingDate,
  cast( auggj as fis_auggj_no_conv_depre preserving type ) AS ClearingDocFiscalYear,
  cast( augbl as fis_augbl_depre preserving type ) AS ClearingAccountingDocument,
  auggj AS ClearingJournalEntryFiscalYear,
  augbl AS ClearingJournalEntry,
  valut AS ValueDate,
  AGING AS GeneralLedgerAgingScope,
  AGING_INCRMNT AS GeneralLedgerAgingIncrement,
  afabe AS AssetDepreciationArea,
  anln1 AS MasterFixedAsset,
  anln2 AS FixedAsset,
  bzdat AS AssetValueDate,
  anbwa AS AssetTransactionType,
  movcat AS AssetAcctTransClassfctn,
  depr_period AS DepreciationFiscalPeriod,
  anlgr AS GroupMasterFixedAsset,
  anlgr2 AS GroupFixedAsset,
  anlkl AS AssetClass,
  panl1 AS PartnerMasterFixedAsset,
  panl2 AS PartnerFixedAsset,
  kalnr AS CostEstimate,
  cast( kzbws as fis_inventoryspclstockvalntype preserving type ) AS InventorySpecialStockValnType,
  cast( xobew as fis_mlxobew preserving type ) AS IsSupplierStockValuation,
  cast( sobkz as fis_inventoryspecialstocktype preserving type ) AS InventorySpecialStockType,
  cast( mat_kdauf as fis_mlmat_kdauf preserving type ) AS InventorySpclStkSalesDocument,
  cast( mat_kdpos as fis_mlmat_kdpos preserving type ) AS InventorySpclStkSalesDocItm,
  cast( mat_pspnr as fis_invspstock_wbsint_no_conv preserving type ) AS InvtrySpclStockWBSElmntIntID,
  cast( mat_ps_posid as fis_invspstock_wbs_no_conv preserving type ) AS InventorySpclStockWBSElement,
  mat_lifnr AS InventorySpecialStockSupplier,
  cast( bwtar as fis_bwtar_d preserving type ) AS InventoryValuationType,
  bwkey AS ValuationArea,
  cast(mlptyp as fml_process_type preserving type ) AS MaterialLedgerProcessType,
  cast(mlcateg as fml_category preserving type ) AS MaterialLedgerCategory,
  cast(hvkwrt as fis_lcrcy_sp_value preserving type ) AS SlsPriceAmountInCoCodeCrcy,
  cast(vprsv as fml_price_control preserving type ) AS ProductPriceControl,
  cast( bukrs_sender as fis_bukrs_sender preserving type ) AS SenderCompanyCode,
  racct_sender AS SenderGLAccount,
  cast( accas_sender as fis_accas_sender preserving type ) AS SenderAccountAssignment,
  cast( accasty_sender as fis_accasty_sender preserving type ) AS SenderAccountAssignmentType,
  cast( objnr as fis_objnr preserving type) AS ControllingObject,
  hkgrp AS CostOriginGroup,
  uspob AS OriginSenderObject,
  cast( co_belkz as fis_co_belkz preserving type ) AS ControllingDebitCreditCode,
  co_beknz AS OriginCtrlgDebitCreditCode,
  cast( beltp as fis_bp_inout preserving type ) AS ControllingObjectDebitType,
  muvflg AS QuantityIsIncomplete,
  gkont AS OffsettingAccount,
  cast( gkoar as fis_gkoar preserving type ) AS OffsettingAccountType,
  erlkz AS LineItemIsCompleted,
  pernr AS PersonnelNumber,
  scope AS ControllingObjectClass,
  cast( pbukrs as fis_pbukrs preserving type ) AS PartnerCompanyCode,
  pscope AS PartnerControllingObjectClass,
  uprctr AS OriginProfitCenter,
  aufnr_org AS OriginOrder,
  ulstar AS OriginCostCtrActivityType,
  ukostl AS OriginCostCenter,
  UMATNR AS OriginProduct,
  VARC_UACCT AS VarianceOriginGLAccount,
  accas AS AccountAssignment,
  accasty AS AccountAssignmentType,
  lstar AS CostCtrActivityType,
  aufnr AS OrderID,
  autyp AS OrderCategory,
  cast( ps_psp_pnr as fis_wbsint_no_conv preserving type ) AS WBSElementInternalID,
  cast( ps_posid as fis_wbs_no_conv preserving type ) AS WBSElement,
  cast( pps_psp_pnr as fis_partner_wbsint_no_conv preserving type ) AS PartnerWBSElementInternalID,
  cast( pps_posid as fis_partner_wbs_no_conv preserving type ) AS PartnerWBSElement,
  cast( ps_prj_pnr as fis_projectint_no_conv preserving type ) AS ProjectInternalID,
  cast( ps_pspid as fis_project_no_conv preserving type ) AS Project,
  cast( pps_prj_pnr as fis_part_projectint_no_conv preserving type ) AS PartnerProjectInternalID,
  cast( pps_pspid as fis_part_project_no_conv preserving type ) AS PartnerProject,
  erkrs AS OperatingConcern,
  nplnr AS ProjectNetwork,
  nplnr_vorgn AS RelatedNetworkActivity,
  prznr AS BusinessProcess,
  kstrg AS CostObject,
  bemot AS BillableControl,
  rsrce AS CostAnalysisResource,
  cast( qmnum as fis_qmnum preserving type ) AS CustomerServiceNotification,
  service_doc_type AS ServiceDocumentType,
  service_doc_id AS ServiceDocument,
  service_doc_item_id AS ServiceDocumentItem,
  cast( pservice_doc_type as fis_psrvdoc_type preserving type ) AS PartnerServiceDocumentType,
  cast( pservice_doc_id as fis_psrvdoc_id preserving type ) AS PartnerServiceDocument,
  cast( pservice_doc_item_id as fis_psrvdoc_item_id preserving type ) AS PartnerServiceDocumentItem,
  service_contract_type AS ServiceContractType,
  service_contract_id AS ServiceContract,
  service_contract_item_id AS ServiceContractItem,
  solution_order_id AS BusinessSolutionOrder,
  solution_order_item_id AS BusinessSolutionOrderItem,
  vtkey AS ProviderContract,
  vtpos AS ProviderContractItem,
  ra_contract_id AS RevenueAccountingContract,
  ra_pob_id AS PerformanceObligation,
  overtimecat AS TimeSheetOvertimeCategory,
  paccas AS PartnerAccountAssignment,
  paccasty AS PartnerAccountAssignmentType,
  co_accasty_n1 AS StstclAccountAssignmentType1,
  co_accasty_n2 AS StstclAccountAssignmentType2,
  co_accasty_n3 AS StstclAccountAssignmentType3,
  cast( ps_posid as /cpd/plan_item_id ) AS WorkPackage,
  work_item_id AS WorkItem,
  plstar AS PartnerCostCtrActivityType,
  paufnr AS PartnerOrder,
  pautyp AS PartnerOrderCategory,
  pkdauf AS PartnerSalesDocument,
  pkdpos AS PartnerSalesDocumentItem,
  cast( pnplnr as fis_par_npln preserving type ) AS PartnerProjectNetwork,
  pnplnr_vorgn AS PartnerProjectNetworkActivity,
  cast( pprznr as fis_par_prznr preserving type ) AS PartnerBusinessProcess,
  pkstrg AS PartnerCostObject,
  cast( co_buzei as co_buzei_acd preserving type ) AS ControllingDocumentItem,
  varc_hkgrp AS VarianceOriginGroup,
  fkart AS BillingDocumentType,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  spart AS OrganizationDivision,
  matnr_copa AS SoldProduct,
  matkl AS SoldProductGroup,
  kdgrp AS CustomerGroup,
  cast( land1 as fis_land1_gp preserving type ) 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,
  re_bukrs AS CashLedgerCompanyCode,
  re_account AS CashLedgerAccount,
  fikrs AS FinancialManagementArea,
  fipex AS CommitmentItem,
  fistl AS FundsCenter,
  measure AS FundedProgram,
  rfund AS Fund,
  rgrant_nbr AS GrantID,
  rbudget_pd AS BudgetPeriod,
  sfund AS PartnerFund,
  sgrant_nbr AS PartnerGrant,
  cast( sbudget_pd as fis_fm_pbudget_period preserving type ) AS PartnerBudgetPeriod,
  bdgt_account AS PubSecBudgetAccount,
  bdgt_account_cocode AS PubSecBudgetAccountCoCode,
  bdgt_cnsmpn_date AS PubSecBudgetCnsmpnDate,
  bdgt_cnsmpn_period AS PubSecBudgetCnsmpnFsclPeriod,
  bdgt_cnsmpn_year AS PubSecBudgetCnsmpnFsclYear,
  bdgt_relevant AS PubSecBudgetIsRelevant,
  bdgt_cnsmpn_type AS PubSecBudgetCnsmpnType,
  bdgt_cnsmpn_amount_type AS PubSecBudgetCnsmpnAmtType,
  rsponsored_prog AS SponsoredProgram,
  rsponsored_class AS SponsoredClass,
  rbdgt_vldty_nbr AS GteeMBudgetValidityNumber,
  kblnr AS EarmarkedFundsDocument,
  kblpos AS EarmarkedFundsDocumentItem,
  FS_PRODUCT_GROUP AS FinancialServicesProductGroup,
  BRANCH_ID AS FinancialServicesBranch,
  DATASOURCE_ID AS FinancialDataSource,
  vname AS JointVenture,
  cast( egrup as jv_egroup_cds preserving type ) AS JointVentureEquityGroup,
  cast( recid as jv_recind_cds preserving type ) AS JointVentureCostRecoveryCode,
  cast( vptnr as jv_part_cds preserving type ) AS JointVenturePartner,
  cast( btype as jv_bilind_cds preserving type ) AS JointVentureBillingType,
  cast( etype as jv_etype_cds preserving type ) AS JointVentureEquityType,
  cast( prodper as jv_prodper_cds preserving type ) AS JointVentureProductionDate,
  cast( billm as jv_billm_cds preserving type ) AS JointVentureBillingDate,
  cast( pom as jv_pom_cds preserving type ) AS JointVentureOperationalDate,
  cast( cbrunid as jv_cbrunid_cds preserving type ) AS CutbackRun,
  cast( jvactivity as jv_activity_cds preserving type ) AS JointVentureAccountingActivity,
  cast( pvname as jv_pvname_cds preserving type ) AS PartnerVenture,
  cast( pegrup as jv_pegrup_cds preserving type ) AS PartnerEquityGroup,
  cast( s_recind as jv_srecind_cds preserving type ) AS SenderCostRecoveryCode,
  cast( cbracct as jv_cbracct_cds preserving type ) AS CutbackAccount,
  cast( cbobjnr as jv_cbobjnr_cds preserving type ) AS CutbackCostObject,
  SWENR AS REBusinessEntity,
  SGENR AS RealEstateBuilding,
  SGRNR AS RealEstateProperty,
  SMENR AS RERentalObject,
  RECNNR AS RealEstateContract,
  snksl AS REServiceChargeKey,
  sempsl AS RESettlementUnitID,
  cast( dabrz as fis_dabrbez preserving type ) AS SettlementReferenceDate,
  pswenr AS REPartnerBusinessEntity,
  psgenr AS RealEstatePartnerBuilding,
  psgrnr AS RealEstatePartnerProperty,
  psmenr AS REPartnerRentalObject,
  precnnr AS RealEstatePartnerContract,
  psnksl AS REPartnerServiceChargeKey,
  psempsl AS REPartnerSettlementUnitID,
  pdabrz AS PartnerSettlementReferenceDate,
  acrobjtype AS AccrualObjectType,
  acrlogsys AS AccrualObjectLogicalSystem,
  acrobj_id AS AccrualObject,
  acrsobj_id AS AccrualSubobject,
  acritmtype AS AccrualItemType,
  acrrefobj_id AS AccrualReferenceObject,
  acrvaldat AS AccrualValueDate,
  cast( valobjtype as fis_val_obj_type preserving type ) AS FinancialValuationObjectType,
  cast( valobj_id as fis_val_obj_id preserving type ) AS FinancialValuationObject,
  cast( valsobj_id as fis_val_subobj_id preserving type ) AS FinancialValuationSubobject,
  netdt AS NetDueDate,
  risk_class AS CreditRiskClass,
  arbid AS WorkCenterInternalID,
  vornr AS OrderOperation,
  aufps AS OrderItem,
  paufps AS PartnerOrderItem,
  uvorn AS OrderSuboperation,
  equnr AS Equipment,
  tplnr AS FunctionalLocation,
  istru AS Assembly,
  ilart AS MaintenanceActivityType,
  plknz AS MaintenanceOrderPlanningCode,
  artpr AS MaintPriorityType,
  priok AS MaintPriority,
  maufnr AS SuperiorOrder,
  cast( matkl_mm as fis_matkl_mm preserving type ) AS ProductGroup,
  planned_parts_work AS MaintenanceOrderIsPlanned,
  vornr_org AS OriginOrderOperation,
  mig_source AS JrnlEntryItemMigrationSource,
  P_ACDOCA.offstg_docln AS OffsettingLedgerGLLineItem
FROM P_ACDOCA
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON CompanyCode = _JournalEntry.CompanyCode AND FiscalYear = _JournalEntry.FiscalYear AND AccountingDocument = _JournalEntry.AccountingDocument  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- 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_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_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_Currency AS _BalanceTransactionCurrency ON BalanceTransactionCurrency = _BalanceTransactionCurrency.Currency  -- 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_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CostSourceUnit ON CostSourceUnit = _CostSourceUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _AdditionalQuantity1Unit ON AdditionalQuantity1Unit = _AdditionalQuantity1Unit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _AdditionalQuantity2Unit ON AdditionalQuantity2Unit = _AdditionalQuantity2Unit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _AdditionalQuantity3Unit ON AdditionalQuantity3Unit = _AdditionalQuantity3Unit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ReferenceQuantityUnit ON ReferenceQuantityUnit = _ReferenceQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _IncmpltSummableValnQtyUnt ON IncmpltSummableValnQtyUnt = _IncmpltSummableValnQtyUnt.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_CostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter  -- association [0..*]
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_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_AccountingDocumentType AS _AccountingDocumentType ON AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_FinancialAccountType AS _FinancialAccountType ON FinancialAccountType = _FinancialAccountType.FinancialAccountType  -- association [0..1]
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- 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 SourceLedger = _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_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _SupplierCompany ON Supplier = _SupplierCompany.Supplier AND CompanyCode = _SupplierCompany.CompanyCode  -- 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_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_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_Order AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_Order AS _OriginOrder ON OriginOrder = _OriginOrder.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_FinancialTransactionType AS _FinancialTransactionType ON FinancialTransactionType = _FinancialTransactionType.FinancialTransactionType  -- 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_ReferenceDocumentType AS _ReferenceDocumentType ON ReferenceDocumentType = _ReferenceDocumentType.ReferenceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_ReferenceDocumentType AS _PredecessorReferenceDocType ON PredecessorReferenceDocType = _PredecessorReferenceDocType.ReferenceDocumentType  -- 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_AccountingDocumentCategory AS _AccountingDocumentCategory ON AccountingDocumentCategory = _AccountingDocumentCategory.AccountingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_PostingKey AS _PostingKey ON PostingKey = _PostingKey.PostingKey  -- association [0..1]
LEFT OUTER JOIN I_SubLedgerAccLineItemType AS _SubLedgerAccLineItemType ON SubLedgerAcctLineItemType = _SubLedgerAccLineItemType.SubLedgerAcctLineItemType  -- association [0..1]
LEFT OUTER JOIN I_User AS _User ON AccountingDocCreatedByUser = _User.UserID  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _EliminationProfitCenter ON ControllingArea = _EliminationProfitCenter.ControllingArea AND EliminationProfitCenter = _EliminationProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_GLAccountType AS _GLAccountType ON GLAccountType = _GLAccountType.GLAccountType  -- association [0..1]
LEFT OUTER JOIN I_FinancialAccountType AS _OffsettingAccountType ON OffsettingAccountType = _OffsettingAccountType.FinancialAccountType  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _AlternativeGLAccount ON CountryChartOfAccounts = _AlternativeGLAccount.ChartOfAccounts AND AlternativeGLAccount = _AlternativeGLAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_OffsettingAccount AS _OffsettingAccount ON OffsettingChartOfAccounts = _OffsettingAccount.ChartOfAccounts AND OffsettingAccountType = _OffsettingAccount.OffsettingAccountType AND OffsettingAccount = _OffsettingAccount.OffsettingAccount  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _OffsettingChartOfAccounts ON OffsettingChartOfAccounts = _OffsettingChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _CountryChartOfAccounts ON CountryChartOfAccounts = _CountryChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_SpecialGLCode AS _SpecialGLCode ON SpecialGLCode = _SpecialGLCode.SpecialGLCode AND FinancialAccountType = _SpecialGLCode.FinancialAccountType  -- association [0..1]
LEFT OUTER JOIN I_TaxCode AS _TaxCode ON TaxCode = _TaxCode.TaxCode  -- association [0..*]
LEFT OUTER JOIN I_Country AS _TaxCountry ON TaxCountry = _TaxCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocument AS _ClearingAccountingDocument ON CompanyCode = _ClearingAccountingDocument.CompanyCode AND FiscalYear = _ClearingAccountingDocument.FiscalYear AND ClearingAccountingDocument = _ClearingAccountingDocument.AccountingDocument  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _ClearingJrnlEntryFiscalYear ON ClearingJournalEntryFiscalYear = _ClearingJrnlEntryFiscalYear.FiscalYear AND CompanyCode = _ClearingJrnlEntryFiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JournalEntry AS _ClearingJournalEntry ON CompanyCode = _ClearingJournalEntry.CompanyCode AND ClearingJournalEntryFiscalYear = _ClearingJournalEntry.FiscalYear AND ClearingJournalEntry = _ClearingJournalEntry.AccountingDocument  -- 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_MasterFixedAsset AS _GroupMasterFixedAsset ON CompanyCode = _GroupMasterFixedAsset.CompanyCode AND GroupMasterFixedAsset = _GroupMasterFixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _PartnerMasterFixedAsset ON CompanyCode = _PartnerMasterFixedAsset.CompanyCode AND PartnerMasterFixedAsset = _PartnerMasterFixedAsset.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_FixedAsset AS _GroupFixedAsset ON CompanyCode = _GroupFixedAsset.CompanyCode AND GroupMasterFixedAsset = _GroupFixedAsset.MasterFixedAsset AND GroupFixedAsset = _GroupFixedAsset.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _PartnerFixedAsset ON CompanyCode = _PartnerFixedAsset.CompanyCode AND PartnerMasterFixedAsset = _PartnerFixedAsset.MasterFixedAsset AND PartnerFixedAsset = _PartnerFixedAsset.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_BusinessProcess AS _BusinessProcess ON ControllingArea = _BusinessProcess.ControllingArea AND BusinessProcess = _BusinessProcess.BusinessProcess  -- 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_OrderCategory AS _PartnerOrderCategory ON PartnerOrderCategory = _PartnerOrderCategory.OrderCategory  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _PartnerSalesDocument ON PartnerSalesDocument = _PartnerSalesDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _PartnerSalesDocumentItem ON PartnerSalesDocument = _PartnerSalesDocumentItem.SalesDocument AND PartnerSalesDocumentItem = _PartnerSalesDocumentItem.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_BusinessProcess AS _PartnerBusinessProcess ON ControllingArea = _PartnerBusinessProcess.ControllingArea AND PartnerBusinessProcess = _PartnerBusinessProcess.BusinessProcess  -- association [0..1]
LEFT OUTER JOIN I_BillingDocumentType AS _BillingDocumentType ON BillingDocumentType = _BillingDocumentType.BillingDocumentType  -- 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_Product AS _SoldProduct ON SoldProduct = _SoldProduct.Product  -- association [0..1]
LEFT OUTER JOIN I_Product AS _OriginProduct ON OriginProduct = _OriginProduct.Product  -- association [0..1]
LEFT OUTER JOIN I_InventoryValuationType AS _InventorySpecialStockValnType ON InventorySpecialStockValnType = _InventorySpecialStockValnType.InventoryValuationType  -- association [0..1]
LEFT OUTER JOIN I_InvtrySpecialStockValnType AS _InventorySpclStockValnType ON InventorySpecialStockValnType = _InventorySpclStockValnType.InventorySpecialStockValnType  -- association [0..1]
LEFT OUTER JOIN I_InventorySpecialStockType AS _InventorySpecialStockType ON InventorySpecialStockType = _InventorySpecialStockType.InventorySpecialStockType  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _InventorySpclStkSalesDocument ON InventorySpclStkSalesDocument = _InventorySpclStkSalesDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _InventorySpclStkSalesDocItm ON InventorySpclStkSalesDocument = _InventorySpclStkSalesDocItm.SalesDocument AND InventorySpclStkSalesDocItm = _InventorySpclStkSalesDocItm.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _InvtrySpclStockWBSElmntBasic ON InvtrySpclStockWBSElmntIntID = _InvtrySpclStockWBSElmntBasic.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _InvtrySpclStkWBSElmntBscData ON InvtrySpclStockWBSElmntIntID = _InvtrySpclStkWBSElmntBscData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _InventorySpecialStockSupplier ON InventorySpecialStockSupplier = _InventorySpecialStockSupplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _InvtrySpclStockSupplierText ON InventorySpecialStockSupplier = _InvtrySpclStockSupplierText.Supplier  -- association [0..1]
LEFT OUTER JOIN I_InventoryValuationType AS _InventoryValuationType ON InventoryValuationType = _InventoryValuationType.InventoryValuationType  -- association [0..1]
LEFT OUTER JOIN I_ControllingDebitCreditCode AS _ControllingDebitCreditCode ON ControllingDebitCreditCode = _ControllingDebitCreditCode.ControllingDebitCreditCode  -- association [0..1]
LEFT OUTER JOIN I_ControllingDebitCreditCode AS _OriginCtrlgDebitCreditCode ON OriginCtrlgDebitCreditCode = _OriginCtrlgDebitCreditCode.ControllingDebitCreditCode  -- association [0..1]
LEFT OUTER JOIN I_ControllingObject AS _OriginSenderObject ON OriginSenderObject = _OriginSenderObject.ControllingObject  -- association [0..1]
LEFT OUTER JOIN I_ControllingObjectClass AS _ControllingObjectClass ON ControllingObjectClass = _ControllingObjectClass.ControllingObjectClass  -- association [0..1]
LEFT OUTER JOIN I_Partnercompany AS _PartnerCompany ON PartnerCompany = _PartnerCompany.PartnerCompany  -- association [0..1]
LEFT OUTER JOIN I_ControllingObjectClass AS _PartnerControllingObjectClass ON PartnerControllingObjectClass = _PartnerControllingObjectClass.ControllingObjectClass  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _OriginCostCenter ON ControllingArea = _OriginCostCenter.ControllingArea AND OriginCostCenter = _OriginCostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _OriginProfitCenter ON ControllingArea = _OriginProfitCenter.ControllingArea AND OriginProfitCenter = _OriginProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenterActivityType AS _CostCtrActivityType ON ControllingArea = _CostCtrActivityType.ControllingArea AND CostCtrActivityType = _CostCtrActivityType.CostCtrActivityType  -- association [0..*]
LEFT OUTER JOIN I_CostCenterActivityType AS _OriginCostCtrActivityType ON ControllingArea = _OriginCostCtrActivityType.ControllingArea AND OriginCostCtrActivityType = _OriginCostCtrActivityType.CostCtrActivityType  -- association [0..*]
LEFT OUTER JOIN I_OrderCategory AS _OrderCategory ON OrderCategory = _OrderCategory.OrderCategory  -- association [0..1]
LEFT OUTER JOIN I_MovementCategory AS _MovementCategory ON AssetAcctTransClassfctn = _MovementCategory.AssetAcctTransClassfctn  -- association [0..1]
LEFT OUTER JOIN I_AssetTransactionType AS _AssetTransactionType ON AssetTransactionType = _AssetTransactionType.AssetTransactionType  -- association [0..1]
LEFT OUTER JOIN I_CostOriginGroup AS _CostOriginGroup ON ControllingArea = _CostOriginGroup.ControllingArea AND CostOriginGroup = _CostOriginGroup.CostOriginGroup  -- association [0..*]
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_OperatingConcern AS _OperatingConcern ON OperatingConcern = _OperatingConcern.OperatingConcern  -- association [0..1]
LEFT OUTER JOIN I_ValuationArea AS _ValuationArea ON ValuationArea = _ValuationArea.ValuationArea  -- association [0..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_ConditionContract AS _ConditionContract ON ConditionContract = _ConditionContract.ConditionContract  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrder AS _MaintenanceOrder ON OrderID = _MaintenanceOrder.MaintenanceOrder AND OrderCategory = '30'  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrderOperation AS _MaintenanceOrderOperation ON OrderID = _MaintenanceOrderOperation.MaintenanceOrder AND OrderOperation = _MaintenanceOrderOperation.MaintenanceOrderOperation AND OrderCategory = '30'  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrderSubOperation AS _MaintenanceOrderSubOperation ON OrderID = _MaintenanceOrderSubOperation.MaintenanceOrder AND OrderOperation = _MaintenanceOrderSubOperation.MaintenanceOrderOperation AND OrderSuboperation = _MaintenanceOrderSubOperation.MaintenanceOrderSubOperation  -- 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_WorkPackage AS _WorkPackage ON WorkPackage = _WorkPackage.WorkPackage  -- association [0..1]
LEFT OUTER JOIN I_WorkPackageWorkItem AS _WorkPackageWorkItem ON WorkItem = _WorkPackageWorkItem.WorkItem AND WorkPackage = _WorkPackageWorkItem.WorkPackage  -- association [0..1]
LEFT OUTER JOIN I_TimeSheetOvertimeCat AS _TimeSheetOvertimeCat ON TimeSheetOvertimeCategory = _TimeSheetOvertimeCat.TimeSheetOvertimeCategory  -- 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_ServiceDocumentType AS _PartnerServiceDocumentType ON PartnerServiceDocumentType = _PartnerServiceDocumentType.ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocByDocumentType AS _PartnerServiceDocument ON PartnerServiceDocumentType = _PartnerServiceDocument.ServiceDocumentType AND PartnerServiceDocument = _PartnerServiceDocument.ServiceDocument  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocItemByDocumentType AS _PartnerServiceDocumentItem ON PartnerServiceDocumentType = _PartnerServiceDocumentItem.ServiceDocumentType AND PartnerServiceDocument = _PartnerServiceDocumentItem.ServiceDocument AND PartnerServiceDocumentItem = _PartnerServiceDocumentItem.ServiceDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _ProjectBasicData ON ProjectInternalID = _ProjectBasicData.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _PartnerProjectBasicData ON PartnerProjectInternalID = _PartnerProjectBasicData.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _PartnerWBSElementBasicData ON PartnerWBSElementInternalID = _PartnerWBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_AccrualObjectType AS _AccrualObjectType ON AccrualObjectType = _AccrualObjectType.AccrualObjectType  -- association [0..1]
LEFT OUTER JOIN I_AccrualObject AS _AccrualObject ON AccrualObjectType = _AccrualObject.AccrualObjectType AND _AccrualObject.AccrualObjectLogicalSystem = '' AND CompanyCode = _AccrualObject.CompanyCode AND AccrualObject = _AccrualObject.AccrualObject  -- association [0..1]
LEFT OUTER JOIN I_AccrualSubObject AS _AccrualSubobject ON AccrualObjectType = _AccrualSubobject.AccrualObjectType AND _AccrualSubobject.AccrualObjectLogicalSystem = '' AND CompanyCode = _AccrualSubobject.CompanyCode AND AccrualObject = _AccrualSubobject.AccrualObject AND AccrualSubobject = _AccrualSubobject.AccrualSubobject  -- association [0..1]
LEFT OUTER JOIN I_AccrualItemType AS _AccrualItemType ON AccrualObjectType = _AccrualItemType.AccrualObjectType AND AccrualItemType = _AccrualItemType.AccrualItemType  -- association [0..1]
LEFT OUTER JOIN I_CreditRiskClass AS _CreditRiskClass ON CreditRiskClass = _CreditRiskClass.CreditRiskClass  -- association [0..1]
LEFT OUTER JOIN I_FinValuationObjectType AS _FinValuationObjectType ON FinancialValuationObjectType = _FinValuationObjectType.FinancialValuationObjectType  -- association [0..1]
LEFT OUTER JOIN I_SemTagGLAccount AS _SemTagGLAccount ON GLAccount = _SemTagGLAccount.GLAccount AND ChartOfAccounts = _SemTagGLAccount.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CashLedgerCompanyCode ON CashLedgerCompanyCode = _CashLedgerCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _CashLedgerAccount ON CashLedgerCompanyCode = _CashLedgerAccount.CompanyCode AND CashLedgerAccount = _CashLedgerAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinancialManagementArea ON FinancialManagementArea = _FinancialManagementArea.FinancialManagementArea  -- association [0..1]
LEFT OUTER JOIN I_FundsCenter AS _FundsCenter ON FinancialManagementArea = _FundsCenter.FinancialManagementArea AND FundsCenter = _FundsCenter.FundsCenter  -- association [0..*]
LEFT OUTER JOIN I_FundedProgram AS _FundedProgram ON FinancialManagementArea = _FundedProgram.FinancialManagementArea AND FundedProgram = _FundedProgram.FundedProgram  -- 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_Fund AS _PartnerFund ON FinancialManagementArea = _PartnerFund.FinancialManagementArea AND PartnerFund = _PartnerFund.Fund  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _PartnerGrant ON PartnerGrant = _PartnerGrant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriod AS _PartnerBudgetPeriod ON PartnerBudgetPeriod = _PartnerBudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _PubSecBudgetAccountCoCode ON PubSecBudgetAccountCoCode = _PubSecBudgetAccountCoCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PubSecBudgetAccount AS _PubSecBudgetAccount ON PubSecBudgetAccountCoCode = _PubSecBudgetAccount.PubSecBudgetAccountCoCode AND PubSecBudgetAccount = _PubSecBudgetAccount.PubSecBudgetAccount  -- association [0..1]
LEFT OUTER JOIN I_SponsoredProgramCore AS _SponsoredProgram ON SponsoredProgram = _SponsoredProgram.SponsoredProgram  -- association [0..1]
LEFT OUTER JOIN I_SponsoredClassCore AS _SponsoredClass ON SponsoredClass = _SponsoredClass.SponsoredClass  -- association [0..1]
LEFT OUTER JOIN I_FiscCalendarDateForCompCode AS _PubSecBudgetCnsmpnDate ON PubSecBudgetCnsmpnDate = _PubSecBudgetCnsmpnDate.CalendarDate AND PubSecBudgetAccountCoCode = _PubSecBudgetCnsmpnDate.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearPeriodForCmpnyCode AS _PubSecBudgetCnsmpnFsclPeriod ON PubSecBudgetAccountCoCode = _PubSecBudgetCnsmpnFsclPeriod.CompanyCode AND PubSecBudgetCnsmpnFsclYear = _PubSecBudgetCnsmpnFsclPeriod.FiscalYear AND PubSecBudgetCnsmpnFsclPeriod = _PubSecBudgetCnsmpnFsclPeriod.FiscalPeriod  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _PubSecBudgetCnsmpnFsclYear ON PubSecBudgetAccountCoCode = _PubSecBudgetCnsmpnFsclYear.CompanyCode AND PubSecBudgetCnsmpnFsclYear = _PubSecBudgetCnsmpnFsclYear.FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_PubSecBdgtCnsmpnType AS _PubSecBudgetCnsmpnType ON PubSecBudgetCnsmpnType = _PubSecBudgetCnsmpnType.PubSecBudgetCnsmpnType  -- association [0..1]
LEFT OUTER JOIN I_PubSecBdgtCnsmpnAmtType AS _PubSecBudgetCnsmpnAmtType ON PubSecBudgetCnsmpnAmtType = _PubSecBudgetCnsmpnAmtType.PubSecBudgetCnsmpnAmtType  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnit_3 AS _ConsolidationUnit ON ConsolidationUnit = _ConsolidationUnit.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnit_3 AS _PartnerConsolidationUnit ON PartnerConsolidationUnit = _PartnerConsolidationUnit.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN I_Globalcompany AS _Company ON Company = _Company.Company  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnChartOfAccounts AS _ConsolidationChartOfAccounts ON ConsolidationChartOfAccounts = _ConsolidationChartOfAccounts.ConsolidationChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFinStmntItem AS _CnsldtnFinancialStatementItem ON ConsolidationChartOfAccounts = _CnsldtnFinancialStatementItem.ConsolidationChartOfAccounts AND CnsldtnFinancialStatementItem = _CnsldtnFinancialStatementItem.FinancialStatementItem  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSubItemCategory AS _CnsldtnSubitemCategory ON CnsldtnSubitemCategory = _CnsldtnSubitemCategory.SubItemCategory  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSubItem AS _CnsldtnSubitem ON CnsldtnSubitemCategory = _CnsldtnSubitem.SubItemCategory AND CnsldtnSubitem = _CnsldtnSubitem.SubItem  -- association [0..1]
LEFT OUTER JOIN I_ProviderContract AS _ProviderContract ON ProviderContract = _ProviderContract.ProviderContract  -- association [0..1]
LEFT OUTER JOIN I_ProviderContractItem AS _ProviderContractItem ON ProviderContract = _ProviderContractItem.ProviderContract AND ProviderContractItem = _ProviderContractItem.ProviderContractItem  -- association [0..1]
LEFT OUTER JOIN I_AccountAssignmentType AS _AccountAssignmentType ON AccountAssignmentType = _AccountAssignmentType.AccountAssignmentType  -- association [0..1]
LEFT OUTER JOIN I_JrnlEntryItemObsoleteRsn AS _JrnlEntryItemObsoleteRsn ON JrnlEntryItemObsoleteReason = _JrnlEntryItemObsoleteRsn.JrnlEntryItemObsoleteReason  -- association [0..1]
LEFT OUTER JOIN E_JournalEntryItem AS _Extension ON SourceLedger = _Extension.SourceLedger AND CompanyCode = _Extension.CompanyCode AND FiscalYear = _Extension.FiscalYear AND AccountingDocument = _Extension.AccountingDocument AND LedgerGLLineItem = _Extension.LedgerGLLineItem  -- association [1..1]
;