R_SrcgProjItmCndnAmount

DDL: R_SRCGPROJITMCNDNAMOUNT Type: view BASIC
20 Fields 1 Data Sources 4 Associations

Condition Amount for Srcg Project Item

R_SrcgProjItmCndnAmount is a Basic CDS View that provides data about "Condition Amount for Srcg Project Item" in SAP S/4HANA. It reads from 1 data source (mmspitmcndamt) and exposes 20 fields with key field SrcgProjItemCndnAmountUUID. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
mmspitmcndamt SPItemConditionAmount from

Associations (4)

CardinalityTargetAliasCondition
[1..1] R_SrcgProjItmCndnValidity _SrcgProjItmCndnValidity $projection.SrcgProjItemCndnValdtyUUID = _SrcgProjItmCndnValidity.SrcgProjItemCndnValdtyUUID
[1..1] R_SourcingProject _SourcingProject $projection.SourcingProjectUUID = _SourcingProject.SourcingProjectUUID
[0..1] I_UnitOfMeasure _ConditionQuantityUnit $projection.ConditionQuantityUnit = _ConditionQuantityUnit.UnitOfMeasure
[0..1] I_PurCommodityConditionMapping _CommodityConditionMapping $projection.ConditionType = _CommodityConditionMapping.ConditionType

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName RSPITMCNDNAMT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey SrcgProjItemCndnAmountUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Condition Amount for Srcg Project Item view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY SrcgProjItemCndnAmountUUID mmspitmcndamt srcgprojitemcndnamountuuid Srcg Proj Item Condition Amount UUID
SourcingProjectUUID mmspitmcndamt sourcingprojectuuid Sourcing Project UUID
SrcgProjItemCndnValdtyUUID mmspitmcndamt srcgprojitemcndnvaldtyuuid Srcg Proj Item Condition Validity UUID
ConditionType mmspitmcndamt conditiontype Condition type
SrcgProjItemCndnIsMand mmspitmcndamt srcgprojitemcndnismand Condition is Mandatory
SrcgProjItemCndnIsExcld mmspitmcndamt srcgprojitemcndnisexcld Condition is Excluded
SrcgProjPricingScaleBasis mmspitmcndamt srcgprojpricingscalebasis Scale Base Type
ConditionValidityStartDate mmspitmcndamt conditionvaliditystartdate Valid From
ConditionValidityEndDate mmspitmcndamt conditionvalidityenddate Valid To
ConditionSequentialNumberShort mmspitmcndamt conditionsequentialnumbershort Sequent. No. of Cond
ConditionQuantity mmspitmcndamt conditionquantity Pricing Unit
ConditionQuantityUnit mmspitmcndamt conditionquantityunit Unit of Measure
CmmdtyPricingEngineIsEnabled mmspitmcndamt cmmdtypricingengineisenabled Enabled for CPE
SuplrCostBreakdownIsRelevant mmspitmcndamt suplrcostbreakdownisrelevant Condition is Relevant for Cost Breakdown
SourcingOrigin mmspitmcndamt sourcingorigin Sourcing Origin
SourcingScenario mmspitmcndamt sourcingscenario Integration Scenario
_SrcgProjItmCndnValidity _SrcgProjItmCndnValidity
_ConditionQuantityUnit _ConditionQuantityUnit
_SourcingProject _SourcingProject
_CommodityConditionMapping _CommodityConditionMapping

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_SrcgProjItmCndnAmount.
-- 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_SrcgProjItmCndnAmount AS
SELECT
  SPItemConditionAmount.srcgprojitemcndnamountuuid AS SrcgProjItemCndnAmountUUID,
  SPItemConditionAmount.sourcingprojectuuid AS SourcingProjectUUID,
  SPItemConditionAmount.srcgprojitemcndnvaldtyuuid AS SrcgProjItemCndnValdtyUUID,
  SPItemConditionAmount.conditiontype AS ConditionType,
  SPItemConditionAmount.srcgprojitemcndnismand AS SrcgProjItemCndnIsMand,
  SPItemConditionAmount.srcgprojitemcndnisexcld AS SrcgProjItemCndnIsExcld,
  SPItemConditionAmount.srcgprojpricingscalebasis AS SrcgProjPricingScaleBasis,
  SPItemConditionAmount.conditionvaliditystartdate AS ConditionValidityStartDate,
  SPItemConditionAmount.conditionvalidityenddate AS ConditionValidityEndDate,
  SPItemConditionAmount.conditionsequentialnumbershort AS ConditionSequentialNumberShort,
  SPItemConditionAmount.conditionquantity AS ConditionQuantity,
  SPItemConditionAmount.conditionquantityunit AS ConditionQuantityUnit,
  SPItemConditionAmount.cmmdtypricingengineisenabled AS CmmdtyPricingEngineIsEnabled,
  SPItemConditionAmount.suplrcostbreakdownisrelevant AS SuplrCostBreakdownIsRelevant,
  SPItemConditionAmount.sourcingorigin AS SourcingOrigin,
  SPItemConditionAmount.sourcingscenario AS SourcingScenario
FROM mmspitmcndamt AS SPItemConditionAmount
LEFT OUTER JOIN R_SrcgProjItmCndnValidity AS _SrcgProjItmCndnValidity ON SrcgProjItemCndnValdtyUUID = _SrcgProjItmCndnValidity.SrcgProjItemCndnValdtyUUID  -- association [1..1]
LEFT OUTER JOIN R_SourcingProject AS _SourcingProject ON SourcingProjectUUID = _SourcingProject.SourcingProjectUUID  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ConditionQuantityUnit ON ConditionQuantityUnit = _ConditionQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_PurCommodityConditionMapping AS _CommodityConditionMapping ON ConditionType = _CommodityConditionMapping.ConditionType  -- association [0..1]
;

Learn More