Question:
Hello All,
I would like to know some thing about data transfer. I want to upload the charecteristics into the system. I selected Data Transfer Workbench. I created a text file entered the data of Object Type:-BUS1088, Program type:-BINP, and program method :-RCCTBI01. I am confused as on file structure. What should be structre of the file to be uploaded.
Please guide me on as how to create file for uploading. What should be the structure of file and how the data should be fed in the file??
Answer:
hi,
the prefered way to load masters is using LSMW.
To create characteristics use the object 0150 and standard program RCCTBI01.
If you want to just create characteristics without assigning any values, then create a single level structure. You can also do a recording of the transaction instead of using the standard program RCCTBI01 for this purpose.
If you want to just create characteristics and assign values, then you have to create a two level structure. The first level should contain the header details of the characteristics & the second level should contain the values.
Hope this helps you to get started.
_________________
Regards,
Chanda
"Everything is possible. Impossible takes longer."
PM/CS FAQ
Answer:
Hi Chanda,
I tried the LSMW but was not able to upload the data.
The problem came in the step no. 11 i.e. Convert Data. The conversion program generated was not able to convert data from and in the summary it showed
Transactions read: 1
Records read: 1
Transactions written: 0
Records written: 0
can you plz guide on the same
Thanks in advance
Answer:
hi,
i cannot point out the error whithout seeing the LSMW. Can u send me a mail with the screen shots of the following:
1. source fields
2. structure relation
3. specify files (properties)
4. assign files
5. the upload flat file
mkchanda@yahoo.com
_________________
Regards,
Chanda
"Everything is possible. Impossible takes longer."
PM/CS FAQ
Answer:
Hi,
I do not think LSMW helps in this case as there seems to be some problem wrt Tcode CT04.
Still if there is some way out do let me know.
Regards
Answer:
Hi,
This is an example of a LSMW program that I use.
2.2.1 1-Characteristics Creation :Code & additional list of value
Data transfer program: RCCTBI01
Data transfer method: B (Batch input)
2.2.1.1 Source structures
CHARAC_HEADER - CHARAC_HEADER
CHARAC_LOV - CHARAC_LOV
2.2.1.2 Target struct.
BGR00 - Batch Input Structure for Session Data
BIMST - Batch input for characteristics
BIMZW - Batch Input: Allowed Characteristic Values
2.2.1.3 Structure relations
BGR00 <=== CHARAC_HEADER
BIMST <=== CHARAC_HEADER
BIMZW <=== CHARAC_LOV
2.2.1.4 Source fields
CHARAC_HEADER - CHARAC_HEADER
NAME NAME Type: C Lgth: 030 Position: 0001
DESCRIPTION DESCRIPTION Type: C Lgth: 030 Position: 0002
TYPE TYPE Type: C Lgth: 004 Position: 0003
LEN Lgth Type: N Lgth: 002 Position: 0004
UOM UOM Type: C Lgth: 006 Position: 0005
DECIMAL DECIMAL Type: N Lgth: 001 Position: 0006
CHARAC_LOV - CHARAC_LOV
NAME NAME Type: C Lgth: 030 Position: 0001
VALUE VALUE Type: C Lgth: 030 Position: 0002
DESC DESC Type: C Lgth: 030 Position: 0003
2.2.1.5 Target fields
BGR00 - Batch Input Structure for Session Data
See the same structure in §2.1.1.5
BIMST - Batch input for characteristics
STYPE Batch input interface record type Type: CHAR Lgth: 001
TCODE Transaction code Type: CHAR Lgth: 020
NAME Characteristic name Type: CHAR Lgth: 030
NAME_REF Characteristic to be copied from Type: CHAR Lgth: 030
DESCRIPT Characteristic description Type: CHAR Lgth: 030
FORMAT Data type of characteristic Type: CHAR Lgth: 004
LENGTH Number of characters Type: CHAR Lgth: 002
DECIMALS Number of decimal places Type: CHAR Lgth: 002
UNIT Unit of measure, language-depend. Type: CHAR Lgth: 006
INPUTREQU Entry required Type: CHAR Lgth: 001
SIGN Value with plus or minus sign Type: CHAR Lgth: 001
LOWERCASE Case sensitive Type: CHAR Lgth: 001
PATTERN Value with template Type: CHAR Lgth: 030
INTERVAL Interval values allowed Type: CHAR Lgth: 001
NO_VAL_CHK Indicator: additional values Type: CHAR Lgth: 001
TABLENAME Table name Type: CHAR Lgth: 030
FIELDNAME Field name Type: CHAR Lgth: 030
DISP_VALUE Display allowed values Type: CHAR Lgth: 001
USE_PATT Ind. :displ.template when ass. Type: CHAR Lgth: 001
STATUS Status of a characteristic Type: CHAR Lgth: 001
MULTIPLE Indicator: value allowed for Type: CHAR Lgth: 001
EXPO_TYPE Exponent display format Type: NUMC Lgth: 001
EXPONENT Exponent display Type: CHAR Lgth: 002
TITLE1 First line of heading Type: CHAR Lgth: 030
TITLE2 Second line of heading Type: CHAR Lgth: 030GROUP Characteristics group Type: CHAR Lgth: 010
BIMZW - Batch Input: Allowed Characteristic Values
STYPE Batch input interface record type Type: CHAR Lgth: 001
XLINE Line index for int. table processing Type: NUMC Lgth: 004
WERT Characteristic value Type: CHAR Lgth: 030
WERTEBEZ Characteristic value descript . Type: CHAR Lgth: 030
VORSCHLAG Default value Type: CHAR Lgth: 001
2.2.1.6 Fieldmapping
All fields not listed of the R/3 structures keep their initial values.
Struct.: BGR00
__BEGIN_OF_RECORD__ BGR00 = INIT_BGR00.
BGR00-STYPE Default settings BGR00-STYPE = '0'.
BGR00-GROUP Default settings BGR00-GROUP= g_groupname.
BGR00-MANDT Default settings BGR00-MANDT = SY-MANDT.
BGR00-USNAM Default settings BGR00-USNAM = g_userid.
BGR00-START Default settings BGR00-START = ''.
BGR00-XKEEP Default settings BGR00-XKEEP = ''.
BGR00-NODATA Default settings BGR00-NODATA = ''.
__END_OF_RECORD__
at_first_transfer_record.
if g_cnt_transactions_group = 5000.
g_cnt_transactions_group = 0.
transfer_record.
endif.
Struct.: BIMST
__BEGIN_OF_RECORD__ BIMST = INIT_BIMST.
BIMST-STYPE Default settings BIMST-STYPE = '1'.
BIMST-TCODE ABAP Coding BIMST-TCODE = 'CT01'.
BIMST-NAME <=== CHARAC_HEADER-NAME Transfer (MOVE) BIMST-NAME = CHARAC_HEADER-NAME.
BIMST-DESCRIPT <=== CHARAC_HEADER-DESCRIPTION Transfer (MOVE) BIMST-DESCRIPT = CHARAC_HEADER-DESCRIPTION.
BIMST-FORMAT <=== CHARAC_HEADER-TYPE
Rule type: ABAP Coding
perform lsmw_translate
using 'CONVERT_TYPE'
CHARAC_HEADER-TYPE
changing BIMST-FORMAT.
BIMST-LENGTH <=== CHARAC_HEADER-LEN Transfer (MOVE) BIMST-LENGTH = CHARAC_HEADER-LEN.
BIMST-DECIMALS <=== CHARAC_HEADER-DECIMAL Transfer (MOVE) BIMST-DECIMALS=CHARAC_HEADER-DECIMAL.
BIMST-UNIT <=== CHARAC_HEADER-UOM
Rule type: Translation (reusable)
perform lsmw_translate
using 'CHARACTERISTIC_UOM'
CHARAC_HEADER-UOM
changing BIMST-UNIT.
BIMST-NO_VAL_CHK Constant BIMST-NO_VAL_CHK = 'X'.
BIMST-STATUS Constant BIMST-STATUS = '1'.
__END_OF_RECORD__ transfer_record.
Struct.: BIMZW
__BEGIN_OF_RECORD__ BIMZW = INIT_BIMZW.
BIMZW-STYPE Default settings BIMZW-STYPE = '2'.
BIMZW-WERT <=== CHARAC_LOV-VALUE Transfer (MOVE) BIMZW-WERT = CHARAC_LOV-VALUE.
BIMZW-WERTEBEZ<===CHARAC_LOV-VALUE Transfer (MOVE) BIMZW-WERTEBEZ=CHARAC_LOV-VALUE.
__END_OF_RECORD__ transfer_record.
__END_OF_TRANSACTION__ transfer_transaction.
__END_OF_RECORD__ transfer_record.
Answer:
hi,
Maquidy delivers again! I couldn't have explained it better.
Guest : The tranx code to be used for the LSMW is CT01
_________________
Regards,
Chanda
"Everything is possible. Impossible takes longer."
PM/CS FAQ
Answer:
Hi Chanda,
TCode CT01 is an obsolete code as per SAP, and it recommends the use of CT04 for the same. When u try to use CT01 u get the following message
Use transaction CT04 for characteristics management
Message no. C1 898
Diagnosis
You are about to use an obsolete transaction. This transaction is no
longer fully supported.
Procedure
Use transaction CT04.
Answer:
hi guest,
you are absolutely right about CT01 being obsolete...BUT FOR BATCH INPUT(BI) WITH PROGRAM RCCTBI01 YOU HAVE TO USE CT01 !
Here is the excerpt of the OSS message I had recieved regarding creation of characteristics thro batch input program RCCTBI01:
"Pls note that txn CT01 is obsolete and should not be used
any more. Because many customers have existing BIs for this txn we had
to support BI for CT01 nevertheless. So for BI please use CT01.
In batch input characteristics can only be created: please use program
RCCTBI01 for this purpose"
_________________
Regards,
Chanda
"Everything is possible. Impossible takes longer."
PM/CS FAQ