topic Re: report not picking correct data in Application Development and Automation Discussions

report not picking correct data

former_member630092 — Thu, 10 Sep 2009 07:59:59 GMT

Is it possible for vendor aging report to dispaly for Particular Vendor the

amount ( bsik-dmbtr ) using Purchase organization field.

There are two Purchase Organizations C100 ( for CPU ) and D100 ( for Monitor ) in my case.

data is picked from bsik , lfm1 ,lfa1 tables.

Example : if D100 is for Monitor-screen and has amount 1000.

c100 is for CPU and has amount 2000.

In that case report with Vendor , comp code, Pur. Orga and period should disply

c100 amount 2000.

D100 amount 1000.

my report is showing that vendor is existing for C100 or D100.

but for vendor that exist in both C100 and D100. ( Say vendor number 200 )

the amount is coming for vendor number 200 in c100 and d100 equal to 1000.

but it should come c100 = 2000

and for d100 = 1000.

Re: report not picking correct data

Former Member — Thu, 10 Sep 2009 10:27:00 GMT

Hi,

Your question is not clear.

In case you are using loop and populating data into a internal table compare all key fields.

Regards,

Amit

Re: report not picking correct data

former_member630092 — Thu, 10 Sep 2009 11:48:31 GMT

My question is :

Two Purchase Organizations C100 ( for CPU ) and D100 ( for Monitor ) .

Example : D100 has amount 1000. And C100 has amount 2000.

Single vendor is connected to C100 or D100

BSIK-DMBTR (Total) for vendor number 200 in c100 and d100 is coming 1000.

but it should come C100 = 2000

and for D100 = 1000.

I want a way in which I can first check ekorg field and then bsik-dmbtr

Field so that amount linked in C100 And D100 should come.

Re: report not picking correct data

former_member630092 — Sun, 13 Sep 2009 17:16:43 GMT

need the document related to vendor's liabilities aging report and addedc new field Pur Org to show dmbtr amount related to pur orga with particular vendor ?

Re: report not picking correct data

Clemenss — Sun, 13 Sep 2009 17:43:37 GMT

Hi Ravi,

I don't know what kind of programming you did. I remember a similarr requirement where we used a SELEC ... FOR ALL ENTRIES IN approach and got only one record with specific amount returned although there were two of the same amount - they are put together as duplicates by the data base.

Documentation on "SELECT... FOR ALL ENTRIES IN itab WHERE cond..." says "Duplicate lines are automatically eliminated from the result set"

Something I needed some days to believe...

Regards,

Clemens

Re: report not picking correct data

former_member630092 — Mon, 14 Sep 2009 05:11:09 GMT

Thanks.

My report is working fine with vendor related to single Purchase Organization.

But when one vendor is related to different purchase Organizations in that case report must pick the vendor - Purchase Organization -amount .

Suppose vendor 123 in puchase organizatio D100 has some PO teated amount 1000/-.

But vendor 123 in Purchase Organization C100 has amount 2000.

Then 123 with D100 is 1000/-

and 123 with C100 is 2000/-.

I think my report is showing Purchase Organization related to vendor.

but it is not picking the amount related to Purchase Ortganization and vendor.

actually amount picking table BSIK has no Purchase Organization Firld.

This may be the reason . how to resolve this ??

i have doubt only with multiople Purchase Organization .

Thanks

How can i check

Re: report not picking correct data

Former Member — Mon, 14 Sep 2009 05:15:28 GMT

Hi,

Using which tcode are you assigning differnt amount to the same vendor for different purchase organizations?

Regards,

Vikranth

Re: report not picking correct data

former_member630092 — Mon, 14 Sep 2009 05:34:28 GMT

I am not sure about this point in vendor aging report. i have added a pur Organization field in this report.

I am asking

If vendor no 123 is in D100 and C100 ( D100 and C100 are Pur Organizations )

Initially no transaction is there.

Suppose vendor no 123 created a Puchase Order of 500 /- using D100 Purchase Organization in duration 01.01.2008

to 01.01.2009

But vendor no 123 in Purchase Organization C100 has no transaction.

Then 123 with D100 is sould show 500/-

and 123 with C100 is 0 /-.

output of this report should show above results ?

If output is like this then how to rectify my report ?

Or it shoud show the result like this

Then 123 with D100 is sould show 500/-

and 123 with C100 is 500 /-

My output is showing like above same

Thanks

Re: report not picking correct data

former_member630092 — Mon, 14 Sep 2009 08:54:16 GMT

Hi,

i need some more information to completye my report .

Is it true that same vendor for different purchase organizations can have differnt amount related to it.

1) Can we create diffferent vendor number of same organization if vendor is having same material to different Purchase Organization ?

2) Can we create diffferent vendor number of same organization if vendor is having different material to different Purchase organizations ?

which one is true 1 or 2 or both ?

Thanks

Re: report not picking correct data

former_member630092 — Tue, 15 Sep 2009 04:57:43 GMT

I am not able to find the relevent information regarding my previous post.

Do reply .

Thanks

Re: report not picking correct data

former_member630092 — Wed, 16 Sep 2009 05:41:08 GMT

Can we create diffferent vendor number if vendor is linked to having different Purchase organizations with same material or with diferent material?

Example : Say Vendor (888) from ABC company is providing material to XYZ company with Pur Org D100.

and same vendor (888) from ABC company is providing material to XYZ company with Pur Org C100.

Main Point here is Purchase Organization.

Can we create another vendor (999) from ABC company to provide material to XYZ company with Pur Org C100.

want to keep a track about Amount of vendor of ABC company linked to Pur Org C100 and D100 separetly.

Or any other sol

Thanks.

Re: report not picking correct data

former_member630092 — Fri, 18 Sep 2009 08:42:24 GMT

got the sol