C_InspLotWithRsltRecgStatus

DDL: C_INSPLOTWITHRSLTRECGSTATUS SQL: CINSPLOTRRSTATUS Type: view CONSUMPTION Package: ODATA_QM_RSLT_RECG
5 Fields 1 Data Sources 3 OData Services 1 Fiori Apps

Results Recording Status

C_InspLotWithRsltRecgStatus is a Consumption CDS View that provides data about "Results Recording Status" in SAP S/4HANA. It reads from 1 data source (I_InspectionLot) and exposes 5 fields with key field InspectionLot. It is exposed through 3 OData services (ASQL_F1685A, ASQL_F2361, UI_INSPLOT_RSLTRECG). It is used in 1 Fiori application: Record Inspection Results (Version 2). Part of development package ODATA_QM_RSLT_RECG.

Data Sources (1)

SourceAliasJoin Type
I_InspectionLot _InspectionLot from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CINSPLOTRRSTATUS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Results Recording Status view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

OData Services (3)

ServiceBindingVersionContractRelease
ASQL_F1685A ASQL_F1685A C2 NOT_RELEASED
ASQL_F2361 ASQL_F2361 C2 NOT_RELEASED
UI_INSPLOT_RSLTRECG UI_INSPLOT_RSLTRECG V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F1685A Record Inspection Results (Version 2) Transactional An application to record results for inspection characteristics.

Record Inspection Results (Version 2)

Business Role: Quality Technician

With the new Record Inspection Results app, you can record and process results for characteristics for one or more inspection lots effectively. You can also use this app to create defects manually for different categories, such as inspection lots, inspection operations, and characteristics.

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspectionLot InspectionLot Inspection Lot
MatlQualityAuthorizationGroup I_InspectionLot MatlQualityAuthorizationGroup QM Matl Auth.
InspectionLotType I_InspectionLot InspectionLotType Inspection Type
Plant I_InspectionLot Plant Valuation Area
IsBusinessPurposeCompleted I_InspectionLot IsBusinessPurposeCompleted Purpose Completed

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_InspLotWithRsltRecgStatus.
-- 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: CINSPLOTRRSTATUS

CREATE VIEW C_InspLotWithRsltRecgStatus AS
SELECT
  _InspectionLot.InspectionLot AS InspectionLot,
  _InspectionLot.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup,
  _InspectionLot.InspectionLotType AS InspectionLotType,
  _InspectionLot.Plant AS Plant,
  _InspectionLot.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM I_InspectionLot AS _InspectionLot
;

Learn More