I need billing plan detaisl from FPLT TABLE.

[Former Member]

I have sales order no VBAK-VBELN.

I need billing plan item detaisl from FPLT TABLE.

HOW TO LINK THESE 2 TABLES to get these billing [plan item details records

Edited by: abap_friends on Jul 8, 2010 8:17 AM

[Former Member]

Hi,

Use following LInk : VBAK-RPLNR = FPLT-FPLNR.

Regards

Vinod

[Former Member]

hI vonodv thank for ur reply.

i have item details in my fplt for sales oprder no.

But vbak -fplnr is empty.

can i have any function module to get these item details

[Former Member]

Hi,

As far as I know, the link for FPLT is VBAK-RPLNR. Have you checked the value in the field FPLT-FPLNR? This value should correspond to some record in VBAK.

For the Order number in VA02 -> header -> Payment card tab are you getting the billing plan details ?

Regards

Vinod

[Former Member]

Hi,

try with this fm

CALL FUNCTION 'SD_SALES_BILLINGPLAN_READ'

EXPORTING

i_vbeln = ip_docnum

i_posnr = ip_posnr

TABLES

e_fplt = it_fplt

EXCEPTIONS

no_billingplan_allowed = 1

no_billingplan_found = 2

OTHERS = 3

or

SELECT posnr fplnr INTO TABLE i_fplnr

FROM vbkd

WHERE vbeln EQ ip_docnum.

IF NOT i_fplnr[] IS INITIAL.

SELECT fplnr mlstn fkdat INTO TABLE i_mlstn FROM fplt

FOR ALL ENTRIES IN i_fplnr

WHERE fplnr EQ i_fplnr-fplnr.

Endif.

Regards,

Carlos

[Former Member]

Hi,

Instead of sales document header table VBAk, you would have to take VBFA (Sales Document Flow) which you can easily link with table FPLT field FPLNR.

for example:

Join tables FPLT and VBFA on the common field name FPLNR.

Hope this works for you.,

Regards,

Mansi.