P_ProjectFieldMappingForChgDoc

DDL: P_PROJECTFIELDMAPPINGFORCHGDOC SQL: PPROJFIELDMAP Type: view BASIC Package: VDM_PS_ST_CHANGEDOC

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. Part of development package VDM_PS_ST_CHANGEDOC.

2 data source(s) 4 fields

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
fieldnameasfieldnameendasDDICName
GFNName dd03nd fieldname_raw
Objname dd03nd strucobjn 
@AbapCatalog.sqlViewName: 'PPROJFIELDMAP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Project/WBS Mapping Fields for Chg Doc'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view P_ProjectFieldMappingForChgDoc
with parameters
    p_tabname : ddstrucobjname,
    p_viewname: viewname
  as select from dd27s
    inner join   dd03nd as DD03ND on  DD03ND.strucobjn = :p_tabname 
                                  and DD03ND.nodename  = '.NODE1'
                                  and DD03ND.fieldname = dd27s.viewfield


{
  key 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,
      // dd27s.fieldname      as DDICName,

      DD03ND.fieldname_raw as GFNName,
      DD03ND.strucobjn     as Objname,

      case
      when DD03ND.strucobjn = 'I_PROJECTDATA_2' then cast('PROJ' as tabname )
      when DD03ND.strucobjn = 'I_WBSELEMENTDATA_2' then cast('PRPS' as tabname )
      else cast ('N/A' as tabname )
      end                  as TabName
}
where
  dd27s.viewname = :p_viewname
  and  dd27s.as4local   = 'A'

Learn More