Technical report documentation

Identification

Name of the report: BW - Historical Overdues for QlikView Loading (Core Query)

Code of the report: QVMS_BW_QRY_CUB_FIAR1_0003

Name of Info-provider (BW): FIAR: Line Item

Code of Info-provider (BW): CUB_FIAR1

Location

Roles -> Competence Centre Role -> Qlikview Queries -> BW Queries for QV RES KA Dashboard

Filters

What object is filtered and what is the filter. Comment to be filled by David

In BO, if 2 queries, please add 2 tables.

Filtered Object

Filter Value

Comment

Status

(0COMP_CODE__C_STAT_SL)

Code

Name

1

SI Entity

Include

GL Acc WC Sub Type

(0GL_ACCOUNT__C_GL_STYP)

Code

Name

PRODUCT NON DOUBT

PRODUCT NON DOUBT

Include

Status Trading P Doc

(0DEBITOR__C_STAT_SL)

Code

Name

1

SI Entity

Exclude

Prompts/Variables

What object have a variable and what kind of selection is possible? Is there a default value

Filtered Object

Prompt Type

Default value

Comment

Sales group (0SALES_GRP)

Manual Input / Default Value

None

Accounting Clerks (C_BUSAB)

Manual Input / Default Value

None

Geography / Zone (0COMP_CODE_C_ZONE)_

Manual Input / Default Value

None

GL Acc WC Sub Type (0GL_ACCOUNT_C_GL_STYP)_

Manual Input / Default Value

None

ERP GBU (0G_CWWE01_C_PFCTR1)_

Manual Input / Default Value

None

Payer country (0G_CWWE11)

Manual Input / Default Value

None

All Key Figures (Currency - 0CURRENCY)

Manual Input / Default Value

None

Used for Currency Conversion of Key Figures

Characteristics

For BW, list the characteristics with Key + Description. For BO, list the objects. Comment will be filled by David. In BO, if 2 queries, please add 2 tables.

Object Key

Object Description

Comment

0GL_ACCOUNT__C_GL_STYP

GL Acc WC Sub Type

0COMP_CODE__C_ZONE

Geography / Zone

0G_CWWE01__C_PFCTR2

ERP Group of activ

0DEBITOR__C_GRCUST

Customer Group

0SALES_GRP

Sales group

0G_CWWE01

Sub-activity

0DEBITOR__0COUNTRY

Cust: Country key

0G_CWWE01__C_PFCTR1

ERP GBU

0G_CWWE01__CPFCTR2_2

FC B.U.

0COMP_CODE

Company code

C_MATNR

Material

0DEBITOR__C_STAT_SL

Status Trading P Doc

Used only as filter, not displayed.

0COMP_CODE__C_STAT_SL

Status

Used only as filter, not displayed.

C_BUSAB

Accounting Clerks

Used only as filter, not displayed.

0G_CWWE11

Payer country

Used only as filter, not displayed.

Key Figures

List the key figures & the calculation (if many similar key figures explain 1 and say how many). Comment will be filled by David.

Key figure name

Calculation

Comment

AR JAN Y-1

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-23

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-23

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

AR FEB Y-1

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-22

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-22

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

AR MAR Y-1

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-21

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-21

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

AR APR Y-1

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-20

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-20

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

AR MAY Y-1

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-19

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-19

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

AR JUN Y-1

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-18

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-18

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

AR JUL Y-1

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-17

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-17

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

AR AUG Y-1

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-16

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-16

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

AR SEP Y-1

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-15

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-15

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

AR OCT Y-1

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-14

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-14

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

AR NOV Y-1

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-13

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-13

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

AR DEC Y-1

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-12

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-12

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

AR JAN Y

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-11

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-11

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

AR FEB Y

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-10

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-10

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

AR MAR Y

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-09

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-09

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

AR APR Y

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-08

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-08

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

AR MAY Y

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-07

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-07

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

AR JUN Y

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-06

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-06

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

AR JUL Y

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-05

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-05

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

AR AUG Y

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-04

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-04

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

AR SEP Y

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-03

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-03

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

AR OCT Y

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-02

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-02

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

AR NOV Y

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-01

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-01

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

AR DEC Y

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

Balance, Previous day (BW_CKF_CUB_FIAR1_0126)

Equals addition of “Balance, Posting Date <= Previous Day, Open Items (BW_RKF_CUB_FIAR1_0149)” and “Balance, Posting Date <= Prev Day, CLearing Date > Prev Day (BW_RKF_CUB_FIAR1_0150)”

Debit/Credit Amount with contribution (BW_CKF_CUB_FIAR1_0024)

Equals “Debit/Credit Amount (0DEB_CRE_LC)” multiply by “C_contrib rep (CONTRIB)” divided by 100.

Debit/Credit Amount (0DEB_CRE_LC)

Basic Key Figure

Balance, Posting Date <= Previous day, Open Items (BW_RKF_CUB_FIAR1_0149)

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Less than and equal to Posting Date (0PSTNG_DATE) variable DATEWC00

