SAP CRM PRCD_COND Table

dataservices job design
1

Hi There,

I am facing quite a strange issue while trying to access PRCD_COND (Pricing Condition) table via ABAP Data FLow in designer. It’s a cluster table. The strange thing is the field size of GUIDs fields in this Table, for example it gives me field width of varchar(16) for GUID field KNUMV which should be varchar 32.

did some analysis and came to know that in SAP CRM field width for GUID fields in this table is 16 where as output field width is 32 , but it has not been mentioned how SAP is conevrting these 16 char to 32 char to make it complete guid of length varchar 32…

In DS when I import this table field width imported is of varchar(16) instead of varchar(32). hence I am not able to join this table with other table as the key fields are GUIDs of this table.

Has anybody ever faced this sort of issue…? I really appriciate your inputs.

Thanks .

BOBJFan (BOB member since 2011-09-24)

2

Did you get a chance to do VIEW DATA and see how the data looks like?

ganeshxp :us: (BOB member since 2008-07-17)

3

Hi Ganesh, Tnaks for your reply, view data also returns only 16 char. With further investigation I found that, If I will use ABAP DF (for cluster table, I don’t think there is any other way I can access cluster tables…? am I right?) on SAPCRM system tables it will return GUID as 16 characters and I will need to use some Function module like ‘RRXWS_RAW_TO_CHAR’ to conevrt this 16 char to 32 char GUID . However it need RFC.INI setup to exist and now I don’t know how can I do this setup.

Went through some forums to get some info it suggests me to look for saprfc.ini file in my installed business objects folder…but I couldn’t find one… any idea how can I do this?

Thanks

BOBJFan (BOB member since 2011-09-24)