cancel
Showing results for 
Search instead for 
Did you mean: 

Purchase info record extraction logic

rajesh_r11
Participant
0 Kudos

Hi,

Iam in process of Data migration for Purchase inforec from SAP 4.7 to ECC 6,

So please provide your inputs on logic for extracting Purchase info record -

Tables Used:

1) ENIA

2) EINE

3) A017

4) KONP,

The problem is I need the link between EINE and A017(which field is used as reference between this 2 tables for extracting conditions)

Thanks

Rajesh. R

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi Rajesh,

I have to work on the similar kind of requirement. How did you manage to do the conversion for purchase info records with conditions.

kindly suggest your approach.

Thanks,

bh_hir

Former Member
0 Kudos

create a query using SQVI transction link the tables EINA EINE A017 and KONP.

Link the required fields between the tables.

Input the data like info recod or plant materail or vendor and extract the required files in KONP and A017

Former Member
0 Kudos

From EINE you will get the inforecord number and Infotype,purchase orgainsation,plant etc...for the same inforecord number you will get the material code & vendor from EINA...now in A017 enter the vendor and material from EINA & other details from EINE you can get the required result

Regards,

Indranil

adwait_bachuwar
Active Contributor
0 Kudos

Hi,

to fetch the data related to the info records you need to add the eine and eina fields that is vendor, plant, material, purchase organization, info record type (std, s/c, pipeline or consignment but these are stored in numbers). these values are put together will give you the basic price / gross price condition record no. this you have to pass into KONP. one more thing this will have the validity period for the basic price. and under one condition record no there might be more conditions maintained such as discount, surcharge, freights etc.

regards,

Adwait Bachuwar