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
105

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
46

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
46

DDMMYY Convert to DD.MM.YYYY

0 Kudos
46

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

Former Member
0 Kudos
46

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
46

v1 = date+0(2)

v2 = date+3(2)

v3 = date+5(4).

concatenate v1 v2 v3 into date separated by '.'

0 Kudos
46

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