topic Re: need help...? in Application Development and Automation Discussions

need help...?

Former Member — Thu, 07 Jun 2007 05:49:19 GMT

Hi,

I have to have a header data with fields

Vendor Number: RBKP-LIFNR

Vendor Name: LFA1-NAME1 (Link via LIFNR)

Purchase Order: EKBE-EBELN

SAP Inv: RBKP-BELNR

Vendor Invoice No: RBKP-XBLNR

what will be the syntax for this..shud i have one internal table or two..

please help..

cheers:jim

Re: need help...?

Former Member — Thu, 07 Jun 2007 05:52:12 GMT

hi,

Its better if u have two internal tables and join them

Re: need help...?

Former Member — Thu, 07 Jun 2007 05:54:49 GMT

Hi Jimmy,

you need to declare only one internal table as follows.

types: begin ot itype,

LIFNR type RBKP-LIFNR,

NAME1 type LFA1-NAME1,

EBELN type EKBE-EBELN,

BELNR type RBKP-BELNR,

XBLNR type RBKP-XBLNR,

end of itype.

data: itab type table of itype, "internal table

wtab type itype. "work area

regards,

Ruchika

Reward if useful.

Re: need help...?

Former Member — Thu, 07 Jun 2007 05:57:14 GMT

But how will I raise a select command...I have the internal table with this structure but not able to figure out how to get data into the table...

Thnx

Re: need help...?

Former Member — Thu, 07 Jun 2007 06:01:08 GMT

Hi,

Check if u can relate like this:

using Customer Invoice search in VBFA for Sales Order and from VBFA search for Purchase Order corresponding to Sales Order and for Correspoding PO u can search for Corresponding Vendor Invoices in RBKP. I think for Vendor Invoice u can check in MIRO and in that tcode if u give the PO number all data related to PO u can get.

And also check this:

types: begin of ty_itab1,

LIFNR type RBKP-LIFNR,

NAME1 type LFA1-NAME1,

EBELN type EKBE-EBELN,

BELNR type RBKP-BELNR,

XBLNR type RBKP-XBLNR,

end of ty_itab1.

data: itab1 type standard table of ty_itab1,

wa1 type ty_itab1.

read table itab into wa with key lifnr = itab1-lifnr.

if sy-subrc eq 0.

move wa-lifnr = wa1-lifnr.

move wa-ebeln = wa1-ebeln.

move wa-xblnr = wa1-xblnr.etc.

append wa1 to itab1.

endif.

Regards

Kannaiah

Re: need help...?

Former Member — Thu, 07 Jun 2007 06:01:30 GMT

hi jimmy,

u first write select statment on table tbkp,

then use for all entries of first <itab>, write select statment on table lfa1,

now use for all entries of first <itab>, write select statemnet on table ekbe.

in loop u can move all these records one global <itab> then disply.

reward points if helpful,

regards,

seshu.

Re: need help...?

Former Member — Thu, 07 Jun 2007 06:02:39 GMT

u can use ctrl statements....

loop at itab.

write : / itab-fld1 , itab-fld2.

at new <fld>.

write : / <item fileds>.

endat.

hope it helps.....

sorry i think i got the question wrong...please ignore this.

Message was edited by:

Premalatha G

Re: need help...?

Former Member — Thu, 07 Jun 2007 06:05:08 GMT

I have a selection screen with a select option field for EKBE-EBELN...Now for this range I have to fill this internal table with header data...

Not able to figure out the link between the tables...

thnx for ur help guys...

Jim

Re: need help...?

Former Member — Thu, 07 Jun 2007 06:08:41 GMT

first select form ekbe table then use this <itab>, for all other selection statements through for all entries.

otherwise post your code then we'll try to adjust.

reward with points if helpful.

regards,

seshu.

Re: need help...?

Former Member — Thu, 07 Jun 2007 06:10:58 GMT

Hi jimmy,

sorry for previous reply.

try wid this way.

TYPES: begin of itype,

lifnr TYPE rbkp-lifnr,

belnr TYPE rbkp-belnr,

xblnr TYPE rbkp-xblnr,

END OF itype.

TYPES:BEGIN OF itype1,

name1 TYPE lfa1-name1,

END OF itype1.

TYPES: BEGIN OF itype2,

ebeln TYPE ekbe-ebeln,

END OF itype2.

DATA: itab TYPE TABLE OF itype, "internal table

wtab TYPE itype. "work area

DATA: itab1 TYPE TABLE OF itype1, "internal table

wtab1 TYPE itype1. "work area

DATA: itab2 TYPE TABLE OF itype2, "internal table

wtab2 TYPE itype2. "work area

SELECT lifnr belnr xblnr FROM rbkp INTO TABLE itab.

SELECT name1 FROM lfa1 INTO TABLE itab1 FOR ALL ENTRIES IN itab WHERE

lifnr = itab-lifnr.

select ebeln from ekbe into table itab2 for all entries in itab where

belnr = itab-belnr.

regards,

Ruchika

Re: need help...?

Former Member — Thu, 07 Jun 2007 06:12:34 GMT

Hi,

Now you can read these three internal tables in a final header table.

regards,

Ruchika

Re: need help...?

Former Member — Thu, 07 Jun 2007 06:19:54 GMT

Hi,

if you want to select according to your select-options then go in this way

TYPES: begin of itype,

lifnr TYPE rbkp-lifnr,

belnr TYPE rbkp-belnr,

xblnr TYPE rbkp-xblnr,

END OF itype.

TYPES:BEGIN OF itype1,

name1 TYPE lfa1-name1,

END OF itype1.

TYPES: BEGIN OF itype2,

ebeln TYPE ekbe-ebeln,

belnr type ekbe-belnr,

END OF itype2.

DATA: itab TYPE TABLE OF itype, "internal table

wtab TYPE itype. "work area

DATA: itab1 TYPE TABLE OF itype1, "internal table

wtab1 TYPE itype1. "work area

DATA: itab2 TYPE TABLE OF itype2, "internal table

wtab2 TYPE itype2. "work area

select ebeln belnr from ekbe into table itab2 .

SELECT lifnr belnr xblnr FROM rbkp INTO TABLE itab FOR ALL ENTRIES IN

itab2 WHERE

belnr = itab2-belnr.

SELECT name1 FROM lfa1 INTO TABLE itab1 FOR ALL ENTRIES IN itab WHERE

lifnr = itab-lifnr.

regards,

Ruchika

Re: need help...?

Former Member — Thu, 07 Jun 2007 06:21:30 GMT

select ebeln belnr from ekbe into table itab2 where ebeln in s_ebeln.

Modify first select statement like this...............

Re: need help...?

Former Member — Thu, 07 Jun 2007 06:33:19 GMT

Hey Ruchika,

Thanx for ur help...iam just trying this...also is it possible for us to do all this through one internal table and through one select statement using joins...in one select statement we can have more than one join...am i right...

But I am stilll trying...thanx again Ruchi...I appreciate...

Re: need help...?

Former Member — Thu, 07 Jun 2007 06:50:27 GMT

Hi jimmy,

Yes you are right. but its advisable to avoid joins . but its your wish. if you want to use join you can use , becouse now you have common fields between these tables.

good luck

Ruchika