C_ProductInspLotOriginVariant

DDL: C_PRODUCTINSPLOTORIGINVARIANT SQL: CPRODILORGVAR Type: view CONSUMPTION Package: VDM_MD_PRODUCT
4 Fields 2 Data Sources

InspLot Origin Variant

C_ProductInspLotOriginVariant is a Consumption CDS View that provides data about "InspLot Origin Variant" in SAP S/4HANA. It reads from 2 data sources (I_InspectionLotOrigin, I_InspectionLotOriginType) and exposes 4 fields with key fields InspectionLotOrigin, InspectionLotOriginVariant. Part of development package VDM_MD_PRODUCT.

Data Sources (2)

SourceAliasJoin Type
I_InspectionLotOrigin _InspLotOrigin inner
I_InspectionLotOriginType _InspLotOriginType from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CPRODILORGVAR view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view
EndUserText.label InspLot Origin Variant view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY InspectionLotOrigin I_InspectionLotOrigin InspectionLotOrigin Insp. Lot Orig.
KEY InspectionLotOriginVariant I_InspectionLotOriginType InspectionLotOriginVariant Variant
InspectionLotType I_InspectionLotOriginType InspectionLotType Inspection Type
InspectionLotOriginText

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_ProductInspLotOriginVariant.
-- 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: CPRODILORGVAR

CREATE VIEW C_ProductInspLotOriginVariant AS
SELECT
  _InspLotOrigin.InspectionLotOrigin AS InspectionLotOrigin,
  _InspLotOriginType.InspectionLotOriginVariant AS InspectionLotOriginVariant,
  _InspLotOriginType.InspectionLotType AS InspectionLotType,
  _InspLotOrigin._Text[1:Language=$session.system_language].InspectionLotOriginText AS InspectionLotOriginText
FROM I_InspectionLotOriginType AS _InspLotOriginType
INNER JOIN I_InspectionLotOrigin AS _InspLotOrigin ON /* join condition not captured in parsed metadata */
;

Learn More