C_SrceOfSupForPurchaseContract

DDL: C_SRCEOFSUPFORPURCHASECONTRACT Type: view_entity CONSUMPTION Package: ODATA_MM_ANALYTICS
15 Fields 1 Data Sources

Source of Supply relevant for Purchase Contract Header

C_SrceOfSupForPurchaseContract is a Consumption CDS View that provides data about "Source of Supply relevant for Purchase Contract Header" in SAP S/4HANA. It reads from 1 data source (P_SrceOfSupForPurchaseContract) and exposes 15 fields with key field SourceDocument. Part of development package ODATA_MM_ANALYTICS.

Data Sources (1)

SourceAliasJoin Type
P_SrceOfSupForPurchaseContract P_SrceOfSupForPurchaseContract from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Source of Supply relevant for Purchase Contract Header view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY SourceDocument Source Document
PurchaseContract PurchaseContract Purchasing Doc.
Supplier Supplier Supplier
SupplierName SupplierName Supplier Name
PurchasingDocumentType PurchasingDocumentType RFQ Type
PurchasingDocumentTypeName PurchasingDocumentTypeName Description
ValidityEndDate ValidityEndDate ValidTo
TargetAmount
DocumentCurrency DocumentCurrency Document Currency
ContractConsumptionInPct ContractConsumptionInPct Consumption Pct
PurchaseContractValidityStatus PurchaseContractValidityStatus Validity Status ID
PurContrValidityStatusName PurContrValidityStatusName Validity Status
PurchasingSourceType
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group

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_SrceOfSupForPurchaseContract.
-- 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 C_SrceOfSupForPurchaseContract AS
SELECT
  cast(SourceDocument as cds_source_document) AS SourceDocument,
  PurchaseContract,
  Supplier,
  SupplierName,
  PurchasingDocumentType,
  PurchasingDocumentTypeName,
  ValidityEndDate,
  avg(TargetAmount as ktwrt) AS TargetAmount,
  DocumentCurrency,
  ContractConsumptionInPct,
  PurchaseContractValidityStatus,
  PurContrValidityStatusName,
  cast(PurchasingSourceType as vdm_purchasingsourcetype) AS PurchasingSourceType,
  PurchasingOrganization,
  PurchasingGroup
FROM P_SrceOfSupForPurchaseContract
;

Learn More