Standard report in sd, document type "RV"

[Former Member]

Hi

Please clarify the below query

1.any standard report to view sales order status along billed & unbilled amount.

2.Any standard report to view progress billing status

3. Whether it is possible to create new document type same as ( sap standard RV)

If yes any implication steps please

Regards

Guna

[Former Member]

Answered

[Former Member]

Hello,

There are no standard consolidated report available for this requirement.

As per the earlier suggestion, you may check with ABAP team for developing a Z* report.

S_ALR_87012332 - This report will give you statement of customer wise / Vendor wise / GL wise accounts

S_ALR_87012168 - Due date analysis for customer open items

S_ALR_87012172 - This report will give you balance at the period start, debit total & credit total for the reporting period and closing balance at the end of reporting period

You may create new accounting document type. There is implication of this, provided you have maintined the number ranges and other details correctly.

Please check with your FI team for more help on this.

Regards,

SAM

[jpfriends079]

1.any standard report to view sales order status along billed & unbilled amount.

Create a query with tables VBUK, VBAK & VBFA

In VBFA, you can get Quantity, Base Unit, Reference value & Subs.doc.categ.(M for billing)

2.Any standard report to view progress billing status

Check with Table VBUK. provide desired list of Invoice number in VBELN field.

Please note there are not standard report for either of the report you desire.

3. Whether it is possible to create new document type same as ( sap standard RV)
If yes any implication steps please

Yes, you can have one. Just check with FI guy for the other related config required for it, like automatic account posting, posting keys, etc.

From SD. pioint of view, you need to define that in desired billing doc type's (VOFA) Document Type, general control.

Regards

JP

[Former Member]

Any update

[Former Member]

Hi

Thanks

Description of SD billing items not displayed in t_code FBL5N.

[Former Member]

Sales document Description is not showing in FBL5N report

[jpfriends079]

In your copying controls, for Billing (VTFL or VTFA) based on your requirement in header maintain allocation or reference number.

Regards

JP