‎2006 Mar 30 3:39 PM
‎2006 Mar 30 3:40 PM
Hi
take data element <b>BOOLEAN</b>
(X=true, -=false, space=unknown)
‎2006 Mar 30 3:43 PM
‎2006 Mar 30 3:52 PM
i mean in se11 when i want to craete
i look for it and i didnt find
‎2006 Mar 30 3:54 PM
‎2006 Mar 30 3:42 PM
hi rani,
1. for logical do u mean true/false.
2. then we use char 1 only.
if 'X' then it has to be understood as true.
else
false.
3***********
why sap uses this concept ?
bcos.
<b>So that SAP can operate in different databases.</b>
MS Sql server has got boolean type for tables,
but ORACLE does not have.
So SAP decided to have one COMMON CONCEPT
of using CHAR 1 as
type boolean.
This is similar to DATE Field.
DATE field is also stored as CHAR (8)
WHY?
bcos different database store
DATE field in different formats.
OrACle saves date field (along with time also)
(its saving format is different than
that of mssql server)
Hence, SAP uses
MOST OF THE TIME,
CHAR fields for all types of purpose.
(whether boolean, logical, date, time etc etc)
regards,
amit m.
Message was edited by: Amit Mittal