R_SrcgProjQtnItmCndnValidity

DDL: R_SRCGPROJQTNITMCNDNVALIDITY Type: view BASIC
14 Fields 2 Data Sources 2 Associations

Cndn Validity for Item in Srcg Proj Qtn

R_SrcgProjQtnItmCndnValidity is a Basic CDS View that provides data about "Cndn Validity for Item in Srcg Proj Qtn" in SAP S/4HANA. It reads from 2 data sources (P_SrcgProjQtnItmCndnValidity, R_SrcgProjQtnItem) and exposes 14 fields with key field ConditionRecord. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
P_SrcgProjQtnItmCndnValidity _ConditionValidity from
R_SrcgProjQtnItem _Item inner

Associations (2)

CardinalityTargetAliasCondition
[0..1] R_SourcingProjectQuotation _SourcingProjectQuotation $projection.SourcingProjectQuotationUUID = _SourcingProjectQuotation.SourcingProjectQuotationUUID
[0..1] I_BackendPlantForPurg _BackendPlantForPurg $projection.ProcmtHubPlantUniqueID = _BackendPlantForPurg.ProcmtHubPlantUniqueID

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName RSPQTNITMCNDVAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey ConditionRecord view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Cndn Validity for Item in Srcg Proj Qtn view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ConditionRecord P_SrcgProjQtnItmCndnValidity ConditionRecord Cond.Record No.
ConditionValidityEndDate P_SrcgProjQtnItmCndnValidity ConditionValidityEndDate Valid To
SourcingProjectQuotation P_SrcgProjQtnItmCndnValidity SourcingProjectQuotation Supplier Quotation
SrcgProjQuotationVersion P_SrcgProjQtnItmCndnValidity SrcgProjQuotationVersion Version
SourcingProjectQuotationItem P_SrcgProjQtnItmCndnValidity SourcingProjectQuotationItem Item
ConditionApplication P_SrcgProjQtnItmCndnValidity ConditionApplication Application
ConditionType P_SrcgProjQtnItmCndnValidity ConditionType Condition type
ConditionValidityStartDate P_SrcgProjQtnItmCndnValidity ConditionValidityStartDate Valid From
ConditionIsDeleted P_SrcgProjQtnItmCndnValidity ConditionIsDeleted Deletion Indic.
ProcmtHubPlantUniqueID P_SrcgProjQtnItmCndnValidity ProcmtHubPlantUniqueID Plant Unique ID
SrcgProjQtnItemUUID R_SrcgProjQtnItem SrcgProjQtnItemUUID Supplier Quotation Item UUID
SourcingProjectQuotationUUID R_SrcgProjQtnItem SourcingProjectQuotationUUID Supplier Quotation UUID
_SourcingProjectQuotation _SourcingProjectQuotation
_BackendPlantForPurg _BackendPlantForPurg

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_SrcgProjQtnItmCndnValidity.
-- 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_SrcgProjQtnItmCndnValidity AS
SELECT
  _ConditionValidity.ConditionRecord AS ConditionRecord,
  _ConditionValidity.ConditionValidityEndDate AS ConditionValidityEndDate,
  _ConditionValidity.SourcingProjectQuotation AS SourcingProjectQuotation,
  _ConditionValidity.SrcgProjQuotationVersion AS SrcgProjQuotationVersion,
  _ConditionValidity.SourcingProjectQuotationItem AS SourcingProjectQuotationItem,
  _ConditionValidity.ConditionApplication AS ConditionApplication,
  _ConditionValidity.ConditionType AS ConditionType,
  _ConditionValidity.ConditionValidityStartDate AS ConditionValidityStartDate,
  _ConditionValidity.ConditionIsDeleted AS ConditionIsDeleted,
  _ConditionValidity.ProcmtHubPlantUniqueID AS ProcmtHubPlantUniqueID,
  _Item.SrcgProjQtnItemUUID AS SrcgProjQtnItemUUID,
  _Item.SourcingProjectQuotationUUID AS SourcingProjectQuotationUUID
FROM P_SrcgProjQtnItmCndnValidity AS _ConditionValidity
INNER JOIN R_SrcgProjQtnItem AS _Item ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_SourcingProjectQuotation AS _SourcingProjectQuotation ON SourcingProjectQuotationUUID = _SourcingProjectQuotation.SourcingProjectQuotationUUID  -- association [0..1]
LEFT OUTER JOIN I_BackendPlantForPurg AS _BackendPlantForPurg ON ProcmtHubPlantUniqueID = _BackendPlantForPurg.ProcmtHubPlantUniqueID  -- association [0..1]
;

Learn More