Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

what is a purchasing data analysis report

Former Member

‎2007 May 24 6:43 AM

0 Likes
451

hell all,

can some one plz tell me what a purchasing data analysis report is?

thanks in advance,

seenu

Message was edited by:

Seenu SAP

hell all,

can some one plz tell me what a purchasing data analysis report is?

thanks in advance,

seenu

Message was edited by:

Seenu SAP

Reply
1 REPLY 1
Read only

Former Member

‎2007 May 24 6:48 AM

0 Likes
402

Hi

RBKP is the Invoice(vendor) header Table

RSEG is the item table

<b>Join RBKP and RSEG and link the RSEg EBELn and EBELP fields with the EKBE table</b>

VTTK is the Shipment Header table and VTTP is the Item table

VTTP has VBELN (DElivery Field) Like this like:

Take the EKKN (po Account assignment) -VBELN field(Sales Order) and POSNR (item) fields and pass to LIPS to get the delivery which is nothing but the VTTP delivery.

VTTP-VBELN pass to LIPS, take VGBEL and VGPOS (sales Order details) and pass them to EKKN Table and Take the PO and Item details.

Reward points if useful

Regards

Anji