Z tcode for VK12.

[Former Member]

Hi all,

Following is my requirement.

1.Create Copy of VK12

2. User wil enter condition type, Sales order no, Distribution channel no, Price gropu and rest thing.

3. Same output of vk12 should come.

4. Along with the list output , there should be UPLOAD and DOWNLOAD buttons on screen.

5. When Clicked on DOWNLOAD - that outpit list should get download to XLS or txt file.

6. User can change certain values in that file and Use UPLOAD button to upload the file using same transaction.

7. After this the list should come on the screen and the changed values should be updated to the related tables.

So my question is...

1. What is the best procedure to do this ?

2. Is there any Enhancement that i can used to do the same in VK12 , instead of creating zVK12.?

3. If no enhancement present what is going to be the steps for me..?

Please help..

Its urgent..

Points wil be rewarded.

Thanks in advance,

Amruta.

[Former Member]

i is best to create a z....

and u can bring there requ...................

Regards

Anbu

[Former Member]

Hi Amrutha,

Do you want to copy the standard t.code VK12?

If yes then its a big development as u want to copy all the objects related to that t.code.

Moreover why you want to copy the standard t.code.

Can you explain in brief about the functional requirement?

[Former Member]

Hi,

This is my fs..

3.2.3 Overview of Business requirement

Create a custom tcode to be used to maintain pricing condition records. This will be similar in structure and functionality to VK12 with the added functionality of list download/upload to/from text and XLS file types. Like VK11/VK12 the user will enter a condition type, select the key combination, and the resulting screen will format according to the table structure selected.

3.3.2 Enhancements

Copy VK12 and modify to allow upload for each condition type + key combination. Once the user have selected the condition type and key combination to determine the condition table the execution button will produce a screen similar to SAPMV13A with additional functional buttons to allow the user to download the list into an external xls or txt file. This file can then be manipulated and then uploaded using the same transaction. Upon upload the system will update the condition table using standard processing and a result log will be generated to show any errors that may have occurred. Each error condition will need to be defined in the DEV spec and a functional job aid will be written to tell the user how to remediate every error scenario.

3.3.2.1 SAP Transaction(s)

VK12 Copy

3.3.2.2 Input Data / Output Data

Input

Condition type u2013 KSCHA

Condition Key combination

This will determine the condition table (based on sequence) to be updated. Each condition table will have its own required fields.

Output

Processing log generated. This log will contain both header and item level errors.

3.3.2.3 Business Logic

Once the user has selected the condition type and key combination to determine the condition table the execution button will produce a screen similar to SAPMV13A with additional functional buttons to allow the user to download the list into an external xls or txt file. This file can then be manipulated and then uploaded using the same transaction. Upon upload the system will update the condition table using standard processing and a result log will be generated to show any errors that may have occurred. Each error condition will need to be defined in the DEV spec and a functional job aid will be written to tell the user how to remediate every error scenario.

[Former Member]

Hi,

The only option is you need to copy the system program of VK12 Into ZPROGRAM.

Then make the changes as per your reqirement.

Regards

Kiran Sure

[Former Member]

are there any BADI's for the same..?

If yes wil it help.?

[Former Member]

Hi,

BADI'S are available, but i feel it will not work in your case.

try the BADI SD_COND_SAVE_A.

Regards

Kiran Sure