01-29-2009 8:16 PM
Hi all,
I have searched the forum for an answer to this question to no avail. I am attempting to make an archiving report on sales information drawing fields from tables such as KNA1 and VBAP. I am attempting to make a new information structure and subsequently a new field catalog to include all of the fields necessary for the report. The problem is that these two tables (and others) do not appear to be contained in the archiving object associated with the field catalog.
Is it possible to create a field catalog that can draw on archives from more than one archiving object? Or is there some other way to derive fields from tables in multiple archiving objects for one field catalog?
Thank you!
-Danny
01-30-2009 12:07 AM
Hi Danny,
I think One field catelogue can be created for one archive object only.
If possible you can try this logic.
First create two temporary transparent tables by copying the structures of KNA1 and VBAP.
In a Program get the archived records for those two Objects FI_ACCRECV and SD_VBAP and store those records in these two tables by using the Standard Archive functions.
Finally you can generate the required sales report by relating these two tables.
Hope this helps
Regards
Swarna Shree
01-30-2009 12:07 AM
Hi Danny,
I think One field catelogue can be created for one archive object only.
If possible you can try this logic.
First create two temporary transparent tables by copying the structures of KNA1 and VBAP.
In a Program get the archived records for those two Objects FI_ACCRECV and SD_VBAP and store those records in these two tables by using the Standard Archive functions.
Finally you can generate the required sales report by relating these two tables.
Hope this helps
Regards
Swarna Shree