CTE_FIN_SUBS_IMPORTING_ENTRY

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 CTE_FIN_SUBS_IMPORTING_ENTRY.
-- 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: CTE_FIN_S_I_ENT

CREATE VIEW CTE_FIN_SUBS_IMPORTING_ENTRY AS
SELECT
  entry_id AS EntryId,
  legacy_entry_id AS LegacyEntryId,
  expense_type_name AS ExpenseTypeName,
  expense_type_code AS ExpenseTypeCode,
  entry_date AS EntryDate,
  entry_currency_code AS EntryCurrencyCode,
  exchange_rate AS ExchangeRate,
  exchange_rate_direction AS ExchangeRateDirection,
  is_personal AS IsPersonal,
  entry_description AS EntryDescription,
  vendor_code AS VendorCode,
  vendor_description AS VendorDescription,
  entry_receipt_type AS EntryReceiptType,
  entry_org_unit1_code AS EntryOrgUnit1Code,
  entry_org_unit1_value AS EntryOrgUnit1Value,
  entry_org_unit2_code AS EntryOrgUnit2Code,
  entry_org_unit2_value AS EntryOrgUnit2Value,
  entry_org_unit3_code AS EntryOrgUnit3Code,
  entry_org_unit3_value AS EntryOrgUnit3Value,
  entry_org_unit4_code AS EntryOrgUnit4Code,
  entry_org_unit4_value AS EntryOrgUnit4Value,
  entry_org_unit5_code AS EntryOrgUnit5Code,
  entry_org_unit5_value AS EntryOrgUnit5Value,
  entry_org_unit6_code AS EntryOrgUnit6Code,
  entry_org_unit6_value AS EntryOrgUnit6Value,
  entry_custom1_code AS EntryCustom1Code,
  entry_custom1_value AS EntryCustom1Value,
  entry_custom2_code AS EntryCustom2Code,
  entry_custom2_value AS EntryCustom2Value,
  entry_custom3_code AS EntryCustom3Code,
  entry_custom3_value AS EntryCustom3Value,
  entry_custom4_code AS EntryCustom4Code,
  entry_custom4_value AS EntryCustom4Value,
  entry_custom5_code AS EntryCustom5Code,
  entry_custom5_value AS EntryCustom5Value,
  entry_custom6_code AS EntryCustom6Code,
  entry_custom6_value AS EntryCustom6Value,
  entry_custom7_code AS EntryCustom7Code,
  entry_custom7_value AS EntryCustom7Value,
  entry_custom8_code AS EntryCustom8Code,
  entry_custom8_value AS EntryCustom8Value,
  entry_custom9_code AS EntryCustom9Code,
  entry_custom9_value AS EntryCustom9Value,
  entry_custom10_code AS EntryCustom10Code,
  entry_custom10_value AS EntryCustom10Value,
  entry_custom11_code AS EntryCustom11Code,
  entry_custom11_value AS EntryCustom11Value,
  entry_custom12_code AS EntryCustom12Code,
  entry_custom12_value AS EntryCustom12Value,
  entry_custom13_code AS EntryCustom13Code,
  entry_custom13_value AS EntryCustom13Value,
  entry_custom14_code AS EntryCustom14Code,
  entry_custom14_value AS EntryCustom14Value,
  entry_custom15_code AS EntryCustom15Code,
  entry_custom15_value AS EntryCustom15Value,
  entry_custom16_code AS EntryCustom16Code,
  entry_custom16_value AS EntryCustom16Value,
  entry_custom17_code AS EntryCustom17Code,
  entry_custom17_value AS EntryCustom17Value,
  entry_custom18_code AS EntryCustom18Code,
  entry_custom18_value AS EntryCustom18Value,
  entry_custom19_code AS EntryCustom19Code,
  entry_custom19_value AS EntryCustom19Value,
  entry_custom20_code AS EntryCustom20Code,
  entry_custom20_value AS EntryCustom20Value,
  entry_custom21_code AS EntryCustom21Code,
  entry_custom21_value AS EntryCustom21Value,
  entry_custom22_code AS EntryCustom22Code,
  entry_custom22_value AS EntryCustom22Value,
  entry_custom23_code AS EntryCustom23Code,
  entry_custom23_value AS EntryCustom23Value,
  entry_custom24_code AS EntryCustom24Code,
  entry_custom24_value AS EntryCustom24Value,
  entry_custom25_code AS EntryCustom25Code,
  entry_custom25_value AS EntryCustom25Value,
  entry_custom26_code AS EntryCustom26Code,
  entry_custom26_value AS EntryCustom26Value,
  entry_custom27_code AS EntryCustom27Code,
  entry_custom27_value AS EntryCustom27Value,
  entry_custom28_code AS EntryCustom28Code,
  entry_custom28_value AS EntryCustom28Value,
  entry_custom29_code AS EntryCustom29Code,
  entry_custom29_value AS EntryCustom29Value,
  entry_custom30_code AS EntryCustom30Code,
  entry_custom30_value AS EntryCustom30Value,
  entry_custom31_code AS EntryCustom31Code,
  entry_custom31_value AS EntryCustom31Value,
  entry_custom32_code AS EntryCustom32Code,
  entry_custom32_value AS EntryCustom32Value,
  entry_custom33_code AS EntryCustom33Code,
  entry_custom33_value AS EntryCustom33Value,
  entry_custom34_code AS EntryCustom34Code,
  entry_custom34_value AS EntryCustom34Value,
  entry_custom35_code AS EntryCustom35Code,
  entry_custom35_value AS EntryCustom35Value,
  entry_custom36_code AS EntryCustom36Code,
  entry_custom36_value AS EntryCustom36Value,
  entry_custom37_code AS EntryCustom37Code,
  entry_custom37_value AS EntryCustom37Value,
  entry_custom38_code AS EntryCustom38Code,
  entry_custom38_value AS EntryCustom38Value,
  entry_custom39_code AS EntryCustom39Code,
  entry_custom39_value AS EntryCustom39Value,
  entry_custom40_code AS EntryCustom40Code,
  entry_custom40_value AS EntryCustom40Value,
  entry_custom41_code AS EntryCustom41Code,
  entry_custom41_value AS EntryCustom41Value,
  entry_custom42_code AS EntryCustom42Code,
  entry_custom42_value AS EntryCustom42Value,
  entry_custom43_code AS EntryCustom43Code,
  entry_custom43_value AS EntryCustom43Value,
  entry_custom44_code AS EntryCustom44Code,
  entry_custom44_value AS EntryCustom44Value,
  entry_custom45_code AS EntryCustom45Code,
  entry_custom45_value AS EntryCustom45Value,
  entry_custom46_code AS EntryCustom46Code,
  entry_custom46_value AS EntryCustom46Value,
  entry_custom47_code AS EntryCustom47Code,
  entry_custom47_value AS EntryCustom47Value,
  entry_custom48_code AS EntryCustom48Code,
  entry_custom48_value AS EntryCustom48Value,
  entry_custom49_code AS EntryCustom49Code,
  entry_custom49_value AS EntryCustom49Value,
  entry_custom50_code AS EntryCustom50Code,
  entry_custom50_value AS EntryCustom50Value,
  entry_custom51_code AS EntryCustom51Code,
  entry_custom51_value AS EntryCustom51Value,
  entry_custom52_code AS EntryCustom52Code,
  entry_custom52_value AS EntryCustom52Value,
  entry_custom53_code AS EntryCustom53Code,
  entry_custom53_value AS EntryCustom53Value,
  entry_custom54_code AS EntryCustom54Code,
  entry_custom54_value AS EntryCustom54Value,
  entry_custom55_code AS EntryCustom55Code,
  entry_custom55_value AS EntryCustom55Value,
  entry_custom56_code AS EntryCustom56Code,
  entry_custom56_value AS EntryCustom56Value,
  entry_custom57_code AS EntryCustom57Code,
  entry_custom57_value AS EntryCustom57Value,
  entry_custom58_code AS EntryCustom58Code,
  entry_custom58_value AS EntryCustom58Value,
  entry_custom59_code AS EntryCustom59Code,
  entry_custom59_value AS EntryCustom59Value,
  entry_custom60_code AS EntryCustom60Code,
  entry_custom60_value AS EntryCustom60Value,
  entry_custom61_code AS EntryCustom61Code,
  entry_custom61_value AS EntryCustom61Value,
  entry_custom62_code AS EntryCustom62Code,
  entry_custom62_value AS EntryCustom62Value,
  entry_custom63_code AS EntryCustom63Code,
  entry_custom63_value AS EntryCustom63Value,
  entry_custom64_code AS EntryCustom64Code,
  entry_custom64_value AS EntryCustom64Value,
  entry_custom65_code AS EntryCustom65Code,
  entry_custom65_value AS EntryCustom65Value,
  entry_custom66_code AS EntryCustom66Code,
  entry_custom66_value AS EntryCustom66Value,
  entry_custom67_code AS EntryCustom67Code,
  entry_custom67_value AS EntryCustom67Value,
  entry_custom68_code AS EntryCustom68Code,
  entry_custom68_value AS EntryCustom68Value,
  entry_custom69_code AS EntryCustom69Code,
  entry_custom69_value AS EntryCustom69Value,
  entry_custom70_code AS EntryCustom70Code,
  entry_custom70_value AS EntryCustom70Value,
  entry_custom71_code AS EntryCustom71Code,
  entry_custom71_value AS EntryCustom71Value,
  entry_custom72_code AS EntryCustom72Code,
  entry_custom72_value AS EntryCustom72Value,
  entry_custom73_code AS EntryCustom73Code,
  entry_custom73_value AS EntryCustom73Value,
  entry_custom74_code AS EntryCustom74Code,
  entry_custom74_value AS EntryCustom74Value,
  entry_custom75_code AS EntryCustom75Code,
  entry_custom75_value AS EntryCustom75Value,
  entry_custom76_code AS EntryCustom76Code,
  entry_custom76_value AS EntryCustom76Value,
  entry_custom77_code AS EntryCustom77Code,
  entry_custom77_value AS EntryCustom77Value,
  entry_custom78_code AS EntryCustom78Code,
  entry_custom78_value AS EntryCustom78Value,
  entry_custom79_code AS EntryCustom79Code,
  entry_custom79_value AS EntryCustom79Value,
  entry_custom80_code AS EntryCustom80Code,
  entry_custom80_value AS EntryCustom80Value,
  approved_amount AS ApprovedAmount,
  clearing_account_code AS ClearingAccountCode,
  expense_pay_indicator AS ExpensePayIndicator,
  offset_pay_type AS OffsetPayType,
  location_city_name AS LocationCityName,
  report_entry_transaction_amoun AS ReportEntryTransactionAmoun,
  is_billable AS IsBillable,
  entry_location_name AS EntryLocationName,
  entry_country_code AS EntryCountryCode,
  entry_country_sub_code AS EntryCountrySubCode,
  entry_uuid AS EntryUuid,
  supplier_tax_id AS SupplierTaxId,
  card_account_id AS CardAccountId,
  card_transaction_id AS CardTransactionId,
  card_transaction_amount AS CardTransactionAmount,
  card_transaction_currency AS CardTransactionCurrency,
  card_transaction_posted_amount AS CardTransactionPostedAmount,
  card_trans_posted_currency AS CardTransPostedCurrency,
  card_billing_amount AS CardBillingAmount,
  card_program_type_code AS CardProgramTypeCode,
  card_statem_period_start_date AS CardStatemPeriodStartDate,
  card_statem_period_end_date AS CardStatemPeriodEndDate,
  entry_electronic_receipt_id AS EntryElectronicReceiptId,
  entry_receipt_id AS EntryReceiptId,
  report_entry_pat_key AS ReportEntryPatKey,
  request_id AS RequestId,
  request_entry_id AS RequestEntryId,
  card_billing_date AS CardBillingDate,
  entry_payment_type_code AS EntryPaymentTypeCode,
  entry_payment_type_name AS EntryPaymentTypeName,
  merchant_tax_id AS MerchantTaxId,
  liability_account_code AS LiabilityAccountCode,
  expense_pay_accounting_ind AS ExpensePayAccountingInd
FROM cte_d_fin_i_entr
;