Access Sequence

[niravbhatt]

Dear All,

In GST, Tax Rate will be determined based on Condition Type, Region, Vendor GST Class, Material Tax Indicator and HSN Code which we defined in FV11.

So whenever new material code created which has HSN Code which is not maintain in system then required to define access sequence in Fv11.

It is very complex activity and chances of human error is very high.

Request you all to Pl. suggest what will be best possible way to setup the access sequence to minimize complexity.

Thanks and Regards,

Nirav

[JL23]

"Oh government, why did you make our new tax system so complicated that it requires that many entries in a SAP Access sequence"

"Dear tax payer, it is the variety of your business which determines how detailed you need to search for an appropriate tax rate."

SAP uses access sequence and conditions all over in a ERP system, from pricing, over taxes to material determination, to output determination etc etc.

It is usually your business requirements that drive the number of condition records.

Let us make an example with purchase order printing:

If you only use the document type NB and you only have 1 printer then 1 condition record will be sufficient

If you want differentiate between normal purchase order and rush orders and you create a ZNB document type then you need already 2 condition records.

If you 4 buyers and each of your buyer wants to print at the printer in his office, and all your buyers do normal and rush orders then you already 8 condition records

Now you expand your business with a subsidiary in another town far away, which also has 4 buyers with the same requirements then you are already at 16 condition records.

And since you want do stock transfers between those 2 plants you also have to use a further document type UB, and you end up in 32 condition records.

I hope you understand now how it can become quickly complicated and maintenance intensive.

Review the process and think where it could be simplified, in mathematics we would say: find the least common denominator

All buyers want print at the local printer, no matter what document type.

Remove the document type from the access sequence. Actually you would not do it this way. You would create a new access sequence without document type, as you have not a single case where the document type is used to differentiate the printer. Instead you could just use the purchasing group to determine the printer. And this way you had reduced the number of conditions from 32 to 8

And exact the same is what you have to do with your taxes.

If 600 condition records finally just find the same tax code then it does not really make sense to maintain the determination on such a detailed level (based on Condition Type, Region, Vendor GST Class, Material Tax Indicator and HSN Code) .

So it is a combination of the complexity of the tax law with the complexity of your business and the ability of the consultant to find the lest common denominator to make it as easy as possible.

And since you can have many different accesses you can pretty well control what cases can be combined and where all details are needed.

If we go back to the above example with the printing, and would say that the buyers in plant A would be fine the final approach but the buyers in plant B what print all UBs at printer 123, then you still do not need your 32 condition records.

you would just need the 8 without document type, + 4 further for the old access with the document type UB for the buyers in plant B, which means you end with 12.

[niravbhatt]

Thanks for your reply.

In GST, intra-state level two types of GST shall be levied CGST (Central Goods and Services Tax) and SGST (State Goods and Services Tax).

I will be thank full if provide your feedback for below solution :

>> Can we use vendor master's one field which we are not using or we can create one additional field. In which we update the field for intra-state or inter-state. And this new field we will use it in place of Region in access sequence. So instead of maintaining data for say 20 states we need to maintain it for 2 scenario i.e. inter-state or intra-state.

Thanks and Regards,

Nirav

[JL23]

I don't know your business, this question has be answered by you and your business folks. I tried to explain you how access sequences work in general. If you only sell one product and you always have the same tax then you may be able to set it up for your personal needs with just 2 conditions.