A_DocumentInfoRecordDesc

DDL: A_DOCUMENTINFORECORDDESC SQL: ADIRDESC Type: view_entity COMPOSITE
10 Fields 1 Data Sources

Document Info Record Description

A_DocumentInfoRecordDesc is a Composite CDS View that provides data about "Document Info Record Description" in SAP S/4HANA. It reads from 1 data source (I_DocInfoRecordDescriptionTP) and exposes 10 fields with key fields DocumentInfoRecordDocType, DocumentInfoRecordDocNumber, DocumentInfoRecordDocVersion, DocumentInfoRecordDocPart, Language.

Data Sources (1)

SourceAliasJoin Type
I_DocInfoRecordDescriptionTP docRecDesc from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Document Info Record Description view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY DocumentInfoRecordDocType DocumentInfoRecordDocType Document Type
KEY DocumentInfoRecordDocNumber DocumentInfoRecordDocNumber Document
KEY DocumentInfoRecordDocVersion DocumentInfoRecordDocVersion Doc. Version
KEY DocumentInfoRecordDocPart DocumentInfoRecordDocPart Document Part
KEY Language Language Report Text Language
DocumentDescription DocumentDescription Doc. Name
LongTextExists LongTextExists LgText ID
DocInfoRecdShortText DocInfoRecdShortText Description
ChangedDateTime _DocInfoRecord ChangedDateTime Time Stamp
_DocInfoRecord _DocInfoRecord

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 A_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: ADIRDESC

CREATE VIEW A_DocumentInfoRecordDesc AS
SELECT
  DocumentInfoRecordDocType,
  DocumentInfoRecordDocNumber,
  DocumentInfoRecordDocVersion,
  DocumentInfoRecordDocPart,
  Language,
  DocumentDescription,
  LongTextExists,
  DocInfoRecdShortText,
  _DocInfoRecord.ChangedDateTime AS ChangedDateTime
FROM I_DocInfoRecordDescriptionTP AS docRecDesc
;

Learn More