Problems with Selection for Werks from Eine

[Former Member]

Hi all

I surch for an way to get the Werks for Eine.

I know

EKPO

EKKO-BSTYP

LFA1

LFM1

EKKO

EKPO

EKPO

EKPO

EBAN

MT06E

EINA

EINE

EKPO

KOMP

But there is no way to select werks.

a bit coding

SELECT * FROM EINE

WHERE INFNR = I_EINE-INFNR

AND EKORG = I_EINE-EKORG.

endselect.

Chris

[Former Member]

Hi Christian,

What values do you have?

What Values do you want?

Regards,

Ravi

[RichHeilman]

WERKS is in the EINE table in my 46c system. Is it not in your system?

SELECT * FROM EINE
      WHERE INFNR = I_EINE-INFNR
        AND EKORG = I_EINE-EKORG
<b>        and WERKS in S_WERKS.</b>

If your system is not configured to have plant specific PIRs, then this field will be blank.

Regards,

Rich Heilman

[Former Member]

The Problem is not the selection. I need Werks for the selection, but i can not find the connection.

[Former Member]

hii

there is a WERKS FIELD IN EINE

SELECT * FROM EINE

WHERE INFNR = I_EINE-INFNR

AND EKORG = I_EINE-EKORG AND

WERKS = I_EINE-WERKS .

ReGARDS

Naresh

[Former Member]

there is a WERKS FIELD IN EINE

SELECT * FROM EINE

WHERE INFNR = I_EINE-INFNR

AND EKORG = I_EINE-EKORG AND

WERKS = I_EINE-WERKS

a nice idear. But its not correct.

A sample

SELECT * FROM EINE

WHERE INFNR = I_EINE-INFNR

AND EKORG = I_EINE-EKORG AND

endselect. -> i get all entrys from Eine

But i need a special WERKS

[Former Member]

Select single * from EINE

where infnr eq l_infnr

and ekorg eq l_ekorg

and esokz eq k_std

and werks ne space.

?

[Former Member]

If you have vendor information, then you can get WERKS from LFA1.

Regards,

Ravi

[Former Member]

The Point is this is not the correct Werks.

In the Eine is an entry for Werk 100,200,300

But in the LFA1 is the Werk 500.

[Former Member]

If you have Purchase order Item details, the you can get the WERKS from EKPO.

select single werks from ekpo into v_werks

where ebeln = <PO> and ebelp = <POITEM>.

then you can use it on eina.

Regards,

Ravi

[Former Member]

its correct to.

But The Werks in the purchase order is not the correct one.

Purchase Order 125

Eine 130

[Former Member]

hii

try this

SELECT WERKS ..

FROM LFA1

INTO IT_LFA1

WHERE WERKS IN S_WERKS .

IF SY-SUBRC = 0.

SELECT * FROM EINE

FOR ALL ENTRIES IN IT_LFA1

WHERE INFNR = I_EINE-INFNR

AND EKORG = I_EINE-EKORG AND

WERKS IN S_WERKS .

ENDIF .

THIS WAY YOU WILL HAVE FIELDS IN BOTH .

[Former Member]

Is ok, but ..

In the LFa1 the Werk is 500

in the Eine the Werk is 100.

The would be no result

Again.

On with way i can get WErks for the selection from Eine

SELECT WERKS ..

FROM LFA1

INTO IT_LFA1

WHERE WERKS IN S_WERKS .

IF SY-SUBRC = 0.

SELECT * FROM EINE

FOR ALL ENTRIES IN IT_LFA1

WHERE INFNR = I_EINE-INFNR

AND EKORG = I_EINE-EKORG AND

WERKS IN S_WERKS .

ENDIF .

[RichHeilman]

If there is not plant specific PIR for you vendor for plant 500, then one must be created in order to make the link. It appears that the PIRs were not created for this plant, just the others. The PIR for plant 500 will need to be created.

Regards,

Rich Heilman

[RichHeilman]

You may be able to use transaction code MEMASSIN to do a Mass maintenance of the PIRs to copy from one plant to the other.

Regards,

Rich Heilman

[Former Member]

Use EINE-INFNR = EKPO-INFNR to link EKPO to EINE