Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Validation of date , Posting key and Account

Former Member
0 Kudos
109

Hi,

I am getting a date it DDMMYY format, want to check if it is in the right format and then change to normal format (DD.MM.YYY). is there any FM for this?

the given posting keys and Accounts are Exist in SAP or not? how to check and

posting keys are stored in which table

Accounts stored in which table

Plz give me the table names of both posting keys and Accounts

i look forward to your reply

point will be rewarded

Thanks & Regards

SEK

6 REPLIES 6

Former Member
0 Kudos
50

Hi,

To check the validity of the Date use the

FM <b>DATE_CHECK_PLAUSIBILITY</b>

To convert from YYYYMMDD to DDMMYYY use the

FM <b>CONVERSION_EXIT_PDATE_OUTPUT</b>

Check table for Posting Key

<b>TBSL</b>

As for Account Number

If Customer - <b>KNA1</b>

Vendor - <b>LFA1</b>

G/L Account - <b>SKA1</b>

Message was edited by:

Dominic Pappaly

0 Kudos
50

DDMMYY Convert to DD.MM.YYYY

0 Kudos
50

The FM CONVERSION_EXIT_PDATE_OUTPUT will convert it from YYYYMMDD to DD.MM.YYYY

Former Member
0 Kudos
50

Hi Mr Raja..

To check the validity for date : FM DATE_CHECK_PLAUSIBILITY

and the Check table for Posting Key TBSL

Former Member
0 Kudos
50

v1 = date+0(2)

v2 = date+3(2)

v3 = date+5(4).

concatenate v1 v2 v3 into date separated by '.'

0 Kudos
50

Hi,

There cud b a simpler way to convert yyyymmdd into ddmmyy .

CONCATENATE date_S16(2) '.' date_S14(2) '.' date_S1+0(4) INTO DATE_FINAL.

date_s1 and date_final must be of string type .

Regards,

Nishu Gupta