/SAM4U/BTL_L_A_DATASET_SYST_US

DDL: /SAM4U/BTL_L_A_DATASET_SYST_US SQL: /SAM4U/BTLASSU Type: view
18 Fields 4 Data Sources

Abstraction: Dataset. System Use

/SAM4U/BTL_L_A_DATASET_SYST_US is a CDS View that provides data about "Abstraction: Dataset. System Use" in SAP S/4HANA. It reads from 4 data sources (/sam4u/btl_dset, /sam4u/btl_dset, /sam4u/btl_dssu, /sam4u/btl_dssu) and exposes 18 fields with key fields datasetguid, bname, program_name, type, bname.

Data Sources (4)

SourceAliasJoin Type
/sam4u/btl_dset Dataset from
/sam4u/btl_dset Dataset union
/sam4u/btl_dssu SysUseNew left_outer
/sam4u/btl_dssu SysUseOld left_outer

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName /SAM4U/BTLASSU view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Abstraction: Dataset. System Use view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY datasetguid /sam4u/btl_dset datasetguid Object GUID
KEY bname SysUse bname User name
KEY program_name SysUse program_name Program Name
KEY type SysUse type Worklist Type
task SysUse task Task/Log Entry
unclassified SysUse unclassified Single-Character Flag
source SysUse source ViolationSource
object_type SysUse object_type Type
object_name SysUse object_name Technical Name
datasetguid Object GUID
KEY bname SysUse bname User name
KEY program_name SysUse program_name Program Name
KEY type SysUse type Worklist Type
task SysUse task Task/Log Entry
unclassified SysUse unclassified Single-Character Flag
source SysUse source ViolationSource
object_type SysUse object_type Type
object_name SysUse object_name Technical Name

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_A_DATASET_SYST_US.
-- 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/BTLASSU

CREATE VIEW /SAM4U/BTL_L_A_DATASET_SYST_US AS
SELECT
  Dataset.datasetguid AS datasetguid,
  SysUse.bname AS bname,
  SysUse.program_name AS program_name,
  SysUse.type AS type,
  SysUse.task AS task,
  SysUse.unclassified AS unclassified,
  SysUse.source AS source,
  SysUse.object_type AS object_type,
  SysUse.object_name AS object_name
FROM /sam4u/btl_dset AS Dataset
LEFT OUTER JOIN /sam4u/btl_dssu AS SysUseNew ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /sam4u/btl_dssu AS SysUseOld ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): /sam4u/btl_dset
;

Learn More