P_ProjectFieldMappingForChgDoc

DDL: P_PROJECTFIELDMAPPINGFORCHGDOC SQL: PPROJFIELDMAP Type: view BASIC
4 Fields 2 Data Sources

Project/WBS Mapping Fields for Chg Doc

P_ProjectFieldMappingForChgDoc is a Basic CDS View that provides data about "Project/WBS Mapping Fields for Chg Doc" in SAP S/4HANA. It reads from 2 data sources (dd03nd, dd27s) and exposes 4 fields with key field GFNNameCapitals.

Data Sources (2)

SourceAliasJoin Type
dd03nd DD03ND inner
dd27s dd27s from

Parameters (2)

NameTypeDefault
p_tabname ddstrucobjname
p_viewname viewname

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PPROJFIELDMAP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Project/WBS Mapping Fields for Chg Doc view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY GFNNameCapitals dd27s viewfield View field
fieldnameasfieldnameendasDDICName
GFNName dd03nd fieldname_raw Property Name
Objname dd03nd strucobjn DD: Name of a structured object (e.g. entity, context)

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 P_ProjectFieldMappingForChgDoc.
-- 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: PPROJFIELDMAP
-- Parameters: p_tabname : ddstrucobjname, p_viewname : viewname

CREATE VIEW P_ProjectFieldMappingForChgDoc AS
SELECT
  dd27s.viewfield AS GFNNameCapitals,
  case when dd27s.viewfield = 'FREEDEFINEDAMOUNT1' then cast('USR06' as fieldname ) when dd27s.viewfield = 'FREEDEFINEDAMOUNT2' then cast('USR07' as fieldname ) else cast ( dd27s.fieldname as fieldname ) end as DDICName AS fieldnameasfieldnameendasDDICName,
  dd03nd.fieldname_raw AS GFNName,
  dd03nd.strucobjn AS Objname
FROM dd27s
INNER JOIN dd03nd AS DD03ND ON /* join condition not captured in parsed metadata */
;

Learn More