I_SlsPricingProcedureCndnItem

DDL: I_SLSPRICINGPROCEDURECNDNITEM SQL: ISLSPRCGPRCDCITM Type: view BASIC Package: VDM_SD_BF_PR
23 Fields 1 Data Sources 6 Associations

Condition Item in Sales Pricing Procedure

I_SlsPricingProcedureCndnItem is a Basic CDS View that provides data about "Condition Item in Sales Pricing Procedure" in SAP S/4HANA. It reads from 1 data source (P_PricingProcedureItem) and exposes 23 fields with key fields PricingProcedure, PricingProcedureStep, ConditionType. It has 6 associations to related views. Part of development package VDM_SD_BF_PR.

Data Sources (1)

SourceAliasJoin Type
P_PricingProcedureItem P_PricingProcedureItem from

Associations (6)

CardinalityTargetAliasCondition
[1..1] I_ConditionUsage _ConditionUsage $projection.ConditionUsage = _ConditionUsage.ConditionUsage
[1..1] I_ConditionApplication _ConditionApplication $projection.ConditionApplication = _ConditionApplication.ConditionApplication
[1..1] I_ConditionType _ConditionType $projection.ConditionUsage = _ConditionType.ConditionUsage and $projection.ConditionApplication = _ConditionType.ConditionApplication and $projection.ConditionType = _ConditionType.ConditionType
[0..1] I_PrcgProcedItemPrntType _PrcgProcedItemPrntType $projection.PricingProcedureItemPrintType = _PrcgProcedItemPrntType.PricingProcedureItemPrintType
[0..*] I_SlsPrcgProcedItemText _Text $projection.PricingProcedure = _Text.PricingProcedure and $projection.PricingProcedureStep = _Text.PricingProcedureStep and $projection.PricingProcedureCounter = _Text.PricingProcedureCounter
[1..1] I_SlsPricingProcedure _SalesPricingProcedure $projection.PricingProcedure = _SalesPricingProcedure.PricingProcedure

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISLSPRCGPRCDCITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Condition Item in Sales Pricing Procedure view
ObjectModel.usageType.serviceQuality B view
ObjectModel.usageType.sizeCategory M view
ObjectModel.usageType.dataClass CUSTOMIZING view
VDM.viewType #BASIC view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY PricingProcedure PricingProcedure Procedure
KEY PricingProcedureStep PricingProcedureStep Step Number
KEY ConditionType ConditionType Condition type
PricingProcedureCounter PricingProcedureCounter Pricing Procedure Counter
ConditionUsage ConditionUsage Usage
ConditionApplication ConditionApplication Application
PrcgProcedItemFromRefStep PrcgProcedItemFromRefStep From Step
PrcgProcedItemToRefStep PrcgProcedItemToRefStep To Step
ConditionIsManuallyDtmnd ConditionIsManuallyDtmnd Manual only
PrcgProcedItemSubtotal PrcgProcedItemSubtotal Subtotal
ConditionIsForStatistics ConditionIsForStatistics Statistical
AccountKeyForGLAccount AccountKeyForGLAccount Account Key
AcctKeyForAccrualsGLAccount AcctKeyForAccrualsGLAccount Accruals
PricingProcedureItemPrintType PricingProcedureItemPrintType Print Type
ConditionIsMandatory ConditionIsMandatory Required
CndnIsAcctDetnRelevant CndnIsAcctDetnRelevant Acct Detn Relevant
PriceElementAccessLevel PriceElementAccessLevel Access Level
_ConditionUsage _ConditionUsage
_ConditionApplication _ConditionApplication
_ConditionType _ConditionType
_PrcgProcedItemPrntType _PrcgProcedItemPrntType
_Text _Text
_SalesPricingProcedure _SalesPricingProcedure

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_SlsPricingProcedureCndnItem.
-- 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: ISLSPRCGPRCDCITM

CREATE VIEW I_SlsPricingProcedureCndnItem AS
SELECT
  PricingProcedure,
  PricingProcedureStep,
  ConditionType,
  PricingProcedureCounter,
  ConditionUsage,
  ConditionApplication,
  PrcgProcedItemFromRefStep,
  PrcgProcedItemToRefStep,
  ConditionIsManuallyDtmnd,
  PrcgProcedItemSubtotal,
  ConditionIsForStatistics,
  AccountKeyForGLAccount,
  AcctKeyForAccrualsGLAccount,
  PricingProcedureItemPrintType,
  ConditionIsMandatory,
  CndnIsAcctDetnRelevant,
  PriceElementAccessLevel
FROM P_PricingProcedureItem
LEFT OUTER JOIN I_ConditionUsage AS _ConditionUsage ON ConditionUsage = _ConditionUsage.ConditionUsage  -- association [1..1]
LEFT OUTER JOIN I_ConditionApplication AS _ConditionApplication ON ConditionApplication = _ConditionApplication.ConditionApplication  -- association [1..1]
LEFT OUTER JOIN I_ConditionType AS _ConditionType ON ConditionUsage = _ConditionType.ConditionUsage AND ConditionApplication = _ConditionType.ConditionApplication AND ConditionType = _ConditionType.ConditionType  -- association [1..1]
LEFT OUTER JOIN I_PrcgProcedItemPrntType AS _PrcgProcedItemPrntType ON PricingProcedureItemPrintType = _PrcgProcedItemPrntType.PricingProcedureItemPrintType  -- association [0..1]
LEFT OUTER JOIN I_SlsPrcgProcedItemText AS _Text ON PricingProcedure = _Text.PricingProcedure AND PricingProcedureStep = _Text.PricingProcedureStep AND PricingProcedureCounter = _Text.PricingProcedureCounter  -- association [0..*]
LEFT OUTER JOIN I_SlsPricingProcedure AS _SalesPricingProcedure ON PricingProcedure = _SalesPricingProcedure.PricingProcedure  -- association [1..1]
;

Learn More