I_CACaseAttribute

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_CACaseAttribute.
-- 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: ICADISCASEATTR

CREATE VIEW I_CACaseAttribute AS
SELECT
  udmcaseattr10.case_guid AS CaseUUID,
  udmcaseattr10.fica_gpart AS BusinessPartner,
  udmcaseattr10.fica_vkont AS ContractAccount,
  udmcaseattr10.fica_vtref AS CAContract,
  udmcaseattr10.fica_applk AS CAApplicationArea,
  udmcaseattr10.fica_subap AS CASubApplication,
  udmcaseattr10.fica_disputed_am AS DisputedAmount,
  cast( udmcaseattr10.fica_totalinv_am as fica_totalinv_amt_gfn preserving type ) AS TotalReceivablesAmount,
  cast( udmcaseattr10.fica_totalcor_am as fica_totalcor_amt_gfn preserving type ) AS DisputeCaseCorrectionAmount,
  cast( udmcaseattr10.fica_reversed_am as fica_reversed_amt_gfn preserving type ) AS DisputeCaseReversedAmount,
  cast( udmcaseattr10.fica_credited_am as fica_credited_amt_gfn preserving type ) AS CreditedAmount,
  cast( udmcaseattr10.fica_writeoff_am as fica_writeoff_amt_gfn preserving type ) AS WriteOffAmount,
  cast( udmcaseattr10.fica_replaced_am as fica_replaced_amt_gfn preserving type ) AS DisputeCaseReplacedAmount,
  cast( udmcaseattr10.fica_paid_am as fica_paid_amt_gfn preserving type ) AS PaidAmount,
  udmcaseattr10.fin_dispute_curr AS DisputeCaseCurrency,
  udmcaseattr10.fin_log_system AS LogicalSystem,
  udmcaseattr10.fica_int_reason AS CADisputeType,
  udmcaseattr10.fin_bukrs AS CompanyCode,
  udmcaseattr10.fin_coordinator AS DisputeCaseCoordinator,
  udmcaseattr10.fin_root_ccode AS DisputeCaseRootCause,
  udmcaseattr10.fin_due_date AS CaseProcessingDeadlineDate,
  udmcaseattr10.fin_contact_name AS ContactPersonFullName,
  udmcaseattr10.fin_contact_mail AS ContactPersonEmailAddress,
  udmcaseattr10.fin_contact_tel AS ContactPersonPhoneNumber,
  udmcaseattr10.fin_contact_fax AS ContactPersonFaxNumber,
  udmcaseattr10.fin_contact_faxc AS ContactPersonFaxCountry,
  udmcaseattr10.fica_contact_key AS DisputeCaseBPCorrespondenceKey,
  udmcaseattr10.fin_stat_para AS CaseSystemStatus,
  udmcaseattr10.fica_info1 AS DisputeCaseInformationText,
  udmcaseattr10.fica_date1 AS DisputeCaseTransactionDate,
  udmcaseattr10.fica_intky AS CADisputeCase,
  fin_origin AS DisputeCaseOrigin,
  sdm_status AS CACaseConversionStatus
FROM udmcaseattr10
;