SPP - Load data from csv file

[Former Member]

We are trying to upload sales order data into SPP through a csv file, however we keep getting the error

"No valid (product/location) item to load into APO-BI"

We have created the product and location in the APO master data for the part and location we are trying to load.

Has anyone been successful in loading data from csv file into SPP ? Would appreciate any help.

Thanks

[Former Member · Accepted solution]

Hi Ganesh,

Some times if there is a supersession chain for the product u r trying to load history, then also u will not be able to load the data in the BI.

Best Regards,

Satish

[Former Member · Accepted solution]

Thanks Somnath and Satish for your replies. Really appreciate the effort put in by you guys.

We had a few doubts while creating the csv file to match the standard format given by Somnath. we thought it would be best to describe the sequence of master data and upload related activities we have performed till now to give you guys a background.

<b>System landscape:</b>

We are working on an SCM sandbox without data interface with other systems. We are trying to load order data from a csv file and configure a business scenario for a limited set of parts.

<b>Issue faced:</b>

Since the master data has been created in APO and not pulled in from CRM, we are unsure about certain fields in the standard csv format for SPP (specifically CRM GUid, product and material). This is a sample record from the csv we are trying to upload. Please note that we had to take guesses for quite a few fields!

<b>Master data</b>

Product: PROD1 (with SPP enabled fields) created in APO master

Location: LOC1 created in APO master

BOD: LOC1 (consisting of one location only)

<b>CSV uploaded</b>

Executing Loc. Type CHAR 4 CRMELOCTYP -<b> 1002</b>

Cus-Facing Loc. Type CHAR 4 CRMFLOCTYP - <b>1002</b>

Type 1st Stockh.Loc. CHAR 4 CRMFSTLTP - <b>1002</b>

Order Qty: Sls Units QUAN 17 CRMORDQTYV - <b>1000</b>

Pl. GI Date (Req.) DATS 8 CRMPGIDATW - <b>20061010</b>

Pl. GI Time (Req.) TIMS 6 CRMPGITIMW - <b>200000</b>

Customer-Facing Loc. CHAR 20 CRM_FACLOC - <b>LOC1</b>

1st Stockholding Loc CHAR 20 CRM_FSTLOC - <b>LOC1</b>

Transaction Created DATS 8 CRM_ITCRAT - <b>20061010</b>

GUID of a CRM item CHAR 32 CRM_ITMGUI Check - <b>PROD1</b>

Item Transaction Typ CHAR 4 CRM_ITMTYP Check - <b>NORM</b>

Item Category Usage CHAR 4 CRM_ITMTYS Blank

Use:Higher Level Itm CHAR 2 CRM_ITMUSE Blank

Abnormal Demand CHAR 1 CRM_NOTNRM Blank

Item No. Order Doc. NUMC 10 CRM_NUMINT Check - <b>PROD1</b>

No. of Doc Items INT4 10 CRM_NUMOFI Check - <b>1</b>

Transaction Number CHAR 10 CRM_OBJ_ID Check - <b>PROD1</b>

GUID CRM Order Obj. CHAR 32 CRM_OHGUID Check - <b>PROD1</b>

Parent item CHAR 32 CRM_PARITM Blank

Business Trans. Type CHAR 4 CRM_PRCTYP Blank

Denominator INT4 10 Put 1 - <b>1</b>

10th Exponent INT4 10 Put 1 - <b>1</b>

Numerator INT4 10 Put 1 - <b>1</b>

Reason for Rejection CHAR 2 CRM_REJECT Blank

Requested deliv.date DATS 8 CRM_REQDAT - <b>20061016</b>

Goods Recipient CHAR 10 CRM_SHIPTO - <b>CUST1 (Not created in master)</b>

Source System CHAR 10 LOGSYS - <b>EXCEL</b>

Material CHAR 18 MATERIAL - <b>PROD1</b>

Update Mode CHAR 1 RECORDMODE - <b>F</b>

Sales unit UNIT 3 SALES_UNIT - <b>EA</b>

Product CHAR 32 CRM_PROD - <b>PROD1</b>

Base Unit UNIT 3 BASE_UOM - <b>EA</b>

Product ID CHAR 40 CRMPROD_ID - <b>PROD1</b>

Thanks again for your help!

Best Regards

Ganesh

[somnath_manna · Accepted solution]

Ganesh,

you necessarily need location and product master in APO for the data load. The update rule checks for the master data as explained in the below mentioned link.

http://help.sap.com/saphelp_scm50/helpdata/en/43/5671e13a153576e10000000a11466f/content.htm

Also see <a href="this

http://help.sap.com/saphelp_scm50/helpdata/en/43/5673673a153576e10000000a11466f/content.htm">this link</a> to get further details of the error during data capture.

See if you can upload the following records (you will need to copy into Excel and Paste Special >> Transpose to fit in the template). Make sure you have the relevant master data location CFLOC1 (or something suitable) and PROD1.

1002 1002

1002 1002

1002 1002

60 60

20050401 20050501

121210 121210

CFLOC1 CFLOC1

CFLOC1 CFLOC1

20050401 20050501

ST_1 ST_2

