I_OplAcctgDocumentItemBrowser

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_OplAcctgDocumentItemBrowser.
-- 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.
-- Parameters: P_ClearingStatusSelection : fis_clearingstatusselection

CREATE VIEW I_OplAcctgDocumentItemBrowser AS
SELECT
  P_OperationalAcctgDocBrowser.AccountingDocumentCatGroup AS AccountingDocumentCatGroup,
  P_OperationalAcctgDocBrowser.CompanyCode AS CompanyCode,
  P_OperationalAcctgDocBrowser.FiscalYear AS FiscalYear,
  P_OperationalAcctgDocBrowser.AccountingDocument AS AccountingDocument,
  P_OperationalAcctgDocBrowser.AccountingDocumentItem AS AccountingDocumentItem,
  P_OperationalAcctgDocBrowser.ChartOfAccounts AS ChartOfAccounts,
  P_OperationalAcctgDocBrowser.ClearingDate AS ClearingDate,
  P_OperationalAcctgDocBrowser.ClearingCreationDate AS ClearingCreationDate,
  P_OperationalAcctgDocBrowser.ClearingJournalEntry AS ClearingJournalEntry,
  P_OperationalAcctgDocBrowser.ClearingAccountingDocument AS ClearingAccountingDocument,
  P_OperationalAcctgDocBrowser.PostingKey AS PostingKey,
  P_OperationalAcctgDocBrowser.FinancialAccountType AS FinancialAccountType,
  P_OperationalAcctgDocBrowser.SpecialGLCode AS SpecialGLCode,
  P_OperationalAcctgDocBrowser.SpecialGLTransactionType AS SpecialGLTransactionType,
  P_OperationalAcctgDocBrowser.DebitCreditCode AS DebitCreditCode,
  P_OperationalAcctgDocBrowser.BusinessArea AS BusinessArea,
  P_OperationalAcctgDocBrowser.PartnerBusinessArea AS PartnerBusinessArea,
  P_OperationalAcctgDocBrowser.TaxCode AS TaxCode,
  P_OperationalAcctgDocBrowser.WithholdingTaxCode AS WithholdingTaxCode,
  P_OperationalAcctgDocBrowser.TaxType AS TaxType,
  P_OperationalAcctgDocBrowser.TransactionTypeDetermination AS TransactionTypeDetermination,
  P_OperationalAcctgDocBrowser.ValueDate AS ValueDate,
  P_OperationalAcctgDocBrowser.AssignmentReference AS AssignmentReference,
  P_OperationalAcctgDocBrowser.DocumentItemText AS DocumentItemText,
  P_OperationalAcctgDocBrowser.PartnerCompany AS PartnerCompany,
  P_OperationalAcctgDocBrowser.FinancialTransactionType AS FinancialTransactionType,
  P_OperationalAcctgDocBrowser.CorporateGroupAccount AS CorporateGroupAccount,
  P_OperationalAcctgDocBrowser.PlanningLevel AS PlanningLevel,
  P_OperationalAcctgDocBrowser.ControllingArea AS ControllingArea,
  P_OperationalAcctgDocBrowser.CostCenter AS CostCenter,
  P_OperationalAcctgDocBrowser.OrderID AS OrderID,
  P_OperationalAcctgDocBrowser.BillingDocument AS BillingDocument,
  P_OperationalAcctgDocBrowser.SalesDocument AS SalesDocument,
  P_OperationalAcctgDocBrowser.SalesDocumentItem AS SalesDocumentItem,
  P_OperationalAcctgDocBrowser.ScheduleLine AS ScheduleLine,
  P_OperationalAcctgDocBrowser.ServiceDocumentType AS ServiceDocumentType,
  P_OperationalAcctgDocBrowser.ServiceDocument AS ServiceDocument,
  P_OperationalAcctgDocBrowser.ServiceDocumentItem AS ServiceDocumentItem,
  P_OperationalAcctgDocBrowser.MasterFixedAsset AS MasterFixedAsset,
  P_OperationalAcctgDocBrowser.FixedAsset AS FixedAsset,
  P_OperationalAcctgDocBrowser.AssetTransactionType AS AssetTransactionType,
  P_OperationalAcctgDocBrowser.AssetValueDate AS AssetValueDate,
  P_OperationalAcctgDocBrowser.PersonnelNumber AS PersonnelNumber,
  P_OperationalAcctgDocBrowser.IsSalesRelated AS IsSalesRelated,
  P_OperationalAcctgDocBrowser.LineItemDisplayIsEnabled AS LineItemDisplayIsEnabled,
  P_OperationalAcctgDocBrowser.IsOpenItemManaged AS IsOpenItemManaged,
  P_OperationalAcctgDocBrowser.IsNotCashDiscountLiable AS IsNotCashDiscountLiable,
  P_OperationalAcctgDocBrowser.IsAutomaticallyCreated AS IsAutomaticallyCreated,
  P_OperationalAcctgDocBrowser.IsUsedInPaymentTransaction AS IsUsedInPaymentTransaction,
  P_OperationalAcctgDocBrowser.OperationalGLAccount AS OperationalGLAccount,
  P_OperationalAcctgDocBrowser.GLAccount AS GLAccount,
  P_OperationalAcctgDocBrowser.Customer AS Customer,
  P_OperationalAcctgDocBrowser.Supplier AS Supplier,
  P_OperationalAcctgDocBrowser.BranchAccount AS BranchAccount,
  P_OperationalAcctgDocBrowser.IsBalanceSheetAccount AS IsBalanceSheetAccount,
  P_OperationalAcctgDocBrowser.ProfitLossAccountType AS ProfitLossAccountType,
  P_OperationalAcctgDocBrowser.SpecialGLAccountAssignment AS SpecialGLAccountAssignment,
  P_OperationalAcctgDocBrowser.DueCalculationBaseDate AS DueCalculationBaseDate,
  P_OperationalAcctgDocBrowser.PaymentTerms AS PaymentTerms,
  P_OperationalAcctgDocBrowser.CashDiscount1Days AS CashDiscount1Days,
  P_OperationalAcctgDocBrowser.CashDiscount2Days AS CashDiscount2Days,
  P_OperationalAcctgDocBrowser.NetPaymentDays AS NetPaymentDays,
  P_OperationalAcctgDocBrowser.CashDiscount1Percent AS CashDiscount1Percent,
  P_OperationalAcctgDocBrowser.CashDiscount2Percent AS CashDiscount2Percent,
  P_OperationalAcctgDocBrowser.PaymentMethod AS PaymentMethod,
  P_OperationalAcctgDocBrowser.PaymentBlockingReason AS PaymentBlockingReason,
  P_OperationalAcctgDocBrowser.FixedCashDiscount AS FixedCashDiscount,
  P_OperationalAcctgDocBrowser.HouseBank AS HouseBank,
  P_OperationalAcctgDocBrowser.BPBankAccountInternalID AS BPBankAccountInternalID,
  P_OperationalAcctgDocBrowser.TaxDistributionCode1 AS TaxDistributionCode1,
  P_OperationalAcctgDocBrowser.TaxDistributionCode2 AS TaxDistributionCode2,
  P_OperationalAcctgDocBrowser.TaxDistributionCode3 AS TaxDistributionCode3,
  P_OperationalAcctgDocBrowser.InvoiceReference AS InvoiceReference,
  P_OperationalAcctgDocBrowser.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  P_OperationalAcctgDocBrowser.InvoiceItemReference AS InvoiceItemReference,
  P_OperationalAcctgDocBrowser.FollowOnDocumentType AS FollowOnDocumentType,
  P_OperationalAcctgDocBrowser.StateCentralBankPaymentReason AS StateCentralBankPaymentReason,
  P_OperationalAcctgDocBrowser.SupplyingCountry AS SupplyingCountry,
  P_OperationalAcctgDocBrowser.InvoiceList AS InvoiceList,
  P_OperationalAcctgDocBrowser.BillOfExchangeUsage AS BillOfExchangeUsage,
  P_OperationalAcctgDocBrowser.DunningKey AS DunningKey,
  P_OperationalAcctgDocBrowser.DunningBlockingReason AS DunningBlockingReason,
  P_OperationalAcctgDocBrowser.LastDunningDate AS LastDunningDate,
  P_OperationalAcctgDocBrowser.DunningLevel AS DunningLevel,
  P_OperationalAcctgDocBrowser.DunningArea AS DunningArea,
  P_OperationalAcctgDocBrowser.WithholdingTaxCertificate AS WithholdingTaxCertificate,
  P_OperationalAcctgDocBrowser.Product AS Product,
  P_OperationalAcctgDocBrowser.Plant AS Plant,
  P_OperationalAcctgDocBrowser.PurchasingDocument AS PurchasingDocument,
  P_OperationalAcctgDocBrowser.PurchasingDocumentItem AS PurchasingDocumentItem,
  P_OperationalAcctgDocBrowser.AccountAssignmentNumber AS AccountAssignmentNumber,
  P_OperationalAcctgDocBrowser.IsCompletelyDelivered AS IsCompletelyDelivered,
  P_OperationalAcctgDocBrowser.MaterialPriceControl AS MaterialPriceControl,
  P_OperationalAcctgDocBrowser.ValuationArea AS ValuationArea,
  P_OperationalAcctgDocBrowser.InventoryValuationType AS InventoryValuationType,
  P_OperationalAcctgDocBrowser.VATRegistration AS VATRegistration,
  P_OperationalAcctgDocBrowser.DelivOfGoodsDestCountry AS DelivOfGoodsDestCountry,
  P_OperationalAcctgDocBrowser.PaymentDifferenceReason AS PaymentDifferenceReason,
  P_OperationalAcctgDocBrowser.ProfitCenter AS ProfitCenter,
  P_OperationalAcctgDocBrowser.JointVenture AS JointVenture,
  P_OperationalAcctgDocBrowser.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  P_OperationalAcctgDocBrowser.JointVentureEquityGroup AS JointVentureEquityGroup,
  P_OperationalAcctgDocBrowser.TreasuryContractType AS TreasuryContractType,
  P_OperationalAcctgDocBrowser.AssetContract AS AssetContract,
  P_OperationalAcctgDocBrowser.CashFlowType AS CashFlowType,
  P_OperationalAcctgDocBrowser.TaxJurisdiction AS TaxJurisdiction,
  P_OperationalAcctgDocBrowser.REInternalFinNumber AS REInternalFinNumber,
  P_OperationalAcctgDocBrowser.RealEstateObject AS RealEstateObject,
  P_OperationalAcctgDocBrowser.SettlementReferenceDate AS SettlementReferenceDate,
  P_OperationalAcctgDocBrowser.CommitmentItem AS CommitmentItem,
  P_OperationalAcctgDocBrowser.CommitmentItemShortID AS CommitmentItemShortID,
  P_OperationalAcctgDocBrowser.CostObject AS CostObject,
  P_OperationalAcctgDocBrowser.ProjectNetwork AS ProjectNetwork,
  P_OperationalAcctgDocBrowser.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  P_OperationalAcctgDocBrowser.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  P_OperationalAcctgDocBrowser.WBSElementInternalID AS WBSElementInternalID,
  cast( case when P_OperationalAcctgDocBrowser.ProfitabilitySegment_2 > '9999999999' then '9999999999' else lpad( P_OperationalAcctgDocBrowser.ProfitabilitySegment_2, 10, '0' ) end as rkeobjnr_numc ) AS ProfitabilitySegment,
  P_OperationalAcctgDocBrowser.ProfitabilitySegment_2 AS ProfitabilitySegment_2,
  P_OperationalAcctgDocBrowser.JointVentureEquityType AS JointVentureEquityType,
  P_OperationalAcctgDocBrowser.IsEUTriangularDeal AS IsEUTriangularDeal,
  P_OperationalAcctgDocBrowser.CostOriginGroup AS CostOriginGroup,
  P_OperationalAcctgDocBrowser.CompanyCodeCurrencyDetnMethod AS CompanyCodeCurrencyDetnMethod,
  P_OperationalAcctgDocBrowser.ClearingIsReversed AS ClearingIsReversed,
  P_OperationalAcctgDocBrowser.PaymentMethodSupplement AS PaymentMethodSupplement,
  P_OperationalAcctgDocBrowser.AlternativeGLAccount AS AlternativeGLAccount,
  P_OperationalAcctgDocBrowser.PartnerProfitCenter AS PartnerProfitCenter,
  P_OperationalAcctgDocBrowser.Reference1IDByBusinessPartner AS Reference1IDByBusinessPartner,
  P_OperationalAcctgDocBrowser.Reference2IDByBusinessPartner AS Reference2IDByBusinessPartner,
  P_OperationalAcctgDocBrowser.IsNegativePosting AS IsNegativePosting,
  P_OperationalAcctgDocBrowser.PaymentCardItem AS PaymentCardItem,
  P_OperationalAcctgDocBrowser.PaymentCardPaymentSettlement AS PaymentCardPaymentSettlement,
  P_OperationalAcctgDocBrowser.CreditControlArea AS CreditControlArea,
  P_OperationalAcctgDocBrowser.Reference3IDByBusinessPartner AS Reference3IDByBusinessPartner,
  P_OperationalAcctgDocBrowser.DataExchangeInstruction1 AS DataExchangeInstruction1,
  P_OperationalAcctgDocBrowser.DataExchangeInstruction2 AS DataExchangeInstruction2,
  P_OperationalAcctgDocBrowser.DataExchangeInstruction3 AS DataExchangeInstruction3,
  P_OperationalAcctgDocBrowser.DataExchangeInstruction4 AS DataExchangeInstruction4,
  P_OperationalAcctgDocBrowser.Region AS Region,
  P_OperationalAcctgDocBrowser.HasPaymentOrder AS HasPaymentOrder,
  P_OperationalAcctgDocBrowser.PaymentReference AS PaymentReference,
  P_OperationalAcctgDocBrowser.TaxDeterminationDate AS TaxDeterminationDate,
  P_OperationalAcctgDocBrowser.ClearingItem AS ClearingItem,
  P_OperationalAcctgDocBrowser.BusinessPlace AS BusinessPlace,
  P_OperationalAcctgDocBrowser.TaxSection AS TaxSection,
  P_OperationalAcctgDocBrowser.CostCtrActivityType AS CostCtrActivityType,
  P_OperationalAcctgDocBrowser.AccountsReceivableIsPledged AS AccountsReceivableIsPledged,
  P_OperationalAcctgDocBrowser.AcctsReceivablePledgingCode AS AcctsReceivablePledgingCode,
  P_OperationalAcctgDocBrowser.BusinessProcess AS BusinessProcess,
  P_OperationalAcctgDocBrowser.FunctionalArea AS FunctionalArea,
  P_OperationalAcctgDocBrowser.CustomerIsInExecution AS CustomerIsInExecution,
  P_OperationalAcctgDocBrowser.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  P_OperationalAcctgDocBrowser.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  P_OperationalAcctgDocBrowser.LedgerGLLineItem AS LedgerGLLineItem,
  P_OperationalAcctgDocBrowser.Segment AS Segment,
  P_OperationalAcctgDocBrowser.PartnerSegment AS PartnerSegment,
  P_OperationalAcctgDocBrowser.PartnerFunctionalArea AS PartnerFunctionalArea,
  P_OperationalAcctgDocBrowser.HouseBankAccount AS HouseBankAccount,
  P_OperationalAcctgDocBrowser.CostElement AS CostElement,
  P_OperationalAcctgDocBrowser.PaymentServiceProvider AS PaymentServiceProvider,
  P_OperationalAcctgDocBrowser.PaymentRefByPaytSrvcProvider AS PaymentRefByPaytSrvcProvider,
  P_OperationalAcctgDocBrowser.SEPAMandate AS SEPAMandate,
  P_OperationalAcctgDocBrowser.ReferenceDocumentType AS ReferenceDocumentType,
  P_OperationalAcctgDocBrowser.OriginalReferenceDocument AS OriginalReferenceDocument,
  P_OperationalAcctgDocBrowser.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
  P_OperationalAcctgDocBrowser.AccountingDocumentItemRef AS AccountingDocumentItemRef,
  P_OperationalAcctgDocBrowser.FiscalPeriod AS FiscalPeriod,
  P_OperationalAcctgDocBrowser.AccountingDocumentCategory AS AccountingDocumentCategory,
  P_OperationalAcctgDocBrowser.PostingDate AS PostingDate,
  P_OperationalAcctgDocBrowser.DocumentDate AS DocumentDate,
  P_OperationalAcctgDocBrowser.AccountingDocumentType AS AccountingDocumentType,
  P_OperationalAcctgDocBrowser.NetDueDate AS NetDueDate,
  P_OperationalAcctgDocBrowser.CashDiscount1DueDate AS CashDiscount1DueDate,
  P_OperationalAcctgDocBrowser.CashDiscount2DueDate AS CashDiscount2DueDate,
  P_OperationalAcctgDocBrowser.OffsettingAccount AS OffsettingAccount,
  P_OperationalAcctgDocBrowser.OffsettingAccountType AS OffsettingAccountType,
  P_OperationalAcctgDocBrowser.OffsettingChartOfAccounts AS OffsettingChartOfAccounts,
  P_OperationalAcctgDocBrowser.CashLedgerCompanyCode AS CashLedgerCompanyCode,
  P_OperationalAcctgDocBrowser.CashLedgerAccount AS CashLedgerAccount,
  P_OperationalAcctgDocBrowser.FinancialManagementArea AS FinancialManagementArea,
  P_OperationalAcctgDocBrowser.FundsCenter AS FundsCenter,
  P_OperationalAcctgDocBrowser.FundedProgram AS FundedProgram,
  P_OperationalAcctgDocBrowser.Fund AS Fund,
  P_OperationalAcctgDocBrowser.GrantID AS GrantID,
  P_OperationalAcctgDocBrowser.BudgetPeriod AS BudgetPeriod,
  P_OperationalAcctgDocBrowser.PartnerFund AS PartnerFund,
  P_OperationalAcctgDocBrowser.PartnerGrant AS PartnerGrant,
  P_OperationalAcctgDocBrowser.PartnerBudgetPeriod AS PartnerBudgetPeriod,
  P_OperationalAcctgDocBrowser.PubSecBudgetAccount AS PubSecBudgetAccount,
  P_OperationalAcctgDocBrowser.PubSecBudgetAccountCoCode AS PubSecBudgetAccountCoCode,
  P_OperationalAcctgDocBrowser.CompanyCodeCurrency AS CompanyCodeCurrency,
  P_OperationalAcctgDocBrowser.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  P_OperationalAcctgDocBrowser.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  P_OperationalAcctgDocBrowser.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  P_OperationalAcctgDocBrowser.ValuationDiffAmtInCoCodeCrcy AS ValuationDiffAmtInCoCodeCrcy,
  P_OperationalAcctgDocBrowser.CashDiscountAmtInCoCodeCrcy AS CashDiscountAmtInCoCodeCrcy,
  P_OperationalAcctgDocBrowser.InvoiceAmtInCoCodeCrcy AS InvoiceAmtInCoCodeCrcy,
  P_OperationalAcctgDocBrowser.FunctionalCurrency AS FunctionalCurrency,
  P_OperationalAcctgDocBrowser.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  P_OperationalAcctgDocBrowser.TransactionCurrency AS TransactionCurrency,
  P_OperationalAcctgDocBrowser.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  P_OperationalAcctgDocBrowser.OriginalTaxBaseAmount AS OriginalTaxBaseAmount,
  P_OperationalAcctgDocBrowser.TaxAmount AS TaxAmount,
  P_OperationalAcctgDocBrowser.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  P_OperationalAcctgDocBrowser.WithholdingTaxBaseAmount AS WithholdingTaxBaseAmount,
  P_OperationalAcctgDocBrowser.PlannedAmtInTransactionCrcy AS PlannedAmtInTransactionCrcy,
  P_OperationalAcctgDocBrowser.CashDiscountBaseAmount AS CashDiscountBaseAmount,
  P_OperationalAcctgDocBrowser.CashDiscountAmount AS CashDiscountAmount,
  P_OperationalAcctgDocBrowser.NetPaymentAmount AS NetPaymentAmount,
  P_OperationalAcctgDocBrowser.WithholdingTaxAmount AS WithholdingTaxAmount,
  P_OperationalAcctgDocBrowser.WithholdingTaxExemptionAmt AS WithholdingTaxExemptionAmt,
  P_OperationalAcctgDocBrowser.InvoiceAmountInFrgnCurrency AS InvoiceAmountInFrgnCurrency,
  P_OperationalAcctgDocBrowser.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  P_OperationalAcctgDocBrowser.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  P_OperationalAcctgDocBrowser.AdditionalCurrency1 AS AdditionalCurrency1,
  P_OperationalAcctgDocBrowser.ValuationDiffAmtInAddlCrcy1 AS ValuationDiffAmtInAddlCrcy1,
  P_OperationalAcctgDocBrowser.AmountInAdditionalCurrency1 AS AmountInAdditionalCurrency1,
  P_OperationalAcctgDocBrowser.AdditionalCurrency2 AS AdditionalCurrency2,
  P_OperationalAcctgDocBrowser.AmountInAdditionalCurrency2 AS AmountInAdditionalCurrency2,
  P_OperationalAcctgDocBrowser.ValuationDiffAmtInAddlCrcy2 AS ValuationDiffAmtInAddlCrcy2,
  P_OperationalAcctgDocBrowser.PaymentCurrency AS PaymentCurrency,
  P_OperationalAcctgDocBrowser.AmountInPaymentCurrency AS AmountInPaymentCurrency,
  P_OperationalAcctgDocBrowser.CreditControlAreaCurrency AS CreditControlAreaCurrency,
  P_OperationalAcctgDocBrowser.HedgedAmount AS HedgedAmount,
  P_OperationalAcctgDocBrowser.BaseUnit AS BaseUnit,
  P_OperationalAcctgDocBrowser.Quantity AS Quantity,
  P_OperationalAcctgDocBrowser.AbsoluteQuantity AS AbsoluteQuantity,
  P_OperationalAcctgDocBrowser.GoodsMovementEntryUnit AS GoodsMovementEntryUnit,
  P_OperationalAcctgDocBrowser.QuantityInEntryUnit AS QuantityInEntryUnit,
  P_OperationalAcctgDocBrowser.PurchasingDocumentPriceUnit AS PurchasingDocumentPriceUnit,
  P_OperationalAcctgDocBrowser.PurchaseOrderQty AS PurchaseOrderQty,
  P_OperationalAcctgDocBrowser.MaterialPriceUnitQty AS MaterialPriceUnitQty,
  P_OperationalAcctgDocBrowser.Ledger AS Ledger,
  P_OperationalAcctgDocBrowser.LedgerGroup AS LedgerGroup,
  P_OperationalAcctgDocBrowser.NumberOfItems AS NumberOfItems,
  P_OperationalAcctgDocBrowser.ClearingStatusSelection AS ClearingStatusSelection,
  P_OperationalAcctgDocBrowser._CompanyCode AS _CompanyCode,
  P_OperationalAcctgDocBrowser._FiscalYear AS _FiscalYear,
  P_OperationalAcctgDocBrowser._JournalEntry AS _JournalEntry,
  P_OperationalAcctgDocBrowser._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  P_OperationalAcctgDocBrowser._ChartOfAccounts AS _ChartOfAccounts,
  P_OperationalAcctgDocBrowser._PostingKey AS _PostingKey,
  P_OperationalAcctgDocBrowser._FinancialAccountType AS _FinancialAccountType,
  P_OperationalAcctgDocBrowser._DebitCreditCode AS _DebitCreditCode,
  P_OperationalAcctgDocBrowser._BusinessArea AS _BusinessArea,
  P_OperationalAcctgDocBrowser._PartnerBusinessArea AS _PartnerBusinessArea,
  P_OperationalAcctgDocBrowser._TaxType AS _TaxType,
  P_OperationalAcctgDocBrowser._ControllingArea AS _ControllingArea,
  P_OperationalAcctgDocBrowser._ProfitCenter AS _ProfitCenter,
  P_OperationalAcctgDocBrowser._CostCenter AS _CostCenter,
  P_OperationalAcctgDocBrowser._SupplyingCountry AS _SupplyingCountry,
  P_OperationalAcctgDocBrowser._Product AS _Product,
  P_OperationalAcctgDocBrowser._Plant AS _Plant,
  P_OperationalAcctgDocBrowser._BaseUnit AS _BaseUnit,
  P_OperationalAcctgDocBrowser._InventoryValuationType AS _InventoryValuationType,
  P_OperationalAcctgDocBrowser._PaymentDifferenceReason AS _PaymentDifferenceReason,
  P_OperationalAcctgDocBrowser._Segment AS _Segment,
  P_OperationalAcctgDocBrowser._PartnerSegment AS _PartnerSegment,
  P_OperationalAcctgDocBrowser._WBSElementBasicData AS _WBSElementBasicData,
  P_OperationalAcctgDocBrowser._AccountingDocumentType AS _AccountingDocumentType,
  P_OperationalAcctgDocBrowser._TransactionCurrency AS _TransactionCurrency,
  P_OperationalAcctgDocBrowser._InternalOrder AS _InternalOrder,
  P_OperationalAcctgDocBrowser._Order AS _Order,
  P_OperationalAcctgDocBrowser._MasterFixedAsset AS _MasterFixedAsset,
  P_OperationalAcctgDocBrowser._FixedAsset AS _FixedAsset,
  P_OperationalAcctgDocBrowser._AssetTransactionType AS _AssetTransactionType,
  P_OperationalAcctgDocBrowser._PurchasingDocument AS _PurchasingDocument,
  P_OperationalAcctgDocBrowser._PurchasingDocumentItem AS _PurchasingDocumentItem,
  P_OperationalAcctgDocBrowser._ValuationArea AS _ValuationArea,
  P_OperationalAcctgDocBrowser._ProjectNetwork AS _ProjectNetwork,
  P_OperationalAcctgDocBrowser._CostCtrActivityType AS _CostCtrActivityType,
  P_OperationalAcctgDocBrowser._BusinessProcess AS _BusinessProcess,
  P_OperationalAcctgDocBrowser._FunctionalArea AS _FunctionalArea,
  P_OperationalAcctgDocBrowser._AdditionalCurrencyRoles AS _AdditionalCurrencyRoles,
  P_OperationalAcctgDocBrowser._CurrentCostCenter AS _CurrentCostCenter,
  P_OperationalAcctgDocBrowser._CurrentProfitCenter AS _CurrentProfitCenter,
  P_OperationalAcctgDocBrowser._Customer AS _Customer,
  P_OperationalAcctgDocBrowser._CustomerCompany AS _CustomerCompany,
  P_OperationalAcctgDocBrowser._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  P_OperationalAcctgDocBrowser._SalesDocument AS _SalesDocument,
  P_OperationalAcctgDocBrowser._ServiceDocument AS _ServiceDocument,
  P_OperationalAcctgDocBrowser._Supplier AS _Supplier,
  P_OperationalAcctgDocBrowser._SupplierCompany AS _SupplierCompany,
  P_OperationalAcctgDocBrowser._FinancialManagementArea AS _FinancialManagementArea,
  P_OperationalAcctgDocBrowser._FundsCenter AS _FundsCenter,
  P_OperationalAcctgDocBrowser._Fund AS _Fund,
  P_OperationalAcctgDocBrowser._PartnerFund AS _PartnerFund,
  P_OperationalAcctgDocBrowser._FundedProgram AS _FundedProgram,
  P_OperationalAcctgDocBrowser._CashLedgerCompanyCode AS _CashLedgerCompanyCode,
  P_OperationalAcctgDocBrowser._CashLedgerAccount AS _CashLedgerAccount,
  P_OperationalAcctgDocBrowser._BudgetPeriod AS _BudgetPeriod,
  P_OperationalAcctgDocBrowser._PartnerBudgetPeriod AS _PartnerBudgetPeriod,
  P_OperationalAcctgDocBrowser._Grant AS _Grant,
  P_OperationalAcctgDocBrowser._PartnerGrant AS _PartnerGrant,
  P_OperationalAcctgDocBrowser._PubSecBudgetAccountCoCode AS _PubSecBudgetAccountCoCode,
  P_OperationalAcctgDocBrowser._PubSecBudgetAccount AS _PubSecBudgetAccount
FROM P_OperationalAcctgDocBrowser
LEFT OUTER JOIN I_AccountingDocumentCatGroup AS _AccountingDocumentCatGroup ON AccountingDocumentCatGroup = _AccountingDocumentCatGroup.AccountingDocumentCatGroup  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _PartnerCompany ON PartnerCompany = _PartnerCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Partnercompany AS _PartnerCompany_2 ON PartnerCompany = _PartnerCompany_2.PartnerCompany  -- association [0..1]
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]
;