I_ParkedOplAcctgDocItem

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_ParkedOplAcctgDocItem.
-- 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_ParkedOplAcctgDocItem AS
SELECT
  ProfitabilitySegment,
  P_ParkedOplAcctgDocItem.SourceCompanyCode AS SourceCompanyCode,
  P_ParkedOplAcctgDocItem.SourceFiscalYear AS SourceFiscalYear,
  P_ParkedOplAcctgDocItem.SourceAccountingDocument AS SourceAccountingDocument,
  P_ParkedOplAcctgDocItem.SourceAccountingDocumentItem AS SourceAccountingDocumentItem,
  P_ParkedOplAcctgDocItem.AccountAssignmentNumber AS AccountAssignmentNumber,
  P_ParkedOplAcctgDocItem.AssetContract AS AssetContract,
  P_ParkedOplAcctgDocItem.AssetTransactionType AS AssetTransactionType,
  P_ParkedOplAcctgDocItem.AssetValueDate AS AssetValueDate,
  P_ParkedOplAcctgDocItem.AssignmentReference AS AssignmentReference,
  P_ParkedOplAcctgDocItem.BaseUnit AS BaseUnit,
  P_ParkedOplAcctgDocItem.BPBankAccountInternalID AS BPBankAccountInternalID,
  P_ParkedOplAcctgDocItem.BranchAccount AS BranchAccount,
  P_ParkedOplAcctgDocItem.BudgetPeriod AS BudgetPeriod,
  P_ParkedOplAcctgDocItem.BusinessArea AS BusinessArea,
  P_ParkedOplAcctgDocItem.BusinessPlace AS BusinessPlace,
  P_ParkedOplAcctgDocItem.BusinessProcess AS BusinessProcess,
  P_ParkedOplAcctgDocItem.CashDiscount1Days AS CashDiscount1Days,
  P_ParkedOplAcctgDocItem.CashDiscount1DueDate AS CashDiscount1DueDate,
  P_ParkedOplAcctgDocItem.CashDiscount1Percent AS CashDiscount1Percent,
  P_ParkedOplAcctgDocItem.CashDiscount2Days AS CashDiscount2Days,
  P_ParkedOplAcctgDocItem.CashDiscount2DueDate AS CashDiscount2DueDate,
  P_ParkedOplAcctgDocItem.CashDiscount2Percent AS CashDiscount2Percent,
  P_ParkedOplAcctgDocItem.CashFlowType AS CashFlowType,
  P_ParkedOplAcctgDocItem.CommitmentItemShortID AS CommitmentItemShortID,
  P_ParkedOplAcctgDocItem.CompanyCode AS CompanyCode,
  P_ParkedOplAcctgDocItem.CompanyCodeCurrencyDetnMethod AS CompanyCodeCurrencyDetnMethod,
  P_ParkedOplAcctgDocItem.CostCenter AS CostCenter,
  P_ParkedOplAcctgDocItem.CostCtrActivityType AS CostCtrActivityType,
  P_ParkedOplAcctgDocItem.CostObject AS CostObject,
  P_ParkedOplAcctgDocItem.CostOriginGroup AS CostOriginGroup,
  P_ParkedOplAcctgDocItem.CreditControlArea AS CreditControlArea,
  P_ParkedOplAcctgDocItem.Customer AS Customer,
  P_ParkedOplAcctgDocItem.DataExchangeInstruction1 AS DataExchangeInstruction1,
  P_ParkedOplAcctgDocItem.DataExchangeInstruction2 AS DataExchangeInstruction2,
  P_ParkedOplAcctgDocItem.DataExchangeInstruction3 AS DataExchangeInstruction3,
  P_ParkedOplAcctgDocItem.DataExchangeInstruction4 AS DataExchangeInstruction4,
  P_ParkedOplAcctgDocItem.DebitCreditCode AS DebitCreditCode,
  P_ParkedOplAcctgDocItem.DocumentItemText AS DocumentItemText,
  P_ParkedOplAcctgDocItem.DueCalculationBaseDate AS DueCalculationBaseDate,
  P_ParkedOplAcctgDocItem.DunningArea AS DunningArea,
  P_ParkedOplAcctgDocItem.DunningBlockingReason AS DunningBlockingReason,
  P_ParkedOplAcctgDocItem.DunningKey AS DunningKey,
  P_ParkedOplAcctgDocItem.DunningLevel AS DunningLevel,
  P_ParkedOplAcctgDocItem.FinancialAccountType AS FinancialAccountType,
  P_ParkedOplAcctgDocItem.FinancialTransactionType AS FinancialTransactionType,
  P_ParkedOplAcctgDocItem.FixedAsset AS FixedAsset,
  P_ParkedOplAcctgDocItem.FixedCashDiscount AS FixedCashDiscount,
  P_ParkedOplAcctgDocItem.FollowOnDocumentType AS FollowOnDocumentType,
  P_ParkedOplAcctgDocItem.Fund AS Fund,
  P_ParkedOplAcctgDocItem.FunctionalArea AS FunctionalArea,
  P_ParkedOplAcctgDocItem.FundedProgram AS FundedProgram,
  P_ParkedOplAcctgDocItem.FundsCenter AS FundsCenter,
  P_ParkedOplAcctgDocItem.GLAccount AS GLAccount,
  P_ParkedOplAcctgDocItem.GrantID AS GrantID,
  P_ParkedOplAcctgDocItem.HouseBank AS HouseBank,
  P_ParkedOplAcctgDocItem.HouseBankAccount AS HouseBankAccount,
  P_ParkedOplAcctgDocItem.InventoryValuationType AS InventoryValuationType,
  P_ParkedOplAcctgDocItem.InvoiceItemReference AS InvoiceItemReference,
  P_ParkedOplAcctgDocItem.InvoiceList AS InvoiceList,
  P_ParkedOplAcctgDocItem.InvoiceReference AS InvoiceReference,
  P_ParkedOplAcctgDocItem.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  P_ParkedOplAcctgDocItem.IsEUTriangularDeal AS IsEUTriangularDeal,
  P_ParkedOplAcctgDocItem.IsNotCashDiscountLiable AS IsNotCashDiscountLiable,
  P_ParkedOplAcctgDocItem.IsSalesRelated AS IsSalesRelated,
  P_ParkedOplAcctgDocItem.JointVenture AS JointVenture,
  P_ParkedOplAcctgDocItem.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  P_ParkedOplAcctgDocItem.JointVentureEquityGroup AS JointVentureEquityGroup,
  P_ParkedOplAcctgDocItem.JointVentureEquityType AS JointVentureEquityType,
  P_ParkedOplAcctgDocItem.JointVenturePartner AS JointVenturePartner,
  P_ParkedOplAcctgDocItem.LastDunningDate AS LastDunningDate,
  P_ParkedOplAcctgDocItem.MasterFixedAsset AS MasterFixedAsset,
  P_ParkedOplAcctgDocItem.MaterialPriceControl AS MaterialPriceControl,
  P_ParkedOplAcctgDocItem.MaterialPriceUnitQty AS MaterialPriceUnitQty,
  P_ParkedOplAcctgDocItem.Product AS Product,
  P_ParkedOplAcctgDocItem.NetDueDate AS NetDueDate,
  P_ParkedOplAcctgDocItem.NetPaymentDays AS NetPaymentDays,
  P_ParkedOplAcctgDocItem.OrderID AS OrderID,
  P_ParkedOplAcctgDocItem.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  P_ParkedOplAcctgDocItem.PartnerBudgetPeriod AS PartnerBudgetPeriod,
  P_ParkedOplAcctgDocItem.PartnerBusinessArea AS PartnerBusinessArea,
  P_ParkedOplAcctgDocItem.PartnerFund AS PartnerFund,
  P_ParkedOplAcctgDocItem.PartnerGrant AS PartnerGrant,
  P_ParkedOplAcctgDocItem.PartnerSegment AS PartnerSegment,
  P_ParkedOplAcctgDocItem.PaymentBlockingReason AS PaymentBlockingReason,
  P_ParkedOplAcctgDocItem.PaymentCardPaymentSettlement AS PaymentCardPaymentSettlement,
  P_ParkedOplAcctgDocItem.PaymentDifferenceReason AS PaymentDifferenceReason,
  P_ParkedOplAcctgDocItem.PaymentMethod AS PaymentMethod,
  P_ParkedOplAcctgDocItem.PaymentMethodSupplement AS PaymentMethodSupplement,
  P_ParkedOplAcctgDocItem.PaymentReference AS PaymentReference,
  P_ParkedOplAcctgDocItem.PaymentTerms AS PaymentTerms,
  P_ParkedOplAcctgDocItem.PersonnelNumber AS PersonnelNumber,
  P_ParkedOplAcctgDocItem.PlanningLevel AS PlanningLevel,
  P_ParkedOplAcctgDocItem.Plant AS Plant,
  P_ParkedOplAcctgDocItem.PostingKey AS PostingKey,
  P_ParkedOplAcctgDocItem.ProfitCenter AS ProfitCenter,
  P_ParkedOplAcctgDocItem.ProjectNetwork AS ProjectNetwork,
  P_ParkedOplAcctgDocItem.PurchasingDocument AS PurchasingDocument,
  P_ParkedOplAcctgDocItem.PurchasingDocumentItem AS PurchasingDocumentItem,
  P_ParkedOplAcctgDocItem.REInternalFinNumber AS REInternalFinNumber,
  P_ParkedOplAcctgDocItem.Reference1IDByBusinessPartner AS Reference1IDByBusinessPartner,
  P_ParkedOplAcctgDocItem.Reference2IDByBusinessPartner AS Reference2IDByBusinessPartner,
  P_ParkedOplAcctgDocItem.Reference3IDByBusinessPartner AS Reference3IDByBusinessPartner,
  P_ParkedOplAcctgDocItem.Region AS Region,
  P_ParkedOplAcctgDocItem.Segment AS Segment,
  P_ParkedOplAcctgDocItem.SettlementReferenceDate AS SettlementReferenceDate,
  P_ParkedOplAcctgDocItem.SpecialGLAccountAssignment AS SpecialGLAccountAssignment,
  P_ParkedOplAcctgDocItem.SpecialGLCode AS SpecialGLCode,
  P_ParkedOplAcctgDocItem.SpecialGLTransactionType AS SpecialGLTransactionType,
  P_ParkedOplAcctgDocItem.StateCentralBankPaymentReason AS StateCentralBankPaymentReason,
  P_ParkedOplAcctgDocItem.Supplier AS Supplier,
  P_ParkedOplAcctgDocItem.SupplyingCountry AS SupplyingCountry,
  P_ParkedOplAcctgDocItem.TaxCode AS TaxCode,
  P_ParkedOplAcctgDocItem.TaxJurisdiction AS TaxJurisdiction,
  P_ParkedOplAcctgDocItem.TaxSection AS TaxSection,
  P_ParkedOplAcctgDocItem.TaxType AS TaxType,
  P_ParkedOplAcctgDocItem.TreasuryContractType AS TreasuryContractType,
  P_ParkedOplAcctgDocItem.VATRegistration AS VATRegistration,
  P_ParkedOplAcctgDocItem.ValuationArea AS ValuationArea,
  P_ParkedOplAcctgDocItem.ValueDate AS ValueDate,
  P_ParkedOplAcctgDocItem.WBSElementInternalID AS WBSElementInternalID,
  P_ParkedOplAcctgDocItem.WithholdingTaxCode AS WithholdingTaxCode,
  P_ParkedOplAcctgDocItem.AdditionalCurrency1 AS AdditionalCurrency1,
  P_ParkedOplAcctgDocItem.AdditionalCurrency2 AS AdditionalCurrency2,
  P_ParkedOplAcctgDocItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  P_ParkedOplAcctgDocItem.PaymentCurrency AS PaymentCurrency,
  P_ParkedOplAcctgDocItem.TransactionCurrency AS TransactionCurrency,
  P_ParkedOplAcctgDocItem.AmountInAdditionalCurrency1 AS AmountInAdditionalCurrency1,
  P_ParkedOplAcctgDocItem.AmountInAdditionalCurrency2 AS AmountInAdditionalCurrency2,
  P_ParkedOplAcctgDocItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  P_ParkedOplAcctgDocItem.AmountInPaymentCurrency AS AmountInPaymentCurrency,
  P_ParkedOplAcctgDocItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  P_ParkedOplAcctgDocItem.CashDiscountAmount AS CashDiscountAmount,
  P_ParkedOplAcctgDocItem.CashDiscountAmtInCoCodeCrcy AS CashDiscountAmtInCoCodeCrcy,
  P_ParkedOplAcctgDocItem.CashDiscountBaseAmount AS CashDiscountBaseAmount,
  P_ParkedOplAcctgDocItem.InvoiceAmountInFrgnCurrency AS InvoiceAmountInFrgnCurrency,
  P_ParkedOplAcctgDocItem.InvoiceAmtInCoCodeCrcy AS InvoiceAmtInCoCodeCrcy,
  P_ParkedOplAcctgDocItem.PlannedAmtInTransactionCrcy AS PlannedAmtInTransactionCrcy,
  P_ParkedOplAcctgDocItem.TaxAmount AS TaxAmount,
  P_ParkedOplAcctgDocItem.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  P_ParkedOplAcctgDocItem.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  P_ParkedOplAcctgDocItem.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  P_ParkedOplAcctgDocItem.WithholdingTaxAmount AS WithholdingTaxAmount,
  P_ParkedOplAcctgDocItem.WithholdingTaxBaseAmount AS WithholdingTaxBaseAmount,
  P_ParkedOplAcctgDocItem.WithholdingTaxExemptionAmt AS WithholdingTaxExemptionAmt,
  P_ParkedOplAcctgDocItem.Quantity AS Quantity,
  _CompanyCode.ChartOfAccounts AS ChartOfAccounts,
  _CompanyCode.ControllingArea AS ControllingArea,
  _CompanyCode.FiscalYearVariant AS FiscalYearVariant,
  _CompanyCode.FinancialManagementArea AS FinancialManagementArea,
  _ParkedOplAcctgDocument.AccountingDocumentCategory AS AccountingDocumentCategory,
  _ParkedOplAcctgDocument.AccountingDocumentType AS AccountingDocumentType,
  _ParkedOplAcctgDocument.PartnerCompany AS PartnerCompany,
  _ParkedOplAcctgDocument.FiscalPeriod AS FiscalPeriod,
  _ParkedOplAcctgDocument.DocumentDate AS DocumentDate,
  _ParkedOplAcctgDocument.PostingDate AS PostingDate,
  _ParkedOplAcctgDocument.LedgerGroup AS LedgerGroup
