Solved: how to break up the tax

former_member325312 · ‎2009 Sep 05

hello sap experts how can we break up the taxes in pld like vat ,service taxl ike so on

Former Member · ‎2009 Sep 05

Hi Anderson ,

If you need to print of Tax Breakup in Document Print.

Try to Create Tax BreakUp in Repetetive Area.

for example: Sales Order

->> Open the Sales Order System PLD and Save as the NEW PLD then Open the NEW PLD.

->> Select the Repetetive Area on Field Index Window.

->> Click the Print Layout Designer on menu bar.

->> Select Repetetive Area. -> Add.

->> Create Tax BreakUp in (NEW)Repetetive Area1 and Create Sales Tax Authorities Name, Tax Code,

Tax Rate and Tax Amount.

->> Create 4 Database Fields and Select One by One Fields.

Select 1database field then Click Alt+Select the Table in Content Tab on Properties Window.

Sales Tax Authorities Name


Table -> OSTA - Sales Tax Authorities Name.
Column -> Name.

Tax Code


Table -> RDR4 - Sales Order - Tax Amount per Document.
Column -> StcCode - Tax Code.

TaxRate


Table -> RDR4 - Sales Order - Tax Amount per Document.
Column -> TaxRate - TaxRate.

Tax Amount


Table -> RDR4 - Sales Order - Tax Amount per Document.
Column -> Tax Amount - Tax Amount.

AND Hide the Repetetive Area then assign the GROUP BY (Select Group by 1) method in Repetetive Area Footer and

Create formula fields in Repetetive Area Footer and Copy Paste the Tax field id's .

Assign the Sort by Sales Tax Authorities Name.

Save it and run the print preview.

Regards,

Madhan.

Edited by: Madhan Babu C on Sep 5, 2009 8:42 AM

how to break up the tax