Excise Invoice report with Sales Order Billing number

[former_member471180]

Dear all,

      may i know any standard report display the excise invoice number with the sales order billing number?

Please kindly advise.

thank you

[siva_vasireddy2]

Hi,

you can check the same Data in the Table- J_1IEXCHDR

[former_member211635]

Please check following table and field

j_1iexchdr-rdoc = vbrk-vbeln

Thank You

Nishu

[jpfriends079]

Discussion moved from SAP ERP SD Billing to Internationalization and Unicode

[prasanna_kumar4]

HI

Check the T-code: J1ISAL ( It is Available in ECC 6 EPH6 )

[former_member471180]

i couldnt get this t-code J1ISAL in the system.

thanks

[prasanna_kumar4]

HI

I already clearly mentioned that it is available in ECC6 EPH6

Kindly check below mentioned SAP Note and apply it.

1743574 - Sales register and Purchase register for India

[former_member471180]

Dear Mahesh,

     i tried to follow the sap note that you mentioned but i facing 1 issue, ( please refer screen capture as below)

The IT_FIELDS - Associated Type : "ABAP_KEYDESC..." i couldnt get it in the sap system.

Do you know what is the full naming of this associated type? thank you

[Former Member]

billing No..( VF01 No) and Excise Inv.No.( J1IIN No.) and some other details avaialbe with T.Code..J1IP.

Pl.Check

Rajesh Chauhan

[Lakshmipathi]

I think, J1I7 will display both Delivery and Billing document references for a given excise invoice which I am not sure.  Please check and update here.

G. Lakshmipathi

[phanikumar_v3]

Dear Lakshmipathiji,

In J1i7--i cannot see Cess/SH.Cess amounts-- how can i add---Even in lay out also not available.

Need to  take the help of Abaper only on this or

any other Transaction which can show BED & Cess & SH.Cess Excise group wise---other than J_1iexchdr--need to show to the users.

I can do this With Quick viewer--but any other way out?

Phanikumar

[Lakshmipathi]

If that standard report is not meeting your requirement, then you can copy the same (program J_1IEXCH), rename it and add the coding to suit the Business requirement.

G. Lakshmipathi