Credit block and release Date and time

[noumanahmed_khan]

Dear All,

I require a report which can display credit block status date and time and credit release status date and time for sales order. I have gone through the report RSSCD100 with object class VERKBELEG.It is not fullfilling the requirement as it only display change information.

If customer has already exceeded the credit limit and new sales order has been generated then this report will reflect its blocked status.

Kinldy help

Thank you,

NoMi

[Former Member · Accepted solution]

Hi,

As far as I can understand your requirement, you need the following info:

1. Date and time when the sales order passes into credit block

2. Date and time when the above credit block is released.

According to me there is no standard report that can give you both the above information, so you will have to get it developed. In the standard business scenario, the system passes a sales order into credit block at the time of saving the sales order, if the customer has exceeded the credit limit. So you can use the Sales Order creation date and time (VBAK-ERDAT and VBAK-ERZET) as the date and time when the sales order passed into credit block.

For getting the date and time of the release of credit block, you can use tables CDHDR and CDPOS which will give you the exact change date and time.

Hope this helps

Regards.

[Former Member · Accepted solution]

I dont think there is any standard report for this and also you cannot do any table joins and get this data, because these details are not recorded any where.

Try this: Get all these four fields added to Order - Header - Additional data B. Populate them as and when the order goes to credit block or get released from credit block. Then from VBAK you can read this fields and get the details for all the orders or for the required orders.

Regards

Sai

[saif_sabri]

Hello Dear

Customer level In the customer master record, you can specify a billing block.

From the transaction Change Customer Master (VD02), use the menu path

Extras ➢ Blocking Data, and add a billing block for a particular sales area or for

all sales areas. An alternative transaction for setting blocks is VD05

The billing blocks will be applicable for all relevant documents for this customer.

billing block G1 has been applied in the customer master record in the blocking data

Block A Customer (VD05) This transaction is used to block a customer from

transacting business with your organization. You have options

to block sales orders, delivery, and billing documents in some or all the sales areas.

Regards from Pakistan

Edited by: Saif Ali Sabri on May 20, 2010 3:17 PM

Edited by: Saif Ali Sabri on May 20, 2010 3:18 PM

[Former Member]

Just one question. Why cant you use VKM4?

[noumanahmed_khan]

Because it doesnu2019t display time of creation and change.

[Former Member]

Hi,

Reorganization credit data SD

The report enables you to reorganize open credit, delivery and billing document

values. It is used, for example, when updating errors occur.

RVKRED08 Checking sales documents which reach the credit horizon

The report checks all sales documents, which reach the dynamic credit check

horizon, as new. The report runs periodically, and should run at the start of a

period. The period for the u2018date of the next credit checku2019 is proposed from the

current date, with the help of the period split for open sales order values.

RVKRED09 Checking the credit documents from credit view

Released documents are only checked if the validity period for the release has

run out (number days).

RVKRED88 Simulation reorganization credit data SD

In order to execute a report

1. Choose System and Services and Reporting.

2. Enter the name of the report.

3. Choose Program andExecute.

4. Enter the selection criteria.

5. Choose Program Execute or Program Execute and Print.

REgards,

Krishna O

[noumanahmed_khan]

Dear krisha,

None of the report mentioned fullfil my question requirement..

Thanks

NoMi

[Former Member]

Hi,

IF it is not mentioned in single program .

You can develop a query by using multiple program. Please find the list of programs for CM

+Reports for Credit Management+

The following table provides an overview of all the reports available to you in the area of credit

management

Program Function

RFDKLI10 Customers with missing credit data

This report checks the data for the credit limit for completeness, and produces

the corresponding error lists. These can be used to re-maintain the

corresponding definitions manually, or per Batch Input.

RFDKLI20 Reorganization of credit limit for customers

This report enables you to reorganize the credit limit information in the control

areas.

RFDKLI30 Short overview credit limit

The report lists the central and control area-related data per customer.

RFDKLI40 Overview credit limit

The report provides you with an extensive overview of the customeru2019s credit

situation.

RFDKLI41 Credit master sheet

The credit master sheet enables you to display and print out the customer

master data for a single account, which is needed for the area of credit

management.

RFDKLI42 Early warning list

The early warning list enables you to display and print out customers in credit

management, who are viewed as critical customers in the area of credit checks

in SD.

RFDKLI43 Master data list

The master data list enables you to display and print out customersu2019 credit cards.

In particular, you can display information not contained in the standard system,

for example, user-defined fields or external data, which you have created with

specific additonal software.

RFDKLI50 Mass change credit limit data

This report allows quick mass change for master data in credit management.

RFDKLIAB Change display, credit management

With this report, you can display changes for credit management master data for

all accounts.

RVKRED06 Checking blocked credit documents

The report checks all blocked documents from credit view. The report is started

in the background, and should run after the incoming payments programs.

FI/SD - Credit Management/Risk Management SAP AG

Reports for Credit Management

RVKRED77 Reorganization credit data SD

The report enables you to reorganize open credit, delivery and billing document

values. It is used, for example, when updating errors occur.

RVKRED08 Checking sales documents which reach the credit horizon

The report checks all sales documents, which reach the dynamic credit check

horizon, as new. The report runs periodically, and should run at the start of a

period. The period for the u2018date of the next credit checku2019 is proposed from the

current date, with the help of the period split for open sales order values.

RVKRED09 Checking the credit documents from credit view

Released documents are only checked if the validity period for the release has

run out (number days).

RVKRED88 Simulation reorganization credit data SD

REgards,

Krishna O

Edited by: Krishna O on May 20, 2010 11:30 AM

[noumanahmed_khan]

Dear Krishna

I have created a qurey with Table VBUK which contains Sales Doc,Created on, Creation Time and overall status of the credit check but it preserve last change. What i require is when credit check was blocked and when it was release on a single report. If you know any table which fulfil the requriement kinldy suggest.

Thanks

NoMi