‎2008 Jun 04 4:57 PM
hi gurus
could u plz send me a flat file used for BDC using line items
good points will be rewarded
‎2008 Jun 04 5:11 PM
Hi,
this depends on the requirement.
In some cases there may be 2 flat files.
one for header and second for items
In some cases there may be 1 flat file.
2 flat files : one for header and another for item.
here header is vendor details and items bank details.
header file
zsample1 0001 0001 0001 ................
zsample2 0001 0001 0001 ................
zsample3 0001 0001 0001 ................
items file.
zsample1 DE 100000 name1
zsample1 DE 100001 name2
zsample2 DE 100000 name1
zsample2 DE 100001 name2
Incase of singlefile details will be as follows:
zsample1 0001 0001 0001.......DE 100000 name1
zsample1 0001 0001 0001.......DE 100001 name2
zsample2 0001 0001 0001 ....DE 100000 name1 .
zsample2 0001 0001 0001 ... DE 100000 name2
Just records will be duplicated except at the item values incase of single file.
Hope this is clear for you.
Reward points if helpful .
Thanks and regards
‎2008 Jun 04 5:11 PM
Hi,
this depends on the requirement.
In some cases there may be 2 flat files.
one for header and second for items
In some cases there may be 1 flat file.
2 flat files : one for header and another for item.
here header is vendor details and items bank details.
header file
zsample1 0001 0001 0001 ................
zsample2 0001 0001 0001 ................
zsample3 0001 0001 0001 ................
items file.
zsample1 DE 100000 name1
zsample1 DE 100001 name2
zsample2 DE 100000 name1
zsample2 DE 100001 name2
Incase of singlefile details will be as follows:
zsample1 0001 0001 0001.......DE 100000 name1
zsample1 0001 0001 0001.......DE 100001 name2
zsample2 0001 0001 0001 ....DE 100000 name1 .
zsample2 0001 0001 0001 ... DE 100000 name2
Just records will be duplicated except at the item values incase of single file.
Hope this is clear for you.
Reward points if helpful .
Thanks and regards