N_SAFT_CODE_SNIPPET

DDL: N_SAFT_CODE_SNIPPET Type: view_entity
9 Fields 2 Data Sources

AFT Code Snippet: Code Snippet View

N_SAFT_CODE_SNIPPET is a CDS View that provides data about "AFT Code Snippet: Code Snippet View" in SAP S/4HANA. It reads from 2 data sources (N_SAFT_CODE_SNIPPETS_CRL, N_SAFT_CODE_SNIPPET_REG) and exposes 9 fields with key fields CodeSnippetID, Origin, Origin.

Data Sources (2)

SourceAliasJoin Type
N_SAFT_CODE_SNIPPETS_CRL CRLCodeSnippets union
N_SAFT_CODE_SNIPPET_REG RegisteredCodeSnippets from

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label AFT Code Snippet: Code Snippet View view
Metadata.ignorePropagatedAnnotations true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CodeSnippetID N_SAFT_CODE_SNIPPET_REG CodeSnippetID Code Snippet ID
KEY Origin Task Origin
Description N_SAFT_CODE_SNIPPET_REG Description Well Code Des.
UpperDescription
LibraryIDasCodeSnippetID
KEY Origin N_SAFT_CODE_SNIPPETS_CRL Origin Task Origin
Description N_SAFT_CODE_SNIPPETS_CRL Description Well Code Des.
UpperDescription
BusinessContext

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 N_SAFT_CODE_SNIPPET.
-- 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 N_SAFT_CODE_SNIPPET AS
SELECT
  RegisteredCodeSnippets.CodeSnippetID AS CodeSnippetID,
  'SAP ' AS Origin,
  RegisteredCodeSnippets.Description AS Description,
  upper(RegisteredCodeSnippets.Description) AS UpperDescription,
  RegisteredCodeSnippets.BusinessContext as BusinessContext AS LibraryIDasCodeSnippetID,
  '' AS BusinessContext
FROM N_SAFT_CODE_SNIPPET_REG AS RegisteredCodeSnippets
-- UNION with additional select branch(es): N_SAFT_CODE_SNIPPETS_CRL
;

Learn More