KEMBAR78
Excel 3 | PDF | Computer Programming | Software Engineering
Scribd
Upload
34 views25 pages

Excel 3

Uploaded by

jpfrancisnaveen5
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
34 views25 pages

Excel 3

Uploaded by

jpfrancisnaveen5
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 25

FUNCTION LOGLOCKMOD

S
S
S
S
S
S
S
S
EXTINFO PRIMARYKEY
E 0
E 0
E 0
E 0
E 0
E 0
E 0
E 0
FOREIGNKEY FLGPRIMKEY
0
0
0
0
0
0
0
0
FLGFRGNKEY OBJ_TYPE
ESTVA
ESTVA
ESTVA
ESTVA
ESTVA
ESTVA
ESTVA
ESTVA
OBJ_KEY INT_CHAR
00000000000000189378000000000000000000009999960044
00000000000000189378000000000000000000009999960045
00000000000000189378000000000000000000009999960046
00000000000000189378000000000000000000009999975019
00000000000000189426000000000000000000009999960044
00000000000000189426000000000000000000009999960045
00000000000000189426000000000000000000009999960046
00000000000000189426000000000000000000009999975019
NAME_CHAR DESCR_CHAR
SAP_RMS_1010_001_PRICE Price
SAP_RMS_1010_001_CURR Currency Key
SAP_RMS_1010_001_UNIT Unit of Reference Quantity
SAP_RMS_1010_001_PEINH Price Unit
SAP_RMS_1010_001_PRICE Price
SAP_RMS_1010_001_CURR Currency Key
SAP_RMS_1010_001_UNIT Unit of Reference Quantity
SAP_RMS_1010_001_PEINH Price Unit
COUNTER CHAR_VALUE
0 40
0 INR
0 L
0 2
0 100
0 AUD
0 KG
0 4
DESCR_CVAL NUM_VAL_FM
40 4.0000000000000000E+01
INR 0.0000000000000000E+00
L 0.0000000000000000E+00
2 2.0000000000000000E+00
100 1.0000000000000000E+02
AUD 0.0000000000000000E+00
KG 0.0000000000000000E+00
4 4.0000000000000000E+00
MEAS_UNIT1 ISOCODE1
NUM_VAL_TO MEAS_UNIT2
0.0000000000000000E+00
0.0000000000000000E+00
0.0000000000000000E+00
0.0000000000000000E+00
0.0000000000000000E+00
0.0000000000000000E+00
0.0000000000000000E+00
0.0000000000000000E+00
ISOCODE2 VAL_RELATN
1
1
1
1
1
1
1
1
TOLER_FROM TOLER_TO
0.0000000000000000E+00 0.0000000000000000E+00
0.0000000000000000E+00 0.0000000000000000E+00
0.0000000000000000E+00 0.0000000000000000E+00
0.0000000000000000E+00 0.0000000000000000E+00
0.0000000000000000E+00 0.0000000000000000E+00
0.0000000000000000E+00 0.0000000000000000E+00
0.0000000000000000E+00 0.0000000000000000E+00
0.0000000000000000E+00 0.0000000000000000E+00
PERCENTAGE OPER_INC
0.0000000000000000E+00
0.0000000000000000E+00
0.0000000000000000E+00
0.0000000000000000E+00
0.0000000000000000E+00
0.0000000000000000E+00
0.0000000000000000E+00
0.0000000000000000E+00
ALLOC_NO DOC_TYPE
0
0
0
0
0
0
0
0
DOC_NUMBER DOC_VER
DOC_PART SUB_VALUES
SORT_FIELD RECNO_ROOT
1 185115
1 185115
1 185115
1 185115
1 185115
1 185115
1 185115
1 185115
REF_RECNRH FLAG
0
0
0
0
0
0
0
0
REF_RECNPH FLG_VALFIX_DESCR
0
0
0
0
0
0
0
0
OBJ_KEY_LONG CHAR_VALUE_LONG
40
INR
L
2
100
AUD
KG
4
DESCR_CVAL_LONG
40
INR
L
2
100
AUD
KG
4
Guidelines for Entering Decision Table Data

Condition columns take range expression as their cell values


Range Option Pattern
contains any contains any &1
contains only contains only &1
contains string contains string &1
currency equals currency equals
does not contain any contains not any &1
does not contain only contains not only &1
does not contain string contains no string &1
does not match pattern [<>&pattern]
ends with ends with &1
is between [&1..&2]
is equal to =&1
is greater than > &1
is greater than or equal to >= &1
is initial is initial
is less than < &1
is less than or equal to <= &1
is not between <&1;>&2
is not equal to <>&1
is not initial is not initial
is not valid is not valid
is valid is valid
matches pattern [&pattern]
starts with text starts with &1
unit equals unit equals

Result columns take constant expression as their cell values

Range Option Pattern


or &1 ; &2
(and) unless exclude &1

Result Column Type Pattern


Text &1
Number NUMBER
Boolean TRUE/FALSE (change the cell format to Text before
Amount NUMBER CURRENCY
Quantity NUMBER UNIT
Timepoint - Date Format YYYY-MM-DD
Timepoint - Date Time Format YYYY-MM-DDThh:mm:ss
Timepoint - Timestamp Format YYYY-MM-DDThh:mm:ssZ
Timepoint - Time Format Thh:mm:ss
Timepoint - Date Time with offset Format YYYY-MM-DDThh:mm:ss[+|-]hh:mm

Language E
Example
contains any abc
contains only abc
contains string abc
currency equals EUR
contains not any abc
contains not only abc
contains no string abc
[<>pattern]
ends with abc
[0..15]
=abc
> 100
>=200
is initial
<100
<=200
<12;>50
<>abc
is not initial
is not valid
is valid
[pattern]
starts with abc
unit equals KG

Example
EUR ; USD
exclude JPY

Example
abc
123 , 200.50
TRUE , FALSE
100 USD
100 KG
2011-01-06
2011-01-06T10:10:10
2011-01-06T10:10:10Z
T10:10:10
2011-01-06T10:10:10+10:00

You might also like