I_PricingAccessField

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_PricingAccessField.
-- 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: ICNDNACCF

CREATE VIEW I_PricingAccessField AS
SELECT
  t682z.kvewe AS ConditionUsage,
  t682z.kappl AS ConditionApplication,
  t682z.kozgf AS AccessSequence,
  t682z.kolnr AS AccessNumberOfAccessSequence,
  cast ( t682i.kotabnr as char03 ) AS ConditionTable,
  t682z.zifna AS PricingConditionField,
  t682z.qustr AS PrcgCndnAccDocumentStructure,
  t682z.qufna AS PrcgCndnAccessDocumentField,
  t682z.qudiw AS PrcgCndnAccConstantValueSource,
  t682z.kzini AS PrcgCndnValueInitialIsAllowed,
  t682z.fstst AS PricingConditionAccessType,
  t682z.mbwrt AS PricingConditionAccessPriority,
  t682z.direction_hier_eval AS PrcgConditionAccessDirection,
  t682z.dist_leaf_to_node_in_hlvls AS PrcgCndnAccessDistanceValue
FROM t682z
INNER JOIN t682i ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PricingAccess AS _PricingAccess ON ConditionUsage = _PricingAccess.ConditionUsage AND ConditionApplication = _PricingAccess.ConditionApplication AND AccessSequence = _PricingAccess.AccessSequence AND AccessNumberOfAccessSequence = _PricingAccess.AccessNumberOfAccessSequence  -- association [1..1]
;