A_InspectionSubset

DDL: A_INSPECTIONSUBSET SQL: AINSPSUBSET Type: view COMPOSITE
47 Fields 1 Data Sources

Inspection Points

A_InspectionSubset is a Composite CDS View that provides data about "Inspection Points" in SAP S/4HANA. It reads from 1 data source (I_InspectionSubsetTP_2) and exposes 47 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionSubsetInternalID.

Data Sources (1)

SourceAliasJoin Type
I_InspectionSubsetTP_2 I_InspectionSubsetTP_2 from

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName AINSPSUBSET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Inspection Points view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.compositionRoot true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled false view
ObjectModel.entityChangeStateId ChangedDateTime view

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot InspectionLot Inspection Lot
KEY InspPlanOperationInternalID InspPlanOperationInternalID
KEY InspectionSubsetInternalID InspectionSubsetInternalID
MaterialSample MaterialSample
Equipment Equipment Equipment check
FunctionalLocation FunctionalLocation Object ID
ShopFloorItem ShopFloorItem Serial.Mat. ID
SelectedCodeSetPlant SelectedCodeSetPlant
SelectedCodeSet SelectedCodeSet CodeGrp/SelSet
InspSubsetUsageDcsnCodeGroup InspSubsetUsageDcsnCodeGroup
InspSubsetUsageDcsnCode InspSubsetUsageDcsnCode
InspSubsetUsageDcsnValuation InspSubsetUsageDcsnValuation
InspectionSubsetTime InspectionSubsetTime
InspectionSubsetDate InspectionSubsetDate
InspSubsetLongNumericKey InspSubsetLongNumericKey
InspSubsetShortNumericKey InspSubsetShortNumericKey
InspectionSubsetLongCharKey InspectionSubsetLongCharKey
InspectionSubsetShortCharKey InspectionSubsetShortCharKey
InspectionPartialLot InspectionPartialLot
Inspector Inspector Inspector
InspectionSubsetYieldQty InspectionSubsetYieldQty
InspectionSubsetScrapQty InspectionSubsetScrapQty
InspectionSubsetReworkQty InspectionSubsetReworkQty
InspectionSubsetQtyUnit InspectionSubsetQtyUnit
InspSbstFuncnlLocProperty InspSbstFuncnlLocProperty
InspSbstEquipProperty InspSbstEquipProperty
InspSbstMatlSmplProperty InspSbstMatlSmplProperty
InspectionSubsetSortKey InspectionSubsetSortKey
InspSbstDateFldProperty InspSbstDateFldProperty
InspSbstLongNmbrFldProperty InspSbstLongNmbrFldProperty
InspSbstShrtNmbrFldProperty InspSbstShrtNmbrFldProperty
InspSbstLongTxtFldProperty InspSbstLongTxtFldProperty
InspSbstTimeFldProperty InspSbstTimeFldProperty
InspSbstShrtTxtFldProperty InspSbstShrtTxtFldProperty
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
ChangedDateTime ChangedDateTime Time Stamp
Plant Plant Valuation Area
WorkCenter WorkCenter Work Center
InspectionLotType InspectionLotType Inspection Type
InspectionSubsetType InspectionSubsetType
MatlQualityAuthorizationGroup MatlQualityAuthorizationGroup QM Matl Auth.
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed

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 A_InspectionSubset.
-- 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: AINSPSUBSET

CREATE VIEW A_InspectionSubset AS
SELECT
  InspectionLot,
  InspPlanOperationInternalID,
  InspectionSubsetInternalID,
  MaterialSample,
  Equipment,
  FunctionalLocation,
  ShopFloorItem,
  SelectedCodeSetPlant,
  SelectedCodeSet,
  InspSubsetUsageDcsnCodeGroup,
  InspSubsetUsageDcsnCode,
  InspSubsetUsageDcsnValuation,
  InspectionSubsetTime,
  InspectionSubsetDate,
  InspSubsetLongNumericKey,
  InspSubsetShortNumericKey,
  InspectionSubsetLongCharKey,
  InspectionSubsetShortCharKey,
  InspectionPartialLot,
  Inspector,
  InspectionSubsetYieldQty,
  InspectionSubsetScrapQty,
  InspectionSubsetReworkQty,
  InspectionSubsetQtyUnit,
  InspSbstFuncnlLocProperty,
  InspSbstEquipProperty,
  InspSbstMatlSmplProperty,
  InspectionSubsetSortKey,
  InspSbstDateFldProperty,
  InspSbstLongNmbrFldProperty,
  InspSbstShrtNmbrFldProperty,
  InspSbstLongTxtFldProperty,
  InspSbstTimeFldProperty,
  InspSbstShrtTxtFldProperty,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  ChangedDateTime,
  Plant,
  WorkCenter,
  InspectionLotType,
  InspectionSubsetType,
  MatlQualityAuthorizationGroup,
  IsBusinessPurposeCompleted
FROM I_InspectionSubsetTP_2
;

Learn More