topic Re: Cost analysis as per position in QlikView

Cost analysis as per position

geam1988 — Fri, 27 Jul 2018 08:16:40 GMT

I am trying to do cost analysis as per position. cost as per sales order is working properly but when i want to see the cost as per position. it shows the same value for every position.

Wish to see the result like this ,

SUM(COSS.WTG007 ) for 500016393 - 010400

SUM(COSP.WTG007 ) for 500016393 - 010300

Sum(KONV.KWERT) for 500016393 - 010500

As per positon getting result like this, Wrong

As per Sales order,

Do not hesitate co contact me if you have any question.

Re: Cost analysis as per position

YoussefBelloum — Fri, 27 Jul 2018 08:18:34 GMT

Hi,

would you be able to share your source table structure and the script you're using ?

Re: Cost analysis as per position

geam1988 — Fri, 27 Jul 2018 09:06:00 GMT

// Auftragsstammdaten

AUFK:
LOAD AUFK.MANDT,
AUFK.AUFNR,
AUFK.OBJNR,
AUFK.KDAUF,
AUFK.KDAUF as VBAK.VBELN,
AUFK.UPDATE_CONTROL

FROM
[..\..\PROD\20_QVD_ROH\SAP\AUFK.QVD]
(qvd);

Left join (AUFK)
Load Distinct
VBAK.VBELN
Resident VBAK;

// CO-Objekt: Summen Kosten - interne Buchungen

COSS:

LOAD *,
COSS.WTG001 + COSS.WTG002 + COSS.WTG003 + COSS.WTG004 + COSS.WTG005 + COSS.WTG006 + COSS.WTG007 + COSS.WTG008 + COSS.WTG009 + COSS.WTG010 + COSS.WTG011 + COSS.WTG012 + COSS.WTG013 + COSS.WTG014 + COSS.WTG015 + COSS.WTG016 as TOTAL.COSS
;

LOAD COSS.MANDT,
COSS.LEDNR,
COSS.OBJNR as AUFK.OBJNR,
COSS.GJAHR,
COSS.WRTTP,
COSS.VERSN,
COSS.KSTAR,
COSS.HRKFT,
COSS.VRGNG,
COSS.PAROB,
COSS.USPOB,
COSS.BEKNZ,
COSS.TWAER,
COSS.PERBL,
COSS.MEINH,

COSS.WTG001,
COSS.WTG002,
COSS.WTG003,
COSS.WTG004,
COSS.WTG005,
COSS.WTG006,
COSS.WTG007,
COSS.WTG008,
COSS.WTG009,
COSS.WTG010,
COSS.WTG011,
COSS.WTG012,
COSS.WTG013,
COSS.WTG014,
COSS.WTG015,
COSS.WTG016,

COSS.BUDGET_PD
FROM
[..\..\PROD\20_QVD_ROH\SAP\COSS.QVD]
(qvd)

where COSS.VRGNG = 'KOAO' OR COSS.VRGNG = 'KZPI' OR COSS.VRGNG = 'RKL'
;

Left join (COSS)
Load Distinct
AUFK.OBJNR
Resident AUFK;

/*
Left join (COSS)
Load Distinct
KEPH.MEK
Resident AUFK;
*/

// CO-Objekt: Summen Kosten - externe Buchungen

COSP:

LOAD *,

COSP.WTG001 + COSP.WTG002 + COSP.WTG003 + COSP.WTG004 + COSP.WTG005 + COSP.WTG006 + COSP.WTG007 + COSP.WTG008 + COSP.WTG009 + COSP.WTG010 + COSP.WTG011 + COSP.WTG012 + COSP.WTG013 + COSP.WTG014 + COSP.WTG015 + COSP.WTG016 as TOTAL.COSP;

LOAD COSP.MANDT,
COSP.LEDNR,
COSP.OBJNR as AUFK.OBJNR,
COSP.GJAHR,
COSP.WRTTP,
COSP.VERSN,
COSP.KSTAR,
COSP.HRKFT,
COSP.VRGNG,
COSP.VBUND,
COSP.PARGB,
COSP.BEKNZ,
COSP.TWAER,
COSP.PERBL,
COSP.MEINH,

COSP.WTG001,
COSP.WTG002,
COSP.WTG003,
COSP.WTG004,
COSP.WTG005,
COSP.WTG006,
COSP.WTG007,
COSP.WTG008,
COSP.WTG009,
COSP.WTG010,
COSP.WTG011,
COSP.WTG012,
COSP.WTG013,
COSP.WTG014,
COSP.WTG015,
COSP.WTG016,
COSP.BUDGET_PD

FROM
[..\..\PROD\20_QVD_ROH\SAP\COSP.QVD]
(qvd)
where COSP.VRGNG = 'COIN'
;

Left join (COSP)
Load Distinct
AUFK.OBJNR
Resident AUFK;

Are you looking for this ?

Re: Cost analysis as per position

YoussefBelloum — Fri, 27 Jul 2018 09:24:25 GMT

it may help yes...

what are the dimensions/expressions used on the table where the result is wrong

and what are those used on the table (Sales order) where the result is good ?

Re: Cost analysis as per position

geam1988 — Fri, 27 Jul 2018 09:40:47 GMT

result is wrong

Dimensions

VBAP.VBELN

VBAP.POSNR

Expressions

SUM(COSS.WTG007)

SUM(COSP.WTG007 )

Sum(KONV.KWERT)

result is good

Dimensions

VBAP.VBELN

Expressions

SUM(COSS.WTG007)

SUM(COSP.WTG007 )

Sum(KONV.KWERT)

i want to show the result as per position .

Re: Cost analysis as per position

geam1988 — Fri, 27 Jul 2018 09:54:46 GMT

FYI..

for the position 10300 and 10400 i do not have internal price

for position 10500 i have internal price and it show the value as per position. getting the value from KONV table.