cancel
Showing results for 
Search instead for 
Did you mean: 

Report -need

former_member205059
Participant
0 Kudos

Dear Experts,

Report with the details of sales including material, qty, billing number, excise invoice no, date of invoice, base value, excise duty, cess, vat. is there any standard report like this , pls help me out

Thanks

Basavaraj

Accepted Solutions (1)

Accepted Solutions (1)

reazuddin_md
Active Contributor
0 Kudos

Create SAP Query:SQVI by using Table join option ,

Join the tables: J_1IEXCHDR & J_1IEXCDTL .

former_member205059
Participant
0 Kudos

Hi,

Could you pls brief me how to join these tables ,

Thanks

Basavaraj

Lakshmipathi
Active Contributor
0 Kudos

Go to SQVI and do the following:

1) Give some description in "Quickview"

2) Click "Create" button

3) Give some description in "Title"

4) From the tab "Data Source", select "Table Join" and click blue tick

5) Press "Shift + F1"

6) Give the table you wanted and press enter

7) Again Press "Shift + F1"

😎 Again give the table you wanted and press enter

9) Press F3

10) On your left screen you can see those two tables with header "List fields" and "Selection Field"

11) Whatever data you want to give as input, (say for example based on sales organisation, you want some report), select the white box under selection field

thanks

G. Lakshmipathi

former_member205059
Participant
0 Kudos

HI,

SQV1 Transaction code does not exist .

Basavaraj

former_member205059
Participant
0 Kudos

hi

i will check revert you back sir

thanks

basavaraj

former_member205059
Participant
0 Kudos

sir,

there is Abap run time error, i need to check, selected layoyt mode after that i have pressed " shift+f1" system gives an error

select the write function. could you pls suggest me

Regards

Basavaraj

Lakshmipathi
Active Contributor
0 Kudos

SQVI is a standard transaction and I dont know why you get dump error. Take the help of ABAPer and in debug mode, execute it once again. Probably, ABAPer can help you.

thanks

G. Lakshmipathi

Former Member
0 Kudos

Hi,

The Tcode is SQVI. It is not SQV1. You have mentioned as SQV1. Please check.

Regards,

K Bharathi

Former Member
0 Kudos

Hi,

The transaction code is SQVI. You have mentioned that it is SQV1. Please check.

Regards,

K Bharathi

former_member205059
Participant
0 Kudos

Sorry late reply

Got it sir.

Thanks a lot

former_member205059
Participant
0 Kudos

sir,

Can we transport condition table from development to production server

if yes pls let me know the procedure,if not why

Thanks

Basavaraj

Answers (3)

Answers (3)

Lakshmipathi
Active Contributor
0 Kudos

Have you checked j1i7 ??

thanks

G. Lakshmipathi

former_member1091983
Active Contributor
0 Kudos

Hi,

Check t-code J1ILN...Indirect Taxes -Reports ..

Reg,

JJ

former_member205059
Participant
0 Kudos

Hi

j1iln is used for CIN, in J1i7 you will get the list of excise invoices,

Rgards

Basavaraj

former_member205059
Participant
0 Kudos

Hi

j1iln is used for CIN, in J1i7 you will get the list of excise invoices,

Rgards

Basavaraj

former_member1091983
Active Contributor
0 Kudos

Hi,

You may have to create a SAP query or Z-report by using the table J_1IEXCHDR... for ur requirement.

I think there is no std report.

Reg,

JJ

Former Member
0 Kudos

You can use Tables VBRK & J_1IEXCHDR.

Best Regards,

Ankur

former_member205059
Participant
0 Kudos

Hi

but i am getting only billing documents

Regards

Basavaraj