What is C_CharacteristicDocument in SAP S/4HANA?

C_CharacteristicDocument is a consumption CDS view in SAP S/4HANA. Characteristic Document of DMS It contains 20 fields.

What VDM layer is C_CharacteristicDocument?

C_CharacteristicDocument is classified as a Consumption view optimized for specific business scenarios and reporting.

C_CharacteristicDocument

Q: Which tables does C_CharacteristicDocument read from?

C_CharacteristicDocument reads data from: I_DocumentInfoRecordObjectLink, I_DocumentInfoRecordAttachment, I_DocumentInfoRecord, I_DocumentInfoRecordDocStatus.

DDL: C_CHARACTERISTICDOCUMENT SQL: CINSPCHARDOC Type: view CONSUMPTION Package: ODATA_QM_RR

20 Fields 4 Data Sources

Characteristic Document of DMS

C_CharacteristicDocument is a Consumption CDS View that provides data about "Characteristic Document of DMS" in SAP S/4HANA. It reads from 4 data sources (I_DocumentInfoRecordObjectLink, I_DocumentInfoRecordAttachment, I_DocumentInfoRecord, I_DocumentInfoRecordDocStatus) and exposes 20 fields with key fields DocumentInfoRecordDocType, DocumentInfoRecordDocNumber, DocumentInfoRecordDocPart, DocumentInfoRecordDocVersion, LinkedSAPObjectKey. Part of development package ODATA_QM_RR.

Data Sources (4)

Source	Alias	Join Type
I_DocumentInfoRecordObjectLink	_DirObjectLinks	from
I_DocumentInfoRecordAttachment	_DirOriginals	left_outer
I_DocumentInfoRecord	_DocInfoRecd	left_outer
I_DocumentInfoRecordDocStatus	_DocStatus	left_outer

Annotations (9)

Name	Value	Level
AbapCatalog.sqlViewName	CINSPCHARDOC	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.compiler.compareFilter	true	view
VDM.viewType	#CONSUMPTION	view
EndUserText.label	Characteristic Document of DMS	view
AccessControl.authorizationCheck	#CHECK	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.usageType.serviceQuality	#C	view

Fields (20)

Key	Field	Source Table	Source Field	Description
KEY	DocumentInfoRecordDocType	I_DocumentInfoRecordObjectLink	DocumentInfoRecordDocType	Document Type
KEY	DocumentInfoRecordDocNumber	I_DocumentInfoRecordObjectLink	DocumentInfoRecordDocNumber	Document
KEY	DocumentInfoRecordDocPart	I_DocumentInfoRecordObjectLink	DocumentInfoRecordDocPart	Document Part
KEY	DocumentInfoRecordDocVersion	I_DocumentInfoRecordObjectLink	DocumentInfoRecordDocVersion	Doc. Version
KEY	LinkedSAPObjectKey	I_DocumentInfoRecordObjectLink	LinkedSAPObjectKey	SAP Object Key
	LinkedSAPObject	I_DocumentInfoRecordObjectLink	LinkedSAPObject	Object
	FileName	I_DocumentInfoRecordAttachment	FileName	URL or Filenam Path
	WorkstationApplication	I_DocumentInfoRecordAttachment	WorkstationApplication	Applic.
	FileSize	I_DocumentInfoRecordAttachment	FileSize	Safety Data Sheet File Size
	StorageCategory	I_DocumentInfoRecordAttachment	StorageCategory	Category
	PhysicalDocument	I_DocumentInfoRecordAttachment	PhysicalDocument	Phys. Document
	CreatedByUser	I_DocumentInfoRecord	CreatedByUser	User Name
	CreationDateTime	I_DocumentInfoRecord	CreationDateTime	Timestamp
	LastChangedByUser	I_DocumentInfoRecord	LastChangedByUser	User Name
	ChangedDateTime	I_DocumentInfoRecord	ChangedDateTime	Time Stamp
	InternalDocumentStatus	I_DocumentInfoRecord	InternalDocumentStatus	Status
	ExternalDocumentStatus
	DocumentStatusName
	ObjectDescription
	DocumentURL

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 C_CharacteristicDocument.
-- 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: CINSPCHARDOC

CREATE VIEW C_CharacteristicDocument AS
SELECT
  _DirObjectLinks.DocumentInfoRecordDocType AS DocumentInfoRecordDocType,
  _DirObjectLinks.DocumentInfoRecordDocNumber AS DocumentInfoRecordDocNumber,
  _DirObjectLinks.DocumentInfoRecordDocPart AS DocumentInfoRecordDocPart,
  _DirObjectLinks.DocumentInfoRecordDocVersion AS DocumentInfoRecordDocVersion,
  _DirObjectLinks.LinkedSAPObjectKey AS LinkedSAPObjectKey,
  _DirObjectLinks.LinkedSAPObject AS LinkedSAPObject,
  _DirOriginals.FileName AS FileName,
  _DirOriginals.WorkstationApplication AS WorkstationApplication,
  _DirOriginals.FileSize AS FileSize,
  _DirOriginals.StorageCategory AS StorageCategory,
  _DirOriginals.PhysicalDocument AS PhysicalDocument,
  _DocInfoRecd.CreatedByUser AS CreatedByUser,
  _DocInfoRecd.CreationDateTime AS CreationDateTime,
  _DocInfoRecd.LastChangedByUser AS LastChangedByUser,
  _DocInfoRecd.ChangedDateTime AS ChangedDateTime,
  _DocInfoRecd.InternalDocumentStatus AS InternalDocumentStatus,
  _DocStatus._Text[1:Language = $session.system_language].ExternalDocumentStatus AS ExternalDocumentStatus,
  _DocStatus._Text[1:Language = $session.system_language].DocumentStatusName AS DocumentStatusName,
  _DirObjectLinks._Text[1:Language = $session.system_language].ObjectDescription AS ObjectDescription,
  cast ( ' ' as abap.sstring( 1333 ) ) AS DocumentURL
FROM I_DocumentInfoRecordObjectLink AS _DirObjectLinks
LEFT OUTER JOIN I_DocumentInfoRecordAttachment AS _DirOriginals ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_DocumentInfoRecord AS _DocInfoRecd ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_DocumentInfoRecordDocStatus AS _DocStatus ON /* join condition not captured in parsed metadata */
;

Depth:

C_CharacteristicDocument view