Please explain the Functinality given ASAP

[Former Member]

General Description

Teac Electronics (M) Sdn Bhd currently is requesting for a new customized report which list down by finished products, sales quantity, sales amount, material cost and scrap plus variable and fixed expense.

The customized report should only include the finished product of category ZTFG and generated by center selection and the source of each cell is extracted as indicated and as per existing reports ZCOAVT01 (program), ZSL2/ZSL3 (transaction code), FBL3 (transaction code) and J1SIPAAX (program).

ZCOAVT01 is a product costing report, which includes both sub-assemblies (ZTSA) and finished goods (ZTFG).

Description

A new customized report, which list down by finished products, sales quantity, sales amount, material cost and scrap plus variable and fixed expense.

The customized report should only include the material type (finished product of category) ZTFG and generated by center selection and the source of each cell is extracted as indicated and as per existing reports ZCOAVT01 (program ZCOAVT01), ZSL2 (program JZSL2AAX) / ZSL3 (program JZSL3AAX), FBL3 (program RFEPOS00) and J1SIPAAX (program J1SIPAAX).

ZCOAVT01 is a product costing report, which includes both sub-assemblies (ZTSA) and finished goods (ZTFG).

Screen Layout

Selection Parameter layout:

Selection Parameter

Below are the user selection parameters:

No. Description Technical Name Format Opt/Mand?

1 Company code BUKRS 4 CHARS Mandatory

2 Controlling Area KOKRS 4 CHARS Mandatory

3 Plant WERKS 4 CHARS Mandatory

4 Division SPART 2 CHARS Optional

5 Product Group KSTRG 12 CHARS Optional

6 Material Number MATNR 18 CHARS Optional

7 Plan Version VERSN 3 CHARS Optional

8 Fiscal Year GJAHR 4 CHARS Mandatory

9 First Half N/A OPTION BUTTON

10 Second Half N/A OPTION BUTTON

11 Cost Center group KSGRU 4 CHARS Optional

12 Or Values KOSTL 4 CHARS Optional

13 Cost Element Group KAGRU USER DEFINE Optional

14 Or Values KSTAR 4 CHARS Optional

15 Controlling Area Currency N/A OPTION BUTTON

16 Company Code Currency N/A OPTION BUTTON

Remarks: Selection screen is a combination of Report ZCOAVT01 and ZSL2/ZSL3

Expected Output and Mapping of User selection entry to SAP Tables

1. Expected Output

2. Below is the mapping logic of the selection criteria to SAP tables.

(R)ow Cost elements

Formula Refer program

1 till 7 retrieve from report ZCOAVT01 and FBL3

Your program should only pick up figures from those material which belong to type ZTFG only (Table name = RMMG1, Field name = MTART), refer to appendix A1 and A2

ODD Media Budget Expenses

1 Actual Sales Quantity refer to appendix A1 ZCOAVT01

2

Sales Amount

refer to appendix A1 and A2 ZCOAVT01

(Plan sales amount)

FBL3

(Actual sales amount)

3 Material used refer to appendix A1 ZCOAVT01

4 Scrap refer to appendix A1 ZCOAVT01

5 Balanced Sales amount (R5) – material used (R6) – scrap(R7)

6 Recovery Amount Balance (R8) – Valuable Expenses (R17)

7 Recovery Ratio Recovery Amount (R9) / Fixed Expenses (R24) * 100

8 till R25 retrieve from report ZSL2 and ZSL3, refer to Appendix B

8

DIRECT LABOUR

Sum of cost element :

5013101

5013111

5013131

5013133

5013136

5013141

5013152

5013153

JZSL2AAX

J1SIPAAX

9

WELFARE

Sum of cost element :

5013302

5013311

5013312

5013313

5013321

5013341

5013361

JZSL2AAX

J1SIPAAX

10

SUNDRY TOOLS, L;INE SUPPLIES

Sum of cost element :

5015202

5015211

5015231

5015241

JZSL2AAX

J1SIPAAX

11

MAINTENANCE

Sum of cost element :

5015411

JZSL2AAX

J1SIPAAX

12

OTHER EXPENSES

Sum of cost element :

5015601

5015631

5015691

JZSL2AAX

J1SIPAAX

13 VARIABLE EXPENSES

Sum(R12~ R16)

14

INDIRECT LABOUR

Sum of cost element :

5013201

5013211

5013231

5013233

5013241

5013252

