function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Informatica, The ID field in object must be mapped for update.

So we pull data from SAP quotes/sales and push it into a custom object in SFDC.

How we reference the records in SFDC to the ones in SAP is via the SAP sales doc #. In fact when you view this is Informatica you can see in both SAP and SFDC the Sales doc. and SAP_Sales_Doc__c and keys. 

Now theres another field ORCL in SAP it's a boolen value true/false (or X/blank) and i need to push that to the related records in SFDC. The problem is when i try to us data synchronization it tells me "The ID field in object must be mapped for update." How the hell am i supposed to map to this field when there's nothing in SAP that references that.....the only reference to records i have is via the SAP sales doc.
Raj VakatiRaj Vakati
I can sugges onte think .. 

create a new external id field ( you can use SAP id or any uniquer field )  and use this field for both insert and update 
I should mention the SAP_Sales_Doc__c field is an external ID
Raj VakatiRaj Vakati
SAP_Sales_Doc__c if its a unique that will work ..
Raj VakatiRaj Vakati
Refer this image

User-added image