topic Re: csv format in Application Development and Automation Discussions

csv format

Former Member — Thu, 09 Nov 2006 05:54:31 GMT

I am getting the file in xml format.

From here my analyst programmer writes it into csv file so that we can code extraction program with ABAP.

Till now the data we were getting are with single PO number

Ex…file format(csv)

EDI_DC40 800 620 0 ZCPAOC01 ZCPAOC

ZSTBM_LOT,,,,0000032R5659,0,D7N3650WFB,,4485,IBM,,,ASMVIEWBR,Production,,,,V0,00,BH,,KR,,,D7,FB,BS,,1C,,20060908,005600007,NORMAL PROCESS

ZSTBM_STAGE,IBM_TST

ZSTBM_STAGE,IBM_BI

Now I am getting the file with multiple PO’s and multiple PO numbers…how should I maintain the line item values in my csv file. A single Po will be having 2-3 line items.

My question is “how should I advise my analyst programmer to keep the multiple line items?

Re: csv format

Former Member — Thu, 09 Nov 2006 06:06:02 GMT

U can ask him to keep the po number along with the line item details in every line. In this way while reading in the program it will be easy for u to distinguish between different PO line items as u will be having the PO number along with the line item.

Re: csv format

Former Member — Thu, 09 Nov 2006 06:17:03 GMT

Hi Phani,

thanks for th eprompt reply..

along with po means i reckon: po,poline item is n't it?

i might get the same PO number with different line items as well different PO number with different PO lineitems.

please advise me with the above and also can u give me som eexample scenario with the down example.

ex: po, poline item

thank you

Re: csv format

Former Member — Thu, 09 Nov 2006 06:25:33 GMT

phanai thanks i got clue. i am closing the post. and rewarding points.