I_PricingConditionType

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_PricingConditionType.
-- 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: IPRCGCNDNTYPE

CREATE VIEW I_PricingConditionType AS
SELECT
  _t685.kappl AS ConditionApplication,
  _t685.kschl AS ConditionType,
  _t685.kvewe AS ConditionUsage,
  _t685.kozgf AS AccessSequence,
  _t685a.koaid AS ConditionClass,
  cast(_t685a.krech as krech_long) AS ConditionCalculationType,
  _t685a.kntyp AS ConditionCategory,
  _t685a.txprf AS PrcgCndnAmountRoundingRule,
  _t685a.purp AS PricingConditionFunction,
  _t685a.kdupl AS StructureCondition,
  _t685a.knega AS PrcgConditionAmountSign,
  _t685a.kgrpe AS IsGroupCondition,
  _t685a.rdifa AS PrcgCndnRndngDiffsIsSettled,
  _t685a.grlnr AS PrcgGroupConditionRoutine,
  _t685a.kmanu AS CndnManualEntries,
  _t685a.kkopf AS CndnAppliesHeader,
  _t685a.kposi AS CndnAppliesItems,
  _t685a.kaend_loe AS PrcgCndnTypeDeletionIsAllowed,
  _t685a.kaend_btr AS PrcgCndnAmountChangedIsAllowed,
  _t685a.kaend_ufk AS PrcgCndnCnvrsnFctrChgIsAllowed,
  _t685a.kaend_wrt AS PrcgCndnValChgIsAllwd,
  _t685.dtvob AS PrcgCndnPrpsdValidFromDateCode,
  _t685.datvo AS PrcgCndnPrpsdValidToDateCode,
  _t685a.kalsm AS PricingProcedure,
  _t685a.kdele AS PrcgConditionDeletionMethod,
  _t685a.koupd AS CndnIsRelevantForLimitValue,
  _t685a.kzbzg AS PricingScaleBasisShort,
  _t685a.kstpr AS PricingScaleCheckingRule,
  _t685a.stfkz AS PricingScaleType,
  _t685a.kofrs AS PricingScaleRoutine,
  _t685a.grmen AS PricingScaleUnit,
  _t685a.ganzz AS PrcgCndnCrcyCnvrsnIsAftMltpl,
  _t685a.kruek AS IsRelevantForAccrual,
  _t685a.kvarc AS CndnIsForVariantConfiguration,
  _t685a.kmeng AS PrcgCndnQtyCnvrsnIsActivated,
  _t685a.kfkiv AS CndnIsRelevantForIntcoBilling,
  _t685a.kznep AS ConditionExclusion,
  _t685a.kprdt AS PricingDateIdentificationCode,
  _t685a.val_zero AS CndnValueZeroProcgCode,
  _t685a.vkkal AS IsRelevantForSalesPriceCalc,
  _t685a.isinclusionpoint AS ConditionTypeIsInclusionPoint,
  _t685a.pricingsubproceduremaxstep AS PricingSubprocedureMaxStep
FROM t685 AS _t685
INNER JOIN t685a AS _t685a ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ConditionApplication AS _ConditionApplication ON ConditionApplication = _ConditionApplication.ConditionApplication  -- association [0..1]
LEFT OUTER JOIN I_ConditionTypeText AS _Text ON ConditionType = _Text.ConditionType AND ConditionApplication = _Text.ConditionApplication AND _Text.ConditionUsage = 'A'  -- association [0..*]
LEFT OUTER JOIN I_PricingConditionTypeText AS _Text_2 ON ConditionType = _Text_2.ConditionType AND ConditionApplication = _Text_2.ConditionApplication  -- association [0..*]
;