T157H_M

DDL: T157H_M Type: view Package: MB

Text Verticalization: View for T157H

T157H_M is a CDS View that provides data about "Text Verticalization: View for T157H" in SAP S/4HANA. It reads from 1 data source (t157h) and exposes 5 fields with key fields Spras, Tcode, Bwart, Sobkz. Part of development package MB.

Data Sources (1)

SourceAliasJoin Type
t157h t157h from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName VT157H_M view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #GENERIC view
AbapCatalog.buffering.numberOfKeyFields 001 view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view
EndUserText.label Text Verticalization: View for T157H view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Spras t157h spras Off. Language
KEY Tcode t157h tcode Undefined range (can be used for patch levels)
KEY Bwart t157h bwart Valuation Type
KEY Sobkz t157h sobkz Special Stock
Htext

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 T157H_M.
-- 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 T157H_M AS
SELECT
  t157h.spras AS Spras,
  t157h.tcode AS Tcode,
  t157h.bwart AS Bwart,
  t157h.sobkz AS Sobkz,
  coalesce(t157h_i.htext,t157h.htext) AS Htext
FROM t157h
;