Skip to content

Instantly share code, notes, and snippets.

@SaibotFlow
Last active August 8, 2023 14:27
Show Gist options
  • Select an option

  • Save SaibotFlow/f188e7668811fa3725d20a48267269bc to your computer and use it in GitHub Desktop.

Select an option

Save SaibotFlow/f188e7668811fa3725d20a48267269bc to your computer and use it in GitHub Desktop.
Get SAP system type with description
DATA: lv_category TYPE char1,
lv_category_text TYPE string.
SELECT SINGLE b~ddtext, a~cccategory FROM t000 AS a
INNER JOIN dd07t AS b ON b~domvalue_l = a~cccategory
WHERE a~mandt = @sy-mandt
AND b~ddlanguage = @sy-langu
AND b~domname = 'CCCATEGORY'
INTO (@lv_category_text, @lv_category).
@SaibotFlow
Copy link
Author

CCCATEGORY is the key here.

  • P = Productive
  • T = Test
  • C = Customizing
  • D = Demo
  • E = Training/Education
  • S = SAP Reference

Descriptions depend on the language

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment