Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

internal tables

hi gurus..

i'm a begginer..

how can i store all the data that i extracted into a final internal table (it_details)???

heres my code...

tnx!!

  • select shipping details from vbkd

SELECT inco1

inco2

INTO CORRESPONDING FIELDS OF TABLE it_sales

FROM vbkd

FOR ALL ENTRIES IN it_sales

WHERE vbeln EQ it_sales-vbeln

AND posnr EQ it_sales-posnr.

  • get description of shipping point

SELECT vtext

INTO CORRESPONDING FIELDS OF TABLE it_sales

FROM tvstt

FOR ALL ENTRIES IN it_sales

WHERE spras = 'en'

AND vstel = it_sales-vstel.

  • get description of incoterms

SELECT bezei

INTO CORRESPONDING FIELDS OF TABLE it_sales

FROM tinct

FOR ALL ENTRIES IN it_sales

WHERE inco1 = it_sales-inco1.

  • AND

  • inco1 = it_sales-inco2.

  • SELECT bezei

  • INTO CORRESPONDING FIELDS OF TABLE it_sales

  • FROM tinct.

  • WHERE inco1 = it_sales-inco2

  • get description route

SELECT bezei

INTO CORRESPONDING FIELDS OF TABLE it_sales

FROM tvrot

FOR ALL ENTRIES IN it_sales

WHERE route = it_sales-route.

  • Get customer details

SELECT kunnr

name1

name2

ort01

pstlz

regio

pfach

INTO CORRESPONDING FIELDS OF TABLE it_sales

FROM kna1

FOR ALL ENTRIES IN it_sales

WHERE kunnr EQ it_sales-kunnr.

Edited by: p0ng j0nes on Oct 12, 2008 4:43 AM

Tags:
Not what you were looking for? View more on this topic or Ask a question