I_AddlLedgerOplAcctgDocItem

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_AddlLedgerOplAcctgDocItem.
-- 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_AddlLedgerOplAcctgDocItem AS
SELECT
  P_Bseg_Add_Com.bukrs AS CompanyCode,
  P_Bseg_Add_Com.belnr AS AccountingDocument,
  P_Bseg_Add_Com.gjahr AS FiscalYear,
  P_Bseg_Add_Com.buzei AS AccountingDocumentItem,
  P_Bseg_Add_Com.ktopl AS ChartOfAccounts,
  P_Bseg_Add_Com.augdt AS ClearingDate,
  P_Bseg_Add_Com.augcp AS ClearingCreationDate,
  P_Bseg_Add_Com.auggj AS ClearingJournalEntryFiscalYear,
  cast( P_Bseg_Add_Com.auggj as fis_auggj_no_conv_depre preserving type ) AS ClearingDocFiscalYear,
  P_Bseg_Add_Com.augbl AS ClearingJournalEntry,
  cast( P_Bseg_Add_Com.augbl as fis_augbl_depre preserving type ) AS ClearingAccountingDocument,
  P_Bseg_Add_Com.bschl AS PostingKey,
  P_Bseg_Add_Com.koart AS FinancialAccountType,
  P_Bseg_Add_Com.shkzg AS DebitCreditCode,
  P_Bseg_Add_Com.gsber AS BusinessArea,
  P_Bseg_Add_Com.pargb AS PartnerBusinessArea,
  P_Bseg_Add_Com.mwskz AS TaxCode,
  P_Bseg_Add_Com.qsskz AS WithholdingTaxCode,
  P_Bseg_Add_Com.ktosl AS TransactionTypeDetermination,
  P_Bseg_Add_Com.valut AS ValueDate,
  P_Bseg_Add_Com.zuonr AS AssignmentReference,
  P_Bseg_Add_Com.sgtxt AS DocumentItemText,
  P_Bseg_Add_Com.vbund AS PartnerCompany,
  P_Bseg_Add_Com.bewar AS FinancialTransactionType,
  P_Bseg_Add_Com.altkt AS CorporateGroupAccount,
  P_Bseg_Add_Com.kokrs AS ControllingArea,
  P_Bseg_Add_Com.kostl AS CostCenter,
  P_Bseg_Add_Com.projn AS Project,
  P_Bseg_Add_Com.aufnr AS OrderID,
  P_Bseg_Add_Com.anln1 AS MasterFixedAsset,
  P_Bseg_Add_Com.anln2 AS FixedAsset,
  P_Bseg_Add_Com.anbwa AS AssetTransactionType,
  P_Bseg_Add_Com.xopvw AS IsOpenItemManaged,
  P_Bseg_Add_Com.xauto AS IsAutomaticallyCreated,
  P_Bseg_Add_Com.hkont AS GLAccount,
  P_Bseg_Add_Com.xbilk AS IsBalanceSheetAccount,
  P_Bseg_Add_Com.gvtyp AS ProfitLossAccountType,
  P_Bseg_Add_Com.zfbdt AS DueCalculationBaseDate,
  P_Bseg_Add_Com.rebzg AS InvoiceReference,
  P_Bseg_Add_Com.rebzj AS InvoiceReferenceFiscalYear,
  P_Bseg_Add_Com.rebzz AS InvoiceItemReference,
  P_Bseg_Add_Com.rebzt AS FollowOnDocumentType,
  P_Bseg_Add_Com.wverw AS BillOfExchangeUsage,
  P_Bseg_Add_Com.matnr AS Material,
  P_Bseg_Add_Com.matnr AS Product,
  P_Bseg_Add_Com.werks AS Plant,
  P_Bseg_Add_Com.bwkey AS ValuationArea,
  P_Bseg_Add_Com.bwtar AS InventoryValuationType,
  P_Bseg_Add_Com.prctr AS ProfitCenter,
  P_Bseg_Add_Com.vname AS JointVenture,
  P_Bseg_Add_Com.recid AS JointVentureCostRecoveryCode,
  P_Bseg_Add_Com.egrup AS JointVentureEquityGroup,
  P_Bseg_Add_Com.vertt AS TreasuryContractType,
  P_Bseg_Add_Com.vertn AS AssetContract,
  P_Bseg_Add_Com.vbewa AS CashFlowType,
  cast( P_Bseg_Add_Com.imkey as recaimkeyfi preserving type ) AS REInternalFinNumber,
  P_Bseg_Add_Com.imkey AS RealEstateObject,
  P_Bseg_Add_Com.dabrz AS SettlementReferenceDate,
  P_Bseg_Add_Com.fipos AS CommitmentItem,
  cast( P_Bseg_Add_Com.fipos as fis_fipos_shortid preserving type ) AS CommitmentItemShortID,
  P_Bseg_Add_Com.kstrg AS CostObject,
  P_Bseg_Add_Com.nplnr AS ProjectNetwork,
  P_Bseg_Add_Com.aufpl AS OrderInternalBillOfOperations,
  P_Bseg_Add_Com.aplzl AS OrderIntBillOfOperationsItem,
  P_Bseg_Add_Com.projk AS WBSElementInternalID,
  cast( case when P_Bseg_Add_Com.paobjnr > '9999999999' then '9999999999' else lpad( P_Bseg_Add_Com.paobjnr, 10, '0' ) end as rkeobjnr_numc ) AS ProfitabilitySegment,
  cast( P_Bseg_Add_Com.paobjnr as rkeobjnr_char ) AS ProfitabilitySegment_2,
  P_Bseg_Add_Com.xragl AS ClearingIsReversed,
  P_Bseg_Add_Com.uzawe AS PaymentMethodSupplement,
  P_Bseg_Add_Com.lokkt AS AlternativeGLAccount,
  P_Bseg_Add_Com.fistl AS FundsCenter,
  P_Bseg_Add_Com.geber AS Fund,
  P_Bseg_Add_Com.pprct AS PartnerProfitCenter,
  P_Bseg_Add_Com.xref1 AS Reference1IDByBusinessPartner,
  P_Bseg_Add_Com.xref2 AS Reference2IDByBusinessPartner,
  P_Bseg_Add_Com.kblnr AS EarmarkedFundsDocument,
  P_Bseg_Add_Com.kblpos AS EarmarkedFundsDocumentItem,
  P_Bseg_Add_Com.fkber AS FunctionalArea,
  P_Bseg_Add_Com.rfzei AS PaymentCardItem,
  P_Bseg_Add_Com.ccbtc AS PaymentCardPaymentSettlement,
  P_Bseg_Add_Com.xref3 AS Reference3IDByBusinessPartner,
  P_Bseg_Add_Com.agzei AS ClearingItem,
  P_Bseg_Add_Com.bupla AS BusinessPlace,
  P_Bseg_Add_Com.secco AS TaxSection,
  P_Bseg_Add_Com.lstar AS CostCtrActivityType,
  P_Bseg_Add_Com.prznr AS BusinessProcess,
  P_Bseg_Add_Com.grant_nbr AS GrantID,
  P_Bseg_Add_Com.measure AS FundedProgram,
  P_Bseg_Add_Com.segment AS Segment,
  P_Bseg_Add_Com.psegment AS PartnerSegment,
  P_Bseg_Add_Com.pfkber AS PartnerFunctionalArea,
  P_Bseg_Add_Com.kstar AS CostElement,
  P_Bseg_Add_Com.netdt AS NetDueDate,
  P_Bseg_Add_Com.gkont AS OffsettingAccount,
  P_Bseg_Add_Com.gkart AS OffsettingAccountType,
  P_Bseg_Add_Com.pgeber AS PartnerFund,
  P_Bseg_Add_Com.pgrant_nbr AS PartnerGrant,
  P_Bseg_Add_Com.budget_pd AS BudgetPeriod,
  P_Bseg_Add_Com.pbudget_pd AS PartnerBudgetPeriod,
  P_Bseg_Add_Com.bstat AS AccountingDocumentCategory,
  P_Bseg_Add_Com.re_bukrs AS CashLedgerCompanyCode,
  P_Bseg_Add_Com.re_account AS CashLedgerAccount,
  P_Bseg_Add_Com.bdgt_account_cocode AS PubSecBudgetAccountCoCode,
  P_Bseg_Add_Com.bdgt_account AS PubSecBudgetAccount,
  P_Bseg_Add_Com.h_hwaer AS CompanyCodeCurrency,
  P_Bseg_Add_Com.dmbtr_shl AS AmountInCompanyCodeCurrency,
  P_Bseg_Add_Com.rfccur AS FunctionalCurrency,
  P_Bseg_Add_Com.fcsl_shl AS AmountInFunctionalCurrency,
  P_Bseg_Add_Com.mwsts_shl AS TaxAmountInCoCodeCrcy,
  P_Bseg_Add_Com.bdiff_shl AS ValuationDiffAmtInCoCodeCrcy,
  P_Bseg_Add_Com.h_waers AS TransactionCurrency,
  P_Bseg_Add_Com.wrbtr_shl AS AmountInTransactionCurrency,
  P_Bseg_Add_Com.wmwst_shl AS TaxAmount,
  P_Bseg_Add_Com.pswsl AS BalanceTransactionCurrency,
  P_Bseg_Add_Com.pswbt_shl AS AmountInBalanceTransacCrcy,
  P_Bseg_Add_Com.h_hwae2 AS AdditionalCurrency1,
  P_Bseg_Add_Com.bdif2_shl AS ValuationDiffAmtInAddlCrcy1,
  P_Bseg_Add_Com.dmbe2_shl AS AmountInAdditionalCurrency1,
  P_Bseg_Add_Com.h_hwae3 AS AdditionalCurrency2,
  P_Bseg_Add_Com.dmbe3_shl AS AmountInAdditionalCurrency2,
  P_Bseg_Add_Com.bdif3_shl AS ValuationDiffAmtInAddlCrcy2,
  P_Bseg_Add_Com.meins AS BaseUnit,
  P_Bseg_Add_Com.menge AS Quantity,
  P_Bseg_Add_Com.nbritm AS NumberOfItems,
  P_Bseg_Add_Com.kblnr AS EarmarkedFunds,
  P_Bseg_Add_Com.kblpos AS EarmarkedFundsItem
