I_SalesDocumentTypeText

DDL: I_SALESDOCUMENTTYPETEXT SQL: ISDSALESDOCTYPET Type: view BASIC Package: VDM_SD_SLS_GF

Sales Document Type - Text

I_SalesDocumentTypeText (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public 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. It is exposed through 20 OData services (ASQL_F0333A, ASQL_F1786, ASQL_F1810, ...). Part of development package VDM_SD_SLS_GF.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessSales
Application ComponentSD-SLS-GF-2CL
CapabilitiesData Source for Data Extraction,Language-Dependent Text,Data Source in SQL Select,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities,Data Source for Search
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageSales for SAP S/4HANA Cloud Public 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

OData Services (20)

ServiceBindingVersionContractRelease
ASQL_F0333A ASQL_F0333A C2 NOT_RELEASED
ASQL_F1786 ASQL_F1786 C2 NOT_RELEASED
ASQL_F1810 ASQL_F1810 C2 NOT_RELEASED
ASQL_F2242 ASQL_F2242 C2 NOT_RELEASED
ASQL_F2964 ASQL_F2964 C2 NOT_RELEASED
ASQL_F3014 ASQL_F3014 C2 NOT_RELEASED
ASQL_F3331 ASQL_F3331 C2 NOT_RELEASED
ASQL_F3417 ASQL_F3417 C2 NOT_RELEASED
ASQL_F4185 ASQL_F4185 C2 NOT_RELEASED
ASQL_F4293 ASQL_F4293 C2 NOT_RELEASED
ASQL_F4557 ASQL_F4557 C2 NOT_RELEASED
ASQL_F5133 ASQL_F5133 C2 NOT_RELEASED
ASQL_F6191 ASQL_F6191 C2 NOT_RELEASED
ASQL_F6381 ASQL_F6381 C2 NOT_RELEASED
ASQL_F6382 ASQL_F6382 C2 NOT_RELEASED
ASQL_F7061 ASQL_F7061 C2 NOT_RELEASED
ASQL_F7062 ASQL_F7062 C2 NOT_RELEASED
ASQL_F7066 ASQL_F7066 C2 NOT_RELEASED
ASQL_F8641 ASQL_F8641 C2 NOT_RELEASED
ASQL_F8712 ASQL_F8712 C2 NOT_RELEASED

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
;