Shulou(Shulou.com)06/01 Report--

The content of this article is mainly about how to use the SAP counter-accounting function. The content of the article is clear and clear. It is very suitable for beginners to learn and is worth reading. Interested friends can follow the editor to read together. I hope you can get something through this article!

The anti-accounting function of sap is similar to the so-called red letter, which is displayed in the form of scarlet letter, but the scarlet letter cannot be specified when making vouchers.

In the SAP system, the debit amount of the general ledger voucher is stored in the database by using a positive number by the debit and a negative number by the lender. Each line item of the certificate will have an accounting code, which corresponds to a lending direction, so the line item of the voucher will record a lending direction at the same time, which can be looked up directly through the BSEG table, for example:

Normal business credentials:

Borrow: 1001 cash 4000 loan: 1002 bank deposit 4000

The data stored in the SAP system are: accounting code, loan identification account amount 40 S 1001 4000 50 H 1002 4000

If you need to make a counter-accounting voucher, for example, you need to make a counter-accounting voucher of the above voucher, you need to specify it as anti-accounting when the voucher is made, as shown in the figure:

In this figure, you need to call up the anti-accounting option box through "other data".

The data saved in the background are as follows: accounting code, loan identification, account amount, reverse bookkeeping 40 S 1002 4000 X 50 H 1001 4000 X

Such accounting vouchers are also produced when using FB08 to make counter-bookkeeping vouchers. The counter-accounting voucher will be displayed as a scarlet letter when the balance is displayed, that is to say, the above counter-accounting voucher is equivalent to the voucher:

Based on the above, we can see that SAP can use the following logic to deduce the vouchers displayed: the loan direction satisfies the formula S (positive 1) = H (negative 1) * reverse accounting (negative 1, not positive 1), that is to say, the normal display is based on the loan logo, if there is reverse accounting, just the opposite. The amount shown = debit ID (debit is positive 1, credit is negative 1) * (stored amount number) * reverse bookkeeping (negative 1, not positive 1)

Reverse bookkeeping is a financial term, and its meaning is detailed in the previous forwarded article. The characteristic of reverse accounting in BW is: ZXNEGP. To put it simply, the H with the counter-accounting mark is S, and the S with the anti-accounting mark is H.

FI general ledger bank has three key indicators: credit amount, debit amount, debit / credit amount.

Under normal circumstances:

1) if the loan is marked as H, the system will put the recorded amount into the credit amount.

2) if the loan is marked as S, the system will put the recorded amount into the debit amount.

3) debit-credit amount is put into "debit / credit amount".

However, when the record is marked with a reverse bookkeeping mark:

1) if the counter-bookkeeping is marked as X and the loan is marked as H, the system will put the recorded amount into the debit amount

2) if the reverse bookkeeping is marked as X and the loan is marked as S, the system will put the recorded amount into the credit amount.

3) debit-credit amount is still put into "debit / credit amount".

Such as:

ECC data:

Voucher number, accounting code, loan identification, counter-bookkeeping, marking amount.

Voucher 1 40 S empty 200

Voucher 2 50 H null-200

Voucher 3 40 S X 300

Voucher 4 50 H X-300

After extracting the DSO of BW:

Voucher number, bookkeeping code, loan mark, counter-bookkeeping mark, debit amount, credit amount, debit / credit amount

Voucher 1 40 S empty 200 200

Voucher 2 50 H null-200 200

Voucher 3 40 S X 300-300

Voucher 4 50 H X-300-300

In some cases, the system requires a debit amount (considering counter-accounting), where query cannot limit the debit amount identified as S (or debit / credit amount), but is directly limited to the "debit amount".

However, the quantity in the general ledger is partly debit and credit, and if you also need to consider counter-bookkeeping, you need to add your own new features to complete the user requirements.

Thank you for your reading. I believe you have a certain understanding of "how to use the SAP counter-accounting function". Go to practice quickly. If you want to know more about it, you can follow the website! The editor will continue to bring you better articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.