generic Extraction

[Former Member]

dear experts,

i need the contract information fields in reporting lelel.from the period apr 2010 onwards

The contract information is stored in Table KONP ,

but the data is not populated to the respected fields,

so,want to load the data to the fields?

how to load the data? i had found there is no standard extractor to bring the data from KONP table?

if am going to crate the generis data source and extract the data from Apr 2010 onwards mean,

whcih delta method is better?

and i have a anothere fileds product faily ,i wan tto append this field to 0MAT_TEXT

how to write logic plz give the solution for the above

plz,,.....

[Former Member]

Hi,

are you sure regarding table KONP. KONP is the condition table of the pricing process. Contract data is stored in VBAK and VBAP with a special order type.

Cheers

J.

[Former Member]

Hi ,

tanx for ur reply,

actulayy the contract information am talking about master data,(contract type contract number contract name)

the contract price information may be is tehre in terms of condition value.

i want to fet the information from KONP table whcih is already consist of these filds.without populating data,

reagrds

[Former Member]

i have contract type and contract no in one table but the cointract name is not there in the table

plz help how to make in one data source

plz guide me..

regards

[Former Member]

Hi,

I don't understand your requirement. KONP is a table which is filled with data during pricing process. The key is the the number of condition and a running number. I don't think it is a good idea to populate this fields instead of using the priicing process.

Cheers

J

[Former Member]

o.k fine completetely agree ,

i want tthe field in reporting level

contract type contract name contract number contract price

wher we can find out these fields in r/3 and how do i extract the data?

regards

[Former Member]

hai all,

plz anyone help me how do i acheive this ,our func consulatnt says,thses information not having the system,but is there some othere termnology,

vendor agreemnr agre type

how do i relate the key nformation in generic as well as in cube level

need to design 1:1 or 1:many?

regards

[Former Member]

hai everyone,

the contract information is there in VBAK,VBAP

i want tthe information from item level so i have to choose VBAP in t code va45n

in the sales doc type i have choosen zwk1 mat value contrcat

it takes you another screen wher i able to see list of contract,

but i could not able to find the corect field

when i take the sale doc no into se16 it showing table VBAP select entries

where i can find the exact information?

regarsd