I_InspectionLotUrl

DDL: I_INSPECTIONLOTURL SQL: IINSPLOTURL Type: view BASIC
7 Fields 2 Data Sources

Assigned URL to Inspection Lot

I_InspectionLotUrl is a Basic CDS View that provides data about "Assigned URL to Inspection Lot" in SAP S/4HANA. It reads from 2 data sources (sood, P_InspectionLotUrl) and exposes 7 fields with key field InspectionLot.

Data Sources (2)

SourceAliasJoin Type
sood _OfficeObjectDefinition inner
P_InspectionLotUrl P_InspectionLotUrl from

Annotations (9)

NameValueLevelField
EndUserText.label Assigned URL to Inspection Lot view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName IINSPLOTURL view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey InspectionLot view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot InspectionLot Inspection Lot
DocumentType DocumentType Order Type
DocumentYear DocumentYear
DocNumber DocNumber Document Number
ObjectDescription sood objdes Title
CreatedByUserName sood cronam Created
CreationDate sood crdat Generation Time

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 I_InspectionLotUrl.
-- 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: IINSPLOTURL

CREATE VIEW I_InspectionLotUrl AS
SELECT
  InspectionLot,
  DocumentType,
  DocumentYear,
  DocNumber,
  _OfficeObjectDefinition.objdes AS ObjectDescription,
  _OfficeObjectDefinition.cronam AS CreatedByUserName,
  _OfficeObjectDefinition.crdat AS CreationDate
FROM P_InspectionLotUrl
INNER JOIN sood AS _OfficeObjectDefinition ON /* join condition not captured in parsed metadata */
;

Learn More