I_InspectionLotCube

DDL: I_INSPECTIONLOTCUBE SQL: IINSPECTIONLOTC Type: view COMPOSITE Package: VDM_QM_ANALYTICS
27 Fields 2 Data Sources 1 Associations

Inspection Lot Cube

I_InspectionLotCube is a Composite CDS View (Cube) that provides data about "Inspection Lot Cube" in SAP S/4HANA. It reads from 2 data sources (I_InspectionLot, I_InspLotUsageDecision) and exposes 27 fields with key field InspectionLot. It has 1 association to related views. Part of development package VDM_QM_ANALYTICS.

Data Sources (2)

SourceAliasJoin Type
I_InspectionLot ILot from
I_InspLotUsageDecision UD inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_PurchaseOrderItem _PurchaseOrderItem $projection.PurchasingDocument = _PurchaseOrderItem.PurchaseOrder and $projection.PurchasingDocumentItem = _PurchaseOrderItem.PurchaseOrderItem

Annotations (10)

NameValueLevelField
Analytics.dataCategory #CUBE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName IINSPECTIONLOTC view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Inspection Lot Cube view
Metadata.allowExtensions true view
AccessControl.authorizationCheck #CHECK view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspectionLot InspectionLot Inspection Lot
Material I_InspectionLot Material Vehicle Model
Plant I_InspectionLot Plant Valuation Area
InspectionLotOrigin I_InspectionLot InspectionLotOrigin
InspectionLotType I_InspectionLot InspectionLotType Inspection Type
Supplier I_InspectionLot Supplier Supplier
PurchasingDocumentCategory I_InspectionLot PurchasingDocumentCategory Doc. Category
PurchasingDocument I_InspectionLot PurchasingDocument Purchasing Document
PurchasingDocumentItem I_InspectionLot PurchasingDocumentItem Purchasing Doc. Item
Customer I_InspectionLot Customer Sold-to Party
MatlQualityAuthorizationGroup I_InspectionLot MatlQualityAuthorizationGroup QM Matl Auth.
InspectionLotQuantityUnit I_InspectionLot InspectionLotQuantityUnit Sample UOM
InspectionLotCreatedOn I_InspectionLot InspectionLotCreatedOn Created On
InspectionLotCreatedOnTime I_InspectionLot InspectionLotCreatedOnTime
InspectionLotUsageDecidedOn I_InspLotUsageDecision InspectionLotUsageDecidedOn
InspLotUsageDecisionTime I_InspLotUsageDecision InspLotUsageDecisionTime
InspectionLotQualityScore I_InspLotUsageDecision InspectionLotQualityScore Inspection Lot Score
InspectionLotCount
InspectionLotQuantity I_InspectionLot InspectionLotQuantity
_Material I_InspectionLot _Material
_Plant I_InspectionLot _Plant
_InspectionLotOrigin I_InspectionLot _InspectionLotOrigin
_InspectionLotType I_InspectionLot _InspectionLotType
_Supplier I_InspectionLot _Supplier
_Customer I_InspectionLot _Customer
_InspectionLotQuantityUnit I_InspectionLot _InspectionLotQuantityUnit
_PurchaseOrderItem _PurchaseOrderItem

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_InspectionLotCube.
-- 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: IINSPECTIONLOTC

CREATE VIEW I_InspectionLotCube AS
SELECT
  ILot.InspectionLot AS InspectionLot,
  ILot.Material AS Material,
  ILot.Plant AS Plant,
  ILot.InspectionLotOrigin AS InspectionLotOrigin,
  ILot.InspectionLotType AS InspectionLotType,
  ILot.Supplier AS Supplier,
  ILot.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  ILot.PurchasingDocument AS PurchasingDocument,
  ILot.PurchasingDocumentItem AS PurchasingDocumentItem,
  ILot.Customer AS Customer,
  ILot.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup,
  ILot.InspectionLotQuantityUnit AS InspectionLotQuantityUnit,
  ILot.InspectionLotCreatedOn AS InspectionLotCreatedOn,
  ILot.InspectionLotCreatedOnTime AS InspectionLotCreatedOnTime,
  UD.InspectionLotUsageDecidedOn AS InspectionLotUsageDecidedOn,
  UD.InspLotUsageDecisionTime AS InspLotUsageDecisionTime,
  UD.InspectionLotQualityScore AS InspectionLotQualityScore,
  cast ('1' as qzhlgesamt ) AS InspectionLotCount,
  ILot.InspectionLotQuantity AS InspectionLotQuantity,
  ILot._Material AS _Material,
  ILot._Plant AS _Plant,
  ILot._InspectionLotOrigin AS _InspectionLotOrigin,
  ILot._InspectionLotType AS _InspectionLotType,
  ILot._Supplier AS _Supplier,
  ILot._Customer AS _Customer,
  ILot._InspectionLotQuantityUnit AS _InspectionLotQuantityUnit
FROM I_InspectionLot AS ILot
INNER JOIN I_InspLotUsageDecision AS UD ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurchaseOrderItem AS _PurchaseOrderItem ON PurchasingDocument = _PurchaseOrderItem.PurchaseOrder AND PurchasingDocumentItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [0..1]
;

Learn More