topic Re: Account Validation in Application Development and Automation Discussions

Account Validation

Former Member — Sun, 03 Dec 2006 12:15:01 GMT

Hi All,

i created one bdc for FI Documents postings

during uploading process , i want validate the accounts,if the account exist in the SAP then only create session otherwise display error log file

how to validate the accounts

Plz give me the sample code

i look forward to your reply

Thanks & Regards

SEK

Re: Account Validation

Former Member — Sun, 03 Dec 2006 12:51:05 GMT

It depends on which type of account you need to check.

U can do two validations:

- The first one: check if the account exists;

- The second one: check if the account is defined for the company code.

- Vendor account: check if It's in LFA1 and LFB1

- Customer account: check if It's in KNA1 and KNB1

- G/L account: check if It's in SKA1 and SKB1

Max

Re: Account Validation

Former Member — Mon, 04 Dec 2006 10:15:07 GMT

Hi,

thank you for your reply

if anybody have sample code for account validation plz send me

i look forward to your reply

Thanks Regards

SEK

Re: Account Validation

andreas_mann3 — Mon, 04 Dec 2006 10:17:47 GMT

hi,

try:

select count( * ) from knb1 into sy-dbcnt

where kunnr = itab-kunnr

and bukrs = itab-bukrs.

if sy-dbcnt 0.

-> write to error log

Message was edited by:

Andreas Mann

Re: Account Validation

Former Member — Mon, 04 Dec 2006 11:42:20 GMT

Hi ,

Thank you for your reply

data : begin of itab,

NEWKO1 LIKE BSEG-NEWKO,

NEWKO2 LIKE BSEG-NEWKO,

ENDOF ITAB.

From the Excel sheet we upload the data into ITAB

loop at itab.

Here the validation part comes

itab-newko the uploaded accounts exist in the sap or not

if sy-subrc ne 0. not exist in sap

the move the data to errtab

delete from itab.

endif.

my main problem is how to validate the uploaded accounts is exist in the sap or not

plz send sample code for validation

i look forward to your reply

Thanks & Regards

SEK