P_FieldMappingReqdForChangeDoc

DDL: P_FIELDMAPPINGREQDFORCHANGEDOC SQL: PSDFIELDMAPPING Type: view CONSUMPTION Package: VDM_SD_DEX

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 5 fields with key field GFNNameCapitals. Part of development package VDM_SD_DEX.

2 data source(s) 5 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 (5)

KeyFieldSource TableSource FieldDescription
KEY GFNNameCapitals dd27s viewfield
DDICName dd27s fieldname
GFNName dd03nd fieldname_raw
Objname dd03nd strucobjn
TabName dd27s tabname 
@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' ) 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,
      
      // The dd27s.tabname value for custom feild is E_SalesDocumentBasic/E_SalesDocumentItemBasic(not VBAK/VBAP)

      dd27s.tabname 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' )
  and dd27s.as4local  = 'A'

Learn More