output type - Access sequence

[Former Member]

Hi,

I have created a output type for VF02 and my requirement is to restrict the output type to only certain company codes.

I have created a access sequence with table 502 and assigned this to the output type and also maintained the condition records.

But still I see that the output type is getting created for all company codes..Am i missing anything here.

Please let me know.

Regards

Praneeth

[jignesh_mehta3 · Accepted solution]

What are the Feilds you have taken in Table 502?

Is your Condition Record Company Code specific?

I believe Company Code is not available in Feild Catalogue for Output Condition Tables...

Thanks,

Jignesh Mehta

[Former Member · Accepted solution]

Hi,

That's right . The field is not available in the field catalogue and hence changed it back to Sales org / land and now it is working correctly.

By the way can we restrict a output type based on sales org on the output tab on the VF02. I mean if the user goes for an F4 on the output tab he should not have the option of running this output type. Can we do this in SAP.

Regards

Praneeth

[Former Member · Accepted solution]

hi , i dont think this is possible in standard SAP, normally you will assign an output type in the output determination procedure & this is inturn will be assigned to the document type, you cannot control this from coming in F4, but you can have a ABAP code & write a requirement and assign this requirement to the output type in the output determination procedure.

Thanks & regards

Ilango

[jignesh_mehta3 · Accepted solution]

Hello,

I believe you do not want the particular Output Type to be visible in VF02 - Header - Output - F4 list.

See, the F4 List is coming from the Output Procedure (Where the Output Types are listed sequentially). This Output Procedure is then assigned to Invoice Type. (IMG - Sales and Distribution - Basic Functions - Output Control - Output Determination - Output Determination Using the Condition Technique - Maintain Output Determination for Billing Documents - Maintain Output Determination Procedure & Assign Output Determination Procedures).

Now, for your requirment, you will have to create multiple Output Precedures & assigned the same to relevant Invoice Types. This will ensure that only the Output Types listed in particular Output Procedure are displayed in F4 List in Vf02.

This would be a time consuming process, but if your client demands, you will have to do it...

Hope this helps,

Thanks,

Jignesh Mehta

[Former Member · Accepted solution]

Hi,

I agree with the comments...

So I though why not restrict the output type from executing even if the user picks up the output type from the f4 list and used VOFM output control routines and created a new routine 900 and assigned to the output type and wrote the below logic ...

SY-SUBRC = 0.

IF KOMKBV3-VKORG NE '0076'.

SY-SUBRC = 4.

EXIT.

ENDIF.

but I see that still the output type is getting executed. Can you please let me know if I am missing anything and I have activated the routine using program RV80HGEN.

Regards

Praneeth

[jignesh_mehta3 · Accepted solution]

Hello,

Whatever you have done seems perfect.

Hope you have assigned the Routine in Requirement column in Output Procedure.

Regarding, why it is not working, you will have to work with ABAPer & debug the program execution to check the values passing.

Hope this helps,

Thanks,

JIgnesh Mehta

[Former Member]

Hi,

If company code field is not available in condition table then search in OV24 T code from their you can take, it is called allowed field catalog.

If that field is not available their also then check below document and ask your abaper to fallow this process below and add that field then you can see this field in OV24 and from that you can use this field to crate condition table

In SAP condition records store the pricing values. These records are stored in condition tables. Condition tables name has three digits. From 1 to 500 are reserved by SAP name space and from 501 to 999 are given to customer space. In the actual database a persistent data base table is created with u201CAu201D prefixed to the table number .i.e. condition table 980 creates a table with name A980.

During the condition table creation required fields can be selected. Only the fields present in the field catalogue are available for selection in the condition table. Fields present in the KOMG table can be added to the field catalogue. By default SAP does not add all the fields of KOMG to field catalogue. KOMG table is a union of KOMP, KOMK tables. KOMK table contains the header information of the document (Sales order or Billing), KOMP contains item level information of the document (Sales order / Billing). New fields can be added to the KOMP, KOMK structures. To add the new fields to these structures, an append structure should not be created. To add a field to KOMP structure, field should be added to KOMPAZ structure, which is an include in KOMP structure. Similarly fields should be added to KOMKAZ structure.

If it is required to create a condition table with a custom field the following steps should be followed.

A.Add the field in KOMKAZ or KOMPAZ structure. If the field is at the header level, add the field to KOMKAZ, and if the field is at the item level add to KOMPAZ structure. This step should be done SE11 transaction.

B.Activate the structure.

C.Add the new field to field catalog.

D.Create the condition table.

Adding the field to field catalog and condition table creation can be done VOK0 transaction.

At run time the custom field should be filled with the appropriate value. To to this the following user exits should be used.

USEREXIT_PRICING_PREPARE_TKOMK in RV60AFZZ .

USEREXIT_PRICING_PREPARE_TKOMP in RV60AFZZ.

Below is an example to add sales representative , who is a partner at item level to KOMP structure.

1. Go to Se11, and add the field WWSR1.

2. Open the program RV60AFZZ using SE38 transaction.

3. Add the field to field catalog. To do this go to VOK0 transaction. Then environment ? condition table ? field catalog.

4. Create the condition table. To do this goto VOK0 transaction. Goto environment-> condition table create. Enter the condition table number 980 .

Once the condition table is created, this table can be used in the access sequence. Access sequence is assigned to the condition type. Condition type is inserted in the required pricing procedure. Condition records can be created in VK11 transaction. All the condition records are created with reference to the condition type. As the condition type is linked to access sequence, and access sequence to condition table, system displays all the condition table assigned to access sequence , in the initial screen. User should select one table, and enter condition records.

for more detail check http://www.magnatraining.com/sap-sd-pricing-how-to-add-custom-fields-to-a-condition-table/

[Former Member]

Hi,

Your requirement is not possible with standerd functionality,go for a enhancement with the help of your ABAP consultant.

Thanks

Siva.k