P_InspSpecQuantityCtrl

DDL: P_INSPSPECQUANTITYCTRL SQL: PINSPQTYCTRL Type: view BASIC
29 Fields 1 Data Sources 1 Associations

P_InspSpecQuantityCtrl is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (qpmk) and exposes 29 fields with key fields InspectionSpecificationPlant, InspectionSpecification, InspectionSpecificationVersion. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
qpmk qpmk from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_UnitOfMeasure _UnitOfMeasure $projection.InspectionSpecificationUnit = _UnitOfMeasure.UnitOfMeasure

Annotations (5)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PINSPQTYCTRL view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY InspectionSpecificationPlant qpmk zaehler Version
KEY InspectionSpecification qpmk mkmnr Master IC
KEY InspectionSpecificationVersion qpmk version XML Vers.
InspSpecDecimalPlaces qpmk stellen Decimal Places
InspectionSpecificationUnit qpmk masseinhsw Unit of Meas.
InspSpecTargetValue qpmk sollwert Target Value
InspSpecHasTargetValue qpmk sollwni Not Initial
InspSpecUpperLimit qpmk toleranzob Upper Limit
tolobni qpmk tolobni Not Initial
InspSpecLowerLimit qpmk toleranzun Lower Limit
tolunni qpmk tolunni Not Initial
InspSpecFirstUpperSpecLimit qpmk grenzeob1 1st Upper Limit
grenzob1ni qpmk grenzob1ni Not Initial
InspSpecFirstLowerSpecLimit qpmk grenzeun1 1st Lower Limit
grenzun1ni qpmk grenzun1ni Not Initial
InspSpecSecondUpperSpecLimit qpmk grenzeob2 2nd Upper Limit
grenzob2ni qpmk grenzob2ni Not Initial
InspSpecSecondLowerSpecLimit qpmk grenzeun2 2nd Lower Limit
grenzun2ni qpmk grenzun2ni Not Initial
InspSpecUpperPlausibilityLimit qpmk plausioben UpPlaus. Limit
plausiobni qpmk plausiobni Not Initial
InspSpecLowerPlausibilityLimit qpmk plausiunte LoPlaus. Limit
plausiunni qpmk plausiunni Not Initial
InspSpecUpperSpecLimitChange qpmk tolerweiob UpperSpecLmtChg
tolwobni qpmk tolwobni Not Initial
InspSpecLowerSpecLimitChange qpmk tolerweiun LowerSpecLmtChg
tolwunni qpmk tolwunni Not Initial
UnitOfMeasureName
_UnitOfMeasure _UnitOfMeasure

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 P_InspSpecQuantityCtrl.
-- 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: PINSPQTYCTRL

CREATE VIEW P_InspSpecQuantityCtrl AS
SELECT
  qpmk.zaehler AS InspectionSpecificationPlant,
  qpmk.mkmnr AS InspectionSpecification,
  qpmk.version AS InspectionSpecificationVersion,
  qpmk.stellen AS InspSpecDecimalPlaces,
  qpmk.masseinhsw AS InspectionSpecificationUnit,
  qpmk.sollwert AS InspSpecTargetValue,
  qpmk.sollwni AS InspSpecHasTargetValue,
  qpmk.toleranzob AS InspSpecUpperLimit,
  qpmk.tolobni AS tolobni,
  qpmk.toleranzun AS InspSpecLowerLimit,
  qpmk.tolunni AS tolunni,
  qpmk.grenzeob1 AS InspSpecFirstUpperSpecLimit,
  qpmk.grenzob1ni AS grenzob1ni,
  qpmk.grenzeun1 AS InspSpecFirstLowerSpecLimit,
  qpmk.grenzun1ni AS grenzun1ni,
  qpmk.grenzeob2 AS InspSpecSecondUpperSpecLimit,
  qpmk.grenzob2ni AS grenzob2ni,
  qpmk.grenzeun2 AS InspSpecSecondLowerSpecLimit,
  qpmk.grenzun2ni AS grenzun2ni,
  qpmk.plausioben AS InspSpecUpperPlausibilityLimit,
  qpmk.plausiobni AS plausiobni,
  qpmk.plausiunte AS InspSpecLowerPlausibilityLimit,
  qpmk.plausiunni AS plausiunni,
  qpmk.tolerweiob AS InspSpecUpperSpecLimitChange,
  qpmk.tolwobni AS tolwobni,
  qpmk.tolerweiun AS InspSpecLowerSpecLimitChange,
  qpmk.tolwunni AS tolwunni,
  _UnitOfMeasure._Text[1:Language=$session.system_language].UnitOfMeasureName AS UnitOfMeasureName
FROM qpmk
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON InspectionSpecificationUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
;

Learn More