Load 0CUST_SALES_TEXT in DELTA mode ?
I need to load data for Customers texts and attributes (0CUSTOMER and 0CUST_SALES).
When I load data for attributes, I can load it in DELTAmode but when i load data for text I can't have it in DELTA mode but only on FULL mode.
Unfortunately, customer texts takes too much time (nearly 2h30). The ideal thing is to load customers text in DELTA mode but I don't know how I can do it? Can I have some help? I'm in SAP version 7.0.
Thanks in advance,
Edited by: Bernadette Duong on Oct 20, 2008 2:00 PM
Srinivas Neelam replied
Hi Bernadette Duong,
Create a new Datasource will have the datasource 0cust_sales_text loading in delta mode and not in full mode, but will your solution (customer exit) impact R/3 transaction for customers? I don't see where this solution could be better as create a new datasource. could you explain me what you mean?
--> Use standard datasource only to load data. At r/3 side delete not required records(not changed or created newly). Then you can reduce total no of records loading into BW. This solution nothing to do with R/3 transactions as data comes from tables.
for new datasource, you need to create a infoset or view on multiple tables and on that need to create datasouce. As you have huge no of records, it takes more time than restricting records at user exit.
You better try both options and take your decision.
Hope it Helps
[Dont forget to close the call by assigning poings.... - Food for Points: Make a Difference through Community Contribution!|https://www.sdn.sap.com/irj/sdn/index?rid=/webcontent/uuid/007928c5-c4ef-2a10-d9a3-8109ae621a82]