Application Development 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
Showing results for 
Search instead for 
Did you mean: 

Tables

Former Member
0 Kudos

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

2 REPLIES 2

Former Member
0 Kudos

Hi jayasree,

check it VBKD-FKDAT .

regards,

srinivas.oleti

Former Member
0 Kudos

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