Skip to Content
0
Former Member
Jan 14, 2012 at 12:05 PM

Re: table joining for k810009

49 Views

Hi Experts,

I am developing a new report by taking output field from table k810009 and some selection screen field from mara.

Below is my code

TABLES : MARA,K810009.

TYPES: BEGIN OF TY_FINAL,

ARTNR TYPE K810009-ARTNR, " MATERIAL NUMBER

PAPH1 TYPE K810009-PAPH1, " PRODUCT HIERARCHY LEVEL 1

PAPH2 TYPE K810009-PAPH2, " PRODUCT HIERARCHY LEVEL 2

PAPH3 TYPE K810009-PAPH3, " PRODUCT HIERARCHY LEVEL 3

PAPH4 TYPE K810009-PAPH4, " PRODUCT HIERARCHY LEVEL 4

PAPH5 TYPE K810009-PAPH5, " PRODUCT HIERARCHY LEVEL 5

PAPH6 TYPE K810009-PAPH6, " PRODUCT HIERARCHY LEVEL 6

WWREP TYPE K810009-WWREP, " REPRESENTATIVE MATERIAL FOR PCA

BUKRS TYPE K810009-BUKRS, " COMPANY CODE

PRCTR TYPE K810009-PRCTR, "PROFIT CENTER

VKORG TYPE K810009-VKORG, " SALES ORGANISATION

WERKS TYPE K810009-WERKS, "PLANT

MAKTX TYPE MAKT-MAKTX, " MATERIAL DESCRIPTION

END OF TY_FINAL.

SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-001.

SELECT-OPTIONS: S_MTART FOR MARA-MTART. "MATERIAL TYPE

S_MATKL FOR MARA_MATKL. " MATERIAL GROUP

S_ARTWR FOR K810009-ARTWR. "MATERIAL NUMBER

S_WERKS FOR K810009-WERKS. "PLANT

S_BUKRS FOR K810009-BUKRS. "COMPANY CODE

S_VKORG FOR K810009-VKORG. "SALES ORGNISATION.

SELECTION-SCREEN END OF BLOCK B1.

can any one throw some light how to dispaly output filed based on my selection screen.

Regards,

Am

Moderator Message: Just do not post your requirement. First try out on your own & get back to the forums in case of any specific problem.

Edited by: Suhas Saha on Jan 15, 2012 2:49 PM