C_SourcingProjectSupplierDEX

DDL: C_SOURCINGPROJECTSUPPLIERDEX SQL: CMMSORPROJSDEX Type: view CONSUMPTION
19 Fields 1 Data Sources

Sourcing Project

C_SourcingProjectSupplierDEX is a Consumption CDS View (Fact) that provides data about "Sourcing Project" in SAP S/4HANA. It reads from 1 data source (R_SrcgProjPubdSuplrListBP) and exposes 19 fields with key field SrcgProjPubdSuplrListUUID.

Data Sources (1)

SourceAliasJoin Type
R_SrcgProjPubdSuplrListBP R_SrcgProjPubdSuplrListBP from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CMMSORPROJSDEX view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Sourcing Project view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.modelingPattern #ANALYTICAL_FACT view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Analytics.dataCategory #FACT view
Analytics.dataExtraction.enabled true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY SrcgProjPubdSuplrListUUID SrcgProjPubdSuplrListUUID Published Supplier List UUID
SourcingProjectUUID SourcingProjectUUID Sourcing Project UUID
SourcingSupplierListUUID SourcingSupplierListUUID UUID of Sourcing Supplier List
SupplierListUUID SupplierListUUID Supplier List UUID
SrcgSuplrListBusPartUUID SrcgSuplrListBusPartUUID Business Partner GUID
CurrentDateTime CurrentDateTime
SrcgProjSupplierLockStatus SrcgProjSupplierLockStatus Supplier Lock Status
SrcgProjParticipationStatus SrcgProjParticipationStatus Supplier Participation Status
QtnExtendedLatestSubmsnDteTime QtnExtendedLatestSubmsnDteTime Submission Deadline
SrcgProjSuplrPartcipnDclnRsn SrcgProjSuplrPartcipnDclnRsn Reason
SourcingOrigin SourcingOrigin Sourcing Origin
SourcingScenario SourcingScenario Integration Scenario
SourcingProjectIsRefused SourcingProjectIsRefused Participation Declined
Supplier Supplier Supplier
BusinessPartner BusinessPartner Issuing Authority
AddressID AddressID Ship-to address
SupplierCountryGroup SupplierCountryGroup Country/Region Group
SuplrListSupplierIsMandatory SuplrListSupplierIsMandatory Mandatory Supplier
BusinessPartnerIsBlocked BusinessPartnerIsBlocked Central Block

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_SourcingProjectSupplierDEX.
-- 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: CMMSORPROJSDEX

CREATE VIEW C_SourcingProjectSupplierDEX AS
SELECT
  SrcgProjPubdSuplrListUUID,
  SourcingProjectUUID,
  SourcingSupplierListUUID,
  SupplierListUUID,
  SrcgSuplrListBusPartUUID,
  CurrentDateTime,
  SrcgProjSupplierLockStatus,
  SrcgProjParticipationStatus,
  QtnExtendedLatestSubmsnDteTime,
  SrcgProjSuplrPartcipnDclnRsn,
  SourcingOrigin,
  SourcingScenario,
  SourcingProjectIsRefused,
  Supplier,
  BusinessPartner,
  AddressID,
  SupplierCountryGroup,
  SuplrListSupplierIsMandatory,
  BusinessPartnerIsBlocked
FROM R_SrcgProjPubdSuplrListBP
;

Learn More