ESH_N_SRCGPROJAWARDINGSCENARIO

DDL: ESH_N_SRCGPROJAWARDINGSCENARIO SQL: ESH_L_MMSPAWD Type: view
19 Fields 1 Data Sources

ESH_N_SRCGPROJAWARDINGSCENARIO is a CDS View in SAP S/4HANA. It reads from 1 data source (R_SRCGPROJAWARDINGSCENARIOTP) and exposes 19 fields with key fields SOURCINGPROJECTQUOTATIONUUID, SRCGPROJAWARDINGSCENARIOUUID.

Data Sources (1)

SourceAliasJoin Type
R_SRCGPROJAWARDINGSCENARIOTP R_SRCGPROJAWARDINGSCENARIOTP from

Annotations (6)

NameValueLevelField
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName ESH_L_MMSPAWD view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY SOURCINGPROJECTQUOTATIONUUID
KEY SRCGPROJAWARDINGSCENARIOUUID SRCGPROJAWARDINGSCENARIOUUID Awarding Scenario UUID
COMPANYCODE _SOURCINGPROJECT COMPANYCODE Receiver Company Code
COMPANYCODENAME
CREATEDBYUSER CREATEDBYUSER User Name
CREATIONDATETIME CREATIONDATETIME Timestamp
LASTCHANGEDATETIME LASTCHANGEDATETIME Timestamp
MATERIALGROUP _SOURCINGPROJECT MATERIALGROUP Product Group
PURCHASINGGROUP _SOURCINGPROJECT PURCHASINGGROUP Purchasing Group
PURCHASINGGROUPNAME
PURCHASINGORGANIZATION _SOURCINGPROJECT PURCHASINGORGANIZATION Purchasing Organization
PURCHASINGORGANIZATIONNAME
SOURCINGPROJECTNAME _SOURCINGPROJECT SOURCINGPROJECTNAME Name
SOURCINGPROJECTQUOTATIONNAME
SOURCINGPROJECTTYPE _SOURCINGPROJECT SOURCINGPROJECTTYPE Sourcing Project Type
SOURCINGPROJECTUUID SOURCINGPROJECTUUID Sourcing Project UUID
SRCGPROJAWDGSCENLIFECYCLESTS SRCGPROJAWDGSCENLIFECYCLESTS Status
SRCGPROJECTAWARDINGSCENARIO SRCGPROJECTAWARDINGSCENARIO Awarding Scenario
SRCGPROJECTAWARDINGSCENNAME SRCGPROJECTAWARDINGSCENNAME Name

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 ESH_N_SRCGPROJAWARDINGSCENARIO.
-- 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: ESH_L_MMSPAWD

CREATE VIEW ESH_N_SRCGPROJAWARDINGSCENARIO AS
SELECT
  _SRCGPROJAWARDINGSCENQTN._SOURCINGPROJECTQUOTATION.SOURCINGPROJECTQUOTATIONUUID AS SOURCINGPROJECTQUOTATIONUUID,
  SRCGPROJAWARDINGSCENARIOUUID,
  _SOURCINGPROJECT.COMPANYCODE AS COMPANYCODE,
  _SOURCINGPROJECT._COMPANYCODE.COMPANYCODENAME AS COMPANYCODENAME,
  CREATEDBYUSER,
  CREATIONDATETIME,
  LASTCHANGEDATETIME,
  _SOURCINGPROJECT.MATERIALGROUP AS MATERIALGROUP,
  _SOURCINGPROJECT.PURCHASINGGROUP AS PURCHASINGGROUP,
  _SOURCINGPROJECT._PURCHASINGGROUP.PURCHASINGGROUPNAME AS PURCHASINGGROUPNAME,
  _SOURCINGPROJECT.PURCHASINGORGANIZATION AS PURCHASINGORGANIZATION,
  _SOURCINGPROJECT._PURCHASINGORGANIZATION.PURCHASINGORGANIZATIONNAME AS PURCHASINGORGANIZATIONNAME,
  _SOURCINGPROJECT.SOURCINGPROJECTNAME AS SOURCINGPROJECTNAME,
  _SRCGPROJAWARDINGSCENQTN._SOURCINGPROJECTQUOTATION.SOURCINGPROJECTQUOTATIONNAME AS SOURCINGPROJECTQUOTATIONNAME,
  _SOURCINGPROJECT.SOURCINGPROJECTTYPE AS SOURCINGPROJECTTYPE,
  SOURCINGPROJECTUUID,
  SRCGPROJAWDGSCENLIFECYCLESTS,
  SRCGPROJECTAWARDINGSCENARIO,
  SRCGPROJECTAWARDINGSCENNAME
FROM R_SRCGPROJAWARDINGSCENARIOTP
;

Learn More