topic Ensure field sequence is correct for data for mutiple source structure in Application Development and Automation Discussions

Ensure field sequence is correct for data for mutiple source structure

Former Member — Wed, 09 Apr 2008 13:29:50 GMT

Hi,

I'm using LSMW with IDOC message type 'FIDCC2' Basic type 'FIDCCP02'.

I'm getting error that packed fields are not permitted.

I'm getting Ensure field sequence is correct for data for mutiple source structures.

***************************************************************************************************************************

Source Structures

HEADER_STRUCT G/L Account Document Header

LINE_STRUCT G/L Account Document Line

***************************************************************************************************************************

Source Fields

HEADER_STRUCT G/L Account Document Header

BKTXT C(025) Document Header Text

BLART C(002) Document Type

BLDAT DYMD(008) Document Date

BUDAT DYMD(008) Posting Date

KURSF C(009) Exchange rate

WAERS C(005) Currency

WWERT DYMD(008) Translation Date

XBLNR C(016) Reference

LINE_STRUCT G/L Account Document Line

AUFNR C(012) Order

HKONT C(010) G/L Account

KOSTL C(010) Cost Center

MEINS C(003) Base Unit of Measure

MENGE C(013) Quantity

PRCTR C(010) Profit Center

SGTXT C(050) Text

SHKZG C(001) Debit/Credit Ind.

WRBTR AMT3(013) Amount

I have changed PAC3 field for caracters fields of same length to avoid erreur message of no packed fields allowed.

***************************************************************************************************************************

Structure Relations

E1FIKPF FI Document Header (BKPF) <<<< HEADER_STRUCT G/L Account Document Header

Select Target Structure E1FIKPF .

E1FISEG FI Document Item (BSEG) <<<< LINE_STRUCT G/L Account Document Line

E1FISE2 FI Document Item, Second Part of E1FISEG (BSEG)

E1FINBU FI Subsidiary Ledger (FI-AP-AR) (BSEG)

E1FISEC CPD Customer/Vendor (BSEC)

E1FISET FI Tax Data (BSET)

E1FIXWT Extended Withholding Tax (WITH_ITEM)

***************************************************************************************************************************

Files

Legacy Data On the PC (Frontend)

File to read GL Account info c:\GL_Account.txt

Data for Multiple Source Structures (Sequential Files)

Separator Tabulator

Field Names at Start of File

Field Order Matches Source Structure Definition

With Record End Indicator (Text File)

Code Page ASCII

Legacy Data On the R/3 server (application server)

Imported Data File for Imported Data (Application Server)

Imported Data c:\SYNERGO_CREATE_LCNA_FI_GLDOC_CREATE.lsmw.read

Converted Data File for Converted Data (Application Server)

Converted Data c:\SYNERGO_LCNA_FI_GLDOC_CREATE.lsmw.conv

Wildcard Value Value for Wildcard '*' in File Name

***************************************************************************************************************************

Source Structures and Files

HEADER_STRUCT G/L Account Document Header

File to read GL Account info c:\GL_Account.txt

LINE_STRUCT G/L Account Document Line

File to read GL Account info c:\GL_Account.txt

***************************************************************************************************************************

File content:

Document Header Text Document Type Document Date Posting Date Exchange rate Currency Translation Date Reference

G/L Account document SA 20080401 20080409 1.05 CAD 20080409 Reference

Order G/L Account Cost Center Base Unit of Measure Quantity Profit Center Text Debit/Credit Ind. Amount

44000022 1040 Line item text 1 H 250

60105M01 13431 TO 10 Line item text 2 S 150

800000 60105M01 Line item text 3 S 100

60110P01 6617 H 40 Line item text 4 S 600

44000022 ACIBRAM Line item text 5 H 600

The file structure is as follow

Header titles

Header info

Line titles

Line1 info

Line2 info

Line3 info

Line4 info

Line5 info

****************************************************************************************************************************

Could someone direct me in the wright direction?

Thank you in advance!

Curtis

Re: Ensure field sequence is correct for data for mutiple source structure

Former Member — Wed, 09 Apr 2008 19:11:48 GMT

I worked out the errors.

Thanks you!

Re: Ensure field sequence is correct for data for mutiple source structure

Former Member — Wed, 02 Jul 2008 13:24:51 GMT

Hi ,

I am getting the Same error.While Specifying the file we need to specify

Header title

Header Info

Item title

Item Info like this or

we need to specify like this

i have specified like this in the flat file.Is this correct

Headertitle

Itemtitle

Headerinfo

iteminfo.

In the LSMW step '9' Read data then i am geeting this Information How to solve this pblm.

Please give me the answer.

Thanks,

Swapna

Re: Ensure field sequence is correct for data for mutiple source structure

Former Member — Wed, 02 Jul 2008 17:42:34 GMT

In source field. Create a field that will represent your structure. In the definition of the field there's an item called IDENTIFYING FEILD CONTENT here you put a caracter that will identify the line for that structure.

Ex.: struct1

fields:

ident C 1 contains "H"

name C 30

adress C 50

.....

Struct2

fields

ident C 1 contains "L"

....

The Ident field is the one that will tell LSMW that this line is for this structure.

In m'I case I put "H" for header and "L" for lines for the header.

Regards

Re: Ensure field sequence is correct for data for mutiple source structure

Former Member — Thu, 03 Jul 2008 13:05:23 GMT

Hi,

Thank you so much for yout reply.

For example

i have VBAK(Heder structure)

VBAP( Item Structure)

My file should be like this i think

Identification content Fieldnames

H VBELN ERDAT ERNAM

Fieldvalues for header

H 1000 20080703 swapna

Identification content Fieldnames

I VBELP AUART

Fieldvalues for item

I 001 OR

002 OR

Is this format is correct.

Let me know whether i am correct or not

Re: Ensure field sequence is correct for data for mutiple source structure

Former Member — Thu, 03 Jul 2008 13:10:24 GMT

Yes this is correct.

So the flat file that will be read from LSMW will know what the lines are.

"H" for header and "I" for lines of the header file.

This way you can put all data together in the same flat file.

Ex.:

....

Regards.