Know the release strategy for a particular pruchasing group

[sushanta_dash]

Hi All,

I have a requirement in which I have to know the release startegy which is assigned to a particular purchasing group.

Here purchasing group is one of the release charcterestics of each startegy. And different strategies have different purchasing groups assignment.

Please let me know if the question is not clear.

Awiting your reply.

Thanks in advance.

Sushanta

[sushanta_dash]

Yes it can be only achievable throgh a "Z" report.

Thanks all who have guided to reach this answer.

[Former Member]

can we use CL24N tcode

so that we get the release strategy and the corresponding values affetcing the realse sategy like plant, pur grp, doc type etc

[former_member1346789]

Hi Sushanta,

I have done the program for same req. on last summer. The Main logic

take rel strg. from T16fs table -- > combine rel strg. & group then pass to KSSK table

, based on internal class number select Internal characteristic value from KSML,

go to CABN and pick up the characteristic value

-

---

Sample code:

-

---

SELECT frggr frgsx frgc1 INTO TABLE itb_t16fs FROM t16fs

WHERE frgsx IN s_frgsx

AND frgc1 IN s_frgc1.

IF NOT itb_t16fs[] IS INITIAL.

SELECT frggr frgsx frgxt INTO TABLE itb_t16ft FROM t16ft

FOR ALL ENTRIES IN itb_t16fs

WHERE spras = sy-langu

AND frggr = itb_t16fs-frggr

AND frgsx = itb_t16fs-frgsx.

ENDIF.

SORT itb_t16ft BY frggr frgsx.

LOOP AT itb_t16fs.

CONCATENATE itb_t16fs-frggr itb_t16fs-frgsx INTO itb_t16fs-obtab.

MODIFY itb_t16fs.

CLEAR itb_t16fs.

ENDLOOP.

SELECT SINGLE klart INTO w_klart FROM tcla

WHERE obtab = k_tab.

IF NOT itb_t16fs[] IS INITIAL.

SORT itb_t16fs BY obtab.

SELECT objek klart clint INTO TABLE itb_kssk FROM kssk

FOR ALL ENTRIES IN itb_t16fs

WHERE objek = itb_t16fs-obtab

AND mafid = k_o

AND klart = w_klart.

ENDIF.

IF NOT itb_kssk[] IS INITIAL.

SORT itb_kssk BY clint.

SELECT imerk INTO TABLE itb_ksml FROM ksml

FOR ALL ENTRIES IN itb_kssk

WHERE clint = itb_kssk-clint.

ENDIF.

IF NOT itb_ksml[] IS INITIAL.

SORT itb_ksml BY imerk.

SELECT atinn INTO TABLE itb_cabn FROM cabn

FOR ALL ENTRIES IN itb_ksml

WHERE atinn = itb_ksml-imerk

AND atfel = k_fie.

ENDIF.

SORT itb_cabn BY atinn.

IF NOT itb_kssk[] IS INITIAL.

SELECT objek klart atinn atwrt INTO TABLE itb_ausp FROM ausp

FOR ALL ENTRIES IN itb_kssk

WHERE objek = itb_kssk-objek

AND mafid = k_o

AND klart = itb_kssk-klart

AND atwrt IN s_ekgrp.

ENDIF.

IF NOT itb_ausp[] IS INITIAL.

SELECT ekgrp eknam ektel telfx INTO TABLE itb_t024

FROM t024

FOR ALL ENTRIES IN itb_ausp

WHERE ekgrp = itb_ausp-atwrt.

ENDIF.

SORT itb_t024 BY ekgrp.

[Former Member]

Hi, We had some time ago a similar requirement in an implementation where the characteristics for release strategy were:

- Document Type

- Purchasing Group

- Value $ Range

We have implemented a Z-report that read all characteristics values per release strategy and then combine them in every possible way and then show the result in ALV report. If you would like to know which releases strategies were assigned to a pr. group you had to execute the report without filters and then in ALV filter by desired purchasing group.

That worked very well, so I recommend you to do that.

regards, SL

[Former Member]

Hello Sebastien,are there any standard report to get the same data or shall we get this data by fetching any table.

[Former Member]

Go for the z-report....

I don't have access right now to the code,

later i will post some parts that might be useful.

regards, SL

-

---

I have just seen the above post with sample code. This seems to be ok. Our idea was the same.

Edited by: Sebastian Ligueros on Dec 14, 2009 10:54 AM