Sap Sale Module: Re: [sap-log-sd] Pricing description in a custom report

Posted by jim-wolfe
on Aug 4 at 12:00 PM

Pricing doesn't exist at the header level in konv because SAP always allocates any header conditions to a line item level. The pricing condition texts would have to come from T685T for any condition types. Otherwise, if you're trying to retrieve subtotal or total values, e.g. profit margin, you'll either need to capture them in a condition type that is tied to a formula, or assign one of the subtotal, e.g. kzwi*, fields to the subtotal line in the pricing procedure, then get the value off of vbrp, and read the text off of the pricing procedure text table T683T

---------------Original Message---------------
From: Pamela79 Pilch
Sent: Thursday, August 04, 2011 8:00 AM
Subject: Pricing description in a custom report

Hello,

We are developing a custom report. The report will fetch invoices from VBRK table for a a given date.

For the selected invoices, we need to pick pricing condition types as in invoices from table KONV ( VBRK-KNUMH=KONV-KNUMH ). In this way we have all the condition types for the invoices.... I have following questions :-

a) in the invoice pricing, I also need to have text elements and their values in our custom report. that is I need to fetch the word "gross price" and its value from line item pricing ( Both KWART and KWERT ).... I also need to have "profit margin" and its value ( both condition base and cond value ),

I also need to have any other description I have in invoice pricing and its value like "rebate basis" and its value etc...

What logic should I use to fetch the above description and their values ( both base value and final value as appearing in pricing screen of invoice line items ! )

b) KONV shows item wise records. Pricing is also stored at header level in invoices... which condition table is used to store header condition and the values ?

regards
Pamela

__.____._