S_SRCPROJWITHREFTOCCTRCMMDTY

DDL: S_SRCPROJWITHREFTOCCTRCMMDTY SQL: SPTOCCTRCMMDTY Type: view Package: LOG_CMM_PRC_PUR_HUB_SRCG_PROJ
6 Fields 1 Data Sources

Creation of SP with reference to Central Contract

S_SRCPROJWITHREFTOCCTRCMMDTY is a CDS View that provides data about "Creation of SP with reference to Central Contract" in SAP S/4HANA. It reads from 1 data source (I_CntrlPurContrItmCmmdtyQtyTP) and exposes 6 fields with key fields CentralPurchaseContract, CentralPurchaseContractItem. Part of development package LOG_CMM_PRC_PUR_HUB_SRCG_PROJ.

Data Sources (1)

SourceAliasJoin Type
I_CntrlPurContrItmCmmdtyQtyTP I_CntrlPurContrItmCmmdtyQtyTP from

Parameters (1)

NameTypeDefault
SrcgProjEarliestCndnSelDate kdate

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName SPTOCCTRCMMDTY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Creation of SP with reference to Central Contract view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY CentralPurchaseContract CentralPurchaseContract Purchasing Doc.
KEY CentralPurchaseContractItem CentralPurchaseContractItem Item in Central Purchase Contract
PurgDocCmmdtyQtyValidToDate
PurgDocCmmdtyQtyValidFromDate
Commodity Commodity Commodity Code
_Commodity _Commodity

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 S_SRCPROJWITHREFTOCCTRCMMDTY.
-- 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: SPTOCCTRCMMDTY
-- Parameters: SrcgProjEarliestCndnSelDate : kdate

CREATE VIEW S_SRCPROJWITHREFTOCCTRCMMDTY AS
SELECT
  CentralPurchaseContract,
  CentralPurchaseContractItem,
  max(PurgDocCmmdtyQtyValidToDate) AS PurgDocCmmdtyQtyValidToDate,
  cast ( $parameters.SrcgProjEarliestCndnSelDate as kdatb preserving type ) AS PurgDocCmmdtyQtyValidFromDate,
  Commodity
FROM I_CntrlPurContrItmCmmdtyQtyTP
;

Learn More