Condition type in Sales Documents

[Former Member]

Hi All,

I would like to understand the sales documents that uses a specific condition type, it might be at header or at line item level too.

The volume of my data is really huge and i tried using KONV & KONP as an initial search and system goes for a time out error.

Do i have any other alternative to fetch the sales documents thats uses my specifc condition type.

Please help me out on this regard

Regards

Ilango

[tn_naveen · Accepted solution]

Hi,

Capture the Condition Type value into one of the subtotal fields - KZWI1 to KZWI6. These fields are available in VBAP.

You can then search VBAP for lines with entries only in that particular subtotal field you are using to capture the condition type.

You can also create an index on VBAP for this field to make it more effective. Hope that helps!

Regards,

Naveen

[Former Member]

Hi All,

Thanks for the information, as indicated earlier the option of using KONV & KONP is of no help as the volume of data is so heavy and more over i wish to obtain information on the historical record to understand the available sales documents.

The requirement here is to obtain the list of sales order that uses a specific condition type hence i am not able to key in the key fields of KONV & KONP and hence i have a performance issue along with the system going for time out error.

the outcome of VBAK is so heavy and it runs to millions of entries per year and i cannot load all these data at a single shot in KONV or KONP.

do i have any option of indexing table or any other means that can ease my search.

Thanks & Regards

ilango

Edited by: Ilango R V on Nov 30, 2009 6:46 AM

[Former Member]

Dear,

Try what i suggested it is very easy one.

kapil

[Former Member]

Hi,

Get the KNUMV value from the VBAK sales document Table and with KNUMV goto the Table KONV

And enter this KNUMV value and in KSCHL maintain the CONDITION TYPE as per your requirement ( for example PR00)

And execute, there you will get The documents which have this condition type

The KNUMV ( DOCUMENT CONDITION ) will be unique for all the orders

Please check it and revert back.

regards,

santosh

[Former Member]

Hi,

You can achieve it by creating pricing report,

T-code V/LA,V/LB,V/LC

in this you can select fields - sales document,sales document item,sales organization

then click on "OR" icon, then again u have to select table numbers, 350,089,090,099 which is for sales organization and sales document & it's items,

click on icon(Forward arrow) continue to list structure

In positioning coloum - select header level for sales document & sales organization,

for other keep at item level.

Save

Execute report by V/LD,

Select your report and speciefy your search criteria.

kapil

[pratik_mahendra]

Hello, Use table KONV. Primary key in this is 'Doc Cond.' this feild is unique. You should be able to get sales order through this if you link couple of tables to link 'Doc Cond..' to VBRK or VBRP.

[former_member315051]

Take the KNUMV feild number from VBAK and Pass into KONV , you can able to get the Sales order conditions with specific to Condition type.

Regards,

Ramesh