10-22-2007 7:39 AM
hi
friends
can any body help what is the structure and file format i have to give when i run RFBIKR00 program to create vendor master data ... thanx in advance ..
by
leee
10-22-2007 7:46 AM
Hi
Are you trying to upload the data ??
in that the program does some validation of
the data, unlike most upload programs. For instance, you have to make sure
that a vendor exists before you attempt to change it through transaction
XK02, otherwise an error report is produced.
In terms of data structure, the file must have a header segment as the first
record (type 0), then various segment 1s and 2s. I don't know all the
various combinations of 1s and 2s, but my client has used the RFBIKR00
program 4 times in its vendor migration, the first 3 files creating
different parts of the vendor data. Obviously the data itself is company
confidential, but I can tell you the segment structure of each file:
First file - Create General Data
0YDL_MIS00251600PJA77336 20020713X/ (File Header)
1XK01 ...
2BLFA1
1XK01 ...
2BLFA1
etc
Second file - Create Company Code Data
0YDL_MIS00252600PJA77336 20020713X/
1XK01
2BLFB1
1XK01
2BLFB1
etc.
Third file - Create Purchase Organisation Data
0YDL_MIS00253600PJA77336 20020713X/
1XK01
2BLFM1
1XK01
2BLFM1
etc.
Fourth file - change (Partner Functions Data)
0YDL_MIS00254600PJA77336 20020713X/
1XK02
2BLFA1
2BLFM2
2BWYT3
2BWYT3
1XK02
2BLFA1
2BLFM2
2BWYT3
2BWYT3
etc.
Separate programs are required to migrate vendor addresses, classification
and text. If you go into transaction SXDA, put in LFA1, BINP and RFBIKR00,
and copy the file to a location on a server, you can view the generic
structure required using the Change file button.
n LSMW you can take a file in whatever format you have,
map the fields as necessary, and write to the structures
needed by RFBIKR00. There is even a place within LSMW
to run RFBIKR00 afterwards. Depending on what's coming in
you may only have to link the fields across with no
translation.
By using LSMW you won't need to write any ABAP to open
the file and change the format - all this is integrated
in LSMW. Look at <URL:http://service.sap.com/lsmw> for
an outline, dowloading and installing LSMW and for
detailed documentation.
LSMW is in effect "middleware" - though if you are able
to get the original data in exactly the format used by
RFBIKR00 then you won't need it.
If you must write your own program to feed RFBIKR00 then
the "made easy" guide is a good start, plus the SAP
documentation of the program, and study of the
structures via SE11.
Make sure any mandatory fields either have an entry in the
source data or that you can apply a default (which is also
very easy in LSMW).
Regards
Pavan
10-22-2007 7:42 AM
hi read documentation of that abap
use the foll.structures:
-BGR00
-BLFA1
-BLFB1
-BLFBK
-BLFB5...
A.
Message was edited by:
Andreas Mann
10-22-2007 7:50 AM
hi
Andreas Mann
i had read the document but i understand some ponits .. when i run the program its asking the file name what r the things i have to place in that file can u give the what will be the file contents ... its very helpfull
by
leee
.
10-22-2007 7:46 AM
Hi
Are you trying to upload the data ??
in that the program does some validation of
the data, unlike most upload programs. For instance, you have to make sure
that a vendor exists before you attempt to change it through transaction
XK02, otherwise an error report is produced.
In terms of data structure, the file must have a header segment as the first
record (type 0), then various segment 1s and 2s. I don't know all the
various combinations of 1s and 2s, but my client has used the RFBIKR00
program 4 times in its vendor migration, the first 3 files creating
different parts of the vendor data. Obviously the data itself is company
confidential, but I can tell you the segment structure of each file:
First file - Create General Data
0YDL_MIS00251600PJA77336 20020713X/ (File Header)
1XK01 ...
2BLFA1
1XK01 ...
2BLFA1
etc
Second file - Create Company Code Data
0YDL_MIS00252600PJA77336 20020713X/
1XK01
2BLFB1
1XK01
2BLFB1
etc.
Third file - Create Purchase Organisation Data
0YDL_MIS00253600PJA77336 20020713X/
1XK01
2BLFM1
1XK01
2BLFM1
etc.
Fourth file - change (Partner Functions Data)
0YDL_MIS00254600PJA77336 20020713X/
1XK02
2BLFA1
2BLFM2
2BWYT3
2BWYT3
1XK02
2BLFA1
2BLFM2
2BWYT3
2BWYT3
etc.
Separate programs are required to migrate vendor addresses, classification
and text. If you go into transaction SXDA, put in LFA1, BINP and RFBIKR00,
and copy the file to a location on a server, you can view the generic
structure required using the Change file button.
n LSMW you can take a file in whatever format you have,
map the fields as necessary, and write to the structures
needed by RFBIKR00. There is even a place within LSMW
to run RFBIKR00 afterwards. Depending on what's coming in
you may only have to link the fields across with no
translation.
By using LSMW you won't need to write any ABAP to open
the file and change the format - all this is integrated
in LSMW. Look at <URL:http://service.sap.com/lsmw> for
an outline, dowloading and installing LSMW and for
detailed documentation.
LSMW is in effect "middleware" - though if you are able
to get the original data in exactly the format used by
RFBIKR00 then you won't need it.
If you must write your own program to feed RFBIKR00 then
the "made easy" guide is a good start, plus the SAP
documentation of the program, and study of the
structures via SE11.
Make sure any mandatory fields either have an entry in the
source data or that you can apply a default (which is also
very easy in LSMW).
Regards
Pavan
10-22-2007 8:15 AM
hi
pavan
thax for u reply
u mentiond first record type 0
0 YDL_MIS00251600PJA77336 20020713X this is what our uploaded data ?
and 1 and 2 r transaction and structures .
my quastion is suppose if i have 10 records dos it meen that we have to give in header data only affter that 1 2 will follows
like
0 YDL_MIS00251600PJA77336 20020713X
0 YDL_MIS00251600PJA77336 20020713X
0 YDL_MIS00251600PJA77336 20020713X
0 YDL_MIS00251600PJA77336 20020713X
'
'
'
'
'
0 YDL_MIS00251600PJA77336 20020713X 10 th record
and next
1
2
like that is it so....
can u give clarification
by
leee