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.

Accepted Solutions (1)

Accepted Solutions (1)

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.

Answers (0)