/SAM4U/BTL_L_SYSTEM

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_SYSTEM.
-- 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/BTLQSYS

CREATE VIEW /SAM4U/BTL_L_SYSTEM AS
SELECT
  System.systemid AS SystemId,
  substring(System.systemid, 1, 10) AS SystemInstallation,
  concat(concat(substring(System.systemid, 11, 3), '/'), substring(System.systemid, 14, 3)) AS SystemName,
  substring(System.systemid, 11, 3) AS SystemSysId,
  substring(System.systemid, 14, 3) AS SystemClient,
  System.systemno AS SystemNo,
  System.destinationid AS DestinationId,
  System.description AS SystemDescription,
  System.system_category AS SystemCategory,
  SysCategTexts.text AS SystemCategoryText,
  System.statusid AS StatusId,
  Status.StatusText AS StatusText,
  System.createdat AS CreatedAt,
  System.createdby AS CreatedById,
  CreatedUser.UserFullName AS CreatedByName,
  System.changedat AS ChangedAt,
  Dataset.createdat AS UpdatedOn,
  System.changedby AS ChangedById,
  ChangedUser.UserFullName AS ChangedByName,
  System.is_archived AS IsArchived,
  System.is_deleted AS IsDeleted,
  System.is_favorite AS IsFavorite,
  Dataset.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.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,
  Dataset.fues_active AS FUEsActive,
  Dataset.fues_active - DatasetSource.fues_active AS FUEsActiveDelta,
  cast(Dataset.fues_active * PriceActive.price * 12 as abap.int8) AS CostActive,
  cast((Dataset.fues_active - DatasetSource.fues_active) * PriceActive.price * 12 as abap.int8) AS CostActiveDelta,
  Price.price_currency AS CostCurrency,
  Dataset.segments_count AS SegmentsCount,
  Dataset.segments AS Segments,
  DomainValueText.ddtext AS ClientTypeText,
  cast('' as abap.char(6)) AS UsersTag,
  cast('' as abap.char(8)) AS EnginesTag,
  cast('' as abap.char(11)) AS DevelopersTag,
  cast('' as abap.char(4)) AS LAWTag,
  cast('' as abap.char(4)) AS HanaTag
FROM /sam4u/btl_dsys AS System
LEFT OUTER JOIN /SAM4U/BTL_L_STATUS_TEXT AS Status ON /* join condition not captured in parsed metadata */
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_L_DATASET AS SystemDataset 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_PRICING_TENANT AS Price ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /SAM4U/BTL_L_PRICING_TENANT AS PriceActive 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 dd07t AS DomainValueText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /sam4u/btl_dsctx AS SysCategTexts ON /* join condition not captured in parsed metadata */
;