Process: Product Costing

Responsibility area: Manage Activity Type Price




Scope

WW
Frequency

On demand
References


Attachments

Template ZWFA47A.xlsx

xx << I upload the activity type price >> xx



  Guideline  

I get informed that a new activity needs to be created via SYRA

In PF2


STEP 1

Enter transaction Z1K_ACTUAL in the transaction field of main menu.

Click on the line Z1K_ULKB21 and then in EXEC PROGRAM 







STEP 2

Enter a document date and define the following fields:

Test Run: X - test mod (the file is check but no Batch Input or Postings are generated) / (space) – Real mode.

File name: To enter the location (in order to search please execute to access the search screen).;

BTCI Name: Batch Input Name reference: ZBKB21_CCode;

Online: E - Direct Posting in SAP (allowing only the display of errors); / (space) –  Creates Batch-Input session

Controlling Area: CHEF;

Screen VARIANT: SAP09;

Press Execute  

Note

No document date/Posting Date is requested in the screen as the information is retrieved by the txt file contents (first column of the template).

Upload file

After execution a message box requiring the upload file will be displayed.




STEP 3

The program generates a batch input session for transaction  KB21N.

Go to transaction SM35;

Select the session and process it;

Note

In case of more complex files (containing more data and line to be processed) the system might generate more than one Batch Input session for the same upload

Document posted

In the BTCI session processed, it’s possible to find the document number of the posting done. Mark the line and see Log




STEP 4

Run transaction KB21N and enter the document number previously collected;

Note

You can also check CO objects receivers using report ZACT running transaction GR55.

 


STEP 1

 

Before starting the upload there are 2 important steps that must be done:

1) Choose the correct layout on transaction KP06:

  • Go to transaction KP06
  • Go to “Settings”
  • Choose “Set planner profile”
  • Select: SAP102 "Release 3.0/3.1 CO-OM: Acty Input/ATyp/StKF
  • Go back and leave the transaction KP06.

2) Assign the prices on transaction KP26:

  • Go to transaction KP26
  • Enter the Sender CC and the Activity Type:

 

  • Enter the price

 

 


STEP 2

Enter transaction Z1K_PLANNING in the transaction field of main menu. 

Then click on line Z1K_KP06_ACT and EXEC PROGRAM 



 

 

 


STEP 3

Click the first program CC or Order

After, you’ll get a screen, where you will have to choose the following options:

  • “BTCI Name”
  • “User”
  • “Keep” (for batch session caption in SM35);
  • “Test Run“
  • Year and periods
  • “Distribution Key = 1”

Press Execute  and define the path of the file.

 


STEP 4

After executing in test mode, go back and remove the flag from the “Test Mode”.

 

You’ll get an warning message, press “Continue” and then you’ll have the outcome of the upload.

 

Go to transaction SM35 and process the batch input (unflagging the option “Dynpro Standard Size”).

 

After running the batch input session, the system won’t give us any document number. In order to be sure that the upload was correctly done, go to transaction GR55 (report 1LLV) orS_ALR_87013630, choosing “Plan Version: 0” and the company code.

 

In WP2


STEP 1

I prepare the file to be uploaded with: 

  1. Controlling area
  2. Sender cost center
  3. Activity Type
  4. Receivers: it can be a WBS, a Cost center or an order
  5. Personnel number (not compulsory)
  6. Quantity
  7. Item text
  8. "X"

 

Delete columns headings & empty rows. 

 

Save the file as type : CSV (Comma delimited)

Click yes if you have a message : "do you want to keep the workbook in the format?"


STEP 2

Start the transaction ZWFA47A and enter: 

  1. The file in csv format
  2. Session that must be run with transaction SM35: ZWFAI + company + 3 characters

  3. Controlling area

  4. Version : 0

  5. Document Header Text: Sales force case number

  6. Posting Date & Document date : last day of the month

  7. Select "production" to work with pre-established rates or select "consumption" to work with actual rates.


Execute 

If you have a message "Do you want to grant access to this file?", click

Error messages must be solved before moving forward

For instance, if you have the message "Activity type xxx cannot be allocated from cost center xxxx-xxxx" it means that the budget was not entered with KP26. 

 


STEP 3

If no errors found, flag the options:

  • Create BTCI session
  • Send BI execution

Execute 

A batch input is generated and automatically processed. 

A message informs that the session was successfully processed

 

 


STEP 4

Go to SM35 to see documents posted 

 

 

You can display the document with the transaction KB23N and check that it corresponds to what was expected

And check the cost center with the transaction KSB1

I notify the requester