cancel
Showing results for 
Search instead for 
Did you mean: 

Withholding Tax

Former Member
0 Kudos

Hi Friends,

Iam working for US withholding Tax reporting 1099. ,

In Classic Withholding Tax initially we configured 2 company codes say {A and B}.  These company codes are not activated in EWT (Extended withholding tax). Now once I activate this company codes (A & B) in EWT  -  are all open items, cleared items, vendor master data will come and show in EWT? or else any customization required.....Please suggest.


I refereed SCN and SAP Notes.



Thanks

Anil


Accepted Solutions (1)

Accepted Solutions (1)

m_madhu
Active Contributor
0 Kudos

HI Mr.Anil,

Migration is required.

refer the below notes.

379186

Regards

Madhu M

Former Member
0 Kudos

Hi Madhu,

Thanks for your message..

I have seen the SAP note which you provided but this note explain for all company codes classic and extended WH tax. we already have few company codes in EWT also. If I implement this note it will effect all company codes data may get disrupt.

Thanks

Anil

m_madhu
Active Contributor
0 Kudos

HI Anil,

Migration is possible with company code wise also.

Please refer the below notes
432692 WTMG USA withholding tax for states.

Steps:

Tcode : WTMG

RUN id

crreate

choose company codes.

and also refer the note no  1551206 point no 4.

Note no 189989 337267 

Regards

Madhu M

Former Member
0 Kudos

Hi Madhu,

Thank you for your inputs

I have seen all your SAP Notes, it is helpful to me - In CWT we are using 2 company codes and in EWT using 4 company codes. All customizing setting  are same WH tax types and WH codes.for CWT and EWT  Before activating CWT, we need to follow WTMG.(432692). then only we can do cross-company posting also,

Let me check and get back to you. Any other comments on the same?

Anil

m_madhu
Active Contributor
0 Kudos

HI Anil,

If you want to post cross company posting then both company codes are should be EWT then only

system will allow post.

Regards

Madhu M

Former Member
0 Kudos

That's right madhu, I agree for doing cross company codes postings with CWT and EWT it should be active in both company codes then only its possible right,

But Once I activated I can able to do cross-company postings in both (CWT & EWT) so my question is once I activated CWT company codes in this case all my vendor invoices, cleared items, parked documents, master data etc. will automatically fetch in EWT can I able see all this? If not its mandatory to run WTMG.


In one of the SCN post, I have seen below solution:


If we activate for company code (CWT) it affects the master data, transaction data and the organization data.  The open Items, parked items get affected because of this activation. Just activate it by clicking the check box mentioned against the company code. It adds all the required tables to be used for Extended Withholding tax. It even provides the required fields for configuring the extended with holding in the vendor master also.

Anil

m_madhu
Active Contributor
0 Kudos

HI Anil,

Please refer the below points.

1. CWT means classic Withholding tax (old Method) SAP suggesting to migrate to EWT

2. EWT means Extended withholding tax (New Method ) SAP suggested to use EWT

3. If one company code  in CWT and another company code in EWT then cross company code posting is not possible. Hence you need to migrate from CWT to EWT.

4. Before migration you need to clear all you parked.

5. For cleared documents migration is not required.

6. Only open documents migration is required.

7. During migration process vendor master will assigned with wt types and codes.

I hope above information will help you.

Regards

Madhu M

Former Member
0 Kudos

Hi Madhu,

Thanks you lot

In your point No 3 you said - If one company code  in CWT and another company code in EWT then cross company code posting is not possible. But I tested in sandbox by activating CWT,  Iam able to do cross company code postings. But Iam not sure whether it affects the master data, transaction data and the organization data.  The open Items, parked items get affected because of this activation.

Anyhow, Let me check once I migrate what would be the results.

Anil

m_madhu
Active Contributor
0 Kudos

HI Anil,

If you have different settings then you will face error  called F5786 while posting intercompany code posting.

Regards

Madhu M

Former Member
0 Kudos

Hi Madhu,

I have same setting for both CWT and EWT and also done with cross company posting by activating CWT company code.


But Iam not sure whether it affects the master data, transaction data and the organization data.  The open Items, parked items will get affected because of this activation? or not..........

Please suggest me whether to go for migration or not.

Anil

m_madhu
Active Contributor
0 Kudos

HI Anil,

withholding tax is involving in those documents ?

means vendor master should have wh type code.

Regards

Madhu M

Former Member
0 Kudos

Yes, WH tax involves in this documents and also have WH tax codes in vendor master.

Anil

m_madhu
Active Contributor
0 Kudos

Hi anil,

Please provide me screen shot for same.

Regards

Madhu M

Former Member
0 Kudos

Hi Madhu,

