Skip to Content
0

FI posting with clearing header data for bank line items from FB05

Dec 09, 2016 at 06:52 AM

221

avatar image

Hi Abapers,

I have this requirement. On user entry of HBKID (Short key for a house bank) i have fetched T012K-HKONT and need to add 1 or 2 to T012K-HKONT. After adding i have fetched line items from BSIS where HKONT = T012K-HKONT(1/2) and BSCHL = 40/50 and SHKZG = S/H. Now based on BSIS-ZUONR i have fetched data from FEBEP. Now there are certain conditions to check(BSIS-WRBTR = FEBEP-KWBTR). If that is true i need to do the following.

Trigger Program SAPMF05A [FB05 t-code] and post the below FI document

Posting Key Date GL Account GL Description Amount (kwbtr)

40 FEBEP-BUDAT 9XXXXXXX2(after adding)Bank Outgoing GL 9999

50 FEBEP-BUDAT 9XXXXXXX0(original) Bank Main GL 9999

I need to eliminate the line items obtained from table BSIS and include the same in table BSAS. Also table FEBEP (Belnr)needs to be updated by the document no. which gets generated from fb05. As per now this is done by standard. How can i do it from a z-program. I have completed the data fetching from the tables but need help on how to post this document with line items clearance from table BSIS and then adding them in table BSAS. Also i need to keep in my mind that as per the Standard Program behavior the Table BSEG , BSAS , BSIS and FEBEP are updated. I have never worked on this kind of requirement before. A little guidance or helpful links or some code would be very helpful.

Thanks in advance. Really need help on this issue.


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Raymond Giuseppi
Dec 09, 2016 at 08:38 AM
0

Tech answer for clearing:

  • Don't worry for BSIS records, then will move to BSAS as soon as BSEG items are cleared.
  • The FM POSTING_INTERFACE_CLEARING will build the BDC for FB05 execution. If you want a BAPI, use one like BAP_ACC_DOCUMENT_POST and then execute a clearing transaction, or even submit the associated report like SAPF124.
  • (Also use search tool/launchpad, there are many threads with posting and clearing keywords)

For the update of FEBEP, ask again functionals, the request is surprising, usually the document is created from a transaction like FEBP (auto) or FF67 (manual) are you re-writing those transactions?

Regards,
Raymond

Share
10 |10000 characters needed characters left characters exceeded
surajit sharma Dec 10, 2016 at 10:52 AM
0

Hi Raymond,

Thank you for your quick reply. I went through some links on FM POSTING_INTERFACE_CLEARING. Also had a conversation with my functional. What i have to do is for each line item i get after adding 1/2 to the main account, i need to clear them from FB05 and create a FI clearing document and need to update the same in table FEBEP-Belnr with 2 other fields needed to be flagged as X

  • FEBEP-EPERL
  • FEBEP-VB1OK

So for this what data in internal table i must have from bsis,febep and T012K so that i can pass to FM POSTING_INTERFACE_CLEARING. After that how can i get the clearing document to update in febep. Please can you elaborate this steps to me. Some things can be childish which i am asking you but as you can understand i am doing this type of requirement for the first time.

Share
10 |10000 characters needed characters left characters exceeded
surajit sharma Dec 14, 2016 at 06:01 AM
0

Hi Raymond,

Completed with the FB05 process. Line items are being cleared as you said and document no. is generated. Now only i need to update this document no. (belnr) in table FEBEP for this line item based on Assignment No. (ZNOUR). The document no. is getting updated in table Bseg. I need to copy that and update the same in Table FEBEP based on on Assignment No. (ZNOUR). Is there any specific way of doing that. Please can you help me on this.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

I don't know any tool for this (usually this table in maintained in standard reports with open-sql statements)

Sample : form open_fi_posting in program RFEBBU00 in transactions like FEBP.

      update febep set   vb1ok = febep-vb1ok                "hw534210
                         belnr = febep-belnr                "hw534210
                         b1doc = febdoc-docno
                         b1typ = febdoc-doctype
                         b1err = febep-b1err                "hw534210
                   where kukey = febep-kukey
                     and esnum = febep-esnum.

Regards,
Raymond

0
surajit sharma Dec 14, 2016 at 10:44 AM
0

Hi Raymond,

Thanks alot for sharing this information. This will definitely help me to resolve my issue.

Share
10 |10000 characters needed characters left characters exceeded