Alpha Numeric Number Ranges issue CIN

[prasanna_kumar4]

Hi all,

Export Invoice will start from 1 E, 2 E, 3 E ...............

& Local Invoice will starts from 1 L, 2 L, 3 L .................

The above is my client Requirement for CIN how to map into SAP , i searched in the forum i couldn't able to find out

please guide me how to map into SAP

Regards,

Prasanna

[Former Member · Accepted solution]

Hi

It is not possible to maintain alpha numeric number ranges.

Any how if you want to differentiate the Local & Export invoices.

then create 2 series groups 1 for domestic and another for Exports and maintain the number ranges J_1IEXCLOC and J_EXCEXP

regards

Prashanth

[prasanna_kumar4 · Accepted solution]

Thanks for Reply Mr.Prashanth,

I maintained 2 series group S3 for Local / Domestic & S4 for Export

My doubt is can i maintained the Number ranges as i mentioned in J_1IEXCLOC and J_EXCEXP (Alpha Numberic) ?

System will determined automatically or we need to enter manually ?

Regards,

prasanna

[Former Member · Accepted solution]

Hi,

System will not determine alphanumeric,if it is entered manually then it will work but again entering manually is not easy to user, so better you check any exit is available for this.

Kapil

[prasanna_kumar4 · Accepted solution]

Thanks for Reply Kapil,

Yes alphanumeric Standard SAP is not provided we have to go ahead for some User-exit

i don't know what is the user exit and program and the code i need to maintain

please guide me any one

Regards,

Prasanna

[Lakshmipathi · Accepted solution]

System will not allow you to maintain alpha numeric number ranges for CIN. So you maintain numeric value there and save. Parallely you have to try with J_1I7_USEREXIT_EXCISE_BEF_SAVE where you have to prefix the required alpha character and hard code this in such a way that as and when the respective (domestic and exports) excise invoice is generated, sytem should populate this alpha character before the number range.

I think, by this way, your requirement can be achieved.

thanks

G. Lakshmipathi

[prasanna_kumar4 · Accepted solution]

Thanks for Reply Lakshmipathi,

User-exit - J_1I7_USEREXIT_EXCISE_BEF_SAVE

Program - ?

Can you guide me what is the Hard Code we need to Write under this User exit because i am new to CIN

Please guide me

Regards,

Prasanna

[former_member188076 · Accepted solution]

Hi

User Exit : J_1I7_USEREXIT_EXCISE_BEF_SAVE is basically a FM. So check that in SE37.

For logic you can discuss with your ABAP and pre-fix the Alpha Code before the numeric no. range before saving.

Regards,

Amitesh Anand

[madhu_vadlamani]

Hi Prasanna,

As gurus told ask your abap people to create an enhancement point in the fm an use concatenate statement and try.Keep a debug point ans see how data is flowing through this.Post if need help.

Regards,

Madhu.

[Lakshmipathi]

In the said exit, you have to hard code the alpha characters E & L and depending upon the series group, the value should be populated to field EXNUM along with the corresponding number range. Explain this logic to your ABAPer and he can write coding accordingly.

thanks

G. Lakshmipathi

[prasanna_kumar4]

Thanks for reply ,

In SE37 FM : J_1I7_USEREXIT_EXCISE_BEF_SAVE

My ABAPer has written a Code like that

DATA DOCNO TYPE J_1IEXCDTL-DOCNO.

data m type c.

if excdtl-TRNTYP = '' and excdtl-DOCYR = sy-datum.

CONCATENATE m DOCNO INTO EXCDTL-DOCNO.

endif.

After that i tested system is not picked , its picking only numeric value

is there any Changes is required to solve my problem , guide me

Regards,

Preasanna

Edited by: prasanna_sap on Sep 6, 2011 8:56 AM