/SAM4U/BTL_L_CONSOLIDATION_SYS

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 /SAM4U/BTL_L_CONSOLIDATION_SYS.
-- 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: /SAM4U/BTLQCNSS

CREATE VIEW /SAM4U/BTL_L_CONSOLIDATION_SYS AS
SELECT
  ConsolidationSystem.consolidationguid AS ConsolidationGUID,
  ConsolidationSystem.systemid AS SystemId,
  ConsolidationNames.consolidationname AS ConsolidationName,
  ConsolidationSystem.createdat AS CreatedAt,
  ConsolidationSystem.createdby AS CreatedById,
  CreatedUser.UserFullName AS CreatedByName,
  ConsolidationSystem.changedat AS ChangedAt,
  ConsolidationSystem.changedby AS ChangedById,
  ChangedUser.UserFullName AS ChangedByName,
  Dataset.createdat AS UpdatedOn,
  ConsolidationSystem.is_archived AS IsArchived,
  ConsolidationSystem.is_deleted AS IsDeleted,
  ConsolidationNames.is_favorite AS IsFavorite,
  System.SystemInstallation AS SystemInstallation,
  System.SystemName AS SystemName,
  System.SystemSysId AS SystemSysId,
  System.SystemClient AS SystemClient,
  System.DestinationId AS DestinationId,
  System.SystemDescription AS SystemDescription,
  System.StatusId AS StatusId,
  Status.StatusText AS StatusText,
  ConsolidationSystem.datasetguid AS DatasetGUID,
  cast(substring(Dataset.datasetid, 1, 10) as abap.numc(10)) AS DatasetNumber,
  cast(substring(Dataset.datasetid, 11, 6) as abap.numc(6)) AS DatasetVersion,
  Dataset.statusid AS DatasetStatusId,
  DatasetStatus.StatusText AS DatasetStatusText,
  Dataset.createdat AS DatasetAt,
  Dataset.users AS Users,
  Dataset.roles AS Roles,
  Dataset.profiles AS Profiles,
  Dataset.developers AS Developers,
  Dataset.fues AS FUEs,
  Dataset.fues - DatasetSource.fues AS FUEsDelta,
  cast(Dataset.fues * Price.price * 12 as abap.int8) AS Cost,
  cast((Dataset.fues - DatasetSource.fues) * Price.price * 12 as abap.int8) AS CostDelta,
  Price.price_currency AS CostCurrency,
  Dataset.fues_active AS FUEsActive,
  Dataset.fues_active - DatasetSource.fues_active AS FUEsActiveDelta,
  Dataset.source AS SourceId,
  cast( case when Dataset.source = '1' then 'Remotely Transferred Dataset' when Dataset.source = '2' then 'SAM4U Data Extraction File' when Dataset.source = '3' then 'STAR Data Extraction File' end as abap.char( 50 ) ) as Source AS char50asSource,
  Dataset.segments_count AS SegmentsCount
FROM /sam4u/btl_ccnss AS ConsolidationSystem
LEFT OUTER JOIN /SAM4U/BTL_L_USER AS CreatedUser ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /SAM4U/BTL_L_USER AS ChangedUser ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /SAM4U/BTL_L_SYSTEM AS System ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /SAM4U/BTL_L_STATUS_TEXT AS Status ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /sam4u/btl_dset AS Dataset ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /SAM4U/BTL_L_STATUS_TEXT AS DatasetStatus ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /SAM4U/BTL_L_PRICING_TENANT AS Price ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /SAM4U/BTL_L_DATASET_SOURCE AS DatasetToSource ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /sam4u/btl_dset AS DatasetSource ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /sam4u/btl_ccns AS ConsolidationNames ON /* join condition not captured in parsed metadata */
;