I_CFinTemporaryPostingItem

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_CFinTemporaryPostingItem.
-- 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_CFinTemporaryPostingItem AS
SELECT
  cast ( msgguid as fins_cfin_repltra_guid preserving type ) AS CFinRpldTransactionUUID,
  cast ( posnr as posnr_acc preserving type ) AS AccountingDocumentItemRef,
  cast ( logsystem_sender as fis_logsystem_sender preserving type ) AS SenderLogicalSystem,
  cast ( bukrs_sender as bukrs_sender preserving type ) AS SenderCompanyCode,
  cast ( belnr_sender as fis_belnr_sender preserving type ) AS SenderAccountingDocument,
  cast ( gjahr_sender as gjahr_sender preserving type ) AS SenderFiscalYear,
  cast ( bukrs as fis_bukrs preserving type ) AS CompanyCode,
  cast ( gjahr as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  cast ( buzei as farp_buzei preserving type ) AS AccountingDocumentItem,
  cast ( bschl as fis_bschl preserving type ) AS PostingKey,
  cast ( wrbtr as fis_wsl preserving type ) AS AmountInTransactionCurrency,
  cast ( waers as waers preserving type ) AS TransactionCurrency,
  cast ( dmbtr as fis_hsl preserving type ) AS AmountInCompanyCodeCurrency,
  cast ( currkey_10 as fagl_currkey_10 preserving type ) AS CompanyCodeCurrency,
  cast ( shkzg as fis_shkzg preserving type ) AS DebitCreditCode,
  cast ( mwskz as fis_mwskz preserving type ) AS TaxCode,
  cast ( umskz as fis_umskz preserving type ) AS SpecialGLCode,
  cast ( kokrs as fis_kokrs preserving type ) AS ControllingArea,
  cast ( kostl as fis_kostl preserving type ) AS CostCenter,
  cast ( prctr as fis_prctr preserving type ) AS ProfitCenter,
  cast ( koart as fis_koart preserving type ) AS FinancialAccountType,
  cast ( hkont as fis_racct preserving type ) AS GLAccount,
  cast ( lifnr as lifnr preserving type ) AS Supplier,
  cast ( kunnr as kunnr preserving type ) AS Customer,
  cast ( vbund as vbund preserving type ) AS TradingPartner,
  cast ( matnr as matnr preserving type ) AS Material,
  cast ( rmvct as fis_rmvct preserving type ) AS FinancialTransactionType,
  cast ( dmbe2 as dmbe2 preserving type ) AS AmountInGroupCurrency,
  cast ( currkey_30 as fagl_currkey_30 preserving type ) AS GroupCurrency,
  last_changed_at AS DraftLastChangedDateTime
FROM cfin_tmp_it AS Item
;