FROM P_Bseg_Add_Com
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON CompanyCode = _JournalEntry.CompanyCode AND FiscalYear = _JournalEntry.FiscalYear AND AccountingDocument = _JournalEntry.AccountingDocument  -- association [1..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_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInChartOfAccounts.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_Segment AS _Segment ON Segment = _Segment.Segment  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- 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]
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_FinancialAccountType AS _FinancialAccountType ON FinancialAccountType = _FinancialAccountType.FinancialAccountType  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- 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_InternalOrder AS _InternalOrder ON OrderID = _InternalOrder.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElementInternalID ON WBSElementInternalID = _WBSElementInternalID.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
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_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_InventoryValuationType AS _InventoryValuationType ON InventoryValuationType = _InventoryValuationType.InventoryValuationType  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _PartnerSegment ON PartnerSegment = _PartnerSegment.Segment  -- 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_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_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_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_ProfitCenter AS _PartnerProfitCenter ON ControllingArea = _PartnerProfitCenter.ControllingArea AND PartnerProfitCenter = _PartnerProfitCenter.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_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _PartnerFunctionalArea ON PartnerFunctionalArea = _PartnerFunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _OffsettingAccount ON ChartOfAccounts = _OffsettingAccount.ChartOfAccounts AND OffsettingAccount = _OffsettingAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAccountType AS _OffsettingAccountType ON OffsettingAccountType = _OffsettingAccountType.GLAccountType  -- association [0..1]
LEFT OUTER JOIN I_FinancialAccountType AS _OffsettingAccountType_2 ON OffsettingAccountType = _OffsettingAccountType_2.FinancialAccountType  -- association [0..1]
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_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_OffsettingAccount AS _OffsettingAccountWithBP ON OffsettingChartOfAccounts = _OffsettingAccountWithBP.ChartOfAccounts AND OffsettingAccountType = _OffsettingAccountWithBP.OffsettingAccountType AND OffsettingAccount = _OffsettingAccountWithBP.OffsettingAccount  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _OffsettingChartOfAccounts ON OffsettingChartOfAccounts = _OffsettingChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
;