I prepared in a word document with screen shots its huge document.But WH tax countries and WH tax codes and Types are same for both CWT and EWT

Anil

m_madhu
Active Contributor
0 Kudos

Hi Anil,

Migration is required for your company codes are using classic WT for only open Invoice documents and not for cleared Invoices. Classic WT parked documents will not considered for migration you need to remove them.  Before migration don't activate the Extended WT.

Migration you need to Map the CWT Tax codes to EWT WT type & codes.

Cross company posting only allowed in case fo both EWT only.

please provide me your problemic point.

Regards

Madhu M

Former Member
0 Kudos

Hi Madhu,

I agree your comments, but the company codes which are not activated in EWT treated as CWT company codes right. The issue is once I activated CWT company codes am able to do cross company code postings.... But Iam not sure whether it affects the master data, transaction data a and open Items, parked items will get affected because of this activation? or not.......... If not then I use WTMG.

Please give your inputs on the same

Anil

Former Member
0 Kudos

Hi Madhu

I am working on it, once completed will get back to you

Anil

m_madhu
Active Contributor
0 Kudos

HI Anil,

Plaease avoid the converting cleared items, since this takes a disproporationate amount of time

and therefore effect the system performance and archive the cleared item before you start the converation.

Conver only CWT 1000 vendors open invoices.

Regards

Madhu

Former Member
0 Kudos

HI Madhu,

Before Migration, can we Assign WH Tax Types to CWT company codes or not?

Analysis Completed with errors around 36

Analysis Completed without errors around 136

I am in the process of Conversion steps from classic WHT to Extended WHT.  In the T.code WTMG during analysis stage, system is displaying  Red light -error message. But the Red traffic light is not allowing me to change to next conversion steps. Can anybody share your thoughts on this , how to go about

Kindly suggest...

Anil

m_madhu
Active Contributor
0 Kudos

HI Anil,

Yes, before migration you need to assing CWT code to EWT types.

Error FWTM380 because

due to the fact that the Official WH Tax key for the wtax code in classic wtax is different from the wtax code in extended.

As per system design, we had put some strict checks during the conversion so that no inconsistency should come after the conversion. As part of that we check official wtax keys also must match.

Regards

Madhu M

m_madhu
Active Contributor
0 Kudos

Hi Anil,

Error : FWTM375

Table T059P: base amount for w/tax type 03 in country XX inconsistency

Reason for above is in CWT base amount may be "Net amount " But in EWT base amount not set

"Net amount" may be set differently compare to CWT.

Please make sure both should be same.

Regards

Madhu M

Former Member
0 Kudos

Hi Madhu,

1. "Net Amount" for both is already set CWT and EWT

2. "Off WH Keys" is set same for both CWT and EWT

Now, it is showing only 1 error to solve the issue:

  • One or more of the withholding tax codes that you use in classic withholding tax is reflected in withholding tax type XX after the changeover. For the classic withholding tax code, the net amount was used as the base amount, but for withholding tax type US in country US, a different setting is used.


Anil

m_madhu
Active Contributor
0 Kudos

HI Anil,

Please provide me error code for further investigation.

I feel in CWT tax code is having setting of Formula and EWT is wt type is set as a no formula.

Regards

Madhu M

Former Member
0 Kudos

Madhu.

m_madhu
Active Contributor
0 Kudos

HI Anil,

WT code : XX  IN CWT base amount setting should be same with WT Type XX in EWT base amount  setting

Example : CWT + Code FE + Base amount is Net

                 EWT + Type  FE + Base amount is Net

If both are same then check the accumulation.

Regards

Madhu M

m_madhu
Active Contributor
0 Kudos

HI Anil,

Do you have any EWT WT type "US".

WT type " US" is assigned to any CWT code ?

settings are same ?

Regards

Madhu M

Former Member
0 Kudos

Madhu,

Its success, But in Type/code Assignment I can see 1 error. But for Others no errors.

m_madhu
Active Contributor
0 Kudos

Anil,

Please provide me Error code ? and error long description for further.

along with which WT type and  which WT code ? with thrid value ?

Regards

Madhu M

Former Member
0 Kudos

H Madhu,

Many many thanks for your all inputs and valuable time to reach success....

Finally, completed successfully and able to post cross company codes between CWT and EWT. Now, how to move all this process into production? .

Let me again cross check all my customization, Master data, Transaction postings etc  and will assign full points to you.

Thanks

Anil

m_madhu
Active Contributor
0 Kudos

Hi Anil,

Congrats to you and fainally finish migration. All steps you need to do in Production server.

Please follow the what are the step done still now you need to do it production server.

In Production server you have face problem with Inconsistency documents and those docuemnts

