P_FieldMappingReqdForChangeDoc

DDL: P_FIELDMAPPINGREQDFORCHANGEDOC SQL: PSDFIELDMAPPING Type: view CONSUMPTION

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.

2 data source(s) 4 fields

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
DDICName dd27s fieldname
GFNName dd03nd fieldname_raw
Objname dd03nd strucobjn 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'PSDFIELDMAPPING'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Field mapping required for Change documents item extractor'
@VDM.viewType: #CONSUMPTION
@VDM.private: true


define view P_FieldMappingReqdForChangeDoc
  as select from dd27s
 inner join dd03nd as DD03ND on ( dd03nd.strucobjn = 'I_SALESDOCUMENTBASIC' or
                                  dd03nd.strucobjn = 'I_SALESDOCUMENTITEM' or
                                  dd03nd.strucobjn = 'I_SALESDOCUMENTSCHEDULELINE' or
                                  dd03nd.strucobjn = 'I_PRICINGELEMENT' or 
                                  dd03nd.strucobjn = 'I_SDDOCUMENTCOMPLETEPARTNERS' or
                                  dd03nd.strucobjn = 'I_SLSDOCITEMBILLINGPLAN' or
                                  dd03nd.strucobjn = 'I_SALESSCHEDGAGRMTDELIVSCHED' or
                                  dd03nd.strucobjn = 'I_SALESDOCUMENTEXTDITEM') and 
                                  dd03nd.nodename = '.NODE1' and 
                                  dd03nd.fieldname = dd27s.viewfield 
{
  key dd27s.viewfield     as GFNNameCapitals,
      dd27s.fieldname     as DDICName,
      dd03nd.fieldname_raw as GFNName,
      dd03nd.strucobjn    as Objname,
      
      case
      when dd03nd.strucobjn = 'I_SALESDOCUMENTBASIC' then cast('VBAK' as tabname )
      when dd03nd.strucobjn = 'I_SALESDOCUMENTITEM' then cast('VBAP' as tabname )
      when dd03nd.strucobjn = 'I_SALESDOCUMENTSCHEDULELINE' then cast('VBEP' as tabname )
      when dd03nd.strucobjn = 'I_PRICINGELEMENT' then cast('KONVC' as tabname )
      when dd03nd.strucobjn = 'I_SDDOCUMENTCOMPLETEPARTNERS' then cast('VBPA' as tabname )
      when dd03nd.strucobjn = 'I_SLSDOCITEMBILLINGPLAN' then cast('FPCA' as tabname )
      when dd03nd.strucobjn = 'I_SALESSCHEDGAGRMTDELIVSCHED' then cast('VBLB' as tabname )
      when dd03nd.strucobjn = 'I_SALESDOCUMENTEXTDITEM' then cast('VBKD' as tabname )
      else cast ('N/A' as tabname )
      end as TabName
                                   
    


}
where
      ( dd27s.viewname = 'ISDSALESDOCITEM' or
        dd27s.viewname = 'ISDSALESDOCBSC'  or 
        dd27s.viewname = 'IPRICINGELEMENT' or 
        dd27s.viewname = 'ISDSLSDOCSCHEDLN' or 
        dd27s.viewname = 'ISDDOCCMPLTPART' or
        dd27s.viewname = 'ISDBILLINGPLAN'  or 
        dd27s.viewname = 'ISDSCHDGAGRMTDS' or
        dd27s.viewname = 'ISDSLSDOCEXTITM')
  and dd27s.as4local  = 'A'

Learn More