C_SrcgProjProcmtProjDocVarbl

DDL: C_SRCGPROJPROCMTPROJDOCVARBL SQL: CSPPROCMTPROJVB Type: view CONSUMPTION
6 Fields 1 Data Sources 1 Associations

Doc Varbl for Procmnt Proj in Srcg Proj

C_SrcgProjProcmtProjDocVarbl is a Consumption CDS View that provides data about "Doc Varbl for Procmnt Proj in Srcg Proj" in SAP S/4HANA. It reads from 1 data source (I_SrcgProjProcurementProject) and exposes 6 fields with key field SrcgProjProcmtProjectUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_SrcgProjProcurementProject I_SrcgProjProcurementProject from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_SourcingProjectDocVarbl _SourcingProject $projection.SourcingProjectUUID = _SourcingProject.SourcingProjectUUID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CSPPROCMTPROJVB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey SrcgProjProcmtProjectUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #CONSUMPTION view
EndUserText.label Doc Varbl for Procmnt Proj in Srcg Proj view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY SrcgProjProcmtProjectUUID SrcgProjProcmtProjectUUID Procurement Project UUID
SourcingProjectUUID SourcingProjectUUID Sourcing Project UUID
SrcgProjProcurementProject SrcgProjProcurementProject Project
SourcingOrigin SourcingOrigin Sourcing Origin
SourcingScenario SourcingScenario Integration Scenario
_SourcingProject _SourcingProject

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_SrcgProjProcmtProjDocVarbl.
-- 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: CSPPROCMTPROJVB

CREATE VIEW C_SrcgProjProcmtProjDocVarbl AS
SELECT
  SrcgProjProcmtProjectUUID,
  SourcingProjectUUID,
  SrcgProjProcurementProject,
  SourcingOrigin,
  SourcingScenario
FROM I_SrcgProjProcurementProject
LEFT OUTER JOIN C_SourcingProjectDocVarbl AS _SourcingProject ON SourcingProjectUUID = _SourcingProject.SourcingProjectUUID  -- association [1..1]
;

Learn More