Transaction code to post sales data

[Former Member]

Hi,

What transaction is used to post data relating to business entities sales group and sales offices?

Thanks

[Former Member · Accepted solution]

HI Ellen,

Could you eloborate on the requirement

Regards

Srini

[Former Member · Accepted solution]

Hi All,

I am working on getting data filled for fields VKGRP and VKBUR for table VBAK. At this time, we do not have data for these fields in the table VBAK. I am thinking that somehow our setup is not displaying these two fields on the screen for data entry when using this specific transaction code to post sales data.

I would want to check what transaction code that would be to see the screen and verify if the fields for the sales group and sales offices are available for this transaction code. if not then we would have to some how change the setup to include these 2 fields for the screen and start entering these values to fill the tbale VBAK.

What would you recommend to get these 2 fields filled with data for sales group and sales offices? There are other sales tables that we use to get this information, and I suppose once the screen has these fields for data entry, then the rest of the other tables will be filled with these values.

Hope this make sense.

Thanks

[Former Member · Accepted solution]

Hi Ellen

I can suggest you one thing i.e., to find out different tables in which these fields exits

Go to Se15 - ABAp dictionary-fields-view fields-give field name and execute(F8)

system will display different tables which have data realted to VKGRP and VKBUR.

Select some table names in which you want to search data.

You can then go to SE16 and give this table name and execute, go to field selection and give your selection criteria and execute, system will display all the documents/data related to that particular table.

Hope this will help you in searching.Pl give feedback whether it worked out else put forth problems faced

REWARD IF IT HELPS

Regards

Srini

[Former Member · Accepted solution]

Hi All,

Thanks for your repsonses. I am actually a technical and not a functional person and aware of these methods of displaying the data from the tables, logical databases, etc.

I would think the problem is actually there was no master data for the sales groups and sales offices when the sales documents were posted.

Would you be able to tell me what are the transaction codes that you would normally use to post sales and billing documents, etc.? I think once I know these TCODES, I can actually get things going.

Thanks

Message was edited by:

Ellen DeGeneres

Message was edited by:

Ellen DeGeneres

[rmazzali · Accepted solution]

Hi Ellen,

maybe that you cannot see the fields because there is a transaction variant.

In the sales cycle sales office and sales group are taken from the sales order (VA01) or copied in the vbak table from tha customer master data (knvv table).

Then these fields are copied in the subsequent invoice document.

If the sales office and sales group fields are not visible in customer master, check if the customer account group allows these fields (tcode OVT0)

pls reward points if helpfull

Regards

Roberto

[Former Member]

HI;

I see 2 possibilites

1. The data is not present in the Customer Master, which in turn is not getting picked up in the SO. If this is the case then we need to correct the Cust. Master so that the data is picked up automatically in the subsequent orders.

2. The other thing I can think of is, it is just that you are not able to display the fields when you check VBAK tbl. If this is the case then after you execute SE16 with a SO#, under the "settings" tab, you will have a option for "Choose Fields", here the filed might not have been selected for display. Just select them and it should work.

Regards.

[Former Member]

Hi;

Can you please give more details on what information you are looking for.

Regards.