3) Item Status (0FI_DOCSTAT) equals “O” for open items.

Balance, Posting Date <= Prev day, Clearing Date > Prev day (BW_RKF_CUB_FIAR1_0150)

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Date (0CLEAR_DATE) variable DATEWC02

3) Less than and equal to Posting Date (0PSTNG_DATE) variable DATEWC00

Overdues JAN Y-1

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-23

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-23

5) Less than and equal to Net Due Month variable C_DUEDOMU_0001-23

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

Overdues FEB Y-1

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-22

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-22

5) Less than and equal to Net Due Month variable C_DUEDOMU_0001-22

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

Overdues MAR Y-1

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-21

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-21

5) Less than and equal to Net Due Month variable C_DUEDOMU_0001-21

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

Overdues APR Y-1

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-20

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-20

5) Less than and equal to Net Due Month variable C_DUEDOMU_0001-20

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

Overdues MAY Y-1

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-19

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-19

5) Less than and equal to Net Due Month variable C_DUEDOMU_0001-19

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

Overdues JUN Y-1

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-18

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-18

5) Less than and equal to Net Due Month variable C_DUEDOMU_0001-18

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

Overdues JUL Y-1

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-17

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-17

5) Less than and equal to Net Due Month variable C_DUEDOMU_0001-17

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

Overdues AUG Y-1

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-16

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-16

5) Less than and equal to Net Due Month variable C_DUEDOMU_0001-16

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

Overdues SEP Y-1

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-15

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-15

5) Less than and equal to Net Due Month variable C_DUEDOMU_0001-15

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

Overdues OCT Y-1

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-14

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-14

5) Less than and equal to Net Due Month variable C_DUEDOMU_0001-14

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

Overdues NOV Y-1

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-13

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-13

5) Less than and equal to Net Due Month variable C_DUEDOMU_0001-13

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

Overdues DEC Y-1

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-12

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-12

5) Less than and equal to Net Due Month variable C_DUEDOMU_0001-12

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

Overdues JAN Y

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-11

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-11

5) Less than and equal to Net Due Month variable C_DUEDOMU_0001-11

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

Overdues FEB Y

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-10

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-10

5) Less than and equal to Net Due Month variable C_DUEDOMU_0001-10

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

Overdues MAR Y

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-09

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-09

5) Less than and equal to Net Due Month variable C_DUEDOMU_0001-09

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

Overdues APR Y

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-08

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-08

5) Less than and equal to Net Due Month variable C_DUEDOMU_0001-08

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

Overdues MAY Y

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-07

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-07

5) Less than and equal to Net Due Month variable C_DUEDOMU_0001-07

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

Overdues JUN Y

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-06

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-06

5) Less than and equal to Net Due Month variable C_DUEDOMU_0001-06

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

Overdues JUL Y

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-05

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-05

5) Less than and equal to Net Due Month variable C_DUEDOMU_0001-05

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

Overdues AUG Y

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-04

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-04

5) Less than and equal to Net Due Month variable C_DUEDOMU_0001-04

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

Overdues SEP Y

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-03

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-03

5) Less than and equal to Net Due Month variable C_DUEDOMU_0001-03

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

Overdues OCT Y

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-02

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-02

5) Less than and equal to Net Due Month variable C_DUEDOMU_0001-02

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

Overdues NOV Y

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001-01

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001-01

5) Less than and equal to Net Due Month variable C_DUEDOMU_0001-01

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

Overdues DEC Y

Restricted to:

1) Calculated Key Figure -> Debit/Credit Amount with Contribution (BW_CKF_CUB_FIAR1_0024)

2) Greater than Clearing Year/Month variable C_CLR_MON_0001

3) Clearing Year/Month (C_CLR_MON) equals “Not Assigned (#)”

4) Less than Posting Year/Month variable C_PST_MON_0001

5) Less than and equal to Net Due Month variable C_DUEDOMU_0001

Calculated Key Figure with Currency Conversion Type CTK_ZRHWC

Overdues Previous Day (BW_CKF_CUB_FIAR1_0127)

Equals addition of “Overdue, Posting Date <= Previous Day, Open Items (BW_RKF_CUB_FIAR1_0151)” and “Overdue, Posting Date <= Prev Day, CLearing Date > Prev Day (BW_RKF_CUB_FIAR1_0152)”

Overdue, Posting Date <= Previous day, Open Items (BW_RKF_CUB_FIAR1_0151)

Restricted to:

1) Balance, Posting Date <= Previous day, Open Items (BW_RKF_CUB_FIAR1_0149)

2) Less than and equal to Net Due Date variable DATEWC03

Overdue, Posting Date <= Prev day, Clearing Date > Prev day (BW_RKF_CUB_FIAR1_0152)

Restricted to:

1) Overdue, Posting Date <= Prev day, Clearing Date > Prev day (BW_RKF_CUB_FIAR1_0150)

2) Less than and equal to Net Due Date variable DATEWC03

Broadcasts

If any broadcast (for BO), please describe it : location of the broadcast, settings, schedules

There are no broadcasts for this BW query.

  • No labels