A_SlsPricingConditionType

DDL: A_SLSPRICINGCONDITIONTYPE SQL: ASLSCNDNTYPE Type: view BASIC
39 Fields 1 Data Sources 1 Associations

Condition Types

A_SlsPricingConditionType is a Basic CDS View that provides data about "Condition Types" in SAP S/4HANA. It reads from 1 data source (I_PricingConditionType) and exposes 39 fields with key fields ConditionUsage, ConditionApplication, ConditionType. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PricingConditionType I_PricingConditionType from

Associations (1)

CardinalityTargetAliasCondition
[0..*] A_SlsPrcgCndnTypeText _Text $projection.ConditionType = _Text.ConditionType and $projection.ConditionApplication = _Text.ConditionApplication and $projection.ConditionUsage = _Text.ConditionUsage

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ASLSCNDNTYPE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Condition Types view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY ConditionUsage ConditionUsage Usage
KEY ConditionApplication ConditionApplication Application
KEY ConditionType ConditionType Condition type
AccessSequence AccessSequence Access Sequence
ConditionClass ConditionClass Condition Class
ConditionCalculationType ConditionCalculationType Calculat.Type
ConditionCategory ConditionCategory Condit.Category
PrcgCndnAmountRoundingRule PrcgCndnAmountRoundingRule Rounding Rule
PricingConditionFunction PricingConditionFunction ConditionFunctn
StructureCondition StructureCondition Structure Cond.
PrcgConditionAmountSign PrcgConditionAmountSign Plus/Minus
IsGroupCondition IsGroupCondition Group Condition
PrcgCndnRndngDiffsIsSettled PrcgCndnRndngDiffsIsSettled RoundDiffAdj.
PrcgGroupConditionRoutine PrcgGroupConditionRoutine GrpCond.Routine
CndnManualEntries CndnManualEntries Manual Entries
CndnAppliesHeader CndnAppliesHeader Header Condit.
CndnAppliesItems CndnAppliesItems Item Condition
PrcgCndnTypeDeletionIsAllowed PrcgCndnTypeDeletionIsAllowed Delete
PrcgCndnAmountChangedIsAllowed PrcgCndnAmountChangedIsAllowed Amount/Percent
PrcgCndnCnvrsnFctrChgIsAllowed PrcgCndnCnvrsnFctrChgIsAllowed Qty. Relation
PrcgCndnValChgIsAllwd PrcgCndnValChgIsAllwd Value
PrcgCndnPrpsdValidFromDateCode PrcgCndnPrpsdValidFromDateCode Prop.Valid From
PrcgCndnPrpsdValidToDateCode PrcgCndnPrpsdValidToDateCode Prop.Deliv.Date
PricingProcedure PricingProcedure Procedure
PrcgConditionDeletionMethod PrcgConditionDeletionMethod Delete from DB
CndnIsRelevantForLimitValue CndnIsRelevantForLimitValue Condit. Update
PricingScaleBasisShort PricingScaleBasisShort Scale Base Type
PricingScaleCheckingRule PricingScaleCheckingRule Check Scale
PricingScaleType PricingScaleType Scale Type
PricingScaleRoutine PricingScaleRoutine Scale Routine
PricingScaleUnit PricingScaleUnit Unit of Measure
PrcgCndnCrcyCnvrsnIsAftMltpl PrcgCndnCrcyCnvrsnIsAftMltpl Currency Conv.
IsRelevantForAccrual IsRelevantForAccrual Accruals
CndnIsForVariantConfiguration CndnIsForVariantConfiguration UsedfVarConfig
PrcgCndnQtyCnvrsnIsActivated PrcgCndnQtyCnvrsnIsActivated Qty Conversion
CndnIsRelevantForIntcoBilling CndnIsRelevantForIntcoBilling IntcoBillCond
PricingDateIdentificationCode PricingDateIdentificationCode Pricing Date
CndnValueZeroProcgCode CndnValueZeroProcgCode Zero Value Proc.
_Text _Text

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 A_SlsPricingConditionType.
-- 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: ASLSCNDNTYPE

CREATE VIEW A_SlsPricingConditionType AS
SELECT
  ConditionUsage,
  ConditionApplication,
  ConditionType,
  AccessSequence,
  ConditionClass,
  ConditionCalculationType,
  ConditionCategory,
  PrcgCndnAmountRoundingRule,
  PricingConditionFunction,
  StructureCondition,
  PrcgConditionAmountSign,
  IsGroupCondition,
  PrcgCndnRndngDiffsIsSettled,
  PrcgGroupConditionRoutine,
  CndnManualEntries,
  CndnAppliesHeader,
  CndnAppliesItems,
  PrcgCndnTypeDeletionIsAllowed,
  PrcgCndnAmountChangedIsAllowed,
  PrcgCndnCnvrsnFctrChgIsAllowed,
  PrcgCndnValChgIsAllwd,
  PrcgCndnPrpsdValidFromDateCode,
  PrcgCndnPrpsdValidToDateCode,
  PricingProcedure,
  PrcgConditionDeletionMethod,
  CndnIsRelevantForLimitValue,
  PricingScaleBasisShort,
  PricingScaleCheckingRule,
  PricingScaleType,
  PricingScaleRoutine,
  PricingScaleUnit,
  PrcgCndnCrcyCnvrsnIsAftMltpl,
  IsRelevantForAccrual,
  CndnIsForVariantConfiguration,
  PrcgCndnQtyCnvrsnIsActivated,
  CndnIsRelevantForIntcoBilling,
  PricingDateIdentificationCode,
  CndnValueZeroProcgCode
FROM I_PricingConditionType
LEFT OUTER JOIN A_SlsPrcgCndnTypeText AS _Text ON ConditionType = _Text.ConditionType AND ConditionApplication = _Text.ConditionApplication AND ConditionUsage = _Text.ConditionUsage  -- association [0..*]
;

Learn More