Report Program

[Former Member]

Hi Abap Gurus,

I am very new to ABAP.This is my first report program.I am giving the details.Please help me in coding it keeping in mind the best possible coding standard.

Select VBELN KUNNR VKORG from LIKP based on selection criteria.

Select MATNR ARKTX VTWEG MATKL from LIPS for all entries selected above.

Select EAN11 (UPC code) from MEAN where HPEAN = u2018Xu2019 and EANTP = u2018UCu2019 or u2018IEu2019 and matnr = LIPS MATNR.(added by Asish dash)

Call FM FRE_ART_SITE_SALES_PRICE_READ with below parameters to get the retail price for the article/site combination.

Ip_matnr = material number(matnr).

Ip_werks = site name(werks).

Ip_date_from = current date.

Select additional text (makt-maktx) for all materials.

Using the function module MERCHANDISE_GROUP_HIER_ART_SEL and the merchandise category, the sub dept (MATKL+0(2)) is determined.

Read table WTADDI for all the additional articles (WTADDI-ADDIMAT) for the material sales organisation and distribution channel combination.

Get the colour and size characteristic for the article/accessories.

Note: To support the cut over/new article number transition process, the legacy article number will be printed on the sku tag. This will be stored in SAP as a UPC code with a category (EANTP) u2013 ZS (for sunglass hut).

For above note select (EAN11) UPS from MEAN table where EANTP = u201CZSu201D for given material. If select is successful replace the material number with this (MEAN-EAN11) UPC code.

If MARC-MMSTA = u2018Mu2019 (markdown) for the material the retrieve retail price on or before that date. Call FRE_ART_SITE_SALES_PRICE_READ for getting the price on or before that date

(Marked down prices are maintained as retail price changes). The condition for retail prices is VKP0. This will be used on the tag as u201CWAS $XXX.XXu201D as shown below and the current retail will be entered as u201CNOW $XXX.XXu201D.

Now we have format the data in the smartform based on the article number or the additional article. Layouts for both the article and additional article are given below. If the article is an additional article we have to print additional articles as accessories. Fetching data for accessories will be same as above.

For every site leading and lagging tags are to be printed each for article and accessories. Samples of both are given in the attachment.

The flow will be like this.

Loop at all the article

Print SKU tags for the material

If article is markdown

Print markdown tag for the article

If material has additional article (entries in WTADDI) for the article.

Print tags accessories tag for all the additional articles

If additional article is markdown

Print markdown accessories tags for additional article .

End.

Edited by: Vijay Babu Dudla on Jan 30, 2009 3:56 AM

[Former Member]

Hi Devashis

Try to do by urself, you must be not aware of Rules of engagement with SDN.

So read those first and then post.

you you face any difficulty then you can post and i am sure you will get the reply.

REPORTED TO MODERATOR

[Former Member]

Hi Devashis,

I understand that you are new to abap, but posting the whole requirement is against

rules of SCN. Just try to do yourself, then when you face problem try search in SCN.

Even then if you don't get the answer ask in SCN for any logic, but not for whole code.

Regards,

Manoj Kumar P

[Former Member]

Hi

There is lot of help available on the syntax of these statements and you can obtain codes by searching for DEMO* in ABAP.

Try this link for [keywords|http://help.sap.com/abapdocu/en/ABENABAP_STATEMENTS_OVERVIEW.htm].

Hope this helps

Regards,

Jayanthi.K