R_SrcgProjItmCndnValidityTP

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

Condition Validity of Srcg Proj Itm - TP

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

Data Sources (1)

SourceAliasJoin Type
R_SrcgProjItmCndnValidity R_SrcgProjItmCndnValidity from

Associations (4)

CardinalityTargetAliasCondition
[1..1] R_SourcingProjectTP _SourcingProject $projection.SourcingProjectUUID = _SourcingProject.SourcingProjectUUID
[0..*] I_SrcgProjSourcingOriginText _SrcgProjSourcingOriginText $projection.SourcingOrigin = _SrcgProjSourcingOriginText.SourcingOrigin
[0..*] I_SrcgProjSourcingScenarioText _SrcgProjSourcingScenarioText $projection.SourcingScenario = _SrcgProjSourcingScenarioText.SourcingScenario
[*] R_SrcgProjItmCndnAmountTP _SrcgProjItmCndnAmount

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey SrcgProjItemCndnValdtyUUID 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 Validity of Srcg Proj Itm - TP view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY SrcgProjItemCndnValdtyUUID SrcgProjItemCndnValdtyUUID Srcg Proj Item Condition Validity UUID
SourcingProjectUUID SourcingProjectUUID Sourcing Project UUID
SourcingProjectItemUUID SourcingProjectItemUUID Item UUID
ConditionValidityStartDate ConditionValidityStartDate Valid From
ConditionValidityEndDate ConditionValidityEndDate Valid To
ProcmtHubPlantUniqueID ProcmtHubPlantUniqueID Plant Unique ID
ConditionType ConditionType Condition type
SourcingOrigin SourcingOrigin Sourcing Origin
SourcingScenario SourcingScenario Integration Scenario
_SrcgProjItmCndnAmount _SrcgProjItmCndnAmount
_SourcingProject _SourcingProject
_SourcingProjectItem _SourcingProjectItem
_BackendPlantForPurg _BackendPlantForPurg
_ConditionText _ConditionText
_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_SrcgProjItmCndnValidityTP.
-- 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_SrcgProjItmCndnValidityTP AS
SELECT
  SrcgProjItemCndnValdtyUUID,
  SourcingProjectUUID,
  SourcingProjectItemUUID,
  ConditionValidityStartDate,
  ConditionValidityEndDate,
  ProcmtHubPlantUniqueID,
  ConditionType,
  SourcingOrigin,
  SourcingScenario
FROM R_SrcgProjItmCndnValidity
LEFT OUTER JOIN R_SourcingProjectTP AS _SourcingProject ON SourcingProjectUUID = _SourcingProject.SourcingProjectUUID  -- association [1..1]
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..*]
LEFT OUTER JOIN R_SrcgProjItmCndnAmountTP AS _SrcgProjItmCndnAmount ON /* condition not available in parsed metadata */  -- association [*]
;

Learn More