Question Re: How to implement NOTE 571669. in Technology Q&A

How to implement NOTE 571669.

Former Member — Wed, 03 Jul 2013 04:36:04 GMT

Hello Gurus,

I have a requirement where I need to show values for materials whose (BSTAUS) = V and(BSTTYP) = V .The values are there at PSA level but I saw in the transformation for 2LIS_03_BF that the values for such scenarios are getting deleted , so it is not getting reflected at the cube level . I refered to NOTE 571669 but I didn't understood how to implement the solution.

Can someone guide me about how to implement the solution code wise.

Re: How to implement NOTE 571669.

RamanKorrapati — Wed, 03 Jul 2013 04:55:05 GMT

Hi Nagendra,

Implementing note means you may need install some patches. its not manual kind of work.

Thru note you find advantages and effect if any. inform the same to your supervisors and get approval to implement.

once you got approvals from respective supervisors, take basis team help and implent on sand box or dev system. check the data flow once and values how its loading to target from psa.

if everything looks fine then move to qualitya and do some test case and next moce to prod thru transport request.

If you don't have OSS id to check what OSS Note have, you can t code SNOTE.

further more details, look the below blog which made by mate Suman.

http://scn.sap.com/community/data-warehousing/netweaver-bw/blog/2013/05/19/how-to-download-a-sap-note-without-oss-id

Thanks

Re: How to implement NOTE 571669.

anilkumar_kalkivai — Wed, 03 Jul 2013 04:59:06 GMT

Hi Nagndra,

Go to Tcode: SNOTE

In the Application toolbar click Download button.

Give the note number and download it.

After downloading the note you will find this note under NEW node in the tree.

Double click on the note.

This Note is of type Can not be implemented.

Try To read the Note and follow the instructions accordingly.

Regards,

Anil

Re: How to implement NOTE 571669.

Former Member — Wed, 03 Jul 2013 05:11:57 GMT

Hi Raman,

Thanks for the swift response.

The note 571669 implements the below solution which I can see at the start routine for 2LIS_03_BF .

* INSERT BEGIN

loop at DATA_PACKAGE.

if DATA_PACKAGE-stockcat eq 'V' or

DATA_PACKAGE-stocktype eq 'V'.

delete DATA_PACKAGE.

endif.

endloop.

* if abort is not equal zero, the update process will be canceled

ABORT = 0.

* INSERT END

But what I want is to get the values for materials having stockcat and stocktype =V . The note gives a workaround solution for getting those values . The issue that I am facing is how to implement the workaround solution mentioned in the note which mentions about creating two key figures ZVERWERT and ZVERMENGE and updating those with some code mentioned in the NOTE.

Re: How to implement NOTE 571669.

Former Member — Wed, 03 Jul 2013 05:18:50 GMT

Hi Anil,

I tried donnloading the note but I got the below error,

An error occurred during RFC communication with a remote system. SAPOSS was
used as a destination (maintain destinations in transaction SM59). The message
returned by the RFC interface is:

Error when opening an RFC connection (LB: Hostname or service of the message
server unknown DEST =SA

Re: How to implement NOTE 571669.

anshu_lilhori — Wed, 03 Jul 2013 05:30:52 GMT

Hi,

I have gone through the note.

Few questions :

Is your inventory data flow in 3.x ?
your bw system version and package?
Are you planning to report out of these consumption values?

As this note is very old so you need to check on the same as well.

You have to ignore the start routine part and follow the routines written in communication structure.

Hope it gives some idea.

Regards,

Re: How to implement NOTE 571669.

RamanKorrapati — Wed, 03 Jul 2013 05:43:23 GMT

Hi Nagendra,

As said by AL,

please check the version. for which version that note will applciable. if your system details(version, patches) are the same, then you can go ahead with the same note.

Note saying to use routines, take ABAP exepert help and maintian logic and check the data load once. on dev system.

bit kind of abap related thing, explain the same to abaper and he will help you how to pull data into ZVERWERT and ZVERMENGE .

Thanks

Re: How to implement NOTE 571669.

Former Member — Wed, 03 Jul 2013 06:14:14 GMT

Hi Anshu,

1 . My Inventory data flow is in 7.x flow

2 . Bw Release - 731 , SP- level - 0004 , Support package - SAPKW73104

3 . I have a report for non - moving inventory where I need to capture receipt value having movement 101 . Now the problem that I am facing is that if there is a movement type 101 and stockcat =v and stocktyp =v the particular record is deleted at transformation level because of the code as mentioned below :-

* INSERT BEGIN

loop at DATA_PACKAGE.

if DATA_PACKAGE-stockcat eq 'V' or

DATA_PACKAGE-stocktype eq 'V'.

delete DATA_PACKAGE.

endif.

endloop.

* if abort is not equal zero, the update process will be canceled

ABORT = 0.

* INSERT END

Now the Note 571669 tells a workaround solution for the same . I wanted to know how to implement that solution code-wise as I am not able to understand the solution thoroughly.

Re: How to implement NOTE 571669.

anshu_lilhori — Wed, 03 Jul 2013 09:01:52 GMT

Hi,

Are you sure that you are in 7.x and the below code is working.

NSERT BEGIN

loop at DATA_PACKAGE.

if DATA_PACKAGE-stockcat eq 'V' or

DATA_PACKAGE-stocktype eq 'V'.

delete DATA_PACKAGE.

Reason is in 7.x data_package has been replaced by source_package.

please cross check.

Regards,

Re: How to implement NOTE 571669.

Former Member — Thu, 04 Jul 2013 05:25:51 GMT

Hi,

There was a error in the transformation earlier but that was handled bycopying fields of

_ty_t_SC_1 to _ty_s_SC_1_full which resolved the issue

Now I want to implement the code mentioned in 571669 which is a workaround for including receipt values with stockcat =v and stocktyp =v .

Create two new key figures (cumulative values):

1. Material consumption value (ZVERWERT, for example) with unit

0BASE_UOM

2. Material consumption quantity (ZVERMENGE, for example) with unit

0LOC_CURRCY

3. Include these in the InfoCube definition.

4. Update these key figures from 2LIS_03_BF as follows:

-> material consumption value:

IF ( COMM_STRUCTURE-processkey EQ '100' "Other Issues

OR COMM_STRUCTURE-processkey EQ '101' "Returns / Vendor

OR COMM_STRUCTURE-processkey EQ '104' "Material Transfer

OR COMM_STRUCTURE-processkey EQ '105' "Stock Adjustment InvD

OR COMM_STRUCTURE-processkey EQ '106' "Stock Adjustment Other

OR COMM_STRUCTURE-processkey EQ '110' ) "Issues from Stock

"Transfers

AND COMM_STRUCTURE-bwapplnm EQ 'MM'

* only movements which are relevant for stock control

AND COMM_STRUCTURE-cppvlc <> 0

AND COMM_STRUCTURE-stockcat EQ 'V'

AND COMM_STRUCUTRE-stocktype EQ 'V'.

* result value of the routine

RESULT = -1 * COMM_STRUCTURE-cppvlc.

* if the returncode is zero, the result will be updated

RETURNCODE = 0.

ELSEIF ( COMM_STRUCTURE-processkey EQ '000' "Other Receipts

OR COMM_STRUCTURE-processkey EQ '001' "Goods Receipt/Vendor

OR COMM_STRUCTURE-processkey EQ '004' "Material Transfer/"Receipt

OR COMM_STRUCTURE-processkey EQ '005' "Stock Adjustment InvD

OR COMM_STRUCTURE-processkey EQ '006' "Stock Adjustment Other

OR COMM_STRUCTURE-processkey EQ '010' ) "Receipt from Stock

"Transfer

* only movements which are relevant for stock control

AND COMM_STRUCTURE-cppvlc <> 0

AND COMM_STRUCTURE-stockcat EQ 'V'

AND COMM_STRUCUTRE-stocktype EQ 'V'.

* result value of the routine

RESULT = COMM_STRUCTURE-cppvlc.

* if the returncode is zero, the result will be updated

RETURNCODE = 0.

ELSE.

* if the returncode is not equal zero, the result will not be updated

RETURNCODE = 4.

ENDIF.

* if abort is not equal zero, the update process will be canceled

ABORT = 0..

Re: How to implement NOTE 571669.

anshu_lilhori — Thu, 04 Jul 2013 09:36:59 GMT

Hi,

First of all the code given in that note is for 3.x flows and not for 7.x.

You need to comment the start routine part in case you are planning to capture material consumption value and quantity.

Enhance your cube with the 2 keyfigures as mentioned in that note.

Replace comm_structure with source_fields in case of 7.x.

Map all the fields stated above with your newly created keyfigure and write the field level routine.

Hope this helps.

Regards,

Re: How to implement NOTE 571669.

Former Member — Thu, 11 Jul 2013 11:13:01 GMT

Hi Anshu,

The problem got resloved by writing the field level routine for the two key figures .

Thanks a lot.