I_IntlTrdDocumentCategoryText
Document Category Text
I_IntlTrdDocumentCategoryText is a Basic CDS View that provides data about "Document Category Text" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 5 fields with key fields Language, ReferenceDocumentCategory. It has 2 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| dd07t | dd07t | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_Language | _Language | _Language.Language = $projection.Language |
| [0..1] | I_IntlTrdDocumentCategory | _IntlTrdDocumentCategory | _IntlTrdDocumentCategory.ReferenceDocumentCategory = $projection.ReferenceDocumentCategory |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Document Category Text | view | |
| VDM.viewType | #BASIC | view | |
| ObjectModel.dataCategory | #TEXT | view | |
| AbapCatalog.sqlViewName | IINTTRDDOCCATTXT | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.representativeKey | ReferenceDocumentCategory | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.sizeCategory | L | view | |
| ObjectModel.usageType.dataClass | #META | view |
Fields (5)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | Language | ddlanguage | ||
| KEY | ReferenceDocumentCategory | domvalue_l | ||
| ReferenceDocumentCategoryName | ddtext | |||
| _Language | _Language | |||
| _IntlTrdDocumentCategory | _IntlTrdDocumentCategory |
@EndUserText.label: 'Document Category Text'
@VDM.viewType: #BASIC
@ObjectModel.dataCategory: #TEXT
@AbapCatalog.sqlViewName: 'IINTTRDDOCCATTXT'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'ReferenceDocumentCategory'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: 'L'
@ObjectModel.usageType.dataClass: #META
/*+[hideWarning] { "IDS" : [ "KEY_CHECK", "CALCULATED_FIELD_CHECK" ] } */
define view I_IntlTrdDocumentCategoryText
as select from dd07t
association [0..1] to I_Language as _Language on _Language.Language = $projection.Language
association [0..1] to I_IntlTrdDocumentCategory as _IntlTrdDocumentCategory on _IntlTrdDocumentCategory.ReferenceDocumentCategory = $projection.ReferenceDocumentCategory
{
@Semantics.language: true
@ObjectModel.foreignKey.association: '_Language'
key ddlanguage as Language,
@ObjectModel.foreignKey.association: '_IntlTrdDocumentCategory'
key domvalue_l as ReferenceDocumentCategory,
@Semantics.text: true
ddtext as ReferenceDocumentCategoryName,
_Language,
_IntlTrdDocumentCategory
}
where
domname = '/SAPSLL/DOCCA'
and as4local = 'A'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07T"
],
"ASSOCIATED":
[
"I_INTLTRDDOCUMENTCATEGORY",
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA