I_CntrlPurContrItmCndnScales

DDL: I_CNTRLPURCONTRITMCNDNSCALES SQL: ICCTRICNDSCALES Type: view COMPOSITE
22 Fields 2 Data Sources 2 Associations

CCTR Item Condition Scales Basic View

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

Data Sources (2)

SourceAliasJoin Type
I_CntrlPurContrItmCndnAmount CntrlPurContrItmCndnAmount inner
I_PurgPrcgCndnRecordScale PurgPrcgCndnRecordScale from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_CntrlPurContrItmCndnValdty _CntrlPurContrItmCndnValdty _CntrlPurContrItmCndnValdty.ConditionRecord = $projection.ConditionRecord and _CntrlPurContrItmCndnValdty.ConditionValidityEndDate = $projection.ConditionValidityEndDate
[1..1] I_CentralPurchaseContract _CentralPurchaseContract _CentralPurchaseContract.CentralPurchaseContract = $projection.CentralPurchaseContract

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICCTRICNDSCALES view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label CCTR Item Condition Scales Basic View 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 (22)

KeyFieldSource TableSource FieldDescription
KEY CentralPurchaseContract I_CntrlPurContrItmCndnAmount CentralPurchaseContract Purchasing Doc.
KEY CentralPurchaseContractItem I_CntrlPurContrItmCndnAmount CentralPurchaseContractItem Item in Central Purchase Contract
KEY ConditionRecord I_PurgPrcgCndnRecordScale ConditionRecord Cond.Record No.
KEY ConditionValidityEndDate I_CntrlPurContrItmCndnAmount 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_CntrlPurContrItmCndnAmount PricingScaleType Scale Type
ConditionQuantity I_CntrlPurContrItmCndnAmount ConditionQuantity Pricing Unit
ConditionQuantityUnit I_CntrlPurContrItmCndnAmount ConditionQuantityUnit Unit of Measure
_CntrlPurContrItmCndnValdty _CntrlPurContrItmCndnValdty
_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_CntrlPurContrItmCndnScales.
-- 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: ICCTRICNDSCALES

CREATE VIEW I_CntrlPurContrItmCndnScales AS
SELECT
  CntrlPurContrItmCndnAmount.CentralPurchaseContract AS CentralPurchaseContract,
  CntrlPurContrItmCndnAmount.CentralPurchaseContractItem AS CentralPurchaseContractItem,
  PurgPrcgCndnRecordScale.ConditionRecord AS ConditionRecord,
  CntrlPurContrItmCndnAmount.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,
  CntrlPurContrItmCndnAmount.PricingScaleType AS PricingScaleType,
  CntrlPurContrItmCndnAmount.ConditionQuantity AS ConditionQuantity,
  CntrlPurContrItmCndnAmount.ConditionQuantityUnit AS ConditionQuantityUnit
FROM I_PurgPrcgCndnRecordScale AS PurgPrcgCndnRecordScale
INNER JOIN I_CntrlPurContrItmCndnAmount AS CntrlPurContrItmCndnAmount ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CntrlPurContrItmCndnValdty AS _CntrlPurContrItmCndnValdty ON _CntrlPurContrItmCndnValdty.ConditionRecord = ConditionRecord AND _CntrlPurContrItmCndnValdty.ConditionValidityEndDate = ConditionValidityEndDate  -- association [1..1]
LEFT OUTER JOIN I_CentralPurchaseContract AS _CentralPurchaseContract ON _CentralPurchaseContract.CentralPurchaseContract = CentralPurchaseContract  -- association [1..1]
;

Learn More