Reg: Billing Plan Report

[Former Member]

Hi

I got one FS from Client side regarding Billing Report i unable to write the logic for some Fields, please find attach the Ouput Format required from Clinet.

Sales Order Number (VBAK-VBELN)

Project Definition Number

Project Definition (from project)

Project Manager (person responsible from project)

Customer Number

Customer Name

Order Type

Sales Order Line

Billing Plan Item Number

Billing Item Milestone Description (from Project)

Billing Plan ItemValue

Billing Item Currency

Billing Block Status

Billing Plan Item Billing Type

Milestone Planned Billing Date

Milestone Release Confirmation Date

Billing Plan Item Invoice Number

I am unable to find the logic for the Below output Feilds

Billing Item Milestone Description (from Project)

Milestone Planned Billing Date

Milestone Release Confirmation Date

Billing Plan Item Invoice Number

Please let know which Table which will fetch this details

The Input for this report is Plant ( Mandatory Feild) and optional Feild are Sale order No and Project Definition No.

Kindly help me out SAP GURUS

Regards

[Former Member · Accepted solution]

Hi,

The logic for Billing plan item invoice number is:

Pass the sales order number into VBKD table.Execute.

Select your lineitem and fetch the value if Billing plan number(FPLNR).

To know the number of items in billing plan enter this FPLNR into FPLT Table.Execute.

Pass the FPLNR into VBFA table and Execute.

You will find the invoice numbers for your billing plan items.

Regards,

Krishna.

[Former Member · Accepted solution]

Hi

Thanks A lot can u please let me know the logic for getting other feilds

Billing Item Milestone Description (from Project)

Milestone Planned Billing Date

Milestone Release Confirmation Date

Thanks & Regards

[Former Member · Accepted solution]

Hi,

In which T.code you are entering the fields that are specified by you.

I cannot find them in order.

Could you please tell me so that I will try here and provide logic for them also.

Regards,

Krishna.

[Former Member · Accepted solution]

Hi

I am developing a ZREPORT report ....i need to write a FS for that same......feilds which i have mentioned is the output of that report......Input will be PLANT....i will running this report againt each plant.........

Reagrds

[Former Member · Accepted solution]

Hi Krishna,

The logic to retreive Invoices for Billing plan line itmes is really helpfull.

Keep up your great work.

Thanks & Regards,

Karthik