SFIN Planning Query 9
SFIN Planning Query 9
SFIN Planning Query 9
Tasks
1. Log on to SAP BW and create a new query from an existing SFIN query.
2. Launch Query Designer (Business Explorer) and open your new query.
Step Action
(1) Open the folder Business Explorer by double-clicking it.
Step Action
(2) Open the folder Query by double-clicking it.
Transaction Copy
Step Action
(3) Execute the transaction Copy with a double-click.
Step Action
(4) Enter /ERP/SFIN_A51 in the Source InfoCube box.
Step Action
Step Action
(5) Enter U01_MP1AL in the Target InfoCube box.
(6) Click Execute .
Step Action
(7) Click the header of the row /ERP/SFIN_A51_IRQ001.
Step Action
(8) Click Transfer Selections.
Step Action
(9) Click Process Selected Objects.
Step Action
(10) Enter U01_MP1ALQ in the Technical Name of Copy box.
(11) Click Process Selected Objects.
Step Action
(12) Click Continue .
Step Action
(13) Click the entry Market Segment Planning on Periods.
(14) Click Open.
Step Action
Change the Description of the New Query.
Step Action
(15) Click .
Step Action
(16) Enter U01 Product plan and Actual Query in the Description box.
(17) Click Save .
Step Action
(18) Click Rows/Columns .
Step Action
(19) Right-click Material Group.
Step Action
(20) Click Remove .
Step Action
(21) Right-click Customer Group .
Step Action
(22) Click Remove .
Step Action
(23) Drag Profit Center.
(24) Drop on the G/L Accountdimension.
Step Action
(25) Drag U01 Virtual Material.
(26) Drop on the Rowsarea, in second position.
Step Action
Set all the row characteristics to display based on Master Data.
Step Action
(27) Click Profit Center.
Step Action
Click G/L Account.
(28)
Press Shift key while performing the action.
Step Action
(29) Click the Extended tab to select it.
Step Action
Set the row characteristics Profit Center and U01 Virtual Material to
display keys only.
Step Action
(30) Click Master Data.
Step Action
Click U01 Virtual Material.
(31)
Press Ctrl key while performing the action.
Step Action
(32) Click the Display tab.
Step Action
(33) Click Display As to open a drop-down list.
Step Action
(34) Select Key .
Step Action
(35) Click Save .
The key figures are restricted to the delivered InfoCubes. You need to
swap in your own InfoCubes.
Step Action
(36) Double-click Total Plan &/ERP/T_FISCYEAR01&.
Step Action
Remove the Financials Planning(/ERP/SFIN_R01) InfoCube from the
selected Key Figure, and replace them with the U01 Product Planning
RTC (U01_R01).
Step Action
(37) Double-click InfoProvider.
Step Action
(38) Click /ERP/SFIN_R01.
Step Action
(39) Click Remove from Selections.
Step Action
(40) Click U01 Product Planning RTC.
Step Action
(41) Click Add to Selections.
Step Action
(42) Click OK.
Step Action
(43) Click OK.
Step Action
(44) Click Save .
Step Action
Step Action
Repeat the same InfoProvider replacement for each of the periods 1 to
12.
Step Action
(45) Right-click Period 1.
Step Action
(46) Click Edit... .
Step Action
(47) Double-click InfoProvider.
Step Action
(48) Click /ERP/SFIN_R01.
Step Action
(49) Click Remove from Selections.
Step Action
(50) Click 'U01_R01'.
Step Action
(51) Click Add to Selections.
Step Action
(52) Click OK.
Step Action
(53) Click OK.
In the interest of time, the InfoProvider for the remaining periods will now
be modified for you.
Step Action
(54) Scroll up.
Step Action
The InfoProvider settings for Plan Data are now changed.
Make the same change to the InfoProvider settings for the Actuals.
Step Action
(55) Click Total Actual &/ERP/T_FISCYEAR01&.
Step Action
(56) Click the Display tab.
Step Action
Step Action
(57) Click the Status of Node arrow to open a drop-down list.
Step Action
(58) Select Collapsed.
Step Action
(59) Double-click Total Actual &/ERP/T_FISCYEAR01&.
Step Action
(60) Double-click InfoProvider.
Step Action
(61) Click /ERP/SFIN_V01.
Step Action
(62) Click Remove from Selections.
Step Action
(63) Click the Show arrow to open a drop-down list.
Step Action
(64) Select Single Values.
Step Action
(65) Select U01 Actuals via HANA.
Step Action
(66) Click Add to Selections.
Step Action
(67) Click OK.
Step Action
(68) Click OK.
Step Action
(69) Click Save .
Step Action
Step Action
Repeat the same InfoProvider replacement for each of the periods 1 to
12.
Step Action
(70) Right-click Period 1.
Step Action
(71) Click Edit... .
Step Action
(72) Double-click InfoProvider.
Step Action
(73) Click /ERP/SFIN_V01.
Step Action
(74) Click Remove from Selections.
Step Action
(75) Click 'U01_V01'.
Step Action
(76) Click Add to Selections.
Step Action
(77) Click OK.
Step Action
(78) Click OK.
In the interest of time, the InfoProvider for the remaining periods will now
be modified for you.
Step Action
The InfoProvider settings for Actual Data are now changed.
Step Action
(79) Click Save .
Step Action
(80) Click Filter .
Step Action
Add the Profit Center dimension to the Characteristic Restrictions and
restrict it to IBPF_PC01.
(81) Click Profit Center.
Step Action
(82) Drag Profit Center.
(83) Drop on the Characteristic Restrictionsarea.
Step Action
(84) Double-click Profit Center.
Step Action
(85) Enter IBPF_PC01 in the Direct Input box.
Step Action
(86) Click Add to Selections .
Step Action
(87) Click OK.
Step Action
Add your provisional characteristic U01 Virtual Material to the
Characteristic Restrictions and filter it to the following values:
T-ATV25
T-ATV26
T-ATV27
T-ATV28
T-ATV29
T-ATV30
T-ATVHS
T-ATVMFCN
Step Action
(88) Click U01 Virtual Material.
Step Action
(89) Drag U01 Virtual Materia.
(90) Drop on the Characteristic Restrictionsarea.
Step Action
(91) Double-click U01 Virtual Material.
Step Action
(92) Click Display .
Step Action
(93) Select [Key].
Step Action
(94) Scroll down.
Step Action
(95) Click [T-ATV25].
Step Action
Click [T-ATVMFCN].
(96)
Press Shift key while performing the action.
Step Action
(97) Click Add to Selections .
Step Action
(98) Click OK.
Step Action
(99) Click Save .
Step Action
(100) Double-click G/L Account.
Step Action
(101) Click GL Account / GL Account Group ( Gl Account Hierarchy ) .
Step Action
(102) Click Remove from Selections.
Step Action
Restrict the G/L Account dimension to the following values:
802000
400000
420000
421000
422100
452000
470000
476900
Step Action
(103) Enter 802000 in the Direct Input box.
Step Action
(104) Click Add to Selections .
Step Action
(105) Enter 400000 in the Direct Input box.
Step Action
(106) Click Add to Selections .
In the interest of time, the remaining G/L accounts will now be aded to the
Selections for you.
Step Action
(107) Click OK.
Step Action
(108) Click Save .