R_SrcgProjItmCndnScaleTP

DDL: R_SRCGPROJITMCNDNSCALETP Type: view_entity TRANSACTIONAL Package: RAP_MM_PUR_SRCGPROJ
16 Fields 1 Data Sources 4 Associations

Condition Scale for Srcg Proj Item - TP

R_SrcgProjItmCndnScaleTP is a Transactional CDS View that provides data about "Condition Scale for Srcg Proj Item - TP" in SAP S/4HANA. It reads from 1 data source (R_SrcgProjItmCndnScale) and exposes 16 fields with key field SrcgProjItemCndnScaleUUID. It has 4 associations to related views. Part of development package RAP_MM_PUR_SRCGPROJ.

Data Sources (1)

SourceAliasJoin Type
R_SrcgProjItmCndnScale R_SrcgProjItmCndnScale from

Associations (4)

CardinalityTargetAliasCondition
[1..1] R_SourcingProjectTP _SourcingProject $projection.SourcingProjectUUID = _SourcingProject.SourcingProjectUUID
[0..*] I_PricingScaleTypeText _PricingScaleTypeText $projection.PricingScaleType = _PricingScaleTypeText.PricingScaleType
[0..*] I_SrcgProjSourcingOriginText _SrcgProjSourcingOriginText $projection.SourcingOrigin = _SrcgProjSourcingOriginText.SourcingOrigin
[0..*] I_SrcgProjSourcingScenarioText _SrcgProjSourcingScenarioText $projection.SourcingScenario = _SrcgProjSourcingScenarioText.SourcingScenario

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey SrcgProjItemCndnScaleUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Condition Scale for Srcg Proj Item - TP view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY SrcgProjItemCndnScaleUUID SrcgProjItemCndnScaleUUID Srcg Proj Item Condition Scale UUID
SourcingProjectUUID SourcingProjectUUID Sourcing Project UUID
SrcgProjItemCndnAmountUUID SrcgProjItemCndnAmountUUID Srcg Proj Item Condition Amount UUID
ConditionScaleQuantity ConditionScaleQuantity Scale Quantity
ConditionScaleQuantityUnit ConditionScaleQuantityUnit Scale UoM
ConditionScaleAmount ConditionScaleAmount Scale Value
ConditionScaleAmountCurrency ConditionScaleAmountCurrency Scale Currency
PricingScaleType PricingScaleType Scale Type
SourcingOrigin SourcingOrigin Sourcing Origin
SourcingScenario SourcingScenario Integration Scenario
_SrcgProjItmCndnAmount _SrcgProjItmCndnAmount
_ConditionScaleQuantityUnit _ConditionScaleQuantityUnit
_SourcingProject _SourcingProject
_PricingScaleTypeText _PricingScaleTypeText
_SrcgProjSourcingOriginText _SrcgProjSourcingOriginText
_SrcgProjSourcingScenarioText _SrcgProjSourcingScenarioText

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 R_SrcgProjItmCndnScaleTP.
-- 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 R_SrcgProjItmCndnScaleTP AS
SELECT
  SrcgProjItemCndnScaleUUID,
  SourcingProjectUUID,
  SrcgProjItemCndnAmountUUID,
  ConditionScaleQuantity,
  ConditionScaleQuantityUnit,
  ConditionScaleAmount,
  ConditionScaleAmountCurrency,
  PricingScaleType,
  SourcingOrigin,
  SourcingScenario
FROM R_SrcgProjItmCndnScale
LEFT OUTER JOIN R_SourcingProjectTP AS _SourcingProject ON SourcingProjectUUID = _SourcingProject.SourcingProjectUUID  -- association [1..1]
LEFT OUTER JOIN I_PricingScaleTypeText AS _PricingScaleTypeText ON PricingScaleType = _PricingScaleTypeText.PricingScaleType  -- association [0..*]
LEFT OUTER JOIN I_SrcgProjSourcingOriginText AS _SrcgProjSourcingOriginText ON SourcingOrigin = _SrcgProjSourcingOriginText.SourcingOrigin  -- association [0..*]
LEFT OUTER JOIN I_SrcgProjSourcingScenarioText AS _SrcgProjSourcingScenarioText ON SourcingScenario = _SrcgProjSourcingScenarioText.SourcingScenario  -- association [0..*]
;

Learn More