TAN TAN

10 20

21 21

1 1

STO1 STO2

1 1

1 1

1 1

20050401 20050501

ABC XYZ

CRMCLNT100 CRMCLNT100

PROD1 PROD1

EA EA

EA EA

PROD1 PROD1

Unfortunately I have not been able to sucessfully install all the relevant BI content after upgrading to SCM 5.0 hence can not check at our system.

Thanks,

somnath

[Former Member · Accepted solution]

Hi Somnath,

Thanks to your file format, finally succeeded in loading data from a CSV file into the infocube! We had missed out some fields (CRM GUid, Item transaction type, Guid of CRM object).

Really appreciate the effort that you put into this - will keep you posted on how the configuration goes.

Ganesh

[Former Member · Accepted solution]

Hi Ganesh,

I happened to go thro' this discussion transpired with Somnath and now I am on the same boat. While trying to load the flat file, I end up getting following error message. As I debug with the help of an ABAP expert, I am finding it is referring to objects from CRM.

Did you create objects? If so can you post the list of objects one need to create? or did you modify the (SAP) ABAP Program? Can you post how you solved the issue?   ...Thanks in advance..Raghuram

[Former Member]

We are doing an SPPproof of concept and need to know the mapping between these standard Infoobjects and Key figures between 9ADEMAND and 9APP_CD_CSV_LOAD.

Any is appreciated

Thanks

[Former Member]

We are doing an SPP proof of concept and need to know the mapping between 9ADEMAND and 9APP_CD_CSV_LOAD.

Any help is appreciated

Thanks

[Former Member]

hi,

we are also facing the same issue. if you had the solution can you please post it here.

thanks

[Former Member]

Hi Ganesh,

We are trying to load CSV file to 9ADEMAND cube. This is being done through a transfer structure 9ASPP_CD_CSV_LOAD.

The transfer structure is 9APP_CD_CSV_LOAD and it has certain characteristics - lets say A, B, C and Key Figures D, E. The Infocube 9ADEMAND has characteristics - lets say X, Y and key Figure Z.

In order to define update rules, I need to know the mapping between these standard Infoobjects and Key figures between 9ADEMAND and 9APP_CD_CSV_LOAD.

I wanted to know, how this issue was resolved in your case.

Regards

Parag Dani

[somnath_manna]

Hi Ganesh,

As my good friend Sathish mentioned most of the time csv file is not properly created - you need to check the values in the CRM_ITMGUI field. This field should the GUID for a CRM Item. As per the standard business process the Sales Order data in SPP (9ADEMAND Infocube) is sourced from connected CRM system. In your case you are loading data from csv file to the infocube. Hence you need to populate the according fields for CRM Item details for succesful loading of data.

Here is a list of the fields required in the CSV file.

Infoobject Description Type Field length Technical name

Executing Loc. Type CHAR 4 CRMELOCTYP

Cus-Facing Loc. Type CHAR 4 CRMFLOCTYP

Type 1st Stockh.Loc. CHAR 4 CRMFSTLTP

Order Qty: Sls Units QUAN 17 CRMORDQTYV

Pl. GI Date (Req.) DATS 8 CRMPGIDATW

Pl. GI Time (Req.) TIMS 6 CRMPGITIMW

Customer-Facing Loc. CHAR 20 CRM_FACLOC

1st Stockholding Loc CHAR 20 CRM_FSTLOC

Transaction Created DATS 8 CRM_ITCRAT

GUID of a CRM item CHAR 32 CRM_ITMGUI Check

Item Transaction Typ CHAR 4 CRM_ITMTYP Check

Item Category Usage CHAR 4 CRM_ITMTYS Blank

Use:Higher Level Itm CHAR 2 CRM_ITMUSE Blank

Abnormal Demand CHAR 1 CRM_NOTNRM Blank

Item No. Order Doc. NUMC 10 CRM_NUMINT Check

No. of Doc Items INT4 10 CRM_NUMOFI Check

Transaction Number CHAR 10 CRM_OBJ_ID Check

GUID CRM Order Obj. CHAR 32 CRM_OHGUID Check

Parent item CHAR 32 CRM_PARITM Blank

Business Trans. Type CHAR 4 CRM_PRCTYP Blank

Denominator INT4 10 Put 1

10th Exponent INT4 10 Put 1

Numerator INT4 10 Put 1

Reason for Rejection CHAR 2 CRM_REJECT Blank

Requested deliv.date DATS 8 CRM_REQDAT

Goods Recipient CHAR 10 CRM_SHIPTO

Source System CHAR 10 LOGSYS

Material CHAR 18 MATERIAL

Update Mode CHAR 1 RECORDMODE

Sales unit UNIT 3 SALES_UNIT

Product CHAR 32 CRM_PROD

Base Unit UNIT 3 BASE_UOM

Product ID CHAR 40 CRMPROD_ID

The fields marked as check should have some value, while those marked blank can be blank.

Hope this helps.

Thanks,

Somnath

[Former Member]

Hi Ganesh,

Just check out the CSV file again. 90% of the time the problem lies with the CSV file. Kindly let me know which system landscape you are using.

Best Regards,

Satish