P_RunSettlmtJournalEntryItem

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_RunSettlmtJournalEntryItem.
-- 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: PRUNSETTLJEI

CREATE VIEW P_RunSettlmtJournalEntryItem AS
SELECT
  _RunSettlmtRefDoc.controllingobject AS ControllingObject,
  _RunSettlmtRefDoc.settlementdraftuuid AS SettlementDraftUUID,
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  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,
  FunctionalCurrency,
  BaseUnit,
  AmountInBalanceTransacCrcy,
  AmountInTransactionCurrency,
  AmountInCompanyCodeCurrency,
  AmountInGlobalCurrency,
  AmountInFreeDefinedCurrency1,
  AmountInFreeDefinedCurrency2,
  AmountInFreeDefinedCurrency3,
  AmountInFreeDefinedCurrency4,
  AmountInFreeDefinedCurrency5,
  AmountInFreeDefinedCurrency6,
  AmountInFreeDefinedCurrency7,
  AmountInFreeDefinedCurrency8,
  AmountInFunctionalCurrency,
  Quantity,
  FixedQuantity,
  ValuationQuantity,
  ValuationFixedQuantity,
  _JournalEntryItem.AssetDepreciationArea AS AssetDepreciationArea,
  _JournalEntryItem.MasterFixedAsset AS MasterFixedAsset,
  _JournalEntryItem.FixedAsset AS FixedAsset,
  _JournalEntryItem.AssetValueDate AS AssetValueDate,
  cast(_JournalEntryItem.AssetTransactionType as fco_asset_transaction_type) AS AssetTransactionType,
  _JournalEntryItem.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  _JournalEntryItem.AssetClass AS AssetClass,
  _JournalEntryItem.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  _JournalEntryItem.FinancialAccountType AS FinancialAccountType,
  _JournalEntryItem.PartnerMasterFixedAsset AS PartnerMasterFixedAsset,
  _JournalEntryItem.PartnerFixedAsset AS PartnerFixedAsset
FROM fco_refdoc_dr AS _RunSettlmtRefDoc
INNER JOIN I_JournalEntryItem AS _JournalEntryItem ON /* join condition not captured in parsed metadata */
;