C_Insplot_Object

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_Insplot_Object.
-- 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: CINSPLOTOBJECT

CREATE VIEW C_Insplot_Object AS
SELECT
  _InspLot.InspectionLot AS InspectionLot,
  _InspLot.InspectionLotType AS InspectionLotType,
  _InspLotText.InspectionLotTypeText AS InspectionLotTypeText,
  _InspLot.Material AS Material,
  _InspLot.InspectionLotObjectText AS InspectionLotObjectText,
  _InspLot.InspectionLotText AS InspectionLotText,
  _InspLot.InspectionLotQuantity AS InspectionLotQuantity,
  _InspLot._InspectionLotQuantityUnit._Text[1:Language=$session.system_language].UnitOfMeasure_E AS InspectionLotQuantityUnit,
  _InspLot.Plant AS Plant,
  _InspLot._Plant.PlantName AS PlantName,
  _InspLot.MaterialIsBatchManaged AS MaterialIsBatchManaged,
  _InspLot.Batch AS Batch,
  _InspLot.BatchBySupplier AS BatchBySupplier,
  _InspLot.InspectionLotStartDate AS InspectionLotStartDate,
  _InspLot.InspectionLotEndDate AS InspectionLotEndDate,
  _InspLot.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup,
  _InspLot.BillOfOperationsType AS BillOfOperationsType,
  _InspLot.BillOfOperationsGroup AS BillOfOperationsGroup,
  _InspLot.BillOfOperationsVariant AS BillOfOperationsVariant,
  _InspLot.BillOfOperationsChangeStateID AS BillOfOperationsChangeStateID,
  _InspLot._BillOfOperationsChangeState.BillOfOperationsDesc AS BillOfOperationsDesc,
  _InspLot._BillOfOperationsType._Text[1:Language=$session.system_language].BillOfOperationsTypeName AS BillOfOperationsTypeName,
  _InspLot.QualityCostCollector AS QualityCostCollector,
  _InspLot.Equipment AS Equipment,
  _InspLot._Equipment._EquipmentText[1:Language=$session.system_language].EquipmentName AS EquipmentName,
  _InspLot.FunctionalLocation AS FunctionalLocation,
  _InspLot._FunctionalLocation._FunctionalLocationText[1:Language=$session.system_language].FunctionalLocationName AS FunctionalLocationName,
  _InspLot.InspLotCreatedOnLocalDate AS InspLotCreatedOnLocalDate,
  _InspLot.InspLotCreatedOnLocalTime AS InspLotCreatedOnLocalTime,
  _InspLot.InspectionLotCreatedOnTime AS InspectionLotCreatedOnTime,
  _InspLot.InspectionLotCreatedOn AS InspectionLotCreatedOn,
  _InspLot.InspectionLotCreatedBy AS InspectionLotCreatedBy,
  _InspLot.InspectionLotChangeDate AS InspectionLotChangeDate,
  _InspLot.InspectionLotChangeTime AS InspectionLotChangeTime,
  _InspLot.InspectionLotChangedBy AS InspectionLotChangedBy,
  _InspLot._InspLotUsageDecision.InspLotUsageDecisionValuation AS InspLotUsageDecisionValuation,
  _InspLot._InspLotUsageDecision.InspectionLotUsageDecisionCode AS InspectionLotUsageDecisionCode,
  _InspLot._InspLotUsageDecision.InspLotUsageDecisionCodeGroup AS InspLotUsageDecisionCodeGroup,
  _InspLot._InspLotUsageDecision._UsageDecisionCode.UsageDecisionCodeText AS UsageDecisionCodeText,
  _InspLot._InspLotUsageDecision.InspectionLotQualityScore AS InspectionLotQualityScore,
  _InspLot._InspLotUsageDecision.InspLotUsgeDcsnFollowUpAction AS InspLotUsgeDcsnFollowUpAction,
  _InspLot._InspLotUsageDecision.InspectionLotUsageDecidedOn AS InspectionLotUsageDecidedOn,
  _InspLot._InspLotUsageDecision.InspLotUsageDecisionTime AS InspLotUsageDecisionTime,
  _InspLot._InspLotUsageDecision.InspectionLotUsageDecidedBy AS InspectionLotUsageDecidedBy,
  _InspLot._InspLotUsageDecision.InspLotUsageDecisionChangedBy AS InspLotUsageDecisionChangedBy,
  _InspLot._InspLotUsageDecision.InspLotUsageDecisionChangedOn AS InspLotUsageDecisionChangedOn,
  _InspLot._InspLotUsageDecision.InspLotUsgeDcsnChangedTime AS InspLotUsgeDcsnChangedTime,
  _InspLot.InspectionLotActualQuantity AS InspectionLotActualQuantity,
  _InspLot.InspectionLotSampleQuantity AS InspectionLotSampleQuantity,
  _InspLot._InspectionLotSampleUnit._Text[1:Language=$session.system_language].UnitOfMeasure_E AS InspectionLotSampleUnit,
  _InspLot.InspLotQtyDestroyed AS InspLotQtyDestroyed,
  _InspLot.InspectionLotDefectiveQuantity AS InspectionLotDefectiveQuantity,
  _InspLot.InspLotQtyToBePosted AS InspQtyPosted,
  _InspLot.InspectionLotOrigin AS InspectionLotOrigin,
  _InspectionLotOriginText.InspectionLotOriginText AS InspectionLotOriginText,
  _InspLot.Customer AS Customer,
  _Customer.CustomerName AS CustomerName,
  _InspLot.Supplier AS Supplier,
  _Supplier.SupplierName AS SupplierName,
  _InspLot.Manufacturer AS Manufacturer,
  _Manufacturer.SupplierName AS ManufacturerName,
  _InspLot.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  _MaterialText.MaterialName AS MaterialName,
  _InspLot.PurchasingOrganization AS PurchasingOrganization,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  _InspLot.PurchasingDocument AS PurchasingDocument,
  _InspLot.MaterialDocument AS MaterialDocument,
  _InspLot.DeliveryDocument AS DeliveryDocument,
  _InspLot.ManufacturingOrder AS ManufacturingOrder,
  _InspLot.ProductionVersion AS ProductionVersion,
  _ProductionVersion.ProductionVersionText AS ProductionVersionText,
  _InspLot.SalesOrder AS SalesOrder,
  case _InspLot.SalesOrderItem when '000000' then '' else _InspLot.SalesOrderItem end as SalesOrderItem AS SalesOrderItemendasSalesOrderItem,
  _InspLot.MaintenanceStrategy AS MaintenanceStrategy,
  _InspLot.MaintenancePlan AS MaintenancePlan,
  _InspLot.MaintenancePlanItemIntID AS MaintenancePlanItemIntID,
  _MaintenancePlan.MaintenancePlanDesc AS MaintenancePlanDesc,
  _MaintenanceItem.MaintenanceItemDescription AS MaintenancePlanItemDesc,
  _MaintenanceStrategyT.MaintenanceStrategyDesc AS MaintenanceStrategyDesc,
  _InspLot.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  InspLotSelectionValidFromDate,
  _InspLot.InspLotIsSerialNmbrPossible AS InspLotIsSerialNmbrPossible,
  _InspLot.SerialNumberProfile AS SerialNumberProfile
