ESH_N_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 ESH_N_SOURCINGPROJECT.
-- 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_MMSRCGPROJ
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_N_SOURCINGPROJECT AS
SELECT
  SOURCINGPROJECTUUID,
  _SRCGPROJPUBDSUPLRLISTBP._BUSINESSPARTNER.BUSINESSPARTNER AS BUSINESSPARTNER,
  COMPANYCODE,
  _COMPANYCODE.COMPANYCODENAME AS COMPANYCODENAME,
  CREATEDBYUSER,
  CREATIONDATETIME,
  EXTERNALSOURCINGPROJECTREF,
  _SOURCINGPROJECTITEM.MATERIAL AS MATERIAL,
  MATERIALGROUP,
  _MATERIALGROUPTEXT[1: LANGUAGE = $parameters. P_Language].MATERIALGROUPNAME AS MATERIALGROUPNAME,
  _SRCGPROJPUBDSUPLRLISTBP._SUPPLIER.ORGANIZATIONBPNAME1 AS ORGANIZATIONBPNAME1,
  _SOURCINGPROJECTITEM.PLANT AS PLANT,
  PURCHASERRESPWORKAGREEMENT,
  PURCHASINGGROUP,
  _PURCHASINGGROUP.PURCHASINGGROUPNAME AS PURCHASINGGROUPNAME,
  PURCHASINGORGANIZATION,
  _PURCHASINGORGANIZATION.PURCHASINGORGANIZATIONNAME AS PURCHASINGORGANIZATIONNAME,
  QTNLATESTSUBMISSIONDATETIME,
  SOURCINGPROJECT,
  SOURCINGPROJECTNAME,
  _SOURCINGPROJECTPHASETEXT[1: LANGUAGE = $parameters. P_Language].SOURCINGPROJECTPHASETEXT AS SOURCINGPROJECTPHASETEXT,
  SOURCINGPROJECTTYPE,
  _SOURCINGPROJECTTYPETEXT[1: LANGUAGE = $parameters. P_Language].SOURCINGPROJECTTYPETEXT AS SOURCINGPROJECTTYPETEXT,
  SOURCINGPROJECTVERSION,
  _SOURCINGPROJECTITEM.SRCGPROJITEMDESCRIPTION AS SRCGPROJITEMDESCRIPTION,
  SRCGPROJLIFECYCLESTATUS,
  _SRCGPROJLIFECYCLESTATUS[1: ddlanguage = $parameters. P_Language].ddtext AS SRCGPROJLIFECYCLESTATUSNAME,
  _SRCGPROJPUBDSUPLRLISTBP._SUPPLIER.SUPPLIER AS SUPPLIER,
  _CREATEDBYUSER.USERDESCRIPTION AS USERDESCRIPTION
FROM R_SOURCINGPROJECTTP
LEFT OUTER JOIN dd07t AS _SRCGPROJLIFECYCLESTATUS ON SrcgProjLifecycleStatus=_SRCGPROJLIFECYCLESTATUS.domvalue_l AND _SRCGPROJLIFECYCLESTATUS.domname='VDM_SRCGPROJECTLFCYCSTS' AND _SRCGPROJLIFECYCLESTATUS.as4local='A' AND _SRCGPROJLIFECYCLESTATUS.as4vers='0000'  -- association [0..*]
;