FROM P_ParkedOplAcctgDocItem
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _SourceCompanyCode ON SourceCompanyCode = _SourceCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _SourceFiscalYear ON SourceFiscalYear = _SourceFiscalYear.FiscalYear AND SourceCompanyCode = _SourceFiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ParkedOplAcctgDocument AS _ParkedOplAcctgDocument ON SourceCompanyCode = _ParkedOplAcctgDocument.SourceCompanyCode AND CompanyCode = _ParkedOplAcctgDocument.CompanyCode AND SourceAccountingDocument = _ParkedOplAcctgDocument.SourceAccountingDocument AND SourceFiscalYear = _ParkedOplAcctgDocument.SourceFiscalYear  -- association [0..1]
LEFT OUTER JOIN I_ParkedOplAcctgDocument AS _SourceParkedOplAcctgDocument ON SourceCompanyCode = _SourceParkedOplAcctgDocument.SourceCompanyCode AND SourceCompanyCode = _SourceParkedOplAcctgDocument.CompanyCode AND SourceAccountingDocument = _SourceParkedOplAcctgDocument.SourceAccountingDocument AND SourceFiscalYear = _SourceParkedOplAcctgDocument.SourceFiscalYear  -- 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_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_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_PostingKey AS _PostingKey ON PostingKey = _PostingKey.PostingKey  -- 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_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _PartnerBusinessArea ON PartnerBusinessArea = _PartnerBusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_TaxType AS _TaxType ON TaxType = _TaxType.TaxType  -- association [0..1]
LEFT OUTER JOIN I_Partnercompany AS _PartnerCompany ON PartnerCompany = _PartnerCompany.PartnerCompany  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- 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_Country AS _SupplyingCountry ON SupplyingCountry = _SupplyingCountry.Country  -- 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_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- 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_Segment AS _Segment ON Segment = _Segment.Segment  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _PartnerSegment ON PartnerSegment = _PartnerSegment.Segment  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentType AS _AccountingDocumentType ON AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _PaymentCurrency ON PaymentCurrency = _PaymentCurrency.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 [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_AccountingDocumentCategory AS _AccountingDocumentCategory ON AccountingDocumentCategory = _AccountingDocumentCategory.AccountingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_Order AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_AssetTransactionType AS _AssetTransactionType ON AssetTransactionType = _AssetTransactionType.AssetTransactionType  -- 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_ProjectNetwork AS _ProjectNetwork ON ProjectNetwork = _ProjectNetwork.ProjectNetwork  -- association [0..1]
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_BudgetPeriod AS _BudgetPeriod ON BudgetPeriod = _BudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriod AS _PartnerBudgetPeriod ON PartnerBudgetPeriod = _PartnerBudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_FinancialTransactionType AS _FinancialTransactionType ON FinancialTransactionType = _FinancialTransactionType.FinancialTransactionType  -- association [0..1]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinancialManagementArea ON FinancialManagementArea = _FinancialManagementArea.FinancialManagementArea  -- association [0..1]
LEFT OUTER JOIN I_Fund AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND Fund = _Fund.Fund  -- association [0..1]
LEFT OUTER JOIN I_Fund AS _PartnerFund ON FinancialManagementArea = _PartnerFund.FinancialManagementArea AND PartnerFund = _PartnerFund.Fund  -- association [0..1]
LEFT OUTER JOIN I_FundsCenter AS _FundsCenter ON FinancialManagementArea = _FundsCenter.FinancialManagementArea AND FundsCenter = _FundsCenter.FundsCenter  -- association [0..*]
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_Housebank AS _HouseBank ON CompanyCode = _HouseBank.CompanyCode AND HouseBank = _HouseBank.HouseBank  -- association [0..1]
LEFT OUTER JOIN I_InventoryValuationType AS _InventoryValuationType ON InventoryValuationType = _InventoryValuationType.InventoryValuationType  -- association [0..1]
LEFT OUTER JOIN I_PaymentBlockingReason AS _PaymentBlockingReason ON PaymentBlockingReason = _PaymentBlockingReason.PaymentBlockingReason  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonWorkAgreement_1 ON PersonnelNumber = _PersonWorkAgreement_1.PersonWorkAgreement  -- 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_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
;