topic PGI DataBase tables in Application Development and Automation Discussions

PGI DataBase tables

sravya_ch — Tue, 22 Jun 2010 07:13:17 GMT

Hi All

My Requirement: I need to get PGI done delivery of specific date (ex :today(22.06.2010))

Can any one suggest me the database table .

I know that we can use VBFA , MKPF .

Up to my idea in MKPF reverse PGI data is not saved (if its saved plz do let me the condition how to get the data(know I am using date).

As well if its VBFA (please do tell me the specific condition where I can get the data )

I have in selection screen :BUKRS(Company code)

VKORG(Sales Organization)

KUNNR(Customer Number)

Sravya

Re: PGI DataBase tables

Former Member — Tue, 22 Jun 2010 07:26:46 GMT

Hi,

Get delivery details from LIKP & LIKP based on input parameters VKORG and erdat.

Filter the records of customer by reading Partner table (VBPA).

For getting the PGI Number fetch data from VBFA

Select vbeln posnn
from vbfa
where vbelv = <likp-deliveryno>
and   posnv = <lips-item no>
and   vbtyp_n = 'R'. "Pass R for PGI and 'h' for Reversed PGI"

Get PGI document details by fetching data from MKPF.

pass vbfa-vbeln as input parameter for MKPF selection.

Regards

Vinod