I_OperationalAcctgDocItem

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_OperationalAcctgDocItem.
-- 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_OperationalAcctgDocItem AS
SELECT
  belnr AS AccountingDocument,
  gjahr AS FiscalYear,
  buzei AS AccountingDocumentItem,
  ktopl AS ChartOfAccounts,
  buzid AS AccountingDocumentItemType,
  augdt AS ClearingDate,
  augcp AS ClearingCreationDate,
  auggj AS ClearingJournalEntryFiscalYear,
  cast( auggj as fis_auggj_no_conv_depre preserving type ) AS ClearingDocFiscalYear,
  augbl AS ClearingJournalEntry,
  cast( augbl as fis_augbl_depre preserving type ) AS ClearingAccountingDocument,
  bschl AS PostingKey,
  koart AS FinancialAccountType,
  umskz AS SpecialGLCode,
  umsks AS SpecialGLTransactionType,
  shkzg AS DebitCreditCode,
  gsber AS BusinessArea,
  pargb AS PartnerBusinessArea,
  mwskz AS TaxCode,
  tax_country AS TaxCountry,
  txdat_from AS TaxRateValidityStartDate,
  qsskz AS WithholdingTaxCode,
  mwart AS TaxType,
  txgrp AS TaxItemGroup,
  ktosl AS TransactionTypeDetermination,
  valut AS ValueDate,
  zuonr AS AssignmentReference,
  sgtxt AS DocumentItemText,
  vbund AS PartnerCompany,
  bewar AS FinancialTransactionType,
  altkt AS CorporateGroupAccount,
  fdlev AS PlanningLevel,
  kokrs AS ControllingArea,
  kostl AS CostCenter,
  projn AS Project,
  aufnr AS OrderID,
  vbeln AS BillingDocument,
  vbel2 AS SalesDocument,
  posn2 AS SalesDocumentItem,
  eten2 AS ScheduleLine,
  service_doc_type AS ServiceDocumentType,
  service_doc_id AS ServiceDocument,
  service_doc_item_id AS ServiceDocumentItem,
  anln1 AS MasterFixedAsset,
  anln2 AS FixedAsset,
  anbwa AS AssetTransactionType,
  bzdat AS AssetValueDate,
  pernr AS PersonnelNumber,
  xumsw AS IsSalesRelated,
  xkres AS LineItemDisplayIsEnabled,
  xopvw AS IsOpenItemManaged,
  cast( xcpdd as farp_xcpdd ) AS AddressAndBankIsSetManually,
  xanet AS DownPaymentIsNetProcedure,
  xskrl AS IsNotCashDiscountLiable,
  xauto AS IsAutomaticallyCreated,
  xzahl AS IsUsedInPaymentTransaction,
  saknr AS OperationalGLAccount,
  hkont AS GLAccount,
  kunnr AS Customer,
  lifnr AS Supplier,
  filkd AS BranchAccount,
  xbilk AS IsBalanceSheetAccount,
  gvtyp AS ProfitLossAccountType,
  hzuon AS SpecialGLAccountAssignment,
  zfbdt AS DueCalculationBaseDate,
  zterm AS PaymentTerms,
  zbd1t AS CashDiscount1Days,
  zbd2t AS CashDiscount2Days,
  zbd3t AS NetPaymentDays,
  zbd1p AS CashDiscount1Percent,
  zbd2p AS CashDiscount2Percent,
  zlsch AS PaymentMethod,
  zlspr AS PaymentBlockingReason,
  zbfix AS FixedCashDiscount,
  hbkid AS HouseBank,
  bvtyp AS BPBankAccountInternalID,
  mwsk1 AS TaxDistributionCode1,
  mwsk2 AS TaxDistributionCode2,
  mwsk3 AS TaxDistributionCode3,
  rebzg AS InvoiceReference,
  rebzj AS InvoiceReferenceFiscalYear,
  rebzz AS InvoiceItemReference,
  rebzt AS FollowOnDocumentType,
  lzbkz AS StateCentralBankPaymentReason,
  landl AS SupplyingCountry,
  diekz AS RecrrgSuplrInvcIsSrvcInvoice,
  samnr AS InvoiceList,
  disbn AS BillOfExchangeUsageDocument,
  wverw AS BillOfExchangeUsage,
  mschl AS DunningKey,
  mansp AS DunningBlockingReason,
  madat AS LastDunningDate,
  manst AS DunningLevel,
  maber AS DunningArea,
  esrnr AS PaytSlipWthRefSubscriber,
  esrre AS PaytSlipWthRefReference,
  esrpz AS PaytSlipWthRefCheckDigit,
  qsznr AS WithholdingTaxCertificate,
  matnr AS Material,
  cast( matnr as productnumber ) AS Product,
  werks AS Plant,
  ebeln AS PurchasingDocument,
  ebelp AS PurchasingDocumentItem,
  zekkn AS AccountAssignmentNumber,
  elikz AS IsCompletelyDelivered,
  vprsv AS MaterialPriceControl,
  bwkey AS ValuationArea,
  bwtar AS InventoryValuationType,
  egbld AS DelivOfGoodsDestCountry,
  eglld AS DelivOfGoodsOriginCountry,
  rstgr AS PaymentDifferenceReason,
  prctr AS ProfitCenter,
  vname AS JointVenture,
  recid AS JointVentureCostRecoveryCode,
  egrup AS JointVentureEquityGroup,
  cast( vptnr as jv_part_cds preserving type ) AS JointVenturePartner,
  vertt AS TreasuryContractType,
  vertn AS AssetContract,
  vbewa AS CashFlowType,
  cast( imkey as recaimkeyfi preserving type ) AS REInternalFinNumber,
  imkey AS RealEstateObject,
  dabrz AS SettlementReferenceDate,
  fipos AS CommitmentItem,
  cast( fipos as fis_fipos_shortid preserving type ) AS CommitmentItemShortID,
  kstrg AS CostObject,
  nplnr AS ProjectNetwork,
  aufpl AS OrderInternalBillOfOperations,
  aplzl AS OrderIntBillOfOperationsItem,
  cast( projk as fis_wbsint_no_conv preserving type ) AS WBSElementInternalID,
  cast( case when paobjnr > '9999999999' then '9999999999' else lpad( paobjnr, 10, '0' ) end as rkeobjnr_numc ) AS ProfitabilitySegment,
  cast( paobjnr as rkeobjnr_char ) AS ProfitabilitySegment_2,
  cast( btype as jv_bilind_cds preserving type ) AS JointVentureBillingType,
  etype AS JointVentureEquityType,
  xegdr AS IsEUTriangularDeal,
  hrkft AS CostOriginGroup,
  hwmet AS CompanyCodeCurrencyDetnMethod,
  xragl AS ClearingIsReversed,
  uzawe AS PaymentMethodSupplement,
  lokkt AS AlternativeGLAccount,
  fistl AS FundsCenter,
  geber AS Fund,
  stbuk AS TaxCompanyCode,
  pprct AS PartnerProfitCenter,
  xref1 AS Reference1IDByBusinessPartner,
  xref2 AS Reference2IDByBusinessPartner,
  kblnr AS EarmarkedFundsDocument,
  kblpos AS EarmarkedFundsDocumentItem,
  rfzei AS PaymentCardItem,
  ccbtc AS PaymentCardPaymentSettlement,
  empfb AS AlternativePayeePayer,
  xref3 AS Reference3IDByBusinessPartner,
  dtws1 AS DataExchangeInstruction1,
  dtws2 AS DataExchangeInstruction2,
  dtws3 AS DataExchangeInstruction3,
  dtws4 AS DataExchangeInstruction4,
  grirg AS Region,
  xpypr AS HasPaymentOrder,
  kidno AS PaymentReference,
  txdat AS TaxDeterminationDate,
  agzei AS ClearingItem,
  bupla AS BusinessPlace,
  secco AS TaxSection,
  lstar AS CostCtrActivityType,
  cession_kz AS AccountsReceivableIsPledged,
  cast( cession_kz as fis_cession_kz_code preserving type ) AS AcctsReceivablePledgingCode,
  prznr AS BusinessProcess,
  grant_nbr AS GrantID,
  fkber_long AS FunctionalArea,
  gmvkz AS CustomerIsInExecution,
  measure AS FundedProgram,
  docln AS LedgerGLLineItem,
  Segment,
  psegment AS PartnerSegment,
  pfkber AS PartnerFunctionalArea,
  hktid AS HouseBankAccount,
  kstar AS CostElement,
  taxps AS TaxItemAcctgDocItemRef,
  pays_prov AS PaymentServiceProvider,
  pays_tran AS PaymentRefByPaytSrvcProvider,
  mndid AS SEPAMandate,
  awtyp AS ReferenceDocumentType,
  awkey AS OriginalReferenceDocument,
  awsys AS ReferenceDocumentLogicalSystem,
  posnr AS AccountingDocumentItemRef,
  h_monat AS FiscalPeriod,
  h_bstat AS AccountingDocumentCategory,
  h_budat AS PostingDate,
  h_bldat AS DocumentDate,
  h_blart AS AccountingDocumentType,
  netdt AS NetDueDate,
  sk1dt AS CashDiscount1DueDate,
  sk2dt AS CashDiscount2DueDate,
  gkont AS OffsettingAccount,
  gkart AS OffsettingAccountType,
  gktopl AS OffsettingChartOfAccounts,
  pgeber AS PartnerFund,
  pgrant_nbr AS PartnerGrant,
  budget_pd AS BudgetPeriod,
  pbudget_pd AS PartnerBudgetPeriod,
  j_1tpbupl AS BranchCode,
  cast( prodper as jv_prodper_cds preserving type ) AS JointVentureProductionDate,
  glo_ref1 AS OplAcctgDocItmCntrySpcfcRef1,
  payt_rsn AS PaymentReason,
  re_bukrs AS CashLedgerCompanyCode,
  re_account AS CashLedgerAccount,
  bdgt_account_cocode AS PubSecBudgetAccountCoCode,
  bdgt_account AS PubSecBudgetAccount,
  FS_PRODUCT_GROUP AS FinancialServicesProductGroup,
  BRANCH_ID AS FinancialServicesBranch,
  DATASOURCE_ID AS FinancialDataSource,
  kdgrp AS CustomerGroup,
  land1 AS CustomerSupplierCountry,
  brsch AS CustomerSupplierIndustry,
  h_hwaer AS CompanyCodeCurrency,
  dmbtr_shl AS AmountInCompanyCodeCurrency,
  rfccur AS FunctionalCurrency,
  fcsl_shl AS AmountInFunctionalCurrency,
  mwsts_shl AS TaxAmountInCoCodeCrcy,
  hwbas_shl AS TaxBaseAmountInCoCodeCrcy,
  bdiff_shl AS ValuationDiffAmtInCoCodeCrcy,
  sknto_shl AS CashDiscountAmtInCoCodeCrcy,
  dmbt1_shl AS TaxBrkdwnAmount1InCoCodeCrcy,
  dmbt2_shl AS TaxBrkdwnAmount2InCoCodeCrcy,
  dmbt3_shl AS TaxBrkdwnAmount3InCoCodeCrcy,
  navhw_shl AS NonDcblTaxAmountInCoCodeCrcy,
  rewrt_shl AS InvoiceAmtInCoCodeCrcy,
  h_waers AS TransactionCurrency,
  wrbtr_shl AS AmountInTransactionCurrency,
  txbfw_shl AS OriginalTaxBaseAmount,
  wmwst_shl AS TaxAmount,
  fwbas_shl AS TaxBaseAmountInTransCrcy,
  qsshb_shl AS WithholdingTaxBaseAmount,
  fdwbt_shl AS PlannedAmtInTransactionCrcy,
  skfbt_shl AS CashDiscountBaseAmount,
  wskto_shl AS CashDiscountAmount,
  nebtr_shl AS NetPaymentAmount,
  wrbt1_shl AS TaxBrkdwnAmount1InTransCrcy,
  wrbt2_shl AS TaxBrkdwnAmount2InTransCrcy,
  wrbt3_shl AS TaxBrkdwnAmount3InTransCrcy,
  qbshb_shl AS WithholdingTaxAmount,
  qsfbt_shl AS WithholdingTaxExemptionAmt,
  navfw_shl AS NonDcblTaxAmountInTransCrcy,
  rewwr_shl AS InvoiceAmountInFrgnCurrency,
  pswsl AS BalanceTransactionCurrency,
  pswbt_shl AS AmountInBalanceTransacCrcy,
  h_hwae2 AS AdditionalCurrency1,
  bdif2_shl AS ValuationDiffAmtInAddlCrcy1,
  dmbe2_shl AS AmountInAdditionalCurrency1,
  mwst2_shl AS TaxAmountInAdditionalCurrency1,
  h_hwae3 AS AdditionalCurrency2,
  dmbe3_shl AS AmountInAdditionalCurrency2,
  mwst3_shl AS TaxAmountInAdditionalCurrency2,
  bdif3_shl AS ValuationDiffAmtInAddlCrcy2,
  pycur AS PaymentCurrency,
  pyamt_shl AS AmountInPaymentCurrency,
  t014_waers AS CreditControlAreaCurrency,
  absbt_shl AS HedgedAmount,
  meins AS BaseUnit,
  menge AS Quantity,
  erfme AS GoodsMovementEntryUnit,
  erfmg AS QuantityInEntryUnit,
  bprme AS PurchasingDocumentPriceUnit,
  bpmng AS PurchaseOrderQty,
  peinh AS MaterialPriceUnitQty,
  nbritm AS NumberOfItems,
  kblnr AS EarmarkedFunds,
  kblpos AS EarmarkedFundsItem,
  gst_part AS IN_GSTPartner,
  plc_sup AS IN_GSTPlaceOfSupply,
  hsn_sac AS IN_HSNOrSACCode,
  txbhw_shl AS OriglTaxBaseAmountInCoCodeCrcy,
  txbh2_shl AS OriginalTaxBaseAmtInAddlCrcy1,
  txbh3_shl AS OriginalTaxBaseAmtInAddlCrcy2,
  cast( '' as brgru) AS GLAccountAuthorizationGroup,
  cast( '' as brgru) AS SupplierBasicAuthorizationGrp,
  cast( '' as brgru) AS CustomerBasicAuthorizationGrp,
  cast( '' as brgru) AS AcctgDocTypeAuthorizationGroup,
  cast( '' as aufart) AS OrderType,
  cast( '' as auart) AS SalesOrderType,
  cast( '' as anlkl) AS AssetClass,
  P_BSEG_COM.bukrs AS CompanyCode,
  P_BSEG_COM.stceg AS VATRegistration,
  P_BSEG_COM.txjcd AS TaxJurisdiction,
  P_BSEG_COM.xnegp AS IsNegativePosting,
  P_BSEG_COM.kkber AS CreditControlArea,
  P_BSEG_COM.dmbtr AS AbsoluteAmountInCoCodeCrcy,
  P_BSEG_COM.wrbtr AS AbsoluteAmountInTransacCrcy,
  P_BSEG_COM.dmbe2 AS AbsltAmtInAdditionalCurrency1,
  P_BSEG_COM.dmbe3 AS AbsltAmtInAdditionalCurrency2,
  P_BSEG_COM.pswbt AS AbsltAmtInBalanceTransacCrcy,
  P_BSEG_COM.fcsl AS AbsltAmtInFunctionalCurrency,
  P_BSEG_COM.pyamt AS AbsltAmountInPaymentCurrency,
  P_BSEG_COM.absbt AS HedgedAbsoluteAmount,
  P_BSEG_COM.fdwbt AS PlannedAbsltAmtInTransCrcy,
  P_BSEG_COM.sknto AS CashDiscAbsltAmtInCoCodeCrcy,
  P_BSEG_COM.wskto AS CashDiscountAbsoluteAmount,
  P_BSEG_COM.skfbt AS CashDiscountAbsoluteBaseAmount,
  P_BSEG_COM.rewrt AS InvoiceAbsltAmtInCoCodeCrcy,
  P_BSEG_COM.rewwr AS InvoiceAbsltAmtInFrgnCurrency,
  P_BSEG_COM.nebtr AS NetPaymentAbsoluteAmount,
  P_BSEG_COM.navhw AS NonDcblTaxAbsltAmtInCoCodeCrcy,
  P_BSEG_COM.navfw AS NonDcblTaxAbsltAmtInTransCrcy,
  P_BSEG_COM.mwsts AS TaxAbsltAmountInCoCodeCrcy,
  P_BSEG_COM.wmwst AS TaxAbsoluteAmount,
  P_BSEG_COM.mwst2 AS TaxAbsltAmtInAddlCurrency1,
  P_BSEG_COM.mwst3 AS TaxAbsltAmtInAddlCurrency2,
  P_BSEG_COM.hwbas AS TaxAbsltBaseAmountInCoCodeCrcy,
  P_BSEG_COM.fwbas AS TaxAbsltBaseAmountInTransCrcy,
  P_BSEG_COM.txbhw AS OriglTxAbsltBaseAmountInCCCrcy,
  P_BSEG_COM.txbfw AS OriginalTaxAbsoluteBaseAmount,
  P_BSEG_COM.txbh2 AS OriglTxAbsltBaseAmtInAddlCrcy1,
  P_BSEG_COM.txbh3 AS OriglTxAbsltBaseAmtInAddlCrcy2,
  P_BSEG_COM.dmbt1 AS TaxBrkdwnAbsltAmt1InCoCodeCrcy,
  P_BSEG_COM.dmbt2 AS TaxBrkdwnAbsltAmt2InCoCodeCrcy,
  P_BSEG_COM.dmbt3 AS TaxBrkdwnAbsltAmt3InCoCodeCrcy,
  P_BSEG_COM.wrbt1 AS TaxBrkdwnAbsltAmt1InTransCrcy,
  P_BSEG_COM.wrbt2 AS TaxBrkdwnAbsltAmt2InTransCrcy,
  P_BSEG_COM.wrbt3 AS TaxBrkdwnAbsltAmt3InTransCrcy,
  P_BSEG_COM.qbshb AS WithholdingTaxAbsoluteAmount,
  P_BSEG_COM.qsshb AS WithholdingTaxAbsoluteBaseAmt,
  P_BSEG_COM.qsfbt AS WhldgTaxExemptionAbsltAmount,
  P_BSEG_COM.bdiff AS ValnDiffAbsltAmtInCoCodeCrcy,
  P_BSEG_COM.bdif2 AS ValnDiffAbsltAmtInAddlCrcy1,
  P_BSEG_COM.bdif3 AS ValnDiffAbsltAmtInAddlCrcy2,
  P_BSEG_COM.shkzg_unadjusted AS UnadjustedDebitCreditCode
