Dynamic Precision BPC 7.3 Manuel d'utilisateur télécharger pdf (Page 7)

SAP COMMUNITY NETWORK scn.sap.com

© 2012 SAP AG 7

Fields: Consistent with the runtime object

Fld Name

Position

Data

Type

Length

Decimals

Not null

Default

KEY_COND_C01P

1

int

10

X

0

KEY_COND_C01T

2

int

10

X

0

KEY_COND_C01U

3

int

10

X

0

KEY_COND_C011

4

int

10

X

0

KEY_COND_C012

5

int

10

X

0

KEY_COND_C013

6

int

10

X

0

KEY_COND_C014

7

int

10

X

0

KEY_COND_C015

8

int

10

X

0

KEY_COND_C016

9

int

10

X

0

KEY_COND_C017

10

int

10

X

0

KEY_COND_C018

11

int

10

X

0

D_COSTVALS

12

decimal

17

2

X

0

D_DOCITEMS

13

decimal

17

3

X

0

D_DOCUMENT

14

decimal

17

3

X

0

D_GR_WT_KG

15

decimal

17

3

X

0

D_NETVAL_S

16

decimal

17

2

X

0

D_NT_WT_KG

17

decimal

17

3

X

0

D_OORQTYBM

18

decimal

17

3

X

0

D_OORVALSC

19

decimal

17

2

X

0

D_QUANT_B

20

decimal

17

3

X

0

D_VOLUMCDM

21

decimal

17

3

X

0

Indexes: Consistent with DDIC

Unique index /BIC/ECOND_C01~P

KEY_COND_C01T

KEY_COND_C011

KEY_COND_C012

KEY_COND_C013

KEY_COND_C014

KEY_COND_C015

KEY_COND_C016

KEY_COND_C017

KEY_COND_C018

KEY_COND_C01U

KEY_COND_C01P

Index /BIC/ECOND_C01~CS

KEY_COND_C01P

KEY_COND_C01T

KEY_COND_C01U

KEY_COND_C011

KEY_COND_C012

KEY_COND_C013

KEY_COND_C014

KEY_COND_C015

KEY_COND_C016

KEY_COND_C017

KEY_COND_C018

D_COSTVALS

D_DOCITEMS

D_DOCUMENT

D_GR_WT_KG

D_NETVAL_S

Index layout on database without CS-index

A similar cube without column-store index looks like this:

Indexes: Consistent with DDIC

Index /BIC/ECOPY_BPE~020

KEY_COPY_BPET

Index /BIC/ECOPY_BPE~040

KEY_COPY_BPE1

Index /BIC/ECOPY_BPE~050

KEY_COPY_BPE2

Index /BIC/ECOPY_BPE~060

KEY_COPY_BPE3

Index /BIC/ECOPY_BPE~070

KEY_COPY_BPE4

Index /BIC/ECOPY_BPE~080

KEY_COPY_BPE5

Index /BIC/ECOPY_BPE~090

KEY_COPY_BPE6

Index /BIC/ECOPY_BPE~100

KEY_COPY_BPE7

Index /BIC/ECOPY_BPE~110

KEY_COPY_BPE8

Unique index /BIC/ECOPY_BPE~P

KEY_COPY_BPET

KEY_COPY_BPE1

KEY_COPY_BPE2

KEY_COPY_BPE3

KEY_COPY_BPE4

KEY_COPY_BPE5

KEY_COPY_BPE6

KEY_COPY_BPE7

KEY_COPY_BPE8

KEY_COPY_BPEU

SID_0CALMONTH

1 2 3 4 5 6 7 8 9 10 11 12 ... 18 19

Commentaires sur ces manuels

Pas de commentaire