P_CtrlgOvhdJournalEntryItem

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 P_CtrlgOvhdJournalEntryItem.
-- 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.
-- SQL view name: PCTRLGOVHDJEI

CREATE VIEW P_CtrlgOvhdJournalEntryItem AS
SELECT
  _CtrlgOvhdRefDoc.controllingobject AS ControllingObject,
  _CtrlgOvhdRefDoc.controllingoverheaddraftuuid AS ControllingOverheadDraftUUID,
  SourceLedger,
  _JournalEntryItem.CompanyCode AS CompanyCode,
  _JournalEntryItem.FiscalYear AS FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  _JournalEntryItem.Ledger AS Ledger,
  _JournalEntryItem._Ledger.IsLeadingLedger AS IsLeadingLedger,
  LedgerFiscalYear,
  FiscalPeriod,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  CostCenter,
  ProfitCenter,
  Segment,
  cast(FunctionalArea as fm_efarea) AS FunctionalArea,
  cast(Fund as fm_efonds) AS Fund,
  cast(BudgetPeriod as fm_ebudget_period) AS BudgetPeriod,
  cast(GrantID as gm_grant_receiver) AS GrantID,
  cast(PartnerFunctionalArea as fm_sfarea) AS PartnerFunctionalArea,
  cast(PartnerFund as fm_sfonds) AS PartnerFund,
  cast(PartnerBudgetPeriod as fm_sbudget_period) AS PartnerBudgetPeriod,
  cast(PartnerGrant as gm_grant_sender) AS PartnerGrant,
  BusinessTransactionType,
  DebitCreditCode,
  FinancialTransactionType,
  GLAccount,
  GLRecordType,
  WBSElement,
  BalanceTransactionCurrency,
  TransactionCurrency,
  CompanyCodeCurrency,
  GlobalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  ControllingObjectCurrency,
  BaseUnit,
  AmountInBalanceTransacCrcy,
  AmountInTransactionCurrency,
  AmountInCompanyCodeCurrency,
  AmountInGlobalCurrency,
  AmountInFreeDefinedCurrency1,
  AmountInFreeDefinedCurrency2,
  AmountInFreeDefinedCurrency3,
  AmountInFreeDefinedCurrency4,
  AmountInFreeDefinedCurrency5,
  AmountInFreeDefinedCurrency6,
  AmountInFreeDefinedCurrency7,
  AmountInFreeDefinedCurrency8,
  Quantity,
  FixedQuantity,
  ValuationQuantity,
  ValuationFixedQuantity
FROM fco_ovhd_refdr AS _CtrlgOvhdRefDoc
INNER JOIN fco_ovhd_stadr AS _CtrlgOvhdStat ON /* join condition not captured in parsed metadata */
INNER JOIN I_JournalEntryItem AS _JournalEntryItem ON /* join condition not captured in parsed metadata */
;