I_DocumentInfoRecordDesc

DDL: I_DOCUMENTINFORECORDDESC SQL: ICVDOCDESC Type: view BASIC
13 Fields 1 Data Sources 5 Associations

Document Info Record Description

I_DocumentInfoRecordDesc (Basic)

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

R&D Engineering

I_DocumentInfoRecordDesc is a Basic CDS View that provides data about "Document Info Record Description" in SAP S/4HANA. It reads from 1 data source (drat) and exposes 13 fields with key fields DocumentInfoRecordDocType, DocumentInfoRecordDocNumber, DocumentInfoRecordDocVersion, DocumentInfoRecordDocPart, Language. It has 5 associations to related views.

SAP API Hub

StateC1
Line of BusinessR&D Engineering
Application ComponentCA-DMS
CapabilitiesLanguage-Dependent Text, Data Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities
PackageR&D Engineering for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
drat documentdesc from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_DocumentInfoRecordDocType _DocType $projection.DocumentInfoRecordDocType = _DocType.DocumentInfoRecordDocType --Get Document Number
[0..1] I_DocumentInfoRecordDocNumber _DocNumber $projection.DocumentInfoRecordDocType = _DocNumber.DocumentInfoRecordDocType and $projection.DocumentInfoRecordDocNumber = _DocNumber.DocumentInfoRecordDocNumber --Get Document Part
[0..1] I_DocumentInfoRecordDocPrt _DocPart $projection.DocumentInfoRecordDocType = _DocPart.DocumentInfoRecordDocType and $projection.DocumentInfoRecordDocPart = _DocPart.DocumentInfoRecordDocPart and $projection.DocumentInfoRecordDocNumber = _DocPart.DocumentInfoRecordDocNumber and $projection.DocumentInfoRecordDocVersion = _DocPart.DocumentInfoRecordDocVersion --Get Document Version
[0..1] I_DocumentInfoRecordDocVersion _DocVersion $projection.DocumentInfoRecordDocType = _DocVersion.DocumentInfoRecordDocType and $projection.DocumentInfoRecordDocNumber = _DocVersion.DocumentInfoRecordDocNumber and $projection.DocumentInfoRecordDocVersion = _DocVersion.DocumentInfoRecordDocVersion
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ICVDOCDESC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.dataCategory #TEXT view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey DocumentInfoRecordDocType view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Document Info Record Description view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY DocumentInfoRecordDocType drat dokar SW Document Type
KEY DocumentInfoRecordDocNumber drat doknr Document number
KEY DocumentInfoRecordDocVersion drat dokvr Document Version
KEY DocumentInfoRecordDocPart drat doktl Document Part
KEY Language drat langu Primary lang.
DocumentDescription drat dktxt Document Description
LongTextExists drat ltxin Long Text Exists
DocInfoRecdShortText drat dktxt_uc DMS: Short Texts in Capital Letters
_Language _Language
_DocType _DocType
_DocVersion _DocVersion
_DocPart _DocPart
_DocNumber _DocNumber

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_DocumentInfoRecordDesc.
-- 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: ICVDOCDESC

CREATE VIEW I_DocumentInfoRecordDesc AS
SELECT
  documentdesc.dokar AS DocumentInfoRecordDocType,
  documentdesc.doknr AS DocumentInfoRecordDocNumber,
  documentdesc.dokvr AS DocumentInfoRecordDocVersion,
  documentdesc.doktl AS DocumentInfoRecordDocPart,
  documentdesc.langu AS Language,
  documentdesc.dktxt AS DocumentDescription,
  documentdesc.ltxin AS LongTextExists,
  documentdesc.dktxt_uc AS DocInfoRecdShortText
FROM drat AS documentdesc
LEFT OUTER JOIN I_DocumentInfoRecordDocType AS _DocType ON DocumentInfoRecordDocType = _DocType.DocumentInfoRecordDocType  -- association [1..1]
LEFT OUTER JOIN I_DocumentInfoRecordDocNumber AS _DocNumber ON DocumentInfoRecordDocType = _DocNumber.DocumentInfoRecordDocType AND DocumentInfoRecordDocNumber = _DocNumber.DocumentInfoRecordDocNumber  -- association [0..1]
LEFT OUTER JOIN I_DocumentInfoRecordDocPrt AS _DocPart ON DocumentInfoRecordDocType = _DocPart.DocumentInfoRecordDocType AND DocumentInfoRecordDocPart = _DocPart.DocumentInfoRecordDocPart AND DocumentInfoRecordDocNumber = _DocPart.DocumentInfoRecordDocNumber AND DocumentInfoRecordDocVersion = _DocPart.DocumentInfoRecordDocVersion  -- association [0..1]
LEFT OUTER JOIN I_DocumentInfoRecordDocVersion AS _DocVersion ON DocumentInfoRecordDocType = _DocVersion.DocumentInfoRecordDocType AND DocumentInfoRecordDocNumber = _DocVersion.DocumentInfoRecordDocNumber AND DocumentInfoRecordDocVersion = _DocVersion.DocumentInfoRecordDocVersion  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
;

Learn More