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
99

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
40

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
40

DDMMYY Convert to DD.MM.YYYY

0 Kudos
40

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

Former Member
0 Kudos
40

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
40

v1 = date+0(2)

v2 = date+3(2)

v3 = date+5(4).

concatenate v1 v2 v3 into date separated by '.'

0 Kudos
40

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