Show TOC

Function documentationPayment Charge Report

 

You use this function to prepare and print the payment charge report (Form 313) in Japan. You need to prepare this report if all the real estate charges in a year - for example, rents, security deposits, reikins (remuneration at the contract start), premium charges or renewal charges to a vendor - are higher than a certain amount specified by law. The report collects these payments (created by periodic or one-time posting) and creates a printout or an electronic file, which you can file in with the authorities.

The report collects all the payments that you define on the selection screen. Then it calculates the total of the payments per vendor in a year for all contracts and payment categories (excluding building rent and land rent for corporations) and compares it with the limit specified by law in Japan. If the total of the payment charges is over the limit, you need to file it in to the authorities.

The report also takes the real estate agent commissions into account and reports them in a different form section, if you have selected the Report Agent Commission checkbox as described in Customizing and if the agent commissions are above the same yearly payment charge limit. The agent commissions do not count for the yearly payment charge limit. If the checkbox is not selected, the agent commission should be reported with Form 314.

You can also use this function to create a summary report. It collects the number of all payees and the amount of payment charges that are above the payment limit (reported with Form 313), and also gives a summary about them (building rent and land rent for corporations are included in the summary report) regardless of the payment limit, the business partner, and payment categories. The agent commission is not included in the summary report.

If there are multiple landlords for a given contract, you have to implement the relevant BAdI method and provide the program logic, so that the report can calculate value of the total agent commission paid by a given landlord for a given agent.

To access this report, on the SAP Easy Access screen, choose Start of the navigation path Flexible Real Estate Management Next navigation step Country Specifics Next navigation step Japan Next navigation step Payment Charge Report End of the navigation path.

Prerequisites

You have made the following settings:

  • Made the required settings as described in Customizing for Payment Report

  • Created business partners with one of the following role categories:

    • TR0602: Landlord with Vendor Account

      You can specify multiple landlords, but you must not specify more than one agent for a real estate contract.

    • TR0801: Broker

  • Created payments as open items

  • Created payments that have been cleared in all the necessary payment categories, for example, rents, security deposits, reikins, and so on

Features

Selection

On the selection screen, you must enter the calendar year of reporting.

Note Note

You can only select company codes that are located in Japan.

End of the note.

You can also select the real estate contracts, the business partners (payer), the real estate objects, the payment category, and whether only the cleared items or open and cleared items are taken into account.

When you are satisfied that the information in the list is correct, and you want to prepare a copy of the report for the authorities, you can print out the form in the official format.

Output

The output of the report can be one of the following (for business partners with TR0602 or TR0801 role categories):

  • Detailed ALV list of the payment documents

    • In the ALV list for the payment documents, you can navigate to the real estate contract, the cleared or open payment document, the vendor of the landlord, and the real estate object.

    • The list shows the agent commissions. They do not count for the annual payment charge limit.

    • You can use the default layout 1SAP that SAP delivers or any other layouts that you define.

  • Simple ALV list of the output lines of the report

    • This shows the list that you will send to the authorities in electronic or paper form.

    • Each output line contains a maximum of three pieces of payment information (with different payment categories, rental object locations, rental object descriptions, and basis for calculation) about a vendor. If there are more than three pieces of payment information about a vendor, the report displays these in the next output line.

    • The simple ALV list also shows the agent commissions if they exceed the payment limit and if you have selected the Report Agent Commissions checkbox as described in Customizing.

      If the agent commission is cleared, the payment date appears on the output.

    • You can use the default layout 2SAP that SAP delivers or any other layouts that you define.

    • If you defined the sorting order as described in Customizing, the report creates a new row in the ALV list of the output lines according to your settings.

      If you did not define the sorting order, the report uses the default grouping order.

  • ALV list of the summary report

    This list collects the number of payees and the amount of payment charges above the payment limit (reported with Form 313), and also summarizes them (building rent and land rent for corporations are included in the summary report) regardless of the payment limit, the business partner, and payment categories. The agent commission is not included in the summary report.

    You can switch from any of the ALV lists to the two other types of ALV lists.

  • PDF preview or direct PDF printing

    You can choose this either in the selection screen or in the toolbar of the ALV.

    If you defined the sorting order as described in Customizing, the report creates a new row in the ALV list of the output lines according to your settings. If you did not define the sorting order, the report uses the default grouping order.

  • Text file for electronic filing

    To create the text file, in the ALV, select the Flat file pushbutton on the toolbar.

  • Excel sheet

    To create the Excel file, in the ALV list, choose Start of the navigation path Export Next navigation step Spreadsheet Next navigation step Excel End of the navigation path. The report lists the items of the output lines in an Excel file, which you can use for information purposes.

Application Log

After you have entered valid selection parameters on the selection screen, you do not receive any messages during the processing. Nevertheless, the system adds all the messages that come up during the execution of the report to the application log. In the application log, you are able to view and filter the messages according to the following types:

  • Error (red traffic light)

  • Warning (yellow traffic light)

  • Success or Information (green traffic light)

To view the messages in the application log, in the ALV list, choose Application log (F7) (Application log (F7)).

The system creates a warning message:

  • If the payments to a vendor are below the annual payment charge limit and therefore the report does not take them into account.

  • For all agent commissions that are below the annual payment charge limit.