P_SPQItmConditionAmountDEX

DDL: P_SPQITMCONDITIONAMOUNTDEX Type: view_entity BASIC
6 Fields 2 Data Sources 1 Associations

Private Data Extraction For Amount of SPQ Item

P_SPQItmConditionAmountDEX is a Basic CDS View that provides data about "Private Data Extraction For Amount of SPQ Item" in SAP S/4HANA. It reads from 2 data sources (a4mb, konp) and exposes 6 fields with key fields ConditionRecord, ConditionSequentialNumberShort. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
a4mb a4mb inner
konp konp from

Associations (1)

CardinalityTargetAliasCondition
[1] I_Currency _Currency _Currency.Currency = konp.knumh

Annotations (5)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
VDM.private true view
EndUserText.label Private Data Extraction For Amount of SPQ Item view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ConditionRecord konp knumh NoCondRec.Batch
KEY ConditionSequentialNumberShort konp kopos SequNo of Cond.
ConditionScaleAmount konp kstbw Scale Value
ConditionScaleAmountCurrency konp konws Scale Currency
MaximumConditionAmount konp komxwrt MaxConditValue
ConditionAlternativeCurrency konp kwaeh Cndn Currency

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_SPQItmConditionAmountDEX.
-- 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 P_SPQItmConditionAmountDEX AS
SELECT
  konp.knumh AS ConditionRecord,
  konp.kopos AS ConditionSequentialNumberShort,
  konp.kstbw AS ConditionScaleAmount,
  konp.konws AS ConditionScaleAmountCurrency,
  konp.komxwrt AS MaximumConditionAmount,
  konp.kwaeh AS ConditionAlternativeCurrency
FROM konp
INNER JOIN a4mb ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Currency AS _Currency ON _Currency.Currency = konp.knumh  -- association [1]
;

Learn More