I_TotalBlockStatusText

DDL: I_TOTALBLOCKSTATUSTEXT SQL: ISDTOTBLKSTST Type: view BASIC

Total Block Status - Text

I_TotalBlockStatusText (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Supply Chain

I_TotalBlockStatusText is a Basic CDS View that provides data about "Total Block Status - Text" in SAP S/4HANA. It reads from 1 data source (tvbst) and exposes 5 fields with key fields TotalBlockStatus, Language.

SAP API Hub

StateC1
Line of BusinessSupply Chain
Application ComponentLE-SHP-GF
CapabilitiesLanguage-Dependent Text, Data Source for Data Extraction
PackageSupply Chain for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view is the basic interface view for block statuses of delivery documents. You can use this CDS view to build your own consumption view on top.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
tvbst tvbst from

Annotations (13)

NameValueLevelField
Analytics.dataExtraction.enabled true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey TotalBlockStatus view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Total Block Status - Text view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ISDTOTBLKSTST view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY TotalBlockStatus statu General SD status
KEY Language spras Off. Language
TotalBlockStatusDesc bezei Status Description
_TotalBlockStatus _TotalBlockStatus
_Language _Language

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 I_TotalBlockStatusText.
-- 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: ISDTOTBLKSTST

CREATE VIEW I_TotalBlockStatusText AS
SELECT
  statu AS TotalBlockStatus,
  spras AS Language,
  bezei AS TotalBlockStatusDesc
FROM tvbst
;