Question Re: No records read LSMW FI-AA Direct Input in Enterprise Resource Planning Q&A

No records read LSMW FI-AA Direct Input

Former Member — Wed, 12 Nov 2008 16:57:24 GMT

Hi Gurus,

I am preparing a data load for FI-AA using LSMW Direct Input.

I need to do the load using the structures BALTD and BALTB. The Key Field used for both structure is:

TCODE C(004) Transaction code selected (Batch input)

RCTYP C(001) Record Type

ANLKL C(008) Asset Class

OLDN1 C(012) Old main asset number

OLDN2 C(012) Old asset subnumber

BUKRS C(004) Company Code

In the BALTD structure I am using:

BWCNT C(004) Number of following trans. records

Excel is the basic document from where a txt file is generated: text (tab delimited)

The problem is not with Excel because the invisible extra lines and columns are delited.

When doing the read the system returns the following:

LSM Workbench: Import Data For IOLABRAZIL, FIAD_CO, FI_AA_TR

11/12/2008 - 10:51:49

File(s) Read: C:\Documents and Settings\3giegl\TPG_P\RollOut\2 Acquire_Implement\Project\Data Load Maps\Test_FIAA_Load_TR.txt

C:\Documents and Settings\3giegl\TPG_P\RollOut\2 Acquire_Implement\Project\Data Load Maps\Test_FIAA_Load_TR1.xls

File Written: IOLABRAZIL_FIAD_CO_FI_AA_TR.lsmw.read

Source Structure Read Written Not Written

LSFIAATR 19 0 19

LSFIAAMS 1 1 0

Transactions Read: 1

Records Read: 1

Transactions Written: 1

Records Written: 1

The problem is that the system does 19 reads for the transactions while the sheet has no input records. What could be the cause?

Thanks in Advance

Glenn

Re: No records read LSMW FI-AA Direct Input

Former Member — Wed, 12 Nov 2008 17:14:42 GMT

can you send both structures?

Re: No records read LSMW FI-AA Direct Input

Former Member — Wed, 12 Nov 2008 17:47:36 GMT

LSFIAAMS Finance Fixed Asset Master Data (BALTD / RCTYP = 'A')

TCODE C(004) Transaction code selected (Batch input)

RCTYP C(001) Record Type

ANLKL C(008) Asset Class

OLDN1 C(012) Old main asset number

OLDN2 C(012) Old asset subnumber

BUKRS C(004) Company Code

TXT50 C(050) Asset description

TXA50 C(050) Asset description

ANLHTXT C(050) Asset main number text

SERNR C(018) Serial number

INVNR C(025) Inventory number

MENGE C(017) Quantity (Legacy Data Transfer FI-AA)

MEINS C(003) Base unit of measure (Legacy Data Transfer FI-AA)

AKTIV DDMY(010) Asset capitalization date

KOSTL C(010) Cost Center

WERKS C(004) Plant

STORT C(010) Asset location

ORD41 C(004) Evaluation group 1

ORD42 C(004) Evaluation group 2

LIFNR C(010) Account Number of Vendor or Creditor

HERST C(030) Manufacturer of asset

POSNR C(024) WBS element in investment project for legacy data transfer

AFABE01 C(002) Depreciation area (Legacy Data Transfer FI-AA)

NDJAR01 C(003) Planned useful life in years (Legacy Data Transfer FI-AA)

KANSW01 C(016) Cumulative APC (Legacy Data Transfer FI-AA)

KNAFA01 C(016) Cumulative ordinary dep. (Legacy Data Transfer FI-AA)

NAFAG01 C(016) Ord.dep. posted for the year (Legacy Data Transfer FI-AA)

AFABE02 C(002) Depreciation area (Legacy Data Transfer FI-AA)

NDJAR02 C(003) Planned useful life in years (Legacy Data Transfer FI-AA)

KANSW02 C(016) Cumulative APC (Legacy Data Transfer FI-AA)

KNAFA02 C(016) Cumulative ordinary dep. (Legacy Data Transfer FI-AA)

NAFAG02 C(016) Ord.dep. posted for the year (Legacy Data Transfer FI-AA)

AFABE03 C(002) Depreciation area (Legacy Data Transfer FI-AA)

NDJAR03 C(003) Planned useful life in years (Legacy Data Transfer FI-AA)

KANSW03 C(016) Cumulative APC (Legacy Data Transfer FI-AA)

KNAFA03 C(016) Cumulative ordinary dep. (Legacy Data Transfer FI-AA)

NAFAG03 C(016) Ord.dep. posted for the year (Legacy Data Transfer FI-AA)

BWCNT C(004) Number of following trans. records

LSFIAATR Finance Fixed Asset Transaction Data (BALTB / RCTYP = 'B')

TCODE C(004) Triggered transaction code - transactions (batch input)

RCTYP C(001) Record type for legacy data transfer

ANLKL C(008) Asset Class

OLDN1 C(012) Old main asset number

OLDN2 C(012) Old asset subnumber

BUKRS C(004) Company Code

BWASL C(003) Asset Transaction Type

BZDAT DDMY(010) Asset value date

ANBTR01 C(015) Trans. amount (legacy data transfer FI-AA)

ANBTR02 C(015) Trans. amount (legacy data transfer FI-AA)

ANBTR03 C(015) Trans. amount (legacy data transfer FI-AA)

Re: No records read LSMW FI-AA Direct Input

Former Member — Tue, 18 Nov 2008 16:38:28 GMT

The Reading of the wrong numbers of records has been solved. The error was appointing to the wrong file in the directory. What still has to be solved is the writing of the BALTB records to the application server.