Skip to Content
0
Former Member
Jun 08, 2007 at 06:06 AM

sap abap

23 Views

hi all

i m providing all the condition given to me i had done the task till the selection of data in to all internal tables now i had to join the table but i dont want to make the use of inner join so how can i do that and i completely cant understand whts the last line in bold means .

Select company code (BUKRS), plant (WERKS), Location (STORT), Order number (AUFNR), Object Number (OBJNR) from AUFK. Select material (PLNBEZ), Routing number of operations in the order (AUFPL), Number of reservation/dependent requirements (RSNUM), Task List Type (PLNTY), Key for Task List Group (PLNNR), BOM category (STLTY), Bill of material (STLNR) from table AFKO. Select Status (STAT) from table JEST. Use inner join between tables AUFK and AFKO on field AUFNR. Use inner join between tables AUFK and JEST on field OBJNR.

The status in table JEST is compared with the status taken from table TJ02T. Only orders with goods movement posted status are taken.

thanks

himanshu sharma