SO billing plan

[Former Member]

Hi experts,

Iam trying to extract the sales order details.

Where can i find <b>"Billing date"</b> and <b>"Billing Value"</b> for parituclar item?

Iam looking for tables OR FMs.

Billing plan: va02->so number->double click on item->billing plan tab->billing dates.

Thanks

kaki

[Former Member]

Hi experts,

Iam trying to extract the sales order details.

Where can i find <b>"Billing date"</b> and <b>"Billing Value"</b> for parituclar item?

Iam looking for tables OR FMs.

Billing plan: va02->so number->double click on item->billing plan tab->billing dates.

Thanks

kaki

[Former Member]

Hi,

For the billing date check the field VBKD-FKDAT...

Check the table FPLA for billing plan details..

Thanks,

Naren

[Former Member]

Hi Naren,

Is there any function modules existing for my requirement.

Iam not getting proproper data in VBKD...

Thanks

kaki

[Former Member]

Hi,

Check this FMs SD_SALES_BILLINGPLAN_READ..SD_BILLINGPLAN_POSITION_READ..

Also check the tables FPLA, FPLT..

Thanks,

Naren

Message was edited by: Narendran Muthukumaran

[Former Member]

Hi,

Try this..For the function module SD_SALES_BILLINGPLAN_READ to work you have to use the function module SD_SALES_DOCUMENT_READ..

TABLES: fpla.

PARAMETER: vbeln TYPE vbak-vbeln.

DATA: BEGIN OF ifplt OCCURS 10.

INCLUDE STRUCTURE fpltvb.

DATA: END OF ifplt.

CALL FUNCTION 'SD_SALES_DOCUMENT_READ'

EXPORTING

document_number = vbeln

EXCEPTIONS

error_message = 01.

CALL FUNCTION 'SD_SALES_BILLINGPLAN_READ'

EXPORTING

i_vbeln = vbeln

i_posnr = '000010'

IMPORTING

e_fpla = fpla

TABLES

e_fplt = ifplt

EXCEPTIONS

no_billingplan_allowed = 1

no_billingplan_found = 2

OTHERS = 3.

Thanks,

Naren

[uwe_schieferstein]

Hello Kaki

I assume that the fields you are looking for are in table FPLT (Billing Plan: Dates -> per item):

- FKDAT (Settlement date for deadline)
- FAKWR (Value to be billed/calc. on date in billing/invoice plan)

The billing plan dates per item can be read using function module <b>SD_SALES_BILLINGPLAN_READ</b>. This function module has the following check at the beginning:

  IF I_VBELN NE VBAK-VBELN.
    MESSAGE A044 WITH I_VBELN VBAK-VBELN.
  ENDIF.

Thus, before calling SD_SALES_BILLINGPLAN_READ you have to call

SD_SALES_DOCUMENT_READ

to fill the global variable VBAK in the function group.

A few final remarks:

- As already mentioned the billing plan per item (or header) can be found in VBKD-FPLNR

- The billing plan details are in FPLA (header) and FPLT (dates), credit card details can be found in FPLTC

- If an item billing plan is linked to the header billing plan then FPLA-RFPLN is filled with the header billing plan number

To search for billing plan related function modules use either

- SD_BILLING* or

- BILLING_*

Regards

Uwe

[Former Member]

Hi Naren & Uwe,

Many thanks for the correct replies.Iam giving points to both of you.

Cheers

kaki