We are on a 6.0 ERP system. All the documentation for the 0fi_gl_4 extract seem to be using DMSO fields whereas BSEG has DMB fields. Where does it get the DMB fields?
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
You aslo have to use a ODS (change log DSO) before the cube to resolve duplicates (because you can change fi documents - ie text, due dates stuff like that)
However be very careful about putting line item information into your cube if you huge volumes (think of the size of the SID table for accounting document number!!)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.