5013253

JZSL2AAX

J1SIPAAX

15

WELFARE

Sum of cost element :

5013301

5013332

5013342

5013351

5013361

JZSL2AAX

J1SIPAAX

16

DEPRECIATION

Sum of cost element :

5014300

5014600

5014700

5014800

JZSL2AAX

J1SIPAAX

17

UTILITIES

Sum of cost element :

5015301

5015311

JZSL2AAX

J1SIPAAX

18

ALLOCATION SUPPORT SEC

Sum of cost element :

9100001

9100002

9100003

JZSL2AAX

J1SIPAAX

19 FIXED EXPENSES R19R20R21R22R23

20 TOTAL EXPENSES R17+R24

21 P & L R9 – R24

22 Scrap ratio R7/(R6 + R7)

From the “Expected Output” file, to derive the amounts for column Q and R:-

Cell Formula

Q5 Sum of actual sales amount. Sum(C5, E5, G5, I5, K5, M5)

Q6 Sum of actual material used

Q7 Sum of actual scrap figure

Q12 Average of Sum of actual direct labour cost

Q13 Average of Sum of actual welfare

Q14 Average of Sum of actual SUNDRY TOOLS, L;INE SUPPLIES

Q15 Average of Sum of actual Maintenance

Q16 Average of Sum of actual other expenses

Q17 Average of Sum of actual variable expenses

Q19 Average of Sum of actual Indirect labour

Q20 Average of Sum of actual Welfare

Q21 Average of Sum of actual Depreciation

Q22 Average of Sum of actual Utilities

Q23 Average of Sum of actual Allocation support sec

Q24 Average of Sum of actual fixed expenses

Q25 Sum of variable expenses (Q17) + fixed expenses (Q24)

R12 (Q12/Q25) * 100

R13 (Q13/Q25) * 100

R14 (Q14/Q25) * 100

R15 (Q15/Q25) * 100

R16 (Q16/Q25) * 100

R19 (Q19/Q25) * 100

R20 (Q20/Q25) * 100

R21 (Q21/Q25) * 100

R22 (Q22/Q25) * 100

R23 (Q23/Q25) * 100

R25 “100%”

Appendix A1

Path: Accounting>Controlling>Cost oRject controlling>Product cost Ry period>Information System>Report selection

Application tree report selection product cost Ry period>Product cost Ry period>COPC customized reports>customized reports>Product costing: Actual Vs Target Cost(ZCOAVT01)

Sample variant: Z3140

Appendix A2

For Actual Sales amount, the values will be obtained from the following GL accounts:-

4011100 SALES-THIRD PARTIES-FINISHED GOODS

4011101 SALES-THIRD PARTIES-BENQ-FINISHED GOODS

4012100 SALES-TEAC CORPORATION-FINISHED GOODS

4015100 SALES-TEAC INDONESIA-FINISHED GOODS

4016100 SALES-TEAC AMERICA INC-FINISHED GOODS

4017100 SALES-TEAC RELATED GROUP-FINISHED GOODS

4150120 INTRACOMPANY SALES (IPC-FG&SA)

1) Go to tcode FBL3, select the above mentioned GL accounts to get the following listing. Thereafter, drill down further to get the material number:-

Appendix B

WORKING TO SPLIT THE VARIABLE AND FIXED EXPENSES FOR MATERIAL ZTFG

1) Go to the following patch

Path: Information system>general report selection

Application tree report selection general>report selection>controlling>customized reports>cost center reports

2) From the above ZSL2 / ZSL 3 report, in order to get the mapping of the allocation to material, go to Cost Center Report (program J1SIPAAX).

EXAMPLE :-

The following is the sample file extracted from Cost Center Actual Line Item Report for period 1 fiscal year 2007:-

From the above sample file, material 4900154401 (ZTFG) received 16.80 (0.2%) out of total 8,526.56. Hence, the following sender cost elements will be split as below:-

5014700 => 296.87 x 0.2% = 0.59

5014800 => 157.49 x 0.2% = 0.32

5015202 => 314.29 x 0.2% = 0.63

and so on

According to the mapping logic in page 6, since 5014700 and 5014800 is categorised as Depreciation = Fixed Expenses, the sum received will be 0.91 (0.59 + 0.32). Whereas, for 5015202, it will be categorised as Sundry Tools = Variable Expenses in the new customised report.

[Former Member]

General Description

