Skip to Content
avatar image
Former Member

no reference data found by using BI IP function distribution by refernce

Hello Experts

i try to distribute plan data with the BI IP planning function " distribute by reference." from a Cube A ( ZVPCSPLA ) by using reference data from the Cube B ( ZVPCRIRP ).

but unfortunately no reference data will be found.

In the fileds to be changes are the two characteristics ZVSPSTR and ZVSPSTRE.

The date should be distributed from ZVSPSTR ( K226 ) on level SPKN ( ZVSPSTRE )

to ZVSPSTR ( 1700 ) on level SPS (ZVSPSTRE).

The data in the Cube A are the following data :

ZVFSKM ZVFSE ZVVTWS ZVVTWSE ZVSPSTR ZVSPSTRE ZVKENNGR 0FISCPER 0TYPE

0FISCPER3 0FISCVARNT0FISCYEAR

Edited by: Masfa500 on Jun 25, 2010 12:16 PM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 25, 2010 at 10:44 AM

    Hi,

    What are the filter conditions based on which you are reading the data from cube for distribution ?

    Pratyush

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Pratyush,

      the filter is set to both ( from and to values ) ZVSPSTRE ( SPKN ; SPS) ZVSPSTR is not in the filter.

      Data will already read from the Cube.

      the settings in "Reference Values to Any Block Characteristics" are :

      ZVVERS = empty ( becuse it is not filled in the refernce cube )

      ZVVTWS = variable ZVPCVTW1 which contains 11001

      ZVKENNGR = 5108

      ZVFSKM = 1001000000

      ZVGESELL = # because it does not exist in the Cubes ( neighter in A or in B )

      0COMP_CODE = 0000

      ZVFSTAT = # because it does not exist in the reference Cube

      0FISCYEAR = variable ZVPCCE02 which contains 2010

      ZVVTWSE = VTWEG

      ZVPVERS = # because it does not exist in the reference Cube

      0FISCPER3 = variable ZVPCPBP which contains the value 12

      0VTYPE =10

      ZVPLEVEL # because it does not exist in the reference Cube

      0FISCVARNT = VM

      ZVVIEW = PCR-FAKTEN

      ZVFSE = 2FUEHR

      0CURRENCY = EUR

      0FISCPER = variable ZVPCFPER which contains 2010012

      0INFOPROV = ZVPCRIRP ( Reference Cube )

      regards Michael

  • avatar image
    Former Member
    Jun 25, 2010 at 12:08 PM

    The data in the Cube A are :

    ZVFSKM = 1001000000

    ZVFSE = 2FUEHR

    ZVVTWS = 11001

    ZVVTWSE = VTWEG

    ZVSPSTR = K226

    ZVSPSTRE = SPKN

    ZVKENNGR = 5103

    0FISCPER = 2010012

    0TYPE = 20

    0FISCPER3 = 12

    0FISCVARNT0 = VM

    FISCYEAR = 2010

    0CURRENCY = EUR

    ZVFSTAT = S

    ZVPLEVEL = PCR_2FUEHR

    ZVPVERS = VORSCHLAG

    ZVVERS = PC1

    ZVVIEW = PCR-FAKTEN

    0COMP-CODE = 0000

    Keyfigure = 91500

    The data in the reference Cube B are :

    ZVFSKM = 1001000000

    ZVFSE = 2FUERH

    ZVVTWS = 11001

    ZVVTWSE = VTWEG

    ZVSPSTR = 1700

    ZVSPSTRE = SPS

    ZVKENNGR = 5108

    0FISCPER = 2010012

    0TYPE = 10

    0FISCPER3 = 12

    0FISCVARNT0 = VM

    FISCYEAR = 2010

    0CURRENCY = EUR

    ZVVERS = empty

    ZVVIEW = PCR-FAKTEN

    0COMP-CODE = 0000

    Keyfigure = 1250

    and a second record on ZVSPSTR 1701 with keyfigure = 2750

    Edited by: Masfa500 on Jun 25, 2010 2:36 PM

    Add comment
    10|10000 characters needed characters exceeded