Table BUT000 Business partner Valid From Date: how to decrypt?

[Former Member]

Hello

how can convert in a Microsoft Excel function (or a function module in SAP) the values in the date fields in table BUT000?

VALID FROM 20.120.131.000.000

VALID TO 99.991.231.235.959

I am checking these table with transaction SE16. I cannot understand the contents of these date fields. I need to know which date is in the table as I have to find out why I get warning u201CPartner XXX cannot be used, as per contract 01.01.2012 FTR_GUI220u201D although in all date fields in the business partner have a date before 01.10.2012. So before mentioned warning should not pop up?!

All tables that I want to check on the date field contents:

BUT000

BUT020

BUT0BK

BUT100

All these tables are time dependent.

[marcin_cholewczuk]

Hi,

This is timestamp, so format is YYYYMMDDHHMMSS - just ignore dots. In your case object is active since 31.01.2012.

To which format you want to convert it?

BR

Marcin Cholewczuk

[Former Member]

You can use FM IB_CONVERT_FROM_TIMESTAMP to convert a timestamp to date and time.

The output for your VALID TO 99.991.231.235.959 would be

Date = 31.12.9999

Time = 23:59:59

Brenda