Teac Electronics (M) Sdn Bhd currently is requesting for a new customized report which list down by finished products, sales quantity, sales amount, material cost and scrap plus variable and fixed expense.

The customized report should only include the finished product of category ZTFG and generated by center selection and the source of each cell is extracted as indicated and as per existing reports ZCOAVT01 (program), ZSL2/ZSL3 (transaction code), FBL3 (transaction code) and J1SIPAAX (program).

ZCOAVT01 is a product costing report, which includes both sub-assemblies (ZTSA) and finished goods (ZTFG).

Description

A new customized report, which list down by finished products, sales quantity, sales amount, material cost and scrap plus variable and fixed expense.

The customized report should only include the material type (finished product of category) ZTFG and generated by center selection and the source of each cell is extracted as indicated and as per existing reports ZCOAVT01 (program ZCOAVT01), ZSL2 (program JZSL2AAX) / ZSL3 (program JZSL3AAX), FBL3 (program RFEPOS00) and J1SIPAAX (program J1SIPAAX).

ZCOAVT01 is a product costing report, which includes both sub-assemblies (ZTSA) and finished goods (ZTFG).

Screen Layout

Selection Parameter layout:

Selection Parameter

Below are the user selection parameters:

No. Description Technical Name Format Opt/Mand?

1 Company code BUKRS 4 CHARS Mandatory

2 Controlling Area KOKRS 4 CHARS Mandatory

3 Plant WERKS 4 CHARS Mandatory

4 Division SPART 2 CHARS Optional

5 Product Group KSTRG 12 CHARS Optional

6 Material Number MATNR 18 CHARS Optional

7 Plan Version VERSN 3 CHARS Optional

8 Fiscal Year GJAHR 4 CHARS Mandatory

9 First Half N/A OPTION BUTTON

10 Second Half N/A OPTION BUTTON

11 Cost Center group KSGRU 4 CHARS Optional

12 Or Values KOSTL 4 CHARS Optional

13 Cost Element Group KAGRU USER DEFINE Optional

14 Or Values KSTAR 4 CHARS Optional

15 Controlling Area Currency N/A OPTION BUTTON

16 Company Code Currency N/A OPTION BUTTON

Remarks: Selection screen is a combination of Report ZCOAVT01 and ZSL2/ZSL3

Expected Output and Mapping of User selection entry to SAP Tables

1. Expected Output

2. Below is the mapping logic of the selection criteria to SAP tables.

(R)ow Cost elements

Formula Refer program

1 till 7 retrieve from report ZCOAVT01 and FBL3

Your program should only pick up figures from those material which belong to type ZTFG only (Table name = RMMG1, Field name = MTART), refer to appendix A1 and A2

ODD Media Budget Expenses

1 Actual Sales Quantity refer to appendix A1 ZCOAVT01

2

Sales Amount

refer to appendix A1 and A2 ZCOAVT01

(Plan sales amount)

FBL3

(Actual sales amount)

3 Material used refer to appendix A1 ZCOAVT01

4 Scrap refer to appendix A1 ZCOAVT01

5 Balanced Sales amount (R5) – material used (R6) – scrap(R7)

6 Recovery Amount Balance (R8) – Valuable Expenses (R17)

7 Recovery Ratio Recovery Amount (R9) / Fixed Expenses (R24) * 100

8 till R25 retrieve from report ZSL2 and ZSL3, refer to Appendix B

8

DIRECT LABOUR

Sum of cost element :

5013101

5013111

5013131

5013133

5013136

5013141

5013152

5013153

JZSL2AAX

J1SIPAAX

9

WELFARE

Sum of cost element :

5013302

5013311

5013312

5013313

5013321

5013341

5013361

JZSL2AAX

J1SIPAAX

10

SUNDRY TOOLS, L;INE SUPPLIES

Sum of cost element :

5015202

5015211

5015231

5015241

JZSL2AAX

J1SIPAAX

11

MAINTENANCE

Sum of cost element :

5015411

JZSL2AAX

J1SIPAAX

12

OTHER EXPENSES

Sum of cost element :

5015601

5015631

5015691

JZSL2AAX

J1SIPAAX

13 VARIABLE EXPENSES

Sum(R12~ R16)

14

INDIRECT LABOUR

Sum of cost element :

5013201

5013211

5013231

5013233

5013241

5013252

5013253

JZSL2AAX

J1SIPAAX

15

WELFARE

Sum of cost element :

