I_PurContrHdrCndnScale

DDL: I_PURCONTRHDRCNDNSCALE SQL: IPCTRHCNDSCALE Type: view COMPOSITE
24 Fields 2 Data Sources 2 Associations

Header Condition Scales Basic Data

I_PurContrHdrCndnScale is a Composite CDS View that provides data about "Header Condition Scales Basic Data" in SAP S/4HANA. It reads from 2 data sources (I_PurContrHdrCndnAmount, I_PurgPrcgCndnRecordScale) and exposes 24 fields with key fields PurchaseContract, ConditionRecord, ConditionValidityEndDate, ConditionSequentialNumber, ConditionScaleLine. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_PurContrHdrCndnAmount PurContrHdrCndnAmount inner
I_PurgPrcgCndnRecordScale PurgPrcgCndnRecordScale from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_PurContrHdrCndnAmount _PurContrHdrCndnAmount _PurContrHdrCndnAmount.PurchaseContract = $projection.PurchaseContract and _PurContrHdrCndnAmount.ConditionRecord = $projection.ConditionRecord and _PurContrHdrCndnAmount.ConditionSequentialNumber = $projection.ConditionSequentialNumber and _PurContrHdrCndnAmount.ConditionValidityEndDate = $projection.ConditionValidityEndDate
[1..1] I_PurchaseContract _PurchaseContract _PurchaseContract.PurchaseContract = $projection.PurchaseContract

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPCTRHCNDSCALE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Header Condition Scales Basic Data view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract I_PurContrHdrCndnAmount PurchaseContract Purchasing Doc.
KEY ConditionRecord I_PurgPrcgCndnRecordScale ConditionRecord Cond.Record No.
KEY ConditionValidityEndDate I_PurContrHdrCndnAmount ConditionValidityEndDate Valid To
KEY ConditionSequentialNumber I_PurgPrcgCndnRecordScale ConditionSequentialNumber SequNo of Cond.
KEY ConditionScaleLine I_PurgPrcgCndnRecordScale ConditionScaleLine Line number
ConditionScaleQuantity I_PurgPrcgCndnRecordScale ConditionScaleQuantity Scale Quantity
ConditionScaleQuantityUnit I_PurgPrcgCndnRecordScale ConditionScaleQuantityUnit Scale UoM
PurContrCndnScQtyUnitISOCode
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
ConditionRateRatio I_PurgPrcgCndnRecordScale ConditionRateRatio Ratio
ConditionRateRatioUnit I_PurgPrcgCndnRecordScale ConditionRateRatioUnit Unit of Measure
PurContrCndnRateRatioUntISOCd
ConditionRateAmount I_PurgPrcgCndnRecordScale ConditionRateAmount Condition Amount
ConditionCurrency I_PurgPrcgCndnRecordScale ConditionCurrency Currency
ConditionScaleIsDeleted
PricingScaleType I_PurContrHdrCndnAmount PricingScaleType Scale Type
ConditionQuantity I_PurContrHdrCndnAmount ConditionQuantity Pricing Unit
ConditionQuantityUnit I_PurContrHdrCndnAmount ConditionQuantityUnit Unit of Measure
PurContrCndnQtyUnitISOCode I_PurContrHdrCndnAmount PurContrCndnQtyUnitISOCode
_PurContrHdrCndnAmount _PurContrHdrCndnAmount
_PurchaseContract _PurchaseContract

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_PurContrHdrCndnScale.
-- 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: IPCTRHCNDSCALE

CREATE VIEW I_PurContrHdrCndnScale AS
SELECT
  PurContrHdrCndnAmount.PurchaseContract AS PurchaseContract,
  PurgPrcgCndnRecordScale.ConditionRecord AS ConditionRecord,
  PurContrHdrCndnAmount.ConditionValidityEndDate AS ConditionValidityEndDate,
  PurgPrcgCndnRecordScale.ConditionSequentialNumber AS ConditionSequentialNumber,
  PurgPrcgCndnRecordScale.ConditionScaleLine AS ConditionScaleLine,
  PurgPrcgCndnRecordScale.ConditionScaleQuantity AS ConditionScaleQuantity,
  PurgPrcgCndnRecordScale.ConditionScaleQuantityUnit AS ConditionScaleQuantityUnit,
  cast( '' as abap.unit ) AS PurContrCndnScQtyUnitISOCode,
  PurgPrcgCndnRecordScale.ConditionScaleAmount AS ConditionScaleAmount,
  PurgPrcgCndnRecordScale.ConditionScaleAmountCurrency AS ConditionScaleAmountCurrency,
  PurgPrcgCndnRecordScale.ConditionRateValue AS ConditionRateValue,
  PurgPrcgCndnRecordScale.ConditionRateValueUnit AS ConditionRateValueUnit,
  PurgPrcgCndnRecordScale.ConditionRateRatio AS ConditionRateRatio,
  PurgPrcgCndnRecordScale.ConditionRateRatioUnit AS ConditionRateRatioUnit,
  cast( '' as konwa ) AS PurContrCndnRateRatioUntISOCd,
  PurgPrcgCndnRecordScale.ConditionRateAmount AS ConditionRateAmount,
  PurgPrcgCndnRecordScale.ConditionCurrency AS ConditionCurrency,
  cast( '' as loevm_ko ) AS ConditionScaleIsDeleted,
  PurContrHdrCndnAmount.PricingScaleType AS PricingScaleType,
  PurContrHdrCndnAmount.ConditionQuantity AS ConditionQuantity,
  PurContrHdrCndnAmount.ConditionQuantityUnit AS ConditionQuantityUnit,
  PurContrHdrCndnAmount.PurContrCndnQtyUnitISOCode AS PurContrCndnQtyUnitISOCode
FROM I_PurgPrcgCndnRecordScale AS PurgPrcgCndnRecordScale
INNER JOIN I_PurContrHdrCndnAmount AS PurContrHdrCndnAmount ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurContrHdrCndnAmount AS _PurContrHdrCndnAmount ON _PurContrHdrCndnAmount.PurchaseContract = PurchaseContract AND _PurContrHdrCndnAmount.ConditionRecord = ConditionRecord AND _PurContrHdrCndnAmount.ConditionSequentialNumber = ConditionSequentialNumber AND _PurContrHdrCndnAmount.ConditionValidityEndDate = ConditionValidityEndDate  -- association [1..1]
LEFT OUTER JOIN I_PurchaseContract AS _PurchaseContract ON _PurchaseContract.PurchaseContract = PurchaseContract  -- association [1..1]
;

Learn More