Alfa Numeric Batch Number determination at Production confirmation

Hello Experts,

I want to configure batch number logic in SAP, which would also call for automate batch determination at the time of production confirmation in CO11N

Please suggest-

1. What type of number range I can use? (Internal/External)

2. Do I need user exist if barrel code value III & IV changes weekly & daily (as per day)? If Yes, Please share the user exist name.

Please suggest me the right approach & Steps also to configure this logic in SAP. Thanks

Barrel I

Barrel II

Barrel III

Barrel IV

A

14

31

7

Barrel

Number of Characters

Details of Barrel value

Barrel
I

1

Plant Location –

Location 1- “A”

Location 2 - "B"

Location 3 - "C"

Barrel
II

2

Last two digit of Calendar Year e.g. 14 in case year 2014

Range: 2014 to 9999 Years

Barrel
III

2

Week of the calendar Year

Range: 01 to 52 Weeks

Barrel
IV

1

Day of the Week:

1 - Monday

2 - Tuesday

3 - Wednesday

4 - Thursday

5 - Friday

6 - Saturday

7 - Sunday

Range 1 to 7