cancel
Showing results for 
Search instead for 
Did you mean: 

Reg: Join Conditions for Tables to create a View for Generic Extraction

Former Member
0 Kudos

Hi Experts,

Am trying to extract the data from Solman, for this purpose am creating a Generic Extractor based on three tables. So, can anyone please help me out by providing the join conditions to create a view based upon the following three tables,

1. CRM_ORDERM_H

2. DNOD_NOTIF

3. DNOD_NOTIF_S

Anyways i require the following fields in the extractor finally:

CRM CHANGED AT

GUID

SAP COMPONENT

RELEASE

REPORTED BY

These are the some of the major fields that i require in the final extractior. Please help me out ASAP with the table join conditions..

Will Assign Points for the helpfull answer...

Thanks,

Gattu.

View Entire Topic
Former Member
0 Kudos

Hi,

I don't know the table CRM_ORDERM_H however you can link DNOD_NOTIF and DNOD_NOTIF_S

DNOD_NOTIF_S-CLIENT = DNOD_NOTIF-CLIENT

DNOD_NOTIF_S-GUIDS = DNOD_NOTIF-GUIDS

For the third table could you please paste here its definition like the hereunder?


Transp. table      DNOD_NOTIF       Active                                                                    
Short Text         Notification Header                                                                        
   Field           KeyInitData element    Data TyLengthDecimaShort Text                                       
   CLIENT        X    X   MANDT           CLNT        3     0Client                                           
   GUIDH         X    X   DNOT_GUIDH      RAW        16     0GUID Notification                                
   .INCLUDE               DNOS_NOTIF_INT  STRU        0     0Notifications (Header, Internal Fields)          
   OBJNR                  DNOT_OBJNR      CHAR       22     0Status Management Object Number                  
   STATUS                 DNOT_STATUS     CHAR        1     0Notification Status                              
   DELETED                DNOT_DELE_N     CHAR        1     0Deletion Indicator Notification                  
   PROCESSOR              DNOT_PROC       CHAR       12     0Current Processor                                
   TYPE_PROC              DNOT_TYPE_PRC   CHAR        2     0Type of Processor                                
   REPORTER               DNOT_REPORTER   CHAR       12     0Reported By                                      
   TYPE_REPO              DNOT_TYPE_REP   CHAR        2     0Type of Notification Creator                     
   CREA_TSTMP             DNOT_CREA_TSTMP DEC        15     0Entry Time Stamp                                 
   CHNG_TSTMP             DNOT_CHNG_TSTMP DEC        15     0Time of Last Change                              
   START_TSTMP            DNOT_START_TSTMPDEC        15     0Initial Response Time - Time Stamp               
   END_TSTMP              DNOT_END_TSTMP  DEC        15     0Requested End of Processing - Time Stamp         
   CLO_TSTMP              DNOT_CLO_TSTMP  DEC        15     0Completion Time Stamp                            
   .INCLUDE               DNOS_NOTIF_EXT  STRU        0     0Notifications (Header, External Fields)          
   NUMB                   DNOT_NUM        CHAR       12     0Notification Number (External)                   
   REFNUM                 DNOT_REFNUM     CHAR       20     0External Reference Number                        
   TYPE_NOTIF             DNOT_TYPE_N     CHAR        6     0Message category                                 
   CATEGORY               DNOT_CATEGORY   CHAR       12     0Topic, Area                                      
   SUBJECT                DNOT_SUBJECT    CHAR       60     0Re:                                              
   PRIORITY               DNOT_PRIORITY   CHAR        1     0Notification priority                            
   LANGUAGE               DNOT_LANG_N     LANG        1     0Notification Language                            

hope this helps...

Olivier.