C_InspLotRsltRecg
RAP View for Inspection Lots
C_InspLotRsltRecg is a Consumption CDS View that provides data about "RAP View for Inspection Lots" in SAP S/4HANA. It reads from 1 data source (I_InspectionLot) and exposes 141 fields with key field InspectionLot. It has 15 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_InspectionLot | _InspectionLot | from |
Associations (15)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_InspectionLotAggregate | _InspLotAggrgt | _InspectionLot.InspectionLot = _InspLotAggrgt.InspectionLot |
| [0..1] | P_InspOpAggr | _InspOpAggr | _InspectionLot.InspectionLot = _InspOpAggr.InspectionLot |
| [0..1] | I_InspectionLotCancelledStatus | _InspectionLotWithStatus | _InspectionLot.InspectionLot = _InspectionLotWithStatus.InspectionLot |
| [0..1] | I_BillOfOperationsType | _BillOfOperationsType | _InspectionLot.BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType |
| [0..1] | I_BillOfOperationsUsage | _BillOfOperationsUsage | _InspectionLot.BillOfOperationsUsage = _BillOfOperationsUsage.BillOfOperationsUsage |
| [0..1] | C_InspLotUsgeDcsnValnVH | _InspLotUsgeDcsnValnVH | $projection.insplotusagedecisionvaluation = _InspLotUsgeDcsnValnVH.InspLotUsageDecisionValuation |
| [0..1] | I_MaterialText | _MaterialText | _InspectionLot.Material = _MaterialText.Material and _MaterialText.Language = $session.system_language |
| [0..1] | I_Plant | _PlantText | _InspectionLot.Plant = _PlantText.Plant |
| [0..*] | C_InspLotOpCharcRsltRecg | _InspChar | $projection.InspectionLot = _InspChar.InspectionLot |
| [0..*] | C_InspLotOpUnplndCharcRsltRecg | _UnplannedChar | $projection.Plant = _UnplannedChar.InspectionSpecificationPlant |
| [1..1] | C_InspLotWithRsltRecgStatus | _InspLotWithRsltRecgStatus | _InspectionLot.InspectionLot = _InspLotWithRsltRecgStatus.InspectionLot |
| [0..1] | C_InspLotDefectCount | _InspLotDefectCount | $projection.InspectionLot = _InspLotDefectCount.InspectionLot |
| [1..*] | C_DefectDetailsRsltRecg | _DefectDetails | $projection.InspectionLot = _DefectDetails.InspectionLot |
| [0..*] | C_InspLotOpRsltRecg | _InspLotOp | |
| [0..*] | C_InspLotMatlSmplRsltRecg | _PhysicalSample | |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | RAP View for Inspection Lots | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| VDM.viewType | #CONSUMPTION | view | |
| Search.searchable | true | view | |
| UI.headerInfo.title.type | #STANDARD | view | |
| UI.headerInfo.title.value | Title | view |
Fields (141)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| NumberOfMaterialSamples | Number of Samples | |||
| InspCharOpenCountendasInspCharOpenCount | Number of Open Characteristics | |||
| EquipmentName | ||||
| FunctionalLocationLabelName | ||||
| FunctionalLocationName | ||||
| NumberOfDaysLeftForRsltRecg | ||||
| int4asInspCharacteristicCount | Number of Characteristics | |||
| BillOfOperationsTypeName | Bill of Operations Type | |||
| BillOfOperationsUsageDesc | Bill of Operations Usage | |||
| InspLotUsageDecisionChangedBy | ||||
| InspLotUsageDecisionChangedOn | ||||
| InspLotUsageDecisionCodeGroup | Code Group of Usage Decision | |||
| InspLotUsageDecisionTime | ||||
| InspLotUsageDecisionValuation | ||||
| InspLotUsgeDcsnChangedTime | ||||
| InspLotUsgeDcsnDynValuation | Dynamic Modification Valuation | |||
| InspLotUsgeDcsnFollowUpAction | ||||
| InspLotUsgeDcsnSelectedSet | Selected Set of Usage Decision | |||
| InspectionLotOriginText | ||||
| InspectionLotQualityScore | ||||
| InspectionLotTypeText | ||||
| InspectionLotUsageDecidedBy | ||||
| InspectionLotUsageDecidedOn | ||||
| InspectionLotUsageDecisionCode | ||||
| MatlQltyAuthorizationGrpText | ||||
| MatlQualityAuthorizationGroup | Material Authorization Group in QM | |||
| _InspLotOp | _InspLotOp | |||
| _PhysicalSample | _PhysicalSample | |||
| _InspChar | _InspChar | |||
| _UnplannedChar | _UnplannedChar | |||
| _InspLotDefectCount | _InspLotDefectCount | |||
| _InspLotWithRsltRecgStatus | _InspLotWithRsltRecgStatus | |||
| _DefectDetails | _DefectDetails | |||
| _PlantText | _PlantText | |||
| KEY | InspectionLot | I_InspectionLot | InspectionLot | Inspection Lot |
| Material | I_InspectionLot | Material | Vehicle Model | |
| Plant | I_InspectionLot | Plant | Valuation Area | |
| Batch | I_InspectionLot | Batch | Lot No. | |
| InspectionLotOrigin | I_InspectionLot | InspectionLotOrigin | ||
| InspectionLotEndDate | I_InspectionLot | InspectionLotEndDate | Inspection Lot End Date | |
| Equipment | I_InspectionLot | Equipment | Equipment check | |
| AccountAssignmentCategory | I_InspectionLot | AccountAssignmentCategory | Account Assignment Category | |
| AccountingDocumentType | I_InspectionLot | AccountingDocumentType | Journal Entry Type | |
| BatchBySupplier | I_InspectionLot | BatchBySupplier | Supplier Batch | |
| BatchStorageLocation | I_InspectionLot | BatchStorageLocation | ||
| BillOfOperationsGroup | I_InspectionLot | BillOfOperationsGroup | Group | |
| BillOfOperationsType | I_InspectionLot | BillOfOperationsType | Task List Type | |
| BillOfOperationsUsage | I_InspectionLot | BillOfOperationsUsage | ||
| BillOfOperationsVariant | I_InspectionLot | BillOfOperationsVariant | Group Counter | |
| BillToPartyCountry | I_InspectionLot | BillToPartyCountry | Dst.CtryRg.Ord. | |
| BusinessArea | I_InspectionLot | BusinessArea | Business Area | |
| CompanyCode | I_InspectionLot | CompanyCode | Receiver Company Code | |
| ControllingArea | I_InspectionLot | ControllingArea | Controlling Area | |
| CostCenter | I_InspectionLot | CostCenter | Cost Center | |
| Customer | I_InspectionLot | Customer | Sold-to Party | |
| InspectionDeliveryCategory | I_InspectionLot | InspectionDeliveryCategory | Delivery Category | |
| DeliveryDocument | I_InspectionLot | DeliveryDocument | Delivery Document | |
| DeliveryDocumentItem | I_InspectionLot | DeliveryDocumentItem | Delivery Item | |
| GLAccount | I_InspectionLot | GLAccount | G/L Account Number | |
| GoodsMovementType | I_InspectionLot | GoodsMovementType | Goods Movement Type | |
| GoodsReceiptIsMovedToBlkdStock | I_InspectionLot | GoodsReceiptIsMovedToBlkdStock | GR Posted to Blocked Stock | |
| InspLotBatchTransferredTo | I_InspectionLot | InspLotBatchTransferredTo | Batch for Which Quantity Is Posted | |
| InspLotCreatedOnLocalDate | I_InspectionLot | InspLotCreatedOnLocalDate | Lot Posting Date | |
| InspLotCreatedOnLocalTime | I_InspectionLot | InspLotCreatedOnLocalTime | Lot Posting Time | |
| InspLotDigitalSgntrInUsgeDcsn | I_InspectionLot | InspLotDigitalSgntrInUsgeDcsn | Digital Signature for UD Required | |
| InspLotDigitalSgntrResultsRecg | I_InspectionLot | InspLotDigitalSgntrResultsRecg | Digital Signature for Inspection Required | |
| InspLotExternalNumber | I_InspectionLot | InspLotExternalNumber | Inspection Document from External System | |
| InspLotIsSerialNmbrPossible | I_InspectionLot | InspLotIsSerialNmbrPossible | Serial Numbers | |
| InspLotMaterialPostedTo | I_InspectionLot | InspLotMaterialPostedTo | Material to Which Quantity Is Posted | |
| InspLotNmbrAddlRecordedCharc | I_InspectionLot | InspLotNmbrAddlRecordedCharc | Number of Added Characteristics | |
| InspLotNmbrOpenLongTermCharc | I_InspectionLot | InspLotNmbrOpenLongTermCharc | Number of Open Long-Term Characteristics | |
| InspLotNmbrOpenShortTermCharc | I_InspectionLot | InspLotNmbrOpenShortTermCharc | Number of Open Short-Term Characteristics | |
| InspLotQtyDestroyed | I_InspectionLot | InspLotQtyDestroyed | ||
| InspLotQtyInspected | I_InspectionLot | InspLotQtyInspected | Actually Inspected | |
| InspLotQtyReturnedToSupplier | I_InspectionLot | InspLotQtyReturnedToSupplier | ||
| InspLotQtyToAnotherMaterial | I_InspectionLot | InspLotQtyToAnotherMaterial | Posted to Another Material | |
| InspLotQtyToBePosted | I_InspectionLot | InspLotQtyToBePosted | Must Be Posted | |
| InspLotQtyToBlocked | I_InspectionLot | InspLotQtyToBlocked | Posted to Blocked Stock | |
| InspLotQtyToFree | I_InspectionLot | InspLotQtyToFree | Posted to Unrestricted-Use Stock | |
| InspLotQtyToOtherStock | I_InspectionLot | InspLotQtyToOtherStock | Posted from Inspection Lot Stock (Option 2) | |
| InspLotQtyToReserves | I_InspectionLot | InspLotQtyToReserves | Posted to Reserves | |
| InspLotQtyToSample | I_InspectionLot | InspLotQtyToSample | Posted to Sample | |
| InspLotQtyToScrap | I_InspectionLot | InspLotQtyToScrap | Posted to Scrap | |
| InspLotQtyToSpecialStock | I_InspectionLot | InspLotQtyToSpecialStock | Posted from Inspection Lot Stock (Option 1) | |
| InspLotSelectionValidFromDate | I_InspectionLot | InspLotSelectionValidFromDate | Bill of Operations Valid From | |
| InspLotSmplQtyForLongTermChar | I_InspectionLot | InspLotSmplQtyForLongTermChar | Sample Quantity for Long-Term Characteristic | |
| InspectionLotActualQuantity | I_InspectionLot | InspectionLotActualQuantity | ||
| InspectionLotApproval | I_InspectionLot | InspectionLotApproval | Inspection Lot Approval Required | |
| InspectionLotChangeDate | I_InspectionLot | InspectionLotChangeDate | Lot Last Change Date | |
| InspectionLotChangeTime | I_InspectionLot | InspectionLotChangeTime | Lot Last Change Time | |
| InspectionLotChangedBy | I_InspectionLot | InspectionLotChangedBy | Lot Last Changed By | |
| InspectionLotContainer | I_InspectionLot | InspectionLotContainer | No. Containers | |
| InspectionLotContainerUnit | I_InspectionLot | InspectionLotContainerUnit | Lot Container | |
| InspectionLotCreatedBy | I_InspectionLot | InspectionLotCreatedBy | Lot Created By | |
| InspectionLotCreatedOn | I_InspectionLot | InspectionLotCreatedOn | Lot Creation Date | |
| InspectionLotCreatedOnTime | I_InspectionLot | InspectionLotCreatedOnTime | Lot Creation Time | |
| InspectionLotDefectiveQuantity | I_InspectionLot | InspectionLotDefectiveQuantity | ||
| InspectionLotHasPartialLots | I_InspectionLot | InspectionLotHasPartialLots | Partial Lots | |
| InspectionLotHasQuantity | I_InspectionLot | InspectionLotHasQuantity | ||
| InspectionLotObjectText | I_InspectionLot | InspectionLotObjectText | Inspection Object Description | |
| InspectionLotPlant | I_InspectionLot | InspectionLotPlant | ||
| InspectionLotQuantity | I_InspectionLot | InspectionLotQuantity | Lot Quantity | |
| InspectionLotQuantityUnit | I_InspectionLot | InspectionLotQuantityUnit | Sample UOM | |
| InspectionLotSampleQuantity | I_InspectionLot | InspectionLotSampleQuantity | Sample Size | |
| InspectionLotSampleUnit | I_InspectionLot | InspectionLotSampleUnit | ||
| InspectionLotScrapRatio | I_InspectionLot | InspectionLotScrapRatio | Share of Scrap | |
| InspectionLotStartDate | I_InspectionLot | InspectionLotStartDate | Lot Start Date | |
| InspectionLotStorageLocation | I_InspectionLot | InspectionLotStorageLocation | ||
| InspectionLotText | I_InspectionLot | InspectionLotText | Lot Short Text | |
| InspectionLotType | I_InspectionLot | InspectionLotType | Inspection Type | |
| Manufacturer | I_InspectionLot | Manufacturer | Manufacturer | |
| ManufacturerPartNmbr | I_InspectionLot | ManufacturerPartNmbr | Mfr Part Number | |
| ManufacturingOrder | I_InspectionLot | ManufacturingOrder | Order | |
| MaterialByCustomer | I_InspectionLot | MaterialByCustomer | Customer Material Number | |
| MaterialCompIsSpecialStock | I_InspectionLot | MaterialCompIsSpecialStock | Posted to Special Stock | |
| MaterialDocument | I_InspectionLot | MaterialDocument | Material Doc. | |
| MaterialDocumentItem | I_InspectionLot | MaterialDocumentItem | Material Document Item | |
| MaterialDocumentYear | I_InspectionLot | MaterialDocumentYear | Material Document Year | |
| MaterialIsBatchManaged | I_InspectionLot | MaterialIsBatchManaged | Batch Management Required | |
| MatlDocLatestPostgDate | I_InspectionLot | MatlDocLatestPostgDate | Document Posting Date | |
| ProductionVersion | I_InspectionLot | ProductionVersion | Version ID | |
| ProfitCenter | I_InspectionLot | ProfitCenter | Profit Center | |
| PurchasingDocument | I_InspectionLot | PurchasingDocument | Purchase Order | |
| PurchasingDocumentItem | I_InspectionLot | PurchasingDocumentItem | Purchase Order Item | |
| PurchasingOrganization | I_InspectionLot | PurchasingOrganization | Purchasing Organization | |
| QualityCostCollector | I_InspectionLot | QualityCostCollector | Order for Recording Appraisal Costs | |
| Route | I_InspectionLot | Route | Vehicle route | |
| SalesOrder | I_InspectionLot | SalesOrder | SD Document | |
| SalesOrderItem | I_InspectionLot | SalesOrderItem | Sales Order Item | |
| SalesOrganization | I_InspectionLot | SalesOrganization | Sales Organization | |
| ScheduleLine | I_InspectionLot | ScheduleLine | Delivery Schedule Line Counter | |
| SerialNumberProfile | I_InspectionLot | SerialNumberProfile | Serial Number Profile | |
| SoldToParty | I_InspectionLot | SoldToParty | Sold-to Party | |
| Supplier | I_InspectionLot | Supplier | Supplier | |
| IsBusinessPurposeCompleted | I_InspectionLot | IsBusinessPurposeCompleted | Purpose Completed | |
| NumberOfDefects | _InspLotDefectCount | NumberOfDefects | ||
| InspOpNmbrOfOpenCmpltd | _InspOpAggr | InspOpNmbrOfOpenCmpltd | Number of Open Operations | |
| InspOpNmbrOfAcceptedCmpltd | _InspOpAggr | InspOpNmbrOfAcceptedCmpltd | Number of Accepted Operations | |
| InspOpNmbrOfRjctdCmpltd | _InspOpAggr | InspOpNmbrOfRjctdCmpltd | Number of Rejected Operations | |
| MaterialName | _MaterialText | MaterialName | Material Description | |
| PlantName | _PlantText | PlantName | Plant Name |
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_InspLotRsltRecg.
-- 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: CINSPLOTRSLTRECG
CREATE VIEW C_InspLotRsltRecg AS
SELECT
cast(_InspLotAggrgt.MaterialSampleCount as abap.int4 ) AS NumberOfMaterialSamples,
case when _InspectionLot.InspLotHasSubsets = 'X' then _InspLotAggrgt.InspSubsetCharcOpenCount else _InspLotAggrgt.InspCharOpenCount end as InspCharOpenCount AS InspCharOpenCountendasInspCharOpenCount,
_InspectionLot._Equipment._EquipmentText[1:Language=$session.system_language].EquipmentName AS EquipmentName,
_InspectionLot._FunctionalLocation._FunctionalLocationLabel.FunctionalLocationLabelName AS FunctionalLocationLabelName,
_InspectionLot._FunctionalLocation._FunctionalLocationText[1:Language = $session.system_language].FunctionalLocationName AS FunctionalLocationName,
dats_days_between(cast($session.system_date as abap.dats), _InspectionLot.InspectionLotEndDate) AS NumberOfDaysLeftForRsltRecg,
cast( case when _InspectionLot.InspLotHasSubsets = 'X' then _InspLotAggrgt.InspSubsetCharcAcceptedCount + _InspLotAggrgt.InspSubsetCharcRejectedCount + _InspLotAggrgt.InspSubsetCharcOpenCount + _InspLotAggrgt.NumberOfSkipInspSubsetCharcs else _InspLotAggrgt.InspCharAcceptedCount + _InspLotAggrgt.InspCharRejectedCount + _InspLotAggrgt.InspCharOpenCount + _InspLotAggrgt.NumberOfSkipInspCharcs end as abap.int4) as InspCharacteristicCount AS int4asInspCharacteristicCount,
_InspectionLot._BillOfOperationsType._Text[1:Language=$session.system_language].BillOfOperationsTypeName AS BillOfOperationsTypeName,
_BillOfOperationsUsage._Text[1:Language=$session.system_language].BillOfOperationsUsageDesc AS BillOfOperationsUsageDesc,
_InspectionLot._InspLotUsageDecision.InspLotUsageDecisionChangedBy AS InspLotUsageDecisionChangedBy,
_InspectionLot._InspLotUsageDecision.InspLotUsageDecisionChangedOn AS InspLotUsageDecisionChangedOn,
_InspectionLot._InspLotUsageDecision.InspLotUsageDecisionCodeGroup AS InspLotUsageDecisionCodeGroup,
_InspectionLot._InspLotUsageDecision.InspLotUsageDecisionTime AS InspLotUsageDecisionTime,
_InspectionLot._InspLotUsageDecision.InspLotUsageDecisionValuation AS InspLotUsageDecisionValuation,
_InspectionLot._InspLotUsageDecision.InspLotUsgeDcsnChangedTime AS InspLotUsgeDcsnChangedTime,
_InspectionLot._InspLotUsageDecision.InspLotUsgeDcsnDynValuation AS InspLotUsgeDcsnDynValuation,
_InspectionLot._InspLotUsageDecision.InspLotUsgeDcsnFollowUpAction AS InspLotUsgeDcsnFollowUpAction,
_InspectionLot._InspLotUsageDecision.InspLotUsgeDcsnSelectedSet AS InspLotUsgeDcsnSelectedSet,
_InspectionLot._InspectionLotOrigin._Text[1:Language=$session.system_language].InspectionLotOriginText AS InspectionLotOriginText,
_InspectionLot._InspLotUsageDecision.InspectionLotQualityScore AS InspectionLotQualityScore,
_InspectionLot._InspectionLotType._Text[1:Language=$session.system_language].InspectionLotTypeText AS InspectionLotTypeText,
_InspectionLot._InspLotUsageDecision.InspectionLotUsageDecidedBy AS InspectionLotUsageDecidedBy,
_InspectionLot._InspLotUsageDecision.InspectionLotUsageDecidedOn AS InspectionLotUsageDecidedOn,
_InspectionLot._InspLotUsageDecision.InspectionLotUsageDecisionCode AS InspectionLotUsageDecisionCode,
_InspectionLot._MatlQualityAuthGroup._Text[1:Language=$session.system_language].MatlQltyAuthorizationGrpText AS MatlQltyAuthorizationGrpText,
_InspectionLot._MatlQualityAuthGroup.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup,
_InspectionLot.InspectionLot AS InspectionLot,
_InspectionLot.Material AS Material,
_InspectionLot.Plant AS Plant,
_InspectionLot.Batch AS Batch,
_InspectionLot.InspectionLotOrigin AS InspectionLotOrigin,
_InspectionLot.InspectionLotEndDate AS InspectionLotEndDate,
_InspectionLot.Equipment AS Equipment,
_InspectionLot.AccountAssignmentCategory AS AccountAssignmentCategory,
_InspectionLot.AccountingDocumentType AS AccountingDocumentType,
_InspectionLot.BatchBySupplier AS BatchBySupplier,
_InspectionLot.BatchStorageLocation AS BatchStorageLocation,
_InspectionLot.BillOfOperationsGroup AS BillOfOperationsGroup,
_InspectionLot.BillOfOperationsType AS BillOfOperationsType,
_InspectionLot.BillOfOperationsUsage AS BillOfOperationsUsage,
_InspectionLot.BillOfOperationsVariant AS BillOfOperationsVariant,
_InspectionLot.BillToPartyCountry AS BillToPartyCountry,
_InspectionLot.BusinessArea AS BusinessArea,
_InspectionLot.CompanyCode AS CompanyCode,
_InspectionLot.ControllingArea AS ControllingArea,
_InspectionLot.CostCenter AS CostCenter,
_InspectionLot.Customer AS Customer,
_InspectionLot.InspectionDeliveryCategory AS InspectionDeliveryCategory,
_InspectionLot.DeliveryDocument AS DeliveryDocument,
_InspectionLot.DeliveryDocumentItem AS DeliveryDocumentItem,
_InspectionLot.GLAccount AS GLAccount,
_InspectionLot.GoodsMovementType AS GoodsMovementType,
_InspectionLot.GoodsReceiptIsMovedToBlkdStock AS GoodsReceiptIsMovedToBlkdStock,
_InspectionLot.InspLotBatchTransferredTo AS InspLotBatchTransferredTo,
_InspectionLot.InspLotCreatedOnLocalDate AS InspLotCreatedOnLocalDate,
_InspectionLot.InspLotCreatedOnLocalTime AS InspLotCreatedOnLocalTime,
_InspectionLot.InspLotDigitalSgntrInUsgeDcsn AS InspLotDigitalSgntrInUsgeDcsn,
_InspectionLot.InspLotDigitalSgntrResultsRecg AS InspLotDigitalSgntrResultsRecg,
_InspectionLot.InspLotExternalNumber AS InspLotExternalNumber,
_InspectionLot.InspLotIsSerialNmbrPossible AS InspLotIsSerialNmbrPossible,
_InspectionLot.InspLotMaterialPostedTo AS InspLotMaterialPostedTo,
_InspectionLot.InspLotNmbrAddlRecordedCharc AS InspLotNmbrAddlRecordedCharc,
_InspectionLot.InspLotNmbrOpenLongTermCharc AS InspLotNmbrOpenLongTermCharc,
_InspectionLot.InspLotNmbrOpenShortTermCharc AS InspLotNmbrOpenShortTermCharc,
_InspectionLot.InspLotQtyDestroyed AS InspLotQtyDestroyed,
_InspectionLot.InspLotQtyInspected AS InspLotQtyInspected,
_InspectionLot.InspLotQtyReturnedToSupplier AS InspLotQtyReturnedToSupplier,
_InspectionLot.InspLotQtyToAnotherMaterial AS InspLotQtyToAnotherMaterial,
_InspectionLot.InspLotQtyToBePosted AS InspLotQtyToBePosted,
_InspectionLot.InspLotQtyToBlocked AS InspLotQtyToBlocked,
_InspectionLot.InspLotQtyToFree AS InspLotQtyToFree,
_InspectionLot.InspLotQtyToOtherStock AS InspLotQtyToOtherStock,
_InspectionLot.InspLotQtyToReserves AS InspLotQtyToReserves,
_InspectionLot.InspLotQtyToSample AS InspLotQtyToSample,
_InspectionLot.InspLotQtyToScrap AS InspLotQtyToScrap,
_InspectionLot.InspLotQtyToSpecialStock AS InspLotQtyToSpecialStock,
_InspectionLot.InspLotSelectionValidFromDate AS InspLotSelectionValidFromDate,
_InspectionLot.InspLotSmplQtyForLongTermChar AS InspLotSmplQtyForLongTermChar,
_InspectionLot.InspectionLotActualQuantity AS InspectionLotActualQuantity,
_InspectionLot.InspectionLotApproval AS InspectionLotApproval,
_InspectionLot.InspectionLotChangeDate AS InspectionLotChangeDate,
_InspectionLot.InspectionLotChangeTime AS InspectionLotChangeTime,
_InspectionLot.InspectionLotChangedBy AS InspectionLotChangedBy,
_InspectionLot.InspectionLotContainer AS InspectionLotContainer,
_InspectionLot.InspectionLotContainerUnit AS InspectionLotContainerUnit,
_InspectionLot.InspectionLotCreatedBy AS InspectionLotCreatedBy,
_InspectionLot.InspectionLotCreatedOn AS InspectionLotCreatedOn,
_InspectionLot.InspectionLotCreatedOnTime AS InspectionLotCreatedOnTime,
_InspectionLot.InspectionLotDefectiveQuantity AS InspectionLotDefectiveQuantity,
_InspectionLot.InspectionLotHasPartialLots AS InspectionLotHasPartialLots,
_InspectionLot.InspectionLotHasQuantity AS InspectionLotHasQuantity,
_InspectionLot.InspectionLotObjectText AS InspectionLotObjectText,
_InspectionLot.InspectionLotPlant AS InspectionLotPlant,
_InspectionLot.InspectionLotQuantity AS InspectionLotQuantity,
_InspectionLot.InspectionLotQuantityUnit AS InspectionLotQuantityUnit,
_InspectionLot.InspectionLotSampleQuantity AS InspectionLotSampleQuantity,
_InspectionLot.InspectionLotSampleUnit AS InspectionLotSampleUnit,
_InspectionLot.InspectionLotScrapRatio AS InspectionLotScrapRatio,
_InspectionLot.InspectionLotStartDate AS InspectionLotStartDate,
_InspectionLot.InspectionLotStorageLocation AS InspectionLotStorageLocation,
_InspectionLot.InspectionLotText AS InspectionLotText,
_InspectionLot.InspectionLotType AS InspectionLotType,
_InspectionLot.Manufacturer AS Manufacturer,
_InspectionLot.ManufacturerPartNmbr AS ManufacturerPartNmbr,
_InspectionLot.ManufacturingOrder AS ManufacturingOrder,
_InspectionLot.MaterialByCustomer AS MaterialByCustomer,
_InspectionLot.MaterialCompIsSpecialStock AS MaterialCompIsSpecialStock,
_InspectionLot.MaterialDocument AS MaterialDocument,
_InspectionLot.MaterialDocumentItem AS MaterialDocumentItem,
_InspectionLot.MaterialDocumentYear AS MaterialDocumentYear,
_InspectionLot.MaterialIsBatchManaged AS MaterialIsBatchManaged,
_InspectionLot.MatlDocLatestPostgDate AS MatlDocLatestPostgDate,
_InspectionLot.ProductionVersion AS ProductionVersion,
_InspectionLot.ProfitCenter AS ProfitCenter,
_InspectionLot.PurchasingDocument AS PurchasingDocument,
_InspectionLot.PurchasingDocumentItem AS PurchasingDocumentItem,
_InspectionLot.PurchasingOrganization AS PurchasingOrganization,
_InspectionLot.QualityCostCollector AS QualityCostCollector,
_InspectionLot.Route AS Route,
_InspectionLot.SalesOrder AS SalesOrder,
_InspectionLot.SalesOrderItem AS SalesOrderItem,
_InspectionLot.SalesOrganization AS SalesOrganization,
_InspectionLot.ScheduleLine AS ScheduleLine,
_InspectionLot.SerialNumberProfile AS SerialNumberProfile,
_InspectionLot.SoldToParty AS SoldToParty,
_InspectionLot.Supplier AS Supplier,
_InspectionLot.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
_InspLotDefectCount.NumberOfDefects AS NumberOfDefects,
_InspOpAggr.InspOpNmbrOfOpenCmpltd AS InspOpNmbrOfOpenCmpltd,
_InspOpAggr.InspOpNmbrOfAcceptedCmpltd AS InspOpNmbrOfAcceptedCmpltd,
_InspOpAggr.InspOpNmbrOfRjctdCmpltd AS InspOpNmbrOfRjctdCmpltd,
_MaterialText.MaterialName AS MaterialName,
_PlantText.PlantName AS PlantName
FROM I_InspectionLot AS _InspectionLot
LEFT OUTER JOIN I_InspectionLotAggregate AS _InspLotAggrgt ON _InspectionLot.InspectionLot = _InspLotAggrgt.InspectionLot -- association [0..1]
LEFT OUTER JOIN P_InspOpAggr AS _InspOpAggr ON _InspectionLot.InspectionLot = _InspOpAggr.InspectionLot -- association [0..1]
LEFT OUTER JOIN I_InspectionLotCancelledStatus AS _InspectionLotWithStatus ON _InspectionLot.InspectionLot = _InspectionLotWithStatus.InspectionLot -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsType ON _InspectionLot.BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsUsage AS _BillOfOperationsUsage ON _InspectionLot.BillOfOperationsUsage = _BillOfOperationsUsage.BillOfOperationsUsage -- association [0..1]
LEFT OUTER JOIN C_InspLotUsgeDcsnValnVH AS _InspLotUsgeDcsnValnVH ON insplotusagedecisionvaluation = _InspLotUsgeDcsnValnVH.InspLotUsageDecisionValuation -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON _InspectionLot.Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language -- association [0..1]
LEFT OUTER JOIN I_Plant AS _PlantText ON _InspectionLot.Plant = _PlantText.Plant -- association [0..1]
LEFT OUTER JOIN C_InspLotOpCharcRsltRecg AS _InspChar ON InspectionLot = _InspChar.InspectionLot -- association [0..*]
LEFT OUTER JOIN C_InspLotOpUnplndCharcRsltRecg AS _UnplannedChar ON Plant = _UnplannedChar.InspectionSpecificationPlant -- association [0..*]
LEFT OUTER JOIN C_InspLotWithRsltRecgStatus AS _InspLotWithRsltRecgStatus ON _InspectionLot.InspectionLot = _InspLotWithRsltRecgStatus.InspectionLot -- association [1..1]
LEFT OUTER JOIN C_InspLotDefectCount AS _InspLotDefectCount ON InspectionLot = _InspLotDefectCount.InspectionLot -- association [0..1]
LEFT OUTER JOIN C_DefectDetailsRsltRecg AS _DefectDetails ON InspectionLot = _DefectDetails.InspectionLot -- association [1..*]
LEFT OUTER JOIN C_InspLotOpRsltRecg AS _InspLotOp ON /* condition not available in parsed metadata */ -- association [0..*]
LEFT OUTER JOIN C_InspLotMatlSmplRsltRecg AS _PhysicalSample ON /* condition not available in parsed metadata */ -- association [0..*]
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA