Problem
Created a flat file datasource for uploading master data.Data loaded fine upto PSA.Once the DTP which runs the transformation is scheduled, its ends up in error as below:
Solution
After refering to many links on sdn, i found that since the data is from an external file,the data will not be matching the SAP internal format. So it shud be followed that we mark "External" format option in the datasource ( in this case for Material ) and apply the conversion routine MATN1 as shown in the picture below:
Once the above changes are done, the load was successful.
Knowledge from SDN forums
Conversion takes place when converting the contents of a screen field from display format to SAP-internal format and vice versa and when outputting with the ABAP statement WRITE, depending on the data type of the field.
Check the info here:
http://help.sap.com/saphelp_nw04/helpdata/en/2b/e9a20d3347b340946c32331c96a64e/content.htm
http://help.sap.com/saphelp_nw04/helpdata/en/07/6de91f463a9b47b1fedb5be18699e7/content.htm
This fm ( MATN1) will add leading ZEROS to the material number because when u query on MAKT with MATNR as just 123 you wll not be getting any values, so u should use this conversion exit to add leading zeros.
Labels
- BW Architecture (1)
- BW Reporting (3)
- Data Loading issues (7)
- Datawarehousing (9)
- Extraction (3)
- General Maintainence (5)
- HANA (1)
Blog Archive
-
▼
2008
(21)
-
▼
September
(17)
- Difference between LIS and LO Extraction
- What will happend if a request in Green is deleted?
- When is reconstruction allowed? Questions
- Handling Amount Values with currencies in BW
- PSA reverse posting
- Unable to Cancel Job in SM37 (R3)
- Attribute delta loading "duplicate record found"
- How to supress messages generated by BW Queries
- Dimension Size Vs Fact Size
- BW Main tables
- Production Support Issues in BW
- Selective Deletion in Process Chain
- How to Debugg Update and transfer Rules
- BW tables
- How to define F4 Order Help for infoobject for rep...
- TCURF, TCURR and TCURX
- Error loading master data - Data record 1 ('AB03...
-
▼
September
(17)
Subscribe to:
Post Comments (Atom)
1 comment:
I've been searching for a while, and this post just saved me.
Thanks !
Post a Comment