you need to clear inconsistency. Any junk you need to clear before migration and junk will show by

system before migration. Please reach me out for any clearification.

Regards

Madhu M

Former Member
0 Kudos

Hi Madhu,

Thank you

I am just waiting the feedback from business, they will test and get back to me. Once they reach me will close this ticket and will assign full points.

Sorry for the delay.....

Thanks

Anil

Former Member
0 Kudos

Hi Madhu

While doing cross company codes posting we are getting below error?

"Different tax countries are not permitted xxx  xxx"

Anil

m_madhu
Active Contributor
0 Kudos

Hi Anil,

Please provide me error  code ?

Regards

Madhu M

Former Member
0 Kudos
m_madhu
Active Contributor
0 Kudos

HI anil,

double click on bottok Error message then error description will show 5 digit code

please provide me 5 digit code for further investigation.

Regards

Madhu M

Former Member
0 Kudos

Hi Madhu

Note 2180113 and 2096435 will solve our issue, Please confirm on this note to fix an issue.

thanks

Anil

m_madhu
Active Contributor
0 Kudos

HI Anil,

Please proceed and above notes will help you.

Regards

Madhu M

Former Member
0 Kudos

Hi Madhu

user testing in dev. got an issus

Table T059P: Base amounts for w/tax type FE in country US inconsistent

m_madhu
Active Contributor
0 Kudos

Hi anil,

Please provide me erro code ?

Regards

Mahdu M

Former Member
0 Kudos

I checked all the settings for CWT and EWT are showing correct. earlier it was successful but now the error occurs in DEV

In WTMG only 2 errors with red showing in "Analysis" renaming 100 green indicators

Former Member
0 Kudos

HI madhu

any solution?

I Checked all the way to solve this issue, I checked formulas also. I don't know the error cause

Anil

m_madhu
Active Contributor
0 Kudos

HI Anil

Problem is belongs to CWT and EWT base settings

the Error will appear on two conditions.

SPRO > EWT > wt payment type > base amount

not " net amount "

and

SPRO > WT > calculation > Maintain tax codes.> tax code

'withholding tax base amount calculation' check box ' net base for tax contribution'

1 condition

EWT - base - not equal to 'Net amount'  and CWT > base > on  'Net base for tax contribution'

2 condition

EWT - base - not equal to 'Gross amount' and CWT > base > off ' Net base for tax contribution'

please maintain the your settings base on the above.

I hope above information will resolve your issue.

Regards

Madhu M

Former Member
0 Kudos

Hi Madhu

I tried 2 conditions which you sent in previous message. But I am getting same error.

But earlier it was successful in sand box. Now I don't know what might be the reason?

Once it get successful in DEV, then I have to move TR to quality and again I have to test there then move to PRD .

m_madhu
Active Contributor
0 Kudos

Hi Anil,

Please provide me your FE settings of EWT  ?

also CWT ?? mapted to FE ?

Regards

Madhu M

Former Member
0 Kudos

Hi Madhu,

If I apply your 2 condition am getting lot of errors say around 20 in WTMG.

If i put in normal posting it is showing only 2 errors..

m_madhu
Active Contributor
0 Kudos

HI Anil,

Wrong setting you maintained.

EWT - Gross amount

CWT - Net base for tax contribution.

Regards

Madhu M

Former Member
0 Kudos

Madhu

I already made changes from gross to net because am getting lot of errors if I use Gross...EWT and coming to CWT also changed based on your 2 conditions but it is not working. So I changed to normal postion again.

Anil

Former Member
0 Kudos

Hi Madhu

1 error solved remaining 1 more error is left see the screen shot

m_madhu
Active Contributor
0 Kudos

Hi Anil,

i hope Error : FWTM 375  may be solved.

Second error code ? and long text  ? provide for solution.

Regards

Madhu M

Former Member
0 Kudos

Hi Madhu,

I checked in WH types for payment - net and gross amount but not worked. And also checked in Formals no use.

Please guide .....

Anil

m_madhu
Active Contributor
0 Kudos

HI Anil,

Please refer the program name : wtmigration

line no 5488

If wa_to59p-wt_base NE 1 and wa_t059q-xntto EQ GC_on.

text

perform write_message using   ' ' '  E ' 375  To59p.

WA_wtmigration-witht wa-wtmigmatch-land1 ' ' ' ID_run_id

endif.

if wa_t059p-wt_base ne 2 and wa_to59q-xntto eq gc_off.

perform write_message using  ' ' ' ' E 375  t059p.

wa_wtmigmatch-witht wa_wtmigmatch-land1  '''' ' ' ID_run_ID

end_if.

Please put break point in above line and check two condition.

please take your abaper help. Thank you.

REgards

Madhu M

Answers (0)