topic Tables in Application Development and Automation Discussions

Tables

Former Member — Wed, 30 Nov 2005 04:51:48 GMT

I have to display the service order and sales order in one report. For I have take entries from table VBAP,VBAK and FPLT.

I need the primary key which link table VBAP,VBAK and FPLT. because i have take entries for the billing date from FPLT-AFDAT based on that customer no(VIQMEL)or service order no(AUFK) or sales order no(VBAK).And i am not able to find any primary key for retrieve the billing date

PL reply imm

Re: Tables

Former Member — Wed, 30 Nov 2005 05:08:40 GMT

Hi jayasree,

check it VBKD-FKDAT .

regards,

srinivas.oleti

Re: Tables

Former Member — Wed, 30 Nov 2005 05:43:51 GMT

Hi jayshree,

You must be aware of header table and details table. here the vbak is header table and vbap is details table so in these both tables the primary key is same which is VBELN you can link each other with VBELN.

Same way FPLA and FPLT are the heder and details table consecutively so FPLNR is there primary key you cna relate through the same

If the reply is useful then reward the points

regards,

Siddarth