I_CntrlPurContrHdrCndnScales

DDL: I_CNTRLPURCONTRHDRCNDNSCALES SQL: ICCTRHCNDSCALES Type: view COMPOSITE
21 Fields 2 Data Sources 2 Associations

CCTR Hdr Condition Scales Basic Data

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

Data Sources (2)

SourceAliasJoin Type
I_CntrlPurContrHdrCndnAmount CntrlPurContrHdrCndnAmount inner
I_PurgPrcgCndnRecordScale PurgPrcgCndnRecordScale from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_CntrlPurContrHdrCndnAmount _CntrlPurContrHdrCndnAmount _CntrlPurContrHdrCndnAmount.CentralPurchaseContract = $projection.CentralPurchaseContract and _CntrlPurContrHdrCndnAmount.ConditionRecord = $projection.ConditionRecord and _CntrlPurContrHdrCndnAmount.ConditionSequentialNumber = $projection.ConditionSequentialNumber and _CntrlPurContrHdrCndnAmount.ConditionValidityEndDate = $projection.ConditionValidityEndDate
[1..1] I_CentralPurchaseContract _CentralPurchaseContract _CentralPurchaseContract.CentralPurchaseContract = $projection.CentralPurchaseContract

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICCTRHCNDSCALES view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label CCTR Hdr 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 (21)

KeyFieldSource TableSource FieldDescription
KEY CentralPurchaseContract I_CntrlPurContrHdrCndnAmount CentralPurchaseContract Purchasing Doc.
KEY ConditionRecord I_PurgPrcgCndnRecordScale ConditionRecord Cond.Record No.
KEY ConditionValidityEndDate I_CntrlPurContrHdrCndnAmount 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
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
ConditionRateAmount I_PurgPrcgCndnRecordScale ConditionRateAmount Condition Amount
ConditionCurrency I_PurgPrcgCndnRecordScale ConditionCurrency Currency
ConditionScaleIsDeleted
PricingScaleType I_CntrlPurContrHdrCndnAmount PricingScaleType Scale Type
ConditionQuantity I_CntrlPurContrHdrCndnAmount ConditionQuantity Pricing Unit
ConditionQuantityUnit I_CntrlPurContrHdrCndnAmount ConditionQuantityUnit Unit of Measure
_CntrlPurContrHdrCndnAmount _CntrlPurContrHdrCndnAmount
_CentralPurchaseContract _CentralPurchaseContract

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_CntrlPurContrHdrCndnScales.
-- 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: ICCTRHCNDSCALES

CREATE VIEW I_CntrlPurContrHdrCndnScales AS
SELECT
  CntrlPurContrHdrCndnAmount.CentralPurchaseContract AS CentralPurchaseContract,
  PurgPrcgCndnRecordScale.ConditionRecord AS ConditionRecord,
  CntrlPurContrHdrCndnAmount.ConditionValidityEndDate AS ConditionValidityEndDate,
  PurgPrcgCndnRecordScale.ConditionSequentialNumber AS ConditionSequentialNumber,
  PurgPrcgCndnRecordScale.ConditionScaleLine AS ConditionScaleLine,
  PurgPrcgCndnRecordScale.ConditionScaleQuantity AS ConditionScaleQuantity,
  PurgPrcgCndnRecordScale.ConditionScaleQuantityUnit AS ConditionScaleQuantityUnit,
  PurgPrcgCndnRecordScale.ConditionScaleAmount AS ConditionScaleAmount,
  PurgPrcgCndnRecordScale.ConditionScaleAmountCurrency AS ConditionScaleAmountCurrency,
  PurgPrcgCndnRecordScale.ConditionRateValue AS ConditionRateValue,
  PurgPrcgCndnRecordScale.ConditionRateValueUnit AS ConditionRateValueUnit,
  PurgPrcgCndnRecordScale.ConditionRateRatio AS ConditionRateRatio,
  PurgPrcgCndnRecordScale.ConditionRateRatioUnit AS ConditionRateRatioUnit,
  PurgPrcgCndnRecordScale.ConditionRateAmount AS ConditionRateAmount,
  PurgPrcgCndnRecordScale.ConditionCurrency AS ConditionCurrency,
  cast( '' as loevm_ko ) AS ConditionScaleIsDeleted,
  CntrlPurContrHdrCndnAmount.PricingScaleType AS PricingScaleType,
  CntrlPurContrHdrCndnAmount.ConditionQuantity AS ConditionQuantity,
  CntrlPurContrHdrCndnAmount.ConditionQuantityUnit AS ConditionQuantityUnit
FROM I_PurgPrcgCndnRecordScale AS PurgPrcgCndnRecordScale
INNER JOIN I_CntrlPurContrHdrCndnAmount AS CntrlPurContrHdrCndnAmount ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CntrlPurContrHdrCndnAmount AS _CntrlPurContrHdrCndnAmount ON _CntrlPurContrHdrCndnAmount.CentralPurchaseContract = CentralPurchaseContract AND _CntrlPurContrHdrCndnAmount.ConditionRecord = ConditionRecord AND _CntrlPurContrHdrCndnAmount.ConditionSequentialNumber = ConditionSequentialNumber AND _CntrlPurContrHdrCndnAmount.ConditionValidityEndDate = ConditionValidityEndDate  -- association [1..1]
LEFT OUTER JOIN I_CentralPurchaseContract AS _CentralPurchaseContract ON _CentralPurchaseContract.CentralPurchaseContract = CentralPurchaseContract  -- association [1..1]
;

Learn More