C_ContractAccountTP

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 C_ContractAccountTP.
-- 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 C_ContractAccountTP AS
SELECT
  cast(ContractAccount as vkont_gfn_kk preserving type ) AS ContractAccount,
  cast(ContractAccountForEdit as vkont_gfn_kk preserving type ) AS ContractAccountForEdit,
  CreationDate,
  CreationTime,
  CreatedByUser,
  cast(_CreatedByContactCard.UserDescription as ernam_gfn_text_kk preserving type) AS CreatedByUserName,
  cast ( ContractAccount.IsMarkedForDeletion as loevm_conacct_kk preserving type ) AS IsMarkedForDeletion,
  LastChangeDate,
  LastChangeTime,
  LastChangedByUser,
  cast(_LastChangedByContactCard.UserDescription as aenam_gfn_text_kk preserving type ) AS LastChangedByUserName,
  CAApplicationArea,
  cast ( ContractAccountCategory as vktyp_conacct_kk preserving type ) AS ContractAccountCategory,
  _ContractAccountCategory._Text[1:Language = $session.system_language].ContractAccountCategoryName AS ContractAccountCategoryName,
  cast ( ContractAccountExtReference as vkona_conacct_kk preserving type ) AS ContractAccountExtReference,
  cast ( ContractAccountName as vkbez_conacct_kk preserving type ) AS ContractAccountName,
  CreationDateTime,
  LastChangeDateTime,
  PlannedChangeValidityDate,
  ContractAccountCharUUID,
  virtual UICT_HideTaxExemption : xfeld AS virtualUICT_HideTaxExemptionxfeld,
  virtual UICT_HideCreatedByUser : boole_d AS virtualUICT_HideCreatedByUserboole_d,
  virtual UICT_HideLastChangedByUser : boole_d AS virtualUICT_HideLastChangedByUserboole_d,
  virtual UICT_IsMarkedForDeletionCrit : abap.char( 1 ) AS char1
FROM R_ContractAccountTP
;