P_FieldMappingReqdForChangeDoc

DDL: P_FIELDMAPPINGREQDFORCHANGEDOC SQL: PSDFIELDMAPPING Type: view CONSUMPTION
4 Fields 2 Data Sources

Field mapping required for Change documents item extractor

P_FieldMappingReqdForChangeDoc is a Consumption CDS View that provides data about "Field mapping required for Change documents item extractor" 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

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PSDFIELDMAPPING view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Field mapping required for Change documents item extractor view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY GFNNameCapitals dd27s viewfield View field
DDICName dd27s fieldname UI Group FieldName
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_FieldMappingReqdForChangeDoc.
-- 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: PSDFIELDMAPPING

CREATE VIEW P_FieldMappingReqdForChangeDoc AS
SELECT
  dd27s.viewfield AS GFNNameCapitals,
  dd27s.fieldname AS DDICName,
  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