C_InspLotStatus

DDL: C_INSPLOTSTATUS SQL: CINSPLOTSTATUS Type: view CONSUMPTION
8 Fields 3 Data Sources

Status of Inspection Lot Object Page

C_InspLotStatus is a Consumption CDS View that provides data about "Status of Inspection Lot Object Page" in SAP S/4HANA. It reads from 3 data sources (I_InspectionLot, I_StatusCodeText, I_UserStatusText) and exposes 8 fields with key fields InspectionLot, StatusCode.

Data Sources (3)

SourceAliasJoin Type
I_InspectionLot _InspLot inner
I_StatusCodeText _StatusCodeText left_outer
I_UserStatusText _UserStatusText left_outer

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CINSPLOTSTATUS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
EndUserText.label Status of Inspection Lot Object Page view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspectionLot InspectionLot Inspection Lot
KEY StatusCode _statusObject StatusCode Statuscode
IsUserStatus
StatusShortNameendasStatusShortName
StatusNameendasStatusName
Plant I_InspectionLot Plant Valuation Area
InspectionLotType I_InspectionLot InspectionLotType Inspection Type
MatlQualityAuthorizationGroup I_InspectionLot MatlQualityAuthorizationGroup QM Matl Auth.

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_InspLotStatus.
-- 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: CINSPLOTSTATUS

CREATE VIEW C_InspLotStatus AS
SELECT
  _InspLot.InspectionLot AS InspectionLot,
  _statusObject.StatusCode AS StatusCode,
  _statusObject._StatusCode._StatusCodeText[1:Language=$session.system_language].IsUserStatus AS IsUserStatus,
  case _statusObject._StatusCode._StatusCodeText[1:Language=$session.system_language].IsUserStatus when 'X' then _UserStatusText.UserStatusShortName else _StatusCodeText.StatusShortName end as StatusShortName AS StatusShortNameendasStatusShortName,
  case _statusObject._StatusCode._StatusCodeText[1:Language=$session.system_language].IsUserStatus when 'X' then _UserStatusText.UserStatusName else _StatusCodeText.StatusName end as StatusName AS StatusNameendasStatusName,
  _InspLot.Plant AS Plant,
  _InspLot.InspectionLotType AS InspectionLotType,
  _InspLot.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup
INNER JOIN I_InspectionLot AS _InspLot ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_StatusCodeText AS _StatusCodeText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UserStatusText AS _UserStatusText ON /* join condition not captured in parsed metadata */
;

Learn More