How to add Pan no of corresponding vendor code Name Field in j1inmis report

[former_member220286]

Dear Gurus ,

Please suggest some ideas to add the Pan no in the report : J1INMIS  : J_1I_EWT_MIS  .

Withholding Tax Information System  : report .

Regards

Deep

[former_member194965]

Hi Deep,

Append required field in WITH_ITEMS structure and write your code through implicit enhancement.

Regards,

E.Ananthachari,

[former_member220286]

Dear Gurus ,

Please suggest some ideas regarding the same .

Regards

Deep

[pranay570708]

I guess you need to enhance table 'With_item' to add new field. Create a custom structure with required fields and append it to WITH_ITEM table.

[former_member220286]

I think to append my structure in the structure : with_item

I need the access key .Or some other work around needed Pranay Patel.

Regards

Deep

[pranay570708]

No, you don't need access key to append a structure.

After appending structure, go to report J_1I_EWT_MIS and do implicit enhancement in FORM 'select_with_item'. write fetch logic for your field and modify 'with_item_tab' internal table which is being used for display.

[former_member220286]

Dear Pranay ,

Look what i did is that I made a Zcopy of this report . ZJ_1I_EWT_MIS

And I have  written the logic in the same form :-

FORM select_with_item USING koart

SELECT SINGLE J_1IPANNO FROM J_1IMOVEND INTO  with_item_tab-PAN WHERE  LIFNR  = WITH_ITEM_TAB-WT_ACCO.

         append with_item_tab.

ENDFORM.

The value is correctly fetched in the variable declared by me as with_item_tab-PAN

but how it will be displayed in the final alv displayed as the Tcode I think FB03 called here after

double click the line item..

Regards

Deep

[pranay570708]

You need to do implicit enhancement in the source code only i.e. J_1I_EWT_MIS report.

1. Go to end of the form 'select_with_item', then from menu bar->Edit->Enhancement operation->Show implicit enhancement.

2. you will see quotes mark at end of the form  SELECT_WITH_ITEM. Now press (Shift+F4) to enhance.

3. it will go to edit mode, Now right click on quotes line->Enhancement operations->create Implemenation-         >Declaration type.

4. Give implementation name (must start with Z or Y) and short text. Press ok.

5. Enter your code to insert PAN no. in  'with_item_tab' internal table.

Try below code:

Loop at with_item_table.

SELECT SINGLE J_1IPANNO FROM J_1IMOVEND INTO  with_item_tab-PANWHERE  LIFNR  = WITH_ITEM_TAB-WT_ACCO.

         modify with_item_tab.

endloop.

[former_member220286]

Hi Pranay Patel,

Data was coming correctly , but how to display this in alv which is finally displayed .

Regards

Deep

[pranay570708]

If FB03 tcode is getting triggered on line selection, then you need to enhance that as well to include PAN number.

Append structure to BSEG table and BSEG_ALV structure.

Do implicit enhancement in include MF05LFB0. Write logic to pass value to BSEG-PAN_NO.

Once the development is completed you can test by changing layout and include pan number.

[former_member220286]

Hi Pranay ,

Where to do the implicit enhancement in include  : include MF05LFB0.

Regards

Deep

[pranay570708]

Go to Implicit enhancement option at the end of the form ‘BELEGZEILE_GET’.

[former_member220286]

This message was moderated.

[former_member220286]

Dear Pranay ,

Can you guide me how to activate the standard table : BSEG if somehow it is party activated .

I have used : SE14

but it is showing max. idle time exceeded and then exit .

Suggest some ideas .

Regards

Deep

[pranay570708]

Hi Deep,

BSEG is a cluster table not a transparent one and the data volume in Bseg is very large. Generally the conversion on table BSEG takes an extremely long time (sometimes several days) or terminates.

https://wiki.scn.sap.com/wiki/display/TechTSG/Table+Conversion+-+Frequently+Asked+Questions

The workaround is to check with your basis team to avoid time out dump.

[former_member220286]

Dear Pranay,

So how to activate my appended structure in the Table : BSEG , WITH_ITEM

and in the structure : BSEG_ALV.

My tables are in active mode but the appended structure is party active which is there in BSEG and  in the structure FAGL_BSEG_EXT they are shown as party active .

How to activate them as my FB03 tcode is using this struture : FAGL_BSEG_EXT

and while I execute to display the document going for dump because  the appended structure is party active.

So please suggest some ideas.

Regards

Deep

[pranay570708]

Have you not activated your appended structure during creation? If you haven't Goto se11, enter you append structure name and activate it.

[former_member220286]

Dear Pranay ,

I have activated my structure but when transported the request from dev to qas

. so there in the quality the structure appears partly active .

I am running the DBACOCKPIT ..

Regards

Deep

[pranay570708]

1. Enter the table name in SE14 and press enter

2. Select Background radio button

3. Click on "Save data" and click "Activate and adjust database" .

This will start a background job that you can monitor in SM37. it is better to schedule large tables adjustment in background.

[former_member220286]

Thanks ,

I did the same .

It worked and everything got activated .

Regards

Deep