ESH_N_PROCUREMENTPROJECT

DDL: ESH_N_PROCUREMENTPROJECT SQL: ESH_L_MMPROCPROJ Type: view Package: BSESH_MM_PUR_HANA_CONTENT
18 Fields 1 Data Sources 1 Associations

Anchor view -PROCUREMENTPROJECT

ESH_N_PROCUREMENTPROJECT is a CDS View that provides data about "Anchor view -PROCUREMENTPROJECT" in SAP S/4HANA. It reads from 1 data source (R_PROCUREMENTPROJECTTP) and exposes 18 fields with key field PROCUREMENTPROJECTUUID. It has 1 association to related views. Part of development package BSESH_MM_PUR_HANA_CONTENT.

Data Sources (1)

SourceAliasJoin Type
R_PROCUREMENTPROJECTTP R_PROCUREMENTPROJECTTP from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (1)

CardinalityTargetAliasCondition
[0..*] dd07t _PROCUREMENTPROJECTACTVTNSTS $projection.ProcurementProjectActvtnSts=_PROCUREMENTPROJECTACTVTNSTS.domvalue_l and _PROCUREMENTPROJECTACTVTNSTS.domname='VDM_PROCUREMENTPROJACTVTNSTS' and _PROCUREMENTPROJECTACTVTNSTS.as4local='A'

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.sqlViewName ESH_L_MMPROCPROJ view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY PROCUREMENTPROJECTUUID PROCUREMENTPROJECTUUID Procurement Project UUID
COMPANYCODE COMPANYCODE Receiver Company Code
PLANTCOMPANYCODENAME
COMPANYCODENAME _COMPANYCODE COMPANYCODENAME Company Name
CREATEDBYUSER CREATEDBYUSER User Name
CREATIONDATETIME CREATIONDATETIME Timestamp
EXTERNALPROJECTREFERENCE EXTERNALPROJECTREFERENCE External Project Reference
ISENDOFPURPOSEBLOCKED ISENDOFPURPOSEBLOCKED Busin. Purp. Cmpltd.
PLANTNAME
PROCUREMENTHUBSOURCESYSTEM _PROCUREMENTPROJECTPLANT PROCUREMENTHUBSOURCESYSTEM Connected System ID
PROCUREMENTPROJACTVTNSTSNAME
PROCUREMENTPROJECT PROCUREMENTPROJECT Project
PROCUREMENTPROJECTACTVTNSTS PROCUREMENTPROJECTACTVTNSTS Status
PROCUREMENTPROJECTNAME PROCUREMENTPROJECTNAME Name
PROCUREMENTPROJECTPLANT _PROCUREMENTPROJECTPLANT PROCUREMENTPROJECTPLANT Plant
PRODUCTIONENDDATE _PROCUREMENTPROJECTPLANT PRODUCTIONENDDATE Production End Date
PRODUCTIONSTARTDATE _PROCUREMENTPROJECTPLANT PRODUCTIONSTARTDATE Start of Production
USERDESCRIPTION _CREATEDBYUSER USERDESCRIPTION Full 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_PROCUREMENTPROJECT.
-- 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_MMPROCPROJ
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_N_PROCUREMENTPROJECT AS
SELECT
  PROCUREMENTPROJECTUUID,
  COMPANYCODE,
  _PROCUREMENTPROJECTPLANT._COMPANYCODE.COMPANYCODENAME AS PLANTCOMPANYCODENAME,
  _COMPANYCODE.COMPANYCODENAME AS COMPANYCODENAME,
  CREATEDBYUSER,
  CREATIONDATETIME,
  EXTERNALPROJECTREFERENCE,
  ISENDOFPURPOSEBLOCKED,
  _PROCUREMENTPROJECTPLANT._PLANT.PLANTNAME AS PLANTNAME,
  _PROCUREMENTPROJECTPLANT.PROCUREMENTHUBSOURCESYSTEM AS PROCUREMENTHUBSOURCESYSTEM,
  _PROCUREMENTPROJECTACTVTNSTS[1: ddlanguage = $parameters. P_Language].ddtext AS PROCUREMENTPROJACTVTNSTSNAME,
  PROCUREMENTPROJECT,
  PROCUREMENTPROJECTACTVTNSTS,
  PROCUREMENTPROJECTNAME,
  _PROCUREMENTPROJECTPLANT.PROCUREMENTPROJECTPLANT AS PROCUREMENTPROJECTPLANT,
  _PROCUREMENTPROJECTPLANT.PRODUCTIONENDDATE AS PRODUCTIONENDDATE,
  _PROCUREMENTPROJECTPLANT.PRODUCTIONSTARTDATE AS PRODUCTIONSTARTDATE,
  _CREATEDBYUSER.USERDESCRIPTION AS USERDESCRIPTION
FROM R_PROCUREMENTPROJECTTP
LEFT OUTER JOIN dd07t AS _PROCUREMENTPROJECTACTVTNSTS ON ProcurementProjectActvtnSts=_PROCUREMENTPROJECTACTVTNSTS.domvalue_l AND _PROCUREMENTPROJECTACTVTNSTS.domname='VDM_PROCUREMENTPROJACTVTNSTS' AND _PROCUREMENTPROJECTACTVTNSTS.as4local='A'  -- association [0..*]
;

Learn More