I_SalesDocumentTypeText

DDL: I_SALESDOCUMENTTYPETEXT SQL: ISDSALESDOCTYPET Type: view BASIC
5 Fields 1 Data Sources

Sales Document Type - Text

I_SalesDocumentTypeText (Basic)

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

Sales

I_SalesDocumentTypeText is a Basic CDS View that provides data about "Sales Document Type - Text" in SAP S/4HANA. It reads from 1 data source (tvakt) and exposes 5 fields with key fields SalesDocumentType, Language.

SAP API Hub

StateC1
Line of BusinessSales
Application ComponentSD-SLS-GF
CapabilitiesLanguage-Dependent Text, Data Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Data Extraction, Data Source for Defining CDS Entities, Data Source for Search
PackageSales for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides the prerequisites for answering the following business question:</p> <ul> <li><p>What are the names of sales document types in different languages?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
tvakt tvakt from

Annotations (16)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey SalesDocumentType view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Sales Document Type - Text view
VDM.viewType #BASIC view
Search.searchable true view
Analytics.dataExtraction.enabled true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ISDSALESDOCTYPET view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
Metadata.ignorePropagatedAnnotations true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY SalesDocumentType auart Sales Document Type
KEY Language spras Off. Language
SalesDocumentTypeName Sales Document Type Description
_SalesDocumentType
_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_SalesDocumentTypeText.
-- 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: ISDSALESDOCTYPET

CREATE VIEW I_SalesDocumentTypeText AS
SELECT
  auart AS SalesDocumentType,
  spras AS Language
FROM tvakt
;

Learn More