P_PurgInfoRecdCndScalesMassUpd

DDL: P_PURGINFORECDCNDSCALESMASSUPD SQL: PPIRCONDSCALES Type: view COMPOSITE
27 Fields 1 Data Sources

P_PurgInfoRecdCndScalesMassUpd is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_PurgPrcgCndnRecordScale) and exposes 27 fields with key fields ConditionRecord, ConditionSequentialNumberShort, ConditionScaleLine.

Data Sources (1)

SourceAliasJoin Type
I_PurgPrcgCndnRecordScale I_PurgPrcgCndnRecordScale from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PPIRCONDSCALES view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY ConditionRecord I_PurgPrcgCndnRecordScale ConditionRecord Cond.Record No.
KEY ConditionSequentialNumberShort I_PurgPrcgCndnRecordScale ConditionSequentialNumber SequNo of Cond.
KEY ConditionScaleLine I_PurgPrcgCndnRecordScale ConditionScaleLine Line number
PurchasingInfoRecord _PurgPrcgCndnRecdValidity PurchasingInfoRecord Info Record
Supplier _PurgPrcgCndnRecdValidity Supplier Supplier
Material _PurgPrcgCndnRecdValidity Material Vehicle Model
Plant _PurgPrcgCndnRecdValidity Plant Valuation Area
PurchasingOrganization _PurgPrcgCndnRecdValidity PurchasingOrganization Purchasing Organization
PurchasingInfoRecordCategory _PurgPrcgCndnRecdValidity PurchasingInfoRecordCategory Infotype
ConditionTypeendasConditionType
ConditionValidityStartDate _PurgPrcgCndnRecdValidity ConditionValidityStartDate Valid From
ConditionValidityEndDate _PurgPrcgCndnRecdValidity ConditionValidityEndDate Valid To
PricingScaleBasisShort _ScaleDetail kzbzg Scale Basis
PricingScaleType _ScaleDetail stfkz Scale Type
ConditionScaleQuantity I_PurgPrcgCndnRecordScale ConditionScaleQuantity Scale Quantity
ConditionScaleQuantityUnit I_PurgPrcgCndnRecordScale ConditionScaleQuantityUnit Scale UoM
ConditionScaleAmount I_PurgPrcgCndnRecordScale ConditionScaleAmount Scale Value
ConditionScaleAmountCurrency I_PurgPrcgCndnRecordScale ConditionScaleAmountCurrency Scale Currency
ConditionRateValue I_PurgPrcgCndnRecordScale ConditionRateValue Condition Rate Value
ConditionRateValueUnit I_PurgPrcgCndnRecordScale ConditionRateValueUnit Unit of Condition Rate Value
ConditionRateRatioUnit I_PurgPrcgCndnRecordScale ConditionRateRatioUnit Unit of Measure
ConditionRateRatio I_PurgPrcgCndnRecordScale ConditionRateRatio Ratio
ConditionCurrency I_PurgPrcgCndnRecordScale ConditionCurrency Currency
ConditionRateAmount I_PurgPrcgCndnRecordScale ConditionRateAmount Condition Amount
ConditionScaleIsDeleted
_PurgPrcgConditionRecord I_PurgPrcgCndnRecordScale _PurgPrcgConditionRecord
_PurgPrcgCndnRecdSuplmnt I_PurgPrcgCndnRecordScale _PurgPrcgCndnRecdSuplmnt

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 P_PurgInfoRecdCndScalesMassUpd.
-- 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: PPIRCONDSCALES

CREATE VIEW P_PurgInfoRecdCndScalesMassUpd AS
SELECT
  I_PurgPrcgCndnRecordScale.ConditionRecord AS ConditionRecord,
  I_PurgPrcgCndnRecordScale.ConditionSequentialNumber AS ConditionSequentialNumberShort,
  I_PurgPrcgCndnRecordScale.ConditionScaleLine AS ConditionScaleLine,
  _PurgPrcgCndnRecdValidity.PurchasingInfoRecord AS PurchasingInfoRecord,
  _PurgPrcgCndnRecdValidity.Supplier AS Supplier,
  _PurgPrcgCndnRecdValidity.Material AS Material,
  _PurgPrcgCndnRecdValidity.Plant AS Plant,
  _PurgPrcgCndnRecdValidity.PurchasingOrganization AS PurchasingOrganization,
  _PurgPrcgCndnRecdValidity.PurchasingInfoRecordCategory AS PurchasingInfoRecordCategory,
  case when I_PurgPrcgCndnRecordScale._PurgPrcgConditionRecord.ConditionType is not null then I_PurgPrcgCndnRecordScale._PurgPrcgConditionRecord.ConditionType else I_PurgPrcgCndnRecordScale._PurgPrcgCndnRecdSuplmnt.ConditionType end as ConditionType AS ConditionTypeendasConditionType,
  _PurgPrcgCndnRecdValidity.ConditionValidityStartDate AS ConditionValidityStartDate,
  _PurgPrcgCndnRecdValidity.ConditionValidityEndDate AS ConditionValidityEndDate,
  _ScaleDetail.kzbzg AS PricingScaleBasisShort,
  _ScaleDetail.stfkz AS PricingScaleType,
  I_PurgPrcgCndnRecordScale.ConditionScaleQuantity AS ConditionScaleQuantity,
  I_PurgPrcgCndnRecordScale.ConditionScaleQuantityUnit AS ConditionScaleQuantityUnit,
  I_PurgPrcgCndnRecordScale.ConditionScaleAmount AS ConditionScaleAmount,
  I_PurgPrcgCndnRecordScale.ConditionScaleAmountCurrency AS ConditionScaleAmountCurrency,
  I_PurgPrcgCndnRecordScale.ConditionRateValue AS ConditionRateValue,
  I_PurgPrcgCndnRecordScale.ConditionRateValueUnit AS ConditionRateValueUnit,
  I_PurgPrcgCndnRecordScale.ConditionRateRatioUnit AS ConditionRateRatioUnit,
  I_PurgPrcgCndnRecordScale.ConditionRateRatio AS ConditionRateRatio,
  I_PurgPrcgCndnRecordScale.ConditionCurrency AS ConditionCurrency,
  I_PurgPrcgCndnRecordScale.ConditionRateAmount AS ConditionRateAmount,
  cast( '' as loevm_ko ) AS ConditionScaleIsDeleted,
  I_PurgPrcgCndnRecordScale._PurgPrcgConditionRecord AS _PurgPrcgConditionRecord,
  I_PurgPrcgCndnRecordScale._PurgPrcgCndnRecdSuplmnt AS _PurgPrcgCndnRecdSuplmnt
FROM I_PurgPrcgCndnRecordScale
;

Learn More