2011 Jan 19 2:19 AM
Hi all,
I would like to customize an archiving object (ISU_PRDOCL, for example) to filter data by company code. Do you know how can I do this?
Regards,
Sandu
2011 Jan 19 9:32 AM
Hi,
I don't think that you can filter by company code at print document level. However, at billing document level (ISU_BILLZ for bill document line items and ISU_BILL for bill document header details), you can indeed filter by company code.
To do so, you have to go to transaction SARA, enter archiving object and click on Preprocessing (for pre-processing job) and Write (for write job). Then click on Maintain to access the variant for the job or create a new one.
For ISU_PRDOCL and ISU_PRDOCH, you'll see that you can filter by Print Document No, Contract Account and Portion.
For ISU_BILLZ and ISU_BILL, you'll see that you can filter by Billing Document N., Contract Account, Contract and Company Code.
Hope this helps.
2011 Jan 19 9:32 AM
Hi,
I don't think that you can filter by company code at print document level. However, at billing document level (ISU_BILLZ for bill document line items and ISU_BILL for bill document header details), you can indeed filter by company code.
To do so, you have to go to transaction SARA, enter archiving object and click on Preprocessing (for pre-processing job) and Write (for write job). Then click on Maintain to access the variant for the job or create a new one.
For ISU_PRDOCL and ISU_PRDOCH, you'll see that you can filter by Print Document No, Contract Account and Portion.
For ISU_BILLZ and ISU_BILL, you'll see that you can filter by Billing Document N., Contract Account, Contract and Company Code.
Hope this helps.
2011 Jan 19 12:10 PM
Hi David,
Many thanks for replying. By maintaining ISU_BILL or ISU_BILLZ objects, I have only three aditional restrictions: Document number, Contract account and Contract. Can I do something to add Company code or Division?
Thanks and regards,
Sandu
2011 Jan 19 1:29 PM
Hi David,
We run IS-U on R3 Enterprise 470. On an ECC 6.0, I can see Company code selection in variant. We will try to import REAARCH_ANALYZE_LINE in 470 system.
Thanks,
Sandu
2011 Jan 19 1:54 PM
Hi Sandu,
I agree, importing REAARCH_ANALYZE_LINE in 470 system is your best option. You can also look if there are any OSS notes that SAP has released to support this.
If you can't import REAARCH_ANALYZE_LINE or there is no OSS note then other thing that you can try is to copy standard program REAARCH_ANALYZE_LINE and customize it in a way that it provides this functionality (filtering by company code) but this is probably your last option as it will the more time consuming. In this case, another solution could be to create a custom program that somehow relates company code to contract account/contract (if possible) and that then it invokes standard program REAARCH_ANALYZE_LINE with the relevant parameters.
Thanks for rewarding points. Regards, David.