DHSQL_REPLICATION_PORTIONS

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 DHSQL_REPLICATION_PORTIONS.
-- 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 DHSQL_REPLICATION_PORTIONS AS
SELECT
  pack.producer_id AS producer_id,
  pack.buffer_id AS buffer_id,
  pack.package_id AS package_id,
  pack.Objname AS Objname,
  pack.Objtype AS Objtype,
  repln.sql_service_name AS SqlServiceName,
  repln.alias_name AS AliasName,
  coalesce( repls.sql_service_name_raw, repln.sql_service_name ) AS SqlServiceNameRaw,
  coalesce( repls.external_entity_name_raw, repln.alias_name ) AS AliasNameRaw,
  repln.cds_view_name AS CdsViewName,
  repln.process_option AS ProcessOption,
  repln.action AS Action,
  repln.status AS Status,
  repln.portion_size AS PortionSize,
  repln.max_parallel_portion_load AS MaxParallelPortionLoad,
  repln.max_parallel_portion_delta AS MaxParallelPortionDelta,
  repln.projection AS Projection,
  repln.filter AS Filter,
  repln.uname AS Uname,
  repln.sappassport AS Sappassport,
  repln.epp_component_type AS EppComponentType,
  repln.epp_action_type AS EppActionType,
  repln.epp_action AS EppAction,
  repln.created_at AS CreatedAt,
  repln.changed_at AS ChangedAt,
  pack.Status AS PackageStatus,
  pack.StatusTs AS StatusTs,
  pack.NumberofRecords AS NumberofRecords,
  pack.ProcessedRecords AS ProcessedRecords,
  pack.ProcessedBytes AS ProcessedBytes,
  pack.PrioReadEnabled AS PrioReadEnabled,
  pack.PartitionId AS PartitionId,
  pack.ProducerType AS ProducerType,
  pack.ConsumerType AS ConsumerType
FROM dhsql_replicatn AS repln
INNER JOIN DHRDB_API_PACKAGE AS pack ON /* join condition not captured in parsed metadata */
;