cancel
Showing results for 
Search instead for 
Did you mean: 

SALES REGISTER FOR CIN

Former Member
0 Kudos

Hi Gurus,

I need to write a report for sales register for CIN could any one please give the flow with tax amounts.

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

CIN cycles are not running smoothly, excise postings are not proper, but better if you tally these tables and your excise registers. Check with your MM-CIN consultant.

Former Member
0 Kudos

Hi,

It is not possible that the entries are not there in these tables. If they are not it means no posting is happening in CIN and you can not develop any registers. You check once more in these table, I believe you must be using any sorting criterion on selection screen.

Former Member
0 Kudos

Hi Nilesh,

I have checked those tables through SE16(Data Browser) it is empty except one table J_1IRGSUM

Former Member
0 Kudos

This means there is some issue. Are you using excise full flange. Form GR to utilization by J2IUN. I am sure, there will be some issue. You can not develope any excise related stuff untill there are sintries in registers and tables. What abt registres, they do show correct upto date entries?

Former Member
0 Kudos

Do you have any guess why those tables are empty?

Former Member
0 Kudos

Need your valuable suggestion

Lakshmipathi
Active Contributor
0 Kudos

Check the following note which has been released only recently by SAP

  • Note 1743574 - Sales register and Purchase register for India

 

G. Lakshmipathi

Former Member
0 Kudos

CHk for other excise tables. Its not difficult. you will get all the data, if u dont, let me know. I will help you.

Former Member
0 Kudos

Hi Nilesh,

Could you please help me on the above issue.I need your suggestion

Former Member
0 Kudos

Hi AK,

Sales register should not be difficult task as half of the data will come from normal sales cycle and half will come form excise for sales data.

Based on material and chapter ID fetch data from  J_1ICOMP  , J_1IRG1RNG  , J_1IRG1, J_2IRG1BAL, J_1IRGSUM. You need to link together excise group, series group and number ranges as a linkages. Also as reference  you need to  take data from SD such as customer number and address and chapter ID. Take material number and description from MARA. take SO, Delivery, Billing doc, Invoice and excise invoice number form these tables and link them together. This is ABAP work, you need ot give him entire cycle examples in test system at the time of coding.

Former Member
0 Kudos

Hi Nilesh,

Thanks for your reply,

as per your suggestion i searched tables J_1ICOMP  , J_1IRG1RNG  , J_1IRG1, J_2IRG1BAL, J_1IRGSUM

both in Development  and quality but these tables are empty.

I have to write a report on sales register please guide on the table flow

Former Member
0 Kudos

ONLY J_1IRGSUM HAS VALUE IN CUM receipts

Former Member
0 Kudos

Hi, for plant, whatever exicable you are selling need to be flown into RG1 register for sales. You need fetch the exicable sales data from various tables starting with J_1----. Sales register usually contains data such as sales order no, tax code, condition values, customer number, tax values, material no and name, quantify. Then accordingly you can fetch various sales data such as SO, Del no, Inv no, Excise invoice number etc.

All the details are available easily in excise tables.Not sure but you can chk J_1IRG1 table.

Former Member
0 Kudos

I checked the table J_1IRG1 but it has no data

Former Member
0 Kudos

Dear Mohan,

you have to get the data from different tables,

from vbrk-billing doc number,date

likp -delivery doc no,date

vbrp-billied quantity,material item -no

from j_1iexchdr, get ex-doc no  and date,BED,ECS,SECS.

regards

RAJ

Former Member
0 Kudos

Hi Raj,

Thanks for your reply.

Could you please give the flow on tables elaborately so that i can develop a sales register for CIN .

Thanks in advance