Import Project Data from Sourcing

[Former Member]

Trying to import data from Sourcing into SPM, however when SPM attempts to read and import the data into SPM nothing is populating.

The extract file is showing double quotes on the header fields from Sourcing, is this why SPM can not import the data file or are there other areas that I should be looking at?

[Former Member]

Hi John,

I suggest you to import the data using LSMW.

It's the best way, for importing and exporting the data in SAP with the help of partner profiles.

Regards

Mohammed

[michaelwaugh]

Hi John,

Are you still experiencing issues with loading sourcing extract's to SPM?

Below is a sample of a sourcing extract file that i have loaded before

XSARSINIT;ASAC001C2;ASAC001C3;XARLOCCAT;XARMANORG;XSAPROJPAD;XSAPROJPCD;XSAPROJCDT;XSAPROJUDT;XSAPROJTYP;XSAPROJPR;XSAPROJRSK;XSAPROJST;XSAPROJPSA;XSAPROJPCA;XSAPROJPOA;XSACURR

PROCAT002BGA2011;2147483447;1100;A411;;20110126;20110126;20110126;;;2;0;2147483174;0;0;;USD

PROCAT001BGA2011;2147483448;1100;A411;;20110121;20110121;20110121;;;2;0;2147483174;0;0;;USD

PROCAT008BGA2011;2147483440;1100;1;;20110201;20110201;20110201;20110201;;2;0;2147483174;456789;345678;;USD

PROCAT007BGA2011;2147483441;1100;1;;20110131;20110131;20110131;20110201;;2;0;2147483174;450000;340000;;USD

PROCAT006BGA2011;2147483442;1100;1;;20110126;20110126;20110126;20110126;;3;1;2147483174;35000;25000;2500;USD

PROCAT005BGA2011;2147483443;1100;1;;20110126;20110126;20110126;20110201;;1;2;2147483172;456321;345231;;USD

PROCAT004BGA2011;2147483444;1100;1;;20110126;20110126;20110126;20110201;;2;0;2147483174;345678;12345;;USD

PROCAT003BGA2011;2147483445;1100;1;;20110126;20110126;20110126;20110201;;1;1;2147483174;123456;123451;;USD

Kind regads,

Michael

[former_member257798]

Hi John,

How are you doing this? Are you using SAP Note 1239883  Extractor Starter Kit for Spend Performance Management(SPM)

Kind Regards,

John Harris

Senior Support Engineer, SAP Active Global Support,