P_DocumentInfoRecordAttachment

DDL: P_DOCUMENTINFORECORDATTACHMENT SQL: PCVDOCATTACH Type: view BASIC
29 Fields 1 Data Sources

P_DocumentInfoRecordAttachment is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (dms_doc2loio) and exposes 29 fields with key fields DocumentInfoRecordDocType, DocumentInfoRecordDocNumber, DocumentInfoRecordDocVersion, DocumentInfoRecordDocPart, DocumentIndex.

Data Sources (1)

SourceAliasJoin Type
dms_doc2loio Dir_Loio from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PCVDOCATTACH view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY DocumentInfoRecordDocType dms_doc2loio dokar SW Document Type
KEY DocumentInfoRecordDocNumber dms_doc2loio doknr Document
KEY DocumentInfoRecordDocVersion dms_doc2loio dokvr Doc. Version
KEY DocumentInfoRecordDocPart dms_doc2loio doktl Document Part
KEY DocumentIndex dms_doc2loio lo_index Counter
KEY FileUUID Phio_Filename file_id UUID
KEY PhysicalDocument Original_Phio phio_id Phys. Document
FileName Doc_Files filename URL or Filenam Path
FileSize Original_fileSizeData file_size Size/dim.
WorkstationApplication Doc_Files dappl Applic.
MimeType Original_fileSizeData mimetype MIMETYPE
StorageCategory Original_Phio stor_cat Category
IsOriginalVersionActive Original_Phio prop01 Attribute feature (short version)
OriginalIsProtected Phio_Filename protected Protected
DocumentTitle Original_Phio descript Title
DocumentFormat Original_Phio doc_format Document format
PhysicalDocumentClass Original_Phio ph_class PHIO Class
LogicalDocument dms_doc2loio lo_objid Log. document
LogicalDocumentClass Original_Phio lo_class LOIO class
CreationDateTime
CreatedByUser Original_Phio crea_user User
OriginalCheckedOutTime
OriginalCheckedOutUser Original_CheckOutData chko_user Agent
ChangedDateTime
LastChangedByUser Original_Phio chng_user Last Changed By
LogicalDocumentIsReference dms_doc2loio lo_is_ref Flag
OriginalType dms_doc2loio lo_type Original type
PhysicalDocTechnicalStatus Original_Phio state Vehicle Region
InternalComment Original_CheckOutData chko_commt Comment

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 P_DocumentInfoRecordAttachment.
-- 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: PCVDOCATTACH

CREATE VIEW P_DocumentInfoRecordAttachment AS
SELECT
  Dir_Loio.dokar AS DocumentInfoRecordDocType,
  Dir_Loio.doknr AS DocumentInfoRecordDocNumber,
  Dir_Loio.dokvr AS DocumentInfoRecordDocVersion,
  Dir_Loio.doktl AS DocumentInfoRecordDocPart,
  Dir_Loio.lo_index AS DocumentIndex,
  Phio_Filename.file_id AS FileUUID,
  Original_Phio.phio_id AS PhysicalDocument,
  Doc_Files.filename AS FileName,
  Original_fileSizeData.file_size AS FileSize,
  Doc_Files.dappl AS WorkstationApplication,
  Original_fileSizeData.mimetype AS MimeType,
  Original_Phio.stor_cat AS StorageCategory,
  Original_Phio.prop01 AS IsOriginalVersionActive,
  Phio_Filename.protected AS OriginalIsProtected,
  Original_Phio.descript AS DocumentTitle,
  Original_Phio.doc_format AS DocumentFormat,
  Original_Phio.ph_class AS PhysicalDocumentClass,
  Dir_Loio.lo_objid AS LogicalDocument,
  Original_Phio.lo_class AS LogicalDocumentClass,
  cast ( Original_Phio.crea_time as tzntstmps) AS CreationDateTime,
  Original_Phio.crea_user AS CreatedByUser,
  cast ( Original_CheckOutData.chko_time as tzntstmps) AS OriginalCheckedOutTime,
  Original_CheckOutData.chko_user AS OriginalCheckedOutUser,
  cast ( Original_Phio.chng_time as tzntstmps) AS ChangedDateTime,
  Original_Phio.chng_user AS LastChangedByUser,
  Dir_Loio.lo_is_ref AS LogicalDocumentIsReference,
  Dir_Loio.lo_type AS OriginalType,
  Original_Phio.state AS PhysicalDocTechnicalStatus,
  Original_CheckOutData.chko_commt AS InternalComment
FROM dms_doc2loio AS Dir_Loio
;

Learn More