ICA_MatchingJournalEntryItem

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 ICA_MatchingJournalEntryItem.
-- 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 ICA_MatchingJournalEntryItem AS
SELECT
  cast ('' as ica_method_id) AS MatchingMethodID,
  cast( a.awitem as fis_awitem preserving type ) AS ReferenceDocumentItem,
  cast( a.awitgrp as fis_awitgrp preserving type ) AS ReferenceDocumentItemGroup,
  cast( a.aworg_rev as fis_aworg_rev preserving type ) AS ReversalReferenceDocumentCntxt,
  cast( a.awref_rev as fis_awref_rev preserving type ) AS ReversalReferenceDocument,
  cast( a.prec_awtyp as fis_prec_awtyp preserving type ) AS PredecessorReferenceDocType,
  cast( a.prec_aworg as fis_prec_aworg preserving type ) AS PredecessorReferenceDocCntxt,
  cast( a.prec_awref as fis_prec_awref preserving type ) AS PredecessorReferenceDocument,
  cast( a.prec_awitem as fis_prec_awitem preserving type ) AS PredecessorReferenceDocItem,
  cast( a.prec_bukrs as fins_prec_bukrs_gfc preserving type ) AS PrdcssrJournalEntryCompanyCode,
  cast( a.prec_belnr as fins_prec_belnr_gfc preserving type ) AS PredecessorJournalEntry,
  cast( a.prec_docln as fins_prec_docln_gfc preserving type ) AS PredecessorJournalEntryItem,
  cast( a.src_awtyp as fis_src_awtyp preserving type ) AS SourceReferenceDocumentType,
  cast( a.src_awsys as fis_src_awsys preserving type ) AS SourceLogicalSystem,
  cast( a.src_aworg as fis_src_aworg preserving type ) AS SourceReferenceDocumentCntxt,
  cast( a.src_awref as fis_src_awref preserving type ) AS SourceReferenceDocument,
  cast( a.src_awitem as fis_src_awitem preserving type ) AS SourceReferenceDocumentItem,
  cast( a.src_awsubit as fis_src_awsubit preserving type ) AS SourceReferenceDocSubitem,
  cast( a.xcommitment as fis_xcommitment preserving type ) AS IsCommitment,
  cast( a.rbcur as fis_curr3 preserving type ) AS FreeDefinedCurrency3,
  cast( a.rccur as fis_curr4 preserving type ) AS FreeDefinedCurrency4,
  cast( a.rdcur as fis_curr5 preserving type ) AS FreeDefinedCurrency5,
  cast( a.recur as fis_curr6 preserving type ) AS FreeDefinedCurrency6,
  cast( a.rgcur as fis_curr8 preserving type ) AS FreeDefinedCurrency8,
  cast( a.kfsl2 as fis_vgcur12_fix2 preserving type ) AS GrpValnFixedAmtInGlobCrcy,
  cast( a.kfsl3 as fis_vgcur12_fix3 preserving type ) AS PrftCtrValnFxdAmtInGlobCrcy,
  cast( a.psl2 as fis_vpcur12_2 preserving type ) AS GrpValnTotPrcVarcInGlobCrcy,
  cast( a.psl3 as fis_vpcur12_3 preserving type ) AS PrftCtrValnTotPrcVarcInGlbCrcy,
  cast( a.pfsl2 as fis_vpfcur12_2 preserving type ) AS GrpValnFixedPrcVarcInGlobCrcy,
  cast( a.pfsl3 as fis_vpfcur12_3 preserving type ) AS PrftCtrValnFxdPrcVarcInGlbCrcy,
  cast( a.co_osl as fis_vco_ocur12 preserving type ) AS AmountInObjectCurrency,
  cast( a.mfsl as fis_quan1_12_fix preserving type ) AS FixedQuantity,
  cast( a.vmsl as fis_vquan1_12 preserving type ) AS ValuationQuantity,
  cast( a.vmfsl as fis_vquan1_12_fix preserving type ) AS ValuationFixedQuantity,
  cast( a.qunit1 as fis_qunit1 preserving type ) AS AdditionalQuantity1Unit,
  cast( a.quant1 as fis_quan1_l preserving type ) AS AdditionalQuantity1,
  cast( a.qunit2 as fis_qunit2 preserving type ) AS AdditionalQuantity2Unit,
  cast( a.quant2 as fis_quan2_l preserving type ) AS AdditionalQuantity2,
  cast( a.qunit3 as fis_qunit3 preserving type ) AS AdditionalQuantity3Unit,
  cast( a.quant3 as fis_quan3_l preserving type ) AS AdditionalQuantity3,
  cast(a.timestamp as fis_creation_datetime preserving type ) AS CreationDateTime,
  cast(substring( cast(a.timestamp as abap.char(30)) , 1 , 8) as fis_cpdat) AS CreationDate,
  cast( a.eprctr as fis_eprctr preserving type ) AS EliminationProfitCenter,
  cast(a.lokkt as fis_alternativeglaccount preserving type ) AS AlternativeGLAccount,
  cast( a.xsplitmod as xsplitmod_acd preserving type ) AS ItemIsSplit,
  cast( a.rebzt as fis_rebzt preserving type ) AS FollowOnDocumentType,
  cast( a.zekkn as fis_dzekkn preserving type ) AS AccountAssignmentNumber,
  cast(a.kdauf as vbeln_va preserving type) AS SalesDocument,
  cast(a.kdpos as posnr_va preserving type) AS SalesDocumentItem,
  cast(a.matnr as productnumber) AS Product,
  cast( a.auggj as fis_auggj_no_conv_depre preserving type ) AS ClearingDocFiscalYear,
  cast( a.augbl as fis_augbl_depre preserving type ) AS ClearingAccountingDocument,
  cast( a.kzbws as fis_inventoryspclstockvalntype preserving type ) AS InventorySpecialStockValnType,
  cast( a.xobew as fis_mlxobew preserving type ) AS IsSupplierStockValuation,
  cast( a.sobkz as fis_inventoryspecialstocktype preserving type ) AS InventorySpecialStockType,
  cast( a.mat_kdauf as fis_mlmat_kdauf preserving type ) AS InventorySpclStkSalesDocument,
  cast( a.mat_kdpos as fis_mlmat_kdpos preserving type ) AS InventorySpclStkSalesDocItm,
  cast( a.mat_pspnr as fis_invspstock_wbsint_no_conv preserving type ) AS InvtrySpclStockWBSElmntIntID,
  cast( a.mat_ps_posid as fis_invspstock_wbs_no_conv preserving type ) AS InventorySpclStockWBSElement,
  cast( a.bwtar as fis_bwtar_d preserving type ) AS InventoryValuationType,
  cast(a.mlptyp as fml_process_type preserving type ) AS MaterialLedgerProcessType,
  cast(a.mlcateg as fml_category preserving type ) AS MaterialLedgerCategory,
  cast(a.hvkwrt as fis_lcrcy_sp_value preserving type ) AS SlsPriceAmountInCoCodeCrcy,
  cast(a.vprsv as fml_price_control preserving type ) AS ProductPriceControl,
  cast(a.bukrs_sender as fis_bukrs_sender preserving type ) AS SenderCompanyCode,
  cast( a.accas_sender as fis_accas_sender preserving type ) AS SenderAccountAssignment,
  cast( a.accasty_sender as fis_accasty_sender preserving type ) AS SenderAccountAssignmentType,
  cast( a.objnr as fis_objnr preserving type) AS ControllingObject,
  cast( a.co_belkz as fis_co_belkz preserving type ) AS ControllingDebitCreditCode,
  cast( a.beltp as fis_bp_inout preserving type ) AS ControllingObjectDebitType,
  cast( a.gkoar as fis_gkoar preserving type ) AS OffsettingAccountType,
  cast( a.ktopl as fis_offsettingktopl preserving type ) AS OffsettingChartOfAccounts,
  cast( a.pbukrs as fis_pbukrs preserving type ) AS PartnerCompanyCode,
  cast( a.ps_psp_pnr as fis_wbsint_no_conv preserving type ) AS WBSElementInternalID,
  cast( a.ps_posid as fis_wbs_no_conv preserving type ) AS WBSElement,
  cast( a.pps_psp_pnr as fis_partner_wbsint_no_conv preserving type ) AS PartnerWBSElementInternalID,
  cast( a.pps_posid as fis_partner_wbs_no_conv preserving type ) AS PartnerWBSElement,
  cast( a.ps_prj_pnr as fis_projectint_no_conv preserving type ) AS ProjectInternalID,
  cast( a.ps_pspid as fis_project_no_conv preserving type ) AS Project,
  cast( a.pps_prj_pnr as fis_part_projectint_no_conv preserving type ) AS PartnerProjectInternalID,
  cast( a.pps_pspid as fis_part_project_no_conv preserving type ) AS PartnerProject,
  cast( a.qmnum as fis_qmnum preserving type ) AS CustomerServiceNotification,
  cast( a.pservice_doc_type as fis_psrvdoc_type preserving type ) AS PartnerServiceDocumentType,
  cast( a.pservice_doc_id as fis_psrvdoc_id preserving type ) AS PartnerServiceDocument,
  cast( a.pservice_doc_item_id as fis_psrvdoc_item_id preserving type ) AS PartnerServiceDocumentItem,
  cast( a.ps_posid as /cpd/plan_item_id ) AS WorkPackage,
  cast( a.pnplnr as fis_par_npln preserving type ) AS PartnerProjectNetwork,
  cast( a.pprznr as fis_par_prznr preserving type ) AS PartnerBusinessProcess,
  cast( a.co_buzei as co_buzei_acd preserving type ) AS ControllingDocumentItem,
  cast( a.land1 as fis_land1_gp preserving type ) AS CustomerSupplierCountry,
  cast( a.brsch as fis_brsch preserving type ) AS CustomerSupplierIndustry,
  cast( a.konzs as fis_konzs preserving type ) AS CustomerSupplierCorporateGroup,
  cast( a.sbudget_pd as fis_fm_pbudget_period preserving type ) AS PartnerBudgetPeriod,
  cast( a.egrup as jv_egroup_cds preserving type ) AS JointVentureEquityGroup,
  cast( a.recid as jv_recind_cds preserving type ) AS JointVentureCostRecoveryCode,
  cast( a.vptnr as jv_part_cds preserving type ) AS JointVenturePartner,
  cast( a.btype as jv_bilind_cds preserving type ) AS JointVentureBillingType,
  cast( a.etype as jv_etype_cds preserving type ) AS JointVentureEquityType,
  cast( a.prodper as jv_prodper_cds preserving type ) AS JointVentureProductionDate,
  cast( a.billm as jv_billm_cds preserving type ) AS JointVentureBillingDate,
  cast( a.pom as jv_pom_cds preserving type ) AS JointVentureOperationalDate,
  cast( a.cbrunid as jv_cbrunid_cds preserving type ) AS CutbackRun,
  cast( a.jvactivity as jv_activity_cds preserving type ) AS JointVentureAccountingActivity,
  cast( a.pvname as jv_pvname_cds preserving type ) AS PartnerVenture,
  cast( a.pegrup as jv_pegrup_cds preserving type ) AS PartnerEquityGroup,
  cast( a.s_recind as jv_srecind_cds preserving type ) AS SenderCostRecoveryCode,
  cast( a.cbracct as jv_cbracct_cds preserving type ) AS CutbackAccount,
  cast( a.cbobjnr as jv_cbobjnr_cds preserving type ) AS CutbackCostObject,
  cast( a.dabrz as fis_dabrbez preserving type ) AS SettlementReferenceDate,
  cast( a.valobjtype as fis_val_obj_type preserving type ) AS FinancialValuationObjectType,
  cast( a.valobj_id as fis_val_obj_id preserving type ) AS FinancialValuationObject,
  cast( a.valsobj_id as fis_val_subobj_id preserving type ) AS FinancialValuationSubobject,
  cast( a.uvorn as fis_uvorn_no_conv preserving type ) AS OrderSuboperation,
  cast( a.matkl_mm as fis_matkl_mm preserving type ) AS ProductGroup,
  cast( a.vornr_org as fis_origin_order_operation preserving type) AS OriginOrderOperation,
  a.rldnr AS SourceLedger,
  a.rbukrs AS CompanyCode,
  a.gjahr AS FiscalYear,
  a.belnr AS AccountingDocument,
  a.docln AS LedgerGLLineItem,
  a.ryear AS LedgerFiscalYear,
  a.rrcty AS GLRecordType,
  a.docnr_ld AS JrnlEntrAltvFYConsecutiveID,
  a.ktopl AS ChartOfAccounts,
  a.kokrs AS ControllingArea,
  a.rmvct AS FinancialTransactionType,
  a.vorgn AS GLBusinessTransactionType,
  a.bttype AS BusinessTransactionCategory,
  a.cbttype AS BusinessTransactionType,
  a.closingstep AS FinancialClosingStep,
  a.vrgng AS ControllingBusTransacType,
  a.awtyp AS ReferenceDocumentType,
  a.awsys AS LogicalSystem,
  a.aworg AS ReferenceDocumentContext,
  a.awref AS ReferenceDocument,
  a.subta AS TransactionSubitem,
  a.xreversing AS IsReversal,
  a.xreversed AS IsReversed,
  a.xtruerev AS IsTrueReversed,
  a.subta_rev AS ReversalTransactionSubitem,
  a.xsettling AS IsSettlement,
  a.xsettled AS IsSettled,
  a.prec_gjahr AS PrdcssrJournalEntryFiscalYear,
  a.obs_reason AS JrnlEntryItemObsoleteReason,
  a.xsecondary AS JournalEntryIsSecondaryEntry,
  a.closing_run_id AS JrnlPeriodEndClosingRunLogUUID,
  a.orgl_change AS OrganizationalChange,
  a.racct AS GLAccount,
  a.rcntr AS CostCenter,
  a.prctr AS ProfitCenter,
  a.rfarea AS FunctionalArea,
  a.rbusa AS BusinessArea,
  a.segment AS Segment,
  a.scntr AS PartnerCostCenter,
  a.pprctr AS PartnerProfitCenter,
  a.sfarea AS PartnerFunctionalArea,
  a.sbusa AS PartnerBusinessArea,
  a.rassc AS PartnerCompany,
  a.psegment AS PartnerSegment,
  a.rtcur AS BalanceTransactionCurrency,
  a.tsl AS AmountInBalanceTransacCrcy,
  a.rwcur AS TransactionCurrency,
  a.wsl AS AmountInTransactionCurrency,
  a.rhcur AS CompanyCodeCurrency,
  a.hsl AS AmountInCompanyCodeCurrency,
  a.rkcur AS GlobalCurrency,
  a.ksl AS AmountInGlobalCurrency,
  a.rfccur AS FunctionalCurrency,
  a.fcsl AS AmountInFunctionalCurrency,
  a.rocur AS FreeDefinedCurrency1,
  a.osl AS AmountInFreeDefinedCurrency1,
  a.rvcur AS FreeDefinedCurrency2,
  a.vsl AS AmountInFreeDefinedCurrency2,
  a.bsl AS AmountInFreeDefinedCurrency3,
  a.csl AS AmountInFreeDefinedCurrency4,
  a.dsl AS AmountInFreeDefinedCurrency5,
  a.esl AS AmountInFreeDefinedCurrency6,
  a.rfcur AS FreeDefinedCurrency7,
  a.fsl AS AmountInFreeDefinedCurrency7,
  a.gsl AS AmountInFreeDefinedCurrency8,
  a.kfsl AS FixedAmountInGlobalCrcy,
  a.psl AS TotalPriceVarcInGlobalCrcy,
  a.pfsl AS FixedPriceVarcInGlobalCrcy,
  a.rco_ocur AS ControllingObjectCurrency,
  a.rgm_ocur AS GrantCurrency,
  a.gm_osl AS AmountInGrantCurrency,
  a.runit AS BaseUnit,
  a.msl AS Quantity,
  a.rvunit AS CostSourceUnit,
  a.rrunit AS ReferenceQuantityUnit,
  a.rmsl AS ReferenceQuantity,
  a.co_meinh AS IncmpltSummableValnQtyUnt,
  a.co_megbtr AS IncmpltSummableValnQty,
  a.co_mefbtr AS IncmpltSummableValnFxdQty,
  a.drcrk AS DebitCreditCode,
  a.poper AS FiscalPeriod,
  a.periv AS FiscalYearVariant,
  a.fiscyearper AS FiscalYearPeriod,
  a.budat AS PostingDate,
  a.bldat AS DocumentDate,
  a.blart AS AccountingDocumentType,
  a.buzei AS AccountingDocumentItem,
  a.zuonr AS AssignmentReference,
  a.bstat AS AccountingDocumentCategory,
  a.linetype AS JournalEntryItemCategory,
  a.bschl AS PostingKey,
  a.ktosl AS TransactionTypeDetermination,
  a.slalittype AS SubLedgerAcctLineItemType,
  a.usnam AS AccountingDocCreatedByUser,
  a.rhoart AS OriginObjectType,
  a.glaccount_type AS GLAccountType,
  a.ktop2 AS CountryChartOfAccounts,
  a.rbunit AS ConsolidationUnit,
  a.rbuptr AS PartnerConsolidationUnit,
  a.ritclg AS ConsolidationChartOfAccounts,
  a.ritem AS CnsldtnFinancialStatementItem,
  a.sityp AS CnsldtnSubitemCategory,
  a.subit AS CnsldtnSubitem,
  a.rebzg AS InvoiceReference,
  a.rebzj AS InvoiceReferenceFiscalYear,
  a.rebzz AS InvoiceItemReference,
  a.rbest AS ReferencePurchaseOrderCategory,
  a.ebeln AS PurchasingDocument,
  a.ebelp AS PurchasingDocumentItem,
  a.sgtxt AS DocumentItemText,
  a.werks AS Plant,
  a.lifnr AS Supplier,
  a.kunnr AS Customer,
  a.fbuda AS ServicesRenderedDate,
  a.perop_beg AS PerformancePeriodStartDate,
  a.perop_end AS PerformancePeriodEndDate,
  a.coco_num AS ConditionContract,
  a.wwert AS ExchangeRateDate,
  a.koart AS FinancialAccountType,
  a.umskz AS SpecialGLCode,
  a.mwskz AS TaxCode,
  a.tax_country AS TaxCountry,
  a.hbkid AS HouseBank,
  a.hktid AS HouseBankAccount,
  a.xopvw AS IsOpenItemManaged,
  a.augdt AS ClearingDate,
  a.auggj AS ClearingJournalEntryFiscalYear,
  a.augbl AS ClearingJournalEntry,
  a.valut AS ValueDate,
  a.aging AS GeneralLedgerAgingScope,
  a.aging_incrmnt AS GeneralLedgerAgingIncrement,
  a.afabe AS AssetDepreciationArea,
  a.anln1 AS MasterFixedAsset,
  a.anln2 AS FixedAsset,
  a.bzdat AS AssetValueDate,
  a.anbwa AS AssetTransactionType,
  a.movcat AS AssetAcctTransClassfctn,
  a.depr_period AS DepreciationFiscalPeriod,
  a.anlgr AS GroupMasterFixedAsset,
  a.anlgr2 AS GroupFixedAsset,
  a.anlkl AS AssetClass,
  a.panl1 AS PartnerMasterFixedAsset,
  a.panl2 AS PartnerFixedAsset,
  a.kalnr AS CostEstimate,
  a.mat_lifnr AS InventorySpecialStockSupplier,
  a.bwkey AS ValuationArea,
  a.racct_sender AS SenderGLAccount,
  a.hkgrp AS CostOriginGroup,
  a.uspob AS OriginSenderObject,
  a.co_beknz AS OriginCtrlgDebitCreditCode,
  a.muvflg AS QuantityIsIncomplete,
  a.gkont AS OffsettingAccount,
  a.erlkz AS LineItemIsCompleted,
  a.pernr AS PersonnelNumber,
  a.scope AS ControllingObjectClass,
  a.pscope AS PartnerControllingObjectClass,
  a.uprctr AS OriginProfitCenter,
  a.aufnr_org AS OriginOrder,
  a.ulstar AS OriginCostCtrActivityType,
  a.ukostl AS OriginCostCenter,
  a.umatnr AS OriginProduct,
  a.varc_uacct AS VarianceOriginGLAccount,
  a.accas AS AccountAssignment,
  a.accasty AS AccountAssignmentType,
  a.lstar AS CostCtrActivityType,
  a.aufnr AS OrderID,
  a.autyp AS OrderCategory,
  a.erkrs AS OperatingConcern,
  a.nplnr AS ProjectNetwork,
  a.nplnr_vorgn AS RelatedNetworkActivity,
  a.prznr AS BusinessProcess,
  a.kstrg AS CostObject,
  a.bemot AS BillableControl,
  a.rsrce AS CostAnalysisResource,
  a.service_doc_type AS ServiceDocumentType,
  a.service_doc_id AS ServiceDocument,
  a.service_doc_item_id AS ServiceDocumentItem,
  a.service_contract_type AS ServiceContractType,
  a.service_contract_id AS ServiceContract,
  a.service_contract_item_id AS ServiceContractItem,
  a.solution_order_id AS BusinessSolutionOrder,
  a.solution_order_item_id AS BusinessSolutionOrderItem,
  a.vtkey AS ProviderContract,
  a.vtpos AS ProviderContractItem,
  a.ra_contract_id AS RevenueAccountingContract,
  a.ra_pob_id AS PerformanceObligation,
  a.overtimecat AS TimeSheetOvertimeCategory,
  a.paccas AS PartnerAccountAssignment,
  a.paccasty AS PartnerAccountAssignmentType,
  a.co_accasty_n1 AS StstclAccountAssignmentType1,
  a.co_accasty_n2 AS StstclAccountAssignmentType2,
  a.co_accasty_n3 AS StstclAccountAssignmentType3,
  a.work_item_id AS WorkItem,
  a.plstar AS PartnerCostCtrActivityType,
  a.paufnr AS PartnerOrder,
  a.pautyp AS PartnerOrderCategory,
  a.pkdauf AS PartnerSalesDocument,
  a.pkdpos AS PartnerSalesDocumentItem,
  a.pnplnr_vorgn AS PartnerProjectNetworkActivity,
  a.pkstrg AS PartnerCostObject,
  a.varc_hkgrp AS VarianceOriginGroup,
  a.fkart AS BillingDocumentType,
  a.vkorg AS SalesOrganization,
  a.vtweg AS DistributionChannel,
  a.spart AS OrganizationDivision,
  a.matnr_copa AS SoldProduct,
  a.matkl AS SoldProductGroup,
  a.kdgrp AS CustomerGroup,
  a.bzirk AS SalesDistrict,
  a.kunre AS BillToParty,
  a.kunwe AS ShipToParty,
  a.re_bukrs AS CashLedgerCompanyCode,
  a.re_account AS CashLedgerAccount,
  a.fikrs AS FinancialManagementArea,
  a.fipex AS CommitmentItem,
  a.fistl AS FundsCenter,
  a.measure AS FundedProgram,
  a.rfund AS Fund,
  a.rgrant_nbr AS GrantID,
  a.rbudget_pd AS BudgetPeriod,
  a.sfund AS PartnerFund,
  a.sgrant_nbr AS PartnerGrant,
  a.bdgt_account AS PubSecBudgetAccount,
  a.bdgt_account_cocode AS PubSecBudgetAccountCoCode,
  a.bdgt_cnsmpn_date AS PubSecBudgetCnsmpnDate,
  a.bdgt_cnsmpn_period AS PubSecBudgetCnsmpnFsclPeriod,
  a.bdgt_cnsmpn_year AS PubSecBudgetCnsmpnFsclYear,
  a.bdgt_relevant AS PubSecBudgetIsRelevant,
  a.bdgt_cnsmpn_type AS PubSecBudgetCnsmpnType,
  a.bdgt_cnsmpn_amount_type AS PubSecBudgetCnsmpnAmtType,
  a.rsponsored_prog AS SponsoredProgram,
  a.rsponsored_class AS SponsoredClass,
  a.rbdgt_vldty_nbr AS GteeMBudgetValidityNumber,
  a.kblnr AS EarmarkedFundsDocument,
  a.kblpos AS EarmarkedFundsDocumentItem,
  a.fs_product_group AS FinancialServicesProductGroup,
  a.branch_id AS FinancialServicesBranch,
  a.datasource_id AS FinancialDataSource,
  a.vname AS JointVenture,
  a.swenr AS REBusinessEntity,
  a.sgenr AS RealEstateBuilding,
  a.sgrnr AS RealEstateProperty,
  a.smenr AS RERentalObject,
  a.recnnr AS RealEstateContract,
  a.snksl AS REServiceChargeKey,
  a.sempsl AS RESettlementUnitID,
  a.pswenr AS REPartnerBusinessEntity,
  a.psgenr AS RealEstatePartnerBuilding,
  a.psgrnr AS RealEstatePartnerProperty,
  a.psmenr AS REPartnerRentalObject,
  a.precnnr AS RealEstatePartnerContract,
  a.psnksl AS REPartnerServiceChargeKey,
  a.psempsl AS REPartnerSettlementUnitID,
  a.pdabrz AS PartnerSettlementReferenceDate,
  a.acrobjtype AS AccrualObjectType,
  a.acrlogsys AS AccrualObjectLogicalSystem,
  a.acrobj_id AS AccrualObject,
  a.acrsobj_id AS AccrualSubobject,
  a.acritmtype AS AccrualItemType,
  a.acrrefobj_id AS AccrualReferenceObject,
  a.acrvaldat AS AccrualValueDate,
  a.netdt AS NetDueDate,
  a.risk_class AS CreditRiskClass,
  a.arbid AS WorkCenterInternalID,
  a.vornr AS OrderOperation,
  a.aufps AS OrderItem,
  a.paufps AS PartnerOrderItem,
  a.equnr AS Equipment,
  a.tplnr AS FunctionalLocation,
  a.istru AS Assembly,
  a.ilart AS MaintenanceActivityType,
  a.plknz AS MaintenanceOrderPlanningCode,
  a.artpr AS MaintPriorityType,
  a.priok AS MaintPriority,
  a.maufnr AS SuperiorOrder,
  a.planned_parts_work AS MaintenanceOrderIsPlanned,
  b.rcomp AS Company
FROM acdoca AS a
INNER JOIN t001 AS b ON /* join condition not captured in parsed metadata */
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]
;