I_QualityLevelTP_2

DDL: I_QUALITYLEVELTP_2 Type: view_entity TRANSACTIONAL Package: VDM_QM_CONTROL
49 Fields 1 Data Sources

Quality Level - TP

I_QualityLevelTP_2 is a Transactional CDS View that provides data about "Quality Level - TP" in SAP S/4HANA. It reads from 1 data source (R_QualityLevelTP) and exposes 49 fields with key fields Plant, Material, BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant. Part of development package VDM_QM_CONTROL.

Data Sources (1)

SourceAliasJoin Type
R_QualityLevelTP R_QualityLevelTP projection

Annotations (11)

NameValueLevelField
EndUserText.label Quality Level - TP view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.representativeKey QualityLevelInternalID view
ObjectModel.sapObjectNodeType.name QualityLevel view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY Plant Plant Valuation Area
KEY Material Material Vehicle Model
KEY BillOfOperationsType BillOfOperationsType Task List Type
KEY BillOfOperationsGroup BillOfOperationsGroup Group
KEY BillOfOperationsVariant BillOfOperationsVariant Group Counter
KEY BOOOperationInternalID BOOOperationInternalID Task list node
KEY Sequence Sequence Visit Sequence
KEY QualityLevelInternalID QualityLevelInternalID
Supplier Supplier Supplier
Manufacturer Manufacturer Manufacturer
Customer Customer Sold-to Party
InspectionLotType InspectionLotType Inspection Type
InspectionOperation InspectionOperation
InspectionCharacteristic InspectionCharacteristic
QltyLvlIndirectlyChangedBy QltyLvlIndirectlyChangedBy
QltyLvlManuallyChangedBy QltyLvlManuallyChangedBy
QltyLvlIndirectlyChangedOn QltyLvlIndirectlyChangedOn
QltyLvlManuallyChangedOn QltyLvlManuallyChangedOn
InspectionLot InspectionLot Inspection Lot
InspLotUsageDecisionValuation InspLotUsageDecisionValuation
InspLotUsgeDcsnDynValuation InspLotUsgeDcsnDynValuation
SamplingProcedure SamplingProcedure
InspLotDynamicRule InspLotDynamicRule
QltyLevelNextDynRuleStage QltyLevelNextDynRuleStage
InspLotsWithoutUsageDecision InspLotsWithoutUsageDecision
InspLotsSinceStageChg InspLotsSinceStageChg
RjctdInspLotsSinceStgeChg RjctdInspLotsSinceStgeChg
InspResultDynModifValuation InspResultDynModifValuation
InspectionValuationResult InspectionValuationResult
QualityLevelLastOpenInspLot QualityLevelLastOpenInspLot
QualityLevelLastInspectionOn QualityLevelLastInspectionOn
QltyLevelCanceledInspections QltyLevelCanceledInspections
QualityLevelDeletionOn QualityLevelDeletionOn
QualityLevelResetOn QualityLevelResetOn
ChangedDateTime ChangedDateTime Time Stamp
_Plant _Plant
_Material _Material
_BillOfOperationsType _BillOfOperationsType
_BillOfOperationsGroup _BillOfOperationsGroup
_BillOfOperations _BillOfOperations
_BOOOperationInternalID _BOOOperationInternalID
_Supplier _Supplier
_Customer _Customer
_NextInspLotDynRuleStage _NextInspLotDynRuleStage
_InspLotDynamicRule _InspLotDynamicRule
_InspectionLot _InspectionLot
_Manufacturer _Manufacturer
_QualityLevelLastOpenInspLot _QualityLevelLastOpenInspLot
_ProductPlantQtManagement _ProductPlantQtManagement

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_QualityLevelTP_2.
-- 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.

CREATE VIEW I_QualityLevelTP_2 AS
SELECT
  Plant,
  Material,
  BillOfOperationsType,
  BillOfOperationsGroup,
  BillOfOperationsVariant,
  BOOOperationInternalID,
  Sequence,
  QualityLevelInternalID,
  Supplier,
  Manufacturer,
  Customer,
  InspectionLotType,
  InspectionOperation,
  InspectionCharacteristic,
  QltyLvlIndirectlyChangedBy,
  QltyLvlManuallyChangedBy,
  QltyLvlIndirectlyChangedOn,
  QltyLvlManuallyChangedOn,
  InspectionLot,
  InspLotUsageDecisionValuation,
  InspLotUsgeDcsnDynValuation,
  SamplingProcedure,
  InspLotDynamicRule,
  QltyLevelNextDynRuleStage,
  InspLotsWithoutUsageDecision,
  InspLotsSinceStageChg,
  RjctdInspLotsSinceStgeChg,
  InspResultDynModifValuation,
  InspectionValuationResult,
  QualityLevelLastOpenInspLot,
  QualityLevelLastInspectionOn,
  QltyLevelCanceledInspections,
  QualityLevelDeletionOn,
  QualityLevelResetOn,
  ChangedDateTime
FROM R_QualityLevelTP
;

Learn More