FBCB using LSMW Step by step (Balance carry forward, zero period posting)
This document gives a brief information on creating the documents via FBCB using LSMW for zero period posting (Balance carry forward).
While migrating to New GL, you require transaction FBCB to post data to accounts in period 0. The FBCB T Code is particularly useful in migration of balances from GLT0 to new gl and where profit center (FIN_PCA) is a scenario in New GL. Through reposting by FBCB, it is possible to update the GL Balances for a Profit Center, without impacting the balances at the company code level. FBCB can be used to update the balances at the Account Assignment Level for different New GL scenario like FIN_PCA, FIN_GSBER, FIN_UKR etc to name a few. All the Documents generated through FBCB are updated in period 0 for balance carry forward. It is possible to have an LSMW or BDC update for FBCB.
Major steps involved are-
- Create a LSMW Project
- upload the header and line item files
- create batch input session
- Process session and check the log for output.
- Execute transaction ‘LSMW’.
2. Once project is created, you have to execute all the steps in LSMW and process as per the requirement.
Maintain attributes such as program name, type etc.
For accounting documents, SAP provides standard program RFBIBL00 which can be leveraged.
3. Maintain source structure: Create two structure for header and data file.
4. Maintain source fields: Create same field names in each of the structure which you will use in your header and data files.
5. Maintain Field Mapping and Conversion Rules:
- Create mapping rule for the header and line item fields from the file fields to standard structure fields.
- Standard structure being used are BBKPF, BBSEG.
- Use auto field mapping option to reduce the effort of manually mapping all the fields one by one.
Change the layout and select the ‘Technical fields’, then below two fields will be displayed.
6. Specify files:
Provide the file name in the step for header and line items.
7. Assign Files:
Assign header and line item file names to the header and lineitem structure.
8. Read Data:
Now the process is pretty straightforward as you just need to read the input header and line item files to the LSMW so that it can get all the data for processing.
9. Display Data:
Data can be displayed for header as well as for line item.
10. Convert data:
Conversion program will use conversion logics which were defined in step ‘Maintain Field Mapping and Conversion Rules’ for converting the data from files to processing BBKPF and BBSEG structures.
11. Display converted data:
You can check the converted data which is the final data to be used for posting the transactions.
12. Start Direct Input Program:
Here you can define the processing mode for the posting of transactions.
Once above screen is executed, it’ll open the program RFBIBL00.
After filling all the fields, execute the program which will create a batch input session.
13. Process Batch Input Session:
- You may want to retain the session after completion to check the log in future.
This can be achieved by two ways.
A) Change the header settings like below
B) Change the settings in LSMW step ‘Maintain Field Mapping and Conversion Rules’.
14. Display session log:
Few things to remember here:
- Date format:
Change the date format in user profile to DD.MM.YYYY and provide the date as DDMMYYYY In the input file.
Program will automatically convert the input file date to user profile date if used like above.
- File Format:
BKPF (Header File): Fields can be added or deleted as per the requirements
BSEG (Line Item File):
- Field ‘STYPE’ is linkage between header and line items.
- Maximum 999 line items can be provided per document.
- File used here is a tab delimited file.
- You can use excel file for your convenience and then save as .txt (tab delimited).
- Same process can be used for FB01, FSB1, FBV1, FBB1 also except that the Tcode will be changed as shown in step 5.you can use fields as per your requirements for transactions.
- You can read the documentation of program RFBIBL00 for more details on other transactions.
Related Notes / Reference:
SAP Note 0001562986 – FBCB postings with RFBIBL00
SAP Note 0001679975 – FBCB requires a great deal of time during migration
SAP Note 0001070629 – FAQs: New general ledger migration
Saurabh Gupta is ABAP consultant at Cognizant technology solutions and have keen interest in learning technologies around SAP.