import a csv file into demand history

[Former Member]

Hi SAP Friends,

we are sitting here for hours and just don´t get any further... Our problem is, we have written a csv file according to this example:

Executing Loc. Type CHAR 4 CRMELOCTYP - 1002

Cus-Facing Loc. Type CHAR 4 CRMFLOCTYP - 1002

Type 1st Stockh.Loc. CHAR 4 CRMFSTLTP - 1002

Order Qty: Sls Units QUAN 17 CRMORDQTYV - 1000

Pl. GI Date (Req.) DATS 8 CRMPGIDATW - 20061010

Pl. GI Time (Req.) TIMS 6 CRMPGITIMW - 200000

Customer-Facing Loc. CHAR 20 CRM_FACLOC - LOC1

1st Stockholding Loc CHAR 20 CRM_FSTLOC - LOC1

Transaction Created DATS 8 CRM_ITCRAT - 20061010

GUID of a CRM item CHAR 32 CRM_ITMGUI Check - PROD1

Item Transaction Typ CHAR 4 CRM_ITMTYP Check - NORM

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 - PROD1

No. of Doc Items INT4 10 CRM_NUMOFI Check - 1

Transaction Number CHAR 10 CRM_OBJ_ID Check - PROD1

GUID CRM Order Obj. CHAR 32 CRM_OHGUID Check - PROD1

Parent item CHAR 32 CRM_PARITM Blank

Business Trans. Type CHAR 4 CRM_PRCTYP Blank

Denominator INT4 10 Put 1 - 1

10th Exponent INT4 10 Put 1 - 1

Numerator INT4 10 Put 1 - 1

Reason for Rejection CHAR 2 CRM_REJECT Blank

Requested deliv.date DATS 8 CRM_REQDAT - 20061016

Goods Recipient CHAR 10 CRM_SHIPTO - CUST1 (Not created in master)

Source System CHAR 10 LOGSYS - EXCEL

Material CHAR 18 MATERIAL - PROD1

Update Mode CHAR 1 RECORDMODE - F

Sales unit UNIT 3 SALES_UNIT - EA

Product CHAR 32 CRM_PROD - PROD1

Base Unit UNIT 3 BASE_UOM - EA

Product ID CHAR 40 CRMPROD_ID - PROD1

and have also imported this file into the demand history, but the "order quantity" is missing as well as the whole file in the "manual adjustment of raw data". Does anyone know, what´s the problem??

Thank you so much in advance,

Almi

[Former Member]

Are you on SCM 5.0? If yes then try to first download the CSV file and then do the changes and upload the data.

May in your current file you are missing somthing

[Former Member]

Hola Anjali,

First of all, thank you for your quick answer.

I don´t think that there is anything missing in the CSV file. We are using SPP and also have the SCM 5.0. See if we load the file into SPP neither the order quantity, nor is the file in the "manual adjustment of raw data" is shown . What do u mean by downloading and uploading?

Thank you,

Almi