on 10-13-2012 9:44 AM
Hi Gurus,
I need to write a report for sales register for CIN could any one please give the flow with tax amounts.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
Check the following note which has been released only recently by SAP
G. Lakshmipathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
CHk for other excise tables. Its not difficult. you will get all the data, if u dont, let me know. I will help you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.