cancel
Showing results for 
Search instead for 
Did you mean: 

grpo pld

former_member325312
Active Contributor
0 Kudos

hello sap experts

how can i track this fields in grpo pld

Item Code Item Description UOM Qty Billed QTY Recived QTY Rejected QTY Accepted Rejection Code

Reason for Rejection

thanks in advance

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Jennifer Anderson,

IF you need to print the Item Code, Item Description, UOM, Qty Billed, QTY Recived, QTY Rejected, QTY Accepted, Rejection Code in Rows.

Try this,

->> Open the GRPO PLD and Create Database Fields and 1 Formula Field.

Field_1-> Item Code

Table -> PDN1 - Goods Receipt PO - Rows. Column -> ItemCode.

Field_2-> Item Discription

Table -> PDN1 - Goods Receipt PO - Rows. Column -> Dscription.

Field_3-> Received Quantity (or) QTY Accepted

Table -> PDN1 - Goods Receipt PO - Rows. Column -> Quantity.

Field_4-> UOM

Table -> PDN1 - Goods Receipt PO - Rows. Column -> unitMsr - Unit.

Field_5-> PO Quantity

Table -> PDN1 - Goods Receipt PO - Rows. Column -> BaseRef.

Field_6-> Rejected Quantity = (PO Quantity-Received Quantity)

->> Create 1 Formula Field and assign the formula for Rejected Quantity.

for example: Formula:

 Field_5- Field_3

Regards,

Madhan.

Former Member
0 Kudos

H!

Wht u mean by track in PLD ?

Do u want any query report ?

former_member325312
Active Contributor
0 Kudos

hello thanga raj

i dont want the query pld i need to track those fields in pld if not then give me a query

Edited by: Jennifer Anderson on Aug 25, 2009 6:51 AM

Former Member
0 Kudos

Hi!

It is very much possible to get the fields in PLD

itemcode

ItemDescp

UOM

Quantity

--Billed Qty ??

--Receivd Qty ??

--Rejected QTY ??

--Accepted Rejection Code ?? all these are UDF's in Row level ?

if so also we can get it in PLD.

former_member325312
Active Contributor
0 Kudos

No thanga raj those are not row level udfs and not header level udfs but from where should i track that fields in pld of grpo

Former Member
0 Kudos

Hi!

is these fields are available in GRPO Table first ?

Do u giving any inputs for these fields manually ?

former_member325312
Active Contributor
0 Kudos

hello no i have no given any i/p fields but how to track those

for example i think quantity billed(grpo qty),quantity received(grn quantity i think so) and quantity rejected is ((grpo qty-grn quantity ) and qty accepted (quantity received) iam not sure but iam thinking in this way

Former Member
0 Kudos

Hi!

I understood, i belive it will be like this.

quantity billed (Invoice qty),

quantity received(grpo quantity) and

quantity rejected is ((PO qty-GRPO quantity ) and

qty accepted (Invoice qty received) .

What ever it is, it can be brought in 2 ways,

First.

Add Appropriate UDF in Marketing Doc Rows and Using FMS fill those Fields automatically. We can get it in PLD

Second.

Without UDF's we can achive this only by a Query Report. Create a Query PLD for the same.

As of now, without this two we can't get the info in PLD

former_member325312
Active Contributor
0 Kudos

k tanga raj canu send me the query regarding this

Former Member
0 Kudos

Hi!

Fine. I will do that and update the thread.

Former Member
0 Kudos

Hi!

Try this,

select
G0.Docnum,
G1.ItemCode,
G1.Dscription,
sum(G1.Quantity) as [GRPO Quantity],
sum(P1.Quantity) as [Invoice Qty],

from 
OPDN G0,PDN1 G1 full outer join OPCH P0 on P0.Docentry=G1.TrgetEntry,PCH1 P1
where
G0.Docentry=G1.Docentry and
P0.Docentry=P1.Docentry
Group by
G0.Docnum,
G1.ItemCode,
G1.Dscription

This is the basic query for your report. Try to get Accepted,Rejected Qty using combination of formulas.

Eg; Rejected Qty : sum(G1.Quantity)-sum(P1.Quantity) as RejectedQty