Credit Exposure - Line Item list

[Former Member]

Dear Friends,

We need to have a detailed line item break up of the Credit Exposure, that is displayed in FD32. We can have a break up in terms of Receivables, Sales Values and Special Liabilities, but need a more detailed report as to what all line items are included in the above. Is there any report available for this or any workaround that would provide the detailed information.

Thanks !

[cassio_goulart]

          Ok Raajive,

     If work properly, please mark my answer how correct ou helpful.

Best Regards,

Cassio Goulart

[Former Member]

Sure Cassio will do that.

Thanks !

[cassio_goulart]

          Hi Raajive, how are you my friend?

     So, exist a standard report that you can use for see the Sales Vales for a credit account. The report is the RVKRED88 - SD: Simulation: Reorganization of SD credit data after updating errors. This report was bulding up tables: S066 - Open orders: credit management and S067 - Open deliveries/billing documents (KM).

     I hope that the up advice can help you.

Best Regards.

Cassio Goulart

[Former Member]

Hi Cassio,

Thank you for your help, I hope this should work....we shall try this out.

Regards,

Raajive Nayar

[Former Member]

Hi Raajive,

As per my understanding, there is no standard report to provide such details for each category. However, there is work-around to get the required detail in SAP.

Receivables - This is the balance of the customer account open items (excluding special GL transactions). We can get it by transaction FBL5N or BSID table (only normal items).

Special liabilities - This is total of the open special G/L transactions into customer account. We can get it again by transaction FBL5N or BSID table (by selecting only Special GL transactions check-box)

Sales Value - It comprises of total amount of all orders placed by the customer, which have not been transferred to FI. It can be found out from relevant SD related tables.

I hope it helps.

Regards,

Gaurav

[Former Member]

Hi Gaurav,

Thanks for the prompt response. I understand that regarding 'Sales Values' the Credit Exposure includes both - Sales Order Values for Confirmed Quantities, yet to delivered and invoiced as well as Values of Goods Delivered but not yet invoiced. Is this Correct ?

From VA03 we can get the Sales Order Values for Confirmed Quantities yet to be delivered and invoiced, how about the values of Goods Delivered but not yet Invoiced ? How do we get this ?

Thanks!

[Former Member]

Hi Raajive,

Sales Values in Credit exposure comprises of three activities - Sales Order Values for Confirmed Quantities, yet to delivered and invoiced, Values of Goods Delivered but not yet invoiced and values of Billing documents (FI document not created).

Please check t-codes VF04 & VL06O as well as VBUP and VBUK tables. These should provide the required details.

Regards,

Gaurav

[Former Member]

Hi Gaurav,

Thank you so much for the response.

Is it possible to get the values and details of outbound deliveries in the report or table form from VL06O ? If yes how can this be ?

Thanks once again..

Regards,

Raajive Nayar

[Former Member]

Hi Raajive,

Once you enter t-code VL06O, select the option . in the next screen, give the appropriate input parameters. There is one box "Status: Outb. Delivs' there.

Here you can specifiy the billing status (not yet processed/partially processed/completely processed) as per your requirement. The output will come in below format which can be modified using option to add or remove data fields. The output can be saved in excel as well for further processing.

Output screen

Saving in excel

Hopefully it helps.

Regards,

Gaurav