What is I_SlsPrcgConditionRecord in SAP S/4HANA?

I_SlsPrcgConditionRecord is a basic CDS view in SAP S/4HANA. Condition Record for Pricing in Sales It contains 67 fields.

Which tables does I_SlsPrcgConditionRecord read from?

I_SlsPrcgConditionRecord reads data from: P_SlsPrcgConditionRecord.

What VDM layer is I_SlsPrcgConditionRecord?

I_SlsPrcgConditionRecord is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_SlsPrcgConditionRecord

DDL: I_SLSPRCGCONDITIONRECORD Type: view BASIC

67 Fields 1 Data Sources 9 Associations

Condition Record for Pricing in Sales

I_SlsPrcgConditionRecord (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Sales

I_SlsPrcgConditionRecord is a Basic CDS View that provides data about "Condition Record for Pricing in Sales" in SAP S/4HANA. It reads from 1 data source (P_SlsPrcgConditionRecord) and exposes 67 fields with key field ConditionRecord. It has 9 associations to related views.

SAP API Hub

State	C1
Line of Business	Sales
Application Component	SD-MD-CM
Capabilities	Data Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities
Package	Sales for SAP S/4HANA Cloud Private Edition

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
P_SlsPrcgConditionRecord	Record	from

Associations (9)

Cardinality	Target	Alias	Condition
[0..*]	I_SlsPrcgCndnRecdValidity	_SlsPrcgCndnRecdValidity	`$projection.ConditionRecord = _SlsPrcgCndnRecdValidity.ConditionRecord`
[0..*]	I_SlsPrcgCndnRecdSuplmnt	_SlsPrcgCndnRecdSuplmnt	`$projection.ConditionRecord = _SlsPrcgCndnRecdSuplmnt.ConditionRecord`
[0..*]	I_SlsPrcgCndnRecordScale	_SlsPricingCndnRecdScale	`$projection.ConditionRecord = _SlsPricingCndnRecdScale.ConditionRecord and $projection.ConditionSequentialNumber = _SlsPricingCndnRecdScale.ConditionSequentialNumber`
[0..*]	I_SlsPrcgConditionRecordText	_SlsPrcgConditionRecordText	`$projection.ConditionRecord = _SlsPrcgConditionRecordText.ConditionRecord`
[0..1]	I_Currency	_AlternativeCurrency	`$projection.ConditionAlternativeCurrency = _AlternativeCurrency.Currency`
[0..1]	I_Currency	_RateValueUnit	`$projection.ConditionRateValueUnit = _RateValueUnit.Currency`
[0..1]	I_Currency	_ScaleAmountCurrency	`$projection.ConditionScaleAmountCurrency = _ScaleAmountCurrency.Currency`
[0..1]	I_UnitOfMeasure	_QuantityUnit	`$projection.ConditionQuantityUnit = _QuantityUnit.UnitOfMeasure`
[0..1]	I_UnitOfMeasure	_ScaleQuantityUnit	`$projection.ConditionScaleQuantityUnit = _ScaleQuantityUnit.UnitOfMeasure`

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	ISLSPRCGCNDNRECD	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#REQUIRED	view
VDM.viewType	#BASIC	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.dataClass	#MASTER	view
Metadata.ignorePropagatedAnnotations	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Condition Record for Pricing in Sales	view

Fields (67)

Key	Field	Source Table	Source Field	Description
KEY	ConditionRecord	P_SlsPrcgConditionRecord	ConditionRecord	Number of Condition Record
	ConditionSequentialNumber	P_SlsPrcgConditionRecord	ConditionSequentialNumber	Sequential number of the condition
	ConditionTable	P_SlsPrcgConditionRecord	ConditionTable	Condition Table
	ConditionApplication	P_SlsPrcgConditionRecord	ConditionApplication	Application
	ConditionType	P_SlsPrcgConditionRecord	ConditionType	Condition type
	ConditionValidityEndDate	P_SlsPrcgConditionRecord	ConditionValidityEndDate	Valid To Date
	ConditionValidityStartDate	P_SlsPrcgConditionRecord	ConditionValidityStartDate	Valid-From Date
	CreatedByUser	P_SlsPrcgConditionRecord	CreatedByUser	Name of Person Responsible for Creating the Object
	CreationDate	P_SlsPrcgConditionRecord	CreationDate	Record Created On
	ConditionTextID	P_SlsPrcgConditionRecord	ConditionTextID	Number of texts
	PricingScaleType	P_SlsPrcgConditionRecord	PricingScaleType	Scale Type
	PricingScaleBasis	P_SlsPrcgConditionRecord	PricingScaleBasis	Scale Base Type
	ConditionScaleQuantity	P_SlsPrcgConditionRecord	ConditionScaleQuantity	Condition Scale Quantity
	ConditionScaleQuantityUnit	P_SlsPrcgConditionRecord	ConditionScaleQuantityUnit	Condition Scale Unit of Measure
	ConditionScaleAmount	P_SlsPrcgConditionRecord	ConditionScaleAmount	Scale Value
	ConditionScaleAmountCurrency	P_SlsPrcgConditionRecord	ConditionScaleAmountCurrency	Scale Currency
	ConditionCalculationType	P_SlsPrcgConditionRecord	ConditionCalculationType	Calculation Type for Condition
	ConditionRateValue	P_SlsPrcgConditionRecord	ConditionRateValue	Condition amount or percentage where no scale exists
	ConditionRateValueUnit	P_SlsPrcgConditionRecord	ConditionRateValueUnit	Condition Unit (Currency or Percentage)
	ConditionRateRatio	P_SlsPrcgConditionRecord	ConditionRateRatio	Condition Ratio (in Percent or Per Mille)
	ConditionRateRatioUnit	P_SlsPrcgConditionRecord	ConditionRateRatioUnit	Unit of Measure
	ConditionRateAmount	P_SlsPrcgConditionRecord	ConditionRateAmount	Condition Amount or Percentage
	ConditionCurrency	P_SlsPrcgConditionRecord	ConditionCurrency	Condition Unit (Currency or Percentage)
	ConditionQuantity	P_SlsPrcgConditionRecord	ConditionQuantity	Condition Pricing Unit
	ConditionQuantityUnit	P_SlsPrcgConditionRecord	ConditionQuantityUnit	Unit of Measure
	ConditionToBaseQtyNmrtr	P_SlsPrcgConditionRecord	ConditionToBaseQtyNmrtr	Numerator for converting condition units to base units
	ConditionToBaseQtyDnmntr	P_SlsPrcgConditionRecord	ConditionToBaseQtyDnmntr	Denominator for converting condition units to base units
	BaseUnit	P_SlsPrcgConditionRecord	BaseUnit	Base Unit of Measure
	ConditionLowerLimit	P_SlsPrcgConditionRecord	ConditionLowerLimit	Lower limit of the condition rate/amount
	ConditionLowerLimitAmount	P_SlsPrcgConditionRecord	ConditionLowerLimitAmount	Condition Amount or Percentage
	ConditionLowerLimitRatio	P_SlsPrcgConditionRecord	ConditionLowerLimitRatio	Condition Ratio (in Percent or Per Mille)
	ConditionUpperLimit	P_SlsPrcgConditionRecord	ConditionUpperLimit	Upper limit for the condition rate
	ConditionUpperLimitAmount	P_SlsPrcgConditionRecord	ConditionUpperLimitAmount	Condition Amount or Percentage
	ConditionUpperLimitRatio	P_SlsPrcgConditionRecord	ConditionUpperLimitRatio	Condition Ratio (in Percent or Per Mille)
	ConditionAlternativeCurrency	P_SlsPrcgConditionRecord	ConditionAlternativeCurrency	Condition Currency (for Cumulation Fields)
	ConditionExclusion	P_SlsPrcgConditionRecord	ConditionExclusion	Condition exclusion indicator
	ConditionIsDeleted	P_SlsPrcgConditionRecord	ConditionIsDeleted	Deletion Indicator for Condition Record
	AdditionalValueDays	P_SlsPrcgConditionRecord	AdditionalValueDays	Additional Value Days
	FixedValueDate	P_SlsPrcgConditionRecord	FixedValueDate	Fixed Value Date
	PaymentTerms	P_SlsPrcgConditionRecord	PaymentTerms	Terms of Payment Key
	CndnMaxNumberOfSalesOrders	P_SlsPrcgConditionRecord	CndnMaxNumberOfSalesOrders	Maximum number of sales orders per condition record
	MinimumConditionBasisValue	P_SlsPrcgConditionRecord	MinimumConditionBasisValue	Minimum condition base value
	MaximumConditionBasisValue	P_SlsPrcgConditionRecord	MaximumConditionBasisValue	Maximum condition base value
	MaximumConditionAmount	P_SlsPrcgConditionRecord	MaximumConditionAmount	Maximum condition value
	IncrementalScale	P_SlsPrcgConditionRecord	IncrementalScale	Number of incremental scale
	PricingScaleLine	P_SlsPrcgConditionRecord	PricingScaleLine	Scale number for pricing
	ConditionReleaseStatus	P_SlsPrcgConditionRecord	ConditionReleaseStatus	Release Status
	SalesPriceApprovalRequest	P_SlsPrcgConditionRecord	SalesPriceApprovalRequest	Approval Request for Price Conditions
	ConditionChangeReason	P_SlsPrcgConditionRecord	ConditionChangeReason	Reason for Changing Condition Record
	PrevApprovedConditionRecord	P_SlsPrcgConditionRecord	PrevApprovedConditionRecord	Previously Approved Condition Record
	ConditionTaxCode	P_SlsPrcgConditionRecord	ConditionTaxCode	Tax on sales/purchases code
	ConditionWithholdingTaxCode	P_SlsPrcgConditionRecord	ConditionWithholdingTaxCode	Withholding Tax Code
	TaxExemptionLicense	P_SlsPrcgConditionRecord	TaxExemptionLicense	Tax Exemption License Number
	LicenseGrantDate	P_SlsPrcgConditionRecord	LicenseGrantDate	Date License Granted
	LastChangeDateTime	P_SlsPrcgConditionRecord	LastChangeDateTime	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
	ConditionSearchTermValue	P_SlsPrcgConditionRecord	ConditionSearchTermValue	Search Term 1 for Conditions
	ConditionResponsibility	P_SlsPrcgConditionRecord	ConditionResponsibility	Search Term 2 for Conditions
	SAPObjectNodeType		SAPObjectNodeType	RAP SOT: SAP Object Node Type
	_SlsPrcgCndnRecdValidity		_SlsPrcgCndnRecdValidity
	_SlsPrcgCndnRecdSuplmnt		_SlsPrcgCndnRecdSuplmnt
	_SlsPricingCndnRecdScale		_SlsPricingCndnRecdScale
	_SlsPrcgConditionRecordText		_SlsPrcgConditionRecordText
	_AlternativeCurrency		_AlternativeCurrency
	_RateValueUnit		_RateValueUnit
	_ScaleAmountCurrency		_ScaleAmountCurrency
	_QuantityUnit		_QuantityUnit
	_ScaleQuantityUnit		_ScaleQuantityUnit

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_SlsPrcgConditionRecord.
-- 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 I_SlsPrcgConditionRecord AS
SELECT
  Record.ConditionRecord AS ConditionRecord,
  Record.ConditionSequentialNumber AS ConditionSequentialNumber,
  Record.ConditionTable AS ConditionTable,
  Record.ConditionApplication AS ConditionApplication,
  Record.ConditionType AS ConditionType,
  Record.ConditionValidityEndDate AS ConditionValidityEndDate,
  Record.ConditionValidityStartDate AS ConditionValidityStartDate,
  Record.CreatedByUser AS CreatedByUser,
  Record.CreationDate AS CreationDate,
  Record.ConditionTextID AS ConditionTextID,
  Record.PricingScaleType AS PricingScaleType,
  Record.PricingScaleBasis AS PricingScaleBasis,
  Record.ConditionScaleQuantity AS ConditionScaleQuantity,
  Record.ConditionScaleQuantityUnit AS ConditionScaleQuantityUnit,
  Record.ConditionScaleAmount AS ConditionScaleAmount,
  Record.ConditionScaleAmountCurrency AS ConditionScaleAmountCurrency,
  Record.ConditionCalculationType AS ConditionCalculationType,
  Record.ConditionRateValue AS ConditionRateValue,
  Record.ConditionRateValueUnit AS ConditionRateValueUnit,
  Record.ConditionRateRatio AS ConditionRateRatio,
  Record.ConditionRateRatioUnit AS ConditionRateRatioUnit,
  Record.ConditionRateAmount AS ConditionRateAmount,
  Record.ConditionCurrency AS ConditionCurrency,
  Record.ConditionQuantity AS ConditionQuantity,
  Record.ConditionQuantityUnit AS ConditionQuantityUnit,
  Record.ConditionToBaseQtyNmrtr AS ConditionToBaseQtyNmrtr,
  Record.ConditionToBaseQtyDnmntr AS ConditionToBaseQtyDnmntr,
  Record.BaseUnit AS BaseUnit,
  Record.ConditionLowerLimit AS ConditionLowerLimit,
  Record.ConditionLowerLimitAmount AS ConditionLowerLimitAmount,
  Record.ConditionLowerLimitRatio AS ConditionLowerLimitRatio,
  Record.ConditionUpperLimit AS ConditionUpperLimit,
  Record.ConditionUpperLimitAmount AS ConditionUpperLimitAmount,
  Record.ConditionUpperLimitRatio AS ConditionUpperLimitRatio,
  Record.ConditionAlternativeCurrency AS ConditionAlternativeCurrency,
  Record.ConditionExclusion AS ConditionExclusion,
  Record.ConditionIsDeleted AS ConditionIsDeleted,
  Record.AdditionalValueDays AS AdditionalValueDays,
  Record.FixedValueDate AS FixedValueDate,
  Record.PaymentTerms AS PaymentTerms,
  Record.CndnMaxNumberOfSalesOrders AS CndnMaxNumberOfSalesOrders,
  Record.MinimumConditionBasisValue AS MinimumConditionBasisValue,
  Record.MaximumConditionBasisValue AS MaximumConditionBasisValue,
  Record.MaximumConditionAmount AS MaximumConditionAmount,
  Record.IncrementalScale AS IncrementalScale,
  Record.PricingScaleLine AS PricingScaleLine,
  Record.ConditionReleaseStatus AS ConditionReleaseStatus,
  Record.SalesPriceApprovalRequest AS SalesPriceApprovalRequest,
  Record.ConditionChangeReason AS ConditionChangeReason,
  Record.PrevApprovedConditionRecord AS PrevApprovedConditionRecord,
  Record.ConditionTaxCode AS ConditionTaxCode,
  Record.ConditionWithholdingTaxCode AS ConditionWithholdingTaxCode,
  Record.TaxExemptionLicense AS TaxExemptionLicense,
  Record.LicenseGrantDate AS LicenseGrantDate,
  Record.LastChangeDateTime AS LastChangeDateTime,
  Record.ConditionSearchTermValue AS ConditionSearchTermValue,
  Record.ConditionResponsibility AS ConditionResponsibility,
  SAPObjectNodeType
FROM P_SlsPrcgConditionRecord AS Record
LEFT OUTER JOIN I_SlsPrcgCndnRecdValidity AS _SlsPrcgCndnRecdValidity ON ConditionRecord = _SlsPrcgCndnRecdValidity.ConditionRecord  -- association [0..*]
LEFT OUTER JOIN I_SlsPrcgCndnRecdSuplmnt AS _SlsPrcgCndnRecdSuplmnt ON ConditionRecord = _SlsPrcgCndnRecdSuplmnt.ConditionRecord  -- association [0..*]
LEFT OUTER JOIN I_SlsPrcgCndnRecordScale AS _SlsPricingCndnRecdScale ON ConditionRecord = _SlsPricingCndnRecdScale.ConditionRecord AND ConditionSequentialNumber = _SlsPricingCndnRecdScale.ConditionSequentialNumber  -- association [0..*]
LEFT OUTER JOIN I_SlsPrcgConditionRecordText AS _SlsPrcgConditionRecordText ON ConditionRecord = _SlsPrcgConditionRecordText.ConditionRecord  -- association [0..*]
LEFT OUTER JOIN I_Currency AS _AlternativeCurrency ON ConditionAlternativeCurrency = _AlternativeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _RateValueUnit ON ConditionRateValueUnit = _RateValueUnit.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ScaleAmountCurrency ON ConditionScaleAmountCurrency = _ScaleAmountCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _QuantityUnit ON ConditionQuantityUnit = _QuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ScaleQuantityUnit ON ConditionScaleQuantityUnit = _ScaleQuantityUnit.UnitOfMeasure  -- association [0..1]
;

Depth:

I_SlsPrcgConditionRecord view

P_SlsPrcgConditionRecord view