thanks, do you have info about 0FI_GL_14 data source? it looks fine...
my system doesn't have too. I'm using 0FI_AR_4 but it doesn't show vat related gl accounts. it looks just only customer accounts. 0FI_GL_4 uses bseg table. can I enhance without using abap? I mean, can I easily enhance customer field of the bseg table to the 0FI_GL_4. I found an information but it is a little complicated.
"Use 0FI_GL_4 if you don;t have all the fields you want from BSEG - then use the CI_BSIS include attached to extraction structure (check OSS)
In the CI_BSIS include you can add any field from BSEG as long as you give it it's proper field name
This is the one of the only occasions you don't specify ZZ to begin your field names!
THe way it works is that it extracts data from two views based on BKPF/BSEG and then BKPF/BSEG/BWFIAEDAT (which is a BW specific table implemented via a SAP standard BADI which tracks proper changes to BSEG records - the change date in BKPF can;t be trusted for this!)
Then once this data has been extracted - the function module then loops aroudn the records of the extractor against BSEG doing a move-corresponding ..
.. and thus automatically picking up your CI_BSIS include fields without you having to cmod the extractor
Ah! one of my posts!
Okay tell me exactly what you want to see - can you show me and example of your finance journal and what you want
e.g. this is a standard customer posting
dr customer/debtor 117.50 cr revenue 100.00 cr vat 17.50
Do you want to see the customer on the revenue line?
Is it available in BSEG on the revenue line or not?
If it isn't no problem we can solve that as well (it will be painful but we can do it)
Hi Simon, your post are very helpfull.
in my system, there are discount related accounts which began 603. I'm trying to get related documant list simply. firstly, I tried from 0FI_AR_4 data source, but it doesn't get 603 discount accounts. so, I activated 0FI_GL_4 and got the data related with 603*. but, there isn't any customer identifier within 0FI_GL_4. I'm trying to enhance this data source with customer ID. are there any standard ways for this?