How can I implement a cash flow statement in sap? FI monthly closed

 

SAPCash Flow Statement

InSAPHow to Implement the cash flow statement?

Q: Have you ever done a cash flow statement for China? Can you tell me about it in SAP How to Implement the cash flow statement is more accurate and easy.
A: 1 . Exploitation Tr Module commitment project to call a standard of the systemProgram, And then write a Chinese cash flow statement format, but cannot produce an indirect cash flow statement.
2. Yes, it should be up Fund management Under Commitment itmes Management To Cocd Activation
Cashmanagement All general ledger accounts must be created. Commitment item . Transaction , FM
Records any business related to cash flow, which can reflect both the actual cash flow and the cash flow.
Prediction, such Vendor Or from Customer .
Of course, this is a direct method Cashflow It is very convenient. (After all, the indirect method is better than the direct method. If not FM There is a stupid way to manage commitment items, but it is still valid. In the credential Line item There is a field called Reason code The value assignment in this field can be IMG Custom, basically can be based on the direct method
Create a category for inbound and outbound cash flows Reason code .
This field is set to mandatory for cash and bank accounts each time you enter the credential. After that, you can use the general ledger Drill-down
Report Or ABAP Make a report. This method increases the workload but is feasible.
3. We are using a relatively stupid method. When making every cash (broadly) entry, according to the cash flow statement items managed by the company
In each Item Then, run a summary program to prepare a cash flow statement for management requirements. At the same time, it can be adjusted to the Chinese cash flow statement. View cash flow information at any time .
4. The direct method is used to obtain the number by analyzing the commitment items of the credential, SAP Defines a logical database for this function C1f. This program starts
Part of logical database fetch part is SAP Is used to load data related to cash flow into an internal table.
G_t_fmmp, This part of the program cannot be modified.
Direct Method
A Load the definition parameters of the cash flow statement ( Form fill_item_direct )
This subroutine loads the cash flow statement items and their corresponding commitment items into the internal table Int_cashflow.
B Load data related to cash flow
This part is logical database loading, which belongs SAP Standard procedures and complex data relationships are recommended.
C Computing cash flow
The basic idea of computing is G_t_fmmp Loop To find the commitment items of each record that belong Int_cashflow Of
After the table items, the amount is accumulated to the corresponding table items.
5. Select cash subjects Allocation The field is required and only numbers can be entered. match these numbers with the cash flow statement, and finally summarize this field.
The advantage is that, if you enter an error, you can change it at any time. That is to say, you can adjust it. Cash Flow

Note: :
For none Tr It is best to implement a cash flow table Assignment Column. First, you can directly enter the relevant reasons.CodeAnd Reason code The operation is troublesome. Substitution The field content cannot be changed. Assignment Can be written User exit . However Reason code You can select code.

SD relevant steps:
1. check if all delivery in due list have been processedvl06g
(cocould Set background jobs to automatically generate
the billing due list for posting)
2. check if all picking in due list have been processedvl06p
3. check if all goods issue in due list have been processedvl04
4. check if all billed ar has been release to accountingvfx3

PP relevant steps:
1. Check if all back flash error has been solved
(COGI check every day this kind of problem and solved on time)
2. Check if all production orders that will not be followed have been finally
Confirmed or technically closed. Do final confirmation even small quantity
Variance exist but we consider this order has finished
3. Do technical close at month end for the orders will not be followed in the future
4. Confirmation. Do not confirm any assembly scrap when do production order Conf.

MM relevant steps
1. Check if all goods movement has been booked in SAP
2. gr/IR clearing accounts maintenance if needed
3. Open the MM period for movement posting when new period starts Matrix

fi relevant steps
1. book all accounting entries for:
-accrued expense
-Do recurring entry (prepayment, accrued expense, amortization)
-process g/L, vendor, customer balance & open items
-cost allocations by FI
2.am fixed asset depreciation run and period posting afab
3.am periodic posting askb
4.g/ L, AR, AP balance check & open item clearing
5. foreign currency revaluation for bank/Cash & ar AP open items
bank/cash Revaluation: f.06
ar AP open items: f.05
6.gr/ IR clearing account regrouping process F.19
7. automatic Clearing for g/L accounts, vendor and customer f.13

CO relevant steps
1. Release standard cost estimate
Ck24only when there are costing run to be released.
2. Cost reallocation according to activity
Distribution: ckv5
Assessment: ksu5
3. Cost splitting among activity kss2
4. Actual activity price calculation ksii
5. Production Order revaluation with actual activity price con2
6. WIP calculationfor the production orders kkao
7. Variance Calculation for the production orders kkks1
8. Production/costing orders settlement co88/ko88
9. Material ledger closing> matrix first
A. Create costing runckru00
B. Allow settlementckmf_run
C. Allow closing entriesckmg_run
D. Material selectionckmb_run
E. Determine costing sequenceckmc_run
F. Settle single levelckmh_run
G. Settle multi levelckmm_run
H. Post closingckmi