on 07-29-2005 6:55 PM
Hi All,
1)I have a complaint number coming of the customer portal, so I want to compound it with the 0customer, but since the complaint number is dynamic I cannot maintain any master data, so how do I upload the transactional data, do I need to upload both the complaint number and the customer number and, will it be aggregated for the customers and when I use the customer in the report can I get the details of the customer (master data is already maintained for the customer).
2)I have a infoobject with type char string and length=60, It will be fed with the transactional data(text) from flat file, what happens if the text in the transactional data is more than 60 char will it truncate it automatically or do I need to write an ABAP code in transfer rules or update rules to do that.
Thank You.
Hi,
Just wondering why would you want to compound a complaint number with customer..I would believe that complaint number will just be a part of the transaction data..
If you compound Complaint number with Customer you would have a record in the master data for every unique customer and complaint..
I would suggest just keep it a part of your transaction data..not master data.
Hope I got your scenario right..
Ashish.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If its being pulled from each customer and sits in a table in BW , you could add a Flag field in customer master and use it as a navigational attribute to identify the customers with complaints..
This flag can be updated in the update rule by referring to that table..
Just a quick check here..Do you intend to get the details of every complaint of the customer or do you just want to know whether the customer has a complaint?
Ashish.
What I meant was: You said that you can identify the source. So is this identification in the form of the cutsomer number stored in , lets say, 0CUSTOMER ? Eg. Customer in 0CUSTOMER is like 1001, but the identification that you get from the customer portal is like C456, then you need a link between 1001 and C456 if you want to continue using 0CUSTOMER for analysis. If you want to take C456 value and store it in a different InfoObject, then no need of this linking activity.
So once you have C456 linked to 1001, then during load it'll go like take Cust_ID and look up 0CUSTOMER and get coresponding 0CUSTOMER number.
Hope I am not confusing you...
Hi Sheety,
Could you please confirm that do you have customer number in the cube right now along with complaint number or is it just complaint number which you are trying to link to the customer..
Do let us know what you finally ended up with..It might help everyone..
Ashish.
Message was edited by: Ashish Gour
Hi Shetty,
Not sure why you would like to compound the complaint number to the customer because wouldn't each complaint number be unique... You can have this like as a char of type NUMC.
Forgot the second part: The system will automatically truncate it without you writing any code.
Hope this helps...
Message was edited by: Bhanu Gupta
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
61 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.