C_InspLotDocument

DDL: C_INSPLOTDOCUMENT SQL: CINSPLOTDOC Type: view CONSUMPTION
18 Fields 4 Data Sources

Inspection Lot Document of DMS

C_InspLotDocument is a Consumption CDS View that provides data about "Inspection Lot Document of DMS" in SAP S/4HANA. It reads from 4 data sources (I_DocumentInfoRecordObjectLink, I_DocumentInfoRecordAttachment, I_DocumentInfoRecord, I_DocumentInfoRecordDocStatus) and exposes 18 fields with key fields DocumentInfoRecordDocType, DocumentInfoRecordDocNumber, DocumentInfoRecordDocPart, DocumentInfoRecordDocVersion, LinkedSAPObjectKey.

Data Sources (4)

SourceAliasJoin Type
I_DocumentInfoRecordObjectLink _DirObjectLinks from
I_DocumentInfoRecordAttachment _DirOriginals left_outer
I_DocumentInfoRecord _DocInfoRecd left_outer
I_DocumentInfoRecordDocStatus _DocInfoRecdDocumentStatus left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CINSPLOTDOC view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
EndUserText.label Inspection Lot Document of DMS view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view

Fields (18)

KeyFieldSource TableSource FieldDescription
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

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_InspLotDocument.
-- 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: CINSPLOTDOC

CREATE VIEW C_InspLotDocument 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,
  _DocInfoRecdDocumentStatus._Text[1:Language = $session.system_language].ExternalDocumentStatus AS ExternalDocumentStatus,
  _DocInfoRecdDocumentStatus._Text[1:Language = $session.system_language].DocumentStatusName AS DocumentStatusName
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 _DocInfoRecdDocumentStatus ON /* join condition not captured in parsed metadata */
;

Learn More