2 Replies Latest reply: Mar 5, 2012 8:16 PM by Brenda Bankert RSS

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

E18 SAP
Currently Being Moderated

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.

Actions