I_DOCUMENTINFORECORDATTACHMENT
Document Info Record Attachment
I_DOCUMENTINFORECORDATTACHMENT is a CDS View in S/4HANA. Document Info Record Attachment. It contains 29 fields. 14 CDS views read from this table.
CDS Views using this table (14)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_CharacteristicDocument | view | left_outer | CONSUMPTION | Characteristic Document of DMS |
| C_InspLotDocument | view | left_outer | CONSUMPTION | Inspection Lot Document of DMS |
| C_InspMethodDocument | view | left_outer | CONSUMPTION | Inspection Method Document of DMS |
| ESH_S_DOCUMENT_ATTACHMENT | view | from | ||
| I_DocInfoRecdAttchDetForBusObj | view | from | COMPOSITE | Documents with files for Business Object |
| I_DocInfoRecordAttchsWithCntnt | view | from | COMPOSITE | Document Info Record Attachment (ESH) |
| I_InvgCsMMainImage | view | left_outer | BASIC | Basic view for ICM Main Image |
| I_MfgOrderDocInfoRecdOrigl | view | inner | COMPOSITE | Mfg Order Header Document Info Record Original |
| I_MfgOrderDocumentDataList | view | inner | COMPOSITE | Mfg Order Document (Data List) |
| I_MfgOrderDocumentLinkOriginal | view_entity | from | COMPOSITE | Manufacturing Order Document Link Original |
| I_MfgOrdOpDocInfoRecdOrigl | view | inner | COMPOSITE | Mfg Order Operation Document Info Record Original |
| I_ShiftNoteAttachment | view_entity | inner | COMPOSITE | Shift Note Attachment |
| P_NotifNmbrOfAttachedDocuments | view | inner | COMPOSITE | |
| P_OrderNmbrOfAttachedDocuments | view | inner | COMPOSITE |
Fields (29)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | DocumentIndex | DocumentIndex | 7 |
| KEY | DocumentInfoRecordDocNumber | DocumentInfoRecord,DocumentInfoRecordDocNumber | 7 |
| KEY | DocumentInfoRecordDocPart | DocumentInfoRecordDocPart | 5 |
| KEY | DocumentInfoRecordDocType | DocumentInfoRecordDocType,DocumentType | 6 |
| KEY | DocumentInfoRecordDocVersion | DocumentInfoRecordDocVersion | 5 |
| KEY | FileUUID | FileUUID | 4 |
| KEY | PhysicalDocument | PhysicalDocument | 8 |
| ChangedDateTime | ChangedDateTime | 1 | |
| CreatedByUser | CreatedByUser | 3 | |
| CreationDateTime | CreationDateTime | 1 | |
| DocumentFormat | DocumentFormat | 4 | |
| DocumentTitle | DocumentTitle | 4 | |
| FileName | FileName,InvgCsMImageFileName | 10 | |
| FileSize | FileSize | 10 | |
| InternalComment | InternalComment | 5 | |
| IsOriginalVersionActive | IsOriginalVersionActive | 1 | |
| LastChangedByUser | LastChangedByUser | 3 | |
| LogicalDocument | LogicalDocument | 2 | |
| LogicalDocumentClass | LogicalDocumentClass | 2 | |
| LogicalDocumentIsReference | LogicalDocumentIsReference | 2 | |
| MimeType | MimeType | 5 | |
| OriginalCheckedOutTime | OriginalCheckedOutDateTime | 2 | |
| OriginalCheckedOutUser | OriginalCheckedOutUser | 2 | |
| OriginalIsProtected | OriginalIsProtected | 3 | |
| OriginalType | OriginalType | 5 | |
| PhysicalDocTechnicalStatus | PhysicalDocTechnicalStatus | 2 | |
| PhysicalDocumentClass | PhysicalDocumentClass | 3 | |
| StorageCategory | StorageCategory | 10 | |
| WorkstationApplication | WorkstationApplication | 11 |
@AbapCatalog.sqlViewName: 'ICVDOCATTACH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Document Info Record Attachment'
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MIXED}
define view I_DocumentInfoRecordAttachment
as select from P_DocumentInfoRecordAttachment as Attachment
--Association to get Created user & changed Users full name
--Get DocumentInfoRecord created user full name
association [1..1] to I_DocumentInfoRecordUserVH as _CreatedUser on $projection.DocumentInfoRecordDocType = _CreatedUser.DocumentInfoRecordDocType
and $projection.DocumentInfoRecordDocPart = _CreatedUser.DocumentInfoRecordDocPart
and $projection.DocumentInfoRecordDocNumber = _CreatedUser.DocumentInfoRecordDocNumber
and $projection.DocumentInfoRecordDocVersion = _CreatedUser.DocumentInfoRecordDocVersion
and $projection.CreatedByUser = _CreatedUser.ResponsiblePersonName
--Get DocumentInfoRecord changed user full name
association [1..1] to I_DocumentInfoRecordUserVH as _ChangedUser on $projection.DocumentInfoRecordDocType = _ChangedUser.DocumentInfoRecordDocType
and $projection.DocumentInfoRecordDocPart = _ChangedUser.DocumentInfoRecordDocPart
and $projection.DocumentInfoRecordDocNumber = _ChangedUser.DocumentInfoRecordDocNumber
and $projection.DocumentInfoRecordDocVersion = _ChangedUser.DocumentInfoRecordDocVersion
and $projection.LastChangedByUser = _ChangedUser.LastChangedByUser
--Get original checkedout user full name
association [1..1] to I_DocumentInfoRecordUserVH as _CheckedOutUser on $projection.DocumentInfoRecordDocType = _CheckedOutUser.DocumentInfoRecordDocType
and $projection.DocumentInfoRecordDocPart = _CheckedOutUser.DocumentInfoRecordDocPart
and $projection.DocumentInfoRecordDocNumber = _CheckedOutUser.DocumentInfoRecordDocNumber
and $projection.DocumentInfoRecordDocVersion = _CheckedOutUser.DocumentInfoRecordDocVersion
and $projection.OriginalCheckedOutUser = _CheckedOutUser.ResponsiblePersonName
{
/* Document Info Record key Details */
key Attachment.DocumentInfoRecordDocType as DocumentInfoRecordDocType,
key Attachment.DocumentInfoRecordDocNumber as DocumentInfoRecordDocNumber,
key Attachment.DocumentInfoRecordDocVersion as DocumentInfoRecordDocVersion,
key Attachment.DocumentInfoRecordDocPart as DocumentInfoRecordDocPart,
key Attachment.DocumentIndex as DocumentIndex,
key Attachment.FileUUID as FileUUID,
key Attachment.PhysicalDocument as PhysicalDocument,
/* Original Details */
@EndUserText: {
label: 'File Name'
}
Attachment.FileName as FileName,
Attachment.FileSize as FileSize,
Attachment.WorkstationApplication as WorkstationApplication,
Attachment.MimeType as MimeType,
Attachment.StorageCategory as StorageCategory,
Attachment.IsOriginalVersionActive as IsOriginalVersionActive,
Attachment.OriginalIsProtected as OriginalIsProtected,
Attachment.DocumentTitle as DocumentTitle,
Attachment.DocumentFormat as DocumentFormat,
/* Originals Admin Details */
//@Semantics.businessDate.at: true
//@Semantics.businessDate.createdAt: true
Attachment.CreationDateTime as CreationDateTime,
@Consumption.valueHelpDefinition.association: '_CreatedUser'
@Semantics.user.createdBy: true
Attachment.CreatedByUser as CreatedByUser,
@Semantics.businessDate.at: true
//@Semantics.businessDate.lastChangedAt: true
Attachment.ChangedDateTime as ChangedDateTime,
@Consumption.valueHelpDefinition.association: '_ChangedUser'
@Semantics.user.lastChangedBy: true
Attachment.LastChangedByUser as LastChangedByUser,
//@Semantics.businessDate.at: true
//@Semantics.businessDate.CheckedOutAt: true
Attachment.OriginalCheckedOutTime as OriginalCheckedOutTime,
//Attachment.OriginalCheckedOutDateTime as OriginalCheckedOutDateTime,
@Consumption.valueHelpDefinition.association: '_CheckedOutUser'
@Semantics.user.CheckedOutBy: true
Attachment.OriginalCheckedOutUser as OriginalCheckedOutUser,
/* LOIO and PHIO Details */
Attachment.LogicalDocument as LogicalDocument,
Attachment.LogicalDocumentClass as LogicalDocumentClass,
Attachment.PhysicalDocumentClass as PhysicalDocumentClass,
Attachment.LogicalDocumentIsReference as LogicalDocumentIsReference,
Attachment.OriginalType as OriginalType,
Attachment.PhysicalDocTechnicalStatus as PhysicalDocTechnicalStatus,
Attachment.InternalComment as InternalComment,
// Associations
_CreatedUser,
_ChangedUser,
_CheckedOutUser
}
where
IsOriginalVersionActive = 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_DOCUMENTINFORECORDATTACHMENT"
],
"ASSOCIATED":
[
"I_DOCUMENTINFORECORDUSERVH"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/