I_USFedOplAcctgDocItem

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_USFedOplAcctgDocItem.
-- 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_USFedOplAcctgDocItem AS
SELECT
  Item.CompanyCode AS CompanyCode,
  Item.AccountingDocument AS AccountingDocument,
  Item.FiscalYear AS FiscalYear,
  Item.AccountingDocumentItem AS AccountingDocumentItem,
  Item.USFedGovernmentUUID AS USFedGovernmentUUID,
  Item.IsReversal AS IsReversal,
  Item.IsReversed AS IsReversed,
  Item.ReversalReason AS ReversalReason,
  Item.InvoiceReference AS InvoiceReference,
  Item.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  Item.InvoiceItemReference AS InvoiceItemReference,
  Item.AccountingDocumentType AS AccountingDocumentType,
  Item.FinancialAccountType AS FinancialAccountType,
  Item.IsOpenItemManaged AS IsOpenItemManaged,
  Item.DocumentDate AS DocumentDate,
  Item.DebitCreditCode AS DebitCreditCode,
  Item.PostingDate AS PostingDate,
  Item.ChartOfAccounts AS ChartOfAccounts,
  Item.GLAccount AS GLAccount,
  Item.OffsettingChartOfAccounts AS OffsettingChartOfAccounts,
  Item.OffsettingAccount AS OffsettingAccount,
  Item.OffsettingAccountType AS OffsettingAccountType,
  Item.PaymentDifferenceReason AS PaymentDifferenceReason,
  Item.PaymentTerms AS PaymentTerms,
  Item.NetDueDate AS NetDueDate,
  Item.IsUsedInPaymentTransaction AS IsUsedInPaymentTransaction,
  Item.ClearingJournalEntry AS ClearingJournalEntry,
  Item.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  Item.ClearingItem AS ClearingItem,
  Item.FinancialManagementArea AS FinancialManagementArea,
  Item.Fund AS Fund,
  Item.BudgetPeriod AS BudgetPeriod,
  Item.FundsCenter AS FundsCenter,
  Item.FunctionalArea AS FunctionalArea,
  Item.FundedProgram AS FundedProgram,
  Item.Customer AS Customer,
  Item.PartnerCompany AS PartnerCompany,
  Item.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  Item.CompanyCodeCurrency AS CompanyCodeCurrency
FROM P_USFedOplAcctgDocItem AS Item
;