FROM P_BSEG_COM
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_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingAreaText ON ControllingArea = _ControllingAreaText.ControllingArea  -- 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_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_CostCenterText AS _CostCenterText ON ControllingArea = _CostCenterText.ControllingArea AND CostCenter = _CostCenterText.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_Segment AS _Segment ON Segment = _Segment.Segment  -- association [0..1]
LEFT OUTER JOIN I_SegmentText AS _SegmentText ON Segment = _SegmentText.Segment  -- association [0..*]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _CustomerText ON Customer = _CustomerText.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_OneTimeAccountBP AS _OneTimeAccountBP ON CompanyCode = _OneTimeAccountBP.CompanyCode AND FiscalYear = _OneTimeAccountBP.FiscalYear AND AccountingDocument = _OneTimeAccountBP.AccountingDocument AND AccountingDocumentItem = _OneTimeAccountBP.AccountingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_JournalEntryItemOneTimeData AS _JournalEntryItemOneTimeData ON CompanyCode = _JournalEntryItemOneTimeData.CompanyCode AND FiscalYear = _JournalEntryItemOneTimeData.FiscalYear AND AccountingDocument = _JournalEntryItemOneTimeData.AccountingDocument AND AccountingDocumentItem = _JournalEntryItemOneTimeData.AccountingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _SupplierText ON Supplier = _SupplierText.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_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccountsText AS _ChartOfAccountsText ON ChartOfAccounts = _ChartOfAccountsText.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_AccountingDocumentType AS _AccountingDocumentType ON AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentTypeText AS _AccountingDocumentTypeText ON AccountingDocumentType = _AccountingDocumentTypeText.AccountingDocumentType  -- association [0..*]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _FunctionalCurrency ON FunctionalCurrency = _FunctionalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _BalanceTransactionCurrency ON BalanceTransactionCurrency = _BalanceTransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _AdditionalCurrency1 ON AdditionalCurrency1 = _AdditionalCurrency1.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _AdditionalCurrency2 ON AdditionalCurrency2 = _AdditionalCurrency2.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _PaymentCurrency ON PaymentCurrency = _PaymentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CreditControlAreaCurrency ON CreditControlAreaCurrency = _CreditControlAreaCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_FinancialAccountType AS _FinancialAccountType ON FinancialAccountType = _FinancialAccountType.FinancialAccountType  -- association [0..1]
LEFT OUTER JOIN I_FinancialAccountTypeText AS _FinancialAccountTypeText ON FinancialAccountType = _FinancialAccountTypeText.FinancialAccountType  -- association [0..*]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _FunctionalAreaText ON FunctionalArea = _FunctionalAreaText.FunctionalArea  -- association [0..*]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductDescription AS _ProductText ON Product = _ProductText.Product  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- 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_WBSElementByInternalKey AS _WBSElementInternalID ON WBSElementInternalID = _WBSElementInternalID.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElementInternalIDText ON WBSElementInternalID = _WBSElementInternalIDText.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicDataText ON WBSElementInternalID = _WBSElementBasicDataText.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _GoodsMovementEntryUnit ON GoodsMovementEntryUnit = _GoodsMovementEntryUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PurchasingDocumentPriceUnit ON PurchasingDocumentPriceUnit = _PurchasingDocumentPriceUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentCategory AS _AccountingDocumentCategory ON AccountingDocumentCategory = _AccountingDocumentCategory.AccountingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentCategoryT AS _AccountingDocumentCategoryT ON AccountingDocumentCategory = _AccountingDocumentCategoryT.AccountingDocumentCategory  -- association [0..*]
LEFT OUTER JOIN I_PostingKey AS _PostingKey ON PostingKey = _PostingKey.PostingKey  -- association [0..1]
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _PartnerBusinessArea ON PartnerBusinessArea = _PartnerBusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaText AS _PartnerBusinessAreaText ON PartnerBusinessArea = _PartnerBusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_Country AS _TaxCountry ON TaxCountry = _TaxCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_TaxType AS _TaxType ON TaxType = _TaxType.TaxType  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _PartnerCompany ON PartnerCompany = _PartnerCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _PartnerCompanyText ON PartnerCompany = _PartnerCompanyText.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Partnercompany AS _PartnerCompany_2 ON PartnerCompany = _PartnerCompany_2.PartnerCompany  -- association [0..1]
LEFT OUTER JOIN I_Partnercompany AS _PartnerCompanyText_2 ON PartnerCompany = _PartnerCompanyText_2.PartnerCompany  -- association [0..1]
LEFT OUTER JOIN I_Country AS _SupplyingCountry ON SupplyingCountry = _SupplyingCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_InventoryValuationType AS _InventoryValuationType ON InventoryValuationType = _InventoryValuationType.InventoryValuationType  -- association [0..1]
LEFT OUTER JOIN I_PaymentDifferenceReason AS _PaymentDifferenceReason ON PaymentDifferenceReason = _PaymentDifferenceReason.PaymentDifferenceReason AND CompanyCode = _PaymentDifferenceReason.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PaymentDifferenceReasonT AS _PaymentDifferenceReasonText ON PaymentDifferenceReason = _PaymentDifferenceReasonText.PaymentDifferenceReason AND CompanyCode = _PaymentDifferenceReasonText.CompanyCode  -- association [0..*]
LEFT OUTER JOIN I_Segment AS _PartnerSegment ON PartnerSegment = _PartnerSegment.Segment  -- association [0..1]
LEFT OUTER JOIN I_SegmentText AS _PartnerSegmentText ON PartnerSegment = _PartnerSegmentText.Segment  -- association [0..*]
LEFT OUTER JOIN I_SuplrBankDetailsByIntId AS _SupplierBankDetails ON Supplier = _SupplierBankDetails.Supplier AND BPBankAccountInternalID = _SupplierBankDetails.BPBankAccountInternalID  -- 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_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_FinancialTransactionType AS _FinancialTransactionType ON FinancialTransactionType = _FinancialTransactionType.FinancialTransactionType  -- association [0..1]
LEFT OUTER JOIN I_SalesOrder AS _SalesDocument ON SalesDocument = _SalesDocument.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesDocumentItem ON SalesDocument = _SalesDocumentItem.SalesOrder AND SalesDocumentItem = _SalesDocumentItem.SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _SalesDoc ON SalesDocument = _SalesDoc.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesDocItem ON SalesDocument = _SalesDocItem.SalesDocument AND SalesDocumentItem = _SalesDocItem.SalesDocumentItem  -- 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 _MasterFixedAssetText ON CompanyCode = _MasterFixedAssetText.CompanyCode AND MasterFixedAsset = _MasterFixedAssetText.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAssetText ON CompanyCode = _FixedAssetText.CompanyCode AND MasterFixedAsset = _FixedAssetText.MasterFixedAsset AND FixedAsset = _FixedAssetText.FixedAsset  -- 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_AssetTransactionType AS _AssetTransactionType ON AssetTransactionType = _AssetTransactionType.AssetTransactionType  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonWorkAgreement_1 ON PersonnelNumber = _PersonWorkAgreement_1.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_Employment AS _Employment ON PersonnelNumber = _Employment.EmploymentInternalID  -- association [0..1]
LEFT OUTER JOIN I_Housebank AS _HouseBank ON CompanyCode = _HouseBank.CompanyCode AND HouseBank = _HouseBank.HouseBank  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON PurchasingDocument = _PurchasingDocument.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentItem AS _PurchasingDocumentItem ON PurchasingDocument = _PurchasingDocumentItem.PurchasingDocument AND PurchasingDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_Purreqvaluationarea AS _ValuationArea ON ValuationArea = _ValuationArea.ValuationArea  -- association [0..1]
LEFT OUTER JOIN I_ProjectNetwork AS _ProjectNetwork ON ProjectNetwork = _ProjectNetwork.ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_ProjectNetwork AS _ProjectNetworkText ON ProjectNetwork = _ProjectNetworkText.ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_CostOriginGroup AS _CostOriginGroup ON ControllingArea = _CostOriginGroup.ControllingArea AND CostOriginGroup = _CostOriginGroup.CostOriginGroup  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _PartnerProfitCenter ON ControllingArea = _PartnerProfitCenter.ControllingArea AND PartnerProfitCenter = _PartnerProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ControllingArea = _ProfitCenterText.ControllingArea AND ProfitCenter = _ProfitCenterText.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenterActivityType AS _CostCtrActivityType ON ControllingArea = _CostCtrActivityType.ControllingArea AND CostCtrActivityType = _CostCtrActivityType.CostCtrActivityType  -- association [0..*]
LEFT OUTER JOIN I_BusinessProcess AS _BusinessProcess ON ControllingArea = _BusinessProcess.ControllingArea AND BusinessProcess = _BusinessProcess.BusinessProcess  -- association [0..1]
LEFT OUTER JOIN I_BusinessProcessText AS _BusinessProcessText ON ControllingArea = _BusinessProcessText.ControllingArea AND BusinessProcess = _BusinessProcessText.BusinessProcess  -- association [0..*]
LEFT OUTER JOIN I_FunctionalArea AS _PartnerFunctionalArea ON PartnerFunctionalArea = _PartnerFunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccount AS _HouseBankAccount ON CompanyCode = _HouseBankAccount.CompanyCode AND HouseBank = _HouseBankAccount.HouseBank AND HouseBankAccount = _HouseBankAccount.HouseBankAccount  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccountText AS _HouseBankAccountText ON CompanyCode = _HouseBankAccountText.CompanyCode AND HouseBank = _HouseBankAccountText.HouseBank AND HouseBankAccount = _HouseBankAccountText.HouseBankAccount  -- association [0..*]
LEFT OUTER JOIN I_ReferenceDocumentType AS _ReferenceDocumentType ON ReferenceDocumentType = _ReferenceDocumentType.ReferenceDocumentType  -- 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_ChartOfAccounts AS _OffsettingChartOfAccounts ON OffsettingChartOfAccounts = _OffsettingChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccountsText AS _OffsettingChartOfAccountsText ON OffsettingChartOfAccounts = _OffsettingChartOfAccountsText.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _OffsettingAccount ON ChartOfAccounts = _OffsettingAccount.ChartOfAccounts AND OffsettingAccount = _OffsettingAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_OffsettingAccount AS _OffsettingAccountWithBP ON OffsettingChartOfAccounts = _OffsettingAccountWithBP.ChartOfAccounts AND OffsettingAccountType = _OffsettingAccountWithBP.OffsettingAccountType AND OffsettingAccount = _OffsettingAccountWithBP.OffsettingAccount  -- association [0..1]
LEFT OUTER JOIN I_FinancialAccountType AS _OffsettingAccountType ON OffsettingAccountType = _OffsettingAccountType.FinancialAccountType  -- association [0..1]
LEFT OUTER JOIN I_FinancialAccountTypeText AS _OffsettingAccountTypeText ON OffsettingAccountType = _OffsettingAccountTypeText.FinancialAccountType  -- 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_BudgetPeriod AS _BudgetPeriod ON BudgetPeriod = _BudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriodText AS _BudgetPeriodText ON BudgetPeriod = _BudgetPeriodText.BudgetPeriod  -- association [0..*]
LEFT OUTER JOIN I_BudgetPeriod AS _PartnerBudgetPeriod ON PartnerBudgetPeriod = _PartnerBudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _Grant ON GrantID = _Grant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _PartnerGrant ON PartnerGrant = _PartnerGrant.GrantID  -- 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_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_FinServicesProductGroup AS _FinServicesProductGroup ON FinancialServicesProductGroup = _FinServicesProductGroup.FinancialServicesProductGroup  -- association [0..1]
LEFT OUTER JOIN I_FinancialServicesBranch AS _FinancialServicesBranch ON FinancialServicesBranch = _FinancialServicesBranch.FinancialServicesBranch  -- association [0..1]
LEFT OUTER JOIN I_FinancialDataSource AS _FinancialDataSource ON FinancialDataSource = _FinancialDataSource.FinancialDataSource  -- association [0..1]
LEFT OUTER JOIN I_CustomerGroup AS _CustomerGroup ON CustomerGroup = _CustomerGroup.CustomerGroup  -- association [0..1]
LEFT OUTER JOIN I_Country AS _CustomerSupplierCountry ON CustomerSupplierCountry = _CustomerSupplierCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_CustomerSupplierIndustry AS _CustomerSupplierIndustry ON CustomerSupplierIndustry = _CustomerSupplierIndustry.Industry  -- association [0..1]
;