Create Generic Data source: New GL Line Item : Auto Industry

[Former Member]

Hi, All of you are so nice to help me , but Please help me to clear this up for final desgin, people have mentioned on sdn that For new GL ledeger configuration totals table we use FAGLFLEXT table and for line items we still use BSEG and BKPF tables. but Function team FICO at my client BMW and other clients for automobiles, have mentioned that FAGLFLEXA. is used for line items but that does not contain all fields of BSEG and BKPF . so please help me what should I do to resolve the below

1. If I use FAGLFLEXA Line Item Table , how to combine the remaining fields such as BLART Document Type etc.. from BSEG AND bkpf

2. What is BSEG_ADD: Entry View of Accounting Document for Additional Ledgers, Should i also Include this table since it contains some fields like BSTAT

document status etc for line item.

<b>3. If I take the approach with line item as per new GL TABLE : FAGLFLEXA. and

BSEG_ADD by creating generic data source on two table and enhance any other required fields like blart Document Type will it solve the line item extraction purpose</b>

4. I took the approach as mentioned in Point 3 . but not able to create the generic data source please let me know if you have any template to create the function module generic datasource. please send me step by step guideline would appreciate it. if you have any documents send me at soniyakv@hotmail.com

5. I have reviewed 0FIGl_4 LINE ITEM Data source and found that it contains only bseg and bkpf but no faglflexa table fields. so suggest if i can proceed as number 4.

Thanks

Regards

Soniya Kapoor <i></i>

[Former Member]

Use transaction SQVI to simulate a database view. Try to join FAGLFLEXT and BSEG, BKPF. This transaction is very self explantory and you wont need any help. Let me know if you need help and I can help you.

If you are not able to join them in a view and decided to go for FM, then you will need a very good ABAP programmer with you, becuase you may have to check for conditions and do validations.

Ravi Thothadri