multiple condition type

[Former Member]

we have two condition types Z001 and Z002 map to marketing expense, Z001 plus/minus field is blank, Z002 plus/minus sign field is X(which means negative).

My requirement is in Period 2, 2013, what are the billing document using Z001, any report or table to use?

if we change plus/minus field of Z002 to be blank(which means both positive and negative), the during sales order creation or billing document creation, the condition value of Z002 is positive or negative?

[Former Member]

Hi.

1. My requirement is in Period 2, 2013, what are the billing document using Z001, any report or table to use?
 

Ans - You can look up table VBRK for required period (VBRK-FKDAT) and get Billing document numbers (VBRK-VBELN) with all its Doc. condition (VBRK-KNUMV). Then go to table KONP with KNUMV and get all the records where condition type(KSCHL) = Z001 and it is active (KONV-KINAK = blank)

2. if we change plus/minus field of Z002 to be blank(which means both positive and negative), the during sales order creation or billing document creation, the condition value of Z002 is positive or negative?
774424
 

Ans - Refer SAP note 774424.

Thanks

Atul

[Former Member]

Hi,

condition type plus/minus

Blank (positive/negative):-  during sales order creation what ever value entered in condition it show default positive value, if you want enter negative value use "-" negative symbol to enter negative value.

whatever value(+/-) you enter in condition type it will flow with same value till billing.

period and with condition type  wise there is no report available  you need to develop new Z report with below logic

1 . transfer billing date (FKDAT), billing type (FKART) , billing        document no. if available (VBELN) in VBRK table

2 . read all VBRK-KNUMV (Document condition)

3. transfer this to KONV-KNUMV with this enter required condition type in KONV-KSCHL

4. execute and read/display (condition value)  KONV-KWERT

Regards,

Mahesh Fulse

[former_member662097]

Hi Jolin,

Billing Tables are: VBRK and VBRP for Header data and Item data respectively.

Sales Order Table are: VBAK, VBAP, VBEP for Header data, Item data and Schedule Line Data respectively. There is no standard report available as Santosh already say.

If the condition amount can be either positive or negative for Z002, leave the field blank. Otherwise, enter one of the indicators that specify plus or minus.

Regards,

Shatrughan Singh

[Former Member]

if I changed VPRS plus/minus field from blank to X(negative), what will be the impact?

[former_member662097]

Please check http://scn.sap.com/thread/3395466

Regards,

Shatrughan Singh

[moazzam_ali]

Hi

For your first requirement please use logical data base VFV and create your own report because there is no standard report.

For your 2nd requirement its better that you test this on your own and then ask any question. Your question can be answered by yourself by just testing it.

Thank$

[Former Member]

This message was moderated.

[former_member186385]

Hi ,

My requirement is in Period 2, 2013, what are the billing document using Z001, any report or table to use?

there is no standard report for this

you have to get all the Billing documents created for period 2 using VBRK

get the document number, KNUMV for all the Billing documents and from KONV using KNUMV get the list of documents which has Z001, you can filter the documents using Z001 condition type

if we change plus/minus field of Z002 to be blank(which means both positive and negative), the during sales order creation or billing document creation, the condition value of Z002 is positive or negative?

If you set Blank value at condition type, it will not be calculated with any other condition base. It will be just remain as base condition and can be taken as bas for calculating discount or surcharge

regards,

santosh