C_SrcgProjVersioningReasonVH

DDL: C_SRCGPROJVERSIONINGREASONVH SQL: CSPITMVRSRSNVH Type: view CONSUMPTION Package: ODATA_MM_PUR_SRCGPROJ_MAINTAIN
4 Fields 3 Data Sources 2 OData Services

Reason for New Version of Srcg Project

C_SrcgProjVersioningReasonVH is a Consumption CDS View that provides data about "Reason for New Version of Srcg Project" in SAP S/4HANA. It reads from 3 data sources (I_ProductSourcingReasonModel, I_SourcingProjectType, I_ProductSourcingReason) and exposes 4 fields with key fields SourcingProjectReason, SourcingProjectType. It is exposed through 2 OData services (UI_SOURCINGPROJECT_MANAGE, UI_SRCGPROJ_CONTRIBUTE). Part of development package ODATA_MM_PUR_SRCGPROJ_MAINTAIN.

Data Sources (3)

SourceAliasJoin Type
I_ProductSourcingReasonModel _SourcingProjectReasonModel inner
I_SourcingProjectType _SourcingProjectType inner
I_ProductSourcingReason I_ProductSourcingReason from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CSPITMVRSRSNVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey SourcingProjectReason view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.dataCategory #VALUE_HELP view
VDM.viewType #CONSUMPTION view
EndUserText.label Reason for New Version of Srcg Project view
Search.searchable true view
Consumption.ranked true view

OData Services (2)

ServiceBindingVersionContractRelease
UI_SOURCINGPROJECT_MANAGE UI_SOURCINGPROJECT_MANAGE V2 C1 NOT_RELEASED
UI_SRCGPROJ_CONTRIBUTE UI_SRCGPROJ_CONTRIBUTE V2 C1 NOT_RELEASED

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY SourcingProjectReason I_ProductSourcingReason ProductSourcingReason Sp.Tax Code Reason
KEY SourcingProjectType I_SourcingProjectType SourcingProjectType Sourcing Project Type
SourcingProjectReasonGroup I_ProductSourcingReasonModel ProductSourcingReasonGroup Reason Group
SourcingProjectReasonText

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 C_SrcgProjVersioningReasonVH.
-- 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: CSPITMVRSRSNVH

CREATE VIEW C_SrcgProjVersioningReasonVH AS
SELECT
  I_ProductSourcingReason.ProductSourcingReason AS SourcingProjectReason,
  _SourcingProjectType.SourcingProjectType AS SourcingProjectType,
  _SourcingProjectReasonModel.ProductSourcingReasonGroup AS SourcingProjectReasonGroup,
  I_ProductSourcingReason._SourcingProjectReasonText[1:Language = $session.system_language ].ProductSourcingReasonText AS SourcingProjectReasonText
FROM I_ProductSourcingReason
INNER JOIN I_ProductSourcingReasonModel AS _SourcingProjectReasonModel ON /* join condition not captured in parsed metadata */
INNER JOIN I_SourcingProjectType AS _SourcingProjectType ON /* join condition not captured in parsed metadata */
;

Learn More