DHADM_SEARCH_ObjRecordingObj

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 DHADM_SEARCH_ObjRecordingObj.
-- 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 DHADM_SEARCH_ObjRecordingObj AS
SELECT
  obj.objname AS ObjectName,
  obj.objtype AS ObjectType,
  obj.appltab_name AS ApplicationTableName,
  objtypetx.Text AS ObjectTypeText,
  ovw.MasterLogtabStatus AS MasterLogtabStatus,
  ovw.MasterLogtabStatusText AS MasterLogtabStatusText,
  ovw.MasterLogtabName AS MasterLogtabName,
  ovw.MasterLogtabRecords AS MasterLogtabRecords,
  ovw.SubscriberLogtabStatus AS SubscriberLogtabStatus,
  ovw.SubscriberLogtabStatusText AS SubscriberLogtabStatusText,
  ovw.SubscriberLogtabName AS SubscriberLogtabName,
  ovw.SubscriberLogtabRecords AS SubscriberLogtabRecords,
  ovw.TriggerNamePrefix AS TriggerNamePrefix,
  ovw.TriggerStatus AS TriggerStatus,
  ovw.TriggerStatusText AS TriggerStatusText,
  ovw.MasterLogtabSequenceName AS MasterLogtabSequenceName,
  ovw.MasterLogtabSequenceValue AS MasterLogtabSequenceValue,
  ovw.SubscriberLogtabSequenceName AS SubscriberLogtabSequenceName,
  ovw.SubscriberLogtabSequenceValue AS SubscriberLogtabSequenceValue
FROM DHADM_REC_ObjectToRecObjects AS obj
LEFT OUTER JOIN DHADM_REC_ObjectsOverview AS ovw ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN DHADM_REC_ObjectTypeText AS objtypetx ON /* join condition not captured in parsed metadata */
;