Skip to Content
avatar image
Former Member

Reg: Billing Plan Report

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jun 09, 2009 at 02:15 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Krishna,

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

      Keep up your great work.

      Thanks & Regards,

      Karthik