Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

flat file

Former Member
0 Likes
351

hi gurus

could u plz send me a flat file used for BDC using line items

good points will be rewarded

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
329

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

1 REPLY 1
Read only

Former Member
0 Likes
330

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