I_CnsldtnAddlCharcsTP

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_CnsldtnAddlCharcsTP.
-- 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_CnsldtnAddlCharcsTP AS
SELECT
  CnsldtnAddlCharcUUID,
  cnsldtnaddlcharcfldname AS AdditionalCharcFieldName,
  cast('' as as4text) AS AdditionalCharacteristicText,
  cnsldtnaddlmdsuprordfld AS AdditionalMasterDataSuprordFld,
  cast('' as as4text) AS AdditionalMDSuprordFieldText,
  cnsldtnaddlmdpairedfld AS AdditionalMasterDataPairedFld,
  cast(0 as fincs_number_count) AS NumberOfAdditionalMasterData,
  cast(0 as fincs_number_count) AS NumberOfAccountingMasterData,
  cast(0 as fincs_number_count) AS TotalNumberOfMasterData,
  cnsldtnaddlmdhashier AS AdditionalMasterDataHasHier,
  cnsldtnaddlmdhierisinuse AS AdditionalMDHierarchyIsInUse,
  cast( '' as fincs_hierlink ) AS NavigationToHierarchyLinkName,
  cast( '' as fincs_hierurl ) AS NavigationToHierarchyURL
FROM fincs_addlcharc
LEFT OUTER JOIN I_CnsldtnAddlMDTP AS _MDRecord ON CnsldtnAddlCharcUUID = _MDRecord.CnsldtnAddlCharcUUID  -- association [0..*]
;