how to display depot excise invoice number?

[Former Member]

Hey Buddies,

If I know a depot excise invoice, how could I find delivery number ?

Is J1IJ possible?

Thanks.

Karen

[former_member186385]

Hi,

You have to use two table

J_1IEXCHDR- DOCNO which is Excise invoice and get RDOC which is your Billing document (or reference)

put this in VBRP and VGBEL is the delivery

regards,

santosh

[Former Member]

Hey Sir,

We r looking for the way for user operation. So table is not possible.

and My understanding  , depot excise table is J_1IRG23D..

pls throw a light.

[jpfriends079]

As query is related to CIN, discussion moved from SAP ERP SD Billing to Internationalization and Unicode

[Lakshmipathi]

Try in J1I7

G. Lakshmipathi

[Former Member]

Hey Sir,

I found this report read from table J_1IEXCDTL. It's factory excise table.

[phanikumar_v3]

Go to J1IIN and go to change(F6) and enter the excise number and see the Excise Invoice/year/Excise Grp--- you need to go to Document flow from excise document--you can see the Delivery number Item wise...'''

Phanikumar

[Former Member]

Hey Sir,

I'm checking for depot excise. J1iin is for factory.

[former_member187965]

Hi,

There is no standard process available for this. Generate a query or abap report with table J_1IRG23D. Pass depot excise invoice number in field DEPEXNUM with DEPEXYEAR and pick the required details.