FROM I_InspectionLot AS _InspLot
LEFT OUTER JOIN I_InspectionLotTypeText AS _InspLotText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_InspectionLotOriginText AS _InspectionLotOriginText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaintenancePlanBasic AS _MaintenancePlan ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaintenanceStrategyT AS _MaintenanceStrategyT ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_Inspoperation_Object AS _Operation ON InspectionLot = _Operation.InspectionLot  -- association [1..*]
LEFT OUTER JOIN C_InspLotStatus AS _InspLotStatus ON InspectionLot = _InspLotStatus.InspectionLot  -- association [1..*]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Manufacturer ON Manufacturer = _Manufacturer.Supplier  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_ProductionVersion AS _ProductionVersion ON Material = _ProductionVersion.Material AND Plant = _ProductionVersion.Plant AND ProductionVersion = _ProductionVersion.ProductionVersion  -- association [1..1]
LEFT OUTER JOIN C_InspLotStockPosting AS _InspLotStockPosting ON InspectionLot = _InspLotStockPosting.InspectionLot  -- association [0..*]
LEFT OUTER JOIN I_UserContactCard AS _BusinessCardInfo ON InspectionLotCreatedBy = _BusinessCardInfo.ContactCardID OR inspectionlotusagedecidedby = _BusinessCardInfo.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ChangedByBusinessCardInfo ON InspectionLotChangedBy = _ChangedByBusinessCardInfo.ContactCardID OR insplotusagedecisionchangedby = _ChangedByBusinessCardInfo.ContactCardID  -- association [0..1]
LEFT OUTER JOIN C_InspLotDocument AS _InspLotDocument ON InspectionLot = _InspLotDocument.LinkedSAPObjectKey  -- association [1..*]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON _InspLot.Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [0..1]
;