5013301

5013332

5013342

5013351

5013361

JZSL2AAX

J1SIPAAX

16

DEPRECIATION

Sum of cost element :

5014300

5014600

5014700

5014800

JZSL2AAX

J1SIPAAX

17

UTILITIES

Sum of cost element :

5015301

5015311

JZSL2AAX

J1SIPAAX

18

ALLOCATION SUPPORT SEC

Sum of cost element :

9100001

9100002

9100003

JZSL2AAX

J1SIPAAX

19 FIXED EXPENSES R19R20R21R22R23

20 TOTAL EXPENSES R17+R24

21 P & L R9 – R24

22 Scrap ratio R7/(R6 + R7)

From the “Expected Output” file, to derive the amounts for column Q and R:-

Cell Formula

Q5 Sum of actual sales amount. Sum(C5, E5, G5, I5, K5, M5)

Q6 Sum of actual material used

Q7 Sum of actual scrap figure

Q12 Average of Sum of actual direct labour cost

Q13 Average of Sum of actual welfare

Q14 Average of Sum of actual SUNDRY TOOLS, L;INE SUPPLIES

Q15 Average of Sum of actual Maintenance

Q16 Average of Sum of actual other expenses

Q17 Average of Sum of actual variable expenses

Q19 Average of Sum of actual Indirect labour

Q20 Average of Sum of actual Welfare

Q21 Average of Sum of actual Depreciation

Q22 Average of Sum of actual Utilities

Q23 Average of Sum of actual Allocation support sec

Q24 Average of Sum of actual fixed expenses

Q25 Sum of variable expenses (Q17) + fixed expenses (Q24)

R12 (Q12/Q25) * 100

R13 (Q13/Q25) * 100

R14 (Q14/Q25) * 100

R15 (Q15/Q25) * 100

R16 (Q16/Q25) * 100

R19 (Q19/Q25) * 100

R20 (Q20/Q25) * 100

R21 (Q21/Q25) * 100

R22 (Q22/Q25) * 100

R23 (Q23/Q25) * 100

R25 “100%”

Appendix A1

Path: Accounting>Controlling>Cost oRject controlling>Product cost Ry period>Information System>Report selection

Application tree report selection product cost Ry period>Product cost Ry period>COPC customized reports>customized reports>Product costing: Actual Vs Target Cost(ZCOAVT01)

Sample variant: Z3140

Appendix A2

For Actual Sales amount, the values will be obtained from the following GL accounts:-

4011100 SALES-THIRD PARTIES-FINISHED GOODS

4011101 SALES-THIRD PARTIES-BENQ-FINISHED GOODS

4012100 SALES-TEAC CORPORATION-FINISHED GOODS

4015100 SALES-TEAC INDONESIA-FINISHED GOODS

4016100 SALES-TEAC AMERICA INC-FINISHED GOODS

4017100 SALES-TEAC RELATED GROUP-FINISHED GOODS

4150120 INTRACOMPANY SALES (IPC-FG&SA)

1) Go to tcode FBL3, select the above mentioned GL accounts to get the following listing. Thereafter, drill down further to get the material number:-

Appendix B

WORKING TO SPLIT THE VARIABLE AND FIXED EXPENSES FOR MATERIAL ZTFG

1) Go to the following patch

Path: Information system>general report selection

Application tree report selection general>report selection>controlling>customized reports>cost center reports

2) From the above ZSL2 / ZSL 3 report, in order to get the mapping of the allocation to material, go to Cost Center Report (program J1SIPAAX).

EXAMPLE :-

The following is the sample file extracted from Cost Center Actual Line Item Report for period 1 fiscal year 2007:-

From the above sample file, material 4900154401 (ZTFG) received 16.80 (0.2%) out of total 8,526.56. Hence, the following sender cost elements will be split as below:-

5014700 => 296.87 x 0.2% = 0.59

5014800 => 157.49 x 0.2% = 0.32

5015202 => 314.29 x 0.2% = 0.63

and so on

According to the mapping logic in page 6, since 5014700 and 5014800 is categorised as Depreciation = Fixed Expenses, the sum received will be 0.91 (0.59 + 0.32). Whereas, for 5015202, it will be categorised as Sundry Tools = Variable Expenses in the new customised report.

[Former Member]

You must have asked your team members instead of posting spec here

[Former Member]

ok... I will come back if i had any query...

There is nobody to help me out thats why...