Combining mapping load from xls and load from sql

[#1]

Good morning,

I want to combine a mapping load from xls and a load from sql and run into probs with syntax. Below script results in an error message "field GL_AccountDebit.GLACCT_D unknown" - what is the right syntax?

Directory;
AccountsD:
mapping LOAD
     [G/L Account.SAKNR] as GL_AccountDebit.GLACCT_D,
     [Long Text.TXT50] as LongText.TXT50_D
FROM
skat.XLS
(txt, unicode, embedded labels, delimiter is '\t', msq);

CONNECT TO SAPdb;
RevAllocTable:
load

.... {many fields}

GLACCT_D as GL_AccountDebit.GLACCT_D,

.... {many more fields}

PSTNR as RA_PostingNumber.PSTNR,
ApplyMap ('AccountsD', GL_AccountDebit.GLACCT_D, 'Not Populated') as GL_Name;
select * from SAPdb.SAP."ZFI_RA_POST";

[MK_QSL · Accepted solution]

Try

ApplyMap ('AccountsD', GLACCT_D , 'Not Populated') as GL_Name;